Status Listener
Código:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC3)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 07-DEC-2007 20:18:31
Uptime 0 days 0 hr. 51 min. 4 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC3)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=serveris)(PORT=1523)))
Services Summary...
Service "PARQUE.WORLD" has 1 instance(s).
Instance "PARQUE", status READY, has 1 handler(s) for this service...
Service "PARQUEXDB.WORLD" has 1 instance(s).
Instance "PARQUE", status READY, has 1 handler(s) for this service...
Service "PARQUE_XPT.WORLD" has 1 instance(s).
Instance "PARQUE", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Listener.ora:
Código:
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC3))
(ADDRESS = (PROTOCOL = TCP)(HOST = serveris)(PORT = 1523))
)
)
lo de SQL*Plus no tiene nada que ver con iSQL, ya que este último opera de manera correcta... el problema es solucionable, aunque ahora, con DHCP no da ese problema...
veré lo de DHCP, ya que hay otro problema relacionado que sucede si utilizo ip fija: pierdo conexión con el proxy de internet, aunque eso es lo de menos ya que no pretendo ocupar el servidor para navegar por internet...
gracias de antemano... has sido de gran ayuda...