| Error while connecting with oci8 driver to default database: java.lang.NullPointerException [message #648519] |
Wed, 24 February 2016 09:12  |
evoradba
Messages: 144
Registered: April 2005
Location: Canada
|
Senior Member |
|
|
Hello
Im trying to load java into the database see below the command - this command works in oracle 11.2.3 no problem however in oracle 12 is a no go.
i have removed and reinstall java from the oracle instance as per note How to Reload the JVM in 12.1.0.x ( Doc ID 1612279.1 )
I have also run a few times utlrp.sql and still nothing, i dont know anymore what to do
loadjava -schema TEST directjava.jar
Error while connecting with oci8 driver to default database: java.lang.NullPointerException
exiting : could not open connection
Any help comments would be great
|
|
|
|
|
|
| Re: Error while connecting with oci8 driver to default database: java.lang.NullPointerException [message #648538 is a reply to message #648531] |
Wed, 24 February 2016 14:56  |
evoradba
Messages: 144
Registered: April 2005
Location: Canada
|
Senior Member |
|
|
Hi
the issue has been fix it was invalid objects in the database, here is what i did to fix it
sqlplus / as sysdba
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/utlrp.sql
@?/rdbms/admin/utlrp.sql
@?/rdbms/admin/utlrp.sql
>> The utlrp is meant to be executed few times in case there is any dependency that needs to be resolved.
Please login as sysdba and run the below commands, so the validation check in catnojav.sql will pass, so a complete JVM removal can proceed.
sqlplus / as sysdba
execute sys.dbms_registry.loaded('JAVAVM');
execute sys.dbms_registry.loaded('CATJAVA');
execute sys.dbms_registry.valid('JAVAVM');
execute sys.dbms_registry.valid('CATJAVA');
reload JVM using below note:
How to Reload the JVM in 12.1.0.x ( Doc ID 1612279.1 )
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
