Oracle 11GR2 Installation # Part 5

How to create Database manually.
Asuming that Oracle Software has been installed properly. check other videos if you haven't.

Check the oracle contents and Oracle SID, other parameters in the bash_Profile.

Step 1 of this video Pre-requisites are completed.
Step 2:Go to the dbs directory. copy the file initSID.ora
Modify the directories and names accordingly as shown in the video. Save the file

Step 3: Create all the new directories using mkdir -p command. Verify the directory structure.

Step 4: We need to create the database. Make sure there aren't any oracle processes. Careful that there are no oracle processes.
Start the database in nomount state.
Check the contents of the script. Prepare one script as such with your names and directories.
Keeping higher values temporarily for speedy installation process.
Control file reuse is a good option which helps in rerunning the scripts.

Execute this file with @createdb. Sit back and db to be created. DB got created in 1min.

Step 5: Creating internal views and giving privileges. Check and create other script with the information provided. Contents are not as customized to earlier one. You can simply copy and execute this.

Once all these scripts are completed. You can check the objects and do basic checking for the health of the Database.

Enjoy the installation series.
Subscribe to this channel to get more and more better videos.
Leave comments for your Database preparation.

Thanks for your time..
This is Kiran Signing Off