Analytics Software

I am stuck with the Informatica Server installation as part of the OBI Apps 7.9.5 on the Sun Server (Sun Solaris 10)
At the time of doing the PowerCenter Repository configuration (creating new PowerCenter Repository) the installation aborts with test connection failed.

Following enteries were made:

Repository Type Selected :New

Repository Name :Oracle_BI_DW_Base

Repository DB Type :Oracle

Code Page :Latin1

User ID :infadb

Connect String :obia2



The same database credentials was used for the Domain configuring at it was sucessful but fails during Repository configuration.

I am appending the OBI Apps Informatica install log file.

********************************************************************************************************
This log was generated during installation.
********************************************************************************************************


Environment variables used by installation program
=============================================

LANG = C
PATH = /usr/bin:/usr/xpg4/bin:/beledb2/oracle2/sadmin/oracle/product/10.2.0/db_1/bin:/opt/bin:/beledb2/oracle2/sadmin/oracle/product/10.2.0/db_1/bin:/opt/bin:/beledb2/oracle2/sadmin/oracle/product/10.2.0/db_1/bin:/beledb2/oracle2/sadmin/oracle/product/10.2.0/db_1/bin:/usr/bin:/usr/dt/bin:/usr/openwin/bin:/usr/ucb:/bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin
LD_LIBRARY_PATH = /beledb2/oracle2/sadmin/oracle/product/10.2.0/db_1/lib32:/beledb2/oracle2/sadmin/oracle/product/10.2.0/db_1/lib32:
ORACLE_HOME = /beledb2/oracle2/sadmin/oracle/product/10.2.0/db_1
TNS_ADMIN = /beledb2/oracle2/sadmin/oracle/product/10.2.0/db_1/network/admin


System Environment Variables
===============================

DTUSERSESSION=obiee-172.16.2.177-0
XFILESEARCHPATH=/usr/openwin/lib/locale/%L/%T/%N%S:/usr/openwin/lib/%T/%N%S:/usr/dt/app-defaults/%L/Dt
DTAPPSEARCHPATH=/beledb2_1/sib/oracleBI/.dt/appmanager:/etc/dt/appconfig/appmanager/%L:/etc/dt/appconfig/appmanager/C:/usr/dt/appconfig/appmanager/%L:/usr/dt/appconfig/appmanager/C
LANG=C
DISPLAY=172.16.2.177:0.0
THREADS_FLAG=
PWD=/beledb2_1/sib/oracleBI
_=/usr/dt/bin/sdt_shell
TNS_ADMIN=/beledb2/oracle2/sadmin/oracle/product/10.2.0/db_1/network/admin
DTHELPSEARCHPATH=/beledb2_1/sib/oracleBI/.dt/help/obiee-172.16.2.177-0/%H:/beledb2_1/sib/oracleBI/.dt/help/obiee-172.16.2.177-0/%H.sdl:/beledb2_1/sib/oracleBI/.dt/help/obiee-172.16.2.177-0/%H.hv:/beledb2_1/sib/oracleBI/.dt/help/%H:/beledb2_1/sib/oracleBI/.dt/help/%H.sdl:/beledb2_1/sib/oracleBI/.dt/help/%H.hv:/usr/dt/appconfig/help/%L/%H:/usr/dt/appconfig/help/%L/%H.sdl:/usr/dt/appconfig/help/%L/%H.hv:/usr/dt/appconfig/help/C/%H:/usr/dt/appconfig/help/C/%H.sdl:/usr/dt/appconfig/help/C/%H.hv
OPENWINHOME=/usr/openwin
dtstart_sessionlogfile=/dev/null
USER=obiee
NLSPATH=/usr/dt/lib/nls/msg/%L/%N.cat
DTXSERVERLOCATION=remote
TERMINAL_EMULATOR=dtterm
EDITOR=/usr/dt/bin/dtpad
CLASSPATH=/tmp/install.dir.24744/InstallerData:/tmp/install.dir.24744/InstallerData/installer.zip:
DTDATABASESEARCHPATH=/beledb2_1/sib/oracleBI/.dt/types,/etc/dt/appconfig/types/%L,/etc/dt/appconfig/types/C,/usr/dt/appconfig/types/%L,/usr/dt/appconfig/types/C
HOME=/beledb2_1/sib/oracleBI
XMBINDDIR=/usr/dt/lib/bindings
DTSOURCEPROFILE=true
AB_CARDCATALOG=/usr/dt/share/answerbooks/C/ab_cardcatalog
XMICONBMSEARCHPATH=/beledb2_1/sib/oracleBI/.dt/icons/%B%M.bm:/beledb2_1/sib/oracleBI/.dt/icons/%B%M.pm:/beledb2_1/sib/oracleBI/.dt/icons/%B:/usr/dt/appconfig/icons/%L/%B%M.bm:/usr/dt/appconfig/icons/%L/%B%M.pm:/usr/dt/appconfig/icons/%L/%B:/usr/dt/appconfig/icons/C/%B%M.bm:/usr/dt/appconfig/icons/C/%B%M.pm:/usr/dt/appconfig/icons/C/%B
WINDOWID=67108875
LD_LIBRARY_PATH=/tmp/install.dir.24744/Solaris/resource/jre/jre/lib/sparcv9/server:/tmp/install.dir.24744/Solaris/resource/jre/jre/lib/sparcv9:/tmp/install.dir.24744/Solaris/resource/jre/jre/../lib/sparcv9:/beledb2/oracle2/sadmin/oracle/product/10.2.0/db_1/lib32:/beledb2/oracle2/sadmin/oracle/product/10.2.0/db_1/lib32:
SHELL=/bin/sh
LOGNAME=obiee
ORACLE_HOME=/beledb2/oracle2/sadmin/oracle/product/10.2.0/db_1
ENV=
DTSCREENSAVERLIST=StartDtscreenSwarm StartDtscreenQix StartDtscreenFlame StartDtscreenHop StartDtscreenImage StartDtscreenLife StartDtscreenRotor StartDtscreenPyro StartDtscreenWorm StartDtscreenBlank
DTDEVROOT=
SESSION_SVR=beledb2
HELPPATH=/usr/openwin/lib/locale:/usr/openwin/lib/help
MANPATH=/usr/dt/man:/usr/man:/usr/openwin/share/man
MAIL=/var/mail/obiee
TZ=Asia/Calcutta
XMICONSEARCHPATH=/beledb2_1/sib/oracleBI/.dt/icons/%B%M.pm:/beledb2_1/sib/oracleBI/.dt/icons/%B%M.bm:/beledb2_1/sib/oracleBI/.dt/icons/%B:/usr/dt/appconfig/icons/%L/%B%M.pm:/usr/dt/appconfig/icons/%L/%B%M.bm:/usr/dt/appconfig/icons/%L/%B:/usr/dt/appconfig/icons/C/%B%M.pm:/usr/dt/appconfig/icons/C/%B%M.bm:/usr/dt/appconfig/icons/C/%B
XFORCE_INTERNET=True
JAVA_HOME=/tmp/install.dir.24744/Solaris/resource/jre
TERM=dtterm
PATH=/usr/bin:/usr/xpg4/bin:/beledb2/oracle2/sadmin/oracle/product/10.2.0/db_1/bin:/opt/bin:/beledb2/oracle2/sadmin/oracle/product/10.2.0/db_1/bin:/opt/bin:/beledb2/oracle2/sadmin/oracle/product/10.2.0/db_1/bin:/beledb2/oracle2/sadmin/oracle/product/10.2.0/db_1/bin:/usr/bin:/usr/dt/bin:/usr/openwin/bin:/usr/ucb:/bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin


