Create a database

Pre-requisite : Make sure Exceed is running in the background.

export ORACLE_SID=
export ORACLE_HOME=
export DISPLAY=ip address(get it from the command prompt using the command ipconfig):0.0
Check whether xterm is working or not..
In AIX, go to location /usr/bin/X11 and type xterm.. you should be able to see a small window pop up
In Linux, /usr/X11R6/bin.
In Sun Solaris, /usr/openwin/bin.
In any location, type dbca





Click "next"





Click "Create a database"






Click "General Purpose or Transaction Processing" and click "next"






Enter the global database name and SID and click "next"







Click "next"


Enter the passwords and click "next"

Select storage type as "ASM" or "Filesystem"

Select "use Oracle Managed Files" and select the available disk group.

click "next"

It will ask for the ASMSNMP password specific to ASM; give the password.
click "ok"


Choose the recovery options for the database: skip and click "next"


click on "sample schemas" and click "next"

Initialization parameters:just click on "typical"
tick "automatic memory management"

click "next"

Database storage: skip and click "next"

Select the database creation options
Select "Create a database"

Click "finish"

It will ask for confirmation. Click "ok"


You can see the progress bar simultaneously while the database is getting created.

You can skip "Password Management" and click "exit"


now you will be able to see the database added. do a ps -ef | grep pmon


I guess by default , the database size will be 2 GB.

If you want to increase the database size, then increase the size of the datafiles or make the datafiles autoextend on.