My Blog

Installing OBIEE 12c. Part 4: Configuring & Starting OBIEE

by Paul Cannon on 11th November 2015 81 comments

This is the fourth (and final!) part of a series of blogs showing how to perform a standard single server/instance installation of OBIEE 12c. In the first part I covered the prerequisites of JDK and Fusion Middleware. In the second part I performed the basic software installation for OBIEE; and in the third part covered creating the database repositories required for OBIEE.

In this final part I will perform the configuration of OBIEE 12c. This will setup the domain with Fusion Middleware, configure the BI components and most importantly setup the URLs so you can connect!

This is performed with the configuration utility which can be found under <obiee_home>/bi/bin

You need to be a little careful here, there are two config.sh (config.cmd for windows) files, but in different directories.

<obiee_home>/bi/bin contains the one for standard single server installations

ORACLE_HOME/oracle_common/common/bin contains the one for enterprise deployments. This is far more comprensive than the single server installation and allows you to configure multiple instances on multiple servers.

So to start the standard configuration utility:

cd /u01/app/obiee/bi/bin
./config.sh

As usual this is a graphical wizard, so you may need an x-windows emulator for linux/unix servers.

Unusually the welcome screen includes some options – don’t simply skip past as usual!

In here you get to choose which BI components you wish to configure:

  • Business Intelligence Enterprise Edition – the main BI product
  • Business Intelligence Publisher – if you need “pixel perfect” professional formatted output
  • Essbase – if you want to use the BI accelerator to speed up reporting for users

 

A quick word on the Essbase option. There is a new component in OBIEE 12 called the “Essbase Business Intelligence Acceleration Wizard”. This is a tool that will build Essbase cubes based on fact/dimension structures in the RPD. It will interrogate the RPD for the hierarchies & data sources, build an Essbase ASO cube, load the dimensions and data and finally configure the RPD to use it, all via a small number of simple screens. I will probably blog about this separately later on.

However the full Essbase development tools are no longer available. You cannot use the Essbase Admin Console or Essbase Studio to build your own cubes and manually load them into the RPD – that’s not the reason Essbase is included within the OBIEE 12c product suite any more.

You can still implement Essbase separately from OBIEE 12c and import the cubes you build into OBIEE just as you could under OBIEE 11g, but that would be a completely separate implementation from OBIEE and of course require specific Essbase licences.

So why would you not simply tick all three options and carry on? I guess if you never intend to use any of these components then there is no point installing them – if you include Essbase then the Essbase agent and associated services will always be running, unnecessarily using resources if you never intend to use it.

So select your options and carry on.

Install_OBIEE12c_part4_1

Then the standard prerequisite checks are performed to ensure the server is configured correctly. I’m not really sure what the difference is between this pre-req check and the same one that happened during the earlier software install (in part 2 of this blog series). The list of checks seems to be identical.

Install_OBIEE12c_part4_2

So now we need to specify some details for the new BI domain.

All three of the settings for “Location of New Domain” default to the values:

Domains Directory:          <obiee_home>/user_projects/domains

Domain Name:                  bi

Domain Home:                  <obiee_home>/user_projects/domains/bi

And you can change each of these if you see fit. Right now these are fine for me, so I’m going to leave them as they are.

Beneath these you need to specify the user name and password domain administrator. Again weblogic is the default, but can be changed and you must enter a password. Initially once the OBIEE 12c installation is complete you can login to the Weblogic Console, Enterprise Manager and OBIEE with this user-id (as we’ll see later on).

Install_OBIEE12c_part4_3

Now the wizard needs to know if you’ve already created the database repository schemas and if so where. This was done in part 3 of this blog series, however you do have the option of not installing the schemas with the RCU and letting this wizard do it for you.

If you did use the RCU, then choose ‘use existing schemas’, enter the connection string for the repository database and specify the prefix used on the schema names and the password.

There’s an interesting point here. In the RCU you have the ability to enter a single password for all schemas or individual passwords for each one. But in the screen below you are only asked for one password. I assume this is the password to the xxx_BIPLATFORM schema

Install_OBIEE12c_part4_4

If you decide to skip the RCU step and let this wizard create the schemas the screen appears as below. There are fewer options available:

  • The only database type options are Oracle, Oracle RAC or MS SQL Server (no IBM DB2 or MySQL).
  • You can’t specify different passwords for each schema.
  • You can’t control the tablespaces the schemas are created in.

Install_OBIEE12c_part4_5

Next you need to specify the port range for the BI and WLS processes to use. There are quite a few port numbers required and it doesn’t seem to use then sequentially. Weblogic itself (console and enterprise manager) will get the first port number, the various OBIEE components will get allocated numbers in the next 15 or so, Essbase if included will get some much higher numbers.

I’ve left the default port range at 9500 to 9999. Which means the following ports get allocated:

Weblogic console/enterprise manager:    9500

OBIEE: 9502

Presentation Services: 9507

BI Server: 9514

