Keystore Generation Failed in Informatica Server Installation

Sometimes during informatica server installation, the informatica installer fails to generate the keystore and will result in an error message as mentioned below

Keystore generation failed                       

To overcome this issue, we can generate the keystore manually. The steps to generate the keystore is as mentioned below :

1) Navigate to the folder where JAVA is installed in your system.

For example : C:\Program Files\Java\jdk1.7.0_21\jre\bin

Here you could find the key tool utility as shown in the screenshot below.

2)Go to Start --> cmd --> cd C:\Program Files\Java\jdk1.7.0_21\jre\bin

3)The command to generate the keystore file is as mentioned below

keytool -genkey -alias infkey -keyalg RSA -keysize 2048 -keystore infkey.keystore

4) Give a password for the keystore and fill in other details

NB : Give the host name of the system when it prompts you for your first name and last name

 

How to Unlock a user in Oracle DB

Check User is Locked

SELECT username, account_status FROM dba_users;

List of Locked Users

SELECT username,account_status,lock_date from dba_users where lock_date IS NOT NULL;

Unlock User

ALTER USER user_name IDENTIFIED BY password ACCOUNT UNLOCK;

Failed to create secure socket for OPMN at localhost:9501

Starting OPMN through EM fails (coreApplicaton ->Availability -> Startall)

OPMN fails with the following error in the adminserver.log

[2013-10-16T19:45:29.227-04:00] [AdminServer] [ERROR] [] [oracle.as.management.mbeans.opmn] [tid: OpmnProcessThread-status-46] [userId: <WLS Kernel>] [ecid: 54e490aa440fd7d3:53495834:141c3910d0a:-8000-00000000000000b1,0] [APP: NonJ2EEManagement] OPMN.queryProcessStatus failed with the following exception[[

oracle.as.management.opmn.optic.OpticBadConnectException: Failed to create secure socket for OPMN at hostname:9501

Cause

The processes were not started in the correct order

Once OPMN is started, EM is able to contact opmn, and request for a process to be started.
but if you try to do the same without opmn.exe running then you would get the error above
oracle.as.management.opmn.optic.OpticBadConnectException: Could not get secure socket for localhost  and port 9501

Solution

Start opmn.exe by the following

Start --> cmd --> opmnctl start

Then once OPMN is started, EM is able to contact opmn, and request for a process to be started.
but if you try to do the same .. without opmn.exe running then you would get the error that we are seeing now ...

So the conclusion is that you cannot start the BI processes thru EM if the OPMN process is not started .