Step By Step Installation of Informatica 30 min

In this tutorial video, We covered the step by step installation and configuration of PowerCenter Informatica, Server Installation, Client Installation.

QA Section

Speak Your Mind


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
  • ETL Trainer

    check this module -Backup, Restoration in Informatica. You will get all of them you are searching for

    Reply

Sethu

Hi, Mam How to create user info domain in sql server

Reply
  • ETL Trainer

    We don't need to create it in SQL Server. Hence it should be created in SQL run command line (oracle). The command for creating user is as follows: create user info_domain identified by password(your system's administrator password)

    Reply