Home » RDBMS Server » Server Administration » create control file wrong
create control file wrong [message #55964] Wed, 26 February 2003 19:35 Go to next message
dusong
Messages: 1
Registered: February 2003
Junior Member
machine: AIX 4.3.3
Oracle:8.1.7

I have create a database,and now I want to add a
control file,I do the next step:
1 shutdown
2 cp ctrl.1 ctrl.2
3 edit the init file,add the ctrl.2 to the file
4 startup

I get the next wrong message

ORACLE instance started.
Total System Global Area 28520340 bytes
Fixed Size 73620 bytes
Variable Size 25092096 bytes
Database Buffers 3276800 bytes
Redo Buffers 77824 bytes
ORA-27061: skgfospo: waiting for async I/Os failed
IBM AIX RISC System/6000 Error: 22: Invalid argument

when I rename a datafile,I get another wrong:

ORA-01114: IO error writing block to file 2 (block # 1)
ORA-01110: data file 2: '/home/dusong/data/app2.dat'
ORA-27091: skgfqio: unable to queue I/O
IBM AIX RISC System/6000 Error: 9: Bad file number
Additional information: 1

what happen?

thanks

Report message to a moderator

Re: create control file wrong [message #56009 is a reply to message #55964] Fri, 28 February 2003 16:05 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
OS errors #22 and #9 points to problems with your I/O writes to the disk(s) or storage. Make sure the controllers are not failing, there is a free disk space. Check the AIX logs to see what is causing writes to fail.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Archive logswitch every minute (Oracle 8.1.7)
Next Topic: Change Computer name after the Oracle installation!!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 28 21:00:12 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.