Sunday 29 January 2012

How to deploy RPD and catalog without Enterprise manger

Many times the obiee service goes off because of deployment of inconsistent RPD and to make the services up we need to deploy the previous RPD.

To achieve this we change the name of RPD and Catalog in NQSConfig.ini and Instanvceconfig.xml file respectively just similar to obiee 10g RPD and catalog deployment method. But in obiee11g if we change in NQSConfig.ini and Instanceconfig.xml file and restarted the services the obiee 11g revert back the changes whatever we did manually.


Actually there is Central configuration enable by default in obiee11g which allows us to update the configuration with interface. So to disable the central configuration and deploy the RPD and catalog with obiee10g fashion follow the following steps

1) Edit the biee-doamin.xml file from location ORACLE_HOME\user_projects\domains\bifoundation_domain\config\fmwconfig and edit the “centralConfigurationEnabled” tag as shown below











2) Change the RPD name in of RPD in NQSConfig.ini file .The NQSConfig.ini file is located at ORACLE_HOME\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1












3) Change the catalog detail in instanceconfig.xml file.File is located at location at ORACLE_HOME\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1








4) Restart all services, now you can see the changes whatever we did in NQSConfid.ini and instanceconfig.xml file are as per our requirement now.
Posted by at 09:21
Labels:

12 comments:

  1. Anonymous15 May 2012 at 07:00

    Thanks, but can I change the RPD password without opening EM or AdminTool?

    ReplyDelete
  2. Rhishikesh23 May 2012 at 08:34

    HI,

    Which version of OBIEE are you using....???

    ReplyDelete
    Replies
    1. mandla8 June 2012 at 12:00

      Hi,

      please send how to migration rpd& catlog in obiee 10g


      Kind Regards
      Venkat

      Delete
    2. Rhishikesh19 June 2012 at 08:38

      Hi,

      To deploy the RPD in OBIEE 10g perform the following steps

      1) Navigate over OracleBI\server\Config\NQSConfig.ini.
      2) Edit the file and change the in [ REPOSITORY ] section

      Star = [Name of RPD], DEFAULT;

      For catalog deployment perform the following steps

      1) Navigate over file C:\OracleBIData\web\config\instanceconfig.xml
      2)Edit file and make the changes in
      [Path of the Catalog]

      After the changes done restart the OBIEE services.

      The same changes you have done for OBIEE11G just the folder location are different. You can see the required file NQSConfig.ini and instanceconfig.xml file at following location respectively:
      [Middleware_Home]\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1/NQSConfig.ini

      [Middleware_Home]\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\instanceconfig.xml

      Delete
  3. Challenor12 July 2012 at 05:45

    Hi I am having BI issues to open OBIEE "online" but I can use it offline..
    When I go to Oracle BI Administration so I made a snag it take a look at my attachment and let me know.. The repository password same as the offline account.. The username weblogic same as when I login to EM and a password same use to login to EM. But I get this error.
    " [nQSError:37001] Could not connect to BI Server Instance"

    Went to C:\Program Files (x86)\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orainst\config\OracleBIServerComponent\coreapplication\NQSConfig

    and changed this Star = repository.rpd, DEFAULT ; to BISAMPLE = BISAMPLE.rpd, DEFAULT ;
    Can you assist? I can email you more info if you like.

    ReplyDelete
  4. Challenor12 July 2012 at 22:34

    Additional info.. The error came while doing this tutorial. Topic Testing and Validating a Repository - Set Up Query Logging

    http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi11115/biadmin11g_02/biadmin11g.htm#t4

    ReplyDelete
    Replies
    1. Rhishikesh13 July 2012 at 01:46

      Hi,

      It looks like you are trying to open the RPD from BI Client...
      To open up the RPD from BI client you need to first set the DSN which you can set in Control Panel-> Administrative tools->Data Source using Oracle Bi server driver. Provide there the necessary parameter and test the connectivity of the server...

      While creating the DNS in the screen of Oracle Bi server DSN configuration select the cluster DSN if you have OBIEE system is cluster(Enterprise install) or just keep unchecked this option if you have simple install without cluster environment...

      I hope this will help you...

      Delete
    2. Challenor13 July 2012 at 23:35

      thanks a lot.. It worked

      Delete
  5. Swathi3 September 2012 at 21:52

    Hi Rishikesh,
    I am new to OBIEE. I have 11g. I've some peculiar problems. I don't whether you can assist me on these.
    1. I can't see the query logs in enterprise manager server logs while I can see them in analytics. The user has query logging previlege.
    2. When I deploy new repository using enterprise manager, the NQSConfig.INI will still have old epository until I restart the computer. I am following accurate procedures for deploying.
    Kind regards,
    Swathi

    ReplyDelete
    Replies
    1. Rhishikesh10 October 2012 at 08:40

      Hi Swathi

      Regarding you first question to check the log in enterprise manager navigate over following path

      Business Intelligence->Coreapplication->Click on Diagnostics in right pane.The list of logs are available there.

      Related to second question:- After deployment of RPD you need to restart the BI services

      Delete
  6. Anonymous24 September 2012 at 09:02

    Question for you guys. If I do my OBIEE trainiing using OBIEE 11g do I have to retrain again in order to work in a OBIEE 10g environment? What are the features of 10g I should familiarize with first to make myself comfortable with 10g?

    ReplyDelete
  7. Unknown8 February 2013 at 13:44

    Hello Rhishikesh

    I have a specific scenario where i have to copy a repository from a client server to my company server. We are using OBIEE 10. Is there a procedure to handle this scenario.

    Thanks

    ReplyDelete

Subscribe to: Post Comments (Atom)