[oracle@oeldbapex dbs]$ ps -ef | grep tns
root 15 2 0 2019 ? 00:00:00 [netns]
oracle 1684 1 0 14:35 ? 00:00:00 /u02/sw//bin/tnslsnr LISTENERLINDB -inherit
oracle 1695 352 0 14:36 pts/8 00:00:00 grep tns
[oracle@oeldbapex dbs]$ lsnrctl status
LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 02-JAN-2020 14:36:50
Copyright (c) 1991, 2018, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENERLINDB
Version TNSLSNR for Linux: Version 18.0.0.0.0 - Production
Start Date 02-JAN-2020 14:35:30
Uptime 0 days 0 hr. 1 min. 19 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u02/sw/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/oeldbapex/listenerlindb/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oeldbapex.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "lindb" has 1 instance(s).
Instance "lindb", status RESTRICTED, has 1 handler(s) for this service...
Service "lindbXDB" has 1 instance(s).
Instance "lindb", status RESTRICTED, has 1 handler(s) for this service...
The command completed successfully
[oracle@oeldbapex dbs]$ lsnrctl status
LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 02-JAN-2020 14:38:24
Copyright (c) 1991, 2018, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENERLINDB
Version TNSLSNR for Linux: Version 18.0.0.0.0 - Production
Start Date 02-JAN-2020 14:35:30
Uptime 0 days 0 hr. 2 min. 53 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u02/sw/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/oeldbapex/listenerlindb/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oeldbapex.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "lindb" has 1 instance(s).
Instance "lindb", status RESTRICTED, has 1 handler(s) for this service...
Service "lindbXDB" has 1 instance(s).
Instance "lindb", status RESTRICTED, has 1 handler(s) for this service...
The command completed successfully
[oracle@oeldbapex dbs]$ lsnrctl status
LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 02-JAN-2020 14:38:39
Copyright (c) 1991, 2018, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENERLINDB
Version TNSLSNR for Linux: Version 18.0.0.0.0 - Production
Start Date 02-JAN-2020 14:35:30
Uptime 0 days 0 hr. 3 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u02/sw/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/oeldbapex/listenerlindb/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oeldbapex.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "lindb" has 1 instance(s).
Instance "lindb", status RESTRICTED, has 1 handler(s) for this service...
Service "lindbXDB" has 1 instance(s).
Instance "lindb", status RESTRICTED, has 1 handler(s) for this service...
The command completed successfully
[oracle@oeldbapex dbs]$ sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Thu Jan 2 14:39:24 2020
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL> Select logins from v$instance;
LOGINS
----------
RESTRICTED
SQL> select a.INSTANCE_NAME, a.ACTIVE_STATE,a.logins, b.open_mode
from v$instance a inner join v$database b
on UPPER(a.instance_name) = b.name; 2 3
INSTANCE_NAME ACTIVE_ST LOGINS OPEN_MODE
---------------- --------- ---------- --------------------
lindb NORMAL RESTRICTED READ WRITE
SQL> alter system disable restricted session;
System altered.
SQL> select logins from v$instance;
LOGINS
----------
ALLOWED
SQL> exit
Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
[oracle@oeldbapex dbs]$ lsnrctl status LISTENERLINDB
LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 02-JAN-2020 14:41:10
Copyright (c) 1991, 2018, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oeldbapex.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENERLINDB
Version TNSLSNR for Linux: Version 18.0.0.0.0 - Production
Start Date 02-JAN-2020 14:35:30
Uptime 0 days 0 hr. 5 min. 39 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u02/sw/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/oeldbapex/listenerlindb/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oeldbapex.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "lindb" has 1 instance(s).
Instance "lindb", status READY, has 1 handler(s) for this service...
Service "lindbXDB" has 1 instance(s).
Instance "lindb", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@oeldbapex dbs]$
No comments:
Post a Comment