Skip to main content

Featured

Missing Java Classes - Oracle Database

 Recently in out UAT database our DBA had found that the component JAVAVM (JServer JAVA Virtual Machine) is invalid, and hence he did the JVM reload. One thing he forgot was that the impact of JVM reload on existing JAVA objects in the database. Yes, all the java classes/objects got dropped due to the sudden JVM reload.   Ours is not a standalone database it has various applications running on top of using several java classes, and hence all our applications stopped working. So after a lot of trial and errors, we figured out the complete steps to fix our issue. Query to check the java objects in the database: select owner , count(*) from dba_objects where OBJECT_TYPE like '%JAVA%' group by owner;   Oracle EBusiness Suite Application - APPS                a)        Take a backup of $AD_TOP/admin/driver/adldjava.drv and replace all loadjava commands with below lines loadjava csf java...
1 comment
Read more

ORA-12154 TNS Error with Online and Offline RPDs and OBIEE Merge Issue

Application : 

Life Sciences DataHub 2.4.2 or later  and OBIEE 11.1.1.7

Issue:

  • Clicking on View Data in OBIEE RPD throws “TNS Could not resolve the connect identifier” error.
  • RPDs not getting merged, They are getting created but merging with the existing RPDs does not happen.
Root Cause:

1. The first issue was due to the TNS_ADMIN Environment Variable was not set properly.
2. The second issue was due to the below:
  • The remote location was not configured properly.
  • Syntax mistakes in Obieedeploy.cmd and obieeinstall.cmd files
Resolution:

Issue 1:

1.       Set the TNS_ADMIN variable in the Environment variable section in the windows machine, where OBIEE Admin Tool is installed.

2.       Set the TNS_ADMIN in the setDomainEnv.sh script in the OBIEE Server.
 
Issue 2:

1.       The remote location must be configured in the below way to avoid Remote location related issues.

1.       Remote location name must be same as that of OBIEE Service Location name.

2.       The connection name and username for the connection must be “administrator” (The names are case sensitive)

3.       The password must be the Default RPD Password.

4.       Don’t update any passwords in obieeinstall.cmd or obieedeploy.cmd files in Admin tool server.

Comments

Post a Comment

Popular Posts