471,316 Members | 1,056 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,316 software developers and data experts.

ORA-12224: TNS:no listener

2
When i am trying to connect to oracle it is giving me these two errors

ORA-12224: TNS:no listener

ORA-01034: ORACLE not available
I am new to oracle ,plz help
I am using solaris 5.6 and oracle 8.0.5 version

I am posting my listener.ora and Tnsname

Listener.ora:

LISTENER=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=IPC)
(KEY=uplinkdb)
)
(ADDRESS=
(PROTOCOL = TCP)
(HOST = 10.2.0.49)
(PORT = 1200)
)
)
LISTENER1=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=IPC)
(KEY=AIRTEL)
)
(ADDRESS=
(PROTOCOL = TCP)
(HOST = 10.2.0.49)
(PORT = 1201)
)
)
LISTENER2=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=IPC)
(KEY=onspire)
)
(ADDRESS=
(PROTOCOL = TCP)
(HOST = 10.2.0.49)
(PORT = 1551)
)
)

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=uplinkdb)
(ORACLE_HOME=/usr/up/oracle)
)
)
SID_LIST_LISTENER1=
(SID_LIST=
(SID_DESC=
(SID_NAME=AIRTEL)
(ORACLE_HOME=/usr/up/oracle)
)
)
SID_LIST_LISTENER2=
(SID_LIST=
(SID_DESC=
(SID_NAME=onspire)
(ORACLE_HOME=/usr/up/oracle)
)
)
TRACE_LEVEL_LISTENER = OFF



Tnsname.ora :

uplinkdb=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.2.0.49)
(PORT=1200))
(CONNECT_DATA=(SID=uplinkdb)))
AIRTEL=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.2.0.49)
(PORT=1201))
(CONNECT_DATA=(SID=AIRTEL)))
onspire=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.2.0.49)
(PORT=1551))
(CONNECT_DATA=(SID=onspire)))

airteldb=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.2.0.49)
(PORT=1201))
(CONNECT_DATA=(SID=airteldb)))
orcl=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.2.0.49)
(PORT=1521))
(CONNECT_DATA=(SID=orcl)))
AJAY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 100.1.200.10)(PORT = 1521))
)
(CONNECT_DATA = (SERVICE_NAME = DP51.WORLD))
)
Aug 7 '07 #1
5 16543
debasisdas
8,127 Expert 4TB
check for the services of oracle database and the oracle listener.

ensure that both the services are in auto mode and runing.
Aug 7 '07 #2
Nitvar
2
check for the services of oracle database and the oracle listener.

ensure that both the services are in auto mode and runing.

please tell how to check for the services of oracle database and the oracle listener in oracle 8.0.5 in solarix operating system
Aug 8 '07 #3
debasisdas
8,127 Expert 4TB
you can find some details here and here.
Aug 9 '07 #4
debasisdas
8,127 Expert 4TB
Run the command

lsnrctl status

to check the status of the listener ( if it is started or not)

and the command

lsnrctl start

to start it
Aug 9 '07 #5
Modify and test the database.... so that your oracle database is successful in connection.. if test is sucessful then there would be some problem in the tnsname..

in command promt just ping the tnsname
Aug 10 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Adam Ruth | last post: by
2 posts views Thread by J.Bijleveld | last post: by
reply views Thread by Zahi Savion | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.