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.
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.
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....