License Key
===========
License key file location: /beledb2_1/sib/oracleBI/installable/Informatica_PowerCenter_8.1.1_for_Solaris_back/Oracle_All_OS_Prod.key

File Contents
-------------
Serial number: 9567
Key type: Original
Edition: PowerCenter Standard
Software Version: 8.1.1
Distributed by: Siebel
Issued on: 2007-Jul-02 12:56:17.705
Validity period: Non-Expiry
Deployment level: Production
List of supported platforms are:
Adding [255] logical CPUs for [AIX 32]

Adding [255] logical CPUs for [AIX 64]
Adding [255] logical CPUs for [All operating systems]
Adding [255] logical CPUs for [HP-UX PA-RISC 32]
Adding [255] logical CPUs for [HP-UX IPF 64]
Adding [255] logical CPUs for [HP-UX PA-RISC 64]
Adding [255] logical CPUs for [Linux 32]
Adding [255] logical CPUs for [Linux 64]
Adding [255] logical CPUs for [Solaris 32]
Adding [255] logical CPUs for [Solaris 64]
Adding [255] logical CPUs for [Windows 32]
Adding [255] logical CPUs for [Windows 64]
Number of authorized repository instances: 1
List of PowerCenter options are:
Adding [Data Analyzer]
Adding [Team Based Development]
List of connectivities are:
Adding [DB2]
Adding [Informix]
Adding [Microsoft SQL Server]
Adding [ODBC]
Adding [Oracle]
Adding [SyBase]
Adding [Teradata]
Adding [PowerCenter Connect for IBM MQ Series (Real-Time)]
Adding [PowerCenter Connect for Oracle E-Business Suite]
Adding [PowerCenter Connect for PeopleSoft]
Adding [PowerCenter Connect for SAP NetWeaver - BW]
Adding [PowerCenter Connect for SAP NetWeaver - BW (Real-Time)]
Adding [PowerCenter Connect for SAP NetWeaver - mySAP]
Adding [PowerCenter Connect for SAP NetWeaver - mySAP (Real-Time)]
Adding [PowerCenter Connect for Siebel]


Installation directory selection
================================
/beledb2_1/sib/oracleBI/Informatica/PowerCenter8.1.1



Disk Space validation
======================
true
Enough Disk space is available for this Installation.

Available Disk Space: 823
Required Disk Space: 500


Copying files
=============
Copied the installer utillity files to /tmp/install.dir.24744


Informatica Installation Server Debug log
================================
Informatica Installation Server Debug log moved successfully to user installation directory : /beledb2_1/sib/oracleBI/Informatica/PowerCenter8.1.1


