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))
)
