-
Title
Unable to run ora_setup due to ORA-1031 -
Description
After upgrading from 4.5 to 5.3, ora_setup fails:
07/27/06 12:32 Notice: Oracle env - oq01dwdb01:/u01/app/oracle/product/10.2.0.2/db_2 [ora_setup(pdb)/20470]
07/27/06 12:32 Error: 12035 - OCISessionBegin failed with ORA-1017. [ora_setup(osp)/20470]
07/27/06 12:32 Error: 12035 - OCISessionBegin failed with ORA-1031. [ora_setup(osp)/20470]
07/27/06 12:33 Notice: Oracle version 102 [ora_setup(osp)/20470]
07/27/06 12:34 Parameter was changed SP_ORD_LOGIN_O.OQ01DWDB01 579fd983ba7c57bfca435a2b98de0fdb07f82b3af45c3c3abe3bbbf3ccd9f2 579fd983ba7c57bfca435a2b98de0fdb07f82b3af45c3c3abe -
Cause
Group or permission issue.
-
Resolution
1. Run newgrp DBA to switch primary user group to DBA for the owner of shareplex binary. The newgrp utility creates a new shell execution environment with a new real and effective group identification
UNIX: newgrp DBA
UNIX: id
It should show the effective group for this user is now DBA.
2. Run ora_setup from the proddir/bin directory
./ora_setup