Running Export Into Multiple Files Gives EXP-00008 ORA-600 [Xsoptloc2]
(Doc ID 300849.1)
Last updated on FEBRUARY 02, 2022
Applies to:
Oracle OLAP - Version 10.2.0.4 and laterInformation in this document applies to any platform.
Archived
Symptoms
Running an export statement such as the following:
exp system/systempassword@sid full=yes log=c:\logfile.log filesize=1GB file=exp1.dmp, exp2.dmp
on a 9.2.0.5 Enterprise Edition with the OLAP option installed (Windows 2003) returns the following errors in the export log (logfile.log):
EXP-00008: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [xsoptloc2], [4], [4], [0], [], [], [], []
ORA-06512: in "SYS.DBMS_AW", line 347
ORA-06512: in "SYS.DBMS_AW", line 470
ORA-06512: in "SYS.DBMS_AW_EXP", line 270
ORA-06512: in line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_AW_EXP.schema_info_exp
The following was checked in SQL*Plus:
sqlplus '/ as sysdba'
SQL> select comp_name, version, status from dba_registry;
COMP_NAME | VERSION | STATUS |
... | ... | ... |
OLAP Analytic Workspace | 9.2.0.1 | VALID |
Oracle OLAP API | 9.2.0.1 | VALID |
.
.
.
As the 9.2.0.5 Enterprise Edition patchset was installed in this case, the SELECT statement should show 9.2.0.5 database options (see column 'VERSION'). But the SELECT statement shows only 9.2.0.1 database options.
Changes
RDBMS patchset 9.2.0.5 was applied to a 9.2.0.1 RDBMS instance.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |