Invalid profile parameter dbms/type (or environment variable dbms_type)- Oracle 12.1

[former_member201054]

Hi ,

Installing database in a distribution system. Encountering the below error for Import ABAP connection test.

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

R3trans -d test result from application server

ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library

Can I define the paramter dbms/typ = ora in default profile as there is no instance profile created yet?

how to set the enviroinment variable dbms_type = ora permanently in the app server?..

should it be set under .sapenv_hostname.csh? ( but it says not to edit)

if possible , both PATH and LIB_PATH must be edited? ..example please.

I would appreciate all your help

Thanks in advance

[JamesZ]

Hi Daniel,

Please check the oracle_home setting in listener.ora whether it is the same with the oracle_home in environment variable.

If this is not a problem, please upload trans.log.

Best regards,
James