博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
<<Oracle Applications DBA 基础(第二期)>>Week 03 exercise
阅读量:4178 次
发布时间:2019-05-26

本文共 5967 字,大约阅读时间需要 19 分钟。

1. 安装后, 怎么看有那些 product 安装了和有licence?(hint: script 在 $AD_TOP/sql/ )

[applvis@oel57vis sql]$ pwd

/u01/apps/apps_st/appl/ad/12.0.0/sql
[applvis@oel57vis sql]$ ls adlicmgr.sql
adlicmgr.sql
[applvis@oel57vis sql]$ sqlplus apps/apps @adlicmgr.sql
SQL*Plus: Release 10.1.0.5.0 - Production on Sat Feb 22 23:49:40 2014
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Enter value for 1: apps/apps
Enter value for 2: adlicmgr22feb.out
Enter value for 3: GET_PROD_INFO
Enter value for 4:
Enter value for 5:
Connected.
INSTALLED_PRODUCTS=0,1,3,101,140,160,168,170,172,174,175,177,178,185,186,190,191
,200,201,202,203,204,205,206,207,210,222,230,231,235,240,242,250,260,265,266,271
,274,275,278,279,280,283,298,385,388,390,396,401,405,410,426,429,430,431,432,435
,438,440,450,45
1,452,453,454,455,505,506,507,508,510,511,512,513,515,517,518,519,521,522,523,52
4,530,534,535,539,540,542,544,545,549,550,551,552,553,554,555,556,557,558,560,60
0,601,602,603,660,661,662,663,665,666,667,671,672,673,674,676,677,680,682,690,69
1,692,693,694,6
95,696,697,698,699,701,702,703,704,705,706,708,709,712,714,716,718,722,723,724,7
26,777,778,800,801,804,805,808,809,810,821,862,866,867,868,869,870,873,874,875,8
79,880,881,883,1292,7000,7002,7003,7004,8301,8302,8303,8400,8401,8402,8403,8404,
8405,8406,8407,
8450,8724,8727,8901,9000,9001,9003,9004
SHARED_PRODUCTS=50,60,300,520,689,700,802,803,8721,8722,8723,8731
TERRITORIES=AR,AT,AT,AU,BE,BO,BR,CA,CH,CL,CN,CO,CR,CZ,DE,DK,DO,EC,ES,FI,FR,GB,GB
,GR,GT,HN,HU,IL,IS,IT,JM,JP,KR,MX,NI,NL,NO,PA,PE,PL,PR,PT,PY,SE,SG,SV,TH,TR,TT,T
W,UY,VE
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[applvis@oel57vis sql]$ cat adlicmgr22feb.out
INSTALLED_PRODUCTS=0,1,3,101,140,160,168,170,172,174,175,177,178,185,186,190,191
,200,201,202,203,204,205,206,207,210,222,230,231,235,240,242,250,260,265,266,271
,274,275,278,279,280,283,298,385,388,390,396,401,405,410,426,429,430,431,432,435
,438,440,450,45                                                                 
1,452,453,454,455,505,506,507,508,510,511,512,513,515,517,518,519,521,522,523,52
4,530,534,535,539,540,542,544,545,549,550,551,552,553,554,555,556,557,558,560,60
0,601,602,603,660,661,662,663,665,666,667,671,672,673,674,676,677,680,682,690,69
1,692,693,694,6                                                                 
95,696,697,698,699,701,702,703,704,705,706,708,709,712,714,716,718,722,723,724,7
26,777,778,800,801,804,805,808,809,810,821,862,866,867,868,869,870,873,874,875,8
79,880,881,883,1292,7000,7002,7003,7004,8301,8302,8303,8400,8401,8402,8403,8404,
8405,8406,8407,                                                                 
8450,8724,8727,8901,9000,9001,9003,9004                                         
SHARED_PRODUCTS=50,60,300,520,689,700,802,803,8721,8722,8723,8731               
TERRITORIES=AR,AT,AT,AU,BE,BO,BR,CA,CH,CL,CN,CO,CR,CZ,DE,DK,DO,EC,ES,FI,FR,GB,GB
,GR,GT,HN,HU,IL,IS,IT,JM,JP,KR,MX,NI,NL,NO,PA,PE,PL,PR,PT,PY,SE,SG,SV,TH,TR,TT,T
W,UY,VE                                                                         
[applvis@oel57vis sql]$
--EOF--

2. 怎样看 FORMS service 是运行在 servlet mode 还是在 socket mode ?(hint: script 在$ADMIN_SCRIPTS_HOME)

[applvis@oel57vis sql]$ cd $ADMIN_SCRIPTS_HOME

