I'm having problems trying to run a full export.
We had several components into the database (JAVA,XDB and XML) then the last Wednesday I bounced the data base, stop all our application processes, crons, ... an then startup the database and run all the steps to uninstall and install the components again. During the process I had a problem running the script '?/javavm/install/initjvm.sql'.
The steps I followed were:
1.- Bounce the database
2.- Drop user XDB and tablespace XDB by connecting to SYS and running the following SQL script:
@?/rdbms/admin/catnoqm.sql
3.- ALTER TABLESPACE XDB offline;
4.- DROP TABLESPACE XDB including contents;
5.- rm /ORADATA/DATA2/DATA/xdb01.dbf
6.-Re-create tablespace XDB.
CREATE TABLESPACE XDB
DATAFILE '/ORADATA/DATA2/DATA/xdb01.dbf' SIZE 100M
AUTOEXTEND OFF
LOGGING ONLINE
PERMANENT EXTENT
MANAGEMENT LOCAL
AUTOALLOCATE BLOCKSIZE 4K
SEGMENT SPACE MANAGEMENT AUTO;
7.- To install Java, XML and XDB we have to run the following scripts (Connected as SYS):
@?/javavm/install/rmjvm.sql
@?/javavm/install/initjvm.sql;
@?/rdbms/admin/catqm.sql change_on_install XDB TEMP
Reconnect to SYS again and run the following (Load xdb java library):
@?/rdbms/admin/catxdbj.sql
@?/xdk/admin/initxml.sql;
@?/xdk/admin/xmlja.sql;
@?/rdbms/admin/catjava.sql;
@?/rdbms/admin/catexf.sql;
alter user xdb identified by values 'FD6C945857807E3C';
@?/rdbms/admin/catalog.sql;
@?/rdbms/admin/catblock.sql;
@?/rdbms/admin/catproc.sql;
@?/rdbms/admin/catoctk.sql;
@?/rdbms/admin/owminst.plb;
@?/sqlplus/admin/pupbld.sql;
@?/sqlplus/admin/help/hlpbld.sql
@?/rdbms/admin/utlrp.sql
connected as sys
execute sys.dbms_registry.loaded('JAVAVM');
execute sys.dbms_registry.loaded('CATJAVA');
execute sys.dbms_registry.valid('JAVAVM');
execute sys.dbms_registry.valid('CATJAVA');
Running the script I mentioned before '?/javavm/install/initjvm.sql' I had an read error from a SYSTEM tablespace file and obviously the Java VM wasn't installed properly and I'm having the following error.
I only have database full export from the last Wednesday before the intervention and I would like to resolve the problem with the system tablespace file, then install the JAVAVM and resolve the export problem.
I have read I can uninstall the JAVAVM and run the full export but I think it will be really important to resolve the issue with the file. I never have done that before. Please could you help me. The database version is Oracle 9i (9.2.0.6.0), Operating system version UNIX AIX 5.2.
EXP-00008: ORACLE error 29516 encountered
ORA-29516: Aurora assertion failure: Assertion failure at joevm.c:3129 Unable to locate well known object: 22
DBV-00102: File I/O error on FILE (/ORADATA/DATA/system_01.dbf) during verification read operation (-2)
Please I really need some help. I think if uninstalling the JAVAVM will fix the export problem I could do that firs.
Thank you so much. I'm looking forward to hearing from you soon.
Vinny.