T? ? ? ? ? ? ? ? ? ? ? ?
?ACCOUNT UNLOCK;? ? ? ? ? ? ? ? ? ? ? ?
?-2 Roles for orabbix? ? ? ? ? ? ? ?
?GRANT CONNECT TO orabbix;? ? ? ? ? ? ?
?GRANT RESOURCE TO orabbix;? ? ? ? ? ?
?ALTER USER orabbix DEFAULT ROLE ALL;?
?-3 System Privileges for orabbix? ?
?GRANT SELECT ANY TABLE TO orabbix;? ?
?GRANT CREATE SESSION TO orabbix;? ? ?
?GRANT SELECT ANY DICTIONARY TO orabbix;
?GRANT UNLIMITED TABLESPACE TO orabbix;
?GRANT SELECT ANY DICTIONARY TO orabbix;
?exec dbms_network_acl_admin.create_acl(acl => 'resolve.xml',description => 'resolve acl', principal =>'ORABBIX', is_grant => true, privilege => 'resolve');
?exec dbms_network_acl_admin.assign_acl(acl => 'resolve.xml', host =>'*');
?#### add below in orabbix config files ####
test_internal.Url=jdbc:oracle:thin:@10.127.xxxx.xx:1526:test_internal
test_internal.User=orabbix
test_internal.Password=orabbix
test_internal.QueryListFile=./conf/query.props
好了，脚本是准备好了，就等着方便工作了，短时间内配置几十个数据库实例都不是难题了，谁用谁知道。
|