所有由小潘发布的文章

喜欢分享的小潘.
原创程序、经验闲谈

Oracle EBS提交并发请求时取消“是否提交另一项请求” 提示

留下评论

        在提交并发请求的时候，系统会默认给出一个提示，如图所示：

                           

        但是有客户不希望出现这样的提示，直接点击提交即可，其实Oracle EBS系统内置了一个配置文件来控制此项，具体的并发请求名：

中文：并发：提交每个请求后显示请求摘要

英文：Concurrent: ShowRequests Summary After Each Request Submission

根据自己的项目需求，可将默认的值由“否”变更为“是”（地点层或用户层或职责层），即可取消此项提示。

系统层级

Oracle EBS R12.2版本更改apps密码

留下评论

Oracle ebs12版本中，12.1和12.2更改密码有比较大的变化，以下是12.2变更的操作系统层的命令，以下是官方文档：

R12.2: Steps to Change the APPS, APPLSYS, and APPS_NE Password Using FNDCPASS or AFPASSWD (文档 ID 1674462.1)

–具体命令如下

su – appldev
cd $INST_TOP/admin/scripts
./adstpall apps/apps;
[appldev@devfin scripts]$ FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS xxxxxx
Log filename : L510975.log


Report filename : O510975.out
[appldev@devfin scripts]$ cat L510975.log
+—————————————————————————+
Application Object Library: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

FNDCPASS: 
+—————————————————————————+

Current system time is 17-JAN-2018 10:29:36

+—————————————————————————+

