oracle ora-09968,ORA-09968: unable to lock file

In the aler_orcl.log file, I have this-

Tue Feb 05 22:09:57 2013

PMON started with pid=2, OS id=14288

Tue Feb 05 22:09:57 2013

VKTM started with pid=3, OS id=13112 at elevated priority

VKTM running at (20)ms precision

Tue Feb 05 22:09:57 2013

DIAG started with pid=4, OS id=13768

Tue Feb 05 22:09:57 2013

DBRM started with pid=5, OS id=11476

Tue Feb 05 22:09:57 2013

PSP0 started with pid=6, OS id=12344

Tue Feb 05 22:09:57 2013

DSKM started with pid=7, OS id=13276

Tue Feb 05 22:09:57 2013

DIA0 started with pid=8, OS id=5368

Tue Feb 05 22:09:57 2013

MMAN started with pid=7, OS id=11232

Tue Feb 05 22:09:57 2013

DBW0 started with pid=9, OS id=12992

Tue Feb 05 22:09:57 2013

LGWR started with pid=10, OS id=14140

Tue Feb 05 22:09:57 2013

CKPT started with pid=11, OS id=2964

Tue Feb 05 22:09:57 2013

SMON started with pid=12, OS id=4444

Tue Feb 05 22:09:57 2013

RECO started with pid=13, OS id=13660

Tue Feb 05 22:09:57 2013

MMON started with pid=14, OS id=10596

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

starting up 1 shared server(s) ...

ORACLE_BASE from environment =

965af934f6bf1c0efcc29a425d1a696a.png\app\rjamal

Tue Feb 05 22:09:57 2013

ALTER DATABASE MOUNT

Tue Feb 05 22:09:57 2013

MMNL started with pid=15, OS id=13392

Setting recovery target incarnation to 2

Successful mount of redo thread 1, with mount id 1334447288

Database mounted in Exclusive Mode

Lost write protection disabled

Completed: ALTER DATABASE MOUNT

Tue Feb 05 22:10:04 2013

ALTER DATABASE OPEN

Thread 1 opened at log sequence 1400

Current log# 2 seq# 1400 mem# 0:

965af934f6bf1c0efcc29a425d1a696a.png\APP\RJAMAL\ORADATA\ORCL\REDO02.LOG

Successful open of redo thread 1

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

SMON: enabling cache recovery

Successfully onlined Undo Tablespace 2.

Verifying file header compatibility for 11g tablespace encryption..

Verifying 11g file header compatibility for tablespace encryption completed

SMON: enabling tx recovery

Database Characterset is WE8MSWIN1252

Opening with internal Resource Manager plan

Starting background process FBDA

Starting background process SMCO

Tue Feb 05 22:10:06 2013

SMCO started with pid=20, OS id=13828

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

Tue Feb 05 22:10:07 2013

QMNC started with pid=21, OS id=2640

Tue Feb 05 22:10:06 2013

FBDA started with pid=18, OS id=13760

Tue Feb 05 22:10:11 2013

db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a

user-specified limit on the amount of space that will be used by this

database for recovery-related files, and does not reflect the amount of

space available in the underlying filesystem or ASM diskgroup.

Tue Feb 05 22:10:17 2013

Completed: ALTER DATABASE OPEN

Tue Feb 05 22:13:20 2013

ALTER SYSTEM SET processes=10000 SCOPE=SPFILE;

Stopping background process SMCO

Stopping background process FBDA

Shutting down instance: further logons disabled

Stopping background process QMNC

Stopping background process MMNL

Stopping background process MMON

Tue Feb 05 22:13:30 2013

Shutting down instance (immediate)

License high water mark = 7

Waiting for dispatcher 'D000' to shutdown

All dispatchers and shared servers shutdown

ALTER DATABASE CLOSE NORMAL

Tue Feb 05 22:13:33 2013

SMON: disabling tx recovery

SMON: disabling cache recovery

Tue Feb 05 22:13:34 2013

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Thread 1 closed at log sequence 1400

Successful close of redo thread 1

Completed: ALTER DATABASE CLOSE NORMAL

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Tue Feb 05 22:13:35 2013

Stopping background process VKTM:

Tue Feb 05 22:13:37 2013

Instance shutdown complete

Tue Feb 05 22:13:44 2013

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

965af934f6bf1c0efcc29a425d1a696a.png\app\rjamal\product\11.1.0\db_1\RDBMS

Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST

Autotune of undo retention is turned on.

IMODE=BR

ILAT =1210

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up ORACLE RDBMS Version: 11.1.0.6.0.

Using parameter settings in server-side spfile

965af934f6bf1c0efcc29a425d1a696a.png\APP\RJAMAL\PRODUCT\11.1.0\DB_1\DATABASE\SPFILEORCL.ORA

System parameters with non-default values:

processes = 10000

memory_target = 9856M

control_files = "D:\APP\RJAMAL\ORADATA\ORCL\CONTROL01.CTL"

control_files = "D:\APP\RJAMAL\ORADATA\ORCL\CONTROL02.CTL"

control_files = "D:\APP\RJAMAL\ORADATA\ORCL\CONTROL03.CTL"

db_block_size = 8192

compatible = "11.1.0.0.0"

db_recovery_file_dest = "D:\app\rjamal\flash_recovery_area"

db_recovery_file_dest_size= 2G

undo_tablespace = "UNDOTBS1"

remote_login_passwordfile= "EXCLUSIVE"

db_domain = ""

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

