ORA-00205:can't identify control file check alert log for more info
I am using oracle 10g release 2(10.2.0.1) in rhel4.
actually I am using rhel5 but i have changed entry in /etc/redhat-release:
.........redhat enterprise linux 4 (tikanga)
my problem is:
when I manually create a database(second database) then my automatically created database(first database,created during software installation) gets this above error(ora-00205)
after instance being started in nomount mode and doesn't mount.
during manually creation of second database,i have used these lines:
set oracle_sid=test(name of second database)
does these lines have errors?
should I use 'export' instead of 'set'?
in addition,I want to state that in /etc/oratab file,I have only first database related line but not any info about 2nd database.
I have used in .bash_profile during first database installation(during software installation):
export ORACLE_SID=orcl(1st database)
Now what can I do?
Same old, same old...
Use the same commands from the .bash_profile except "export ORACLE_SID=test".
Then try to create the second database.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
For creating more than 1 databases in same server you should need to set environment variable every time for new databases.
thanks for ur response.but i am confused about what and how environment variables I should set in case of 2 database creation on the same server.kindly show me with an example.
You are a danger to your company and their data.
Click Here to Expand Forum to Full Width