Home » RDBMS Server » Networking and Gateways » Ora-12514 (Oracle 10.2.0.1 Windows 2008 x64)
Ora-12514 [message #501288] Mon, 28 March 2011 07:17 Go to next message
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 #501292 is a reply to message #501288] Mon, 28 March 2011 07:30 Go to previous messageGo to next message
Michel Cadot
Messages: 67484
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
 *Cause:  The listener received a request to establish a connection to a
 database or other service. The connect descriptor received by the listener
 specified a service name for a service (usually a database service)
 that either has not yet dynamically registered with the listener or has
 not been statically configured for the listener.  This may be a temporary
 condition such as after the listener has started, but before the database
 instance has registered with the listener.
 *Action:
  - Wait a moment and try to connect a second time.
  - 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.
  - If an easy connect naming connect identifier was used, check that
    the service name specified is a service known by the listener.
  - Check for an event in the listener.log file.

Regards
Michel
Re: Ora-12514 [message #501305 is a reply to message #501292] Mon, 28 March 2011 08:37 Go to previous messageGo to next message
BlackSwan
Messages: 26752
Registered: January 2009
Location: SoCal
Senior Member
>4) The lsnrctl services listener command run successfully but it doesn't mention the instance ORCL.

what does
lsnrctl services
exactly show (use COPY & PASTE?
is ORCL instance up & running?
Re: Ora-12514 [message #501313 is a reply to message #501305] Mon, 28 March 2011 09:09 Go to previous messageGo to next message
SAKOURA
Messages: 52
Registered: June 2010
Location: France
Member
The result is attached !
Thx in advance.
  • Attachment: em 15.gif
    (Size: 24.47KB, Downloaded 515 times)
Re: Ora-12514 [message #501314 is a reply to message #501313] Mon, 28 March 2011 09:15 Go to previous messageGo to next message
SAKOURA
Messages: 52
Registered: June 2010
Location: France
Member
Hi Michel,
As attached file a part of the listner.log.
Thx in advance.
Sak.
  • Attachment: em 16.gif
    (Size: 61.60KB, Downloaded 400 times)
Re: Ora-12514 [message #501315 is a reply to message #501313] Mon, 28 March 2011 09:16 Go to previous messageGo to next message
BlackSwan
Messages: 26752
Registered: January 2009
Location: SoCal
Senior Member
start the DB then the listener.

are both OS Services for DB & listener running now?
Re: Ora-12514 [message #501316 is a reply to message #501314] Mon, 28 March 2011 09:19 Go to previous messageGo to next message
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 #501318 is a reply to message #501316] Mon, 28 March 2011 09:23 Go to previous messageGo to next message
BlackSwan
Messages: 26752
Registered: January 2009
Location: SoCal
Senior Member
lsnrctl start
sqlplus
/ as sysdba
start
exit

COPY commands above & results, then PASTE all back here

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Ora-12514 [message #501321 is a reply to message #501315] Mon, 28 March 2011 09:29 Go to previous messageGo to next message
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 #501322 is a reply to message #501321] Mon, 28 March 2011 09:31 Go to previous messageGo to next message
BlackSwan
Messages: 26752
Registered: January 2009
Location: SoCal
Senior Member
since you choose to ignore Posting Guidelines & choose NOT do as requested,
I choose to stop wasting my time with additional response.
You're On Your Own (YOYO)!
Enjoy your mystery
Re: Ora-12514 [message #501323 is a reply to message #501318] Mon, 28 March 2011 09:39 Go to previous messageGo to next message
SAKOURA
Messages: 52
Registered: June 2010
Location: France
Member
The result is as attached file. Excuse me but i cannot copy and paste it.
Thx for your understanding.
Sak.
  • Attachment: em 20.GIF
    (Size: 7.48KB, Downloaded 436 times)
Re: Ora-12514 [message #501325 is a reply to message #501323] Mon, 28 March 2011 09:40 Go to previous messageGo to next message
SAKOURA
Messages: 52
Registered: June 2010
Location: France
Member
BlackSwan,
What do you mean by "Posting Guidelines & choose NOT do as requested"?
Thx.
Sak.
Re: Ora-12514 [message #501331 is a reply to message #501325] Mon, 28 March 2011 10:32 Go to previous message
Michel Cadot
Messages: 67484
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Listener password
Next Topic: Database gateways vs Transparent gateways
Goto Forum:
  


Current Time: Thu Oct 29 06:38:18 CDT 2020