4 Replies Latest reply: Feb 4, 2013 10:48 AM by Hussein Sawwan-Oracle RSS

    Initialization parameters after database upgrade eBusiness Suite 11.5.10.2

    InquisitiveDBA
      Our oracle database from 9i(9.2.0.8) to 11g R2(11.2.0.3) in oracle application 11i(11.5.10.2) environment.

      We initially have Oracle eBusiness suite:
      Application 11i (11.5.10.2)
      Database 9i (9.2.0.8)

      We upraded the database from 9.2.0.8 to 10.2.0.4. I noticed after the upgrade the following initialization parameters currently used by the upgraded database (10.2.0.4)

      optimizer_features_enable=9.2.0
      compatible=9.2.0
      optimizer_mode=choose

      Are these parameters correct? Does changing the parameter affect the application? I know that if I upgraded the database, the compatible must be upgraded too unless there are application issues.
      Any thoughts or feedback on this? Thanks.