Oracle Database Installation (Part 3 of 3) – Like a BOSS

Continuing from Oracle Database Installation (Part 2 of 3)

The Database Software and the ASM instance have been setup. The final stage post installation is to create and configure a database.

CREATE A DATABASE

Set the environment variables before invoking the database configuration assistant

$ . oraenv
ORACLE_SID = [oracle] ? orcl
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/11.2.0/dbhome_1

The Oracle base for /u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle

$ dbca

This starts up the database configuration assistant. With the exception of a few changes, rest all have been left as default:

1. Operations > Create a Database
2. Database Templates > General Purpose or Transaction Processing
3. Database Identification > SID set to orcl
4. Database Credentials > Use same password for all accounts
5. Storage options > Specify ASM and select the +DATA diskgroup.
6. Recovery Configuration > Specify Flash Recovery Area and select FRA
7. Database Content > Selected sample schemas
8. Memory tabbed > Character set changed to Unicode AL32UTF8
9. Creation options > Save Database Template and Scripts
10. Finish

START THE DATABASE

To start up the database,

$ sqlplus / as sysdba

SQL> startup nomount

Alternatively, login to enterprise manager as SYS and click the startup button. To check if enterprise manager is running,

$ emctl status dbconsole

followed by,

$ emctl <start | stop> dbconsole

A simple way to check if the database instance is running:

$ ps -ef | grep smon

Subsequent Database management tasks can be accomplished either on the Enterprise Manager console or in SQLPLUS.

Advertisements

About Abhimanyu 'Jay' Jana

Rookie Oracle DBA
This entry was posted in Database, Oracle and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s