Home » Infrastructure » Linux » erros when i connect to my database (erros when i connect to my database)
erros when i connect to my database [message #336583] Mon, 28 July 2008 05:10 Go to next message
alwosaby
Messages: 26
Registered: November 2007
Junior Member
I install oracle10g on Unbreakable oracle RHEL5.2.
after that I type some comands to make testing for my database by tnslsnr or tnsping or lsnctrl
the document contains all errors


[oracle@sameer ~]$ lsnrctl

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 26-JUL-2008 23:33:20

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start

Starting /u01/app/oracle/product/oracle10g/bin/tnslsnr: please wait...


TNS-12537: TNS:connection closed

TNS-12560: TNS:protocol adapter error

TNS-00507: Connection closed

Linux Error: 29: Illegal seek

L
SNRCTL> status

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error

TNS-00511: No listener
Linux Error: 111: Connection refused


LSNRCTL> help

The following operations are available
An asterisk (*) denotes a modifier or extended command:

start stop status
services version reload
save_config trace spawn
change_password quit exit
set* show*

LSNRCTL> services

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

Linux Error: 111: Connection refused


LSNRCTL> quit
[oracle@sameer ~]$ sqlplus


SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jul 26 23:34:45 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter user-name: system

Enter password:


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> quit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

[oracle@sameer ~]$ tnsping mydb


TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 26-JUL-2008 23:36:02

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
/u01/app/oracle/product/oracle10g/network/admin/sqlnet.ora



TNS-03505: Failed to resolve name

[oracle@sameer ~]$ tnslsnr

Unable to resolve address for localhost:6113
ONS runtime exiting


[oracle@sameer ~]$






Re: erros when i connect to my database [message #336645 is a reply to message #336583] Mon, 28 July 2008 08:59 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>(HOST=)
HOST string should not be NULL/EMPTY.
I suspect you have OS configuration issue.
Re: erros when i connect to my database [message #336655 is a reply to message #336645] Mon, 28 July 2008 09:43 Go to previous messageGo to next message
alwosaby
Messages: 26
Registered: November 2007
Junior Member
Thanks

I type both from
127.0.1.1 and my name for computer
(host=127.0.0.1)
(host=pc1)

Re: erros when i connect to my database [message #336715 is a reply to message #336645] Mon, 28 July 2008 14:59 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello

Quote:
[oracle@sameer ~]$ tnsping mydb


TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 26-JUL-2008 23:36:02

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
/u01/app/oracle/product/oracle10g/network/admin/sqlnet.ora


Please post your tnsnames.ora and listner.ora info.

PS: Don't post your IP info. here.

Babu
Re: erros when i connect to my database [message #490421 is a reply to message #336715] Mon, 24 January 2011 18:46 Go to previous message
mcharya
Messages: 1
Registered: December 2010
Location: UK
Junior Member
Though the post is old ....
Someone might hit this page..

The solution for this is to include following lines in /etc/hosts

127.0.0.1 localhost loopback

Previous Topic: Install Oracle 10g on Centos 5 - cannot stat ntcontab.o
Next Topic: Linux file system with column to show file encodings?
Goto Forum:
  


Current Time: Thu Mar 28 10:18:22 CDT 2024