Home » RDBMS Server » Server Administration » ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [message #250492] Tue, 10 July 2007 04:34 Go to next message
deepak samal
Messages: 29
Registered: February 2005
Junior Member
HI,

I installed the oracle 10g server. onlt the basic instalation.

1. created the ORACLE_SID , window service.
2. reated instance and databse manually.
3. reated all the table space, users , objects manully.
4. ow i run some insert stsatements.

all this is working fine from the server machine or if i am connecting thru any client to this server. Everything works proper.

The problem comes when i restart the services . now i am not able to connect to oracle any more . when i am logging in to the oracle by username/password@tnsname this is giving error as:

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor .

i am also not able to login as sys as sysdba.

How could i resolve the problem.Please help me out.


thanks
deepak

Re: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor [message #250601 is a reply to message #250492] Tue, 10 July 2007 10:51 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
The problem comes when i restart the services .

Which Services?

Quote:
when i am logging in to the oracle by username/password@tnsname this is giving error as:


Lsnrctl status?

Quote:
i am also not able to login as sys as sysdba.

when you try as sys what error it thorws?
Previous Topic: Statpack Error
Next Topic: Dynamic Memory Allocation Question
Goto Forum:
  


Current Time: Fri Dec 09 11:27:44 CST 2016

Total time taken to generate the page: 0.05319 seconds