OBIEE – Step by Step Installation

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 …

About the Author Masroof Ahmad

Leave a Comment:

149 comments
Kailash says August 27, 2008

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

Reply
Paul says September 10, 2008

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.

Reply
Atul says September 11, 2008

Paul,
What URL and Password you are using ?

Reply
Mohamed Youssef says September 11, 2008

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

Reply
Atul says September 11, 2008

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

Reply
Mohamed Youssef says September 11, 2008

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

Reply
Atul says September 11, 2008

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 ….)

Reply
Kiran says September 11, 2008

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

Reply
Atul says September 12, 2008

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

Reply
Kiran says September 12, 2008

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

Reply
Kiran says September 12, 2008

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

Reply
Atul says September 12, 2008

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

Reply
Kiran says September 14, 2008

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

Reply
Kiran says September 14, 2008

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

Reply
Atul says September 14, 2008

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.

Reply
Kiran says September 17, 2008

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

Reply
Kiran says September 17, 2008

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

Reply
Atul says September 17, 2008

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/

Reply
jsethi3@gmail.com says September 19, 2008

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)

Reply
Atul says September 19, 2008

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

Reply
Kiran says September 22, 2008

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

Reply
Kiran says September 22, 2008

My DB Version is 10.1.0.5.0

Reply
Atul says September 22, 2008

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

Reply
Kiran says September 22, 2008

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

Reply
Kiran says September 22, 2008

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

Reply
Atul says September 22, 2008

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

Reply
Kiran says September 22, 2008

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

Reply
Kiran says September 22, 2008

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?

Reply
Kiran says September 24, 2008

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

Reply
jsethi3 says September 24, 2008

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

Reply
jsethi3 says September 24, 2008

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?

Reply
Suri says September 24, 2008

Atul,

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

Reply
Atul says September 25, 2008

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

Reply
jsethi3 says September 25, 2008

Hi,

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

Regards,

Jagdeep

Reply
Atul says September 25, 2008

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

Reply
jsethi3 says September 25, 2008

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

Thanks,

Reply
jsethi3 says October 3, 2008

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?

Reply
Prakash says October 28, 2008

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

Reply
Atul Kumar says November 4, 2008

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

Try using exact case A capital.

Reply
kvasavikumarreddy@gmail.com says November 11, 2008

Hi Atul,

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

Reply
vasavi says November 11, 2008

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

Reply
Atul Kumar says November 11, 2008

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.

Reply
vasavi says November 11, 2008

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

Reply
girish says January 14, 2009

Hi Atul,

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

Thanks
Girish.

Reply
    angry birds 2 says May 7, 2016

    angry birds star wars 2 kostenlos downloaden pc 2014

    Reply
Atul Kumar says January 14, 2009

Girish,
DB is not required for OBIEE installation.

Reply
Jagdeep says January 14, 2009

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

Reply
» Oracle BI Publisher Admin Console (xmlpserver) Login Issue : Administrator/Administrator Online Apps DBA: One Stop Shop for Apps DBA’s says January 15, 2009

[…] 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 […]

Reply
Harvinder says January 20, 2009

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

Reply
Atul Kumar says January 21, 2009

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

Reply
Vishal says January 24, 2009

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)

Reply
vasavi says January 28, 2009

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

Reply
Atul says January 28, 2009

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)

Reply
vasavi says January 28, 2009

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

Reply
sachin says March 4, 2009

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

Reply
vasavi says March 5, 2009

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”.

Reply
VilasM says March 7, 2009

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

Reply
sonali says March 27, 2009

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

Reply
max60074 says March 27, 2009

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

Reply
Ravi Kumar says March 30, 2009

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.

Reply
srikanth says April 3, 2009

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

Reply
jsethi3 says April 27, 2009

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?

Reply
Suren says May 7, 2009

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

Reply
Mubarak Ali says May 12, 2009

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

Reply
gautam_sen_in@yahoo.com says August 17, 2009

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 ?

Reply
t.rojavenkat says November 27, 2009

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

Reply
Naveen says November 30, 2009

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.

Reply
t.rojavenkat says December 1, 2009

Hi Atul,

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

Regards,
Roja

Reply
Anil says December 9, 2009

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

Reply
Atul Kumar says December 10, 2009

@ 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

Reply
psus2020 says December 10, 2009

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

Reply
Atul Kumar says December 11, 2009

@ PS,
Are you doing basic install or advanced ?

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

Reply
PS says December 14, 2009

