Database Creation in Oracle 11g in Linux

Pre-requisite for database creation

oracle database software must be installed.(Check my blog for installation)
at least one listener should be there.

Listener creation using netca

netca's location is $ORACLE_HOME/bin directory.

[oracle@pal bin]$ netca

network configuration assistance window will open.

Step 1: Select Listener configuration

Step 2: Select Add>Next

Step 3:Enter name of Listener (you can give any name, chose appropriate name)
           
I am giving name as Listener

Step 4: Select TCP protocol

Step 5:  Enter port no for Listener, default port number is 1521.

Listener will be created using netca.

Listener creation using netmgr

netmgr's location is $ORACLE_HOME/bin directory.

[oracle@pal bin]$ netmgr

Oracle Net Manager's window will open.

Step 1: go to Local>listeners

Step 2: click on + on left panel.

Step 3: Select Listening Location from drop down list on top.
            Click on add address from bottom.

select protocol as TCP/IP

Enter Host Name

Enter Port no

Step 4: Select Database Services from drop down list on top.
            Click on add database.

Enter name of Database (orcl)

Enter path of oracle_home (/u01/app/oracle/product/11.2.0/dbhome_1)

Enter name of oracle_sid (orcl)

Save Network setting and exit

Manually listener creation

By default, the listener.ora file is located in the 
$ORACLE_HOME/network/admin directory on UNIX operating systems and the ORACLE_HOME\network\admin directory on Windows.

Open listener.ora file in text editor

 [oracle@pal ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/
[oracle@pal admin]$ vi listener.ora 
[oracle@pal admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora


LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  )

ADR_BASE_LISTENER = /u01/app/oracle 

Standalone database creation using DBCA.

DBCA's location is $ORACLE_HOME/bin directory.

[oracle@pal ~]$ dbca

Step 1: Select create database>click next

Step 2: Select general purpose or transaction processing>click next

Step3: Enter global database name orcl
           Enter SID orcl>click next

Step 4: on top select enterprise manager and If you want to manage database using oracle enterprise manager enable the check box of configure enterprise manager.
 

On top select automatic Maintenance task and enable check box.

 

Step 5: Select use the same administration password for all accounts and set the password (you can set different password).>click next

Step 6: select storage type to file system

            select storage location to use database file locations from template>click next

Step 7:  enable specify flash recovery area

             enter path of flash recovery area (/u01/app/oracle/flash_recovery_area)

             enter sized of flash recovery area (4096 oracle recommended, you can add more size as per your need).

             enable archiving for generate archive log files.

Step 8: If you want you can enable sample schema, it will give you some basic data to perform certain operations or you can use it as test database.

Step 9:

from top select memory 

select Typical enter memory size 40% of ram size

enable use automatic memory management

from top select sizing 

enter block size 8192

set processes as per your need(150)

from top select character sets

select use the defaults

from top select connection mode

chose dedicated server mode 

Step 10: click next

Step 11: click finish

You can unlock schemas from password management or you can do it later as per your need.

Set Oracle SID

[oracle@pal ~]$ . oraenv

ORACLE_SID = [orcl] ? orcl
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle

[oracle@pal ~]$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Mon Jun 25 22:45:33 2018

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name from v$database;

NAME
---------
ORCL

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
orcl

Thank You.