ORA-07445: Exception Encountered: Core Dump [Nstimexp()+28] [Sigsegv]
Problem Description
In the Oracle database alert log following error is encountered.
ORA-07445: exception encountered: core dump [nstimexp()+28] [SIGSEGV] [ADDR:0x58] [PC:0x107D6071C] [Address not mapped to object] []
In the trace file generated for this error inside the 'stack trace' portion the following function codes are listed.
nstimexp ltmdvp sslsstehdlr sighndlr call_user_handler longjmp dbgrip_start_iterat dbgrip_relation_iterator dbgruprac_read_adrc dbgrsc_set_createid
Cause of the Problem
The problem raised due to Oracle bug 6918493.
In 11g database, this is a reintroduction of Bug 2752985 which affected earlier versions of Oracle.
The silly thing is Bug 3934729 has been introduced on Oracle database 11.0.7 to manage this issue.
Solution of the Problem
To implement the solution, execute the following steps:
1. Set sqlnet.expire_time=0 in $ORACLE_HOME/network/admin/sqlnet.ora file on the server.
2. Restart the listener to ensure that these changes take effect.
$ lsnrctl stop
$ lsnrctl start
3. You can also check on Metalink to see if patch 6918493 is available yet.
4. For 11g, apply patch 3934729 if it is available for your OS.
In the Oracle database alert log following error is encountered.
ORA-07445: exception encountered: core dump [nstimexp()+28] [SIGSEGV] [ADDR:0x58] [PC:0x107D6071C] [Address not mapped to object] []
In the trace file generated for this error inside the 'stack trace' portion the following function codes are listed.
nstimexp ltmdvp sslsstehdlr sighndlr call_user_handler longjmp dbgrip_start_iterat dbgrip_relation_iterator dbgruprac_read_adrc dbgrsc_set_createid
Cause of the Problem
The problem raised due to Oracle bug 6918493.
In 11g database, this is a reintroduction of Bug 2752985 which affected earlier versions of Oracle.
The silly thing is Bug 3934729 has been introduced on Oracle database 11.0.7 to manage this issue.
Solution of the Problem
To implement the solution, execute the following steps:
1. Set sqlnet.expire_time=0 in $ORACLE_HOME/network/admin/sqlnet.ora file on the server.
2. Restart the listener to ensure that these changes take effect.
$ lsnrctl stop
$ lsnrctl start
3. You can also check on Metalink to see if patch 6918493 is available yet.
4. For 11g, apply patch 3934729 if it is available for your OS.
No comments:
Post a Comment