Re: OracleXE and Designer connection problem

From: Mik <NOSPAM_at_yahoo.es>
Date: Wed, 10 May 2006 18:28:33 +0200
Message-ID: <e3t4bb$r9c$1_at_tramontana.micasa.mired>


"HansF" <Fuzzy.Greybeard_at_gmail.com> escribió en el mensaje news:pan.2006.05.10.14.52.56.247430_at_gmail.com...
> 1) tnsping XE
>
> 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)

OK, my output for "tnsping XE" matches exactly this one, except that in my case HOST = 127.0.0.1 (normal, as I've defined it to be this way).

> 2) lsnrctl status
>
> Service "XE" has 1 instance(s).
> Instance "XE", status READY, has 1 handler(s) for this service...

In this case "lsnrctl status" reports that the default service is "XE" but I do not have a Service "XE" instance, only for "CLRExtProc" and "PLSExtProc" services, so here it is the problem I think. What should I do to fix this ?

Lots of thanks you for your useful reply.

--
Mik
Received on Wed May 10 2006 - 18:28:33 CEST

Original text of this message