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,481 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 48

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 48

Expert Comment

by:schwertner
ID: 9657000
Thanks!

Did it  succeed?
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

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…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses

623 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