PLSExtProc status UNKNOWN Ubuntu 12.10 x86_64
Hola he instalado Oracle Database Express Edition 11g Release 2 http://www.oracle.com/technetwork/products/express-edition/downloads/index.html con ubuntu 12.10 de 64 bits, no me puedo conectar y creo que el problema es por Instance «PLSExtProc», status UNKNOWN, has 1 handler(s) for this service…
[code]
aleix@aspire:~$ sudo /etc/init.d/oracle-xe status
LSNRCTL for Linux: Version 11.2.0.2.0 – Production on 08-NOV-2012 00:44:20
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 – Production
Start Date 08-NOV-2012 00:44:16
Uptime 0 days 0 hr. 0 min. 4 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/aspire/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=aspire)(PORT=1521)))
Services Summary…
Service «PLSExtProc» has 1 instance(s).
Instance «PLSExtProc», status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully
[/code]
En el cliente SQL Developer me sale el error:
Status: Failure -Test failed: Listener refused the connection with the following error:ORA-12505, TNS:listener does currently know of SID given in connect descriptor
Alguna solución?
Saludos y gracias B)