Creating a new database using XWindows

Oracle has a nice command that allows you to create a new command. The Database Configuration Assistant (dbca) requires the use of XWindows.

First you will need to download an XWindows client. I use MOBATERM.

http://mobaxterm.mobatek.net/download-home-edition.html

Next you will need to create an SSH session to your Oracle DB host. I am using a Redhat ES 6 instance on Amazon and so I create the session and login using my private key. Note: I had previously configured the oracle account to use the same private key as the “ec2-user” account by copying the .ssh directory into ~oracle/.

Then run dbca which is found in $ORACLE_HOME/bin.

1. Select Create a Database.

DBCA1a

2. Select General template.

 

DBCA2

3. Select a name for the database.

DBCA3

4. Accept defaults for the Enterprise Manager (nice web interface to manage the DB)

DBCA4

 

5. Either set different passwords for the SYS etc. accounts or set a single password (not recommended for Production installations).

DBCA5

6. Accept the standard file structures (unless you would like to configure special datafiles).

DBCA6

7. Accept the standard Flash Recovery Area setup

DBCA7

8. Unless you want a sample schema click Next

DBCA8

9. Importantly select “Unicode ALUTF8” if you are going to be loading up Oracle applications e.g. SOA, OBIEE etc. as these all require multi-language support.

DBCA9

10. I generally leave this section alone and click NEXT

DBCA10

11. Final confirmation

DBCAFINAL

 

12. Your database is being created.

DBCAFINAL2

13. Finally make note of the Enterprise Manager URL for the database as you might use this in the future.

DBCAFINAL3

 

 

 

 

 

 

 

 

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