Home » RDBMS Server » Server Administration » Cant increase the SGA
Cant increase the SGA [message #289564] Mon, 24 December 2007 01:18 Go to next message
saagar
Messages: 79
Registered: December 2007
Member
Shocked
hi all
i have encountered some wired problem
i have windows 2003 server 32 bit on which i have installed oracle 9i on it its physical ram is 4GB it is showing that but when ever i want to increase its SGA more than 700MB it gives me error after when i want to open database it wouldnt let me in also
it gives ORA-12700 Shared Memory Realm Already exist...

please help me to solve this error... and another error while compling huge PL/SQL .......its gives error ORA-065550 and PLS-00123 program too large

please help me to resolve this error....
regards
Re: Cant increase the SGA [message #289566 is a reply to message #289564] Mon, 24 December 2007 01:32 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

1. Are you sure your getting ORA-12700 error.
2. any other oracle software is install on windows machine.
3. about plsql error can you post plsql program.
Re: Cant increase the SGA [message #289573 is a reply to message #289564] Mon, 24 December 2007 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

ORA-12700: invalid NLS parameter value (string)
Cause: An invalid or unknown NLS configuration parameter was specified.
Action: none

Correct your post.

Regards
Michel
Re: Cant increase the SGA [message #289574 is a reply to message #289573] Mon, 24 December 2007 02:33 Go to previous messageGo to next message
saagar
Messages: 79
Registered: December 2007
Member
hi
please see the attached file i have posted that error

regards
Re: Cant increase the SGA [message #289583 is a reply to message #289574] Mon, 24 December 2007 03:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't read doc file, this is stated in OraFAQ Forum Guide.
Correct your post accordingly to forum guidelines.

Regards
Michel
Re: Cant increase the SGA [message #289587 is a reply to message #289564] Mon, 24 December 2007 03:14 Go to previous messageGo to next message
halfydba
Messages: 20
Registered: November 2007
Location: Australia
Junior Member
If your PL/SQL is that large, I think you need to consider making it more modular.
If you can't increase your SGA, you have probably run out of memory. Check what else is consuming memory on the box.
Re: Cant increase the SGA [message #289684 is a reply to message #289587] Tue, 25 December 2007 06:10 Go to previous messageGo to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
You can not increase SGA_MAX_SIZE to bigger than 1512MB if your machine is server. Due to Windows 32 bit does not manage big memory and big file. Consider about the VLM and change it into 64 bit. The VLM - very large memory in Metalink, basic search.

Re: Cant increase the SGA [message #290647 is a reply to message #289684] Mon, 31 December 2007 00:36 Go to previous messageGo to next message
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
Member
It is not fair to say that windows 2003 server will give you memory insufficient errors provided your OS is properly configured. Installing / running Oracle on a machine which is not properly configured may result in unexpected behavior from Oracle Server. windows 2003 server is designed in such a way that what ever amount of memory a process requests will be provided if not from physical then from virtual {swap). If more swap is being used than also not a healthy environment for oracle. Please do following checks hope your problem should vanish:-

(a) Put service pack 2 if you are not using windows 2003 R2 server. R2 or SP2 automatically enable /PAE flag.
(b) check you have /PAE flag enabled [ mycompter -->Rtclick-->Properties -->General tab should see "Physical Address Extension"].
(c)Check if any other non oracle windows process is not consuming significant amount of memory if so uninstall such programs.
(d) In your production environment please do not install any thing else on server other than OS & oracle.[ Oracle loves privacy if you expect performance from it].
(e) Remember 95% of Oracle misbehaviors are caused by improperly / poorly configured/tuned OS.
(f) Remember 90% of DBA's are not comfortable with OS they are using with Oracle.
(g) Check your swap file size make it 4 to 5 times physical memory.

If still not clear than you are welcome to write back
Regards
Manjit Kumar

[Updated on: Mon, 31 December 2007 03:05]

Report message to a moderator

Re: Cant increase the SGA [message #290651 is a reply to message #290647] Mon, 31 December 2007 00:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
mkbhati just an advice, don't put your email in forum post, this is a public area and you will likely be spammed.
If you want you can put it in your profile.

Regards
Michel
Re: Cant increase the SGA [message #290702 is a reply to message #290651] Mon, 31 December 2007 03:00 Go to previous message
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
Member
Thank you Michel, Noted for future.

Regards

Manjit
Previous Topic: Oracle Users
Next Topic: Upgration and Migration.
Goto Forum:
  


Current Time: Fri Dec 02 12:15:43 CST 2016

Total time taken to generate the page: 0.11500 seconds