After successful intallation of OBIEE 11g on linux box, I am thinking about Admin tool.exe on my laptop, but required Windows box to run that. As a work around, did a fresh installation of OBIEE 11g software again on my local Windows XP machine. After than I have copied the admin tool.exe along 'server' folder from C:\[OBIEE_PATH]\bifoundation
As a first step, I have created same directory structure OBIEE 11g installation path of local machine to my laptop and then copied all the files.
Next step, i have created a cmd file for register all the DLL files from C:\[OBIEE_PATH]\bifoundation\bin directory with regsvr32 /s option. This will help to register all these DLLs in single a command. (If anybody required this information, don't hesitate to leave your request with valid email id)
After that from my local machine, exported two registry entries.
1. [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]
2. [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Oracle BI Server 11g_OH741068320]
I have made some changes to the first reg exported file, because its required only Oracle BI Server entry info. So that removed unnecessary lines from first reg exported file. And its look like
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]
"Oracle BI Server 11g_OH741068320"="Installed"
After that added these entries to my laptop using
regedit /s [exported file name]
Finally created one ODBC Connection to laptop pointing to the Linux box DB. Now I can able to open my RPD file in offline as well as online
Cheers!!!
Tuesday, 30 November 2010
TNS-12557: TNS:protocol adapter not loadable
Yesterday, I have installed OBIEE11g to my laptop. Installation was successful and working fine to me. But after that I have encountered issues connecting to the database using my existing connection string. I have added these db connection string to the OBIEE11g home tnsnames.ora file but no luck.
I have did some work around, firstly checked my TNSPING, but the result showing as below
PATH=C:\Program Files\PC Connectivity Solution\;C:\WINDOWS\system32;C:\Middlewar
e\Oracle_BI2\bin;C:\Middleware\Oracle_BI2\opmn\bin;C:\Middleware\Oracle_BI2\opmn
\lib;C:\Middleware\Oracle_BI2\perl\bin
After experimentation revealed that my exiting TNS_ADMIN and bin directory has been missing from PATH environment, so I have decided to add the existing directory and now its looks like. (close the command window and open another one)
PATH=C:\OraHome_1\bin;C:\OraHome_1\network\ADMIN;C:\Program Files\PC Connectivit
y Solution\;C:\WINDOWS\system32;C:\Middleware\Oracle_BI2\bin;C:\Middleware\Oracle_BI2\opmn\bin;C:\Middleware\Oracle_BI2\opmn\lib;C:\Middleware\Oracle_BI2\perl\bin
Simple but spend some time to identify the issue.
Cheers!!!
I have did some work around, firstly checked my TNSPING, but the result showing as below
So I have checked my PATH setting and discovered the original PATH setting missing my old Oracle Home details. This below is my present PATH environment setting. |
PATH=C:\Program Files\PC Connectivity Solution\;C:\WINDOWS\system32;C:\Middlewar
e\Oracle_BI2\bin;C:\Middleware\Oracle_BI2\opmn\bin;C:\Middleware\Oracle_BI2\opmn
\lib;C:\Middleware\Oracle_BI2\perl\bin
After experimentation revealed that my exiting TNS_ADMIN and bin directory has been missing from PATH environment, so I have decided to add the existing directory and now its looks like. (close the command window and open another one)
PATH=C:\OraHome_1\bin;C:\OraHome_1\network\ADMIN;C:\Program Files\PC Connectivit
y Solution\;C:\WINDOWS\system32;C:\Middleware\Oracle_BI2\bin;C:\Middleware\Oracle_BI2\opmn\bin;C:\Middleware\Oracle_BI2\opmn\lib;C:\Middleware\Oracle_BI2\perl\bin
As a result of this path setting, again open one command window (startup->cmd) and tried with same command. Now its working fine |
Cheers!!!
Labels:
Errors and Solutions
Thursday, 25 November 2010
Install & Configuration of OBIEE 11g
I would like to share my experience of installation of OBIEE 11g on linux with you all.
There are four steps
There are four steps
- Oracle Enterprise Linux 5.5 Installation
- Oracle Database 11g R2 Installation
- Repository Creation Utility
- and Oracle Business Intelligence 11g Installation
Once you have restarted your linux box, do the following steps for startup
How to startup OBIEE 11g on linux
Labels:
OBIEE-11g
Oracle 11g R2 Patchset 1 (11.2.0.2) installation on OEL 5.5
Please makes sure that the following or later versions of packages are successfully installed along with operating system. These are pre-requisite for oracle 11g installation.
Cheers!!!
binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
elfutils-libelf-devel-static-0.125
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-24
glibc-common-2.5
glibc-devel-2.5
glibc-headers-2.5
kernel-headers-2.6.18
ksh-20060214
libaio-0.3.106
libaio-devel-0.3.106
libgcc-4.1.2
libgomp-4.1.2
libstdc++-4.1.2
libstdc++-devel-4.1.2
make-3.81
numactl-devel-0.9.8.i386
sysstat-7.0.2
To use ODBC, you must also install the following additional 32-bit ODBC RPMs, depending on your operating system:
unixODBC-2.2.11 (32-bit) or later
unixODBC-devel-2.2.11 (32-bit) or later
unixODBC-devel-2.2.11 (32-bit) or later
Modify of add these entries in /etc/sysctl.conf using vi editor
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
If necessary, update the resource limits in the /etc/security/limits.conf configuration file for the installation owner. For example, add the following lines to the /etc/security/limits.conf file:
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
Modify or add the following entry in /etc/pam.d/login using vi editor
session required pam_limits.so
Next create the group and user for oracle database
/usr/sbin/groupadd -g 500 oinstall
/usr/sbin/groupadd -g 501 dba
/usr/sbin/groupadd -g 502 oper
/usr/sbin/useradd -u 500 -m -g oinstall -G dba,oper oracle
id oracle
passwd oracle
Create the installation directory for oracle installation
mkdir -p /u01/oracle
chown -R oracle:dba /u01/oracle
chmod -R 775 /u01/oracle
Create staging directory for oracle installation
mkdir -p /u01/stage
chown -R oracle:dba /u01/stage
After unzipping the installation files change to the directory containing uninstaller. You must be the oracle user (not root) and you must verify your shell is set correctly. As the oracle user and start the Oracle installer.
$ cd /u01/stage/database
$./runInstaller.
You can ignore this email setting |
You can skip software updates |
From installation option, select create and configure a database. |
From the server class, choose server class |
For a standalone database choose the first option. |
Choose Install type as Advance Install. |
Database Edition should be Enterprise Edition. |
As we created earlier, choose /u01/oracle as Base and Software location will be similar to the below picture |
This database is for OBIEE 11g, so please choose Data Warehousing |
Here you can edit your database name. |
If this database is for demo purpose, so I have to keep with minimum configuration |
You can choose File System. But if you are planning for ASM refer configuration details from installation document. |
Better to choose the second option this time. |
Accept the defaults |
This is a typical result. Based on your OS configuration, please read the oracle Installation documents for more info. |
The following information is good for future reference. |
This will take some time to complete. Be ready for that… |
Now the database creation is going on. |
Finally database configuration success. If you want to change the password, you can use Password Management button. |
From this screen, will prompt to do two things. As a root, you have executed these commands. |
Now database 11gR2 (11.2.0.2) is ready for use. |
Cheers!!!
Repository Creation Utility - OBIEE 11g
Download V22398-01.zip from edelivery.oracle.com Oracle Fusion Middleware Repository Creation Utility 11g (11.1.1.3.3) for Linux x86. To extract the contents of the zip file to the staging directory
Here I have created one user called applmgr for OBIEE installation
When you have unzipped V22398-01.zip, this will produce a directory called rcuHome. Change the directory to rcuHome/bin and start the Repository creation utility using
$ ./rcu
Click on Next in the first RCU screen. Choose the create option and click on Next |
This will do a pre-requisite check, click on OK to proceed. |
Choose the Oracle Business Intelligence option, this will automatically enable the Metadata services, Click on Next |
Click OK in the next screen in the next screen Enter password and Click on Next |
Leave the default values as is, click on Next |
Click OK to create the suggested tablespaces |
Click on OK once the tablespaces have been successfully created. |
Once completed click on Close to finish the RCU process. |
- Oracle Enterprise Linux 5.5 Installation
- Oracle Database 11g R2 Installation
- Oracle Business Intelligence 11g Installation
Cheers!!!
Labels:
OBIEE-11g
OBIEE 11g installation on OEL 5.5
Download the following from edelivery.oracle.com
Oracle Business Intelligence 11g (11.1.1.3.0) for Linux x86 (32-bit) (Disc 1 of 2) V22330-01 Part 1 of 2
Oracle Business Intelligence 11g (11.1.1.3.0) for Linux x86 (32-bit) (Disc 1 of 2) V22330-01 Part 2 of 2
Oracle Business Intelligence 11g (11.1.1.3.0) for Linux x86 (32-bit) (Disc 2 of 2) V22331-01 Part 1 of 2
Oracle Business Intelligence 11g (11.1.1.3.0) for Linux x86 (32-bit) (Disc 2 of 2) V22331-01 Part 2 of 2
Extract these four zip files, will create a folder called bishiphome and under that four Disks. To lunch the OBIEE 11g installation, goto bishiphome/Disk1
$./runInstaller
Click on Next in the first screen |
Choose Enterprise Install option and then click on Next |
Ensure that all the pre-requisite checks are passed 100%. Click on next |
Choose the Create New BI System option. Enter the password. Leave the username and the domain with the default values. Then click on Next |
Enter the /u01/oracle/MiddlewareHome as the Middleware Home location. This will automatically fill the remaining fields. Leave those values with the defaults and click on Next |
Leave the next screen with default options (all components enabled). Click on Next |
On the database details screen, enter the details of your database and BIPLATFORM username and password, click on Next to proceed. |
Choose the default Auto Port option and click on Next |
Disable the I wish to receive Security Updates option and click Next |
Click Yes in the confirmation pop-up window |
Click on Install |
The first step in the install process will copy the install files into Middleware Home. This will take sometime to complete. |
After copying, the configuration process will start. Ensure that all the components are configured correctly. |
After the configuration is complete click on Next |
This screen will get all the details of the services started. |
Now using web browser, naviagte to http://visr12.apps.local:7001/console. When prompted, enter weblogic as the username and enter the password when the you given at the time of installation. |
After logging in, click on the bifoundation_domain link. |
Navigate to the Business Intelligence folder and click on coreapplication |
Now access analytics using http://visr12.apps.local:9704/analytics |
For accessing Bi Publisher Enterprise, http://visr12.apps.local:9704/xmlpserver |
- Oracle Enterprise Linux 5.5 Installation
- Oracle Database 11g R2 Installation
- Repository Creation Utility
Now the installation of OBIEE 11g is completed successfully. I will write the steps for startup and shutdown these services in the next post.
Cheers!!!
Labels:
OBIEE-11g
Subscribe to:
Posts (Atom)