Thursday, July 26, 2012

How to resolve [nQSError: 12008] Unable to connect to port 9705 on machine

When ever facing following error;

Oracle BI Scheduler Error: [nQSError: 12008] Unable to connect to port 9705 on machine wshahzad-62b9f2. [nQSError: 12010] Communication error connecting to remote end

point: address = wshahzad-62b9f2; port = 9705. [nQSError: 12002] Socket communication error at call=: (Number=-1) ???

Go to services and make sure the Oracle BI Scheduler Service is up and running.

Cheers ;) and long live pakistan

Friday, July 6, 2012

Upgrade OBIEE 10g to 11g

Copy the Catalog, Deliveries and Repository from the OBIEE 10 g Installation.

Put the extracted files on the Server with Fusion Middleware Installation of Oracle BI EE 11g

Open the Upgrade Assistance from the following path; MiddlewareHome > Oracle_BI1 > Bin

Open ua.bat (Upgrade Assistant.batch)

On the next screen select “Upgrade Oracle BI RPD and Presentation Catalog”

On the next screen give the 10g repository path, catalog path and deliveries path;

On the next screen set Port to 7001 and 11g Bi Server Credentials, e.g. weblogic/admin1234

On the next screen examination process will start which will make sure that the catalog and deliveries directories are available, readable and contain a file for upgrade, wait until succeeded.

On the next screen upgrade summary will be displayed

Click Next to start the upgrade process

Whoa Upgrade is successful, click Finish

On successful completion the upgraded RPD and catalog will be automatically added to the Fusion Middleware 11g server.
Restart BI Services.

For Verification login to Fusion Middleware Enterprise Manager; http://localhost:7001/em/

You will see under the coreapplication the newly added repository is available.

 Cheers and Long Live Pakistan ;)