Solved

Oracle Server 9i is returning "ORA-01033: ORACLE initialization or shutdown in progress" error message after hard drive upgrade

Posted on 2003-10-31
2
2,471 Views
Last Modified: 2007-12-19
My server was running fine with Oracle Server 9i on Windows 2000 Server. Oracle installed on drive C and database files are located on drive E.

Yesterday I stopped oracle services,  backed up database files on drive E then I replaced drive E and restored the backup to the new drive E. But the server doesn't come up. every time I try to login I get thw error messgae "ORA-01033: ORACLE initialization or shutdown in progress". I removed the new drive and put back the old drive. But it still not working. my database is called "plines"

It is looking for a file name "REDO02.LOG" which doesn't exist even on the original database files on old drive. but "REDO01.LOG" does exist.

Here is dump file contects of my server :
==========================
Dump file c:\oracle\admin\plines\bdump\alert_plines.log
Fri Oct 31 12:47:16 2003
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Fri Oct 31 12:47:16 2003
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            = E:\oracle\oradata\PLINES\CONTROL01.CTL, E:\oracle\oradata\PLINES\CONTROL02.CTL, E:\oracle\oradata\PLINES\CONTROL03.CTL
  db_block_size            = 8192
  db_cache_size            = 25165824
  compatible               = 9.2.0.0.0
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 10800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = ARAMCO.COM.SA
  instance_name            = PLINES
  dispatchers              = (PROTOCOL=TCP) (SERVICE=PLINESXDB)
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = C:\oracle\admin\PLINES\bdump
  user_dump_dest           = C:\oracle\admin\PLINES\udump
  core_dump_dest           = C:\oracle\admin\PLINES\cdump
  sort_area_size           = 524288
  db_name                  = PLINES
  open_cursors             = 300
  star_transformation_enabled= 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
Fri Oct 31 12:47:20 2003
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Oct 31 12:47:21 2003
alter database mount exclusive
Fri Oct 31 12:47:25 2003
Successful mount of redo thread 1, with mount id 2561636633.
Fri Oct 31 12:47:25 2003
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Oct 31 12:47:25 2003
alter database open
Fri Oct 31 12:47:27 2003
Errors in file c:\oracle\admin\plines\bdump\plines_lgwr_2044.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'E:\ORACLE\ORADATA\PLINES\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Fri Oct 31 12:47:28 2003
Errors in file c:\oracle\admin\plines\bdump\plines_lgwr_2044.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'E:\ORACLE\ORADATA\PLINES\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

ORA-313 signalled during: alter database open...
0
Comment
Question by:alsaeed_s
  • 2
2 Comments
 
LVL 47

Accepted Solution

by:
schwertner earned 250 total points
ID: 9656895
use
STARTUP DATABASE NOMOUNT
ALTER DATABASE MOUNT

The following statement adds a new group of redo logs to the database:
ALTER DATABASE
ADD LOGFILE ('E:\ORACLE\ORADATA\PLINES\REDO02.LOG') SIZE 500K;

You can also specify the number that identifies the group using the GROUP option:

ALTER DATABASE
ADD LOGFILE GROUP 10 ('E:\ORACLE\ORADATA\PLINES\REDO02.LOG') SIZE 500K;

After that try to open the database.
0
 
LVL 47

Expert Comment

by:schwertner
ID: 9657000
Thanks!

Did it  succeed?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

948 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now