I am using oracle 10g release 2( 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?