Showing posts with label ORA-01102. Show all posts
Showing posts with label ORA-01102. Show all posts

Tuesday, 21 January 2020

ORA-01102: cannot mount database in EXCLUSIVE mode (During database startup)

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>