Oracle - Connect to Oracle Server as SYSDBA in Oracle

Connect to Oracle Server as SYSDBA in Oracle

Q

How To Connect the Oracle Server as SYSDBA in Oracle?

✍: FYIcenter.com

A

This is Step 4. The best way to connect to the Oracle server as an administrator is to use SQL*Plus. You need to run SQL*Plus with /nolog option and use the CONNECT with blank user name, blank password and AS SYSDBA option. Here is a sample session:

>cd $ORACLE_HOME
>.\bin\sqlplus /nolog

SQL> CONNECT / AS SYSDBA
Connected.

⇒Creating New Database Instance Manually

⇒⇒Oracle Database Tutorials

2016-10-17, 334👍, 0💬

Popular Posts:

NULLIF() - Replacing...

How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...

ISNULL() - Replacing...

How To Replace NULL Values in Expressions using ISNULL() in SQL Server Transact-SQL? As you learned ...

Downloading and Inst...

Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...

sys.server_principal...

How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...

ISNULL() - Replacing...

How To Replace NULL Values in Expressions using ISNULL() in SQL Server Transact-SQL? As you learned ...