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...

Disable HTTPS for Informatica Admin url after installation

 One of the common problem faced by informatica administrators is to disable https for informatica admin console.
 
The solution is very simple with the infasetup.sh command.
 
Here you go!!!
 
Steps:
 
Before executing the below, you should be aware of both the http port and https port. Make sure both the ports are open in the firewall.

1. Take backup of $INFA_HOME/isp/config/nodemeta.xml file
2. Shutdown Informatica services
3. Take backup of $INFA_HOME/tomcat directory

Note: Do not copy or rename any of the below directories
4. cd $INFA_HOME /tomcat/webapps
5. rm -rf coreservices ROOT adminconsole csm
6. cd $INFA_HOME /tomcat/
7. rm -rf temp/* work/*
8. cd $INFA_HOME/server
9. ./infasetup.sh updategatewaynode -hs 0     --> This command should run successfully and this does the trick :)
10. Startup Informatica
11. Validate the url using the http port.

Comments

  1. awesome post presented by you..your writing style is fabulous and keep update with your blogs Informatica Online Course

    ReplyDelete
  2. Thank you so much for sharing this. I appreciate your efforts on making this collection

    Best Informatica Training in Chennai

    Informatica Training center Chennai

    ReplyDelete

Post a Comment

Popular Posts