Seen errors and fixes.
This document will outline recent database problems encountered and fixes or workaround.
Disclaimer: Apply to a TEST environment first. Use on production systems is at DBAs own risk.
Problem A):
ORA-07445: exception encountered.
Description of the problem:
alert log is displaying:
Fri Mar 20 15:39:03 2009
Errors in file /u11/app/testdb/9.2.0/admin/TEST_svr033/udump/test_ora_20719.trc:
ORA-07445: exception encountered: core dump [nsoexc()+184] [SIGBUS] [unknown code] [0x000000110] [] []
The trace file test_ora_20719.trc points to:
Exception signal: 10 (SIGBUS), code: 0 (unknown code), addr: 0×0000000000000110, PC: [0x4000000002b2bc70, nsoexc()+184]
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [nsoexc()+184] [SIGBUS] [unknown code] [0x000000110] [] []
And user’s session get the following error:
ORA-03113 end-of-file on communication channel
Cause:
This seems to be a bug with Oracle 9.2.0.7 and 9.2.0.8
Metalink note 409048.1:
This issue is due to Bug 4683638 ORA-7445[NSOEXC] RAISED FROM CTAS SQL
This is a known problem in the following versions of Oracle.
9.2.0.8.0
10.2.0.2.0
10.1.0.5.0
Workaround:
Metalink note 409048.1 describes a similar problem and suggests the following workaround:
ALTER SESSION SET “_COMPLEX_VIEW_MERGING”=FALSE;
Or use a hint for the SQL that is casuing this error:
select /*+ no_merge (v1) */
…
from tableT t1, viewV v1
where
…
;
End of problem A.
Disclaimer: Apply to a TEST environment first. Use on production systems is at DBAs own risk.
Problem B):
Checking swap space: 0 MB available, 1535 MB required. Failed.
Description of the problem:
While installing Oracle Lite 10g on Windows XP I am getting the following error regarding swap space:
Checking swap space: 0 MB available, 1535 MB required. Failed
To check swap space allocation on my XP desktop which is called Virtual Memory as follow:
Right click my computer àProperties àAdvanced Tab àPerformance section and click Settingsà Advanced Tab àVirtual Memory click Change I made sure that I had over 3000 MB of Virtual Memory.
If you do not have enough Virtual Memory then just re-adjust and restart your desktop.
But I am still getting this error from the Oracle installer, here is the full output of the error:
Starting Oracle Universal Installer…
Checking installer requirements…
Checking operating system version: must be 5.0, 5.1, 5.2 or 6.0 . Actual 5.1
Passed
Checking monitor: must be configured to display at least 256 colors . Actual
4294967296 Passed
Checking swap space: 0 MB available, 1535 MB required. Failed <<<<
Some requirement checks failed. You must fulfill these requirements before
continuing with the installation, at which time they will be rechecked.
Continue? (y/n) [n]
Workaround:
Even though I have enough Virtual Memory on my desktop I continue to get this error:
Checking swap space: 0 MB available, 1535 MB required. Failed
The workaround that I used was to disable the check for Virtual Memory as outlined here:
Navigate to where you have unziped the Oracle software. In my environment I have the Oracle Lite 10g in the foloowing area:
D:\Downloads\Oracle\Database\Lite\OLITE_10.3.0.2.0_Windows\OLITE_10.3.0.2.0_Windows\install
Save the current oraparam.ini and then edit oraparam.ini and do a Find (Ctrl F) and search for swap. There are several sections here each corresponding to a different OS. For my environment I comment out the line that says SWAP_SPACE=1535 under the Windows XP section by adding a # right before SWAP_SPACE=1535 as seem here:
#Windows XP use winver.exe to find version
[Windows-5.1-required]
#Minimum display colours for OUI to run
MIN_DISPLAY_COLORS=256
#SWAP_SPACE=1535
TEMP_SPACE=150
Then I re-run the installer by running Setup.exe and this time Oracle installer will not check for swap space and I get a successful install.
End of problem A.