Oracle On Demand(OOD)项目中EBS打补丁的详细步骤

EBS patching steps in Oracle On Demand(OOD) projects


#check if patch applied & count of invalid objects, create invalids table & replace 7777777 with patch number
select name,user from v$database;
select BUG_NUMBER, LAST_UPDATE_DATE, success_flag from ad_bugs where bug_number=xxx;
create table apps.invalids_13jul12_7777777 as select * from dba_objects where status='INVALID';
select count(*) from dba_objects where status='INVALID';

#copy patch to stage area
cp /tmp/pxxx.zip /dxxx1i/applcsf

#unzip patch zip
unzip pxxx.zip

#check if all prerequisites meet, such as merge or prerequisite patch need
view readme


#switch user

pbrun impdba -u apdxxx1i


#list all available targets on host
/usr/local/git/bin/em-blackout-cmd -s

#list all active blackouts on host, if there's already active blackouts on specific instance, it means other people have already booked this time slot
/usr/local/git/bin/em-blackout-cmd -o list

#blackout APP node
/usr/local/git/bin/em-blackout-cmd -o start -t "DXXX1I" -r 2 -d <2h> -u <apdxxx1i> -c patch_num

#blackout DB node
 /usr/local/git/bin/em-blackout-cmd -o start -t full  -r 2 -d <2h> -u <ordxxx1i> -c patch_num

#stop all app service($ADMIN_SCRIPT_HOME), make sure no errors except timeout relative issue.

adstpall.sh apps/apps


#wait several minutes till all FNDLIBR process quit
ps -ef | grep FNDLIBR | grep dxxx1i


#enable maintence mode
adadmin

#cd patch directory & patch, logfile name format patchnum_13jul12.log
adpatch

#check log see if any errors, seach error
view patchnum_13jul12.log
/error


##check if patch applied & count of invalid objects, drop invalids table if no more invalids
select name,user from v$database;
select BUG_NUMBER, LAST_UPDATE_DATE, success_flag from ad_bugs where bug_number=xxx;
select object_name,object_type,owner,LAST_DDL_TIME from dba_objects where status='INVALID' and object_name||object_type||owner not in (select object_name||object_type||owner from apps.invalids_13jul12_7777777);
select count(*) from dba_objects where status='INVALID';
drop table apps.invalids_13jul12_7777777;


#disable maintence mode
adadmin

#start all app service($ADMIN_SCRIPT_HOME), make sure no errors except timeout relative issue.
adstrtal.sh apps/apps

#disable blackout(APP&DB)
#list all active blackouts on host
/usr/local/git/bin/em-blackout-cmd -o list
#Stop blackout
/usr/local/git/bin/em-blackout-cmd -o stop -n <blackout name from above command>


#health check

login instance from frontend, switch to Application Administrator responsibility, submit Active User request, check output.



  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Open OnDemand 是一个基于 Web 的平台,用于让用户轻松访问和使用 HPC 资源。以下是 Open OnDemand 的安装教程: 1. 安装必要的软件 Open OnDemand 需要 Ruby 2.5 或更高版本,以及 Passenger 和 Apache 或 Nginx 作为 Web 服务器。 对于 Ubuntu,可以使用以下命令安装所需的软件: ``` sudo apt-get update sudo apt-get install -y ruby ruby-dev libapache2-mod-passenger ``` 对于 CentOS 或 RHEL,可以使用以下命令安装所需的软件: ``` sudo yum update sudo yum install -y ruby ruby-devel epel-release sudo yum install -y nginx passenger ``` 2. 安装 Open OnDemand 可以从 Open OnDemand 的 GitHub 页面下载最新版本的 Open OnDemand。将下载的文件解压缩到 `/opt` 目录下: ``` sudo mkdir -p /opt cd /opt sudo wget https://github.com/OSC/Open-OnDemand/releases/download/v1.8.14/openondemand-1.8.14.tar.gz sudo tar -xzf openondemand-1.8.14.tar.gz ``` 3. 配置 Open OnDemand 进入 Open OnDemand 的安装目录并运行配置脚本: ``` cd /opt/openondemand-1.8.14 sudo ./configure ``` 该脚本将要求您输入以下信息: - Open OnDemand 的 URL(默认为 `/`) - HPC 群集的名称 - HPC 群集的登录节点的主机名 - SSH 端口(默认为 22) - 认证方式(密码或密钥) 配置完成后,运行以下命令以启动 Open OnDemand: ``` sudo ondemand start ``` 4. 配置 Web 服务器 如果您使用的是 Apache 作为 Web 服务器,您需要将以下内容添加到 Apache 的配置文件: ``` LoadModule passenger_module /usr/lib/apache2/modules/mod_passenger.so PassengerRoot /usr/lib/ruby/vendor_ruby/phusion_passenger/locations.ini PassengerDefaultRuby /usr/bin/ruby ``` 然后,在 Apache 的 VirtualHost 添加以下内容: ``` <VirtualHost *:80> ServerName yourservername.com DocumentRoot /var/www/ood/public <Directory /var/www/ood/public> Allow from all Options -MultiViews Require all granted </Directory> PassengerUserSwitching on </VirtualHost> ``` 如果您使用的是 Nginx 作为 Web 服务器,您需要将以下内容添加到 Nginx 的配置文件: ``` passenger_root /usr/lib/ruby/vendor_ruby/phusion_passenger/locations.ini; passenger_ruby /usr/bin/ruby; ``` 然后,在 Nginx 的 VirtualHost 添加以下内容: ``` server { listen 80; server_name yourservername.com; root /var/www/ood/public; passenger_enabled on; passenger_user_switching on; } ``` 5. 访问 Open OnDemand 现在,您可以在浏览器访问 Open OnDemand 的 URL,例如 `http://yourservername.com/`。您将看到 Open OnDemand 的登录界面,您可以使用 HPC 群集的用户名和密码登录。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值