|
|
| Re: ora-12514 TNS:listener does not currently know of service [message #607273 is a reply to message #607271] |
Tue, 04 February 2014 08:14   |
 |
mughals_king
Messages: 392
Registered: January 2012
Location: pakistan
|
Senior Member |
|
|
Hi dear its been a long time anywayz
Replace your listener.ora file with the code below then restart the listner and post the results of make sue the paths & Host=Mughal changed these into according to your req.
lsnrctl status
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = TEST)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
)
(SID_DESC =
(SID_NAME = ORACLE10)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = mughal)(PORT = 1522))
)
)
How to start & stop listener.
LSNRCTL>START[listener_name]
LSNRCTL>STOP[listener_name]
Regard
Mughal
[Updated on: Tue, 04 February 2014 08:15] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ora-12514 TNS:listener does not currently know of service [message #607284 is a reply to message #607283] |
Tue, 04 February 2014 08:59 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
ORA-12514 ALWAYS only occurs due to a problem on DB Server system.
One cause of this problem is when the Oracle database is down & needs to be started.
A remote client send a request to the Listener asking to be connected to a specific service.
If/when the listener does not know anything about that service, the listener responds with ORA-12514
post results from the following two OS commands:
lsnrctl status
lsnrctl service
Since every connection request to the listener gets logged, listener.log file will contain a line with 12514 as status code.
*This line contains valuable debugging details. So post this line & surrounding lines.*
for additional debugging suggestions read the URL below:
http://edstevensdba.wordpress.com/2011/03/19/ora-12514/
[Updated on: Tue, 04 February 2014 09:14] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
now everything is working fine, followed your steps till then it was not working then i shutdown my laptop , now when i came n started my laptop it is working fine . 
