In one of our environment Informatica service infaservice.sh is crashing. It was working earlier since installation and in last few days when we are starting its just crashing in 10/15 seconds
Below are the excerpt from catalina.out
-------------------------------------------
Cannot start node due to the error: [[RSVCSHARED_00014] The Repository Capability ['Persistence'] failed to initialize due to: '[DBPERSISTER_0009] Failed to connect to database with connection string 'jdbc:informatica:oracle://server1-scan.domain.name:1521;ServiceName=BIDB_STG;MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true' as user 'POW_DOM'']
Oct 22, 2013 1:12:11 AM com.informatica.repository.persistence.service.impl.PersistenceManagerImpl initialize
SEVERE: Unable to initialize persistence component due to: [DBPERSISTER_0009] Failed to connect to database with connection string 'jdbc:informatica:oracle://server1-scan.domain.name:1521;ServiceName=BIDB_STG;MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true' as user 'POW_DOM'
com.informatica.repository.persistence.PersistenceInitializationException: [DBPERSISTER_0009] Failed to connect to database with connection string 'jdbc:informatica:oracle://server1-scan.domain.name:1521;ServiceName=BIDB_STG;MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true' as user 'POW_DOM'
at com.informatica.repository.persistence.database.DatabaseHandler.createConnection(DatabaseHandler.java:1069)
at com.informatica.repository.persistence.database.DatabaseHandler.<init>(DatabaseHandler.java:1018)
at com.informatica.repository.persistence.database.oracle.OracleHandler.<init>(OracleHandler.java:77)
at com.informatica.repository.persistence.database.DatabaseHandler.createInstance(DatabaseHandler.java:74)
at com.informatica.repository.persistence.database.DDLGenRepositoryConfigurationManagerImpl.initializeConfiguration(DDLGenRepositoryConfigurationManager.java:286)
------------------------------------------
As per the log its not able to connect to POW_DOM.
But we are able to connect user using service name also
---------------------------------------------------
tnsping BIDB_STG
TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 22-OCT-2013 01:58:02
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
/u05/bidb/11.2.0/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(COMMUNITY = domain.name)(PROTOCOL=tcp)(HOST=server1-scan)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=BIDB_STG) (INSTANCE_NAME=STGBI1)))
OK (30 msec)
-------------------------------------------------
sqlplus POW_DOM/******@BIDB_STG
SQL*Plus: Release 11.2.0.2.0 Production on Tue Oct 22 02:00:31 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> SHOW USER
USER is "POW_DOM"
------------------------------------------------
Our Env is Database 2 node rac on RHEL 5 64bit.
Not able to figure out anything. Please help me in troubleshoot the issue.
Regards,
Djay