shared memory

I did some modifications..like this.
alter system set shared_pool_size =0 scope=memory;
alter system set large_pool_size=0 scope=memory;
alter system set java_pool_size =0 scope=memory;
alter system set memory_target =0 scope=memory;
I did commit..
after that
desc v$sgastat;
error:
ora-00604 error occurred at recursive sql level 3
ora-04031 unable to allocate 4064 bytes of shared memory("shared pool","select inst_id,'',ksmssnam,k...","sga heap(1,0)","kglsim heap")


what could be the problem?
nobleitAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
What database version?

I assume you are playing around with Automatic Memory Management (AMM)?  Did you set sga_target and sga_max_size (going from memory on the max size parameter)?

I suggest you refer to the docs on AMM for your version.  Things are changing a lot with every release.

If you don't have AMM set up, you need some memory to do anything.  Don't set it all to 0.
slightwv (䄆 Netminder) Commented:
>>I did commit.

No need to commit.  These commands are not DML and cannot be rolled back.
nobleitAuthor Commented:
There is nothing to do with asm..I was trying to do permormance features...
nobleitAuthor Commented:
I manually modified the init.ora
now init.ora is like this...after I after I made this error
(alter system set shared_pool_size =0 scope=memory;
alter system set large_pool_size=0 scope=memory;
alter system set java_pool_size =0 scope=memory;
alter system set memory_target =0 scope=memory;
I did commit..)
----------------
init.ora now...
jtac.__db_cache_size=310378496
jtac.__java_pool_size=12582912
jtac.__large_pool_size=4194304
jtac.__oracle_base='C:\app\Mathew'#ORACLE_BASE set from environment
jtac.__pga_aggregate_target=268435456
jtac.__sga_target=536870912
jtac.__shared_io_pool_size=0
jtac.__shared_pool_size=264241152
jtac.__streams_pool_size=0
*.audit_file_dest='C:\app\Mathew\admin\jtac\adump'
*.audit_trail='db'
*.compatible='11.1.0.0.0'
*.control_files='C:\app\Mathew\oradata\jtac\control01.ctl','C:\app\Mathew\oradata\jtac\control02.ctl','C:\app\Mathew\oradata\jtac\control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='jtac'
*.db_recovery_file_dest='C:\app\Mathew\flash_recovery_area'
*.db_recovery_file_dest_size=3221225472
*.diagnostic_dest='C:\app\Mathew'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=jtacXDB)'
*.log_archive_dest_1='location=c:\oracle\archive1'
*.log_archive_dest_2='location=c:\oracle\archive2'
*.memory_target=803209216
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_max_size=512000000
*.sga_target=226492416
*.undo_tablespace='UNDOTBS1'
----------------------------------------------

after that in the i executed the following commands below..
----------------------
SQL> shutdown immediate
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","select value$ from props$ wh...","sga heap(1,0)","kglsim object batch")
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup nomount
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> SELECT name, SUM(bytes) FROM V$SGASTAT WHERE pool='LARGE POOL'
  2  GROUP BY ROLLUP(name);
SELECT name, SUM(bytes) FROM V$SGASTAT WHERE pool='LARGE POOL'
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0


SQL> alter system set shared_pool_size=264241152 scope=memory;
alter system set shared_pool_size=264241152 scope=memory
*
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0


SQL> startup pfile=C:\app\Mathew\product\11.1.0\db_2\database\INITjtac.ora
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 3936 bytes of shared memory ("shared pool","select value$ from props$ wh...","sga heap(1,0)","kglsim object batch")

Please help me to resolve this issue..
This is not related to ASM..
slightwv (䄆 Netminder) Commented:
>>scope=memory;

Set these with scope=spfile.  When you are all done, then bounce the database.  With scope=memory, you basically told Oracle to deallocate everything and it had no fall back plan.

>>This is not related to ASM..

Automatic Memory Management: AMM

NOT Automatic Storage Management: ASM.

The docs.  Always start with the docs:
http://download.oracle.com/docs/cd/E11882_01/server.112/e17120/memory003.htm#ADMIN11011


>>ORA-01081: cannot start already-running ORACLE - shut it down first
>>ORA-01012: not logged on

Errors are self explaitory


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.