Re: OracleXE and Designer connection problem

On Wed, 10 May 2006 12:07:51 +0200, Mik wrote:

ORA-12514: Either the XE instance is not registering itself to the listener ... specifically the listener that is on the port that you are trying to hit; OR
the service picked up by the _at_XE alias (which selects the 'XE =' entry in the TNSNAMES.ORA) does not exactly match the service that has registered itself to the listener.

Two test, both at command line, are:

1. tnsping XE

Done from the client environment. Should result in an output like

[Quoted] Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)

(HOST = fuzzy)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = XE))) OK (0 msec)

Note the 'SERVICE_NAME' and 'PORT' entries.

If it does not provide an 'OK', you need to get that fixed first.

We are asking the listener on that port to connect to a service named 'XE'.

2) lsnrctl status

Done from the server's environment that listens on the same port as above. Should include some lines that look like

Service "XE" has 1 instance(s).
[Quoted]   Instance "XE", status READY, has 1 handler(s) for this service...

where the Service matches EXACTLY (case, spaces, etc) to the output from tnsping. This tells us the listener is able to connect to a service named 'XE', which matches the above request.

If these two match and there still is an ORA-12514, there is a high probablity that the wrong tnsnames.ora

-- 
/Hans ... mailto: Fuzzy_dot_GreyBreard_at_gmail_dot_com
Top posting in newsgroups is a sure way to stop my replies!

I reserve the right to change my mind on anything.  Especially when 
confronted with facts that are better than the ones I use right now.