Monday 16 May 2016

Create and Configure a Database using Database Configuration Assistant(DBCA).

Go to following location :

      ORACLE_HOME/bin 

 

Execute below command :

     ./dbca.sh (If database is installed on Linux)
     ./dbca.bat (If database is installed on Windows)


Click on Next.



Select "Create a Database" and then click Next.



 Click on Next.




Enter SID and the click Next.



Click on Next.




Set Schema password and then click Next.

 

 

Click on File Location Variable.

 

 

Here you can see DB variable's location and values.

 

 

Click Finish.

 

 

Click Next.

 

 

Click Next.

 

 

Go to Character Sets tab.

 

 

Here you can specify Character Set for this database.

Note : For Oracle Identity Management, it has to be "AL32UTF8".

 

 

Also you can change DB Initialization Parameters like open_cursors, processes, etc.

 

 

Click Next.

 

 

Click Next.

 

 

Click Finish.

 

 

Say OK.



 

 

Database is being created.

 

 

Database is installed and configured successfully.

 

 

Click Exit.




Happy Learning!!!

1 comment: