Error :
SQL> alter session set container=DEV1;
Session altered.
SQL> conn DEV1_ADMIN@DEV1
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
Warning: You are no longer connected to ORACLE.
Analysis
Database Node 1
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 TEST READ WRITE NO
4 DEV1 READ WRITE NO
Database Node 2
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 TEST READ WRITE NO
4 DEV1 MOUNTED NO
Resolution
Restart the DEV1 PDB on both database nodes.
Database Node 1
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 TEST READ WRITE NO
4 DEV1 READ WRITE NO
Database Node 2
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 TEST READ WRITE NO
4 DEV1 READ WRITE NO
Then DEV1_ADMIN user could be connected and issue resolved.
No comments:
Post a Comment