[applvis@oel57vis scripts]$ ls
adalnctl.sh   adcmctl.sh     adformsrvctl.sh  adopmnctl.sh   adstrtal.sh  java.sh      mwactl.sh
adapcctl.sh   adexecsql.pl   adoacorectl.sh   adpreclone.pl  gsmstart.sh  jtffmctl.sh  mwactlwrpr.sh
adautocfg.sh  adformsctl.sh  adoafmctl.sh     adstpall.sh    ieo          msc
[applvis@oel57vis scripts]$ ./adformsctl.sh status apps/apps
You are running adformsctl.sh  version 120.16
Checking status of OPMN managed FORMS OC4J instance ...
Processes in Instance: VIS_oel57vis.oel57vis.example.com
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status  
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group          | OC4J:oafm          |   13886 | Alive   
OC4JGroup:default_group          | OC4J:forms         |   13812 | Alive   
OC4JGroup:default_group          | OC4J:oacore        |   13724 | Alive   
HTTP_Server                      | HTTP_Server        |   13665 | Alive   
adformsctl.sh: exiting with status 0
adformsctl.sh: check the logfile /u02/inst/apps/VIS_oel57vis/logs/appl/admin/log/adformsctl.txt for more information ...  
[applvis@oel57vis scripts]$ ./adformsrvctl.sh status apps/apps
You are running adformsrvctl.sh  version 120.15.12010000.2
Forms Connect Mode is set to Servlet. Please Change Forms Mode to socket and then run this script.
adformsrvctl.sh: exiting with status 1
[applvis@oel57vis scripts]$

--EOF--

3. 参考PPT 上的启动 database script , 写一对应 app tier 的 startup script , 运行这个script 就可以 启动 整个 app tier 。

[applvis@oel57vis ~]$ cat startapp.sh

. /u01/apps/apps_st/appl/APPSVIS_oel57vis.env
$ADMIN_SCRIPTS_HOME/adstrtal.sh apps/apps
[applvis@oel57vis ~]$ cat stopapp.sh
. /u01/apps/apps_st/appl/APPSVIS_oel57vis.env
$ADMIN_SCRIPTS_HOME/adstpall.sh apps/apps
[applvis@oel57vis ~]$ ls -l
total 8
-rwxr-xr-x 1 applvis dba 88 Feb 23 00:00 startapp.sh
-rwxr-xr-x 1 applvis dba 88 Feb 23 00:01 stopapp.sh
[applvis@oel57vis ~]$

--EOF--

4. (可选)安装 包含 二个节点的ORACLE Applications, 一个节点是数据库,一个节点是应用层。

已安装3节点非共享APPL_TOP的系统

[oravis@vis1 ~]$ grep HOSTNAMES $ORACLE_HOME/appsutil/conf_VIS.txt

HOSTNAMES={Server0_vis1,Server1_vis2,Server2_vis3}
  <config_pair oa_var="HOSTNAMES">{Server0_vis1,Server1_vis2,Server2_vis3}</config_pair>
[oravis@vis1 ~]$ sqlplus apps/apps
SQL*Plus: Release 11.1.0.7.0 - Production on Sun Feb 23 00:56:45 2014
Copyright (c) 1982, 2008, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select node_name,support_cp,support_forms,support_web,support_admin,support_db,status,node_mode from fnd_nodes order by node_name;
NODE_NAME               S S S S S S N
------------------------------ - - - - - - -
AP653APP               N N N N Y N O
AUTHENTICATION               N N N N N   O
VIS1                   N N N N Y Y O
VIS2                   Y Y Y Y N Y O
VIS3                   Y Y Y Y N Y O
SQL>
--EOF--

转载地址:http://awtai.baihongyu.com/

你可能感兴趣的文章
Hibernate的Entity cache(实体缓存)
查看>>
Hibernate中的Query cache(查询缓存)
查看>>
Hibernate的interceptors与events
查看>>
TestNG概述
查看>>
TestNG中测试方法的依赖关系详解
查看>>
TestNG中的运行时测试实例工厂详解
查看>>
TestNG测试的并发执行详解
查看>>
TestNG的监听器概述
查看>>
TestNG的IAnnotationTransformer监听器详解
查看>>
TestNG的IMethodInterceptor监听器详解
查看>>
TestNG的IHookable监听器详解
查看>>
TestNG的IConfigurable监听器详解
查看>>
TestNG的IConfigurationListener监听器详解
查看>>
TestNG的IExecutionListener监听器详解
查看>>
TestNG的ISuiteListener监听器和IAlterSuiteListener监听器详解
查看>>
Maven的settings.xml文件结构之profiles
查看>>
在Suse Linux 11 SP4中启动eclipse时的Failed to load module "pk-gtk-module"异常
查看>>
Linux下的cURL工具概述
查看>>
Eclipse的UML建模插件Papyrus概述
查看>>
UML建模工具UMLet概述
查看>>