Home » RDBMS Server » Networking and Gateways » ORA 12514 (DB 9i,Windows2000)
ORA 12514 [message #506312] Sun, 08 May 2011 01:37 Go to next message
Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt
Member

I have an error ora-12514 while trying to connect using Oracle form builder or any third party software
I tried to modify some DB parameter like max_parallel_server
and processes but it is not working
also,I restarted the server after that the error disappeared for only one day
plz,help me in this issue as soon as possible
Thank u in advance
Re: ORA 12514 [message #506317 is a reply to message #506312] Sun, 08 May 2011 02:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
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.


Quote:
I tried to modify some DB parameter like max_parallel_server

Why? What is the rationale behind this? Or did you try to randomly change parameters till you find one that will "fix" the error?

Regards
Michel
Re: ORA 12514 [message #506381 is a reply to message #506317] Mon, 09 May 2011 01:17 Go to previous messageGo to next message
Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt
Member

thank u so much Michel for your co-operation
But i tried all that before but the same prob.
Really,I read this modification suggested from an expert as a solution
he assumed that thee problem is with the resources or something like that so he recommended to modify this parameter and
Processes parameter also
thank u in advance,
Sami
Re: ORA 12514 [message #506383 is a reply to message #506381] Mon, 09 May 2011 01:23 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
ORA-12514: TNS:listener


Quote:
modification suggested from an expert as a solution


If he really suggested that by seeing the above then I wont consider him as an expert

Sriram
Re: ORA 12514 [message #506384 is a reply to message #506383] Mon, 09 May 2011 01:27 Go to previous messageGo to next message
Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt
Member

thank u Sriram for your added value info
Re: ORA 12514 [message #506501 is a reply to message #506384] Mon, 09 May 2011 08:51 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Since Networking is involved, the basic assumption is that two distinct systems are involved.

For System1 post hostname, IP#, Operating System name & version & Oracle s/w version to 4 decimal places.
For System2 post hostname, IP#, Operating System name & version & Oracle s/w version to 4 decimal places.
Clarify which hostname is associated with DB Server system & which hostname with SQL Client.

From DB Server post content of listener.ora & sqlnet.ora (if either exist)
From DB Server post results from following commands
lsnrtcl status
lsnrctl service
sqlplus scott/tiger

From SQL Client post content of tnsnames.ora & sqlnet.ora (if either exist)
From SQL Client post results from following commands
tnsping <valid_alias>
ping <DBhostname>
sqlplus scott/tiger@<valid_alias>

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
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 please post it & surrounding lines.

[Updated on: Mon, 09 May 2011 08:57]

Report message to a moderator

Re: ORA 12514 [message #506962 is a reply to message #506501] Thu, 12 May 2011 01:06 Go to previous messageGo to next message
Sami_Younis
Messages: 49
Registered: February 2008
Location: Egypt
Member

I have solved the issue
Thank u all
Re: ORA 12514 [message #506964 is a reply to message #506962] Thu, 12 May 2011 01:20 Go to previous message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
How? What was the problem?

Regards
Michel
Previous Topic: ORA-12541: TNS:no listener but instance showing in lsnrctl satus
Next Topic: ora-12514
Goto Forum:
  


Current Time: Wed Dec 11 15:26:35 CST 2024