Bonjour,
J'ai une deux instances ORCL et mon instance SPIRAL sur un serveur oracle.
Je n'arrive pas à y accéder depuis un client.
La commande lsnrctl status me disait :
Impossible de voir mes instances.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 21-AUG-2013 22:19:20
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/tls-srv-Oracle11g/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=::1)(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
Par curiosité j'en ai créer une nouvelle et maintenant il me la voit :
Que faire pour qu'il voit de nouveau mes autres instances ?Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost4)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 22-AUG-2013 14:17:48
Uptime 0 days 4 hr. 19 min. 22 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/tls-srv-Oracle11g/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "SOP" has 1 instance(s).
Instance "SOP", status READY, has 1 handler(s) for this service...
Service "SOPXDB" has 1 instance(s).
Instance "SOP", status READY, has 1 handler(s) for this service...
The command completed successfully
Merci d'avance je galère
Partager