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, duration hours minute second in high quality that is uploaded to the channel Sam Dhanasekaran 19 February 2013. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 6,263 times and liked it 13 visitors.