Collections:
Login to Server without an Instance in Oracle
How To Login to the Server without an Instance in Oracle?
✍: 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 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.
⇒ Start the Default Instance in Oracle
⇐ StartDB.bat Failed to Start the XE Instance in Oracle
2020-09-15, 1633🔥, 0💬
Popular Posts:
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...