Unable to locate the gateway libcogudaor

[promoplaat]

Dear experts,

This is my configuration for running Cognos 8.4 linux 32-bit;

- Oracle Enterprise Linux 4 Update 5
- IBM Java 1.4.2
- Oracle XE (Also tried the standard Oracle10gR2 database)
- Cognos BI Server 8.4 for Linux 32-bit
- Apache 2.0
- Firefox browser

Everthing went fine installing the cognos software until i tried to get a connect to
to the Oracle Database. I tried almost everything to get it work but no results till
today. All my environment variables are pointing to the right location and the
cognos configuration managers starts all the services without any problems. And
still the annoying error message "UDA-SQL-0432: Unable to locate to gateway libcogudaor" 
keeps coming back;



I tried to search on the web i tried many suggestions to solve the problem, in example;
http://www-01.ibm.com/support/docview.wss?uid=swg21341734

These are my env. variables settings;

SSH_AGENT_PID=4066
HOSTNAME=local.linuxserver.com
DESKTOP_STARTUP_ID=
SHELL=/bin/bash
TERM=xterm
HISTSIZE=1000
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
GTK_RC_FILES=/etc/gtk/gtkrc:/root/.gtkrc-1.2-gnome2
WINDOWID=31457354
USER=root
LD_LIBRARY_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib:/opt/instantclient_10_2:/opt/cognos/c8/bin
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
ORACLE_SID=XE
GNOME_KEYRING_SOCKET=/tmp/keyring-ruS2sB/socket
SSH_AUTH_SOCK=/tmp/ssh-ozGdvi4002/agent.4002
KDEDIR=/usr
SESSION_MANAGER=local/local.linuxserver.com:/tmp/.ICE-unix/4002
TNS_ADMIN=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin
MAIL=/var/spool/mail/root
DESKTOP_SESSION=default
PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin:/opt/IBMJava2-142/jre/bin:/opt/cognos/c8/bin:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/opt/IBMJava2-142/jre/bin:/opt/cognos/c8/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin
INPUTRC=/etc/inputrc
PWD=/root
JAVA_HOME=/opt/IBMJava2-142/jre
LANG=en_US.UTF-8
GDMSESSION=default
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
HOME=/root
SHLVL=2
GNOME_DESKTOP_SESSION_ID=Default
LOGNAME=root
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-sBOU67S42b
LESSOPEN=|/usr/bin/lesspipe.sh %s
DISPLAY=:0.0
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
G_BROKEN_FILENAMES=1
COLORTERM=gnome-terminal
XAUTHORITY=/root/.Xauthority
_=/bin/env

tnsping ping to oracle 'XE' also works fine.

but still with no results... can you please give me a suggestion or solution to solve
the problem?

[david.stachon]

I think you're missing copying the .jar file from the oracle install directory, into your cognos directory....

follow these steps carefully:

http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.c8bi.inst_cr_winux.doc/inst_cr_winux_id6511SetupdatasourcesforFrameworkManager.html

[promoplaat]

Hi david,

Thanks for the reply, but i completed this task in my installation (i have copied ojdbc14.jar into the /opt/cognos/c8/webapps/p2pd/WEB-INF/lib location) , otherwise i could not connect in the configuration manager to my oracle db, but that works! only connecting from the administration window does not work... any ideas?