jomfra
asked on
problems after using the alter system statement on my spfile
hello rbrooker,
i RAN INTO SOME PROBLEMS
AFTER I MADE ALL THE AJUSTMENTS AS PER POST
BELOW IS THE ERROR
SQL> startup open
ORACLE instance started.
Total System Global Area 143727516 bytes
Fixed Size 453532 bytes
Variable Size 109051904 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
THANKS
i RAN INTO SOME PROBLEMS
AFTER I MADE ALL THE AJUSTMENTS AS PER POST
BELOW IS THE ERROR
SQL> startup open
ORACLE instance started.
Total System Global Area 143727516 bytes
Fixed Size 453532 bytes
Variable Size 109051904 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
THANKS
did you copy the controlfile to the right location?
as slightvw says, do : show parameter control_files
and make sure that for all the entries you are shown, there is a controlfile.
also, when copying them, make sure the database is shutdown, if not, then the control files will be different versions...
good luck :)
as slightvw says, do : show parameter control_files
and make sure that for all the entries you are shown, there is a controlfile.
also, when copying them, make sure the database is shutdown, if not, then the control files will be different versions...
good luck :)
ASKER
hello experts
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> startup open
ORA-01031: insufficient privileges
SQL> connect system as sysdba
Enter password: ******
Connected to an idle instance.
SQL> startup open
ORACLE instance started.
Total System Global Area 143727516 bytes
Fixed Size 453532 bytes
Variable Size 109051904 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
SQL> show parameter control_files
NAME TYPE VALUE
-------------------------- ---------- ----------- -------------------------- ----
control_files string d:\ORANT\oradata\orcl\CONT ROL0
1.CTL,
d:\ORANT\oradata\orcl\CONT ROL0
2.CTL,d:\ORANT\oradata\orc l\CO
NTROL03.CTL,
c:\oratest\CONTROL03.CTL
do i have to stop the oracleservice ORCL before i copy the control file.
THIS SERVICE IS SET TO RUN AUTOMATIC AND I DID NOT STOP THE
SERVICE WHEN I CARRIED OUT RBROOKER INSTRUCTIONS.
thanks
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> startup open
ORA-01031: insufficient privileges
SQL> connect system as sysdba
Enter password: ******
Connected to an idle instance.
SQL> startup open
ORACLE instance started.
Total System Global Area 143727516 bytes
Fixed Size 453532 bytes
Variable Size 109051904 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
SQL> show parameter control_files
NAME TYPE VALUE
--------------------------
control_files string d:\ORANT\oradata\orcl\CONT
1.CTL,
d:\ORANT\oradata\orcl\CONT
2.CTL,d:\ORANT\oradata\orc
NTROL03.CTL,
c:\oratest\CONTROL03.CTL
do i have to stop the oracleservice ORCL before i copy the control file.
THIS SERVICE IS SET TO RUN AUTOMATIC AND I DID NOT STOP THE
SERVICE WHEN I CARRIED OUT RBROOKER INSTRUCTIONS.
thanks
>>do i have to stop the oracleservice ORCL before i copy the control file.
You don't have to stop the Windows service but you need to shutdown the instance before you copy the control file (or at least the DB has to be unmounted).
rbrooker mentioned this in his post:
"you will need to do this when the database is not mounted, then the controlfiles will be in sync..."
You also need to post the relevant section of the alert log.
You don't have to stop the Windows service but you need to shutdown the instance before you copy the control file (or at least the DB has to be unmounted).
rbrooker mentioned this in his post:
"you will need to do this when the database is not mounted, then the controlfiles will be in sync..."
You also need to post the relevant section of the alert log.
ASKER
hello slightwv
log results
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 4
Tue Dec 12 15:01:52 2006
All dispatchers and shared servers shutdown
Tue Dec 12 15:01:52 2006
alter database close normal
Tue Dec 12 15:01:53 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Dec 12 15:01:57 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 13
Successful close of redo thread 1.
Tue Dec 12 15:02:03 2006
Completed: alter database close normal
Tue Dec 12 15:02:03 2006
alter database dismount
Completed: alter database dismount
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Dump file d:\orant\admin\orcl\bdump\ alert_orcl .log
Tue Dec 12 15:12:36 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Tue Dec 12 15:12:36 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = d:\ORANT\oradata\orcl\CONT ROL01.CTL, d:\ORANT\oradata\orcl\CONT ROL02.CTL, d:\ORANT\oradata\orcl\CONT ROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_co unt= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\ORANT\admin\orcl\bdump
user_dump_dest = d:\ORANT\admin\orcl\udump
core_dump_dest = d:\ORANT\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enable d= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Dec 12 15:12:45 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PR OTOCOL=TCP ))'...
Tue Dec 12 15:12:47 2006
alter database mount exclusive
Tue Dec 12 15:12:49 2006
ORA-00202: controlfile: 'd:\ORANT\oradata\orcl\CON TROL01.CTL '
ORA-27086: skgfglk: unable to lock file - already in use
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
Tue Dec 12 15:12:49 2006
ORA-205 signalled during: alter database mount exclusive...
Shutting down instance (abort)
License high water mark = 3
Instance terminated by USER, pid = 2356
Dump file d:\orant\admin\orcl\bdump\ alert_orcl .log
Tue Dec 12 15:15:50 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Tue Dec 12 15:15:50 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = d:\ORANT\oradata\orcl\CONT ROL01.CTL, d:\ORANT\oradata\orcl\CONT ROL02.CTL, d:\ORANT\oradata\orcl\CONT ROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_co unt= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\ORANT\admin\orcl\bdump
user_dump_dest = d:\ORANT\admin\orcl\udump
core_dump_dest = d:\ORANT\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enable d= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Dec 12 15:16:27 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PR OTOCOL=TCP ))'...
Tue Dec 12 15:16:29 2006
alter database mount exclusive
Tue Dec 12 15:16:29 2006
ORA-00202: controlfile: 'd:\ORANT\oradata\orcl\CON TROL01.CTL '
ORA-27086: skgfglk: unable to lock file - already in use
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
Tue Dec 12 15:16:32 2006
ORA-205 signalled during: alter database mount exclusive...
Shutting down instance (abort)
License high water mark = 3
Instance terminated by USER, pid = 2376
Dump file d:\orant\admin\orcl\bdump\ alert_orcl .log
Tue Dec 12 15:22:00 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Tue Dec 12 15:22:00 2006
Starting ORACLE instance (normal)
Tue Dec 12 15:22:11 2006
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Tue Dec 12 15:22:35 2006
SCN scheme 2
Using log_archive_dest parameter default value
Tue Dec 12 15:23:10 2006
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Tue Dec 12 15:24:15 2006
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = d:\ORANT\oradata\orcl\CONT ROL01.CTL, d:\ORANT\oradata\orcl\CONT ROL02.CTL, d:\ORANT\oradata\orcl\CONT ROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_co unt= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\ORANT\admin\orcl\bdump
user_dump_dest = d:\ORANT\admin\orcl\udump
core_dump_dest = d:\ORANT\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enable d= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Dec 12 15:26:23 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PR OTOCOL=TCP ))'...
Tue Dec 12 15:26:53 2006
alter database mount exclusive
Tue Dec 12 15:27:02 2006
Successful mount of redo thread 1, with mount id 1136801982.
Tue Dec 12 15:27:02 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Dec 12 15:27:02 2006
alter database open
Tue Dec 12 15:27:06 2006
Thread 1 opened at log sequence 13
Current log# 3 seq# 13 mem# 0: D:\ORANT\ORADATA\ORCL\REDO 03.LOG
Successful open of redo thread 1.
Tue Dec 12 15:27:07 2006
SMON: enabling cache recovery
Tue Dec 12 15:27:18 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Dec 12 15:27:19 2006
SMON: enabling tx recovery
Tue Dec 12 15:27:19 2006
Database Characterset is WE8MSWIN1252
Tue Dec 12 15:27:29 2006
replication_dependency_tra cking turned off (no async multimaster replication found)
Completed: alter database open
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 5
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Dec 12 15:30:14 2006
ALTER DATABASE CLOSE NORMAL
Tue Dec 12 15:30:15 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Dec 12 15:30:15 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 13
Successful close of redo thread 1.
Tue Dec 12 15:30:17 2006
Completed: ALTER DATABASE CLOSE NORMAL
Tue Dec 12 15:30:17 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Dump file d:\orant\admin\orcl\bdump\ alert_orcl .log
Tue Dec 12 15:35:18 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Tue Dec 12 15:35:18 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = d:\ORANT\oradata\orcl\CONT ROL01.CTL, d:\ORANT\oradata\orcl\CONT ROL02.CTL, d:\ORANT\oradata\orcl\CONT ROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_co unt= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\ORANT\admin\orcl\bdump
user_dump_dest = d:\ORANT\admin\orcl\udump
core_dump_dest = d:\ORANT\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enable d= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Dec 12 15:35:22 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PR OTOCOL=TCP ))'...
Tue Dec 12 15:35:23 2006
alter database mount exclusive
Tue Dec 12 15:35:28 2006
Successful mount of redo thread 1, with mount id 1136801467.
Tue Dec 12 15:35:28 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Dec 12 15:35:28 2006
alter database open
Tue Dec 12 15:35:29 2006
Thread 1 opened at log sequence 13
Current log# 3 seq# 13 mem# 0: D:\ORANT\ORADATA\ORCL\REDO 03.LOG
Successful open of redo thread 1.
Tue Dec 12 15:35:29 2006
SMON: enabling cache recovery
Tue Dec 12 15:35:30 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Dec 12 15:35:30 2006
SMON: enabling tx recovery
Tue Dec 12 15:35:30 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tra cking turned off (no async multimaster replication found)
Completed: alter database open
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 4
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Dec 12 15:44:40 2006
ALTER DATABASE CLOSE NORMAL
Tue Dec 12 15:44:40 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Dec 12 15:44:41 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 13
Successful close of redo thread 1.
Tue Dec 12 15:44:43 2006
Completed: ALTER DATABASE CLOSE NORMAL
Tue Dec 12 15:44:43 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Dump file d:\orant\admin\orcl\bdump\ alert_orcl .log
Tue Dec 12 15:53:15 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Tue Dec 12 15:53:15 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = d:\ORANT\oradata\orcl\CONT ROL01.CTL, d:\ORANT\oradata\orcl\CONT ROL02.CTL, d:\ORANT\oradata\orcl\CONT ROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_co unt= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\ORANT\admin\orcl\bdump
user_dump_dest = d:\ORANT\admin\orcl\udump
core_dump_dest = d:\ORANT\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enable d= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Dec 12 15:53:20 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PR OTOCOL=TCP ))'...
Tue Dec 12 15:53:22 2006
alter database mount exclusive
Tue Dec 12 15:53:27 2006
Successful mount of redo thread 1, with mount id 1136742642.
Tue Dec 12 15:53:27 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Dec 12 15:53:27 2006
alter database open
Tue Dec 12 15:53:28 2006
Thread 1 opened at log sequence 13
Current log# 3 seq# 13 mem# 0: D:\ORANT\ORADATA\ORCL\REDO 03.LOG
Successful open of redo thread 1.
Tue Dec 12 15:53:28 2006
SMON: enabling cache recovery
Tue Dec 12 15:53:29 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Dec 12 15:53:30 2006
SMON: enabling tx recovery
Tue Dec 12 15:53:30 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tra cking turned off (no async multimaster replication found)
Completed: alter database open
Tue Dec 12 21:19:26 2006
Thread 1 advanced to log sequence 14
Current log# 1 seq# 14 mem# 0: D:\ORANT\ORADATA\ORCL\REDO 01.LOG
Thu Dec 07 08:00:13 2006
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 4
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Thu Dec 07 08:00:19 2006
alter database close normal
Thu Dec 07 08:00:20 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Dec 07 08:00:23 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 14
Successful close of redo thread 1.
Thu Dec 07 08:00:26 2006
Completed: alter database close normal
Thu Dec 07 08:00:26 2006
alter database dismount
Completed: alter database dismount
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Dump file d:\orant\admin\orcl\bdump\ alert_orcl .log
Thu Dec 07 08:00:38 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Thu Dec 07 08:00:38 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = d:\ORANT\oradata\orcl\CONT ROL01.CTL, d:\ORANT\oradata\orcl\CONT ROL02.CTL, d:\ORANT\oradata\orcl\CONT ROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_co unt= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\ORANT\admin\orcl\bdump
user_dump_dest = d:\ORANT\admin\orcl\udump
core_dump_dest = d:\ORANT\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enable d= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Thu Dec 07 08:00:41 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PR OTOCOL=TCP ))'...
Thu Dec 07 08:00:42 2006
alter database mount exclusive
Thu Dec 07 08:00:46 2006
Successful mount of redo thread 1, with mount id 1136311722.
Thu Dec 07 08:00:46 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Thu Dec 07 08:00:47 2006
alter database open
Thu Dec 07 08:00:48 2006
Thread 1 opened at log sequence 14
Current log# 1 seq# 14 mem# 0: D:\ORANT\ORADATA\ORCL\REDO 01.LOG
Successful open of redo thread 1.
Thu Dec 07 08:00:48 2006
SMON: enabling cache recovery
Thu Dec 07 08:00:49 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Thu Dec 07 08:00:49 2006
SMON: enabling tx recovery
Thu Dec 07 08:00:52 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tra cking turned off (no async multimaster replication found)
Completed: alter database open
thanks
log results
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 4
Tue Dec 12 15:01:52 2006
All dispatchers and shared servers shutdown
Tue Dec 12 15:01:52 2006
alter database close normal
Tue Dec 12 15:01:53 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Dec 12 15:01:57 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 13
Successful close of redo thread 1.
Tue Dec 12 15:02:03 2006
Completed: alter database close normal
Tue Dec 12 15:02:03 2006
alter database dismount
Completed: alter database dismount
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Dump file d:\orant\admin\orcl\bdump\
Tue Dec 12 15:12:36 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Tue Dec 12 15:12:36 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = d:\ORANT\oradata\orcl\CONT
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_co
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile=
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\ORANT\admin\orcl\bdump
user_dump_dest = d:\ORANT\admin\orcl\udump
core_dump_dest = d:\ORANT\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enable
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Dec 12 15:12:45 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PR
Tue Dec 12 15:12:47 2006
alter database mount exclusive
Tue Dec 12 15:12:49 2006
ORA-00202: controlfile: 'd:\ORANT\oradata\orcl\CON
ORA-27086: skgfglk: unable to lock file - already in use
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
Tue Dec 12 15:12:49 2006
ORA-205 signalled during: alter database mount exclusive...
Shutting down instance (abort)
License high water mark = 3
Instance terminated by USER, pid = 2356
Dump file d:\orant\admin\orcl\bdump\
Tue Dec 12 15:15:50 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Tue Dec 12 15:15:50 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = d:\ORANT\oradata\orcl\CONT
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_co
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile=
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\ORANT\admin\orcl\bdump
user_dump_dest = d:\ORANT\admin\orcl\udump
core_dump_dest = d:\ORANT\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enable
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Dec 12 15:16:27 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PR
Tue Dec 12 15:16:29 2006
alter database mount exclusive
Tue Dec 12 15:16:29 2006
ORA-00202: controlfile: 'd:\ORANT\oradata\orcl\CON
ORA-27086: skgfglk: unable to lock file - already in use
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
Tue Dec 12 15:16:32 2006
ORA-205 signalled during: alter database mount exclusive...
Shutting down instance (abort)
License high water mark = 3
Instance terminated by USER, pid = 2376
Dump file d:\orant\admin\orcl\bdump\
Tue Dec 12 15:22:00 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Tue Dec 12 15:22:00 2006
Starting ORACLE instance (normal)
Tue Dec 12 15:22:11 2006
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Tue Dec 12 15:22:35 2006
SCN scheme 2
Using log_archive_dest parameter default value
Tue Dec 12 15:23:10 2006
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Tue Dec 12 15:24:15 2006
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = d:\ORANT\oradata\orcl\CONT
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_co
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile=
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\ORANT\admin\orcl\bdump
user_dump_dest = d:\ORANT\admin\orcl\udump
core_dump_dest = d:\ORANT\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enable
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Dec 12 15:26:23 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PR
Tue Dec 12 15:26:53 2006
alter database mount exclusive
Tue Dec 12 15:27:02 2006
Successful mount of redo thread 1, with mount id 1136801982.
Tue Dec 12 15:27:02 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Dec 12 15:27:02 2006
alter database open
Tue Dec 12 15:27:06 2006
Thread 1 opened at log sequence 13
Current log# 3 seq# 13 mem# 0: D:\ORANT\ORADATA\ORCL\REDO
Successful open of redo thread 1.
Tue Dec 12 15:27:07 2006
SMON: enabling cache recovery
Tue Dec 12 15:27:18 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Dec 12 15:27:19 2006
SMON: enabling tx recovery
Tue Dec 12 15:27:19 2006
Database Characterset is WE8MSWIN1252
Tue Dec 12 15:27:29 2006
replication_dependency_tra
Completed: alter database open
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 5
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Dec 12 15:30:14 2006
ALTER DATABASE CLOSE NORMAL
Tue Dec 12 15:30:15 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Dec 12 15:30:15 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 13
Successful close of redo thread 1.
Tue Dec 12 15:30:17 2006
Completed: ALTER DATABASE CLOSE NORMAL
Tue Dec 12 15:30:17 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Dump file d:\orant\admin\orcl\bdump\
Tue Dec 12 15:35:18 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Tue Dec 12 15:35:18 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = d:\ORANT\oradata\orcl\CONT
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_co
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile=
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\ORANT\admin\orcl\bdump
user_dump_dest = d:\ORANT\admin\orcl\udump
core_dump_dest = d:\ORANT\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enable
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Dec 12 15:35:22 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PR
Tue Dec 12 15:35:23 2006
alter database mount exclusive
Tue Dec 12 15:35:28 2006
Successful mount of redo thread 1, with mount id 1136801467.
Tue Dec 12 15:35:28 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Dec 12 15:35:28 2006
alter database open
Tue Dec 12 15:35:29 2006
Thread 1 opened at log sequence 13
Current log# 3 seq# 13 mem# 0: D:\ORANT\ORADATA\ORCL\REDO
Successful open of redo thread 1.
Tue Dec 12 15:35:29 2006
SMON: enabling cache recovery
Tue Dec 12 15:35:30 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Dec 12 15:35:30 2006
SMON: enabling tx recovery
Tue Dec 12 15:35:30 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tra
Completed: alter database open
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 4
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Tue Dec 12 15:44:40 2006
ALTER DATABASE CLOSE NORMAL
Tue Dec 12 15:44:40 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Dec 12 15:44:41 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 13
Successful close of redo thread 1.
Tue Dec 12 15:44:43 2006
Completed: ALTER DATABASE CLOSE NORMAL
Tue Dec 12 15:44:43 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Dump file d:\orant\admin\orcl\bdump\
Tue Dec 12 15:53:15 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Tue Dec 12 15:53:15 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = d:\ORANT\oradata\orcl\CONT
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_co
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile=
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\ORANT\admin\orcl\bdump
user_dump_dest = d:\ORANT\admin\orcl\udump
core_dump_dest = d:\ORANT\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enable
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Tue Dec 12 15:53:20 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PR
Tue Dec 12 15:53:22 2006
alter database mount exclusive
Tue Dec 12 15:53:27 2006
Successful mount of redo thread 1, with mount id 1136742642.
Tue Dec 12 15:53:27 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Dec 12 15:53:27 2006
alter database open
Tue Dec 12 15:53:28 2006
Thread 1 opened at log sequence 13
Current log# 3 seq# 13 mem# 0: D:\ORANT\ORADATA\ORCL\REDO
Successful open of redo thread 1.
Tue Dec 12 15:53:28 2006
SMON: enabling cache recovery
Tue Dec 12 15:53:29 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Dec 12 15:53:30 2006
SMON: enabling tx recovery
Tue Dec 12 15:53:30 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tra
Completed: alter database open
Tue Dec 12 21:19:26 2006
Thread 1 advanced to log sequence 14
Current log# 1 seq# 14 mem# 0: D:\ORANT\ORADATA\ORCL\REDO
Thu Dec 07 08:00:13 2006
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 4
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Thu Dec 07 08:00:19 2006
alter database close normal
Thu Dec 07 08:00:20 2006
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Dec 07 08:00:23 2006
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 14
Successful close of redo thread 1.
Thu Dec 07 08:00:26 2006
Completed: alter database close normal
Thu Dec 07 08:00:26 2006
alter database dismount
Completed: alter database dismount
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Dump file d:\orant\admin\orcl\bdump\
Thu Dec 07 08:00:38 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Thu Dec 07 08:00:38 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = d:\ORANT\oradata\orcl\CONT
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_co
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile=
db_domain =
instance_name = orcl
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = d:\ORANT\admin\orcl\bdump
user_dump_dest = d:\ORANT\admin\orcl\udump
core_dump_dest = d:\ORANT\admin\orcl\cdump
sort_area_size = 524288
db_name = orcl
open_cursors = 300
star_transformation_enable
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Thu Dec 07 08:00:41 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PR
Thu Dec 07 08:00:42 2006
alter database mount exclusive
Thu Dec 07 08:00:46 2006
Successful mount of redo thread 1, with mount id 1136311722.
Thu Dec 07 08:00:46 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Thu Dec 07 08:00:47 2006
alter database open
Thu Dec 07 08:00:48 2006
Thread 1 opened at log sequence 14
Current log# 1 seq# 14 mem# 0: D:\ORANT\ORADATA\ORCL\REDO
Successful open of redo thread 1.
Thu Dec 07 08:00:48 2006
SMON: enabling cache recovery
Thu Dec 07 08:00:49 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Thu Dec 07 08:00:49 2006
SMON: enabling tx recovery
Thu Dec 07 08:00:52 2006
Database Characterset is WE8MSWIN1252
replication_dependency_tra
Completed: alter database open
thanks
This is a test database isn't it?
The important piece is:
ORA-00202: controlfile: 'd:\ORANT\oradata\orcl\CON TROL01.CTL '
ORA-27086: skgfglk: unable to lock file - already in use
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
Do you have more than 1 instance running on this machine? If not, my guess is that when you copied a live controlfile, Oracle still thinks it's open.
Find your user_dump_dest: show parameter user_dump_dest.
Then see if you can issue: alter database backup controlfile to trace;
If that executes, you should have a new trace file in the directory pointed to by user_dump_dest.
If you get that far, post back and we'll try rebuilding the control files.
The important piece is:
ORA-00202: controlfile: 'd:\ORANT\oradata\orcl\CON
ORA-27086: skgfglk: unable to lock file - already in use
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
Do you have more than 1 instance running on this machine? If not, my guess is that when you copied a live controlfile, Oracle still thinks it's open.
Find your user_dump_dest: show parameter user_dump_dest.
Then see if you can issue: alter database backup controlfile to trace;
If that executes, you should have a new trace file in the directory pointed to by user_dump_dest.
If you get that far, post back and we'll try rebuilding the control files.
ASKER
hello slightwv
this a test database
i am practicing for oracle exams
to be honest i have oracle 10g express edition on the same machine
but i disable the service in windows.
the results of the test you post
Connected to:
Personal Oracle9i Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> show parameter background_dump_dest
NAME TYPE VALUE
-------------------------- ---------- ----------- -------------------------- ----
background_dump_dest string d:\ORANT\admin\orcl\bdump
SQL> show parameter user_dump_dest
NAME TYPE VALUE
-------------------------- ---------- ----------- -------------------------- ----
user_dump_dest string d:\ORANT\admin\orcl\udump
SQL> alter database backup controlfile to trace;
Database altered.
p.s i have this serivce name oemrep running windows should i disable it
thanks
this a test database
i am practicing for oracle exams
to be honest i have oracle 10g express edition on the same machine
but i disable the service in windows.
the results of the test you post
Connected to:
Personal Oracle9i Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> show parameter background_dump_dest
NAME TYPE VALUE
--------------------------
background_dump_dest string d:\ORANT\admin\orcl\bdump
SQL> show parameter user_dump_dest
NAME TYPE VALUE
--------------------------
user_dump_dest string d:\ORANT\admin\orcl\udump
SQL> alter database backup controlfile to trace;
Database altered.
p.s i have this serivce name oemrep running windows should i disable it
thanks
Since this is just a test DB it will probably be better to just blow it away and rebuild it but since we've gone this far let's see if we can fix it.
Go to the udump directory and look for a trace file with a recent date. It should have the necessary SQL to create a controlfile.
Copy that file to some directory and edit it. There are 2 versions of the 'create controlfile' SQL in the file. You want the one that DOES NOT reset logs. Delete the SQL for the one that does the reset logs.
Then, run the script. This should create new controlfiles and you should be able to open the database.
Go to the udump directory and look for a trace file with a recent date. It should have the necessary SQL to create a controlfile.
Copy that file to some directory and edit it. There are 2 versions of the 'create controlfile' SQL in the file. You want the one that DOES NOT reset logs. Delete the SQL for the one that does the reset logs.
Then, run the script. This should create new controlfiles and you should be able to open the database.
ASKER
hello slightwv,
>> Go to the udump directory and look for a trace file with a recent date. It should have the necessary SQL to create a controlfile.
>> Copy that file to some directory and edit it. There are 2 versions of the 'create controlfile' SQL in the file. You want the one that DOES NOT reset logs. Delete the SQL for the one that does the reset logs.
when i copy the recent file and edit it this the contents
Dump file d:\orant\admin\orcl\udump\ orcl_ora_2 708.trc
Tue Dec 12 15:53:26 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Personal Oracle9i Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: orcl
Redo thread mounted by this instance: 0 <none>
Oracle process number: 12
Windows thread id: 2708, image: ORACLE.EXE
*** SESSION ID:(9.1) 2006-12-12 15:53:26.000
(blkno = 0x7a, size = 276, max = 1, in-use = 1, last-recid= 0)
(blkno = 0x7b, size = 56, max = 145, in-use = 1, last-recid= 1)
i cannot seem to find the two sql mention i am lost
need some directions
>> Go to the udump directory and look for a trace file with a recent date. It should have the necessary SQL to create a controlfile.
>> Copy that file to some directory and edit it. There are 2 versions of the 'create controlfile' SQL in the file. You want the one that DOES NOT reset logs. Delete the SQL for the one that does the reset logs.
when i copy the recent file and edit it this the contents
Dump file d:\orant\admin\orcl\udump\
Tue Dec 12 15:53:26 2006
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Personal Oracle9i Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: orcl
Redo thread mounted by this instance: 0 <none>
Oracle process number: 12
Windows thread id: 2708, image: ORACLE.EXE
*** SESSION ID:(9.1) 2006-12-12 15:53:26.000
(blkno = 0x7a, size = 276, max = 1, in-use = 1, last-recid= 0)
(blkno = 0x7b, size = 56, max = 145, in-use = 1, last-recid= 1)
i cannot seem to find the two sql mention i am lost
need some directions
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hello
the solution provide work like charm
thank u
the solution provide work like charm
thank u
What does the alert log show?
Also perform the following after the startup fails and post the results:
show parameter control_files;