Login to Server without an Instance in Oracle

Q

How To Login to the Server without an Instance in Oracle?

✍: FYIcenter.com

A

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 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.

 

Introduction to Oracle Database 10g Express Edition

⇒⇒Oracle Database Tutorials

2016-10-16, 198👍, 0💬