This content has been marked as final. Show 7 replies
Looking at this error it seems as it is sometimes related to the permissions assigned to the database user account you are using to create the repository tables. Could you elaborate on the privileges that have been granted to this account? Also what is the connection string you are using to connect to your database?
-Ignacio de la Torre
I gave the user connect, resource, and dba authorities as it's the only thing I'm putting in the database. I didn't grant any other specific permissions
From the Windows 2003 server, I can connect to the database using sqlplus with the login infa_powercenter/infa_powercenter@TDEDEMO.
Here is the tnsnames.ora entry
(ADDRESS = (PROTOCOL = TCP)(HOST = tdess1)(PORT = 1521))
(SERVICE_NAME = TDEDEMO)
The connect string is the same as the connect string that I'm using in the Informatica install.
Thanks for the help!
I was getting another error due to the format that the service configuration for my repository database had on the tnsnames.ora file, check the format on the blog post below and let me know if that resolves your issue:
-Ignacio de la Torre
It's interesting as when I tried the new format, I get the following running a tnsping and I can't connect to sqlplus either. Here's the tnsping error I'm getting. I'm playing around with the tnsnames.ora file to see what might be missing or needed.
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION =
TNS-12533: TNS:illegal ADDRESS parameters
illegal ADDRESS parametersThis just means you misconfigured your tnsnames.ora - proven by the fact tnsping & sqlplus stopped working.
I ended up trying to put the tnsnames.ora entry all on one line, and tnsping worked. However, still the same error installing Informatica. Could Informatica be "caching" the tnsnames.ora file, and I need to re-start the install?It's unlikely that Informatica is caching tnsnames.ora, as it will make the call to the oracle client which in turn uses tnsnames.ora.
The error you're getting, "Database driver event...Error occurred loading library [pmora8.dll]", looks like a problem with your client installation and/or environment variables. If it were a problem on the database (eg username/pw) then you'd expect to get an ORA- error code and message, which you're not getting.
Have you googled for your error? this looks like a match:
Also try this: http://technet.informatica.com/search/node/Database+driver+event...Error+occurred+loading+library+%5Bpmora8.dll%5D
My configuration follows:
Oracle Database 11g R1.
Both running on Windows 2003 server.
Once you finish the Informatica installation process.
Go to your Services and look for the Informatica Orchestration Service, this service is trying to use the 8003 port, which at the same time is assigned to be the Shutdown port.
Once this service is located go to the properties and change the Startup Type to Manual, then stop the service.
Reboot your server.
Then go to Start/All Programs/Informatica PowerCenter/Services/PowerCenter Administration Console.
You should be able to open the Admin Console and create your Repositories and Interfaces.