oracle ora-09968,ORA-09968, ORA-01102 When Starting a Database

一、网友错误

pub上网友遇到一个问题

Tue Nov 22 10:31:19 2011

ALTER DATABASE MOUNT

Tue Nov 22 10:31:19 2011

sculkget: failed to lock /u01/app/oracle/product/10.2.01/db_1/dbs/lkORCL exclusive

sculkget: lock held by PID: 26308

Tue Nov 22 10:31:19 2011

ORA-09968: unable to lock file

Linux Error: 11: Resource temporarily unavailable

Additional information: 26308

Tue Nov 22 10:31:19 2011

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

我给的建议是重启数据库解决，其实重启数据库是关闭了当前开启的实例，然后开启报错的实例，所以重启成功

二、错误重现

Tue Nov 22 10:31:19 2011

ALTER DATABASE MOUNT

Tue Nov 22 10:31:19 2011

sculkget: failed to lock /u01/app/oracle/product/10.2.01/db_1/dbs/lkORCL exclusive

sculkget: lock held by PID: 26308

Tue Nov 22 10:31:19 2011

ORA-09968: unable to lock file

Linux Error: 11: Resource temporarily unavailable

Additional information: 26308

Tue Nov 22 10:31:19 2011

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

[oracle@ECP-UC-DB1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Nov 23 09:07:21 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

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

SQL> select status from v$instance;

STATUS

------------

OPEN

SQL> show parameter name ;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_file_name_convert string

db_name string test

db_unique_name string test

global_names boolean FALSE

instance_name string test

lock_name_space string

log_file_name_convert string

service_names string test

SQL> show parameter control;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

control_file_record_keep_time integer 7

control_files string /opt/oracle/oradata/test/contr

ol01.ctl

SQL> create pfile='/tmp/t_pfile' from spfile;

File created.

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

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

[oracle@ECP-UC-DB1 ~]$ vi /tmp/t_pfile

*.__db_cache_size=67108864

*.__java_pool_size=4194304

*.__large_pool_size=4194304

*.__shared_pool_size=117440512

*.__streams_pool_size=8388608

*.archive_lag_target=0

*.audit_file_dest='/opt/oracle/admin/test/adump'

*.background_dump_dest='/opt/oracle/admin/test/bdump'

*.compatible='10.2.0.3.0'

*.control_files='/opt/oracle/oradata/test/control01.ctl'

*.core_dump_dest='/opt/oracle/admin/test/cdump'

*.db_block_size=8192

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='test'

*.db_recovery_file_dest='/opt/oracle/flash_recovery_area'

*.db_recovery_file_dest_size=2147483648

*.dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)'

*.job_queue_processes=10

*.log_archive_dest_1='location=/opt/oracle/oradata/test/archivelog'

*.open_cursors=1000

*.pga_aggregate_target=66060288

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=209715200

*.undo_management='AUTO'

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='/opt/oracle/admin/test/udump'

~

~

"/tmp/t_pfile" 28L, 1043C written

[oracle@ECP-UC-DB1 ~]$ export ORACLE_SID=tt1

[oracle@ECP-UC-DB1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Nov 23 09:10:47 2011

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL> startup pfile='/tmp/t_pfile' mount;

ORACLE instance started.

Total System Global Area 209715200 bytes

Fixed Size 2082784 bytes

Variable Size 134219808 bytes

Database Buffers 67108864 bytes

Redo Buffers 6303744 bytes

ORA-01102: cannot mount database in EXCLUSIVE mode

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

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

[oracle@ECP-UC-DB1 ~]$ more /opt/oracle/admin/test/bdump/alert_tt1.log

Wed Nov 23 09:11:26 2011

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Shared memory segment for instance monitoring created

Picked latch-free SCN scheme 3

Autotune of undo retention is turned on.

IMODE=BR

ILAT =18

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.4.0.

System parameters with non-default values:

processes = 150

__shared_pool_size = 117440512

__large_pool_size = 4194304

__java_pool_size = 4194304

__streams_pool_size = 8388608

sga_target = 209715200

control_files = /opt/oracle/oradata/test/control01.ctl

db_block_size = 8192

__db_cache_size = 67108864

compatible = 10.2.0.3.0

log_archive_dest_1 = location=/opt/oracle/oradata/test/archivelog

archive_lag_target = 0

db_file_multiblock_read_count= 16

db_recovery_file_dest = /opt/oracle/flash_recovery_area

db_recovery_file_dest_size= 2147483648

undo_management = AUTO

undo_tablespace = UNDOTBS1

remote_login_passwordfile= EXCLUSIVE

db_domain =

dispatchers = (PROTOCOL=TCP) (SERVICE=testXDB)

job_queue_processes = 10

background_dump_dest = /opt/oracle/admin/test/bdump

user_dump_dest = /opt/oracle/admin/test/udump

core_dump_dest = /opt/oracle/admin/test/cdump

audit_file_dest = /opt/oracle/admin/test/adump

db_name = test

open_cursors = 1000

pga_aggregate_target = 66060288

PMON started with pid=2, OS id=28086

PSP0 started with pid=3, OS id=28088

MMAN started with pid=4, OS id=28090

DBW0 started with pid=5, OS id=28092

LGWR started with pid=6, OS id=28094

CKPT started with pid=7, OS id=28096

SMON started with pid=8, OS id=28098

RECO started with pid=9, OS id=28100

CJQ0 started with pid=10, OS id=28102

MMON started with pid=11, OS id=28104

Wed Nov 23 09:11:28 2011

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

MMNL started with pid=12, OS id=28106

Wed Nov 23 09:11:28 2011

starting up 1 shared server(s) ...

Wed Nov 23 09:11:28 2011

ALTER DATABASE MOUNT

Wed Nov 23 09:11:28 2011

sculkget: failed to lock /opt/oracle/product/10.2.0/db_1/dbs/lkTEST exclusive

sculkget: lock held by PID: 12339

Wed Nov 23 09:11:28 2011

ORA-09968: unable to lock file

Linux-x86_64 Error: 11: Resource temporarily unavailable

Additional information: 12339

Wed Nov 23 09:11:28 2011

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

通过这个试验，再现了网友的ORA-09968, ORA-01102错误

三、MOS解释

ORA-09968, ORA-01102 When Starting a Database