Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Location
    Jagdishpur
    Posts
    146

    Unanswered: DB Parameter Resource_Manager_plan

    Hi,

    We are using Oracle9iDB Version 9.2 on SUN Solaris 5.8. When we use DB parameter RESOURCE_MANAGER_PLAN=SYSTEM_PLAN in INIT.ORA & trying to start-up the Database, It is giving me an error "Instance Terminated. Disconnection forced." And database does not comes up.

    When we disable this parameter from the INIT.ORA file, then the DB comes up normally & smoothly. What may be the reason for this error. Could anyone see to it and help me please. Any work-around to this.

    Thanks a lot in advance.

    Regards,
    - KR

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Dear RastogiKamesh,

    I have tested it on My DB and it works well with me.
    Make sure your INIT.ORA should not contain TWO entries of this parameter. I don't have more any idea about this.

    Hope it works.

    Thanks

    Hings.

    ==========

    Still Learning...

  3. #3
    Join Date
    Apr 2003
    Location
    Jagdishpur
    Posts
    146
    Originally posted by Hings
    Dear RastogiKamesh,

    I have tested it on My DB and it works well with me.
    Make sure your INIT.ORA should not contain TWO entries of this parameter. I don't have more any idea about this.

    Hope it works.

    Thanks

    Hings.

    ==========

    Still Learning...

    Hi,
    On what OS u have tested it. Is it on SUN OS and Oracle9i..?? I have one entry for this parameter and that is giving me trouble. I think there might be some conflict between SUN OS resource manager and Database Resource Manager. Just a guess....

    So, how can test it overe here....

    Regards,
    - KR

  4. #4
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Dear RastogiKamesh,

    I have tested it on 8.1.7 with Linux (2.4.18-3).
    I am not sure about Sun OS with 9iR2.

    Thanks,

    Hings

    ==========

    Still Learning...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •