Re: MAX_OPEN_CURSORS - How to set on W95/NT? URGENT!

1. Open the file Orawin95\Database\Initorcl.ora
2. Scroll down until you see the entry compatible = 7.2.0.0.0 Beneath this entry type the following (but it shouldn't really matter where you put it: OPEN_CURSORS = 150 (or whatever number is applicable)
3. Save the changes
4. If your Oracle7 database is running, it will need to be stopped and restarted before the changes will take effect.

Mark...

stevec_at_zimmer.csufresno.edu wrote in article <877194349.8460_at_dejanews.com>...
> I am trying to set up my home pc running Personal Oracle 7 for
> Windows95 so I can do a demo of some heavy duty forms. These require
> boosting the max_open_cursors setting since I keep getting the
> ORA-00604 too many open cursors message.
>
> I have gone into the Registry and added a string: MAX_OPEN_CURSORS,
> and set the value to 200. I tried this at the
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE level, and below this at the
> ORACLE_HOMES level and the ORACLE1 level below that. (Actually, I
> have an entry at each level) But after restarting Windows, PO7, and
> the Form with the problem, I still hit the limit at the same place.
>
> Where is the right place to put this entry?
>
> Thanks in advance for any replies. Please email me if you
> can--sometimes posted messages don't get through.
>
> Steve Cosner
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
>
  Received on Wed Oct 22 1997 - 00:00:00 CDT