Posts

Showing posts with the label Database Creation

How to create database through Graphical tool "DBCA" Database Configuration Assistant

Image
Step 1) You need to go to the ORACLE_HOME/bin location manually to run the DBCA utility Example: -   [oracle@prod bin]$ cd /u01/app/oracle/product/11.2.0/db_1/bin [oracle@prod bin]$ Step 2)  Now run dbca utility through below command Example: - ./dbca Click on below "Next" button to proceed further Step 3) Click on " Create a Database " tab to proceed further Step 4) Click on " General Purpose or Transaction Processing " tab because we are using for practice purpose but in real environment  choose options as per the requirement Step 5)  Put the name of Database which you need to create, in my case it is "orcl" Step 6) Check the "Configure Enterprise Manager" tab and "Automatic Maintenance Tasks" tab, but make sure your listener is up and running, otherwise, you need to uncheck  "Configure Enterprise Manager" tab to proceed further Step 7) Put all

How to Create Oracle Database Manually through the file system

                                STEPS TO CREATE a "MANUALLY  DATABASE " IN ORACLE Step 1)   Create a manual entry in /etc/oratab file for a database which needs to be built, in my case I am using "Karan" [oracle@prod ~]$ cat /etc/oratab # # This file is used by ORACLE utilities.  It is created by root.sh # and updated by either Database Configuration Assistant while creating # a database or ASM Configuration Assistant while creating an ASM instance. # A colon, ':', is used as the field terminator.  A new line terminates # the entry.  Lines beginning with a pound sign, '#', are comments. # # Entries are of the form: #   $ORACLE_SID:$ORACLE_HOME:<N|Y>: # # The first and second fields are the system identifier and home # directory of the database respectively.  The third filed indicates # to the dbstart utility that the database should, "Y", or should not, # "N", be brought up at syste