-
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_home=/u01/app/oracle/ora90
set oracle_sid=test(name of second database)
sqlplus /nolog
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_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/oracle/product/10.2.0/db_1
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.
-
hi,
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.
export ORACLE_HOME=/u01/app/oracle/oracle/product/10.2.0/db_1
export ORACLE_SID=TEST
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|