Login parameters not set in paramdb for database o.SID message during activation. (4257887)

Login parameters not set in paramdb for database o.SID message during activation.

Error received during the install and setup in RAC envirnoment at activation in the event log :

"Login parameters not set in paramdb for database o.SID
Can't set ORACLE_SID and ORACLE_HOME for database o.SID"

Incorrect configuration of TNS_ALIAS.

1. Verify that the TNSNAMES.ora file for the Shareplex TNS ALIAS entry to see if it is correct.

2. Verify that the env ORACLE_SID variable is pointing to the correct TNS ALIAS.

3. Check var/opt/oracle/oratab or etc/oratab file to make sure that the TNS ALIAS Entry is there.

4. Check the Paramdb file in SP_SYS_VARDIR/DATA directory for the SP_ORD_LOGIN_O.<YOUR_SID> and
SP_ORD_OWNER_O.<YOUR_SID> entry. If it is missing run ora_setup using TNS_ALIAS while entering the passwd for system and splex user.

Starting with SharePlex 8.6, the login credentials of SharePlex user are written to and stored in the file named connections.yaml located in /vardir/data subdirectory of SharePlex (where vardir refers to the Variable directory of SharePlex). Here is a sample entry: alvsupu07 # cat connections.yaml o.SYAM: password: 5787d4def4 user: SHA86 In the above, the first line has SID info. The second line has encrypted password and the third line has the name of the SharePlex user that makes connections to the database.