Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Login to the Server without an Instance
How To Login to the Server without an Instance? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition
✍: FYIcenter.com
If your default instance is in trouble, and you can not use the normal login process to reach the server, you can use a special login to log into the server without any instance. Here is how to use SQL*Plus to log in as as a system BDA:
>cd (OracleXE home directory) >.\bin\startdb >.\bin\sqlplus Enter user-name: SYSTEM/fyicenter AS SYSDBA Connected to an idle instance SQL> show instance instance "local"
The trick is to put user name, password and login options in a single string as the user name. "AS SYSDBA" tells the server to not start any instance, and connect the session the idle instance.
Log in as SYSDBA is very useful for performing DBA tasks.
2007-04-24, 5198👍, 0💬
Popular Posts:
What is CAR (Causal Analysis and Resolution)? The basic purpose of CAR is to analyze all defects, pr...
How To Give a User Read-Only Access to a Database? - MySQL FAQs - Managing User Accounts and Access ...
How To Decrement Dates by 1? - MySQL FAQs - Introduction to SQL Date and Time Handling If you have a...
What Happens If a Hyper Link Points to a Music File? - XHTML 1.0 Tutorials - Understanding Hyper Lin...
Can two catch blocks be executed? No, once the proper catch section is executed the control goes fin...