Step By Step Installation of Informatica 30 min

---

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

  Speak Your Mind Cancel reply

  Post Comment

  ---

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

  Speak Your Mind Cancel reply

  Post Comment

  ---