FIX EXP-00008: ORACLE error 604 encountered while exporting full database

if you had the below error (Error 1) while exporting full database
login as sys user and execute the following sql command at sqlplus prompt

GRANT EXECUTE ON sys.lt_export_pkg TO exp_full_database;

and if after running the above sql command and you got the an error (Error 2).
login as sys user and then execute the file
$ORACLE_HOME/rdbms/admin/owminst.plb to validated LT_EXPORT_PKG .
at sqlplus prompt
>@$ORACLE_HOME/rdbms/admin/owminst.plb
ie.
>@$D:\oracle\ora90\rdbms\admin\rdbms\admin\owminst.plb


Error 1
EXP-00008: ORACLE error 604 encountered
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 8
ORA-06550: line 1, column 13:
PLS-00201: identifier 'SYS.LT_EXPORT_PKG' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_i
nfo_exp

Error 2
EXP-00008: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.LT_EXPORT_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_exp

Read More

Oracle RAC Test on VMWare Linux + openfiler SAN/NAS storage

For some of you who don't want to spend much money on SAN storage just for the purpose of testing Oracle RAC feature.
One of the option you can do is install VMWare to set up Linux on it. And you need openfiler to act as SAN storage. for more information on how to do this you can drop in to http://www.oracledba.ca/ there are step by step + image guide for you.

Read More