Home » SQL & PL/SQL » SQL & PL/SQL » oracle log in error
oracle log in error [message #205490] Sat, 25 November 2006 04:00 Go to next message
sathyam2627
Messages: 52
Registered: November 2006
Member
hi,

when i am login in by using sysdba password its getting connected and whenever trying to startup the database its giving an error message, please help me regarding this


SQL> startup
ORACLE instance started.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
ORA-00204: error in reading (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'F:\ORACLE\ORADATA\SATHYA\CONTROL03.CTL'
ORA-27091: skgfqio: unable to queue I/O
ORA-27070: skgfdisp: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 23) Data error (cyclic redundancy check).



and if i am entering into user id its giving a error message
ora-01033:shutdown or intializing in progrss

kindly help me out regarding this


regards,
sathya
Re: oracle log in error [message #205525 is a reply to message #205490] Sat, 25 November 2006 07:01 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

you face problem with ur disk may be ur disk is not online or ur control file is currpted.

solution..you have to restore ur recent control file from bkp and startup ur database

if you have no control file bkp then create new control file.

go through below link how to create control file.

http://www.orafaq.com/forum/m/204217/93410/#msg_204217


hope this helps
Taj
Re: oracle log in error [message #205968 is a reply to message #205525] Tue, 28 November 2006 04:23 Go to previous messageGo to next message
sathyam2627
Messages: 52
Registered: November 2006
Member
hi,

thanks for your valuable assistance


i tried to implement the same which you have mentioned in the link to create controlfile but i am getting an error,

if you dont mind can you send a detail note regarding this because i am new to this environment and i am getting error message as follows..



SQL> ed
Wrote file afiedt.buf

1 CREATE CONTROLFILE REUSE DATABASE "sathya" NORESETLOGS ARCHIVELOG
2 MAXLOGFILES 5
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 10
5 MAXINSTANCES 1
6 MAXLOGHISTORY 113
7 LOGFILE
8 GROUP 1 'f:\ORACLE\ORADATA\sathya\REDO01.LOG' SIZE 10M,
9 GROUP 2 'f:\ORACLE\ORADATA\sathya\REDO02.LOG' SIZE 10M,
10 GROUP 3 'f:\ORACLE\ORADATA\sathya\REDO03.LOG' SIZE 10M
11 DATAFILE
12 'f:\ORACLE\ORADATA\sathya\SYSTEM01.DBF'size 440m,
13 'f:\ORACLE\ORADATA\sathya\USERS01.DBF' size 5m, 'f:\ORACLE\ORADATA\orcl\Undotbs01.DBF' size 45m
14 'f:\ORACLE\ORADATA\sathya\sysaux01.DBF' size 210m,
15 'f:\ORACLE\ORADATA\sathya\example01.DBF' size 150m
16* CHARACTER SET WE8MSWIN1252
SQL> /
CREATE CONTROLFILE REUSE DATABASE "sathya" NORESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01163: SIZE clause indicates 56320 (blocks), but should match header 51200
ORA-01110: data file 1: 'f:\ORACLE\ORADATA\sathya\SYSTEM01.DBF'



Re: oracle log in error [message #205982 is a reply to message #205968] Tue, 28 November 2006 04:56 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hello

SYSTEM01.DBF'size 440m,

due to wrong size specified.
Just specify right size.

simple way
right click on system01.dbf and check what is right size.. and specified in ur control files.

according to system01.dbf file you should check every file like undo.. sysaux... example..

hope this helps
Taj

Re: oracle log in error [message #205989 is a reply to message #205982] Tue, 28 November 2006 05:09 Go to previous messageGo to next message
sathyam2627
Messages: 52
Registered: November 2006
Member
hi

thank you,


in oradata folder sysaux01.DBF is not there can i write the query
by leaving the corresponding statement


regards,
sathya
Re: oracle log in error [message #206006 is a reply to message #205989] Tue, 28 November 2006 06:07 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi

are you sure there is not sysaux.dbf file...

check again.

and create ur control file remaning all files. ( exists files).
and try open ur database .. bcoz i am not sure if you lost ur sysaux.dbf file and i don't think you can open ur database with new control file.
you have to perform recovery from recent bkp...
i hope you have most recently bkp.

hope this helps
Taj.


Previous Topic: regarding ROLE
Next Topic: A small clarification regd update statement.
Goto Forum:
  


Current Time: Thu Dec 08 08:40:22 CST 2016

Total time taken to generate the page: 0.09522 seconds