<<Oracle Applications DBA 基础（第二期）>>Week 03 exercise

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--