BI Schedule: 9511

BI Cluster Controller: 9508

BI Java Hosts: 9510

Essbase Agent: 9799

All of these ports can be found in the enterprise manager after installation.

I’ve not so far found any options for specifying specific ports (as per the static-ports.ini file in OBIEE 11g)

Install_OBIEE12c_part4_6

You’re then asked if you want the sample application installed or your own BI application – this is an interesting new feature allowing you to install OBIEE with a pre-built suite of reports/dashboards etc… Definitely worth investigating later on.

Install_OBIEE12c_part4_7

The summary screen then displays showing the settings you’ve selected and main URLS for accessing the weblogic console, enterprise manager, OBIEE and BI Publisher (they’ve still not renamed this URL from xmlpserver…)

I usually save the response file at this point so I have a record of these details.

Install_OBIEE12c_part4_8

Clicking Configure then begins the process…

This can take a while to run through…took around 45 minutes for me on a slowish VM.

Install_OBIEE12c_part4_9

If you chose to let this wizard create the database repository schemas then it is done during this step as one of the long list of tasks – you shouldn’t see anything happen other than another ‘Success’ tick.

Once complete you will get the configuration complete screen:

Install_OBIEE12c_part4_10

This mentions the ports that have been allocated to each of the OBIEE components… except for the BI Server – the one you need to know the most as you’ll need it when you install the client tools and create an ODBC connection for the Administration Tool. If using the default port range it will be on 9514, alternatively look in the enterprise manager.

Click finish to close down the configuration wizard.

Upon closing it attempts to open a browser so you can login to OBIEE, but in my case it couldn’t find the default browser – no idea why, I’ve got three (IE, Firefox & Chrome) and entering the path to either of them did nothing:

Install_OBIEE12c_part4_11

No matter, I know how to open a browser…

So, enter the URL given in the summary screen above, in my case: http://linux66.local.com:9502/analytics

Install_OBIEE12c_part4_12

Use the weblogic (or whatever you changed it to above) user-id/password to login:

Install_OBIEE12c_part4_13

Definitely more colourful and some new features are immediately apparent – ‘Data Exploration & Discovery’ (Visual Analyzer) and the link to the new Home Page, which is at the alternative URL: http://<server_name>:9502/va

Install_OBIEE12c_part4_14

But back at the main OBIEE home page everything else is pretty much where it used to be and you can quickly view dashboards, create reports, etc. as you could before.

Install_OBIEE12c_part4_15

The final piece of the puzzle for installing OBIEE 12c is knowing how to start and stop all of its services. This is much simpler than before as there are now single scripts to start, stop and view the status of OBIEE.

These are all located in the <obiee_home>/user_projects/domains/bi/bitools/bin directory. The scripts being

  • start.sh
  • stop.sh
  • status.sh

(Presumably .cmd  or .bat equivalents under windows).

So to start OBIEE:

cd /u01/app/obiee/user_projects/domains/bi/bitools/bin
./start.sh

Which once complete will show the following:

Install_OBIEE12c_part4_16

So there you have it, OBIEE 12c all installed, configured and running. There are a lot of differences to earlier versions, not just in functionality and look & feel, but also in the background and how it is deployed within the newer version of Weblogic. Keep an eye on our blogs for more!

Enjoy!

Paul CannonInstalling OBIEE 12c. Part 4: Configuring & Starting OBIEE

81 comments

