Home » Developer & Programmer » Forms » ora-12514 TNS:listener does not currently know of service (Oracle 10g , Windows XP SP2)
ora-12514 TNS:listener does not currently know of service [message #607271] Tue, 04 February 2014 07:48 Go to next message
jgjeetu
Messages: 227
Registered: July 2013
Location: India Hindustan
Senior Member
Please help me out , how to handle this , its urgent Sad
I am using Oracle 10g on Windows xp sp2 inside vmware player.

./fa/11662/0/
  • Attachment: Untitled.jpg
    (Size: 89.31KB, Downloaded 351 times)
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 Go to previous messageGo to next message
mughals_king
Messages: 351
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 #607274 is a reply to message #607273] Tue, 04 February 2014 08:18 Go to previous messageGo to next message
jgjeetu
Messages: 227
Registered: July 2013
Location: India Hindustan
Senior Member
thanks bro but where to put these codings/ where is listener.ora file? and what is HOST , is it ORCL ?

[Updated on: Tue, 04 February 2014 08:19]

Report message to a moderator

Re: ora-12514 TNS:listener does not currently know of service [message #607275 is a reply to message #607274] Tue, 04 February 2014 08:22 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
Dear listener is resides

C:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN

open in notepad

listener.ora

make it change

Re: ora-12514 TNS:listener does not currently know of service [message #607277 is a reply to message #607275] Tue, 04 February 2014 08:23 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
but must restart you listener again as i told in above post

LSNRCTL>START[listener_name]

check in screen shot how to start listener.ora and same to stop


[Updated on: Tue, 04 February 2014 08:29]

Report message to a moderator

Re: ora-12514 TNS:listener does not currently know of service [message #607282 is a reply to message #607275] Tue, 04 February 2014 08:38 Go to previous messageGo to next message
jgjeetu
Messages: 227
Registered: July 2013
Location: India Hindustan
Senior Member
where is screenshot ? still facing the problem bro , please check your message box

[Updated on: Tue, 04 February 2014 08:44]

Report message to a moderator

Re: ora-12514 TNS:listener does not currently know of service [message #607283 is a reply to message #607282] Tue, 04 February 2014 08:51 Go to previous messageGo to next message
mughals_king
Messages: 351
Registered: January 2012
Location: pakistan
Senior Member
No dear follow above solution that is 100% b'coz i handled this many time ago.

Regard
Mughal



[Updated on: Tue, 04 February 2014 09:00]

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 Go to previous messageGo to next message
BlackSwan
Messages: 22718
Registered: January 2009
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

Re: ora-12514 TNS:listener does not currently know of service [message #607289 is a reply to message #607284] Tue, 04 February 2014 10:21 Go to previous message
jgjeetu
Messages: 227
Registered: July 2013
Location: India Hindustan
Senior Member
thanks mughal bro Laughing 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 . Cool
thanks a lot Smile
thanks blackswan too .
Previous Topic: after clear the filed , goes at the first column
Next Topic: How to Open HTML file in same form with current items
Goto Forum:
  


Current Time: Fri Aug 29 15:59:11 CDT 2014

Total time taken to generate the page: 0.19417 seconds