本文主要是介绍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--
[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--
[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--
这篇关于Oracle Applications DBA 基础（第二期）Week 03 exercise的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
