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

Popular Posts:

Using SELECT Stateme...

Can SELECT Statements Be Used on Views in SQL Server? Select (query) statements can be used on views...

Managing Security, L...

Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...

Error: Lock Wait Tim...

What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...

Calculating Age in D...

How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...

Creating Multi-State...

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