Hi there,
I have received several answers, one of the first ones (that did it) was:
> You may have to increase the value of shared_pool_size in your
> init'DATABASE NAME '.ora file
> this file by default will be at $ORACLE_HOME/dbs pointer
> select value depening on the processes for that database.
I increased "shared_pool_size" in initMAIN.ora. It doesn't give me any
more error messages. I am still waiting for some of the lecturers to have
the script run in their classes to see if the problem is gone for good.
THANK YOU VERY MUCH!
cheers,
Hossein
Original posting:
> Dear managers,
> A few month ago I had a problem with our Oracle installation, and some
> nice sole on this list helped us out. He wrote the problem comes after
> oracle 7.3, and suggested to truncate
> $ORACLE_HOME/otrace/admin/process.dat, collect.dat, fdfdir.dat, and
> regid.dat. That worked.
>
> Now we have another problem which seems related/similar to the old one.
> When several students at 1 time try to compile a simple PL/SQL script (to
> create a simple and small table), the following message appears :
>
> ERROR at line 1:
> ORA-04031: unable to allocate 2048 bytes of shared memory
> ("POSITION_CATEGORY","PL/SQL DIANA","PAR.C:parrlc:page")
>
>
> Any ideas would be greatly appreciated.
>
> regards,
> Hossein
>
> ,-----------------------------------------------------------------------,
> | ...Mary had a little ram and Windows was so slow... |
> |-----------------------------------------------------------------------|
> | Hossein S. Zadeh |
> | hossein_at_bf.rmit.edu.au |
> |-----------------------------------------------------------------------|
> | Dept of Aerospace Engineering | RMIT-Faculty of Business |
> | (YES! I AM a rocket scientist!!)| (YES! I AM in business!!) |
> | |
> | Royal Melbourne Institute of Technology (RMIT), Melbourne, Australia |
> '-----------------------------------------------------------------------'
>
>
>
>
>
>
>
,-----------------------------------------------------------------------,
| ...Mary had a little ram and Windows was so slow... |
|-----------------------------------------------------------------------|
| Hossein S. Zadeh |
| hossein_at_bf.rmit.edu.au |
|-----------------------------------------------------------------------|
| Dept of Aerospace Engineering | RMIT-Faculty of Business |
| (YES! I AM a rocket scientist!!)| (YES! I AM in business!!) |
| |
| Royal Melbourne Institute of Technology (RMIT), Melbourne, Australia |
'-----------------------------------------------------------------------'
Received on Wed Sep 30 1998 - 06:59:40 NZST