Copying files
=============
server to /beledb2_1/sib/oracleBI/Informatica/PowerCenter8.1.1
Copying files
=============
ODBC5.1 to /beledb2_1/sib/oracleBI/Informatica/PowerCenter8.1.1

PowerCenter Pre-Installation Tasks
==================================
Create or Join Domain selection: Create Domain

PowerCenter Repository Configuration (JDBC Test Connection)
===========================================================
In PowerCenter Repository Configuration Panel (JDBC Test Connection)
---------------------------------------------------------------------
DB Type : Oracle
Database user ID:infadb
Database service name:obia2
Database URL:beledb3.bel.com:1523;SID=obia2



Note : Test Connection passed
In PowerCenter Repository Configuration Panel (JDBC Test Connection)
---------------------------------------------------------------------
DB Type : Oracle
Database user ID:infadb
Database service name:obia2
Database URL:beledb3.bel.com:1523;SID=obia2



Note : Test Connection failed : The domain is already configured for this user. Enter another user.


Configure Domain Panel
---------------------------------------------------
Domain name:Domain_beledb2
Domain host name:beledb2
Node name:node01_beledb2
Domain port no:6001
Create Repository Servicetrue

Domain user name:admin




Advanced configuration for PowerCenter
======================================
These are the minimum and maximum port numbers for the node. Application services on the node use a port in this range.

Minimum Port : 6005
Maximum Port : 6105

Define Domain, Node and Resources
=====================================
Current time: 2008-Dec-11 17:34:11

Command Executed
----------------
cd "/beledb2_1/sib/oracleBI/Informatica/PowerCenter8.1.1/server"
./infasetup.sh defineDomain -dn "Domain_beledb2" -ad "admin" -pd ***** -ld \"/beledb2_1/sib/oracleBI/Informatica/PowerCenter8.1.1/server/infa_shared/log\" -nn "node01_beledb2" -na "beledb2:6001" -mi 6005 -ma 6105 -sv 6002 -bd \"/beledb2_1/sib/oracleBI/Informatica/PowerCenter8.1.1/server/infa_shared/Backup\" -rf nodeoptions.xml -da beledb3.bel.com:1523 -du infadb -dp infadb -dt Oracle -ds obia2 -f

Output of execution
-------------------
Output: [ICMD_10081] Domain configuration updated.

Error:
ExitCode: 0


Informatica Services Startup
===========================
Current time: 2008-Dec-11 17:39:09

Command Executed
----------------
"/beledb2_1/sib/oracleBI/Informatica/PowerCenter8.1.1/server/tomcat/bin/infaservice.sh" startup

Output of execution
-------------------
Output: Starting Informatica services on node 'node01_beledb2'
Using CURRENT_DIR: /beledb2_1/sib/oracleBI/Informatica/PowerCenter8.1.1/server/tomcat/bin
Using INFA_HOME: /beledb2_1/sib/oracleBI/Informatica/PowerCenter8.1.1

Error:
ExitCode: 0


Pinging the domain
=================
Current time: 2008-Dec-11 17:44:47

Command Executed
----------------
cd "/beledb2_1/sib/oracleBI/Informatica/PowerCenter8.1.1/server/bin"
./infacmd.sh ping -dn "Domain_beledb2" -dg "beledb2:6001" -nn "node01_beledb2" -re 60

Output of execution
-------------------
Output: [ICMD_10052] Node [node01_beledb2] Domain [Domain_beledb2] Host:Port [beledb2:6001] was successfully pinged.

Error:
ExitCode: 0

Adding license
==============
Current time: 2008-Dec-11 17:44:47

Command Executed
----------------
cd "/beledb2_1/sib/oracleBI/Informatica/PowerCenter8.1.1/server/bin"
./infacmd.sh addLicense -dn "Domain_beledb2" -un "admin" -pd ***** -ln "License_beledb2_9567" -lf "/beledb2_1/sib/oracleBI/installable/Informatica_PowerCenter_8.1.1_for_Solaris_back/Oracle_All_OS_Prod.key"

Output of execution
-------------------
Output:
Error:
ExitCode: 0
In PowerCenter Repository Configuration Panel
---------------------------------------------------------------------------

Code page generated: ISO 8859-1 Western European~Latin1~4;MS Windows Latin 1 (ANSI), superset of Latin1~MS1252~2252;


Repository Type Selected :New
Repository Name :Oracle_BI_DW_Base
Repository DB Type :Oracle
Code Page :Latin1
User ID :infadb
Connect String :obia2



Note : Test Connection failed :


Repository Type Selected :New
Repository Name :Powercenter
Repository DB Type :Oracle
Code Page :Latin1
User ID :infadb
Connect String :obia2



Note : Test Connection failed :


Repository Type Selected :New
Repository Name :Powercenter1
Repository DB Type :Oracle
Code Page :Latin1
User ID :infadb
Connect String :obia2



Note : Test Connection failed :


Repository Type Selected :Existing
Repository Name :Powercenter
Repository DB Type :Oracle
Code Page :Latin1
User ID :xdb
Connect String :obia



Note : Test Connection failed :