分类目录归档：系统层级

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

2018年1月17日小潘留下评论

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

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

系统层级、经验闲谈

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

2018年1月12日小潘留下评论

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

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

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及系统版本相关信息

2018年1月11日小潘留下评论

一、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;”

系统层级、经验闲谈

Oracle ebs 资产编号跳号问题分析

2018年1月4日小潘留下评论

在财务系统中会有很多地方都用到缓存，Oracle的解释是为了提高性能而做出的设置，比如在资产模块中，资产编号的生成，就设置了缓存为20，具体如下：

create sequence fa.fa_additions_s
minvalue 1
maxvalue 2000000000
start with 100000001
increment by 1
cache 20
order;

解决方案有两个（一般不建议操作，因为资产编号对资产盘点没有很大的帮助，在实物资产系统一般是用资产标签号进行标识唯一的资产，可说服用户使用标签号；同时建议做个性化对资产编号进行锁定不允许修改）：

1）直接去掉序列号缓存，执行下列命令，但这可能会在性能上造成一定的下降：

alter sequence fa_additions_s nocache;

2）固定序列号的缓存，通过下列命令：

dbms_shared_pool.keep('FA_ADDITIONS_S','Q').

当确认序列不再变更，把上面的代码添加到一个sql脚本，它可以在db启动时运行它，这样在db反弹后pinning不会丢失。

这个问题可能会发生在应用程序的任何序列中，所以用你的序列名替换FA_ADDITIONS_S。

系统层级

Oracle EBS职责分配不生效问题处理（变更过失效日期）

2018年1月3日小潘留下评论

一、通过功能管理员清除高速缓存，同时通过系统管理员提交“有效用户和职责”，观察结果；

二、通过请求同步局部工作流，观察结果；

三、如果前面两步未生效，可考虑应用以下解决方案

1. Go into the responsibility: System Administrator.

2. Navigate to Request > Run.

3. Submit request 'Synchronize WF LOCAL tables'

4. Submit request 'Workflow Directory Services User/Role Validation'

5. Check result in table wf_local_user_roles via:

select role_name, effective_end_date from wf_local_user_roles
where user_name='<>';

6. If still find some records haven't been changed to null, perform:
a.) backup the records:
create table wf_local_user_roles_bak as
select * from wf_local_user_roles
where user_name='<>' and effective_end_date <> to_date('<>','RRRR-MM-DD');
b.) update effective_end_date to null
update wf_local_user_roles
set effective_end_date=to_date('9999-01-01','RRRR-MM-DD')
where user_name='<>' and effective_end_date <> to_date('<>','RRRR-MM-DD');

7. Retest the issue.

8. Migrate the solution as appropriate to other environments.

技术笔记（小潘的技术记录博客）

备案信息：
@2012-2024 www.llku.com 版权所有ICP证：
蜀ICP备18026986号-1
网站支持：
阿里云 ECS

2024年 5月
一	二	三	四	五	六	日
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31