Re: OracleXE and Designer connection problem
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.
-- MikReceived on Wed May 10 2006 - 18:28:33 CEST