Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I connect to an idle instance? 1

Status
Not open for further replies.

Rmcta

Technical User
Nov 1, 2002
478
US
According to my book, if I connect as follows:
Enter user-name: sys as sysdba
Enter password:

I should get "Connected to an idle instance"

but instead I just get:

Connected to:
Personal Oracle9i Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL>

Why? How do I connect to an idle instance?

Thank you for your help!
 
You have connected to ALREADY STARTED instance. Somebody (maybe even you) started it up earlier. You may issue SHUTDOWN IMMEDIATE and exit. If nobody starts it again before you next attempt, you may connect to an idle instance.

Regards, Dima
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top