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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How Can I Open Database with SQL Plus
- Thread starter rr3news
- Start date
SantaMufasa
Technical User
By the term, "Open", I presume you mean "startup". For that, you must be connected to the Oracle instance (via SQL*Plus, for example) with "special" DBA privileges called, "sysdba". Here is a sample session (connecting to a downed database) that illustrates the method:
To be able to "connect / as sysdba", your operating system login must be a member of the Oracle DBA group.
There are differing methods to confirm DBA group membership depending upon whether you are using Windose or *nix. Let us know if you need assistance in determining that issue.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
Code:
sqlplus /nolog
SQL> connect / as sysdba
connected to an idle instance.
SQL> startup
(...Oracle's startup confirmations...)There are differing methods to confirm DBA group membership depending upon whether you are using Windose or *nix. Let us know if you need assistance in determining that issue.
Mufasa(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]
- Status
Similar threads
