United States English English IBM® Site map IBM IBM Support Check here to start a new keyword search. If no signons are available, then you might need to create one using the New Signon option from the toolbar at the upper right of the page. These properties can be located by 1. IBM Cognos would require the full NAME.DOMAIN.COM alias to be defined in the connection string. 5. Source
Oracle 11g installed on machine 2. After the tnsnames.ora aliases are defined and tested, ensure that the alias in the tnsnames.ora file matches the alias in the IBM Cognos connection string. Steps: 1. Click 'edit' and modify the TNS_ADMIN to include the correct path to the tnsnames.ora file and click 'OK'. http://www-01.ibm.com/support/docview.wss?uid=swg21341734
I tried almost everything to get it work but no results till today. 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 If the client is installed with the data base, it is generated. Search the system for multiple tnsnames.ora files.
If the error message that is referenced is occurring in Framework Manager, then ensure that the IBM Cognos server is started, accessible, and fully configured. All rights reserved. Home | Invite Peers | More Business Intelligence Groups Your account is ready. Cognos Data Source Connection Oracle ldd libcogudaor
Compare the version of the Oracle client driver to any listed for the supported environments of the product version that you are using. Hi, Try this, http://bicentre.blogspot.com/2009/01/cognos-oracle-unable-to-connect.html Regards, Rajesh Log in to reply. Using SQLPlus to establish a connection can provide more detail regarding the failures. imp source Cause The Oracle Client installed on Cognos Server is 64-bit version.
To do so, click the listed Connection (accomplished by following steps 1 and 2). 6. Qe-def-0285 The Logon Failed Oracle My best regards. Logon to an Oracle database via SQl*Plus from Cognos Server, then you can see if the Oracle client is 64-bit Production or 32-bit Production; 2. Click on the Pencil icon to edit the connection string.
In IBM Cognos , the client driver is required on both the IBM Cognos server and on any system that runs Framework Manager. http://www.ibm.com/support/docview.wss?uid=swg1PM97864 This is the accepted answer. Uda-sql-0432 Unable To Locate The Gateway Cogudaor Cognos Start a new thread here 859172 Related Discussions UDA-SQL-0432 Unable to locate the gateway "cogudaor". Cogudajdbc In UNIX, the ldd command can be used to identify the dependencies of the libcogudaor library (located in the Cognos bin directory).
Steps: 1. this contact form This requirement exists because the BIBusTKServerMain process, which handles database connectivity, is written in 32-bit code, and so cannot use 64-bit database clients. *** 1. Testing cogudaor.dll / cogudaif.dll with Dependency Walker and Process Explorer software showed libraries being loaded successfully. 3rd party software "CYGWIN" and "OpenSSH" installations on same machine are known to cause this UDA-SQL-0432 Unable to locate the gateway "libcogudaor" mn-konno asked Nov 7, 2005 | Replies (5) I have a problem. Rqp-def-0068 Unable To Connect To At Least One Database During A Multi-database Attach To 1 Database
On Windows the third party tools, Dependency Walker, RegMon, and FileMon (RegMon and FileMon are available from SysInternals) can help identifying missing or inaccessible files. Qe-def-0285 The Logon Failed Cognos Connection Example: TNS_ADMIN:=oracle client install/product/product_version/Client_1/NETWORK/ADMIN Steps: 1. Refer to your Oracle product documentation for the details on installing and configuring your environment to use the 32-bit client libraries.
For example, if an alias is defined as NAME.DOMAIN.COM then SQLPlus allows connections by using just the NAME portion of the alias. As a last resort, copy both the files
Define the Oracle instance in the file. (The following might be optional. Uninstall 64-bit Oracle client; 3. Join this group Popular White Paper On This Topic 5 Best Practices for Business Intelligence 5Replies Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) http://globalcryptonews.com/unable-to/unable-to-access-any-items-in-the-model-cognos.html Note: The above is true for a native CQM datasource connection.
For example, if for any reason the oci.dll (located in the Oracle bin directory) is not available then the connection fails. dump -H libcogudaor.so -- AIX Using these trace utilities identify scenarios where the libraries are being sourced from a location other than the expected Oracle bin directory. Local fix Workaround: rename the libcogudaor12.so to something else e.g. anyone?
If these options are not enabled, then the user ID and password are not included in the connection string when establishing the Oracle connection . The connection for Cognos can be defined without enabling a user ID or password. Required fields are marked *Comment Name * Email * Website Current [email protected] * Leave this field empty Take a moment to rate this website Please Rate Me! ★ ★★ ★★★ ★★★★ Environment Cognos server installed on machine 1.
Rename shr.o to libclntsh.so and copy this file to the 32-bit library directory of your Oracle client installation.