How to create database manually in oracle | manual db creation in oracle

Even if your company standardizes on using the GUI tools, such as #DBCA, it would be a good idea to create a #database manually at least once, not only to help you with this test (although it will help you to pass this portion of the exam), but so that you have an idea of what the #DBCA is doing behind the scenes. This knowledge will help you to make more informed decisions in creating your databases, going forward, regardless of how you create them.

00:00 Intro
00:41 Create parameter file
03:23 Create directories
04:29 Set $ORACLE_SID
05:18 CREATE DATABASE
11:48 Post DB creation scripts
13:24 Update /etc/oratab
15:52 oraenv utility

[synthmania]

After searching finally found the script :). Thank you 🙏 so much!

[jhansivadakapuram]

Finally I found good video..Thanks for your efforts 👍

[dharmarawcase]

Thank You DBA Genesis(Arun Kumar) for this execellent helpful video

[mohammedwahid]

As usual excellent explanation by Arun Kumar again

[shivanshu]

u r an awesome person... awesome tutorials man!!!!

[kisna]

Execellent Tutorial! Very well explained all the points .. appriaciated your efforts! Thank you :)

[pulakkhearu]

While I am connecting to SQL by sqlplus / as sysdba it's showing command not found. As there is no database running in the server, i hv checked from ps -ef | grep pmon.. what could be the reason??

[balajikarthik]

Very Good and clear explanation of DB creation. Thank U

[avngers]

Excellent tutorial..😍
but i am confused, how does the control files got created??..does it got created automatically from pfile parameter?

[pulakkhearu]

Sir do we need to create directory for IFILE also??

[mandarjoshi]

On which location we have to pest pfile

[MrBunroy]

Hi, im facing this kind error .

ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

can you help solve it?