|
数据库 与应用 分别用不同用户管理:
1,EBS 安装目录 /ora11510/oracle
2,
新增GROUP:
dba
在dba 组中新增两个用户
DB user: oravis
appl user: applvis
3,
修改 /home/oravis/.bash_profile
PATH变量加上 /ora11510/oracle/viscomn/admin/scripts/VIS_erp
再增加一行:
. /ora111510/oracle/visappl/APPSORA.env
修改 /home/applvis/.bash_profile
PATH变量加上 /ora11510/oracle/visdb/9.2.0/appsutil/scripts/VIS_erp
再增加一行:
. /ora11510/oracle/visdb/9.2.0/VIS_erp.env
===========
服务的重启与关闭:
在停止服务器的时候,要先停止应用程序,后停数据库
停止应用:
su - applvis
sh /ora11510/oracle/viscomn/admin/scripts/VIS_erp/adstpall.sh apps/apps
或
sh adstpall.sh apps/apps
停止数据库:
su - oravis
sh /ora11510/oracle/visdb/9.2.0/appsutil/scripts/VIS_erp/addlnctl.sh stop VIS
sh /ora11510/oracle/visdb/9.2.0/appsutil/scripts/VIS_erp/addbctl.sh stop immedia
或
sh addlnctl.sh stop VIS
sh addbctl.sh stop immedia
启动的时候,先启动数据库,再启动服务
启动数据库:
su - oravis
sh /ora11510/oracle/visdb/9.2.0/appsutil/scripts/VIS_erp/addbctl.sh start
sh /ora11510/oracle/visdb/9.2.0/appsutil/scripts/VIS_erp/addlnctl.sh start VIS
或
sh addbctl.sh start
sh addlnctl.sh start VIS
启动应用:
su - applvis
sh /ora11510/oracle/viscomn/admin/scripts/VIS_erp/adstrtal.sh apps/apps
或
sh adstrtal.sh apps/apps
====== |
|