on 09-03-2014 11:49 AM
Hi Ahmed,
Let Me know Your issue Is solved or not. if not try this wil help to you,
sqlplus>show parameter shared_pool_size -- 1st check the Size Then
sqlplus>alter system set shared_pool_size= <Value>;
the new size should be 25 % more then the present value,.i.e. out put from
first command.
this way you can increase the value of the shared pool dynamically.
Regards,
Raj.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear
SQL>alter system set SHARED_POOL_SIZE = XXXM;
SQL>alter system set DB_CACHE_SIZE = XXXM;
increase SGA area also
first take backup spfile
after parameter changes it not works restore the spfile other wise oracle will get into mess
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear
as your log said rc=12541 which means
check if Oracle Listener is up. start it.
c:\>sqlplus /nolog
SQL>connect / as sysdba;
If you are not able to connect, Check whether ORACLE_HOME and ORACLE_SID are
assigned.
(also check in regedit : HKEY_LOCAL_MACHINE>SOFTWARE>ORACLE>HOME )
Sometime ORACLE_SID might not be assigned. Make the changes and try.
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SID.WORLD))
STATUS of the LISTENER
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ahmed,
The problem With Shared pool size, check the current shared pool size and Increase it by 25% And try the Installation.
Hope it helps You.
Regards,
Raj.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ahmed,
There can be many reason for termination.
How would you know that ? You need to look into logs.
The log which you has posted itself says look into "import_monitor.java.log and import_monitor.log".
As per you these logs, you need to further check SAPSLOAD.log and other import package logs.
Check and Upload to find the cause.
Else is everything is fine, update R3* files of kernel and try again.
Regards,
Divyanshu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You need to set the standard parameters recommended for Oracle 10g.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Share both the files named import_monitor.java.log, import_monitor.log for analysis.
Thanks,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Post errors in the import_monitor.log
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ahmed ,
Can You please Share the logs import_monitor.java.log, import_monitor.log. Also
Regards,
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.