Oracle database and schema creation

Oracle Installation and Configuration:

The Oracle 10g CD contains folder: Oracle 10g

Under that there are 2 folders:

1. Oracle 10g Client
2. Oracle 10g Server

First install Oracle Server. Go into Oracle 10g\Oracle 10g Server\10g_win32_db\Disk1

Click on Setup.exe

Remember to choose the installation in a drive that has disk space say C Drive.

Default installation does not allow you to change the location.

Advance installation allows you to change the location.

Next install Oracle Client. It is under: Oracle 10g\Oracle 10g Client

There are 2 versions and we want to install the latest version. The latest version is under: Oracle 10g\Oracle 10g Client\10201_client_win32

Go into: Oracle 10g\Oracle 10g Client\10201_client_win32\client and click Setup.exe

Choose the Administrator radio button for installation of the Administrator components can continue.

Next you have to create a Database Instance

Name it: <INSTANCE NAME>

For all the sys/system etc passwords give: <password>

Choose the following program from Start Menu to create a Database Instance:

 

THIS IS THE IMPORTANT SCREEN

Then continue further as usual and create the database.Under this instance <INSTANCE> create different schemas for different projects

Schema creation should be preceded by User creation using Enterprise Management Console:

Once you start the Enterprise Management Console, a command window starts. Do not close it.

Add your Instance to the Tree.Login into it as user sys with sysdba and password as <PASSWORD>.

To Create user go as specified below, right click and create the user. The Role and System tab should be set with the proper privileges for the user









Note: BE SURE TO GET THE Tick Mark in blue before saving it