biee发送预警

创建oracle数据库 名为S_NQ_SCHED(必须)的用户,再角色中给与RECOVERY_CATALOG-OWNER和RESOURCE的功能.(可以写SQL执行功能)

 在SQLPlus Worksheet中用S_NQ_SCHED的用户名和密码登录,执行C:/OracleBI/server/Schema中的SAACCT.Oracle.sql和SAJOBS.Oracle.sql(用来创建表格和用户表),

配置Job Manager,在Job Manager中的username为S_NQ_SCHED和password与S_NQ_SCHED匹配.在Job Manager中的General中的Administrator Password的密码暂时设为空(否则无法创建ibot).

启动Oracle BI Scheduler服务

把代码<CredentialStore>
<CredentialStorage type="file" path="c:/OracleBIData/web/config/credentialstore.xml"/>
<!-- other settings ... -->
</CredentialStore>加到C:/OracleBIData/web/config的instanceconfig.xml中

在DOS中执行cryptotools credstore -add -infile c:/OracleBIData/web/config/credentialstore.xml

格式如下>Credential Alias: admin
>Username: SchedulerAdmin
>Password: SchedulerAdmin
>Do you want to encrypt the password? y/n (y):
>Passphrase for encryption: secret
>Do you want to write the passphrase to the xml? y/n (n):
>File "OracleBIData_HOME/web/config/credentialstore.xml" exists. Do you want to
overwrite it? y/n (y):添加C:/OracleBIData/web/config的credentialstore.xml里的用户

用以创建ibot了,并且可以发送,用Job Manager查看创建的ibot和发送的信息.