|
|
Running Export Into Multiple Files Gives EXP-00008 ORA-600 [Xsoptloc2] |
|
|
|
Note:300849.1 |
Type: |
PROBLEM |
|
|
Last Revision Date: |
09-MAR-2005 |
Status: |
MODERATED |
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review. |
The information in this document applies to:
Oracle OLAP - Version: 9.2.0.5
This problem can occur on any platform.
Errors
EXP-00008 "ORACLE error %lu encountered"
EXP-00083
ORA-00600 "internal error code, arguments: [%s],[%s],[%s], [%s], [%s],
ORA-06512 "at %sline %s"
Symptoms
Running an export statement such as the following:
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
9.2.0.5 RDBMS patchset Patch 3501955 was applied but the 'Postinstallation Procedures' of the patchset were not executed, this includes running multiple sql files (e.g. catpatch.sql) as described in the readme file of the patchset (see headline 'Postinstallation Procedures' ).
Fix
To implement the solution, please execute the following steps (as described in the 'Postinstallation Procedures' of Patch 3501955 ):
1. Set database parameters SHARED_POOL_SIZE and JAVA_POOL_SIZE to at least 150MB each.
2. Startup the RDBMS listener: lsnrctl start.
3. Run the 9.2.0.5 patch 'Postinstallation Procedures' sql files as described in the readme file of patchset Patch 3501955.
(This includes catpatch.sql . After catpatch.sql is executed check the patch.log file for 'ORA-' errors before running the other sql scripts.)
4. Run again:
sqlplus '/ as sysdba'
SQL> select comp_name, version, status from dba_registry;
Now the installed RDBMS options should show a version of 9.2.0.5.
After catpatch.sql is executed the problem should be solved.
References
Help us improve our service. Please email us your comments for this document. . | 
相关文章