To register for an Internet.com membership to receive newsletters and white papers, use the Register button ABOVE.
To participate in the message forums BELOW, click here

HOME 11g Central 10g Central 9i Central 8i Central Oracle News Scripts FAQ OCP Zone Resources Database Journal

Go Back   DBAsupport.com Forums > Oracle Forums > Oracle Database Administration

Reply Post New Thread
 
Thread Tools Rate Thread Display Modes
  #1  
Old 11-12-2009, 09:32 AM
saikatrana saikatrana is offline
Junior Member
 
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?
Reply With Quote
  #2  
Old 11-13-2009, 02:25 PM
LKBrwn_DBA's Avatar
LKBrwn_DBA LKBrwn_DBA is offline
Senior Advisor
 
Join Date: Jul 2002
Location: Lake Worth, FL
Posts: 1,192
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
Reply With Quote
  #3  
Old 11-18-2009, 04:34 PM
giteshtrivedi giteshtrivedi is offline
Junior Member
 
Join Date: Mar 2001
Location: India
Posts: 43
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
Reply With Quote
  #4  
Old 11-19-2009, 01:29 AM
saikatrana saikatrana is offline
Junior Member
 
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.
Reply With Quote
  #5  
Old 11-19-2009, 09:24 PM
Rayyah's Avatar
Rayyah Rayyah is offline
Junior Member
 
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
Reply With Quote
Reply Post New Thread

Bookmarks

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump


All times are GMT -4. The time now is 08:25 AM.


DBAsupport.com Recent Articles


 » Configuring Oracle as a Data Source for SQL Server

 » When tuning Oracle is not an option

 » Leveraging Logical Standby Databases in Data Guard

 » Building an Oracle Server Environment

 » Oracle 11g Security – Guidelines for Auditing

Search DBAsupport:
 


Click Here to Expand Forum to Full Width











Acceptable Use Policy


The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.