Arguments
 
   FNDCPASS system/***** SYSTEM APPLSYS ***** 
+—————————————————————————-+
Working…

FNDCPASS completed successfully.

+—————————————————————————+
Concurrent request completed successfully
Current system time is 17-JAN-2018 10:29:37

+—————————————————————————+
[appldev@devfin scripts]$ ./adautocfg.sh
Enter the APPS user password:

The log file for this session is located at: /u01/DEV/app/fs1/inst/apps/DEV_devfin/admin/log/01171038/adconfig.log

AutoConfig is configuring the Applications environment…

AutoConfig will consider the custom templates if present.
        Using CONFIG_HOME location     : /u01/DEV/app/fs1/inst/apps/DEV_devfin
        Classpath                   : /u01/DEV/app/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/DEV/app/fs1/EBSapps/comn/java/classes

        Using Context file          : /u01/DEV/app/fs1/inst/apps/DEV_devfin/appl/admin/DEV_devfin.xml

Context Value Management will now update the Context file

        Updating Context file…COMPLETED

        Attempting upload of Context file and templates to database…COMPLETED

Configuring templates from all of the product tops…
        Configuring AD_TOP……..COMPLETED
        Configuring FND_TOP…….COMPLETED
        Configuring ICX_TOP…….COMPLETED
        Configuring MSC_TOP…….COMPLETED
        Configuring IEO_TOP…….COMPLETED
        Configuring BIS_TOP…….COMPLETED
        Configuring CZ_TOP……..COMPLETED
        Configuring SHT_TOP…….COMPLETED
        Configuring AMS_TOP…….COMPLETED
        Configuring CCT_TOP…….COMPLETED
        Configuring WSH_TOP…….COMPLETED
        Configuring CLN_TOP…….COMPLETED
        Configuring OKE_TOP…….COMPLETED
        Configuring OKL_TOP…….COMPLETED
        Configuring OKS_TOP…….COMPLETED
        Configuring CSF_TOP…….COMPLETED
        Configuring IBY_TOP…….COMPLETED
        Configuring JTF_TOP…….COMPLETED
        Configuring MWA_TOP…….COMPLETED
        Configuring CN_TOP……..COMPLETED
        Configuring CSI_TOP…….COMPLETED
        Configuring WIP_TOP…….COMPLETED
        Configuring CSE_TOP…….COMPLETED
        Configuring EAM_TOP…….COMPLETED
        Configuring GMF_TOP…….COMPLETED
        Configuring PON_TOP…….COMPLETED
        Configuring FTE_TOP…….COMPLETED
        Configuring ONT_TOP…….COMPLETED
        Configuring AR_TOP……..COMPLETED
        Configuring AHL_TOP…….COMPLETED
        Configuring IES_TOP…….COMPLETED
        Configuring OZF_TOP…….COMPLETED
        Configuring CSD_TOP…….COMPLETED
        Configuring IGC_TOP…….COMPLETED

AutoConfig completed successfully.

[appldev@devfin scripts]$ ./adadminsrvctl.sh start

You are running adadminsrvctl.sh version 120.10.12020000.10

Enter the WebLogic Admin password:
Enter the APPS Schema password:
Starting WLS Admin Server…
Refer /u01/DEV/app/fs1/inst/apps/DEV_devfin/logs/appl/admin/log/adadminsrvctl.txt for details

AdminServer logs are located at /u01/DEV/app/fs1/FMW_Home/user_projects/domains/EBS_domain_DEV/servers/AdminServer/logs

adadminsrvctl.sh: exiting with status 0

adadminsrvctl.sh: check the logfile /u01/DEV/app/fs1/inst/apps/DEV_devfin/logs/appl/admin/log/adadminsrvctl.txt for more information …  


[appldev@devfin scripts]$ grep wls_adminport $CONTEXT_FILE
         <wls_adminport oa_var="s_wls_adminport" oa_type="PORT" base="7001" step="1" range="-1" label="WLS Admin Server Port">7009</wls_adminport>

–上面步骤完成后，通过前台页面去进行WLS层级的配置

http://xxxxx:7009/console
a. Log in to WLS Administration Console.
b. Click Lock & Edit in Change Center.
c. In the Domain Structure tree, expand Services, then select Data Sources.
d. On the "Summary of JDBC Data Sources" page, select EBSDataSource.
e. On the "Settings for EBSDataSource" page, select the Connection Pool tab.
f. Enter the new password in the "Password" field.
g. Enter the new password in the "Confirm Password" field.
h. Click Save.
i. Click Activate Changes in Change Center.


[appldev@devfin scripts]$ ./adstrtal.sh apps/xxxxxx

EBS_GL_SQL

Oracle ebs 查看菜单展开项

留下评论

SELECT LPAD(' ', 6 * (LEVEL – 1)) || menu_entry.entry_sequence sequence,
       LPAD(' ', 6 * (LEVEL – 1)) || menu.user_menu_name SubMenu_Descrition,
       LPAD(' ', 6 * (LEVEL – 1)) || func.user_function_name Function_Description,
       menu.menu_id,
       func.function_id,
       menu_entry.grant_flag Grant_Flag,
       DECODE(menu_entry.sub_menu_id,
              null,
              'FUNCTION',
              DECODE(menu_entry.function_id, null, 'SUBMENU', 'BOTH')) Type
  FROM fnd_menu_entries      menu_entry,
       fnd_menus_vl          menu,
       fnd_form_functions_vl func
 WHERE 1 = 1
   AND menu_entry.sub_menu_id = menu.menu_id(+)
   AND menu_entry.function_id = func.function_id(+)
   AND grant_flag = 'Y'
 START WITH menu_entry.menu_id =
            (SELECT menu_id
               FROM fnd_menus_tl menu2
              WHERE menu2.user_menu_name = 'FIN_GL_MANAGER'–根据自己实际情况替换
                and menu2.language = 'ZHS')
CONNECT BY menu_entry.menu_id = PRIOR menu_entry.sub_menu_id
 ORDER SIBLINGS BY menu_entry.entry_sequence;
 

系统层级、经验闲谈

Oracle EBS如何追踪用户登录IP（Form层）

留下评论

说明：一般不建议开启登录审计，因为这会占用大量的系统资源。

以下操作都通过系统管理员职责进行操作。

1. 开启配置文件“登录：审计层”，根据需要是全局，还是用户层；

2. 启用并发管理器中“OAM Generic Collection Service:XXXX”,此服务默认不启动，直接在前台界面查询出来激活即可；

3. 通过以下命令查询，可以限制需要查询的用户的用户名等相关信息。

SELECT L.LOGIN_ID,
       L.USER_ID,
       L.START_TIME LOGIN_TIME,
       NVL(F.START_TIME, NVL(R.START_TIME, L.START_TIME)) FORM_TIME,
       USR.USER_NAME,
       RSP.RESPONSIBILITY_NAME,
       FRM.USER_FORM_NAME,
       (SELECT IPADDRESS
          FROM FND_OAM_FORMS_RTI OFRI
         WHERE 1 = 1
           AND (TO_CHAR(OFRI.PID) = NVL(SF.PROCESS, SR.PROCESS) OR
               NVL(SF.PROCESS, SR.PROCESS) =
               CONCAT(CONCAT(TO_CHAR(OFRI.PID), ':'),
                       TO_CHAR(OFRI.THREADID)))
           AND ROWNUM <= 1) IPADDRESS,
       R.RESP_APPL_ID,
       R.RESPONSIBILITY_ID,
       F.FORM_ID,
       F.FORM_APPL_ID,
       L.PID,
       L.PROCESS_SPID,
       DECODE(NVL(SF.SID, -999), -999, 'RESP_LEVEL', 'FORM_LEVEL') SESSION_LEVEL,
       NVL(F.AUDSID, R.AUDSID) AUDSID,
       NVL(SF.SID, SR.SID) SID,
       NVL(SF.SERIAL#, SR.SERIAL#) SERIAL#,
       NVL(SF.PROCESS, SR.PROCESS) PROCESS
  FROM FND_RESPONSIBILITY_TL      RSP,
       FND_FORM_TL                FRM,
       FND_USER                   USR,
       FND_LOGINS                 L,
       FND_LOGIN_RESP_FORMS       F,
       GV$SESSION                 SF,
       FND_LOGIN_RESPONSIBILITIES R,
       GV$SESSION                 SR
 WHERE 1 = 1
   AND L.LOGIN_ID = R.LOGIN_ID(+)
   AND R.LOGIN_ID = F.LOGIN_ID(+)
   AND R.LOGIN_RESP_ID = F.LOGIN_RESP_ID(+)
   AND L.LOGIN_TYPE = 'FORM'
   AND L.USER_ID = USR.USER_ID
   AND R.RESPONSIBILITY_ID = RSP.RESPONSIBILITY_ID(+)
   AND R.RESP_APPL_ID = RSP.APPLICATION_ID(+)
   AND RSP.LANGUAGE(+) = USERENV('LANG')
   AND F.FORM_ID = FRM.FORM_ID(+)
   AND F.FORM_APPL_ID = FRM.APPLICATION_ID(+)
   AND FRM.LANGUAGE(+) = USERENV('LANG')
   AND F.AUDSID = SF.AUDSID(+)
   AND R.AUDSID = SR.AUDSID(+) — AND L.LOGIN_ID = :P_LOGIN_ID

4. 根据得出的"PROCESS",通过应用用户去操作系统相应目录查询相关IP信息，如下命令：

cd $FORMS_TRACE_DIR

可以看到系统生成了相应PROCESS名字的rti文件，如下图所示(可通过log文件进去查相应PROCESS对应的IP)：

同时可以找到em_86653.rti文件，然后cat该文件的内容，如下图所示：

至此可以查询出登录用户登录form的相应IP信息。

参考：https://www.cnblogs.com/quanweiru/p/8570732.html

          https://blog.csdn.net/mchdba/article/details/45749131

          https://www.cnblogs.com/hopedba/p/5895106.html

          https://bbs.csdn.net/topics/10450699

          https://blog.csdn.net/mchdba/article/details/68625963

系统层级

Linux操作系统查看CPU及系统版本相关信息

留下评论

一、CPU相关信息

查看CPU信息（型号）
cat /proc/cpuinfo | grep name | cut -f2 -d: | uniq -c

# 总核数 = 物理CPU个数 X 每颗物理CPU的核数
# 总逻辑CPU数 = 物理CPU个数 X 每颗物理CPU的核数 X 超线程数

# 查看物理CPU个数
cat /proc/cpuinfo| grep “physical id”| sort| uniq| wc -l

# 查看每个物理CPU中core的个数(即核数)
cat /proc/cpuinfo| grep “cpu cores”| uniq

# 查看逻辑CPU的个数
cat /proc/cpuinfo| grep “processor”| wc -l

总结：Oracle EBS标准管理器的工作班次下的流程数设置数（数据库节点服务器）为不超过逻辑CPU个数的两倍，比如查询结果为8，最大设置16，因为所有进程都需要在CPU上排队处理，多了也无用；但是如果设置数过小，又会造成CPU浪费。

二、操作系统内存大小信息

cat /proc/meminfo | grep MemTotal

三、操作系统版本相关信息

cat /etc/issue
Oracle Linux Server release 6.8

cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.8 (Santiago)

cat /proc/version
Linux version 2.6.32-642.el6.x86_64 (mockbuild@x86-ol6-builder-05)
(gcc version 4.4.7 20120313 (Red Hat 4.4.7-17) (GCC) ) #1 SMP Tue May
10 12:00:56 PDT 2016

uname -a
Linux r3115035596-1 2.6.32-642.el6.x86_64 #1 SMP Tue May 10 12:00:56 PDT 2016 x86_64 x86_64 x86_64 GNU/Linux

lsb_release -a
LSB Version:    :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch
Distributor ID: OracleServer
Description:    Oracle Linux Server release 6.8
Release:        6.8
Codename:       n/a

四、SWAP空间

但我们平时安装系统时，默认都分内存的2倍.

物理内存 交换分区（SWAP）
<= 4G 至少4G
4~16G 至少8G
16G~64G 至少16G
64G~256G 至少32G
# Linux 下 取进程占用 cpu 最高的前10个进程
ps aux|head -1;ps aux|grep -v PID|sort -rn -k +3|head

# linux 下 取进程占用内存(MEM)最高的前10个进程
ps aux|head -1;ps aux|grep -v PID|sort -rn -k +4|head

https://blog.csdn.net/bingqingsuimeng/article/details/51858858

https://linux.cn/article-211-1.html

https://blog.csdn.net/sunqp0208/article/details/41343443

查询ebs jdk版本：

sh -c “`awk -F= ‘$1 ~ /^JSERVJAVA.*$/ {print $2}’ $ADMIN_SCRIPTS_HOME/java.sh` -version;”