Thursday, January 2, 2020

LISTENER is in restricted mode because post upgrade the database went into restricted mode



[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