Home » RDBMS Server » Server Administration » connect to newly created database (10g, xp)
connect to newly created database [message #539445] Mon, 16 January 2012 01:26 Go to next message
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).
Re: connect to newly created database [message #539449 is a reply to message #539445] Mon, 16 January 2012 01:34 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Change your ORACLE_SID
Re: connect to newly created database [message #539450 is a reply to message #539445] Mon, 16 January 2012 01:34 Go to previous messageGo to next message
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
Re: connect to newly created database [message #539480 is a reply to message #539445] Mon, 16 January 2012 04:57 Go to previous message
emergingdba
Messages: 13
Registered: April 2011
Location: bangalore
Junior Member

Use either .oraenv or export command to set ORACLE_SID.
Previous Topic: Time remaining to complete table statistics
Next Topic: materialized view error
Goto Forum:
  


Current Time: Fri Mar 29 01:59:07 CDT 2024