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 | 3 years ago
  1. 0

    Informatica service crash infaservice.sh

    Oracle Community | 3 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'
  2. 0

    Unable to install informatica in windows 8

    Stack Overflow | 2 years ago | Sai
    com.informatica.repository.persistence.PersistenceInitializationException: [PERSISTENCEAPI_0307] [VIEWS_0014] Failed to create view 'MRI_MRSSCHEMATES33840' This was caused by [informatica][Oracle JDBC Driver][Oracle]ORA-01031: insufficient privileges</p> <pre><code>at com.informatica.repository.persistence.database.oracle.OracleHandler.createView(OracleHandler.java:599)
  3. 0

    Unable to install informatica in windows 8

    Stack Overflow | 2 years ago | Sai
    com.informatica.repository.persistence.PersistenceInitializationException: [PERSISTENCEAPI_0307] [VIEWS_0014] Failed to create view 'MRI_MRSSCHEMATES51593' This was caused by [informatica][Oracle JDBC Driver][Oracle]ORA-01031: insufficient privileges</p> <pre><code>at com.informatica.repository.persistence.database.oracle.OracleHandler.createView(OracleHandler.java:599)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    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