ORA-07445[kksParseChildCursor], ORA-04030, Swap space realted issue. ora-600[17059]

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Database Alert Log file:


Sat Jan 23 20:21:53 2010
Errors in file /orasys/ipay/udump/ipay_ora_12022.trc:
ORA-07445: exception encountered: core dump [kksParseChildCursor()+1180] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7FFF25C0] [] []
Sat Jan 23 20:24:43 2010
Errors in file /orasys/ipay/bdump/ipay_j000_11350.trc:
ORA-12012: error on auto execute of job 263
ORA-04030: out of process memory when trying to allocate 127512 bytes (QERHJ hash-joi,kllcqas:kllsltba)
ORA-06512: at "WTR.TRANSFER_INTERNET_WEB_PAYMENTS", line 17
ORA-06512: at line 1
Sat Jan 23 20:26:36 2010
Process startup failed, error stack:
Sat Jan 23 20:26:43 2010
Errors in file /orasys/ipay/bdump/ipay_psp0_2813.trc:
ORA-07445: exception encountered: core dump [_ndoprnt()+4] [SIGSEGV] [Address not mapped to object] [0xFFFFFFFF7FFF9D60] [] []
Sat Jan 23 20:26:53 2010
Errors in file /orasys/ipay/bdump/ipay_pmon_2811.trc:
ORA-00490: PSP process terminated with error
Sat Jan 23 20:26:53 2010
PMON: terminating instance due to error 490
Sat Jan 23 20:26:53 2010
Errors in file /orasys/ipay/bdump/ipay_lgwr_2825.trc:
ORA-00490: PSP process terminated with error
Sat Jan 23 20:26:53 2010
Errors in file /orasys/ipay/udump/ipay_ora_3185.trc:
ORA-00490: PSP process terminated with error
Sat Jan 23 20:26:53 2010
Error occured while spawning process J001; error = 490
Sat Jan 23 20:26:53 2010
Errors in file /orasys/ipay/bdump/ipay_cjq0_2833.trc:
ORA-00490: PSP process terminated with error
Sat Jan 23 20:26:59 2010
Instance terminated by PMON, pid = 2811


Trace files shows:


ERROR in TRACE FILE
----------------
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
*** 2010-02-01 04:31:47.660
Process startup failed, error stack:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
*** 2010-02-01 04:32:05.713
error 472 detected in background process
ORA-00472: PMON process terminated with error




Solution:
It is matching an  unpublished Bug 6471770
++ Set the following parameter _gby_hash_aggregation_enabled = false : -
SQL> alter system set "_gby_hash_aggregation_enabled"=false scope=both;

++ Also set the following event along with the above parameter, same time : -
SQL> alter system set events '4030 trace name errorstack level 3;name HEAPDUMP level 536870917';

Get Oracle Certifications for all Exams
Free Online Exams.com

R12: How to change the hostname/IP address of an Applications Tier using AutoConfig

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem Description: R12: How to change the hostname/IP address of an Applications Tier using AutoConfig




Solution:






1) Deregister the instance




first run the following sql:
select NAME, SERVER_TYPE from FND_APP_SERVERS;

Then run the following plsql using the info from the above sql:
exec FND_NET_SERVICES.remove_server('<SYSTEM_NAME'>, '<SERVER_NAME>');

# (The System name is the database name [select DB_NAME from FND_DATABASES;])

This plsql will need to be run twice to remove the apps & db server_type.
Then check the system has been deregistered by rerunning the first sql.




2) Stop all app services, db & lsnr




3) Change IP (ensure /etc/hosts has been updated)




4) Start db & lsnr



5) Run autoconfig on db, then apps tiers













References:




Interesting links around Autoconfig in the E-Business-Suite [ID 949160.1]
@Note 840828.1 - 'R12: How to change the hostname/IP address of an Applications Tier using AutoConfig'
@Note 840847.1 - 'R12: How to change the hostname and/or port of the Database Tier using AutoConfig'

Get Oracle Certifications for all Exams
Free Online Exams.com