on 06-26-2007 10:15 AM
Hi,
I am installing NW2004S - PI but at ABAP Import ( Export Dvd's) stage I am getting the jobs failing as lack of shared memory. Is there any way to increase shared memory? I increased my VM to 8GB but still I am facing the jobs fail. Is there any way to overcome this issue. Any help on this is greatly appreciated.
Thanks & Regards,
Daniel.LA
Hi,
This is due to small SGA size.. Stop the insatlltion increase the size of Shared_Pool_size in intisid.ora, restart the database and continue the installtion
regards
Umesh k
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Daniel,
1.First check whether TNSListener is running. If is running Login as <SID>adm and check whether database is up and running.
How to check?
goto run and type sqlplus "/as sysdba"
If you get Ideal Instance as a result use STARTUP command to start database.
If database is already up and running follw the step2.
2. Goto init<SID>.ora file at OS level. (
oracle\ora92\database\init<SID>.ora)
take a back up of file and change the following parameters values as i specified.
a. shared_pool_size = 20M and
b. db_cache_size = 20M
then restart Installation.
This will solve your problem.
Regards,
Suraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Additionally you should set Oracle parameters to accept/recognize this..
sqlplus /nolog
SQL> connect / as sysdba;
SQL> create spfile from pfile;
SQL> alter system SET JAVA_POOL_SIZE=50000000 <b>scope=pfile</b>;
SQL> show parameters;
use "show parameters" to see the other parameters to be increased
Continue installation and it should proceed, revert for queries
Cheers,
Senthil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.