Oracle Identity and Access Manager – Errors trying to install

I am currently trying to configure Oracle Identity and Access Manager and have an issue when connecting to the WebLogic Admin Server –

INST-6193: The attribute JpsContextName in MBean,name=ServerConfig,type=SDPMessagingServerConfig,Application=usermessagingserver not found.
Check the SOA version compatibility.

Looks like it is a patch issue with Oracle SOA. I am currently downloading the required patches after reading another post.


Connor’s private post for Minecraft

My name is Connor and I am 6 1/2 years old. I think Minecraft is the best game ever.I also play Garry’s Mod and Grand Theft Auto IV and the  Episodes from Liberty City with the Hulk Mod.

My favourite YouTube channels are – TheGamingLemon , VanossGaming and DiamondMineCart.

My dad is typing while I talk so I can make sure that he doesn’t misspell anything.

I’ll post more tomorrow.



Installing Oracle Identity Manager

I was just trying to install Oracle Identity Manager 11g R2 and came across an error while running the Repository Creation Utility.

Works out that you need to have XATRANS installed.

Error: XATRANS Views are not installed on this Database. This is required by the OIM Schema

Action: Install view XAVIEWS as SYS user on this Database.

GOOGLE solves my problem.

Don’t forget that the database also needs the following parameters –

show parameters PROCESSES (should be more 300)
show parameters NLS_LENGTH_SEMANTICS  (should be BYTE)
show parameters SHARED_POOL_SIZE (should be more 147456KB)
show parameters SGA_MAX_SIZE (should be more 147456KB)
show parameters DB_BLOCK_SIZE (is greater than or equal to 8KB)
show parameters OPEN_CURSORS (should be more 800)


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>

Looking for a Reverse Proxy ? Try IIS 7.5

If you need a simple but effective reverse proxy you may find IIS 7.5 suits.

Simply load up IIS 7.5, and install URL Rewrite (

Add the URL you wish to be forwarded and enable. For example, some firewalls may not like letting port 9704 through (the OBIEE default port) so you can simply forward public traffic on the public address to and you are done.