cancel
Showing results for 
Search instead for 
Did you mean: 

While installation SAP BO BI 4.2 SP6 connection to oracle database is not working

0 Kudos

Hello,

I have tried to install BO BO 4.2 SP6 and connect it to already existing Oracle Database which is running on a different host. I have downloaded Oracle client, set the enviroment TNS_ADMIN for the tnsnames.ora and ORACLE_HOME for the folder where it was installed (just the client).

During the installation when it asks for TNSNAME , USERNAME and PASSWORD I always get the error:

ORA-12154 TNS: could not resolve the connect identifier specified.

when I try to connect to oracle db with sqlplus [username]/[password]@SID the connection works but otherwise it doesn't, did I miss something? Can you please help?

bo-install.png

Accepted Solutions (0)

Answers (4)

Answers (4)

0 Kudos

Hello and what can I do in this case?

trace log from the installation:

|8de88b9b-b53c-91c4-5999-02a7f7e53d25|2018 09 12 09:22:45:875|+0200|Error| |>>|E| |dbcheck| 3568|7452|| ||||||||||||||||||||||assert failure: (d:\a42sr64\src\platform.services.cms.cpp\dbutilities\dbutils_lib\subsysmgrhelper.h:190). (false : DBUtils::Subsystem Init: Failed to init subsystem manager. Reason: Error initializing database wrapper environment for DatabaseSubsystem.).

Thanks

bo-instal-2.png

denis_konovalov
Active Contributor
0 Kudos

this indicates that the installer can't load some oracle libraries.
Which exact oracle client and what options during it install have you selected ?

patelyogesh
Active Contributor
0 Kudos

HelloPeter Kepes,

Can you please check SAP note : 1685285 - INS00104 during Installation of BOE40

Thank you

Yogesh

denis_konovalov
Active Contributor
0 Kudos

the error comes from Oracle, BOE tries to connect, but oracle doesn't like what it provides.
So, either you are not providing correct system/service name
or you are using wrong client version ....
If you go to command prompt and run tnsping "service_name" , where "service_name " is the same name you give to installer - what happens ?

0 Kudos

in the trace log of the installation this error is generated while I get the error message:

|09caab8e-f7ec-8624-99df-2b4f783e286f|2018 09 11 14:47:31:247|+0200|Error| |>>|E| |dbcheck| 788|1968|| ||||||||||||||||||||||assert failure: (OracleDatabase.cpp:119). (0 : Programmer error: OCI_INVALID_HANDLE).