ORA 12514 [message #506312] |
Sun, 08 May 2011 01:37 |
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 #506501 is a reply to message #506384] |
Mon, 09 May 2011 08:51 |
|
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
|
|
|
|
|