ORA-01102: cannot mount database in EXCLUSIVE mode (During database startup)
idle@SYS> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 1.9327E+11 bytes
Fixed Size 7645856 bytes
Variable Size 1.8093E+11 bytes
Database Buffers 1.1811E+10 bytes
Redo Buffers 529219584 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
-bash-4.1$ kill -9 `ps -ef | grep $ORACLE_SID | grep -v grep | awk '{print $2}'`
-bash-4.1$ ps -ef | grep $ORACLE_SID
oracle 10979 1 0 19:11:38 ? 0:00 oraclebacdbst (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 10982 4703 0 19:11:39 pts/3 0:00 grep bacdb
-bash-4.1$ sqlplus
-bash-4.1$ mv lkBACDBST lkBACDBST_21012020
-bash-4.1$ ls -lrt
total 77618
-rwxrwxr-x 1 oracle oinstall 2992 Feb 3 2012 init.ora
-rwxrwxr-x 1 oracle oinstall 24 Sep 27 2016 lkBACDB
-rwxrwxr-x 1 oracle oinstall 37 Sep 27 2016 initbacdb.ora
drwxrwxr-x 2 oracle oinstall 3 Nov 6 2016 core_69839
drwxrwxr-x 2 oracle oinstall 3 Nov 12 2016 core_69335
drwxrwxr-x 2 oracle oinstall 3 Nov 27 2016 core_69523
-rw-r----- 1 oracle oinstall 24 Jan 28 2018 lkBACDBPR_23122018
-rw-r----- 1 oracle oinstall 24 Jan 28 2018 lkBACDBST_23122018
-rw-r----- 1 oracle oinstall 7680 Sep 24 2018 orapwbacdb_24092018
-rw-r----- 1 oracle dba 1536 Oct 10 2018 spfilebacdb_111018.ora
-rw-r----- 1 oracle dba 24 Dec 23 2018 lkBACDBST_25052019
-rw-r----- 1 oracle oinstall 5120 May 22 2019 orapwbacdb_22may19
-rw-r----- 1 oracle oinstall 5120 May 22 2019 orapwbacdb
-rw-r----- 1 oracle dba 24 May 25 2019 lkBACDBST_21012020
-rw-r----- 1 oracle oinstall 39534592 Jan 19 11:32 snapcf_bacdb.f
-rw-r----- 1 oracle dba 5632 Jan 21 19:12 spfilebacdb.ora
-rw-rw---- 1 oracle dba 1544 Jan 21 19:12 hc_bacdb.dat
-rw-rw---- 1 oracle dba 1544 Jan 21 19:13 hc_bacdbst.dat
-bash-4.1$
-bash-4.1$ sqlplus
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jan 21 19:14:19 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to an idle instance.
idle@SYS> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 1.9327E+11 bytes
Fixed Size 7645856 bytes
Variable Size 1.8093E+11 bytes
Database Buffers 1.1811E+10 bytes
Redo Buffers 529219584 bytes
Database mounted.
idle@SYS> alter database open read only;
Database altered.
idle@SYS> alter database recover managed standby database using current logfile disconnect;
Database altered.
idle@SYS> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBTEST MOUNTED
4 OFFSHR MOUNTED
5 SAIDEMOB MOUNTED
6 SAIDBAS MOUNTED
7 ETESORO MOUNTED
idle@SYS> alter pluggable database SAIDBAS open read only;
Pluggable database altered.
idle@SYS> alter pluggable database SAIDEMOB open read only;
Pluggable database altered.
idle@SYS> alter pluggable database OFFSHR open read only;
Pluggable database altered.
idle@SYS> alter pluggable database ETESORO open read only;
Pluggable database altered.
idle@SYS> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBTEST MOUNTED
4 OFFSHR READ ONLY NO
5 SAIDEMOB READ ONLY NO
6 SAIDBAS READ ONLY NO
7 ETESORO READ ONLY NO
idle@SYS>
idle@SYS> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 1.9327E+11 bytes
Fixed Size 7645856 bytes
Variable Size 1.8093E+11 bytes
Database Buffers 1.1811E+10 bytes
Redo Buffers 529219584 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode
-bash-4.1$ kill -9 `ps -ef | grep $ORACLE_SID | grep -v grep | awk '{print $2}'`
-bash-4.1$ ps -ef | grep $ORACLE_SID
oracle 10979 1 0 19:11:38 ? 0:00 oraclebacdbst (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 10982 4703 0 19:11:39 pts/3 0:00 grep bacdb
-bash-4.1$ sqlplus
-bash-4.1$ mv lkBACDBST lkBACDBST_21012020
-bash-4.1$ ls -lrt
total 77618
-rwxrwxr-x 1 oracle oinstall 2992 Feb 3 2012 init.ora
-rwxrwxr-x 1 oracle oinstall 24 Sep 27 2016 lkBACDB
-rwxrwxr-x 1 oracle oinstall 37 Sep 27 2016 initbacdb.ora
drwxrwxr-x 2 oracle oinstall 3 Nov 6 2016 core_69839
drwxrwxr-x 2 oracle oinstall 3 Nov 12 2016 core_69335
drwxrwxr-x 2 oracle oinstall 3 Nov 27 2016 core_69523
-rw-r----- 1 oracle oinstall 24 Jan 28 2018 lkBACDBPR_23122018
-rw-r----- 1 oracle oinstall 24 Jan 28 2018 lkBACDBST_23122018
-rw-r----- 1 oracle oinstall 7680 Sep 24 2018 orapwbacdb_24092018
-rw-r----- 1 oracle dba 1536 Oct 10 2018 spfilebacdb_111018.ora
-rw-r----- 1 oracle dba 24 Dec 23 2018 lkBACDBST_25052019
-rw-r----- 1 oracle oinstall 5120 May 22 2019 orapwbacdb_22may19
-rw-r----- 1 oracle oinstall 5120 May 22 2019 orapwbacdb
-rw-r----- 1 oracle dba 24 May 25 2019 lkBACDBST_21012020
-rw-r----- 1 oracle oinstall 39534592 Jan 19 11:32 snapcf_bacdb.f
-rw-r----- 1 oracle dba 5632 Jan 21 19:12 spfilebacdb.ora
-rw-rw---- 1 oracle dba 1544 Jan 21 19:12 hc_bacdb.dat
-rw-rw---- 1 oracle dba 1544 Jan 21 19:13 hc_bacdbst.dat
-bash-4.1$
-bash-4.1$ sqlplus
SQL*Plus: Release 12.1.0.2.0 Production on Tue Jan 21 19:14:19 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to an idle instance.
idle@SYS> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 1.9327E+11 bytes
Fixed Size 7645856 bytes
Variable Size 1.8093E+11 bytes
Database Buffers 1.1811E+10 bytes
Redo Buffers 529219584 bytes
Database mounted.
idle@SYS> alter database open read only;
Database altered.
idle@SYS> alter database recover managed standby database using current logfile disconnect;
Database altered.
idle@SYS> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBTEST MOUNTED
4 OFFSHR MOUNTED
5 SAIDEMOB MOUNTED
6 SAIDBAS MOUNTED
7 ETESORO MOUNTED
idle@SYS> alter pluggable database SAIDBAS open read only;
Pluggable database altered.
idle@SYS> alter pluggable database SAIDEMOB open read only;
Pluggable database altered.
idle@SYS> alter pluggable database OFFSHR open read only;
Pluggable database altered.
idle@SYS> alter pluggable database ETESORO open read only;
Pluggable database altered.
idle@SYS> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBTEST MOUNTED
4 OFFSHR READ ONLY NO
5 SAIDEMOB READ ONLY NO
6 SAIDBAS READ ONLY NO
7 ETESORO READ ONLY NO
idle@SYS>
No comments:
Post a Comment