JServer error after upgrade from 9.2.0.80 to 10.2.0.4.0
SID3Oct 8 2010 — edited Oct 8 2010Hi,
I see the following errors
SQL>
SQL> select dbms_java.full_ncomp_enabled from dual;
select dbms_java.full_ncomp_enabled from dual
*
ERROR at line 1:
ORA-00904: "DBMS_JAVA"."FULL_NCOMP_ENABLED": invalid identifier
SQL>
SQL> BEGIN
2 IF dbms_registry.is_valid('JAVAVM',dbms_registry.release_version) != 1 THEN
3 RAISE_APPLICATION_ERROR(-20000,
4 'JServer has not been correctly loaded into the database.');
5 END IF;
6 END;
7 /
BEGIN
*
ERROR at line 1:
ORA-20000: JServer has not been correctly loaded into the database.
ORA-06512: at line 3
SQL> @utlu102s.sql TEXT
.
Oracle Database 10.2 Upgrade Status Utility 10-08-2010 03:27:01
.
Component Status Version HH:MM:SS
Oracle Database Server INVALID 10.2.0.4.0 00:29:34
JServer JAVA Virtual Machine LOADING 9.2.0.4.0 00:00:18
Oracle Database Java Packages LOADING 9.2.0.4.0 00:00:00
Oracle Real Application Clusters INVALID 10.2.0.4.0 00:00:01
What could be the possible reason. This is a very small database of about 4 gb. I can always restore the database back to 9i and then do a fresh upgrade.
I am using manual upgrade method for this.
Previously i have used the same oracle 10g installtion directory or home to upgrade few other databases and never faced any such issue.
I am confused why this issue cropped up all of a sudden.
Please advice.
Thanks in advance.