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, 164👍, 0💬

Popular Posts:

CAST() - Converting ...

How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...

DATEADD() Function U...

How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...

Oracle Database Tuto...

Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...

RAND() - Generating ...

How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...

Creating Multi-State...

How To Create an Multi-Statement Table-Valued Function in SQL Server Transact-SQL? To create a multi...