OraFAQ Forum: Server Administration » problem in creating database..........

Home » RDBMS Server » Server Administration » problem in creating database.......... (oracle 11gR2,oracle linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problem in creating database.......... [message #531727]

Thu, 17 November 2011 08:12

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

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Mahesh Rajendran
Messages: 10708
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

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.

Report message to a moderator

Re: problem in creating database.......... [message #538533 is a reply to message #538531]

Fri, 06 January 2012 13:04

John Watson
Messages: 8962
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

lynndba
Messages: 23
Registered: November 2011

Junior Member

what is your point? i dont see how it answers the question

Report message to a moderator

Re: problem in creating database.......... [message #538542 is a reply to message #538540]

Fri, 06 January 2012 15:25

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Previous Topic:	How partition can be brought offline
Next Topic:	view recompilation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 20:11:17 CST 2025