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;
