Skip to main content

ORA-01102: cannot mount database in EXCLUSIVE mode

Issue:

 After installing 11gR2, i faced issue of ORA-01102 cannot mount database in EXCLUSIVE mode when i tried to start the database.

 SQL> startup
ORACLE instance started.

 Total System Global Area 1653518336 bytes
Fixed Size                  2213896 bytes
Variable Size             956303352 bytes
Database Buffers          687865856 bytes
Redo Buffers                7135232 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode

Solution:

 Step 1. Shutdown the database.

 Step 2. Kill all the process running related to Oracle Database 
----------------------------------
[oracle@testing shm]$ ps -ef | grep ora_ | grep $ORACLE_SID
oracle     843     1  0 02:20 ?        00:00:00 ora_w000_TEST
oracle   23844     1  0 01:48 ?        00:00:00 ora_pmon_TEST
oracle   23846     1  0 01:48 ?        00:00:02 ora_vktm_TEST
oracle   23850     1  0 01:48 ?        00:00:00 ora_gen0_TEST
oracle   23852     1  0 01:48 ?        00:00:00 ora_diag_TEST
oracle   23854     1  0 01:48 ?        00:00:00 ora_dbrm_TEST
oracle   23856     1  0 01:48 ?        00:00:00 ora_psp0_TEST
oracle   23858     1  0 01:48 ?        00:00:00 ora_dia0_TEST
oracle   23860     1  0 01:48 ?        00:00:00 ora_mman_TEST
oracle   23862     1  0 01:48 ?        00:00:00 ora_dbw0_TEST
oracle   23864     1  0 01:48 ?        00:00:01 ora_lgwr_TEST
oracle   23866     1  0 01:48 ?        00:00:00 ora_ckpt_TEST
oracle   23868     1  0 01:48 ?        00:00:00 ora_smon_TEST
oracle   23870     1  0 01:48 ?        00:00:00 ora_reco_TEST
oracle   23872     1  0 01:48 ?        00:00:00 ora_mmon_TEST
oracle   23874     1  0 01:48 ?        00:00:00 ora_mmnl_TEST
oracle   23876     1  0 01:48 ?        00:00:00 ora_d000_TEST
oracle   23878     1  0 01:48 ?        00:00:00 ora_s000_TEST
oracle   23924     1  0 01:48 ?        00:00:00 ora_qmnc_TEST
oracle   23960     1  0 01:48 ?        00:00:00 ora_cjq0_TEST
oracle   24066     1  0 01:48 ?        00:00:00 ora_q000_TEST
oracle   24068     1  0 01:48 ?        00:00:00 ora_q001_TEST
oracle   24140     1  0 01:50 ?        00:00:01 ora_smco_TEST
[oracle@testing shm]$ kill -9 843 23844 23846 23850 23852 23854 23856 23858 23860 23862 23864 23866 23868 23870 23872 23874 23876 23878 23924 23960 24066 24068 24140
[oracle@testing shm]$ ps -ef | grep ora_ | grep $ORACLE_SID  (No more process should be alive)

 Step 3. Remove the lk<SID> file from $ORACLE_HOME/dbs location
----------------------------
[oracle@testing ~]$ cd $ORACLE_HOME
[oracle@testing db_1]$ cd dbs/
[oracle@testing dbs]$ ls
hc_DBUA0.dat  hc_TEST.dat  init.ora  lkTEST  orapwTEST  spfileTEST.ora
[oracle@testing dbs]$ rm lkTEST 

 Step 4. Start the database.
-------------------
SQL> startup
ORACLE instance started.

 Total System Global Area 1653518336 bytes
Fixed Size                  2213896 bytes
Variable Size             956303352 bytes
Database Buffers          687865856 bytes
Redo Buffers                7135232 bytes
Database mounted.
Database opened.


Labels:

Comments

Post a Comment

Popular posts from this blog

Node id does not exist for the current application server id

Issue: After completing cloning procedure, you generally may across the following issue. "Node id does not exist for the current application server id". Solution: First stop the application. Run adgendbc.sh script to configure apps tier dbc file with the correct id from the database instance. Start the application and test your issue. Location of script: 11i: $COMMON_TOP/admin/install/$CONTEXT_NAME R12: $INST_TOP/admin/install [appldev@erptest install]$ sh adgendbc.sh (Note: It will prompt you to give apps username and apps password.)
Post a Comment
Read more

How to change EBS R12 database and application port number

On Database Tier 1. Logon as oracle database user and source environment for R12 RDBMS ORACLE_HOME 2. Start database instance for which you want to change R12 port 3. Backup contextfile 4. Change as below in contextfile         dbport  : Change database port from 1521 to 1541         db_ons_localport : 6300 to 6320         db_ons_remoteport : 6400 to 6420         cmanport : 1521 to 1541 5. Run adautocfg.sh On Apps Tier Change Application port from 8000 to 8020 1. Logon as application manager user and source environment for R12 2. Backup contextfile 3. Run adpreclone    $ perl ./adpreclone.pl appsTier 4. Run adcfgclone and choose new port pool    $ cd $COMMON_TOP/clone/bin    $ perl ./adcfgclone.pl appsTier 5. Check new application URL SQL> select home_url from icx_parameters; HOME_URL ----------...
Post a Comment
Read more

Oracle R12 : You are trying to access a page that is no longer active

Login fails “You are trying to access a page that is no longer active.” The issue can be reproduced at will with the following steps: Issue : After cloning process the login page of Oracle E-Business Suite R12 show the above error. Solution :  For this you need to update the new hostname in the  icx_parameteres table 1.   SQL> SELECT SESSION_COOKIE_DOMAIN FROM icx_parameters; SESSION_COOKIE_DOMAIN --------------------- erp.local.com (This is hostname of Source Application Tier) 2. SQL>update icx_parameters set SESSION_COOKIE_DOMAIN = ‘target.local.com’; 1 row updated. SQL> commit; Commit complete. (This has changed the SESSION_COOKIE_DOMAIN of target application to target hostname.domain_name) 3. SQL> SELECT SESSION_COOKIE_DOMAIN FROM icx_parameters; SESSION_COOKIE_DOMAIN --------------------- target.local.com
Post a Comment
Read more