How to login to an Oracle Database - Database Tutorial 40

Published: 19 February 2013
on channel: Sam Dhanasekaran
6,263
13

Video 40 How to login to an Oracle Database - Database Tutorial

This tutorial explains how to login to the Oracle Database from within the host where the database has been installed.

We need to set the environments first. The two parameters needed are, ORACLE_SID and ORACLE_HOME.

In Windows environment, we setup these parameters using SET command.

For example: set ORACLE_SID=demodb
In most of the UNIX we can do the same using the following command.
export ORACLE_SID=demodb

Once these parameters have been set, we can login to the database as SYSDBA using the following commands.

sqlplus /nolog
connect / as sysdba;


Watch video How to login to an Oracle Database - Database Tutorial 40 online without registration, duration hours minute second in high quality. This video was added by user Sam Dhanasekaran 19 February 2013, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6,263 once and liked it 13 people.