Connect Oracle Database AS SYSDBA Tutorial Example

How To Connect Oracle Database Server AS SYSDBA Tutorial Example

-- Oracle Client Location: C:\oraclexe\app\oracle\product\10.2.0\server\BIN\sqlplus.exe
-- ORACLE_SID: xe
-- username: sys
-- password: sys

-- modify your client location, oracle sid, username, password accordingly.
-- i am using sqlplus as client. you can use anything as you like.
 

Run MS-DOS command prompt then copy & paste the below code to Connect to Oracle Database Server AS SYSDBA Example

   set ORACLE_SID=xe
   C:\oraclexe\app\oracle\product\10.2.0\server\BIN\sqlplus.exe sys/sys@xe as sysdba
      -- that's it!! we are connected to oracle database as sysdba using the above mentioned credentials
      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How To Connect Oracle Database Server AS SYSDBA Tutorial Example - Result in MS-DOS SQLPLUS Client Tools

 

Related Tutorial Examples

  1. How To Unlock HR Account in Oracle Database Tutorial Example
  2. How To Connect Oracle Database Server Tutorial Example
  3. How To Show User Tables In Oracle Database Tutorial Example
  4. How To Create USER In Oracle Database Tutorial Example
  5. How To Drop USER In Oracle Database Tutorial Example
  6. MySQL NULLIF() Nested Function Example
  7. MySQL Stored Procedure: Variable Example
  8. MySQL Database Script: Create Database using SQL Statement Example
  9. 19 Examples to Learn MySQL
  10. 20 Steps to Learn CakePHP by Example

No comments:

Post a Comment

leave your comments here..