[b]To unlock account[/b]:
[b]Error when unlock account[/b]
[quote]
[oracle@ox8 ~]$ oidpasswd connect=OIDDB unlock_su_acct=true
OID DB user password:
[gsldpp_GetDBInstName] ORA-942 ORA-00942: table or view does not exist
encountered
ERROR * gsldpuUnlockSuAccount: Gettinf SID from DB failed
Error in unlocking OID super user account.
[/quote]
Problem: ODS privileges lack
Solve:
Role: connect, resources, select_catalog_role
System Privileges:Create Library, create synonym,create table,create trigger,unlimited tablespace
[oracle@ox8 ~]$ source oid.env
Env variables for OID have been set !
[oracle@ox8 ~]$ vim oid.env
[oracle@ox8 ~]$ oidpasswd connect=idm unlock_su_acct=true
OID DB user password:
OID super user account unlocked successfully.
[b]Error when unlock account[/b]
[quote]
[oracle@ox8 ~]$ oidpasswd connect=OIDDB unlock_su_acct=true
OID DB user password:
[gsldpp_GetDBInstName] ORA-942 ORA-00942: table or view does not exist
encountered
ERROR * gsldpuUnlockSuAccount: Gettinf SID from DB failed
Error in unlocking OID super user account.
[/quote]
Problem: ODS privileges lack
Solve:
Role: connect, resources, select_catalog_role
System Privileges:Create Library, create synonym,create table,create trigger,unlimited tablespace