Join the conversation
  • Muhammad Idrees - 14th November 2015 reply

    Great.
    could you kindly tell us how to create start menu items in windows for strat, stop services and the bi administration tool please?
    Thanks

    Paul Cannon - 14th November 2015 reply

    Muhammad,

    start/stop entries in the start menu are not created – you’d need to create your own shortcuts from the /user_projects/domains/bi/bitools/bin/start.cmd & stop.cmd files. For the BI admin tool you’ll need to install the client tools -this can be downloaded from the OBIEE home page.

    Paul.

    Muhammad Idrees - 16th November 2015 reply

    Correct and So Nice.
    one question please,

    we dont have the user.cmd file, so how could we let the bi know our tnsnames.ora file location? we need it in bi administration tool.
    in obiee 11g, the process was like below

    Try to connect through oci 10/11g.

    If connectivity problems occurs, do the following

    1. Copy the tnsnames.ora from Oracle Database home (ORACLE_HOME\NETWORK\ADMIN\) to the following locations.
    o \OracleBI1\network\admin (Example: C:\OBI\Oracle_BI1\network\admin)
    o \oracle_common\network\admin (Example: C:\OBI\oracle_common\network\admin)
    2. Set the TNS_ADMIN environment variable value with one of the copied locations in the step 1 in user.cmd or user.sh file depending on your OS. This file will be found under \instances\instance1\bifoundation\OracleBIApplication\coreapplication\setup (Example : C:\OBI\instances\instance2\bifoundation\OracleBIApplication\coreapplication\setup)
    3. TNS_ADMIN= C:\app\MiddlewareOBIEE\Oracle_BI1\network\admin
    4. Set ORACLE_HOME environmental variable
    5. Restart OBIEE services.

    how to do that in obiee12c because i am not finding one of the TNSNAMES file in obiee and the USER.CMD file

    Once again, thank you so much for such a nice and thorough blog.
    Regards.

    Paul Cannon - 20th November 2015 reply

    Hi Muhammad,

    I solved this problem by simply copying a tnsnames.ora file into the client installation directory. There is already a ‘network’ directory after the install, but no admin beneath it, so I created an admin directory then copied into it a tnsnames.ora file. After restarting the admin tool I was able to reference the tns entry for my database during a metadata import.

    Paul.

    David Zhou - 21st January 2016

    Very helpful! Thanks!

    Satyaa Shukla - 17th May 2016

    Thanks Paul… 🙂

  • vissu - 17th November 2015 reply

    Hey That was nice blog and I was able to complete the installation seemlessly.
    I have a question on how to migrate the RPD ,webcatolog and security files from my existing 11.1.1.9.0 version to 12c

    Regards,
    Prasad

    Paul Cannon - 20th November 2015 reply

    Hi Prasad,

    I’ve not had chance yet to play with the migration of content from 11g, no doubt that’ll be a separate blog when I do. In the meantime all I can suggest is reading the migration doc that can be found on technet in the OBIEE12c documentation.

    Paul.

  • Siva Pratap - 3rd December 2015 reply

    I’m facing a strange issue. At the end of the configuration while the BI components were getting started, I received errors saying “nqsserver.exe stopped working”. Installation was completed successfully though. But the Presentation server is not coming up. All the other services are showing alive. When I try to start the PS manually, I receive the same errors “nqserver.exe stopped working” and the BI Server also goes down automatically. Any thoughts on this please?

    Paul Cannon - 8th December 2015 reply

    Siva,

    the only thing I can suggest is to look in the log files to see what errors are being generated behind the scenes – these may give you clues as to your problem. The logs are all located under /user_projects/domains/bi/servers

    Paul.

    Siva Pratap - 9th December 2015 reply

    Hi Paul,

    All I can see in the log is this. But there is no specific reason for it.

    Siva Pratap - 9th December 2015 reply

    Siva Pratap - 9th December 2015 reply

    Dec 3, 2015 6:49:36 PM IST>

    <Server failed but will not be restarted because the maximum number of restart attempts has been exceeded

    Siva Pratap - 9th December 2015 reply

    The server ‘obips1’ with process id 9448 is no longer alive; waiting for the process to die
    Process died.
    Server failed during startup. It may be retried according to the auto restart configuration.
    get latest startup configuration before deciding/trying to restart the server
    Server failed but will not be restarted because the maximum number of restart attempts has been exceeded

    Paul Cannon - 9th December 2015 reply

    Siva,

    If that’s the only log entries you can find then I’m afraid I can’t really help – you will need to contact Oracle support to see if they can help you track it down.

    Paul.

    Siva Pratap - 5th July 2016

    I did fix this issue. The solution is posted here http://obiapps4u.blogspot.com/2015/12/presentation-services-not-starting.html

    vikas - 4th January 2016 reply

    Did you ever find the solution?

    Stewart Bryson - 18th February 2016 reply

    Siva: most likely you have a corrupted repository and the BI Server simply cannot start. I’d recommend using the BAR file utility to re-import something deterministic, such as the SampleAppLite BAR file, and then see if the BI Server will start. 10-1 says it does.

    Siva Pratap - 5th July 2016 reply

    Thank you, it was because of the OBIEE 11g installation I had!! Fixed it.

  • vikas - 4th January 2016 reply

    I am also getting “nqserver.exe stopped working” – Does any one found a solution?

    Siva Pratap - 5th July 2016 reply

    The solution is posted here http://obiapps4u.blogspot.com/2015/12/presentation-services-not-starting.html

  • depp - 5th January 2016 reply

    Is BI Admin tool available in obiee 12c for “””LINUX”” or we need to connect from remote like OBIEE 11g ??

    Paul Cannon - 5th January 2016 reply

    No, the Admin tools is still a windows-only utility, so you’ll need to connect via the same type of ODBC connection as 11g.

  • Sujata - 12th February 2016 reply

    Nice Post.!!

  • Burak - 17th February 2016 reply

    Hi everyone,

    ım starting to learn oracle bi and first i should install it and i was start step by step to install it tii configure.. When i trty to configure im seeing some errors and i dont have any idea about it. Please help me

    2016-02-17T21:48:12.895+02:00] [bi] [ERROR] [] [oracle.bi.install.config.actions] [tid: 44] [ecid: 0000LBklcA29TcYFLrrI8A1MlCnC000004,0] Non-skipped failure during configuration action: Execution of [cmd, /c, C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\oracle_common\bin\rcu.bat, -silent, -createRepository, -useSamePasswordForAllSchemaUsers, true, -databaseType, ORACLE, -connectString, localhost:1521/orcl, -dbUser, sys, -dbRole, sysdba, -selectDependentsForComponents, true, -schemaPrefix, DevB, -component, WLS, -component, MDS, -component, OPSS, -component, STB, -component, BIPLATFORM] failed with exit value 1[[
    oracle.bi.exec.ExecutionStatusException: Execution of [cmd, /c, C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\oracle_common\bin\rcu.bat, -silent, -createRepository, -useSamePasswordForAllSchemaUsers, true, -databaseType, ORACLE, -connectString, localhost:1521/orcl, -dbUser, sys, -dbRole, sysdba, -selectDependentsForComponents, true, -schemaPrefix, DevB, -component, WLS, -component, MDS, -component, OPSS, -component, STB, -component, BIPLATFORM] failed with exit value 1

    my error is like this

    how should i fix this?

    Brandon - 17th June 2016 reply

    You ever fix this? I’m having same issue.

  • Soheil Gharedaghi - 23rd February 2016 reply

    I installed The OBIEE 12c and it’s works like charm, for your info my DB is on mssql 2012r2, and there is no problem, but when I login into analytic and change some of weblogic or any users account properties like default home page or language or time zone, they change will applied till the user is logged-in, when the user logged out everything restored to default, I reconfigured REPO and changed the db to another serves but this problem not solved.

    Regards

  • Sébastien Bujold - 21st March 2016 reply

    @Soheil, did you fix your problem? i have same here.

    Soheil Gharedaghi - 25th April 2016 reply

    No, i think it’s a bug.

    Oier Fernandez - 4th October 2016 reply

    Hello here, i have the same problem , any fix already?

  • Vinesh Kumar - 30th March 2016 reply

    Thanks for sharing this post it really helped me a lot in installing OBIEE12c in windows environment. I am looking for the steps which can help me in configuring BI for SSO. I got some of the documents but not able to find related to 12c. Request you to please share the same..
    Thanks in advance

  • Geoff Winkworth - 14th April 2016 reply

    We’re also looking for anything pertaining to SSO configuration; specifically, enabling SSO between Analytics and Visual Analyzer. We’ve cracked the LDAP authentication, custom roles, and provisioning nuts; and have successfully enabled SSO to Analyzer using iPlanetLDAP, but when we navigate to VA, we still get prompted for credentials.
    Thank you.

  • Sandra - 10th May 2016 reply

    Thanks for sharing the post. Do yo have any manual to install multiple instances on multiple servers? I’ve seen that it is possible with ORACLE_HOME/oracle_common/common/bin/config.sh command, but I don’t know how to complete lots of parameters that they are asked for.

  • Stephen - 16th May 2016 reply

    Has anyone seen an error like this: Failed to get anonymous properties.

    I get this when going to the Enterprise Manager. Then going to WebLogic Domain — Security — Security Provider Configuration. This is an install with oracle samples. Have not even migrated our Webcat or RPD yet.

  • TimK - 17th May 2016 reply

    Thank you – this was an extremely easy guide to follow. Hope to return the favour someday!

  • Niamh - 19th May 2016 reply

    Thanks Paul, thorough as ever.
    Apart from Services->Data Sources in Console, and the Scheduler connection info in the BI Instance in enterprise manager, are there any hidden places you know of where one would need to change metadata schema connection details, if, for example, the database server changed?

  • rao - 20th May 2016 reply

    good

  • Lee - 30th May 2016 reply

    unable to use existing schemas , Prefex was used BIP and p/w was used for bip_biplatform schema.
    (12c BI config assist screen 4/9).
    error in connecting oracle database ‘host:port:service’ -invalid user name & p/w
    I tried with other schemas as well no luck any ideas?

  • Senshan Yang - 31st May 2016 reply

    Hi,
    After creating OBI instance (OBIEE 12c),I cannot login to http://localhost:9502/analytics, but these is no issue to login to http://localhost:9500/em with same credentials. Could somebody sheds some light on this?

    Thanks,
    Senshan

    harish kumar - 24th March 2017 reply

    Hello Senshan,

    I am also facing the similar issue. I installed on the 2 linux server and i am facing same issue.
    able to login in em and console. Can you please help and guide me how you resolved this issue?

    Thanks in advance

    Regards
    Harish

  • Ana - 6th June 2016 reply

    @Soheil Gharedaghi
    Did you managed to find a solution for this? I have the same issue.

  • JP - 28th June 2016 reply

    Great blog. Any blogs on how to setup SSL for the same OBI12c installation?

  • Vilas - 9th July 2016 reply

    Is it possible to use TWO_TASK variable to access legacy data? e.g.
    Server A – obiee 12c
    Server B – RDBMS 12 for RCU
    Server C – RDBMS 11.2.0.3.x for database having custom DW & fact/dimension tables and install 11.2.0.4 bins use TWO_TASK to access the legacy data from 11.2.0.3 database?
    Thanks

  • Vishal D - 20th July 2016 reply

    Hey Paul. Thanks for putting these installation steps in a simple and easy to understand way.
    It really help me understand the 12c installation steps.

    Thanks,
    VD

  • Santosh - 30th July 2016 reply

    Hello, Great post. I am looking for a generic help on invoking BI Admin tool. My installation of OBIEE 12c in is Linux machine and able to bring-up services and it is all fine.

    1) Where do I locate BI Administration Tool in Linux machine, like how we have in 11g as AdminTool.exe?

    Paul Cannon - 3rd August 2016 reply

    Hi Santosh,

    there is no linux equivalent of the Admin tool – you’ll need to download and install the OBIEE client tools to a windows pc and run it from there.

    Paul.

  • Dante - 3rd August 2016 reply

    I installed everything, and its working great, thank to the post…but my problem is, i can connect to bi server only from installed machine, but i cannot access from other pc, anyone knows why? where can i enable that ? thank you so much.

    Paul Cannon - 3rd August 2016 reply

    Hi Dante,

    that can’t be an OBIEE issue, it must be a networking/firewall issue on your server. Can you ping it from elsewhere? if you’ve a firewall you’ll need to open up the ports you installed OBIEE with – see the URLs it gave you at the end of the install, e.g. 9502, but you’ll need to open up the first 15, e.g. 9700 to 9714.

    Hope that helps.

    Paul.

  • Onkar - 29th August 2016 reply

    Hi Paul,

    With your steps ,I installed obiee 12c in windows machine but am not able to locate Admin tool in All programmes.In earlier version of OBIEE , Admin tool was getting listed in All programmes every time we install. Any idea where it has gone? Any idea how to list Admin tool in start–> All Programmes->

  • vamsi - 31st August 2016 reply

    hi guys can any one tell me how to start and stop single components like bi server, admin server, and author components in obiee 12c in obiee 11g we use this command to stop or start single components ./opmnctl stopproc ias-component=coreapplication_obis1 like is there is any commands in obiee12c please help me in this

  • Paul Cannon - 13th September 2016 reply

    Hi Vamsi, you can use the -i option on the start/stop commands. -i lets you specify individual components, e.g. stop -i obips1 will stop the presentation service and start -i obips1 will start it again.

    Hope that helps,

    Paul.

  • Guido - 7th October 2016 reply

    Status of Domain: C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\user_projects\domains\bi start.cmd
    NodeManager (DESKTOP-OLHK42M:9506): RUNNING

    Name Type Machine Status
    —- —- ——- ——
    AdminServer Server DESKTOP-OLHK42M RUNNING
    bi_server1 Server DESKTOP-OLHK42M RUNNING
    obips1 OBIPS DESKTOP-OLHK42M SHUTDOWN
    obijh1 OBIJH DESKTOP-OLHK42M RUNNING
    obiccs1 OBICCS DESKTOP-OLHK42M RUNNING
    obisch1 OBISCH DESKTOP-OLHK42M SHUTDOWN
    obis1 OBIS DESKTOP-OLHK42M SHUTDOWN

    **what else should I do?
    Thanks

  • imad - 7th November 2016 reply

    Hi, thanks for sharing this post it really helped me in installing OBIEE12c.
    But I have one question please, I am wondering if it’s possible to connect OBIEE to MySQL (because in DB details step, it only gives 3 type options: Oracle, Oracle RAC or MS SQL Server).
    Thanks in advance for your help.

  • Ritesh - 22nd November 2016 reply

    I restarted the server box, after that my OBIEE services are not comming up, only oracle Db is runnung.

    I tried to run the start.cmd but that too does not runs, and errors out.

    Please advice, how to troubleshoot this e

  • Casper Noome - 30th November 2016 reply

    Hi,
    I get the following error when configuring BI 12c on Solaris 11 Exalytics (With Oracle Pluggable DB):
    (All went fine up to here).

    Failed single shot step: Add default service instance with: oracle.bi.servicelcm.ServiceLCMException: [BIServiceLCM] [oracle.bi.servicelcm.disk.PodImpl::createServiceInstance] [OBI-LCM-99999] An unknown or unexpected error occurred: [BIServiceLCM] [oracle.bi.servicelcm.fmwk.ServiceInstanceFrameworkImpl::createServiceInstance] [OBI-LCM-99999] An unknown or unexpected error occurred: oracle.bi.bar.si.exception.ServiceInstanceLifeCycleException: Failed in running all the handlers during import service instance.

    Any advice would be apreciated!
    Regards,
    casper

    Jake - 25th January 2017 reply

    I’m having the same error… have you fixed this?

  • ayhan yasar - 7th December 2016 reply

    hi,
    I installed obiee12c on Linux. Now I want to migrate rdp and all catalogs on 12c on windows to new BI on Linux
    there are many docs about 11g to 12c migration but not 12c to 12c
    thanks in advice for your help

    Paul Cannon - 7th December 2016 reply

    Hi Ayhan,

    you can use BAR files to export the RPD/Catalog between 12c environments. I’ve blogged this before at http://www.redstk.com/welcome-to-obiee12c-using-bi-application-archive-bar-files/

    Paul.

  • claudio torres - 2nd February 2017 reply

    Hi, An error occurs when I run the config.sh command
    This is the error:
    [ERROR] [] [oracle.bi.install.config.actions] [tid: 52] [ecid: 0000LbzzkylFc5WFLzBT8A1O^rGv000004,0] Non-skipped failure during configuration action: Execution of [/oracle/obiee/oracle_common/common/bin/wlst.sh, /oracle/obiee/bi/modules/oracle.bi.configassistant/biee.py, /oracle/obiee, /oracle/obiee/user_projects/domains/bi2, administrator, Expanded, srv-cdaora01, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//192.168.1.91:1521/orcl, bi2, jdbc:oracle:thin:@//192.168.1.91:1521/orcl, ] failed with exit value 1[[
    oracle.bi.exec.ExecutionStatusException: Execution of [/oracle/obiee/oracle_common/common/bin/wlst.sh, /oracle/obiee/bi/modules/oracle.bi.configassistant/biee.py, /oracle/obiee, /oracle/obiee/user_projects/domains/bi2, administrator, Expanded, srv-cdaora01, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//192.168.1.91:1521/orcl, bi2, jdbc:oracle:thin:@//192.168.1.91:1521/orcl, ] failed with exit value 1
    at oracle.bi.exec.StdinProcess.runProcess(StdinProcess.java:99)
    at oracle.bi.exec.ExecScript.executeScript(ExecScript.java:191)
    at oracle.bi.exec.ExecScript.executeSynchronousScript(ExecScript.java:95)
    at oracle.bi.exec.ExecWLST.executeWLSTScript(ExecWLST.java:62)
    at oracle.bi.install.config.steps.WLSTStep.executeSingleShot(WLSTStep.java:55)
    at oracle.bi.install.config.basesteps.SingleShotActionStep.execute(SingleShotActionStep.java:31)
    at oracle.bi.install.config.basesteps.StepList.execute(StepList.java:85)
    at oracle.bi.install.config.actions.BIConfigAction.doExecute(BIConfigAction.java:127)
    at oracle.as.install.engine.modules.configuration.client.ConfigAction.execute(ConfigAction.java:405)
    at oracle.as.install.engine.modules.configuration.action.TaskPerformer.run(TaskPerformer.java:88)
    at oracle.as.install.engine.modules.configuration.action.TaskPerformer.startConfigAction(TaskPerformer.java:108)
    at oracle.as.install.engine.modules.configuration.action.ActionRequest.perform(ActionRequest.java:15)
    at oracle.as.install.engine.modules.configuration.action.RequestQueue.performSequentialExecution(RequestQueue.java:284)
    at oracle.as.install.engine.modules.configuration.action.RequestQueue.perform(RequestQueue.java:260)
    at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:185)
    at oracle.as.install.engine.modules.configuration.boot.ConfigurationExtension.kickstart(ConfigurationExtension.java:82)
    at oracle.as.install.engine.modules.configuration.ConfigurationModule.run(ConfigurationModule.java:87)
    at java.lang.Thread.run(Thread.java:745)

    How do I solve this?

    DB - 8th February 2017 reply

    Claudio,
    For the error you are getting, try editing the file wlst.sh
    Change the last part of the file…

    # JVM_ARGS=”${WLST_PROPERTIES} ${JVM_D64} ${UTILS_MEM_ARGS} ${CONFIG_JVM_ARGS}”
    # if [ -d “${JAVA_HOME}” ]; then
    # eval ‘”${JAVA_HOME}/bin/java”‘ ${JVM_ARGS} weblogic.WLST ‘”$@”‘
    # else
    # exit 1
    # fi

    JVM_ARGS=”-Djava.security.egd=file:///dev/../dev/urandom ${WLST_PROPERTIES} ${JVM_D64} ${UTILS_MEM_ARGS} ${CONFIG_JVM_ARGS}”
    if [ -d “${JAVA_HOME}” ]; then
    eval ‘”${JAVA_HOME}/bin/java”‘ ${JVM_ARGS} weblogic.WLST ‘”$@”‘
    else
    exit 1
    fi

    This worked for me. Original solution was posted here:
    https://community.oracle.com/thread/3936116

    gerhard herrmann - 7th March 2017 reply

    for me this fixed the issue, too. After adding the ARGS in wlst.sh

  • claudio torres - 20th February 2017 reply

    Hi, I changed the lines, but I still have problems. Do you have any other solution?

    [2017-02-20T09:27:47.697-03:00] [bi] [NOTIFICATION] [] [oracle.bi.install.config.basesteps] [tid: 53] [ecid: 0000LdRVKg2Fc5WFLzBT8A1OehxL000004,0] Failed single shot step: BIEE with: Execution of [/oracle/obiee/oracle_common/common/bin/wlst.sh, /oracle/obiee/bi/modules/oracle.bi.configassistant/biee.py, /oracle/obiee, /oracle/obiee/user_projects/domains/bi2, administrator, Expanded, srv-cdaora01, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//192.168.1.91:1521/orcl, bi2, jdbc:oracle:thin:@//192.168.1.91:1521/orcl, ] failed with exit value 1
    [2017-02-20T09:27:47.704-03:00] [bi] [ERROR] [] [oracle.bi.install.config.actions] [tid: 53] [ecid: 0000LdRVKg2Fc5WFLzBT8A1OehxL000004,0] Non-skipped failure during configuration action: Execution of [/oracle/obiee/oracle_common/common/bin/wlst.sh, /oracle/obiee/bi/modules/oracle.bi.configassistant/biee.py, /oracle/obiee, /oracle/obiee/user_projects/domains/bi2, administrator, Expanded, srv-cdaora01, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//192.168.1.91:1521/orcl, bi2, jdbc:oracle:thin:@//192.168.1.91:1521/orcl, ] failed with exit value 1[[
    oracle.bi.exec.ExecutionStatusException: Execution of [/oracle/obiee/oracle_common/common/bin/wlst.sh, /oracle/obiee/bi/modules/oracle.bi.configassistant/biee.py, /oracle/obiee, /oracle/obiee/user_projects/domains/bi2, administrator, Expanded, srv-cdaora01, 9502, 9503, ORACLE, oracle.jdbc.OracleDriver, jdbc:oracle:thin:@//192.168.1.91:1521/orcl, bi2, jdbc:oracle:thin:@//192.168.1.91:1521/orcl, ] failed with exit value 1
    at oracle.bi.exec.StdinProcess.runProcess(StdinProcess.java:99)
    at oracle.bi.exec.ExecScript.executeScript(ExecScript.java:191)
    at oracle.bi.exec.ExecScript.executeSynchronousScript(ExecScript.java:95)
    at oracle.bi.exec.ExecWLST.executeWLSTScript(ExecWLST.java:62)
    at oracle.bi.install.config.steps.WLSTStep.executeSingleShot(WLSTStep.java:55)
    at oracle.bi.install.config.basesteps.SingleShotActionStep.execute(SingleShotActionStep.java:31)
    at oracle.bi.install.config.basesteps.StepList.execute(StepList.java:85)
    at oracle.bi.install.config.actions.BIConfigAction.doExecute(BIConfigAction.java:127)
    at oracle.as.install.engine.modules.configuration.client.ConfigAction.execute(ConfigAction.java:405)
    at oracle.as.install.engine.modules.configuration.action.TaskPerformer.run(TaskPerformer.java:88)
    at oracle.as.install.engine.modules.configuration.action.TaskPerformer.startConfigAction(TaskPerformer.java:108)
    at oracle.as.install.engine.modules.configuration.action.ActionRequest.perform(ActionRequest.java:15)
    at oracle.as.install.engine.modules.configuration.action.RequestQueue.performSequentialExecution(RequestQueue.java:284)
    at oracle.as.install.engine.modules.configuration.action.RequestQueue.perform(RequestQueue.java:260)
    at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:185)
    at oracle.as.install.engine.modules.configuration.boot.ConfigurationExtension.kickstart(ConfigurationExtension.java:82)
    at oracle.as.install.engine.modules.configuration.ConfigurationModule.run(ConfigurationModule.java:87)
    at java.lang.Thread.run(Thread.java:745)

    ]]

  • Tim - 24th February 2017 reply

    Hello,
    I faced exactly the same error while configuring BI 12c (12.2.1.2.0).
    I solved this issue by adapting the following line in the file $JAVA_HOME/jre/lib/security/java.security :
    Before:
    #securerandom.source=file:/dev/random
    After:
    securerandom.source=file:/dev/./urandom
    Then execute config.sh

    The explanation about the procedure is here: https://blogs.oracle.com/LuzMestre/entry/why_does_my_weblogic_server
    Don’t ask me why entropy is important in this case but it works …

    Hope it helps.

  • Charles - 2nd March 2017 reply

    Very helpful blog post! I have been following along and been pretty successful in my install thus far thanks to this.

    One question

    For the two different config.sh – what exactly are the differences?

    Is there any advantage to using one or the other?

    In what scenario would you use either one?

    Paul Cannon - 3rd March 2017 reply

    Hi Charles,

    One config.sh is for the basic install as above, the other is for when you’re installing a clustered environment – it allows you to specify all the various servers in the cluster.

    Paul.

  • Rupali - 3rd March 2017 reply

    Hi,
    After installation everything was working fine but now services are up and running but after login screen it is showing blank page.

  • vimal - 10th March 2017 reply

    Hi there,
    I’m facing issue while trying to bring up obiee components obis, obips,obijs etc..out of all 5 components only one javahost is running rest other 4 are giving same error of unable to open shared library( of course library name is different for diffferent component but rest everything is same)
    below is the errorfor component obis:
    ——————————————–

    /u01/app/obiee12c/bi/bifoundation/server/bin/nqsserver: error while loading shared libraries: libbi_metadata_rt.so: cannot open shared object file: No such file or directory

    EM and console are working fine. i tried to set LD_LIBRARY_PATH, soft link, reboot server but nothing helps.
    if soeone knows how to fix it, please suggest.

    Thanks,
    Vimal

    vimal - 10th March 2017 reply

    missing file name for other components are:
    obiccs1 = libnqsclusterrpcserver64.so
    obips1.out = libsawhttpserver643r.so
    obis1.out = libnqportable64.so
    obisch1.out = libnqsscheduler64.so
    Thanks,
    Vimal

  • vimal - 10th March 2017 reply

    all these library files are present at /u01/app/obiee12c/bi/bifoundation/server/bin/ location with proper rights and this path is added in LD_LIBRARY_PATH as well.

    louis - 23rd March 2017 reply

    did you found a solution; i am hitting the same problem

  • claudio torres - 20th March 2017 reply

    Hi all, this error happens when we set the schema password above 8 characters. So use admin123 as your password.
    Thank you!

    louis - 23rd March 2017 reply

    I have the same issue, after changing the schema passwords could you start OBI components successfully?

    Daniel Hooper - 23rd March 2017 reply

    I’m encountering the exact same issue with libraries. Has anyone resolved it yet or opened an SR?

  • Charles - 21st March 2017 reply

    Great posts so far – many thanks firstly.

    I do have a quick question

    I completed my OBIEE 12c installation and can not connect to any URL’s – which I understand is likely because I need to open up the ports on the server.

    After installing I noticed that the main 3 ports I need seem to be

    9500, 9502 and 9514 (this is with a default port range installation)

    But there are also a large number of other ports as well from what I can tell

    Presentation Services 9507
    BI Scheduler/Monitor/Script 9511/9512/9513
    BI Cluster Controller/Monitor 9508/9509
    BI Java Hosts 9510
    Essbase Agent 9799

    Do the ports for all of these also need to be opened? Or just the above 3 ports 9500, 9502 and 9514 are sufficient?

    Thanks so much

    Paul Cannon - 24th March 2017 reply

    Hi Charles, those three ports are the main ones for standard OBIEE access. Some are only used internally (for parts of OBIEE to talk to other parts) and wouldn’t go though a firewall and others will be required only if you choose to use them, for example if you wish to use Essbase. I’d just open those three and worry about others if you ever hit a firewall issue.

    Paul.

  • Deddy - 23rd March 2017 reply

    Hi ,

    I am on installing OBIEE12c in my environment. And everything is running well.
    Just confused , is this a must, if we follow the steps and create all the schemas?

    What for the schemas exactly do? what’s the purpose?
    and what if , all the software has been installed , and i delete the schema, what’s will gonna happen?
    Should we create all 8 schemas for this oracle 12c ?

    Please help me to understand this schemas problem.

    Anyway, Thank you , your steps from part 1- 4 help me to succesfully install the software smoothly.

    Best Regards,

    Deddy Sinaga

    Paul Cannon - 24th March 2017 reply

    Hi Deddy,

    The schemas are used to store information required by OBIEE and weblogic. You may not need all of them (depending on what areas of functionality you required in weblogic), but the biplatform and mds schemas are definitely required. If you delete them OBIEE will not start properly.

    hope that helps.

    Paul.

    Deddy - 28th March 2017 reply

    Hi paul ,

    Thank you for your response.

    Yes, i understand that the BIPLATFROM and MDS schemas is the main schemas of OBIEE. But i already install all the schemas.

    I already checked from weblogic console – services – data sources , All the schemas has been registered except the IAU one.

    Soon or later, i need to change the password for every schema , for other 7 schemas, i can change the password, but for IAU , i can’t ,

    Is there any relationship between schema , meaning, when i changed one schema , it will affect the IAU schemas?

    Please advise.

    thank you for your kind attention

    Best Regards,

    Deddy Sinaga

    Paul Cannon - 7th April 2017 reply

    Hi Deddy,

    I can’t see why you can’t change the password on the IAU schemas – an simple ‘alter user identified by’ command works fine for me. Are you getting a message saying you can’t change it?

    Paul.

  • Mayank sinhal - 19th April 2017 reply

    Hi Paul,
    your blog have been helpful in understanding OBIEE installation. Please let me know if you could also please suggest any steps for OBIEE 11g migration to OBIEE 12c post OBIEE 12c installation.

    Paul Cannon - 19th April 2017 reply

    Hi Mayank,

    we have another blog which covers the basics of migrating from 11g to 12c: http://www.redstk.com/migrating-obiee11g-to-12c/

    Rgds, Paul.

Join the conversation