BODI-320006: Cannot open connection to the repository ?

[Former Member]

I have successfully installed 64-bit BO DS 3.1 AIX ver. on 64-bit AIX OS ver. 5.3 .

Now, I'm trying to create the repository on 64-bit Oracle using the following command:

$ repoman -c -Ulocal_repo -Padmin -Qdwh -Saix -tlocal -NOracle -d -o

but, I've got an error message..

-

---

BODI-320006: Cannot open connection to the repository.

The error message from the underlying DBMS is <Oracle shared library <libclntsh.a(shr.o)> not found.

Please make sure it is installed and can be located using the library search path (LIBPATH on AIX, LD_LIBRARY_PATH on Solaris/Linux, SHLIB_PATH on HP-UX).

Please check the file permissions for <libclntsh.a(shr.o)>.>.

An error occurred during local repository creation.

-

---

Environment Variables on my AIX:

$ echo $LINK_DIR

/appli/businessobjects/dataservices

$ echo $LIBPATH

/appli/businessobjects/dataservices/bin:/appli/businessobjects/dataservices/ext/webservice-c/lib:/appli/oracle/product/10.2.0/lib

$ echo $ORACLE_HOME

/appli/oracle/product/10.2.0

$ echo $PATH

/appli/businessobjects/bobje/jdk/bin:/appli/businessobjects/dataservices/bin:ORACLE_HOME/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/bods/bin:/usr/bin/X11:/sbin:

$ echo $ORACLE_SID

DWH

Permissions:

bash-3.2$ ls -l libclntsh*

-rw-r----- 1 oracle oinstall 24705307 Jul 23 13:37 libclntsh.a

lrwxrwxrwx 1 oracle oinstall 17 Jul 23 13:38 libclntsh.so -> libclntsh.so.10.1

-rwxr-xr-x 1 oracle oinstall 24126721 Jul 23 13:38 libclntsh.so.10.1

Any help would be appreciated

Thanks

Georg

[Former Member · Accepted solution]

For Oracle, you should not use -Q option. It is only used for DB2 and SQL Server

-S should be the Database Instance Name

You also have to make sure you have already created the user "local_repo" in the "aix" database.

The other option is to use Repository Manager on Windows. (This is the prefered method, although it can be tedious if you have many repositories to create)