audit_file_dest = "D:\APP\RJAMAL\ADMIN\ORCL\ADUMP"

audit_trail = "DB"

db_name = "orcl"

open_cursors = 300

diagnostic_dest = "D:\APP\RJAMAL"

Tue Feb 05 22:13:45 2013

PMON started with pid=2, OS id=3744

Tue Feb 05 22:13:45 2013

VKTM started with pid=3, OS id=12620 at elevated priority

VKTM running at (20)ms precision

Tue Feb 05 22:13:45 2013

DIAG started with pid=4, OS id=13356

Tue Feb 05 22:13:45 2013

DBRM started with pid=5, OS id=1036

Tue Feb 05 22:13:45 2013

PSP0 started with pid=6, OS id=11528

Tue Feb 05 22:13:45 2013

DSKM started with pid=7, OS id=14160

Tue Feb 05 22:13:45 2013

DIA0 started with pid=8, OS id=13856

Tue Feb 05 22:13:45 2013

MMAN started with pid=7, OS id=6740

Tue Feb 05 22:13:45 2013

DBW0 started with pid=9, OS id=13044

Tue Feb 05 22:13:45 2013

LGWR started with pid=10, OS id=14068

Tue Feb 05 22:13:45 2013

CKPT started with pid=11, OS id=13788

Tue Feb 05 22:13:45 2013

SMON started with pid=12, OS id=14036

Tue Feb 05 22:13:45 2013

RECO started with pid=13, OS id=12132

Tue Feb 05 22:13:45 2013

MMON started with pid=14, OS id=12404

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

starting up 1 shared server(s) ...

ORACLE_BASE from environment =

965af934f6bf1c0efcc29a425d1a696a.png\app\rjamal

Tue Feb 05 22:13:45 2013

ALTER DATABASE MOUNT

Tue Feb 05 22:13:45 2013

MMNL started with pid=15, OS id=4560

Setting recovery target incarnation to 2

Successful mount of redo thread 1, with mount id 1334401436

Database mounted in Exclusive Mode

Lost write protection disabled

Completed: ALTER DATABASE MOUNT

Tue Feb 05 22:13:52 2013

ALTER DATABASE OPEN

Thread 1 opened at log sequence 1400

Current log# 2 seq# 1400 mem# 0:

965af934f6bf1c0efcc29a425d1a696a.png\APP\RJAMAL\ORADATA\ORCL\REDO02.LOG

Successful open of redo thread 1

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

SMON: enabling cache recovery

Successfully onlined Undo Tablespace 2.

Verifying file header compatibility for 11g tablespace encryption..

Verifying 11g file header compatibility for tablespace encryption completed

SMON: enabling tx recovery

Database Characterset is WE8MSWIN1252

Opening with internal Resource Manager plan

Starting background process FBDA

Starting background process SMCO

Tue Feb 05 22:13:54 2013

FBDA started with pid=18, OS id=4684

Tue Feb 05 22:13:54 2013

SMCO started with pid=20, OS id=11544

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

Tue Feb 05 22:13:55 2013

QMNC started with pid=21, OS id=10872

Tue Feb 05 22:14:00 2013

db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a

user-specified limit on the amount of space that will be used by this

database for recovery-related files, and does not reflect the amount of

space available in the underlying filesystem or ASM diskgroup.

Tue Feb 05 22:14:06 2013

Completed: ALTER DATABASE OPEN

Tue Feb 05 22:15:05 2013

Thread 1 advanced to log sequence 1401

Current log# 3 seq# 1401 mem# 0:

965af934f6bf1c0efcc29a425d1a696a.png\APP\RJAMAL\ORADATA\ORCL\REDO03.LOG

Tue Feb 05 22:18:49 2013

Starting background process CJQ0

Tue Feb 05 22:18:49 2013

CJQ0 started with pid=26, OS id=11732

Setting Resource Manager plan SCHEDULER[0x2C0A]:DEFAULT_MAINTENANCE_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter

Tue Feb 05 22:25:04 2013

ALTER SYSTEM SET processes=10000000 SCOPE=SPFILE;

Stopping background process SMCO

Stopping background process FBDA

Shutting down instance: further logons disabled

Tue Feb 05 22:25:11 2013

Stopping background process CJQ0

Stopping background process QMNC

Stopping background process MMNL

Stopping background process MMON

Tue Feb 05 22:25:14 2013

Shutting down instance (immediate)

License high water mark = 7

Stopping Job queue slave processes, flags = 7

Tue Feb 05 22:25:14 2013

ORA-1089 : opidrv aborting process J000 ospid (1016_13040)

Job queue slave processes stopped

Waiting for dispatcher 'D000' to shutdown

All dispatchers and shared servers shutdown

ALTER DATABASE CLOSE NORMAL

Tue Feb 05 22:25:17 2013

SMON: disabling tx recovery

SMON: disabling cache recovery

Tue Feb 05 22:25:17 2013

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Thread 1 closed at log sequence 1401

Successful close of redo thread 1

Completed: ALTER DATABASE CLOSE NORMAL

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Tue Feb 05 22:25:19 2013

Stopping background process VKTM:

Tue Feb 05 22:25:22 2013

Instance shutdown complete

Tue Feb 05 22:25:28 2013

Starting ORACLE instance (normal)

Wed Feb 06 11:53:59 2013

Starting ORACLE instance (normal)

Wed Feb 06 11:56:01 2013

Starting ORACLE instance (normal)

And I don't know where I should look for process trace file?

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值