ORA-29540 Java Class does not exist
Hello,We have 2-nodes 11gR2 RAC/Win2k8. I've created a Java class/stored procedure after I connected to the DB using the below TNS entry
orcl =
(DESCRIPTION =
(LOAD_BALANCE = yes)
(ADDRESS = (PROTOCOL = TCP)(HOST = node1.domain)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = node2.domain)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = orcl)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 60)
(DELAY = 3)
)
)
)
I've noticed that this java class is available from one instance but unavailable from the other (ORA-29540 Java Class does not exist)
However, If I connect to the DB using the below TNS, the java class is available from both instances.
orcl1 =
0