Question Re: Invalid profile parameter dbms/type (or environment variable dbms_type)- Oracle 12.1 in Technology Q&A

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

former_member201054 — Fri, 14 Apr 2017 06:31:12 GMT

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

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

JamesZ — Fri, 14 Apr 2017 08:52:12 GMT

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

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

former_member205280 — Thu, 27 Apr 2017 05:16:14 GMT

Hi Daniel,

You can manually edit the DEFAULT.PFL profile to add dbms/typ parameter, but you'll need to restart the SWPM installation process in order for the change to take effect. For SAP related parameters, we often change in DEFAULT.PFL, or instance related profile, but there are some exceptions like activate ssfs connection for Oracle database rsdb/ssfs_connect = 1, which needs to be set for both user environment and DEFAULT.PLF profile.

Regards,

Michael