Sometimes during installation of Informatica 9.0.1, at the Database connecting page, we might encounter an error like below
"The connection failed.Correct the database connection information and test the connection again"
One of the reasons can be due to the insufficient privileges to the User supplied in Database User Id.
To avoid such problems, while creation of a Database user for installation of Repository grant all privileges and Grant CONNECT and RESOURCE using below SQL.
>CREATE USER INFA IDIENTIFIED BY PASSWORD;
>GRANT CONNECT,RESOURCE TO INFA IDENTIFIED BY PASSWORD;
>GRANT ALL PRIVILEGES TO INFA;
"The connection failed.Correct the database connection information and test the connection again"
One of the reasons can be due to the insufficient privileges to the User supplied in Database User Id.
To avoid such problems, while creation of a Database user for installation of Repository grant all privileges and Grant CONNECT and RESOURCE using below SQL.
>CREATE USER INFA IDIENTIFIED BY PASSWORD;
>GRANT CONNECT,RESOURCE TO INFA IDENTIFIED BY PASSWORD;
>GRANT ALL PRIVILEGES TO INFA;
While Installing Informatica 9.1.0, I do get and error with a popup message "The Connection failed Correct the database connection information and test the connection again" Can any one help me how to solve this problem... Plz...
ReplyDeleteBefore installing i have turned off windows firewall and
Database userID: biaproddb(i have created a user named informatica with sqlplus and granted full acess)
Database address : praveen:1521(my computer name and port as default 1521)
Database service name : ORCL(as default)
https://www.facebook.com/photo.php?fbid=1399533873617789&set=o.258460627587765&type=1&ref=nf
Try to create SYSTEM DSN for orcl service with any database user credentials(biaproddb).
DeleteWhile connection test, you will see exact error which is stopping informatica service to connect to database.
From there debug and resolve that error, then application(Informatica service) can connect to oracle database.
Hi,
Deleteme also getting same problem could you pls guide me how to resolve this issue...
While Installing Informatica 9.6.1 I do get and error with a popup message "The Connection failed Correct the database connection information and test the connection again" Can any one help me how to solve this problem...
ReplyDeletei tried restarting server, turn off the windows firewal and enables 1433 port no for TCP but still the same error