Home » RDBMS Server » Networking and Gateways » ora 12514 not found. (Merge By ROD) (6i forms)
ora 12514 not found. (Merge By ROD) [message #519598] Mon, 15 August 2011 08:17 Go to next message
saqib4882
Messages: 22
Registered: August 2011
Location: Hassan Abdal
Junior Member

hi

My form is not working and the message is

ora 12514 message 12514 not found.


please help me

[Updated on: Tue, 16 August 2011 00:10] by Moderator

Report message to a moderator

Re: ora 12514 not found. [message #519603 is a reply to message #519598] Mon, 15 August 2011 08:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
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 not found. [message #519607 is a reply to message #519603] Mon, 15 August 2011 09:13 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
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 post this line & surrounding lines.
Previous Topic: Remote db connection with gateway
Next Topic: TNS-12542, Address Already In Used
Goto Forum:
  


Current Time: Thu Mar 28 06:39:13 CDT 2024