1.环境说明
192.168.56.150 hostname为node01
192.168.56.151 hostname为node02
需要从node01服务器dblink到node02服务器
2.给hbhe用户授权
[oracle@node01:/ogg/dirchk]$ sqlplus / as sysdba
sys@CXMTDB 11:28:23> grant CREATE PUBLIC DATABASE LINK,DROP PUBLIC DATABASE LINK to hbhe;
Grant succeeded.
3.查看是否授权成功
[oracle@node01:/ogg/dirchk]$ sqlplus hbhe/wwwwww
sys@CXMTDB 11:30:23> set linesize 100
sys@CXMTDB 11:30:30> set pagesize 100
sys@CXMTDB 11:31:19> column username for a20;
sys@CXMTDB 11:31:19> column PRIVILEGE for a30;
hbhe@CXMTDB 11:49:18> select * from user_sys_privs where privilege like upper('%DATABASE LINK%');
USERNAME PRIVILEGE ADM COM INH
------------------------------ ------------------------------ --- --- ---
HBHE CREATE PUBLIC DATABASE LINK NO NO NO
HBHE DROP PUBLIC DATABASE LINK NO NO NO