• Find us:
    +1-669-900-5138   |   +44-203-372-5553
  • Free Newsletter

    Get Latest Updates

  • Make Training Enquiry


    Company

  • Categories

  • Archive

  • OBIEE – Step by Step Installation

    Posted by "" in "business intelligence, installation" on 2008-08-26

    Share on FacebookTweet about this on TwitterShare on Google+Share on LinkedInEmail this to someone

    On request from readers, I am posting step by step installation of Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.X on windows (you can use same steps to install OBIEE on Linux)

    .

    Things good to know about OBIEE Installation

    i) Siebel Analytics from Siebel (acquired by Oracle) is now called as OBIEE (Oracle Business Intelligence Enterprise Edition). Siebel Analytics was originally product from NQuire acquired by Siebel in 2001-02

    ii) OBIEE is different from Oracle Business Intelligence Applications (OBIA)

    iii) To download OBIEE software click here

    iv) Installation Guide for OBIEE is available here

    v) For list of Supported Operating System check Guide here Page 15-16

    vi) There are two top level directory after OBIEE installation

    OracleBI – aka ORACLE_BI_HOME
    OracleBIData
    – aka ORACLE_BI_DATA_HOME

    More on these two directory, file system for OBIEE and important files in OBIEE coming soon

    vi) If you wish to use Oracle AS Single Sign-On server with OBIEE, install OBIEE on exiting 10.1.3.X Oracle Application Server (Advance Install)

    vii) Executable to install OBIEE on Windows is setup.exe and on Linux setup.sh (under server directory in OBIEE Software)

    viii) You will need JDK 1.5.0 or higher to install OBIEE. Download JDK 1.5 from here http://java.sun.com/javase/downloads/index_jdk5.jsp

    .

    .

    Installation Steps

    1. Start installation using setup.exe (Windows) or setup.sh (Linux)

    2. Next screen is for information only – OBIEE requires at least 2GB hard disk space and 200 MB temp disc space

    3. In this screen you define location of OBIEE top level directory,

    ORACLE_BI_HOME and ORACLE_BI_DATA_HOME

    – You also select installation type
    i) Basic
    ii) Advance


    4.
    Select components – In this screen you select components you wish to install with OBIEE server


    5. This screen displays all components you are going to install

    6. Specify JDK Location and Administrator (OC4JADMIN) account password on this screen

    7. In this screen you provide windows user detail and option to start BI as windows services (Manual or Automatic)

    8. Finally start services (using services.msc) if not already done and access OBIEE from browser

    Default Web port BI services is 9704 and default username/password is Administrator/Administrator

    To Access Analytics (BI Analytics ) http : // server name:9704/analytics (Administrator/Administrator)

    9. To Access Publisher (BI Publisher aka XML publisher )
    http :// servername:9704/xmlpserver (Administrator/Administrator)

    How to create user or configure LDAP server (OID/AD/iPlanet) as OBIEE user repository coming soon …

    148 Responses to “OBIEE – Step by Step Installation”

    1. Kailash says:

      Atul,

      I reading your blogs from long time. You were writing very interesting posts earlier. Nowadays you are writing more on installation or some very basic posts. I think you should pick a topic and write proper post various parts which will help the user to learn specific product.

      All these installation are very well given on oracle site. If you finding any workaround or issues then you discuss with installation is good approach to write a post.

      Rest on you. Nowadays it is more quantity on your blog then quality.

      Please write like Anil,Sam are some examples.

      All the best. Keep it up.

      Kailash

    2. Paul says:

      Hi Atul,
      This is a very good doc. Keep it up. I installed the OBIEE as per this doc and everything went quite well.

      But after the install when I try to login to BI Publisher, I get the following error:

      Login failed, Please try again

      I can login to Administration successfully though. Any thoughts?

      Thanks.

    3. Atul says:

      Paul,
      What URL and Password you are using ?

    4. Mohamed Youssef says:

      Hi Atul,

      I really like your posts as cover many areas and different products so i think your are the man of my question I need to start to make a server sizing for three of oracle products which I think you have a good knowledge about those products are :

      1. oracle E-Business Suite R12
      2. UCM Content Managment
      3. OBIEE

      my work experience is in 11i so these products is some what new for me

      so if you got a documented sizing document for these product specifically it is greatly appreciated to share

      thanks in advance

      Mohamed

    5. Atul says:

      Mohamed,
      UCM and OBIEE comes with with many components, What all components you/your client is planning to Use ?
      or
      Are you in situation where customer is not aware of what they want and simply asked you to prepare sizing for OBIEE and UCM

    6. Mohamed Youssef says:

      Hi Atul,
      thanks for response
      I know about the components but what I meant here is if you can provide me a documented questionnaire to guide the sizing process
      for UCM it wil be Document managment application with the infrastructure
      for OBIEE it will be the full Suite and Hyperion is in plane

      thanks

    7. Atul says:

      Oracle has alliances with all the hardware players it certifies, For example (IBM for AIX, HP for HP-Ux, Sun for Sparc..). Contact your Oracle salesperson, They will put you in touch with the appropriate hardware center which in turn will help guide your hardware sizing based on some pre defined set of questions.

      If you want to do it yourself

      For OBIEE hardware sizing, start from question form based on document here http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/PRS2930

      For UCM harware sizing , check installation guide of each UCM component (Content Serevr, Document Management, Web Content Management ….)

    8. Kiran says:

      Atul,
      iam trying to install OBIEE .. I had installed the Application server 10.1.3.1 (J2ee & HTTP Server) But i didn,t installed the DB.. Can we use the E busniess suite DB (12.0.4) which already existing in that box

      Here am using the advanced Obiee installation mode ..getting the error “Not selecting the proper oracle_home which has OC4J as home

      Pls reply me asap… this is really critical for me

    9. Atul says:

      Kiran,
      Yes you could use 12.0.4 DB but this is not recommended (better go for standaone 10.2.0.1 and then upgrade it to 10.2.0.2 and use for OBIEE)

      For –
      “Not selecting the proper oracle_home which has OC4J as home –
      echo $ORACLE_HOME (send us output)
      opmnctl status (from above oracle_home)

      what oracle_home location you are giving when installing OBIEE

    10. Kiran says:

      Atul… Thanks for u r reply..

      I installed the Application server 10.1.3.1 for atleast 3 times and installation type is “J2EE Server and Web Server” because i need the componets “Oracle HTTP Server, Oracle Containers for J2EE (OC4J), and Oracle Process Manager & Notification Server (OPMN)” for Obiee

      I have specified the oc4j Instance name as “OCFCFG1″ and used default ports (7777) and it didn,t asked the DB and installtion went successfull..

      But when iam installing the OBIEE,when I gave the Application server Location (Oracle_home)
      echo $ORACLE_HOME
      /u02/oracle/http/10.1.3.1
      & gave the OC4Jadmin password, & next screen am getting error is “Please specify the valid

    11. Kiran says:

      contunue
      ======
      oracle application 10g instalaltion location. A Vaid oracle application installation 10g instalaltion must have default oc4j instance named home and that home oc4j must be enabled”

      Please let me know
      1) At the time of instalaltion of Application server 10.1.3.1,do we need to take the oc4j instance as home
      2) Are we not supposed define our own name for OC4J Instance

      3) How do we enable the OC4J Instance?

      can you please let me know your thoughts on this

    12. Atul says:

      Kiran,
      leave oc4j name to default value “home” and try

    13. Kiran says:

      Thanks Atul… I had successfully installed the OBIee..

      But iam not able start the OBIEE processs (BI SERVER)
      When i issued the below cmd…

      ./run-sa.sh stop
      Oracle BI Server is not running.
      u02/oracle/obiee/OracleBI/setup]
      # tail -f /u02/oracle/obiee/OracleBI/server/Log/NQServer.log

      Log file is
      ===========
      [nQSError: 46116] The locale EN_US.UTF-8 needs to be installed on the machine for the Oracle BI locale setting English-usa specified in NQSConfig.INI.
      [nQSError: 46116] The locale EN_US.UTF-8 needs to be installed on the machine for the Oracle BI locale setting English-usa specified in NQSConfig.INI.

      And also iam not able to login the Oracle Application Server / em login …
      myserver.com:777/em

    14. Kiran says:

      sorry pls read the above cmd as ./run-sa.sh start

    15. Atul says:

      Kiran,
      What is your O.S. locale (language)? Type “locale” to find o.s. locale.

      It seems BI server is using EN_US.UTF-8 as default locale which is missing (not suppported) by your operating system.

    16. Kiran says:

      Thanks Atul,
      Here goes the locale info of my server
      locale
      LANG=en_US
      LC_COLLATE=”en_US”
      LC_CTYPE=”en_US”
      LC_MONETARY=”en_US”
      LC_NUMERIC=”en_US”
      LC_TIME=”en_US”
      LC_MESSAGES=”en_US”
      LC_ALL=
      ==================================
      I have asked SA to install the EN_US.UTF-8 on this server. We have Rel 12 is eixsting on this server & if we install the EN_US.UTF-8, does it over weites the existing ones (en_US)..This will create any issue? pls let me know

      2) For some reason, Oracle Application server EM is not coming up..giving error as “page cannot be displayed” (servername:7777/em).. All the OPMN services are Up & running

      Processes in Instance: oascfg1.usclswu027.wuintranet.net
      ———————————+——————–+———+———
      ias-component | process-type | pid | status
      ———————————+——————–+———+———
      OC4JGroup:default_group | OC4J:home | 3444920 | Alive
      ASG | ASG | N/A | Down
      HTTP_Server | HTTP_Server | 9724202 | Alive

      Can you pls let me know the issue?

      Thanks a lot for ur help so far

    17. Kiran says:

      The em(servername:7777/em) was not coming since when i installed OBIEE on the application server 10.1.3.1 .. The application ws working before

    18. Atul says:

      Kiran,

      1. If we install the EN_US.UTF-8, does it over weites the existing ones (en_US)..This will create any issue?

      I don’t see any issues here , confirm with Oracle Support

      2. The em(servername:7777/em) was not coming

      Start em using

      opmnctl startproc application=ascontrol

      Check this post
      http://onlineappsdba.com/index.php/2006/11/20/startup-shutdown-application-server-bounce-services/

    19. jsethi3@gmail.com says:

      Getting error while running setup.sh

      …………………..Exception in thread “main” java.lang.OutOfMemoryError

      at java.util.zip.ZipFile.open(Native Method)

      at java.util.zip.ZipFile.(Unknown Source)

      at java.util.zip.ZipFile.(Unknown Source)

      at run.main(run.java:38)

    20. Atul says:

      How much is memory on machine ? Is this on linux or Solaris ?

    21. Kiran says:

      Atul,
      iam getting the below errro when i start the BI server
      ========================

      0509-026 System error: A file or directory in the path name does not exist.
      exec(): 0509-036 Cannot load program /u02/oracle/obiee/OracleBI/server/Bin/nqsserver because of the following errors:
      0509-150 Dependent module libmdxmembernamecache.so could not be loaded.
      0509-022 Cannot load module libmdxmembernamecache.so.

      ===========================
      was this issue b/c oracle home lib path ?

      Please find the OBIEE.env setting

      pg OBIEE.env
      BI_HOME=/u02/oracle/obiee/OracleBI; export BI_HOME
      BIDATA_HOME=/u02/oracle/obiee/OracleBIData; export BIDATA_HOME
      ORACLE_HOME=/u02/oracle/10.1.3.1/OracleAS; export ORACLE_HOME
      LIBPATH=$ORACLE_HOME/lib32; export LIBPATH
      LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
      PATH=$PATH:$ORACLE_HOME/bin; export PATH

      Please update me

    22. Kiran says:

      My DB Version is 10.1.0.5.0

    23. Atul says:

      Kiran,
      Search for this file in linux machine as root to in which directory (lib) this library lying (o missing from server)

      cd /
      find . -name libmdxmembernamecache.so

    24. Kiran says:

      Atul.
      Thanks a Lot for your reply…

      The file is very much located in the below path… still iam getting the error..

      Any thoughts pls

      ls -ltr libmdxmembernamecache.so
      -rwxrwxrwx 1 eamdba dba 1102089 Jul 30 20:25 libmdxmembernamecache.so

    25. Kiran says:

      Atul.
      Thanks a Lot for your reply…

      The file is very much located in the below path… still iam getting the error..

      Any thoughts pls

      cd /u02/oracle/obiee/OracleBI/server/Bin/
      [eamdba@usclswu027][/u02/oracle/obiee/OracleBI/server/Bin]
      # ls -ltr libmdxmembernamecache.so
      -rwxrwxrwx 1 eamdba dba 1102089 Jul 30 20:25 libmdxmembernamecache.so

    26. Atul says:

      Try adding this path in

      LIBPATH & LD_LIBRARY_PATH

      Is linux 32 bit or 64 bit ?
      Which version of OBIEE ?

      I’ll try at my end on similar setup as yours and will update you

    27. Kiran says:

      The following are the paths for LIBPATH & LD_LIBRARY_PATH which are already added in OBIEE_.env
      =======
      LIBPATH=$ORACLE_HOME/lib32:$JAVA_HOME/lib; export LIBPATH
      LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
      ===========
      And I had installed the OBIEE 10.1.3.4 VERSION & My operation system is AIX

      # oslevel -g
      Fileset Actual Level Maintenance Level
      —————————————————————————–
      bos.rte 5.3.0.60 5.3.0.0

    28. Kiran says:

      Atul,
      I was able resolve the above error by setting the LIB Path Properly… Thanks a lot for your quick reponse

      quick question:- I had created respository file (OBID.rpd)in /u02/oracle/obiee/OracleBI/server/Repository..What this file do… do i need to mention the DB settingg on this rpd file?

    29. Kiran says:

      Atul..

      can you pls let me know how do i create respository in AIX for OBIEE 10.1.3.4 installation ..

      Where do i need to add data source to connect the DB

      Pls let me know.. My release date is coming nearer

    30. jsethi3 says:

      I get this error when i start setup.sh from unzipped file directory:

      …………………..Exception in thread “main” java.lang.OutOfMemoryError
      at java.util.zip.ZipFile.open(Native Method)
      at java.util.zip.ZipFile.(Unknown Source)
      at java.util.zip.ZipFile.(Unknown Source)
      at run.main(run.java:38)

      Then I unzipped the files under / filesystem and successfully started the installer, by still modifying the setup.sh file for 1.5.x jdk home. But the installer fails at 1% complaining about .variant.sh files.

      Any idea

    31. jsethi3 says:

      This is the message:

      (Sep 24, 2008 4:01:17 PM), Install.product.install, com.installshield.produc
      t.service.product.PureJavaProductServiceImpl, msg1, installing Copy File Custom (CopyUnixChksh)
      (Sep 24, 2008 4:01:17 PM), Install.product.install, com.siebel.analytics.install.CopyFileCustom, err, An error occurred and product installation failed. Look at the log file /oradata04/oracle/orabiee/log/install.log for details.
      (Sep 24, 2008 4:01:17 PM), Install.product.install, com.sie
      bel.analytics.install.CopyFileCustom, err, ProductException: (error code = 601; message=”err”; additional data = [/UnixChk.sh does not exist])
      STACK_TRACE: 13
      ProductException: (error code = 601; message=”err”; additional data = [/UnixChk.sh does not exist])
      at com.installshield.product.actions.CopyFile.install(CopyFile.java:42)
      at com.siebel.analytics.install.CopyFileCustom.install(CopyFileCustom.java:63)
      at com.installshield.product.service.product.PureJavaProductServiceImpl.ins
      tallProductAction(PureJavaProductServiceImpl.java:1916)
      at com.installshield.product.se
      rvice.product.PureJavaProductServiceImp
      l$InstallProduct.getResultForProduc
      tAction(PureJavaProductServiceImpl.java:5195)
      at com.installshield.product.service.product.InstallableObjectVisitor.visi
      tComponent(InstallableObjectVisitor.java:369)
      at com.installshield.product.service.product.InstallableObjectVisitor.visit
      InstallableComponents(InstallableObjectVisitor.java:333)
      at com.installshield.product.service.product.InstallableObjectVisitor
      .visitProductBeans(InstallableObjectVisitor.java:133)
      at com.installshield.product.service.product.PureJavaProductServiceIm
      pl$InstallProduct.install(PureJavaProductServiceImpl.java:4563)
      at com.installshield.product.service.product.PureJavaProductServiceI
      mpl$Installer.execute(PureJavaProductServiceImpl.java:3758)
      at com.installshield.wizard.service.AsynchronousOpera
      tion.run(AsynchronousOperation.java:41)
      at java.lang.Thread.run(Thread.java:595)

      Any idea?

    32. Suri says:

      Atul,

      Where can download ORACLE BUSINESS INTELLIGENCE ENTERPRISE EDITION 10.1.3.2 for Solaris x86 32-bit ?

    33. Atul says:

      I don’t there is one specific for solaris X86

      http://www.oracle.com/
      technology/software/products/ias/htdocs/101320bi.html

      Check with Oracle Support or try sparc one

    34. jsethi3 says:

      Hi,

      Any response to my question will be great. I tried JAVA_OPTS, but that did not help.

      Regards,

      Jagdeep

    35. Atul says:

      Whats in /oradata04/oracle/orabiee/log/install.log

      Do you see UnixChk.sh in software ?
      It should be in $SOFTware_dir/[your_os]/Server/Oracle_Business_Intelligence

      for linux

      $SOFTware_dir/RH_Linux/Server/Oracle_Business_Intelligence

    36. jsethi3 says:

      Yes. I did run UnixChk.sh and it is SUCCESSFUL!! I tried to install software on windows, and it went fine.

      Thanks,

    37. jsethi3 says:

      The issue was with the stupid .profile.

      How to install client administration tool to develop rpd files? Do we need to install the complete server on the desktop?

    38. Prakash says:

      Hi
      Atul

      I am not able to logging into BI Plublisher with Administrator Username n pwd. This is my first time using this tool. Please help if u can.

      Thanks
      Prakash
      9493947282

    39. Atul Kumar says:

      Prakash,
      Are you getting wrong password or any other message.

      Try using exact case A capital.

    40. kvasavikumarreddy@gmail.com says:

      Hi Atul,

      Can u tell me hoe to integrate the SSO integration on OAM using OBIEE.

    41. vasavi says:

      Hi Atul,

      When i installed the OBIEE on IIS server,Analytics or installed on port number 80 and all the things are installed under 9704.Is It indicating the installation is not successfully or not?

      i am new to OID and All this things..

      Thanks
      Vasavi

    42. Atul Kumar says:

      In your case it seems web server in front is IIS which is listening on port 80.

      Is this case ?

      It seems installation is correct you just need to sort out which application in BIEE (Publisher, Analytics) is using which port to access.

    43. vasavi says:

      Hi Atul,

      Yes it seems to be My server is IIS.And all the servers are running fine.After integrating for SSO like changing the files credintialstore.xml and instanceconfig.xml.At this point when i am trying to restart the servers i am not able to restart the BI Publisher..It is giving the error like do descryption id there for imersonation

      Thanks
      Vasavi

    44. girish says:

      Hi Atul,

      Do we need to install any standalone database before installing obiee and if yes which is the minimum required version.

      Thanks
      Girish.

    45. Atul Kumar says:

      Girish,
      DB is not required for OBIEE installation.

    46. Jagdeep says:

      The repository entries and other information are stored in the xml files on the operating system.

    47. […] Oracle BI Publisher Admin Console (xmlpserver) Login Issue : Administrator/Administrator Posted in January 15th, 2009 byAtul Kumar in business intelligence, troubleshooting  Print This Post I recently installed OBIEE (Oracle Business Intelligence Enterprise Edition) with Installation Type as Advanced (i.e.Using existing Oracle Application Server 10.1.3.X ). For Step by Step OBIEE installation click here […]

    48. Harvinder says:

      Hi Atul,

      I installed OBIEE on solaris 9(sparc 64 bit) with basic installation option.
      I followed below steps to start.

      1. ./oc4j -start
      2. ./run-sa.sh start
      it says

      Oracle BI Server startup initiated.
      Please wait for a while for the Oracle BI Server to completely start.
      Execute the following command to check the Oracle BI Server logfile and see if it started.
      tail -f /sprd2_gsc01/oraobi/OracleBI/server/Log/NQServer.log

      buty nothing happens. Do I need to do some setups or server configuration after installation?

      Thsnks

    49. Atul Kumar says:

      Is BI URL not working (if not what URL you are using) ?

    50. Vishal says:

      H Atul,

      You are writing very interesting posts. I think ‘Basic Installation’ note are very useful to people like me, keep writing basic things also.
      All these installation given on oracle site are very clumsy, I feel no comfort. But your posts supplements user-friendliness.
      All the best. Keep it up.

      Vishal
      Sr. Software Engr.(BI)

    51. vasavi says:

      Hi Atul and all,

      Can u any one tell me how to configure the SSO for the BI Publisher , when the OBIEE is installed in basic installation. I already configured the SSO for the Analytics. Can any one can guide me to do the SSO for the BI Publisher

      Thanks

      Vasavi

    52. Atul says:

      Try this

      http://download.oracle.com/
      docs/cd/B40078_02/doc/bi.1013/
      b40017/T421739T475591.htm#T434806

      and update us if this works (I am facing problem in advance BIP installation with OBIEE on 10g AS R3)

    53. vasavi says:

      Thanks Atul,

      In my case i didn’t installed any Oracle application server.In the document there is that Oracle Application Server is must and should.am i correct? if not is there any way configure the SSO for the BI Publisher? Kindly let me know ..

      Thanks

      Vasavi

    54. sachin says:

      Hi Atul

      I am trying to install OBIEE version 10.1.3.4.0 using biee_windows_x86_101340_disk1 on windows vista Home premium Service Pack 1.

      I have created JAVA_HOME with the path: C:\Program Files\Java\jre1.6.0_07\bin

      i have followed all the screen shots above, but hit this problem:
      ‘Please specify a location for a valid JDK installation.’

      I am at a loss to understand what am i doing wrong?

      Could you please help me out.
      Thanks

      Sachin

    55. vasavi says:

      Hi Sachin,

      You need provide the path of the JDK not jre. Try by installing the jdk(Java Development kit) not JRE (Java Run time Environment).If you have the bin folder unser the C:\program files\java\bin.. provide the path like “C:\Program files\Java”.

    56. VilasM says:

      hi Atul, Thanks for so informative Blog.
      I have aquestion here.

      Today is my first day to start wiht OBIEE. I have installed it successfully on my personla PC and created a repository using MS access as database.

      After this I tried to connect to Presentation Service which ran into error saying IE can not open the page.
      All my internet is running up-to-date (otherwise how could I post this Q :)) .
      It trying to connect to link
      http://uswpus63868:9704/analytics
      where its giving error as page can not open.

      FYI, my own m/c is my server machine for this.
      I also tried this -http://localhost:9704/analytics

      but no luck.:(

      could you tell me what to do?

      Thank you!
      –Vilas

    57. sonali says:

      Dear Atul,

      we re installing OBIEE version 10.1.3.2 using biee_linux_x86_redhat_101332_disk1.cpio on OELinux operating system

      but after instaalation Biserver link is not opening.

      currently our Jdk version is 1.4.2
      [appsuser@TCS186249 apps]$ java -version
      java version “1.4.2”
      gij (GNU libgcj) version 4.1.2 20071124 (Red Hat 4.1.2-42)

      Do we need to upgrade it to 1.5.

      IS it due to that issue or something else could you please help us.

      Sonali

    58. max60074 says:

      where can i find step by step user guide for obiee to create reports

    59. Ravi Kumar says:

      I am doing OBIEE install for PeopleSoft EPM database 8.9 release. The OBIEE server component is installed on Unix server while the OBIEE presentation service is installed over Windows server.

      I have EPM database ruining over Oracle 10G/Solaris. When I am trying to login into OBIEE server http://localhost:9704/analytics I am able to login to BI server. I wanted to connect OBIEE with my EPM database.

      Can you please provide me some steps on connecting OBIEE with PeopleSoft EPM database. Thanks for your help.

    60. srikanth says:

      hi atul,
      I recently installed obiee in our environment which on oel 5 and 10.1.3.4 server.
      But the main thing is that it was sucessfully installed ith a warning
      WARNING: could not delete locked file /tmp/ismp001/4979638
      WARNING: could not delete locked file /tmp/ismp001

      And then we had a problem that we couldnt login in the either we you suggest like
      http :// servername :9704/analytics

      http :// servername :9704/xmlpserver

      Administrator/Administrator

      9704 is default port

      Finally it was not opening so I have deleted the that file /tmp/ismp001/4979638 and simply restarted the services and tried logging but it didnt happen.I wish that your expertise could suggest me some way

    61. jsethi3 says:

      I installed OBIEE in advanced mode over iAS. The ias port is 7777; but the instanceconfig.xml has port set to 80. Can you help me understand why?

    62. Suren says:

      Hi Atul,

      We are planning to move one of the instance from OBIEE server in domain A to OBIEE server in domain B.

      Is there any document which can help us in this?

      Many Thanks,

      Suren

    63. Mubarak Ali says:

      Hello Atul,

      i m littlebit confuse, working with BIEE do we need database server or not, one post your are telling no need DB server for BIEE, one post you are telling to use stand alone DB server, wand can use e-business suit db server(not recomended)

      we have db server alone, citrix alone using the db server, now i need to use BIEE, where can i install it, is it in citrix server?

      if i install like, could i connect the dbserver witch we have, or BIEE itself having DB server ?

      pls reply as soon as possible

    64. gautam_sen_in@yahoo.com says:

      Hi,

      Like the way we connect normal Oracle clients with a server database via tnsnames.ora, How we do the same mapping in case of Oracle BI client and server where they both reside in different physical machines?

      I have both client and server in my machine and with the help of NQSConfig.INI file we can map the rpd file resided in OracleBI\Server\Repository. But I am not sure how to establish the mapping when client and server reside in different machines. Can anybody please help me ?

    65. t.rojavenkat says:

      Hi,

      This is roja.i have one issue.please resolve this.
      1.we have installed Oracle AS(10.1.3.1) on abc windows machine.
      2.we have installed OBIEE server on xyz windows machine with basic option.
      3.we have installed OBIEE presentaion server on abc windows machine(same machine for for oralce AS) with ADVANCED option.
      Our final goal is configure OBIEE with SSO.
      But the probelm is we are not able to open OBIEE applciation page/url.And we have already IIS server on abc windows machine(which is used for Oracle AS).
      why this obiee url page is not opening. Is Oracle AS conflicting with IIS. shall we install the ORacle AS 10g on IIS machine.

      or we did any mistake in installation like adavanced or basic.

      please help us to proceed further.

      Regards
      Roja

    66. Naveen says:

      Hi Atul,
      I’m New to this blog and i want to install OBIEE from scratch.. Could you please tell me the necessary components reqd to be installed before installing OBIEE ?

      — like JDK, which version of Oracle DB reqd (10 and above or ..) etc..

      Awaiting your response ..

      Thanks,
      Naveen.

    67. t.rojavenkat says:

      Hi Atul,

      i dont see your reply.please reply to that issue.

      Regards,
      Roja

    68. Anil says:

      Hi,

      I am new to OBIEE. i need to setup OBIEE server, please provide me any document that details the steps to follow for OBIEE server setup.
      i did refer installation guide, more precise doc like with screen shots will be more helpful

      OBIEE version 10.x and to be installed on Windows 2003 server.
      we are planning to install all components on single machine.

      one more ?, generally on server, do we have Advanced or basic installation

      Your suggesations are most valued

      Thanks in advance
      Anil

    69. Atul Kumar says:

      @ Anil,
      Steps mentioned above should be enough to get you started on OBIEE and you can prepare your own step by step and share with readers.

      Q. generally on server, do we have Advanced or basic installation ?
      A. Its up to your requirement but usually on server its better to go for adanced as you get flexibility to configure components at install time

    70. psus2020 says:

      Atul and All,

      I get the following message when trying to install OBIEE 10.1.3.4.1 on my personal Windows XP Prof.

      “Please specify a valid Oracle Application Server 10g installation location. A valid Oracle Application Server 10g

      installation must have Oracle Container for J2EE (OC4J) and Oracle Process Manager and Notification Server (OPMN)

      installed. The default OC4J instance must be named home.”

      This is where I got stuck. I scanned thru the blog but I didnt notice any clear response on this message. I literally got stuck at this point. Any help would be appreciated.

      Prior to installing OBIEE, I have installed Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 which works just fine. In your step-by-step instructions I noticed to choose JAVA_HOME location but not ORACLE_HOME. In my case I get the prompt for ORACLE_HOME. I chose the location as C:|oracle\product\10.2.0\db_1. Later I get the above message to specify a valid OAS 10g installation.

      Please help.

      PS

    71. Atul Kumar says:

      @ PS,
      Are you doing basic install or advanced ?

      For advanced install you need 10g AS Release 3 (J2ee & opmn install)

    72. PS says:

      Thanks, I am doing advanced install.

    73. keerthi says:

      Hello Atul,

      I have installed it and it worked for me, but if I want to configure my own datawarehouse to Oracle Answers, then where should I do it.

    74. Swetat says:

      Hi Atul,
      I have been able to successfully install OBIEE on linux, however, I do not know where to install the Admin tool for creating and editing rpd on my Windows XP machine.
      Also, can you let me know the step by step of transferring rpd files from Windows to Linux.
      Anything in particular that I need to take care about.

      thanks

    75. Pavan says:

      Hi Atul,

      While installing i have faced the below error,
      “nQSError: 46036 Internal Assertion: Condition GetAdaptersinfo( pAdapterinfo.get(), &ulOutBufLen) == NO_ERROR, file .\Config\SUSystemConfig.cpp, line 1297″.

      But it continued the installationa and After Complete installtion the “BIServer” Services is not starting up.

      My Environment is Win XP with SP3 Enterprise Edition OBIEE 10.1.3.3.

      Could u pls helpme out.

    76. Dris says:

      Hi Atul,
      Can you help me. I have tu restart analytics and Publisher. But I have acces to application Server control.
      Error occured during initialization of VM
      Could not reserve enough space for object heap.
      thanks

    77. Atul Kumar says:

      @ Dris,
      Which application server you are using ? (Oracle 10g AS, WebLogic or Tomcat)

      This issue is mainly because of insufficient free memory on server .

      Two options :
      1. Increase free memory on server
      2. Decrease JVM heap size (this should be in environment file as per application server)

      If this is weblogic then check http://focusthread.com/blog/oracletraining/developertechnical/bpel-soa/error-occurred-during-initialization-of-vm-could-not-reserve-enough-space-soabpel11g-training-environment-setup/

    78. Dris says:

      Hi Atul,

      For the third party installation a use Java sdk 1.5.
      I do not have error during my installation by I can not display analytics and Publisher.
      Thanks

    79. Dris says:

      10/03/03 16:02:11 Oracle Containers for J2EE 10g (10.1.3.1.0) initialized
      2010-03-03 16:02:35.298 NOTIFICATION J2EE JSP-0008 Impossible de rÚpartir la pa
      ge JSP : Exception :oracle.jsp.provider.JspCompileException: Erreurs de comp
      ilation :C:\OracleBI\oc4j_bi\j2ee\home\application-deployments\analytics\analyti
      cs\persistence\_pages\\_default.java

      Could not create the Java virtual
      machine.
      Error occurred during initialization of VM
      Could not reserve enough space for object heap
      

      2010-03-03 16:03:06.102 NOTIFICATION J2EE JSP-0008 Impossible de rÚpartir la pa
      ge JSP : Exception :oracle.jsp.provider.JspCompileException: Erreurs de comp
      ilation :C:\OracleBI\oc4j_bi\j2ee\home\application-deployments\xmlpserver\xmlpse
      rver\persistence\_pages\\_login.java

      Could not create the Java virtual
      machine.
      Error occurred during initialization of VM
      Could not reserve enough space for object heap
      
    80. Lenin says:

      Hi Folks,

      I have windows 7 on may machine,how can i install obiee on windows 7.

    81. KiranK says:

      Hi Atul,

      I am trying to install OBIEE 10.1.4.1 on SUN Solaris SPARC 64 bit environment and am getting the OutOfMemoryError mentioned earlier in this blog.

      jagdeep mentioned that he resolved the issue by unzipping files under / (root) directory. Whats is the logic of this resolution, I mean what does it fix in the original problem? I will need to ask my SA to do it since i do not have the permissions on root.

      Please clarify.

      Thanks,
      Kiran

    82. jsethi3 says:

      Hi Kiran

      That is an old story now. The trick is to start a new session of unix as the user who is going to install OBIEE. Do not su to the user. Open a new session of shell and login as the orabiee (example) user and do the installation. This will source your display also and do the install. Let me know if you face any issue. This works fool proof. I have done umpteen installations now. (jsethi3@yahoo.com). Good Luck

    83. jsethi3 says:

      No need to unzip in the root anymore.

      Thanks,

      Jagdeep

    84. priya says:

      Hi Atul,
      I have installed OBIEE 10.3.4.1 in a linux machine.
      I am gettng the follwoing error while starting the BI server,in the nqsserver.out.log file.

      error while loading shared libraries: libmdxmembernamecache.so: cannot open shared object file: No such file or directory

      BI server is not getting started.

      Please clarify.

    85. Robert says:

      Hi OBIEE gurus,

      I’m trying to install OBIEE 10.1.3.4.1 on Windows server 2008 with JDK 1.6.0_20.

      In the past I’ve successfully installed on Windows server 2003 but only after changing some security settings.

      For the Windows 2008 install I’ve progressively made the OS as insecure as possible (aws scratch environment). I’ve tried localsystem and a named administrator. I am still getting the following error in the log:

      (May 24, 2010 2:00:17 PM), Install.product.install, com.siebel.analytics.install.ExecWizardActionCustom, err, com.installshield.util.ProcessExecException: CreateProcess: C:\OracleBI\oc4j_bi\bin\oc4j.cmd -start error=3
      STACK_TRACE: 7
      com.installshield.util.ProcessExecException: CreateProcess: C:\OracleBI\oc4j_bi\bin\oc4j.cmd -start error=3
      at com.installshield.util.ProcessExec.executeProcess(ProcessExec.java:180)
      at com.installshield.wizardx.actions.ExecWizardAction.executeProcess(ExecWizardAction.java:412)
      at com.installshield.wizardx.actions.ExecWizardAction.run(ExecWizardAction.java:457)
      at com.siebel.analytics.install.ExecWizardActionCustom.run(ExecWizardActionCustom.java:79)
      at java.lang.Thread.run(Unknown Source)

      I had this previously in 2003 but got around it by changing the local security policy. Any ideas for Windows 2008? I believe it is compatible with OBIEE 10.1.3.4.1?

    86. lucas rehem says:

      You make a poor brazilian happy in this bad day! TY

    87. Ash says:

      Hi Atul: I’m new to OBIEE and trying to install based on this doc on Windows 7-64 bit on home premium but i’m getting into the window-7 error and also tried with the workaround but i still can’t pass thru the error with non-supported OS versions. What am i missing? I tried for windows xp as well as windows vista, non of them seems to be helping.

      i greatly appreciate your help.

      thanks
      Ash

    88. minakshi says:

      Hi Atul: I have one question regarding Oracle BI Publisher.
      I schedule one report in BI publisher and in history its showing status as ‘Running’ from a long time, I want to terminate that process and want to stop the running report.
      But as I don’t no much about OBIEE I am unable to do that. Could you please help me with this.

      Thanks
      Minakshi

    89. Akshara says:

      Hi Atul,

      I installed OBIEE with ur help.Now want to configure adminstration tool to connect to schema in Oracle 11g, So went
      obi->Administartion tool->New Repository->ocl 10g/11g->but there i saw need data source name and un and pwd.

      From where i can get this info.
      I don’t have db installed in my machine.

      I could find this file tnsnames.ora only in
      C:\Oracle11gOBIEER1\Oracle_BI1\network\admin\sample

      This file is having just syntax descriptions.It don’t have any data.

      Thanks

    90. Atul Kumar says:

      @ Akshara,
      Which OBIEE version ?

      If 11g, Where is database for OBIEE which you installed ?

      If 10g, install database client and configure TNS (using net config) and point it to existing database.

      If you don’t have database either then you can install database on same machine or different machine (If you are installing database then databse client is not required – DB server comes with client)

    91. Akshara says:

      Hi Atul,

      Thanks for reply.
      I installed OBI 11.1.1 on my machine.
      The 11g db is installed on a server machine.
      While creating the RCU i gave the
      Hostname, port and service name of that server and it got connected.

      After installing bi
      Now when i am trying to import metadata ,by going to
      obi->Administartion tool->New Repository->ocl 10g/11g,In the
      data source name i gave the host:port:service name
      un: schema username
      pwd :schmea pwd (schema from where i want to fetch the table.)

      But its showing connection failed?

      Thanks

    92. Atul Kumar says:

      @ Akshara,
      Install database client on your machine first and then use netca to configure servive_name in tnsnames.ora on your PC which points to database server.

      Then use host:port:service name

    93. Darsh says:

      Atul,

      I have been a quiet student of your blog for a long time. Your postings deliver tremendous value and newbee like me get great insight on OBIEE.

      This time around, I have a project on BI APPS 7.9.5 (Not OBIEE 11g) but BI APPS 7.9.5 that comes with Oracle EBS R12.06

      This is about BI Apps 7.9.5 on Windows Server 2003.

      We have a need to migrate current BI Production Instllation (Two nodes DAC/Informatica layer and BI Apps) from one node to another.

      Take a Look at Following – This is the current architecture of our current BI Production Box

      ————————————————————————————–

      |——————-| |————————|
      | | | |
      | *NODE A* | | *NODE B* |
      | [INFORMATICA/DAC] | | [BI APPS Dashboards |
      | | | |
      | | | |
      |——————-| |————————|
      ^ ^
      | |
      | |
      | |
      |——————————————————————–|
      | | OMEGA – MACHINE | |
      | | | |
      | |———————| |——————–| |
      | | | | | |
      | | Repository DB | | BI APP DB | |
      | | | | | |
      | | | | | |
      | |———————| |——————–| |
      |——————————————————————–|

      ——————————————————————————————–

      From above diagram following things are clear

      1. There are two Nodes – Node A and Node B. Node A houses Informatica/DAC layer and Node B houses BI Apps Dashboards [This is Win Server 2003]
      2. There are two Oracle database instances – 1) Repository DB and 2) BI App DB, and they both reside on same machine called Omega(solaris).

      The Challenge

      Node A and Node B are outdated and desupported boxes. We have bought two bigger boxes with same processor but with better RAM and processing power. We will call them NODE C and NODE D. Both of these new machines (Node C and Node D) are also Win server 2003.

      We want to replace NODE A with NODE C And NODE B with NODE D.

      The question

      If we perform disc copy by getting the image of Node A and Node B and then replace that to Node C and Node D respectively, will it cause any issue to BI installations ? or will it cause any issue in connecting to OMEGA box? What are risks?

      So, In the end new archiecture should look like following.

      ————————————————————————————————
      |——————-| |————————|
      | | | |
      | *NODE C* | | *NODE D* |
      | [INFORMATICA/DAC] | | [BI APPS Dashboards]|
      | | | |
      | | | |
      |——————-| |————————|
      ^ ^
      | |
      | |
      | |
      |——————————————————————–|
      | | OMEGA – MACHINE | |
      | | | |
      | |———————| |——————–| |
      | | | | | |
      | | Repository DB | | BI APP DB | |
      | | | | | |
      | | | | | |
      | |———————| |——————–| |
      |——————————————————————–|

      ————————————————————————————————–

      Thanks,
      D

    94. monuS says:

      Hi Atul

      I am installing OBIEE 11g with a Oracle 10g as repository on Win XP 32 bit machine and every thing is working file till the step 11(configuration module). Its throwing class not found exception while creating ASInstance in the configuration setup.
      Please reply soon.

      Thanks and Regards

    95. Vijay says:

      Hi Atul,

      Actually my requriment is, need to change the obiee url (http://localhost:9704/analytics) instead of this i need http://voc.bi/analytics
      is it possible in BI.

      Could you please replay…

      Thanks,
      Vijay.

    96. Atul Kumar says:

      @ Vijay,
      Yes this is possible. Which OBIEE version you are using (10g or 11g) ?

    97. kalyana says:

      Hi Atul,
      Your information is very good!!!
      Is it possible to to know the steps how OBIEE ver 10g can be integrated with R12 and how the data can be accessed.
      Thanks in advance!!!

      Regards
      Kalyan

    98. Akshara says:

      Hello,

      I installed OBIEE 11.1.1.5 linux.
      Then installed BI client tool in windows.

      Is there a tnsnames.ora file in the BI client machine.
      What i want is i would like to create a repository in the client m/c with the connection type as OCI 10g/11g and then the dsn name same as tnsnames.ora file entry?

      Thanks
      Akshara

    99. Atul Kumar says:

      @ Akshara,
      No, I have not seen any tnsnames.ora which comes with BI client but if you have Database Client (with Admin tool) then you should be able to create tnsnames.ora

      You can also copy tnsnames.ora from any other machine in to your client machine to location %TNS_ADMIN%

      If this variable is not set then place tnsnames.ora in %ORACLE_HOME%\network\admin

    100. naresh says:

      Hi Atul,

      These posts are very helpful,thanks for sharing.

      Naresh

    101. Akshara says:

      Hello Atul,

      I am using OBIEE 11g, i would like to know if its possible to have only one export button per page for all the reports in one dashboard page.

      I have some 25 reports in one dashboard page and the user need to go to each and every report to export, rather is it possible to have just one export button to that page which can export all the reports to one PDF/PPT?XLS?

      Thanks
      Akshara

    102. Kits says:

      Hi Atul,
      Please provide information / step by step procedure on installing BIAPPS 7962(OBIEE, BIAPPS, INFORMATICA, DAC) on a 64 bit Linux.
      I have to do the installation in dev/test/prod.
      Thanks much!!

    103. Pal says:

      HiAtul,

      I am getting following error on OBIEE install 64bit on windows 2008 server:

      nqsclustercontroller.exe has stopped working

      Any thoughts on this?

      Appreciate your help.

      Thanks.

    104. Sajeesh says:

      Hi Atul,

      We have an OBIEE 10.1.3.3.2 instance. I would like to upgrade this to 11g. Could you please tell me, whether I can upgrade directly to 11.1.1.5?

      Regards,
      Sajeesh

    105. Rahul says:

      Hi Atul,

      we are having a clustered environment in our obiee 10g where we have jboss and apache pieces why do we require jboss and apache in obiee 10g what is the role of each of them in obiee

    106. Atul Kumar says:

      @ Rahul,
      OBIEE is j2ee application which runs on application server. JBoss is J2EE application server and Apache HTTP server is webserver. I am assuming in your case OBIEE is deployed in JBOSS (application server deployed to run OBIEE). Apache HTTP server is webserver to sitting in DMZ as reverse proxy infront of JBoss.

    107. Rahul says:

      @ Atul,

      thanks for your clarification. thanks a ton

    108. Mayuri M says:

      Hi all,
      After installation of OAS i am getting an error as:
      Error occurred during initialization of VM
      Could not reserve enough space for object heap
      Could not create the Java virtual machine.
      what changes should i make to opmn.xml file??
      Please suggest

    109. Atul Kumar says:

      @ Mayuri M,
      Error message indicates that you do not have enough memory available on server (that can be allocated to JVM – Java Virtual Machine)

      How much free memory do you have on server ?

    110. Mayuri M says:

      Sorry to say but how do i check the memory on Server??
      I have following values in the opmn.xml file for OC4J module :

    111. Mayuri M says:

      =”-Xrs -server -XX:MaxPermSize=256M -ms1536M -mx1536M -XX:NewSize=256M -XX:MaxNewSize=256M

    112. Atul Kumar says:

      This means JVM is configured for 1.5 GB size , you should have atleast 1.75 GB free memory on server.

      If this is Linux you can use “top” or “free -m”

    113. Venkat says:

      Hi, i’m trying to install BIEE version
      10.1.3.2.1 in OEL 5,But the setup stops with the reason OEL 5 is not supported for this version. Please tell me what packages i need to install in my machine to run this setup.

    114. Atul Kumar says:

      @ Venkat,
      If OBIEE 10.1.3.2.1 is not certified with OEL 5 then you could hit issues.

      Start installation and if you hit problem post it here and will then suggest missing packages based on error message

    115. sharma_rekha2 says:

      Hi Atul,
      Good stuff on OBIEE.Its made me help lots

    116. san says:

      Hi
      When I am trying to install OBIEE11g in my Laptop with the simple installation option the process is not progressing while I am giving Adminstartion details step. I am giving weblogic user which is default and give the password as per the guidance. please suggest me.
      I have installed RCU successfully.

      Regards – San

    117. shreyas says:

      Hi,
      I am facing same error ‘End tag does not match start tag ‘group’ after upgradation of BI Publisher 10g from 10.1.3.4.0 to 10.1.3.4.2.
      template files are not generating (User > Report > Layouts > Auto Generate Layout). it gives error ‘Failed to Load Auto Layout’.

      application.log says:

      End tag does not match start tag ‘group’.
      at oracle.xml.parser.v2.XMLError.flushErrors1(XMLError.java:320)
      at oracle.xml.parser.v2.NonValidatingParser.parseEndTag(NonValidatingParser.java:1395)
      at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1340)
      at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:362)
      at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:308)
      at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:306)
      at oracle.apps.xdo.dataengine.DataProcessor.getSQLRTFLayout(Unknown Source)
      at oracle.apps.xdo.dataengine.DataProcessor.writeDefaultLayout(Unknown Source)
      at oracle.apps.xdo.servlet.resources.ResourceServlet.createAutoLayout(ResourceServlet.java:288)
      at oracle.apps.xdo.servlet.resources.ResourceServlet.service(ResourceServlet.java:144)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      at oracle.apps.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:100)
      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)
      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)
      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)
      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216)
      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
      at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      at com.evermind[Oracle Containers for J2EE 10g (10.1.3.1.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.jav:303)

      i am not able to troubleshoot this issue. Please help me on this.

    118. joe says:

      Hi,

      run-sa.sh = 0 byte
      on obiee10.2.5 Platfrom Unix

      Obiee not startup

      help Please

    119. Sairam says:

      Hi Atul,
      I am installing OBIEE 10.1.3.4.2 in OEL 5.4
      I downloaded and unzipped in windows then ftp to linux machine.installed jdk 1.6

      while run the ./setup.sh setting issue like
      license.xml the license file does not match its signature please contact Sibel technical support

      Please help me.
      Thanks in Advance.

    120. tapfuma says:

      Do you know have any information on integration of OBIEE 10.1.3.4.1 and PeopleSoft EMP ver 9 ? (pref Fiancial Module)

    121. new2obiee says:

      Hi Atul,

      My name is Priya,am new to OBIEE.
      please can you help me with OBIEE Issue.

      I installed oracle database 11g R2 and OBIEE 10.1.3.4.2(I got it from oracle website)on Windows 7 Ultimate.Softwares installed sucessfully.

      but during the process of creating a New repository I got a problem.
      After entering Data source name:SH
      TNS service name:ORCL
      user id & pwd:SH
      and when am trying to Hit Test connection In Oracle ODBC Driver configuration It has given the following error.

      Unable to connect SQLstate=S1000[oracle][ODBC][ora]ORA-28000:The account is locked.

      Before creating New repository in the prerequisites its asking to install
      the sample schemas and establishing a Database connection OBE tutorial,but I did’nt installed that.

      so do you think the problem could be with this because I have not installed sample schemas.

      even I tried to install that but I could not able to find the proper sample schemas for that.
      please help me sir

      • Atul Kumar says:

        @ new2obiee,
        SH schema that you are using is locked. You need to unlock it so loging to database as sysdba (sqlplus “/as sysdba”)

        SQL> alter user SH account unlock;

    122. new2obiee says:

      Hi Atul,

      My name is Priya,am new to OBIEE.
      please can you help me with OBIEE Issue.

      I installed oracle database 11g R2 and OBIEE 10.1.3.4.2(I got it from oracle website)on Windows 7 Ultimate.Softwares installed sucessfully.

      but during the process of creating a New repository I got a problem.
      After entering Data source name:SH
      TNS service name:ORCL
      user id & pwd:SH
      and when am trying to Hit Test connection In Oracle ODBC Driver configuration It has given the following error.

      Unable to connect SQLstate=S1000[oracle][ODBC][ora]ORA-28000:The account is locked.

      Before creating New repository in the prerequisites its asking to install
      the sample schemas and establishing a Database connection OBE tutorial,but I did’nt installed that.

      so do you think the problem could be with this because I have not installed sample schemas.

      even I tried to install that but I could not able to find the proper sample schemas for that.
      please help me sir

    123. new2obiee says:

      Hi Atul,

      I connected to database as sysdba using connect / as sysdba and it got connected and then I unlocked it using alter user SH account unlock.everything went fine.
      then again I tried to create new repository by entering same below details

      Data source name:SH
      TNS service name:ORCL
      user id & pwd:SH

      but again it had shown below error

      Unable to connect SQLstate=28000[oracle][ODBC][ora]ORA-01017;Invalid username/password;login denied.

      In the OBIEE tutorial “creating a repository using OBIEE Admin tool” which I found in Oracle website for beginners.

      They have clearly mentioned in the prerequisites that to Create a directory named SetupFiles under .Download and extract the SH.zip file from here to this directory named SetupFiles.

      and also they mentioned For all others, before starting this tutorial, you should meet the following prerequisites:
      1.Have access to or have installed Oracle 10g Database.
      2.Have access to or have installed the sample schema. This tutorial uses the SH schema included in the Oracle10g Database.
      You can also install the schema by following the instructions found in the Installing the Sample Schemas and Establishing a Database Connection OBE tutorial.

      they have clearly mentioned that SH schema is included in oracle 10g database.
      but am using Oracle 11g R2 11.2.0.1.0,and I have not installed any SH sample schema.
      I tried alot to install the schema,but I could not find anywhere in the Net.
      so do you think the error is giving because I have not installed SH sample schema.

      Please help me with my issue.

    124. new2obiee says:

      Hi Atul,

      I connected to database as sysdba using connect / as sysdba and it got connected and then I unlocked it using alter user SH account unlock.everything went fine.
      then again I tried to create new repository by entering same below details

      Data source name:SH
      TNS service name:ORCL
      user id & pwd:SH

      but this time it had shown login denied error

      Unable to connect SQLstate=28000[oracle][ODBC][ora]ORA-01017;Invalid username/password;login denied.

      In the OBIEE tutorial “creating a repository using OBIEE Admin tool” which I found in Oracle website for beginners.

      They have clearly mentioned in the prerequisites that to Create a directory named SetupFiles under .Download and extract the SH.zip file from here to this directory named SetupFiles.

      and also they mentioned For all others, before starting this tutorial, you should meet the following prerequisites:
      1.Have access to or have installed Oracle 10g Database.
      2.Have access to or have installed the sample schema. This tutorial uses the SH schema included in the Oracle10g Database.
      You can also install the schema by following the instructions found in the Installing the Sample Schemas and Establishing a Database Connection OBE tutorial.

      they have clearly mentioned that SH schema is included in oracle 10g database.
      but am using Oracle 11g R2 11.2.0.1.0,and I have not installed any SH sample schema.
      I tried alot to install the schema,but I could not find anywhere in the Net.
      so do you think the error is giving because I have not installed SH sample schema.

      Please help me with my issue.

    125. Atul Kumar says:

      @ new2obiee,
      Reset password of SH as

      SQL> alter user SH identified by ;

      Try using this new password.

    126. new2obiee says:

      In order to change PWD do I need to login as sysdba or it should be in sql plus environment,please can you give the complete query which is used to change PWD.

    127. Atul Kumar says:

      Login as sysdba

      sqlplus “/as sysdba”

      SQL> alter user SH identified by welocme1 ;

      Try using this new password as welcome1

    128. new2obiee says:

      Hi Atul,

      Test connection shown successful,when I changed password to welcome1.
      but when I tried to Import SH schema from OBIEE Admin Tool the SH schema is not appearing in the select data source under connection type under ODBC 3.5.I can see only DSN:Analytics web and Driver:Oracle BI server in select datasource under ODBC 3.5.and even I cannot see the SH schema under any connection type.
      but even the SH schema as added under system DSN under ODBC Data source Administrator.Please can you suggest what I need to do.

    129. new2obiee says:

      Hi Atul,

      Test connection was successful when I changed password to welcome1.
      but when I tried to Import SH schema from OBIEE Admin Tool the SH schema is not appearing in the select data source under connection type ODBC 3.5.I can see only DSN:Analyticsweb and Driver:Oracle BI server in select datasource under ODBC 3.5.
      and even I cannot see the SH schema under any connection types(ODBC 2.0,DB2 CLI(unicode),XML,OCI 10g/11g.
      but when I checked System DSN in ODBC Data Source Administrator even the SH schema was added as (Name:SH Driver:Oracle in OraDb11g_home1).everything looks ok,but still I dont understand why SH schema is not appearing when am trying to Import it from Database in Oracle BI Administration.
      Please can you suggest what I need to do.

    130. New2obiee says:

      Hi Atul,

      Please can you answer my previous question.
      am waiting for your reply with eager.

    131. New2obiee says:

      Atul,

      Please can you reply to my question posted on August 17th 2012
      I have not heard anything from you since I posted the question.
      Kindly awaiting for your reply with eager

    132. New2obiee says:

      Hi Atul,

      Are you receiving my posts about Obiee,I keep on posting my question for the past 4days,but there is no reply from u for my question.

    133. New2obiee says:

      Dear friends,

      My friends my name is Priya,am new to this blog.

      Please any one can answer to my question posted on Aug 17 2012.
      I would really appreciate your help.

    134. New2obiee says:

      Dear friends,

      My name is Priya,am new to this blog.

      Please any one can answer to my question posted on Aug 17 2012.
      I would really appreciate your help.

    135. New2obiee says:

      Hi Friends

      Not even a single person is there in this blog to resolve a basic and simple question which I posted on August 17th or otherwise you guys are just Ignoring it as a silly question.when I have seen this blog for first time I expected a lot from this blog and thought my issue will be fixed so easily but now am totally disappointed the way that no one is caring at all.

    136. OBIEE2012 says:

      Hi sir,

      Do you provide any type of online training.
      am looking for a online training for OBIEE.
      If so please can you provide all the details at my email I’d

    137. New2obiee says:

      Atul,

      Please can you tell me whether OBIEE 10g/11g can be installed on Windows 7 Home premium OS with 64 bit.

      I mean will Windows 7 Home premium supports OBIEE 10g or 11g.

    138. Ram says:

      @New2obiee/Priya

      yes you can install obiee 10g/11g on windows 7 machine without any problems. But for 10g you just need to right click on the setup.exe file and run compatibility check then you should be good.

    139. Neha says:

      While installing OBIEE – i am getting failure on Creating ASInstance. Error as follows :

      trying to connect to DELMW58220 7001
      oracle.as.provisioning.exception.ASProvisioningException
      at oracle.as.provisioning.engine.Config.executeConfigWorkflow_WLS(Config.java:872)
      at oracle.as.install.bi.biconfig.standard.StandardWorkFlowExecutor.executeHelper(StandardWorkFlowExecutor.java:31)
      at oracle.as.install.bi.biconfig.standard.InstanceProvisioningTask.doExecute(InstanceProvisioningTask.java:81)
      at oracle.as.install.bi.biconfig.standard.AbstractProvisioningTask.execute(AbstractProvisioningTask.java:70)
      at oracle.as.install.bi.biconfig.standard.StandardProvisionTaskList.execute(StandardProvisionTaskList.java:61)
      at oracle.as.install.bi.biconfig.BIConfigMain.doExecute(BIConfigMain.java:112)
      at oracle.as.install.engine.modules.configuration.client.ConfigAction.execute(ConfigAction.java:335)
      at oracle.as.install.engine.modules.configuration.action.TaskPerformer.run(TaskPerformer.java:87)
      at oracle.as.install.engine.modules.configuration.action.TaskPerformer.startConfigAction(TaskPerformer.java:104)
      at oracle.as.install.engine.modules.configuration.action.ActionRequest.perform(ActionRequest.java:15)
      at oracle.as.install.engine.modules.configuration.action.RequestQueue.perform(RequestQueue.java:63)
      at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:158)
      at oracle.as.install.engine.modules.configuration.boot.ConfigurationExtension.kickstart(ConfigurationExtension.java:81)
      at oracle.as.install.engine.modules.configuration.ConfigurationModule.run(ConfigurationModule.java:83)
      at java.lang.Thread.run(Thread.java:662)
      Caused by: java.lang.OutOfMemoryError: PermGen space

      Any pointers ?

    140. sana says:

      hi Atul,

      I am trying to install obiee 11.1.1.6 on windows 7 home with 64 bit.IN the configuration process it’s failed in Create Domain.

      In the log i found that nodemanager.properties file not getting created.

      ——————–FROM LOG FILE———–
      ERROR : Time out occured : nodemanager.properties file not created !!
      java.io.FileNotFoundException: C:\OBIEE\wlserver_10.3\common\nodemanager\nodemanager.properties (The system cannot find the file specified)
      at java.io.FileInputStream.open(Native Method)
      at java.io.FileInputStream.(FileInputStream.java:120)
      at oracle.as.provisioning.weblogic.ASDomain._startNodeManager(ASDomain.java:3688)
      ————————————-

      Any suggestion on how to deal.I am doing Simple install.I have set MS Loopback adapter.Temp has no spaces.

      Thanks

      • Atul Kumar says:

        During install at time of startup , Node manager startup should create nodemanager.properties. Try starting nodemanager manually and see if it creates nodemanager.properties

    141. sana says:

      hi,

      I tried starting the nodemanager but its not creating the properties file.In the nodemanager.log file its giving same error.

      Log file
      ———-

      java.lang.NullPointerException
      at java.util.Hashtable.containsKey(Hashtable.java:307)
      ——————–

      Thanks

    142. viveksathe says:

      Can anyone provide similar step by step OBIEE Installation for the latest downloadable version in 11G 11.1.1.6.

      Purpose is to learn OBIEE on home computer and have access to vision instance.

      I am stuck at one point – RCU installation.

      Is it necessary to have Repository Creation Utility installed on my machine?

      I did download RCU while activating started getting some error around database version 11.1.0.7.0 not being a supported version.

      Look forward to some suggestions that a functional person can follow.

      thanks

    143. Atul Kumar says:

      @ Viveksathe ,

      Check this for OBIEE 11g (11.1.1.6)

      http://onlineappsdba.com/index.php/2011/05/01/obiee-11g-installation-high-level-steps/

      RCU is used to create schema and for 11.1.1.6 RCU there are some pre-reqs . More on RCU at http://onlineappsdba.com/index.php/2009/07/03/oracle-fusion-middleware-11g-repository-creation-utility-rcu/

      What is actual error ?

      If error is “database version 11.1.0.7.0 not being a supported version.”

      Then install 11gR2 database i.e. 11.2.0.1 for OBIEE repository

    Leave a Reply



  • K21 Technologies is among the most experienced Oracle Gold Partner for Identity Access Management service providers. We work with application development companies and in-house technology division to help achieve significant returns on their IT security investment. Our clientele includes some of the globally renowned corporate, which speaks of our expertise in our field.

    We have the most talented and experienced team that can swiftly deploy security solutions even in complex IT ecosystem. Our clients highly appreciate our timely implementation, interactive training, on-demand support and community resources.
  • CONTACTS

    K21 Technologies
    8 Magnolia Place, Harrow,
    London, HA2 6DS

    UK: +44(0)7476444481
    USA: +1-888-414-1821

  • 2014, K21 Technologies. All rights reserved DMCA.com
  • TOP