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.

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.


2. Select General template.



3. Select a name for the database.


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



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


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


7. Accept the standard Flash Recovery Area setup


8. Unless you want a sample schema click Next


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.


10. I generally leave this section alone and click NEXT


11. Final confirmation



12. Your database is being created.


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










Datapump basics

Datapump is a powerful way to move data from one Oracle database to another.

On the target database you will need to make sure that :

1. The user and tablespace exists.

2. The user has create session – grant create session to <user>;

3. The user has access to the tablespace – alter user <user> quota unlimited on <tablespace>;

4. The user has import database access – grant imp_full_database to <user>;

5. The import directory exists – create directory <name> as ‘<path to directory>’ e.g. create directory dpin as ‘/data/import’;

6. Run the import – imdp user/password directory=<name> dumpfile=<dumpfile.dmp>

Post OBIEE Configuration

You will probably find that OBIEE will not be started post reboot on the Windows environment. You can always start up in console mode by running startWebLogic.cmd.


Better still configure it as a Windows Service.

I found this link very helpful to setup Weblogic as a Windows Service. Just replace P6 with bifoundation_domain and you should be right.


This link may also help.

Installing OBIEE on Amazon EBS

One thing you may come across when installing OBIEE (any version) on Windows 2008 R2 is that it requires a loopback adapter.

So for Amazon EBS (Windows 2008 R2) :

1. Create a non-routable address entry for your Amazon host in C:\Windows\System32\drivers\etc\host file   WIN-M7878127

2. Go to Server Manager -> Device Manager

3. Right-click on the Host and Add legacy hardware

Add Legacy

4. Select Install the hardware that I manually select from a list

5. Select Network Adapters

Add Legacy 2


6. Choose Microsoft as the Manufacturer and scroll to Microsoft Loopback Adapter



Add Legacy 3

7. Once the driver is installed , open Network and Sharing Center and select the connection.

8. Make sure you unselect IPV6 and then select IPV4.

9. Enter Subnet as the address. DNS should be left blank.

Add Legacy 6

10. Click Advanced and make sure that Register the connection’s addresses in DNS is unselected.

Add Legacy 5

11. Close all the windows and your done!