| ORA-01967: invalid option for create controlfile [message #166966] |
Mon, 10 April 2006 10:01  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
