Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Informatica powercenter 8.6.1 repository creation hang

424868Dec 1 2010 — edited Mar 17 2011

Hi everybody;

I installed Informatica PowerCenter 8.6.1 with hot fix 11 on a Windows 2003 server, the installation went ok, the domain was created in Oracle database 10g R2 with a character set as follow: NLS_CHARACTERSET AL32UTF8 and NLS_NCHAR_CHARACTERSET AL16UTF16. The database is hosted on a windows server 2003 machine.

The problem is with the repository service, it hangs during the creation. What I noticed is as follows:
The informatica server gets a connection to the database with the repository user info_rep which already has the DBA role.
The informatica server always hang after issuing an SQL statement for retrieving the nls_length_semantics parameter, it seems that the database returns the result to the informatica server but it hang for some reason.

Any idea about what is going on, and how to solve this problem?

Thank you all

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 14 2011

Added on Dec 1 2010

#business-intelligence-applications

8 comments

1,235 views