Thanks, I am doing advanced install.

Reply
keerthi says December 16, 2009

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.

Reply
Swetat says January 9, 2010

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

Reply
Pavan says March 1, 2010

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.

Reply
Dris says March 2, 2010

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

Reply
Atul Kumar says March 3, 2010

@ 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/

Reply
Dris says March 3, 2010

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

Reply
Dris says March 3, 2010

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

Reply
Lenin says March 12, 2010

Hi Folks,

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

Reply
KiranK says April 21, 2010

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

Reply
jsethi3 says April 22, 2010

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

Reply
jsethi3 says April 22, 2010

No need to unzip in the root anymore.

Thanks,

Jagdeep

Reply
priya says April 23, 2010

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.

Reply
Robert says May 27, 2010

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?

Reply
lucas rehem says July 2, 2010

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

Reply
Ash says July 10, 2010

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

Reply
minakshi says July 26, 2010

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

Reply
Akshara says January 7, 2011

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

Reply
Atul Kumar says January 7, 2011

@ 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)

Reply
Akshara says January 7, 2011

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

Reply
Atul Kumar says January 7, 2011

@ 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

Reply
Darsh says January 19, 2011

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

Reply
monuS says March 20, 2011

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

Reply
Vijay says May 3, 2011

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.

Reply
Atul Kumar says May 3, 2011

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

Reply
kalyana says June 10, 2011

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

Reply
Akshara says June 17, 2011

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

Reply
Atul Kumar says June 20, 2011

@ 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

Reply
naresh says August 12, 2011

Hi Atul,

These posts are very helpful,thanks for sharing.

Naresh

Reply
Akshara says August 29, 2011

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

Reply
Kits says October 20, 2011

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!!

Reply
Pal says November 14, 2011

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.

Reply
Sajeesh says November 16, 2011

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

Reply
Rahul says December 5, 2011

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

Reply
Atul Kumar says December 5, 2011

@ 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.

Reply
Rahul says December 6, 2011

@ Atul,

thanks for your clarification. thanks a ton

Reply
Mayuri M says December 12, 2011

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

Reply
Atul Kumar says December 12, 2011

@ 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 ?

Reply
Mayuri M says December 12, 2011

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

Reply
Mayuri M says December 12, 2011

Reply
Mayuri M says December 12, 2011

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

Reply
Atul Kumar says December 13, 2011

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”

Reply
Venkat says December 27, 2011

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.

Reply
Atul Kumar says December 27, 2011

@ 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

Reply
sharma_rekha2 says May 10, 2012

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

Reply
san says May 14, 2012

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

Reply
shreyas says May 22, 2012

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.

Reply
joe says May 22, 2012

Hi,

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

Obiee not startup

help Please

Reply
Sairam says June 20, 2012

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.

Reply
tapfuma says July 17, 2012

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

Reply
new2obiee says August 15, 2012

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

Reply
    Atul Kumar says August 15, 2012

    @ 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;

    Reply
new2obiee says August 15, 2012

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

Reply
new2obiee says August 16, 2012

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.

Reply
new2obiee says August 17, 2012

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.

Reply
Atul Kumar says August 17, 2012

@ new2obiee,
Reset password of SH as

SQL> alter user SH identified by ;

Try using this new password.

Reply
new2obiee says August 17, 2012

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.

Reply
Atul Kumar says August 17, 2012

Login as sysdba

sqlplus “/as sysdba”

SQL> alter user SH identified by welocme1 ;

Try using this new password as welcome1

Reply
new2obiee says August 17, 2012

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.

Reply
new2obiee says August 17, 2012

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.

Reply
New2obiee says August 18, 2012

Hi Atul,

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

Reply
New2obiee says August 20, 2012

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

Reply
New2obiee says August 21, 2012

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.

Reply
New2obiee says August 21, 2012

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.

Reply
New2obiee says August 21, 2012

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.

Reply
New2obiee says August 25, 2012

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.

Reply
OBIEE2012 says September 1, 2012

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

Reply
New2obiee says September 11, 2012

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.

Reply
Ram says September 26, 2012

@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.

Reply
Neha says December 12, 2012

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 ?

Reply
sana says February 15, 2013

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

Reply
    Atul Kumar says February 15, 2013

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

    Reply
sana says February 17, 2013

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

Reply
viveksathe says March 22, 2013

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

Reply
Atul Kumar says March 22, 2013

@ 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

Reply
Add Your Reply