Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01033-Error
icon2.gif  ORA-01033-Error [message #314413] Wed, 16 April 2008 11:26 Go to next message
balaji23_d
Messages: 123
Registered: February 2007
Senior Member
Hi all,

After a long time, I work with toad, while i given the user name and password... Its giving me the error like "ORA-01033
Oracle Initialisation or shut down progress"

Please help me out to solve this error...

Re: ORA-01033-Error [message #314417 is a reply to message #314413] Wed, 16 April 2008 11:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at alert.log
Fix the problem.
Restart the database.

Regards
Michel
Re: ORA-01033-Error [message #314420 is a reply to message #314417] Wed, 16 April 2008 11:44 Go to previous messageGo to next message
balaji23_d
Messages: 123
Registered: February 2007
Senior Member
Hi michel,

Could u tell me where can i get the alert.log file in toad
Re: ORA-01033-Error [message #314423 is a reply to message #314420] Wed, 16 April 2008 11:49 Go to previous messageGo to next message
balaji23_d
Messages: 123
Registered: February 2007
Senior Member
Hi michel,

Yes michel, I found the log file.. But its giving me the error like

Wed Apr 16 21:18:55 2008
ORA-314 signalled during: alter database open...

But wht can i do this problem
Re: ORA-01033-Error [message #314430 is a reply to message #314423] Wed, 16 April 2008 12:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What are the other messages?
Post 15 lines before this one and 5 lines after.

Regards
Michel
Re: ORA-01033-Error [message #314439 is a reply to message #314430] Wed, 16 April 2008 12:32 Go to previous messageGo to next message
balaji23_d
Messages: 123
Registered: February 2007
Senior Member


Wed Apr 16 10:23:55 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Apr 16 10:24:11 2008
alter database mount exclusive
Wed Apr 16 10:24:27 2008
Successful mount of redo thread 1, with mount id 3324932363.
Wed Apr 16 10:24:28 2008
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Apr 16 10:24:29 2008
alter database open
Wed Apr 16 10:24:47 2008
Errors in file e:\orcl\admin\balaji\bdump\balaji_lgwr_2536.trc:
ORA-00314: log 1 of thread 1, expected sequence# 953 doesn't match 956
ORA-00312: online log 1 thread 1: 'E:\ORCL\ORADATA\BALAJI\REDO01.LOG'

Wed Apr 16 10:24:47 2008
Errors in file e:\orcl\admin\balaji\bdump\balaji_lgwr_2536.trc:
ORA-00314: log 1 of thread 1, expected sequence# 953 doesn't match 956
ORA-00312: online log 1 thread 1: 'E:\ORCL\ORADATA\BALAJI\REDO01.LOG'

Wed Apr 16 10:24:48 2008
ORA-314 signalled during: alter database open...
Dump file e:\orcl\admin\balaji\bdump\alert_balaji.log
Wed Apr 16 21:16:33 2008
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
Wed Apr 16 21:16:33 2008
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
Wed Apr 16 21:17:13 2008
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:\orcl\oradata\balaji\CONTROL01.CTL, E:\orcl\oradata\balaji\CONTROL02.CTL, E:\orcl\oradata\balaji\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 =
instance_name = balaji
dispatchers = (PROTOCOL=TCP) (SERVICE=balajiXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = E:\orcl\admin\balaji\bdump
user_dump_dest = E:\orcl\admin\balaji\udump
core_dump_dest = E:\orcl\admin\balaji\cdump
sort_area_size = 524288
db_name = balaji
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
Wed Apr 16 21:17:42 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Apr 16 21:18:04 2008
alter database mount exclusive
Wed Apr 16 21:18:32 2008
Successful mount of redo thread 1, with mount id 3324956495.
Wed Apr 16 21:18:32 2008
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Apr 16 21:18:39 2008
alter database open
Wed Apr 16 21:18:53 2008
Errors in file e:\orcl\admin\balaji\bdump\balaji_lgwr_3456.trc:
ORA-00314: log 1 of thread 1, expected sequence# 953 doesn't match 956
ORA-00312: online log 1 thread 1: 'E:\ORCL\ORADATA\BALAJI\REDO01.LOG'

Wed Apr 16 21:18:54 2008
Errors in file e:\orcl\admin\balaji\bdump\balaji_lgwr_3456.trc:
ORA-00314: log 1 of thread 1, expected sequence# 953 doesn't match 956
ORA-00312: online log 1 thread 1: 'E:\ORCL\ORADATA\BALAJI\REDO01.LOG'
Re: ORA-01033-Error [message #314441 is a reply to message #314439] Wed, 16 April 2008 12:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
ORA-00314: log string of thread string, expected sequence# string doesn"t match string
Cause: The online log is corrupted or is an old version.
Action: Find and install correct version of log or reset logs.

Regards
Michel
Re: ORA-01033-Error [message #314502 is a reply to message #314441] Wed, 16 April 2008 23:48 Go to previous messageGo to next message
balaji23_d
Messages: 123
Registered: February 2007
Senior Member
Hi,

Now I am getting another error

ORA-01034 : ORACLE not available
ORA-27101 : shared memory realm does not exist

please help me...
Re: ORA-01033-Error [message #314504 is a reply to message #314502] Wed, 16 April 2008 23:52 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Start reading some documents.
Start using Google.
Re: ORA-01033-Error [message #314512 is a reply to message #314502] Thu, 17 April 2008 00:37 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Fix the previous error.

Regards
Michel
Previous Topic: comparing two fields
Next Topic: to extract data
Goto Forum:
  


Current Time: Mon Dec 05 07:03:04 CST 2016

Total time taken to generate the page: 0.05619 seconds