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 …
Related Posts for Business Intelligence
- Oracle Business Intelligence Enterprise Edition Overview
- BIEE Installation on Linux (Business Intelligence Enterprise Edition)
- Oracle BI Publisher Cluster / HA
- Clustering Oracle Business Intelligence , BI Server, Presentation Services, Plug-In, Scheduler & Javahost
- OBIEE – Step by Step Installation
- User Management in OBIEE using BI Administration Tool
- Integrate Oracle BI Server with LDAP Server (OID – Oracle Internet Directory)
- Oracle BI Publisher Admin Console (xmlpserver) Login Issue : Administrator/Administrator
- How to install OBIEE on windows 7 (OBIEE Training)
- OBIEE 11g (11.1.1.3.0) Download & Installation
- OBIEE 11g Installation : High Level Steps
- Unable to login to OBIEE /Analytics after OID integration : %user% was authenticated but could not be located within the identity store
- Configure OBIEE 11g Client to connect to 11g RPD in online mode
- Integrate OBIEE 11g with OAM 11g for Single Sign-On in 13 steps
Oracle WebLogic Administrator [USD 399]- 03rd Dec, 2011
Good hands-on exercises (installation, patching, cloning), very experienced trainer worth every penny 
148 users commented in " OBIEE – Step by Step Installation "
Follow-up comment rss or Leave a TrackbackAtul,
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
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.
Paul,
What URL and Password you are using ?
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
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
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
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 ….)
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
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
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
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
Kiran,
leave oc4j name to default value “home” and try
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
sorry pls read the above cmd as ./run-sa.sh start
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.
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
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
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/
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)
How much is memory on machine ? Is this on linux or Solaris ?
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
My DB Version is 10.1.0.5.0
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
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
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
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
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
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?
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
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
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?
Atul,
Where can download ORACLE BUSINESS INTELLIGENCE ENTERPRISE EDITION 10.1.3.2 for Solaris x86 32-bit ?
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
Hi,
Any response to my question will be great. I tried JAVA_OPTS, but that did not help.
Regards,
Jagdeep
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
Yes. I did run UnixChk.sh and it is SUCCESSFUL!! I tried to install software on windows, and it went fine.
Thanks,
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?
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
Prakash,
Are you getting wrong password or any other message.
Try using exact case A capital.
Hi Atul,
Can u tell me hoe to integrate the SSO integration on OAM using OBIEE.
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
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.
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
Hi Atul,
Do we need to install any standalone database before installing obiee and if yes which is the minimum required version.
Thanks
Girish.
Girish,
DB is not required for OBIEE installation.
The repository entries and other information are stored in the xml files on the operating system.
[...] 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 [...]
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
Is BI URL not working (if not what URL you are using) ?
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)
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
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)
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
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
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”.
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
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
where can i find step by step user guide for obiee to create reports
Try
http://download.oracle.com/docs/cd/E12096_01/homepage.htm
and
http://download.oracle.com/docs/cd/E10415_01/doc/nav/portal_booklist.htm
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.
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
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?
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
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
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 ?
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
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.
Hi Atul,
i dont see your reply.please reply to that issue.
Regards,
Roja
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
@ 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
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
@ PS,
Are you doing basic install or advanced ?
For advanced install you need 10g AS Release 3 (J2ee & opmn install)
Thanks, I am doing advanced install.
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.
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
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.
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
@ 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/
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
10/03/03 16:02:11 Oracle Containers for J2EE 10g (10.1.3.1.0) initialized
racle.jsp.provider.JspCompileException: Erreurs de comp
2010-03-03 16:02:35.298 NOTIFICATION J2EE JSP-0008 Impossible de rÚpartir la pa
ge JSP : Exception
ilation :C:\OracleBI\oc4j_bi\j2ee\home\application-deployments\analytics\analyti
cs\persistence\_pages\\_default.java
2010-03-03 16:03:06.102 NOTIFICATION J2EE JSP-0008 Impossible de rÚpartir la pa
racle.jsp.provider.JspCompileException: Erreurs de comp
ge JSP : Exception
ilation :C:\OracleBI\oc4j_bi\j2ee\home\application-deployments\xmlpserver\xmlpse
rver\persistence\_pages\\_login.java
Hi Folks,
I have windows 7 on may machine,how can i install obiee on windows 7.
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
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
No need to unzip in the root anymore.
Thanks,
Jagdeep
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.
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?
You make a poor brazilian happy in this bad day! TY
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
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
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
@ 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)
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
@ 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
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
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
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.
@ Vijay,
Yes this is possible. Which OBIEE version you are using (10g or 11g) ?
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
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
@ 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
Hi Atul,
These posts are very helpful,thanks for sharing.
Naresh
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
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!!
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.
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
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
@ 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.
@ Atul,
thanks for your clarification. thanks a ton
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
@ 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 ?
Sorry to say but how do i check the memory on Server??
I have following values in the opmn.xml file for OC4J module :
=”-Xrs -server -XX:MaxPermSize=256M -ms1536M -mx1536M -XX:NewSize=256M -XX:MaxNewSize=256M
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”
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.
@ 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
Hi Atul,
Good stuff on OBIEE.Its made me help lots
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
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.
Hi,
run-sa.sh = 0 byte
on obiee10.2.5 Platfrom Unix
Obiee not startup
help Please
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.
Do you know have any information on integration of OBIEE 10.1.3.4.1 and PeopleSoft EMP ver 9 ? (pref Fiancial Module)
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
@ 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;
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
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.
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.
@ new2obiee,
Reset password of SH as
SQL> alter user SH identified by ;
Try using this new password.
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.
Login as sysdba
sqlplus “/as sysdba”
SQL> alter user SH identified by welocme1 ;
Try using this new password as welcome1
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.
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.
Hi Atul,
Please can you answer my previous question.
am waiting for your reply with eager.
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
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.
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.
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.
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.
@ New2obiee,
Apologies for not coming back to you, I am afraid I don’t have an answer your question and would suggest raising an Service Request or check at https://forums.oracle.com/forums/category.jspa?categoryID=16
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
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.
@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.
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 ?
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
During install at time of startup , Node manager startup should create nodemanager.properties. Try starting nodemanager manually and see if it creates nodemanager.properties
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
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
@ Viveksathe ,
Check this for OBIEE 11g (11.1.1.6)
http://onlineappsdba.com/index.php/2011/05/01/obiee-11g-installation-high-level-steps/
RCU is used to create schema and for 11.1.1.6 RCU there are some pre-reqs . More on RCU at http://onlineappsdba.com/index.php/2009/07/03/oracle-fusion-middleware-11g-repository-creation-utility-rcu/
What is actual error ?
If error is “database version 11.1.0.7.0 not being a supported version.”
Then install 11gR2 database i.e. 11.2.0.1 for OBIEE repository
Leave A Reply