Skip to Content
avatar image
Former Member

How to check SAP Profile Parameters

Hi expert,

               I upgrade my oracle database from 10.2.0.5 ro 11.2.0.4 with the help of sap guide.  In the end of the guide, it tells me to check SAP profile parameters.

               You have to check the following SAP profile parameters:

               DIR_ORAHOM

               DIR_CLIENT_ORAHO

               DIR_SERVER_ORAHOME

              1.Set DIR_ORAHOME and DIR_CLIENT_ORAHOME in the instance profiles to the corresponding values of the ORACLE_HOME environment variable of the , on the database server.

               Where can I find these profile parameters?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 18, 2014 at 08:09 AM

    Hello,

    usually profiles are placed in /usr/sap/<SID>/SYS/profile. There you will see DEAFAULT.PFL, which is default profile. And also <SID>_<instance>_<server> (or something similar), which is instance profile. You should find parameters in these files.

    Other possibility is to use SAP GUI and transaction RZ11.

    Kind regards

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 18, 2014 at 08:15 AM

    Hi Zong,

    Goto RZ11 and get info for any SAP parameters.

    Set DIR_ORAHOME and DIR_CLIENT_ORAHOME in the instance profiles to the corresponding values of the ORACLE_HOME environment variable of the , on the database server.

    You have to check and update location in instance profile with value that of oracle_home env variable of orasid.

    Refer basics: 949451 - Oracle 11.2.0: Database Upgrade To Release 11.2.0.4 on Unix (Quick Reference)


    Regards,

    Divyanshu

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 18, 2014 at 08:34 AM

    If you want to list all system parameters in a simple way you should run report RSPARAM

    Start SE38 and then execute report.

    This report lists all parameters, including the defaulted values not set in either default.pfl or instance profile.

    Add comment
    10|10000 characters needed characters exceeded