Pritam
can we create user and password using Microsoft SQL SERVER instead of oracle and how
Reply
Mudiliraju
Nice madam
Reply
anandhi
hi,
installed informatica server as per the video, but I couldnot open informatica Administrator home page, getting error like "NET::ERR_CERT_AUTHORITY_INVALID", given password 411 as same as given in the video...plz help to resolve the issue to make successful installation.
Thanks and Regards,
Anandhi.
Reply
Anita H.K
I have installed the Informatica server and client by seeing the above video. After installation, immediately I was able to connect to the Admin console page and was able to login. but next time I tried to load the admin console page it is giving me following error.
Hmmm… can't reach this pagedesktop-1jqko7j refused to connect.
Try:
Search the web for desktop-1jqko7j
Catalina.out contents:
May 15, 2022 7:19:27 AM com.informatica.repository.persistence.service.impl.PersistenceManagerImpl initialize
SEVERE: Unable to initialize persistence component due to: [PERSISTENCEAPI_0307] [DBPERSISTER_0009] Failed to connect to the database with JDBC connection string 'jdbc:informatica:oracle://localhost:56296;ServiceName=orcl_XPT;MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true' as user 'info_domain.' Verify that the connection string and user name are valid. This was caused by [informatica][Oracle JDBC Driver]Error establishing socket to host and port: localhost:56296. Reason: Connection refused: connect
com.informatica.repository.persistence.PersistenceInitializationException: [PERSISTENCEAPI_0307] [DBPERSISTER_0009] Failed to connect to the database with JDBC connection string 'jdbc:informatica:oracle://localhost:56296;ServiceName=orcl_XPT;MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true' as user 'info_domain.' Verify that the connection string and user name are valid. This was caused by [informatica][Oracle JDBC Driver]Error establishing socket to host and port: localhost:56296. Reason: Connection refused: connect
at com.informatica.repository.persistence.database.DatabaseHandler.createConnection(DatabaseHandler.java:1129)
at com.informatica.repository.persistence.database.DatabaseHandler.(DatabaseHandler.java:1032)
at com.informatica.repository.persistence.database.oracle.OracleHandler.(OracleHandler.java:94)
at com.informatica.repository.persistence.database.DatabaseHandler.createInstance(DatabaseHandler.java:97)
at com.informatica.repository.persistence.database.DDLGenRepositoryConfigurationManagerImpl.initializeConfiguration(DDLGenRepositoryConfigurationManager.java:320)
at com.informatica.repository.persistence.database.DDLGenRepositoryConfigurationManagerImpl.(DDLGenRepositoryConfigurationManager.java:304)
at com.informatica.repository.persistence.database.DatabaseRepositoryHandler.(DatabaseRepositoryHandler.java:127)
at com.informatica.repository.persistence.database.DatabasePersister.createRepositoryHandler(DatabasePersister.java:56)
at com.informatica.repository.persistence.service.impl.AbstractPersister.initialize(AbstractPersister.java:102)
at com.informatica.repository.persistence.service.impl.PersistenceManagerImpl.initialize(PersistenceManagerImpl.java:96)
at com.informatica.repository.persistence.service.impl.PersistenceManagerImpl.initialize(PersistenceManagerImpl.java:67)
at com.informatica.repository.service.capability.impl.persistence.PersistenceCapabilityManagerImpl.init(PersistenceCapabilityManagerImpl.java:132)
at com.informatica.repository.service.impl.RepositoryServiceManagerImpl.initPersistence(RepositoryServiceManagerImpl.java:1093)
at com.informatica.repository.service.impl.RepositoryServiceManagerImpl.initService(RepositoryServiceManagerImpl.java:245)
at com.informatica.repository.deployer.embedded.EmbeddedRepositoryConnectionFactory.initializeRepositorySvc(EmbeddedRepositoryConnectionFactory.java:518)
at com.informatica.repository.deployer.embedded.EmbeddedRepositoryConnectionFactory.connect(EmbeddedRepositoryConnectionFactory.java:182)
at com.informatica.project.repository.deployer.common.SetupEmbeddedJRS.getEmbeddedJRSInstance(SetupEmbeddedJRS.java:97)
at com.informatica.project.repository.deployer.embedded.EmbeddedConnectionFactory.initializeProjectRepoSvc(EmbeddedConnectionFactory.java:488)
at com.informatica.project.repository.deployer.embedded.EmbeddedConnectionFactory.connect(EmbeddedConnectionFactory.java:177)
at com.informatica.isp.domainrepositoryservice.impl.PRSDomainRepositoryServiceImpl.initImpl(PRSDomainRepositoryServiceImpl.java:200)
at com.informatica.isp.domainrepositoryservice.impl.PRSDomainRepositoryServiceImpl.init(PRSDomainRepositoryServiceImpl.java:526)
at com.informatica.isp.tools.ispstarter.JSFStarter.init(JSFStarter.java:189)
at com.informatica.isp.tools.ispwebstarter.ISPWebStarterServlet.init(ISPWebStarterServlet.java:24)
at javax.servlet.GenericServlet.init(GenericServlet.java:158)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1284)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1197)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1087)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5210)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5493)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:1073)
at org.apache.catalina.startup.HostConfig$DeployWar.run(HostConfig.java:1857)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Caused by: com.informatica.repository.persistence.ExceptionSurrogate: java.sql.SQLNonTransientConnectionException: [informatica][Oracle JDBC Driver]Error establishing socket to host and port: localhost:56296. Reason: Connection refused: connect
at com.informatica.jdbc.oraclebase.ddcr.b(Unknown Source)
at com.informatica.jdbc.oraclebase.ddcr.a(Unknown Source)
at com.informatica.jdbc.oraclebase.ddcq.b(Unknown Source)
at com.informatica.jdbc.oraclebase.ddcq.a(Unknown Source)
at com.informatica.jdbc.oracle.OracleImplConnection.a(Unknown Source)
at com.informatica.jdbc.oracle.OracleImplConnection.ah(Unknown Source)
at com.informatica.jdbc.oracle.OracleImplConnection.b(Unknown Source)
at com.informatica.jdbc.oracle.OracleImplConnection.z(Unknown Source)
at com.informatica.jdbc.oraclebase.BaseConnection.b(Unknown Source)
at com.informatica.jdbc.oraclebase.BaseConnection.k(Unknown Source)
at com.informatica.jdbc.oraclebase.BaseConnection.a(Unknown Source)
at com.informatica.jdbc.oraclebase.BaseConnection.a(Unknown Source)
at com.informatica.jdbc.oraclebase.BaseDriver.connect(Unknown Source)
at com.informatica.repository.persistence.database.DatabaseHandler.openConnection(DatabaseHandler.java:1171)
at com.informatica.repository.persistence.database.DatabaseHandler.createConnection(DatabaseHandler.java:1118)
... 39 more
Cannot start node because of the following error: [[RSVCSHARED_00014] Internal error. The Repository Capability ['Persistence'] failed to initialize for the following reason: '[PERSISTENCEAPI_0307] [DBPERSISTER_0009] Failed to connect to the database with JDBC connection string 'jdbc:informatica:oracle://localhost:56296;ServiceName=orcl_XPT;MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true' as user 'info_domain.' Verify that the connection string and user name are valid. This was caused by [informatica][Oracle JDBC Driver]Error establishing socket to host and port: localhost:56296. Reason: Connection refused: connect'. Contact Informatica Global Customer Support.].
I have created an user account in SQL Plus - info_domain with dba priviliges
i start the informatica services before connecting to the console.
when i open the task manager i observe that informatica has either stopped or it starts and stops after sometime
Please help me in this regard
Reply
Swati
I have installed Oracle as per the video tutorial with latest version,
While creating the user from SQL Plus - > I am getting error as ORA-00922: missing or invalid option
- Then I tried with "alter session set "_ORACLE_SCRIPT"=true;"
- Then able to create the user
- But When I tried to connect in Informatica at 6th step, I am not able to connect with the Port number and Name which I created
- I have tried with "lsnrctl servicec" -> I got the following details -> Then I added name and password with Port: 49766 and XEXDB, xepdb1
But I am unable to connect, PLEASE HELP ME
LSNRCTL for 64-bit Windows: Version 18.0.0.0.0 - Production on 20-JUL-2021 17:12:08
Service "XE" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:5 refused:0 state:ready
LOCAL SERVER
Service "XEXDB" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:1 refused:0 current:0 max:1022 state:ready
DISPATCHER
(ADDRESS=(PROTOCOL=tcp)(HOST=DESKTOP-EOQK657)(PORT=49766))
Service "xepdb1" has 1 instance(s).
Instance "xe", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:5 refused:0 state:ready
LOCAL SERVER
The command completed successfully
Reply
Rakshith
Hi, I'm trying to install the Informatica server part but I have the same error you had while trying to connect to the database as shown in videos.
Reply
Javier H
Hi, I'm trying to install informatica but I have the same error you had while trying to connect to the data base. I'm using Oracle 18c express edition
Reply
Sandya
Hi,
After installing Informatica(server and client), how do I setup repository service, repository etc?
In this video, I do not see any further instructions on how to setup the informatica for first time use. I've tried to practice Extracting data using your video but I am lost and would appreciate your help on how to proceed further after the installation.
Reply
Sethu
Hi, Mam
How to create user info domain in sql server
Reply
Speak Your Mind