OraFAQ Forum: Server Administration » connect to newly created database

Home » RDBMS Server » Server Administration » connect to newly created database (10g, xp)

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

connect to newly created database [message #539445]

Mon, 16 January 2012 01:26

Bilal Khan
Messages: 128
Registered: April 2010
Location: Pakistan

Senior Member

Hello Every Body.
i create new database (Student) using command line, now i want to connect with newly created database (using sys as sysdba), but again it directly connected with old database (ORCL).
So what should i do to connect with newly created database (Student).

Report message to a moderator

Re: connect to newly created database [message #539449 is a reply to message #539445]

Mon, 16 January 2012 01:34

cookiemonster
Messages: 13968
Registered: September 2008
Location: Rainy Manchester

Senior Member

Change your ORACLE_SID

Report message to a moderator

Re: connect to newly created database [message #539450 is a reply to message #539445]

Mon, 16 January 2012 01:34

Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku

Senior Member

You need to set ORACLE_SID environment variable before connecting to the database

Report message to a moderator

Re: connect to newly created database [message #539480 is a reply to message #539445]

Mon, 16 January 2012 04:57

emergingdba
Messages: 13
Registered: April 2011
Location: bangalore

Junior Member

Use either .oraenv or export command to set ORACLE_SID.

Report message to a moderator

Previous Topic:	Time remaining to complete table statistics
Next Topic:	materialized view error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 30 16:20:50 CDT 2025