Home » RDBMS Server » Networking and Gateways » ORA-12514: TNS:listener does not currently know of service requested in connect (oracle 10g,RHEL 5)
ORA-12514: TNS:listener does not currently know of service requested in connect [message #440454] Mon, 25 January 2010 00:39 Go to next message
vinodraj4u@gmail.com
Messages: 15
Registered: January 2010
Location: bangalore
Junior Member

hi all,

im getting error ORA-12514.our prod db runs under default listener.nw i have configured another listener.if i try to connect from the loacl im grtting above error,bt im able to tnsping from the local system.please some one suggests me the solution to resolve this .its urgent
Re: ORA-12514: TNS:listener does not currently know of service requested in connect [message #440460 is a reply to message #440454] Mon, 25 January 2010 01:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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: TNS:listener does not currently know of service requested in connect [message #440462 is a reply to message #440460] Mon, 25 January 2010 01:41 Go to previous messageGo to next message
vinodraj4u@gmail.com
Messages: 15
Registered: January 2010
Location: bangalore
Junior Member

ya i tried with this option im not able to connect still.services_names is configured
Re: ORA-12514: TNS:listener does not currently know of service requested in connect [message #440468 is a reply to message #440462] Mon, 25 January 2010 02:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As you didn't provide any information we can work with we cannot help.

Regards
Michel
Re: ORA-12514: TNS:listener does not currently know of service requested in connect [message #440489 is a reply to message #440468] Mon, 25 January 2010 03:28 Go to previous messageGo to next message
vinodraj4u@gmail.com
Messages: 15
Registered: January 2010
Location: bangalore
Junior Member

sry,
im having default listener for the database by name listener with 1521 port.it is up and working fine.now i configured another listener by name listener01 with 1526 port and made it up.
bt when i try to connect from application or from local system which were configured for non default listener im getting
ORA-12514: TNS:listener does not currently know of service requested in connect.
i have checked services_names and manually registered the database with alter system register;
Re: ORA-12514: TNS:listener does not currently know of service requested in connect [message #440492 is a reply to message #440489] Mon, 25 January 2010 03:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post
1/ listener.ora and sqlnet.ora,
2/ tnsnames.ora and TNS_ADMIN variable your application use

Regards
Michel
Re: ORA-12514: TNS:listener does not currently know of service requested in connect [message #525647 is a reply to message #440492] Tue, 04 October 2011 07:27 Go to previous messageGo to next message
vinodraj4u@gmail.com
Messages: 15
Registered: January 2010
Location: bangalore
Junior Member

check whether below parameter exists or not in your tnsnames.ora
(SERVER = DEDICATED)
or
(SERVER = SHARED)
Re: ORA-12514: TNS:listener does not currently know of service requested in connect [message #525653 is a reply to message #525647] Tue, 04 October 2011 07:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And? What is the rationale behind this point?

Regards
Michel
Re: ORA-12514: TNS:listener does not currently know of service requested in connect [message #525660 is a reply to message #440489] Tue, 04 October 2011 08:34 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
i have checked services_names and manually registered the database with alter system register;
Have you adjusted your LOCAL_LISTENER parameter to point to the new listener? If you haven't, your database instance will still register its services with the default listener.
Previous Topic: Maintaining a single listener in a multi-instance dB server w/ 3 different Oracle home
Next Topic: tns error
Goto Forum:
  


Current Time: Fri Mar 29 06:10:01 CDT 2024