Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ERROR - ORA-12514: TNS:listener does not currently know of service requeste

user513296Jun 20 2009 — edited Jul 28 2009
I am new bie to oracle 10 under Solaris 10. please specify how to solve :
ERROR - ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.

There is my /oracle/product/102/network/admin/listener.ora file :

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/product/102)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = inhome)(PORT = 1521))
)
)


output of : lsnrctl services
------------------------

oracle @ inhome /oracle/product/102/bin>./lsnrctl services
LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 20-JUN-2009 16:19:59

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Solaris Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=inhome)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully

output of : tnsping ORA10GR2
------------------------
oracle @ inhome /oracle/product/102/bin>./tnsping ORA10GR2

TNS Ping Utility for Solaris: Version 10.2.0.2.0 - Production on 20-JUN-2009 16:21:17

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

Used parameter files:
/oracle/product/102/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = inhome)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORA10GR2)))
OK (10 msec)
oracle @ inhome /oracle/product/102/bin>
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2009
Added on Jun 20 2009
13 comments
3,910 views