Basic Oracle Concepts and Programming Question:
Download Job Interview Questions and Answers PDF
How To Connect the Oracle Server as SYSDBA?
Answer:
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
>.insqlplus /nolog
SQL> CONNECT / AS SYSDBA
Connected.
>cd $ORACLE_HOME
>.insqlplus /nolog
SQL> CONNECT / AS SYSDBA
Connected.
Download Oracle Database Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How To Create an Initialization Parameter File? | How To Create a Server Parameter File? |