DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2009

    ORA-00205:can't identify control file check alert log for more info

    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?

  2. #2
    Join Date
    Jul 2002
    Lake Worth, FL

    Cool 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

  3. #3
    Join Date
    Mar 2001
    For creating more than 1 databases in same server you should need to set environment variable every time for new databases.
    Thanks and Regards,
    Gitesh Trivedi
    Dbametrix Solutions
    Database DBA support

  4. #4
    Join Date
    Nov 2009
    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.

  5. #5
    Join Date
    Aug 2009
    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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.