2. Create Database with DBCA in Oracle 11g

After Oracle Database Software 11.2.0.3 installation we will create database with command dbca...

[oracle@test ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/bin

[oracle@test ~]$ ./dbca

1. Click next for to start the process....

2. Select Create a database and click next... 

3. Select your required template for database or choose default..

4. Write down the name of database we want.. 

5. Here unmark Configure Enterprise manager because it required a listener. And we will create listener after 
   database creation.. 

6. Give the common password OR different password for both username.. 

7. Here we are using default file system, 

8. Specify Recovery area and size. If required mark Enable Archiving.... 

9. Mark sample schemas, it will provide a sample database schema. If you have a script for execution then add it in
    Custom Scripts else select next.. 

10: Assign the memory size for SGA & PGA in custom or select Typical.. 

11. Mark Create database and Generate database creation scripts. We will use this script in upcoming sessions..

12. Save the Create Database summary in html file..

13. Now your database creation is complete. 

Now setup environment for created database.

  [oracle@test ~]$ cd /u01/app/oracle/admin/DB200/
  [oracle@test DB200]$ vi invDB200.env
                           
        # Oracle Settings
         TMP=/tmp; export TMP
         TMPDIR=$TMP; export TMPDIR
         ORACLE_HOSTNAME=test.oracle.com; export ORACLE_HOSTNAME
         ORACLE_SID=DB200; export ORACLE_SID
         ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
         ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
         ORACLE_SID=DB200; export ORACLE_SID
         PATH=/usr/sbin:$PATH; export PATH
         PATH=$ORACLE_HOME/bin:$PATH; export PATH
         LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
         CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH export PATH
  
// After created the above file..//
        
         [oracle@test DB200]$ chmod 775 invDB200.env
         [oracle@test DB200]$ ./ invDB200.env                                       OR
         [oracle@test DB200]$ source invDB200.env
         [oracle@test DB200]$ sqlplus / as sysdba
         
         SQL > select instance_name, status from v$instance;  
         SQL > shut                                      // To shutdown the database.//
         SQL > startup                                  // To start the database.//
         SQL > exit

If you want shutdown the system then first shudown database then shutdown system. After system start/restart again execute the environment file for database DB200 and login in sqlplus and start the database.....