Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 14, 2017 at 08:52 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 27, 2017 at 05:16 AM

    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

    Add comment
    10|10000 characters needed characters exceeded