怎样在Oracle ERP报表添加Excel查看方式
中国it实验室 【转载】 2009年03月25日 18:02
如何实现如上图在查看Oracle ERP报表时可以选择Microsoft Excel类型?很简单,作下面的设置就可以了。
用sysadmin登录Oracle ERP系统,选择Install -> Viewer Options,然后添加一条新记录。新纪录的File Format为”Text”,Mime Type为”application/vnd.ms-excel”,Description为”Microsoft Excel”,保存。
记在这里,作个备忘。
5. 设置主机参数
alter database force logging; |
主库强制归档
主机参数:
fal_client=bnetguard
fal_server=bnet
standby_file_management=auto
remote_login_passwordfile=exclusive |
备机参数:
db_file_name_convert
log_file_name_convert
standby_file_management='AUTO'
standby_archive_dest=/export/home/oracle/oradata/bnet/arch |
6.创建standby 数据库
orapwd
sqlplus "sys/oracle as sysdba"
startup nomount pfile='''
alter database mount standby database;
exit
rman target sys/oracle nocatalog
restore database |
7.设置自动归档
alter system set log_archive_dest_2='server=bnetguard reopen=200' |
8.启动Data Guard自动恢复状态
sqlplus "sys/oracle as sysdba"< recover managed standby database;
exit
EOF |
9.测试
alter system archive log current; |
二、维护:
使Standby 数据库处与 read-only状态
reover cancel/recover managed standby database cancel; |
取消恢复模式
alter database open read only; |
启动数据库到只读状态
recover standby database; |
使数据库切换到恢复模式
recover managed standby database time out 15; |
如果超过15分钟没有传日志
Restarting dead background process QMN0
"Restarting dead background process QMN" message can continually appear in the alert log during startup in RAC environment.
Workaround: Set aq_tm_processes=0 in the init.ora. It can be set to desired value through "alter system set aq_tm_processes=n" once the database is open completely.
alter database activate standby database; |
- 相关阅读:
- ·Oracle电子商务套件构建ERP系统应用案例
//server.zol.com.cn/196/1963741.html - ·solaris下-silent方式安装oracle client
//server.zol.com.cn/127/1273677.html - ·用Instant client批量安装Oracle客户端
//server.zol.com.cn/127/1273679.html - ·Oracle 10G安装笔记
//server.zol.com.cn/127/1273682.html - ·Solaris安装Oracle10g之 libCstd.so.1 问题解决
//server.zol.com.cn/127/1273683.html