Database Administration (MOSC)

MOSC Banner

ORA-29540 Java Class does not exist

edited May 7, 2017 5:00AM in Database Administration (MOSC) 1 commentAnswered
 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 =

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center