Database creation using DBCA

>cat /etc/sysctl.conf -->to see the kernal parameters.

                >cat /etc/security/limits.conf --> to see the limits for the user accounts.

1.creating a directory

                >mkdir -p /u02/app/oracle

                >chown -R oracle:oinstall /uo2/app/oracle

                >chmod -R 775 /u02/app/oracle

                >su - oracle

                >which dbca --> to find the DBCA file location

                >pwd

                >dbca --> we can execute from the current directory because we configured .bash_profile.

                >xhost +

                >su - oracle

                >dbca

2.select "create database" and select "general purpose or transaction processing".

3.specify the database name.

4.deselect "configure Enterprise Manager"

5.check "use the same Administrative password for all the accounts"

6.select "use common location for all the database files". Browse and select the location to

install.

7.enable "Enable Archieving" with "specify Fast Recovery Area"

8.select "Sample Schemas"  (optional)

 

                >ps -ef|grep smon  --> to see the instances which are up and running

                >cat /etc/oratab

                >export ORACLE_HOME = hrms

                >sqlplus / as sysdba

                >shutdown immediate