oracleebs修改APPS用户的密码
修密码前一定备份一下，
为柯城等地区用户提供了全套网页设计制作服务，及柯城网站建设行业解决方案。主营业务为网站制作、成都做网站、柯城网站设计，以传统方式定制建设网站，并提供域名空间备案等一条龙服务，秉承以专业、用心的态度为用户提供真诚的服务。我们深信只要达到每一位用户的要求，就会得到认可，从而选择与我们长期合作。这样，我们也可以走得更远！
SQL> create table fnd_user_20160614 as select * from fnd_user;
Table created.
SQL> create table fnd_oracle_userid_20160614 as select * from fnd_oracle_userid;
Table created.
如果修改失败：
truncate table fnd_user;
truncate table fnd_oracle_userid;
insert into fnd_user select * from 前面的备份表;
insert into fnd_oracle_userid select * from ......;
commit;
[applprod@ebsprod scripts]$ FNDCPASS APPS/APPS 0 Y SYSTEM/MANAGER SYSTEM APPLSYS llcebs
Log filename : L392520.log
Report filename : O392520.out
[applprod@ebsprod scripts]$ ls
adalnctl.sh adcmctl.sh adformsctl.sh adoafmctl.sh adstpall.sh ieo L392520.log mwactlwrpr.sh
adapcctl.sh adexecsql.pl adformsrvctl.sh adopmnctl.sh adstrtal.sh java.sh msc sqlnet.log
adautocfg.sh adforms-c4wsctl.sh adoacorectl.sh adpreclone.pl gsmstart.sh jtffmctl.sh mwactl.sh
[applprod@ebsprod scripts]$ cat L392520.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
module:
+---------------------------------------------------------------------------+
Current system time is 14-JUN-2016 14:28:37
+---------------------------------------------------------------------------+
Working...
+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 14-JUN-2016 14:28:38
+---------------------------------------------------------------------------+
执行autocfg：
[applprod@ebsprod scripts]$ ls
adalnctl.sh adcmctl.sh adformsctl.sh adoafmctl.sh adstpall.sh ieo L392520.log mwactlwrpr.sh
adapcctl.sh adexecsql.pl adformsrvctl.sh adopmnctl.sh adstrtal.sh java.sh msc sqlnet.log
adautocfg.sh adforms-c4wsctl.sh adoacorectl.sh adpreclone.pl gsmstart.sh jtffmctl.sh mwactl.sh
[applprod@ebsprod scripts]$ ./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /app/appl_prod/inst/apps/PROD_ebsprod/admin/log/06141432/adconfig.log
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /app/appl_prod/inst/apps/PROD_ebsprod
Classpath : /app/appl_prod/apps/apps_st/comn/java/lib/appsborg2.zip:/app/appl_prod/apps/apps_st/comn/java/classes
Using Context file : /app/appl_prod/inst/apps/PROD_ebsprod/appl/admin/PROD_ebsprod.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 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 IGS_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 FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed successfully.
-查看日志看是否有报错：
[oraprod@ebsprod PROD_ebsprod]$ sqlplus apps/llcebs
SQL*Plus: Release 11.1.0.7.0 - Production on Tue Jun 14 14:38:27 2016
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>
修改sysadmin 的密码：
[applprod@ebsprod scripts]$ FNDCPASS APPS/llcebs 0 Y SYSTEM/MANAGER USER sysadmin llcebs
Log filename : L392524.log
Report filename : O392524.out
如果是多节点APP: 执行顺序是1-》2——》。。。。1
文章名称：oracleebs修改APPS用户的密码
本文URL：http://mswzjz.cn/article/ijpsoo.html