Ora-12514 [message #501288] |
Mon, 28 March 2011 07:17 |
SAKOURA
Messages: 52 Registered: June 2010 Location: France
|
Member |
|
|
Hello,
My client get the error Ora-12514 when he tries to connect to the db.
Well;
1) we restart the services: "OracleServiceOrcl" and listener but nothing changes
2) We restart the server and nothing changes
3) We checked the dump and he was done on March,26th. No db export yesterday. Is there any link with the clock change of this week-end (location of the server: France)?
4) The lsnrctl services listener command run successfully but it doesn't mention the instance ORCL.
Someone has any idea?
Thx in advance.
Regards,
Sak.
|
|
|
|
|
|
|
|
Re: Ora-12514 [message #501316 is a reply to message #501314] |
Mon, 28 March 2011 09:19 |
SAKOURA
Messages: 52 Registered: June 2010 Location: France
|
Member |
|
|
I tried:
1) connect sys/psw as sysdba. the result: "Connected to an idle instance".
2) Restarting the services: orcl and listner but nothing changes.
I don't know what to try else!
Thx in advance.
Sak.
|
|
|
|
Re: Ora-12514 [message #501321 is a reply to message #501315] |
Mon, 28 March 2011 09:29 |
SAKOURA
Messages: 52 Registered: June 2010 Location: France
|
Member |
|
|
BlackSwan,
I tried both : db before listner, listener before db. same result: ora-12514. They are running both.
|
|
|
|
|
|
Re: Ora-12514 [message #501331 is a reply to message #501325] |
Mon, 28 March 2011 10:32 |
|
Michel Cadot
Messages: 68729 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Copy and paste the result of commands inside the post in text format.
Many of us can't or don't want to download files.
Did you check the following?
Quote: - Check which services are currently known by the listener by executing:
lsnrctl services <listener name>
- Check that the SERVICE_NAME parameter in the connect descriptor of the
net service name used specifies a service known by the listener.
Quote:connect sys/psw as sysdba. the result: "Connected to an idle instance".
This proves the database is not running, so the error is expected.
Regards
Michel
|
|
|