OID E+ora_setup: Parameter SP_ORD_LOGIN_O.SID not found [ora_setup] [module pdb] (4243901)

OID E+ora_setup: Parameter SP_ORD_LOGIN_O.SID not found [ora_setup] [module pdb]

OID E+ora_setup: Parameter SP_ORD_LOGIN_O.SID not found [ora_setup] [module pdb]

check that you can read the paramdb file with the following string this ensures that the correct $SP_SYS_VARDIR is set

cat $SP_SYS_VARDIR/data/paramdb

ls -l $SP_SYS_VARDIR/data/paramdb

You should be able to read the paramdb file with the alias and the permissions should be the owner and primary group of the sharpelex unix user rw rw r  

If the line for OWNER and LOGIN are not in the file you can add them manually to the file the SID should be replaced with your SID case is upper case for this file.  You will need to change the two lines below to change the SID to your upper case sid and the OWNER line to your oracle splex user this should be in the same case as the oracle owner.  

rerun ora_setup

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.