| ora-00205: error in identifying control files [message #98721] |
Sat, 17 August 2002 07:53  |
Nasar
Messages: 2
Registered: August 2002
|
Junior Member |
|
|
hai guys!
i have installed oracle 8.1.6 in redhat7.2.
1. my first problem is in oracle installation, when it comes to net8 configuration, the screen hangs, and no more changes. please let me know how to resume my net8 configuration.
2. second, after killing the instalation processes, i copied $ORACLE_HOME/dbs/init.ora to $ORACLE_HOME/dbs/initoralin.ora
then i issued as follows
#connect internal
startup open pfile=$ORACLE_HOME/dbs/initoralin.ora;
and it gives the following error,
ORA-00205: error in identifying controlfile, check alert log for more info
|
|
|
|
| Re: ora-00205: error in identifying control files [message #98790 is a reply to message #98721] |
Mon, 13 January 2003 03:06  |
viet nam
Messages: 1
Registered: January 2003
|
Junior Member |
|
|
Your control file may be not avaible. You just create your control files, but you must know well, where are all your data files.
Do the following seps :
1 - $SQLPLUS / NOLOG
2 - Connect sys/password_sys as sysdba
3 - startup nomount pfile=$ORACLE_HOME/.../init.ora
4 - Execute this script (you must change the datafile by yours)
CREATE CONTROLFILE SET DATABASE 'OCP'
NORESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXDATAFILES 16
MAXINSTANCES 1
MAXLOGHISTORY 1630
LOGFILE
GROUP 1 'C:ORACLEORADATAOCPREDO01.LOG' SIZE 100K,
GROUP 2 'C:ORACLEORADATAOCPREDO02.LOG' SIZE 100K,
GROUP 3 'C:ORACLEORADATAOCPREDO03.LOG' SIZE 100K
DATAFILE
'C:ORACLEORADATAOCPSYSTEM01.DBF',
'C:ORACLEORADATAOCPUNDOTBS01.DBF',
'C:ORACLEORADATAOCPCWMLITE01.DBF',
'C:ORACLEORADATAOCPDRSYS01.DBF',
'C:ORACLEORADATAOCPEXAMPLE01.DBF',
'C:ORACLEORADATAOCPINDX01.DBF',
'C:ORACLEORADATAOCPODM01.DBF',
'C:ORACLEORADATAOCPTOOLS01.DBF',
'C:ORACLEORADATAOCPUSERS01.DBF',
'C:ORACLEORADATAOCPXDB01.DBF'
CHARACTER SET WE8MSWIN1252
;
5 - ALTER DATABASE OPEN RESETLOGS;
Good luck ;
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
