Home » Infrastructure » Linux » ORA-01967: invalid option for create controlfile
ORA-01967: invalid option for create controlfile [message #166966] Mon, 10 April 2006 10:01 Go to next message
oradba16
Messages: 54
Registered: September 2005
Member
hi,
installing oracle 9i on suse linux 9
while i try to create database at no mount state i receive error

ORA-01967: invalid option for create controlfile

when i checked control file by issuing

show parameter control_files
----------------------------------------------------------------
conrol_files /home/oracle9i/contro/con.ctl

when i go to this path and checked there i cudn't find that file

i feel control file is missing........ i dont hav any backup control file.i did not mirrored that one also. now wat can i do now?
can ay one plz help me to solve this issue
Re: ORA-01967: invalid option for create controlfile [message #167382 is a reply to message #166966] Wed, 12 April 2006 14:55 Go to previous message
adrianp
Messages: 6
Registered: April 2006
Junior Member
You have a few options:

1. if the db is down, edit the initSID.ora file and specify the correct control file location


2. if the db is up, and you know the control file location, you can change the Oracle parameter

SQL> alter system set coltrol_files = '/path/to/file'


3. if the database is still up and mounted, you will want to create new control files with something like

SQL> alter database backup control file to '/path/to/file'


I do encourage you to get a copy of the documentation handy for any options you might need depending on your situation

Adrian


Previous Topic: ORACLE 8i INSTALLATION IN FEDORA CORE 4 GIVES ERROR
Next Topic: connect to linux
Goto Forum:
  


Current Time: Tue May 28 09:45:43 CDT 2024