By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,024 Members | 2,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,024 IT Pros & Developers. It's quick & easy.

ORA-12224: TNS:no listener

P: 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
Share this Question
Share on Google+
5 Replies


debasisdas
Expert 5K+
P: 8,127
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

P: 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
Expert 5K+
P: 8,127
you can find some details here and here.
Aug 9 '07 #4

debasisdas
Expert 5K+
P: 8,127
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

P: 9
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.