Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-01102: cannot mount database in EXCLUSIVE mode in AIX after installing database using dbca

RavilKhalilovMay 25 2015 — edited May 26 2015

Hello!

I have IBM AIX v7 and configured HACMP cluster including two identical nodes

I primary node  after installing database using dbca I got error with message:

ORA-01102: cannot mount database in EXCLUSIVE mode

Database can't be mount(

Here's alert log information:

Mon May 25 18:00:07 2015

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 3

Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST

Autotune of undo retention is turned on.

IMODE=BR

ILAT =84

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options.

ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1/

System name:    nodename

Node name:      nodename

Release:        1

Version:        7

Machine:        0003F6E5D600

Using parameter settings in server-side spfile /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfiletestdb.ora

System parameters with non-default values:

  processes                = 500

  sessions                 = 772

  memory_target            = 18G

  control_files            = "/ctl1/oradata/testdb/control01.ctl"

  control_files            = "/ctl2/oradata/testdb/control02.ctl"

  control_files            = "/ctl3/oradata/testdb/control03.ctl"

  db_block_size            = 8192

  compatible               = "11.2.0.0.0"

  db_recovery_file_dest    = "/backup/fra"

  db_recovery_file_dest_size= 100G

  undo_tablespace          = "UNDOTBS1"

  remote_login_passwordfile= "EXCLUSIVE"

  db_domain                = ""

  dispatchers              = "(PROTOCOL=TCP) (SERVICE=testdbXDB)"

  audit_file_dest          = "/u01/app/oracle/admin/testdb/adump"

  audit_trail              = "DB"

  db_name                  = "testdb"

  open_cursors             = 300

  diagnostic_dest          = "/u01/app/oracle"

Mon May 25 18:00:08 2015

PMON started with pid=2, OS id=14418020

Mon May 25 18:00:08 2015

PSP0 started with pid=3, OS id=17891420

Mon May 25 18:00:09 2015

VKTM started with pid=4, OS id=14090348 at elevated priority

VKTM running at (10)millisec precision with DBRM quantum (100)ms

Mon May 25 18:00:09 2015

GEN0 started with pid=5, OS id=9109714

Mon May 25 18:00:09 2015

DIAG started with pid=6, OS id=16449704

Mon May 25 18:00:09 2015

DBRM started with pid=7, OS id=17104928

Mon May 25 18:00:10 2015

DIA0 started with pid=8, OS id=13303950

Mon May 25 18:00:10 2015

MMAN started with pid=9, OS id=12517522

Mon May 25 18:00:10 2015

DBW0 started with pid=10, OS id=11993232

Mon May 25 18:00:10 2015

LGWR started with pid=11, OS id=15401010

Mon May 25 18:00:10 2015

CKPT started with pid=12, OS id=6619318

Mon May 25 18:00:10 2015

SMON started with pid=13, OS id=16515222

Mon May 25 18:00:10 2015

RECO started with pid=14, OS id=13172906

Mon May 25 18:00:10 2015

MMON started with pid=15, OS id=15794324

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

Mon May 25 18:00:10 2015

MMNL started with pid=16, OS id=18546742

starting up 1 shared server(s) ...

ORACLE_BASE from environment = /u01/app/oracle/

Mon May 25 18:00:11 2015

ALTER DATABASE   MOUNT

sculkget: failed to lock /u01/app/oracle/product/11.2.0/dbhome_1//dbs/lkTESTDB exclusive

sculkget: lock held by PID: 3670226

ORA-09968: unable to lock file

IBM AIX RISC System/6000 Error: 13: Permission denied

Additional information: 3670226

ORA-1102 signalled during: ALTER DATABASE   MOUNT...

But if I install the same darabase from dbca on secondary node, everything installed and run sucessfully.

But in both nodes permissions the same, oracle user ID and oinstall group ID the same, and at  $ORACLE_BASE and $ORACLE_HOME user owner is oracle and oinstall user group.

Has anyone encountered this problem and solved it?

Thanks in advance!

This post has been answered by Emad Al-Mousa on May 25 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 23 2015
Added on May 25 2015
5 comments
1,187 views