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'

Oracle Community | Djay-OC | 4 years ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Informatica service crash infaservice.sh

    Oracle Community | 4 years ago | Djay-OC
    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'

    Root Cause Analysis

    1. 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()
    2. com.informatica.repository
      DDLGenRepositoryConfigurationManagerImpl.initializeConfiguration
      1. com.informatica.repository.persistence.database.DatabaseHandler.createConnection(DatabaseHandler.java:1069)
      2. com.informatica.repository.persistence.database.DatabaseHandler.<init>(DatabaseHandler.java:1018)
      3. com.informatica.repository.persistence.database.oracle.OracleHandler.<init>(OracleHandler.java:77)
      4. com.informatica.repository.persistence.database.DatabaseHandler.createInstance(DatabaseHandler.java:74)
      5. com.informatica.repository.persistence.database.DDLGenRepositoryConfigurationManagerImpl.initializeConfiguration(DDLGenRepositoryConfigurationManager.java:286)
      5 frames