`
xw302
  • 浏览: 123330 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

Oracle OID 使用总结

阅读更多
To unlock account:
[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.



Error when unlock account
引用

[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.


Problem: ODS privileges lack
Solve:
Role: connect, resources, select_catalog_role
System Privileges:Create Library, create synonym,create table,create trigger,unlimited tablespace


分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics