Skip to Content
0

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

Apr 14, 2017 at 06:31 AM

659

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

James Zhang
Apr 14, 2017 at 08:52 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Apr 27, 2017 at 05:16 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded