./sqlplus "/ as sysdba"
SQL> SELECT name FROM v$services order by 1;
NAME
----------------------------------------------------------------
SYS$BACKGROUND
SYS$USERS
orcl.eu-west-1.compute.internal
orclXDB
________________________________________________
lsnrctl services
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zozoprod)(PORT=1521)))
Services Summary...
Service "orcl.eu-west-1.compute.internal" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:136 refused:0 state:ready
LOCAL SERVER
Service "orclXDB.eu-west-1.compute.internal" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:36 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: ip-xx-xx-xx-xxx.eu-west-1.compute.internal, pid: 8649>
(ADDRESS=(PROTOCOL=tcp)(HOST=ip-xx-xx-xx-xxx.eu-west-1.compute.internal)(PORT=29260))
The command completed successfully
Partager