SAP App not starting after installation of SAP ECC6.0 EHP7 Oracle 11G on SUSE Linux 12

[former_member601547]

Hello Experts,

i have Installed SAP ECC6.0 EHP7 with Oracle 11G on SUSE Linux 12 SP5.

SAP App is instlled on one server and Oracle on another server(distributed)

Database is running but when executing R3trans -d on app server its gives RC=12. Below is the trans.log:

SIDadm 69> R3trans -d This is R3trans version 6.25 (release 742 - 11.02.15 - 14:06:42). unicode enabled version 2EETW169 no connect possible: "environment variable dbms_type is not set." R3trans finished (0012). tra-ecas0-sbx:ls0adm 70> more trans.log 4 ETW000 R3trans version 6.25 (release 742 - 11.02.15 - 14:06:42). 4 ETW000 unicode enabled version 4 ETW000 =============================================== 4 ETW000 4 ETW000 date&time : 14.10.2020 - 13:51:03 4 ETW000 control file: <no ctrlfile> 4 ETW000 R3trans was called as follows: R3trans -d 4 ETW000 trace at level 2 opened for a given file pointer 4 ETW000 [ dev trc,00000] Wed Oct 14 13:51:03 2020 29 0.000029 4 ETW000 [ dev trc,00000] db_con_init called 16 0.000045 4 ETW000 [ dev trc,00000] set_use_ext_con_info(): usage of ssfs switched off (rsdb/ssfs_connect=0) 4 ETW000 13 0.000058 4 ETW000 [ dev trc,00000] determine_block_commit: no con_hdl found as blocked for con_name = R/3 4 ETW000 7 0.000065 4 ETW000 [ dev trc,00000] create_con (con_name=R/3) 5 0.000070 4 ETW000 [dbcon.c ,00000] *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library 4 ETW000 19 0.000089 2EETW169 no connect possible: "environment variable dbms_type is not set."

SIDadm 71>

Please let me know if you need any more details.

Thanks and Regards

Ankur Ajane

[S_Sriram]

Hi Ankur.

Refer to the link with this you have to find the steps for example in windows you can refer the SAP note 1827566

https://www.cyberciti.biz/faq/set-environment-variable-unix/

Regards

SS

[S_Sriram]

Hi Ankur.

Are you trying to execute the command in the SAP SIDADM user id? normally all the environment variables are set in the SIDADM user-id, I am not sure about the linux, refer the sap note 2452812.

Regards

SS

[former_member601547]

yes i am running the command in the SAP SIDADM.

In app Server i ran env command and found that "dbms_type=ora" is missing there. and i am not sure how to add it there.
to add it temporarily i tried dbms_type=ora, but it said dbms_type=ora: Command not found.i even tried setenv dbms_type=ora it saidsetenv: Variable name must contain alphanumeric characters.

[dasistdochscheisse]

Have you tried to set dbms_type and call R3trans -d again?

[former_member601547]

i am not sure where to set this parameter.

when i do echo $dbms_type it gives ora

I have tried # export dbms_type=ora and still the same error.

I am not sure where to check this parameter and what location?

[dasistdochscheisse]

> Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>
looks like he profile parameter is not set. DEFAULT.PFL is the file.

BTW, sidadm uses the c-shell, so the correct syntax would be "setenv dbms_type ora" and it is set in .sapenv.csh or .dbenv.csh

And ssfs should be working. Has the installation run through without poblems?