Rams Oracle DBA Blog: Creating an Oracle 11g Database using DBCA

Creating an Oracle 11g Database using DBCA

In this example, I’ve already installed the Oracle Database 11gR2 software (11.2.0.4 in this example) on one of my Linux 6.4 machines, and I’m going to create a new database instance simply called ‘ORCL’ (as it’s going to be used for my EM12c database repository) using the DBCA tool.

The data files will be stored under the /u02/oradata/{DB_NAME} directory, setup by ‘root’ as follows:

Create the directory and give the permission

mkdir -p /ramu/oradata/ORCL
chown -R oracle:oinstall /ramu
chmod -R 775 /ramu

Start the Database Configuration Assistant (DBCA)

Open an X-Windows session to the server as the ‘oracle’ user.

Set your ORACLE_HOME environment variable appropriately, then start the assistant by running the following:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4

$ORACLE_HOME/bin/dbca

Once the GUI starts, respond as follows:

Welcome
- Next
Step 1 of 12: Operations
- Create a Database
- Next

Step 2 of 12: Database Templates
- General Purpose or Transaction Processing
- Next

Step 3 of 12: Database Identification
- Global Database Name: emrep (or any name you want providing it’s no more than 8 characters long, and starts with an alphabetic character)
- SID: emrep
- Next

Step 4 of 12: Management Options
- Tick/Untick ‘Configure Enterprise Manager’ according to your needs.

If you do want to configure Enterprise Manager locally, and a listener hasn’t yet been configured, you’ll be presented with a warning about having to configure one before being able to continue. If you need to create a listener service, take a look at this post.

Leave everything else as default
Next

Step 5 of 12: Database Credentials
- Use the Same Administrative Password for All Account (unless you’d rather not)
- Password: ******
- Confirm Password: ******
- Next

Step 6 of 12: Management Options
- Specify storage type and locations for database files
- Storage Type: File System
- Use Common Location for All Database Files
- Database Files Location: /u02/oradata
- Next

Step 7 of 12: Recovery Configuration
- Tick Specify Fast Recovery Area
- Fast Recovery Area: {ORACLE_BASE}/fra
- Tick Enable Archiving
- Click on Edit Archive Mode Parameters…
  - Archive Log File Format: %t_%s_%r.arc
  - OK
- Next

Step 8 of 12: Database Content
- Optionally, check ‘Sample Schemas’ (this will create an ‘EXAMPLE’ tablespace and some sample schemas). I recommend leaving this unticked if this is to become a live environment.
- Next

Step 9 of 11: Initialization Parameters
- Use a Typical configuration
- Tick ‘Use Automatic Memory Management’
- Change the ‘Memory Size’ value accordingly (or leave default as 40% of total machine memory)
- Review any additional parameters by clicking ‘All Initialization Parameters’
- Next

Step 10 of 11: Database Storage
- Check storage locations/options and update accordingly if required
- Next

Step 11 of 11: Creation Options
- Optionally tick ‘Generate Database Creation Scripts’ if you prefer to keep it for future reference.
- Finish
Confirmation
- Check the ‘Create Database – Summary’ details
- OK