Home » RDBMS Server » Server Administration » problem in creating database.......... (oracle 11gR2,oracle linux)
icon4.gif  problem in creating database.......... [message #531727] Thu, 17 November 2011 08:12 Go to next message
crazylith
Messages: 1
Registered: November 2011
Location: chennai
Junior Member
Yesterday i installed oracle 11g r2 by default i installed database orcl with the installation .but today i tried to create the database with the name green tat also completed sucessfully
the problem is in startup


export oracle_sid=green
sqlplus '/ as sysdba'

startup

database mounted

select instance_name from v$instance;

BUt it SHowing the instance name as orcl

i tried with the other method also

export oracle_sid=green
sqlplus /nolog
conn sys/b123 as sysdba

database mounted

select instance_name from V$parameter;

and it shows instance name as green

i tried to see the datafile location for green database

select file_name from dba_data_files;

it shows the orcl datafile locations.....

[Updated on: Thu, 17 November 2011 08:15] by Moderator

Report message to a moderator

Re: problem in creating database.......... [message #531731 is a reply to message #531727] Thu, 17 November 2011 08:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you want an answer then do NOT mug readers with a bold red size 6 font but read and follow OraFAQ Forum Guide.

Regards
Michel

[Updated on: Thu, 17 November 2011 08:17]

Report message to a moderator

Re: problem in creating database.......... [message #531735 is a reply to message #531727] Thu, 17 November 2011 08:21 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
And just explaining what you did rarely helps us.
Always please post your session. Just copy and paste. Please use code tags.

[Updated on: Thu, 17 November 2011 08:22]

Report message to a moderator

Re: problem in creating database.......... [message #538531 is a reply to message #531727] Fri, 06 January 2012 12:55 Go to previous messageGo to next message
lynndba
Messages: 23
Registered: November 2011
Junior Member
Hi

Verify that you created the database properly ie both databases exist it check the files. orcl is the default database so when you conn sqlplus it connects to that. If you are using windows at the command prompt, type set oracle_sid=green hit enter and verify by typing set oracle_sid it would tell you that oracle_sid is green.
On linux do . oraenv and type green.
Re: problem in creating database.......... [message #538533 is a reply to message #538531] Fri, 06 January 2012 13:04 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
The environment variable oracle_sid is not the same as the variable ORACLE_SID.

update: Arrrghhh! I fell for the "revival of an ancient topic" ploy! Sorry, folks.

[Updated on: Fri, 06 January 2012 13:06]

Report message to a moderator

Re: problem in creating database.......... [message #538540 is a reply to message #538533] Fri, 06 January 2012 14:48 Go to previous messageGo to next message
lynndba
Messages: 23
Registered: November 2011
Junior Member
what is your point? i dont see how it answers the question
Re: problem in creating database.......... [message #538542 is a reply to message #538540] Fri, 06 January 2012 15:25 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It does.
>>export oracle_sid=green
is invalid and
ORACLE_SID is valid. The case matters a lot.
That is why we always ask
Quote:
And just explaining what you did rarely helps us.
Always please post your session. Just copy and paste.
Previous Topic: How partition can be brought offline
Next Topic: view recompilation
Goto Forum:
  


Current Time: Thu Mar 28 23:52:47 CDT 2024