ORA-00205:can't identify control file check alert log for more info
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

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

  1. #1
    Join Date
    Nov 2009
    Posts
    2

    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?

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,460

    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
    Location
    India
    Posts
    57
    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
    Posts
    2
    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.

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