Home » RDBMS Server » Networking and Gateways » Listener could not listen Ora 11 XE server
Listener could not listen Ora 11 XE server [message #546972] Sat, 10 March 2012 18:56 Go to next message
leorbarbosa@gmail.com
Messages: 3
Registered: March 2012
Location: Brazil
Junior Member
Hi,

I have installed on my local machine the Ora 11 XE server and the client. Its okay. I can logon from the OAS normally.

However, when I try to connect from my Php application, the messages that comes is: 'ORA-12154: TNS:could not resolve service name'.

Can someone help me?
Re: Listener could not listen Ora 11 XE server [message #546974 is a reply to message #546972] Sat, 10 March 2012 19:40 Go to previous messageGo to next message
BlackSwan
Messages: 22839
Registered: January 2009
Senior Member
ORA-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system
ORA-12154 occurs when client requests a connection to some DB server system using some connection string.
The lookup operation fails because the name provided can NOT be resolved to any remote DB.
The analogous operation would be when you wanted to call somebody, but could not find their name in any phonebook.
The most frequent cause for the ORA-12154 error is when the connection alias can not be found in tnsnames.ora.
The lookup operation of the alias can be impacted by the contents of the sqlnet.ora file; specifically DOMAIN entry.
TROUBLESHOOTING GUIDE: ORA-12154 & TNS-12154 TNS:could not resolve service name [ID 114085.1]
http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

[Updated on: Sat, 10 March 2012 19:40]

Report message to a moderator

Re: Listener could not listen Ora 11 XE server [message #547022 is a reply to message #546972] Sun, 11 March 2012 10:23 Go to previous messageGo to next message
leorbarbosa@gmail.com
Messages: 3
Registered: March 2012
Location: Brazil
Junior Member
Sorry,

the correct error code is:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.

Can some help?
Re: Listener could not listen Ora 11 XE server [message #547024 is a reply to message #547022] Sun, 11 March 2012 10:36 Go to previous messageGo to next message
Michel Cadot
Messages: 59279
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: Listener could not listen Ora 11 XE server [message #547032 is a reply to message #547024] Sun, 11 March 2012 16:57 Go to previous messageGo to next message
BlackSwan
Messages: 22839
Registered: January 2009
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.
http://edstevensdba.wordpress.com/2011/03/19/ora-12514/
Re: Listener could not listen Ora 11 XE server [message #547049 is a reply to message #547032] Mon, 12 March 2012 01:12 Go to previous messageGo to next message
Littlefoot
Messages: 19648
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Black Swan, 3 messages above

ORA-12154 ALWAYS only occurs on SQL Client & no SQL*Net packets ever leave client system


Black Swan, 1 message above

ORA-12514 ALWAYS only occurs due to a problem on DB Server system.


./fa/1580/0/ So which one is it? A client or a server?
Re: Listener could not listen Ora 11 XE server [message #547057 is a reply to message #547049] Mon, 12 March 2012 02:02 Go to previous messageGo to next message
Michel Cadot
Messages: 59279
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Depends on the actual error (number).

Regards
Michel
Re: Listener could not listen Ora 11 XE server [message #547058 is a reply to message #547057] Mon, 12 March 2012 02:09 Go to previous messageGo to next message
Littlefoot
Messages: 19648
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Shame on me and my blindness! I apologize, sincerely, I overlooked the difference (thought both were the same: 12154 & 12514). No doubt, my week has started magnificently ...
Re: Listener could not listen Ora 11 XE server [message #547063 is a reply to message #547058] Mon, 12 March 2012 02:32 Go to previous messageGo to next message
John Watson
Messages: 4610
Registered: January 2010
Location: Global Village
Senior Member
Quote:
my week has started magnificently ...
For some of us, the week started some time ago:
orcl> alter session set nls_territory='America';

Session altered.

orcl> select to_char(sysdate,'d') from dual;

T
-
2

orcl> alter session set nls_territory='United Arab Emirates';

Session altered.

orcl> select to_char(sysdate,'d') from dual;

T
-
3

orcl>
bit not, I see, for you:
orcl> alter session set nls_territory='Croatia'

Session altered.

orcl> select to_char(sysdate,'d') from dual;

T
-
1
time for Europe to have some coffee.
Re: Listener could not listen Ora 11 XE server [message #547064 is a reply to message #547058] Mon, 12 March 2012 02:33 Go to previous message
Michel Cadot
Messages: 59279
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No problem this was also OP's mistake in his first post.
And I bet many of us have already fallen in this one.

Regards
Michel
Previous Topic: Oracle HTTP SSL Certificate causes errors in IE 6/7/8
Next Topic: ORA-12154 and ORA-12504:
Goto Forum:
  


Current Time: Tue Sep 30 23:13:57 CDT 2014

Total time taken to generate the page: 0.09437 seconds