oracleebs修改APPS用戶的密碼

修密碼前一定備份一下，

為柯城等地區(qū)用戶提供了全套網(wǎng)頁設(shè)計(jì)制作服務(wù)，及柯城網(wǎng)站建設(shè)行業(yè)解決方案。主營業(yè)務(wù)為網(wǎng)站制作、成都做網(wǎng)站、柯城網(wǎng)站設(shè)計(jì)，以傳統(tǒng)方式定制建設(shè)網(wǎng)站，并提供域名空間備案等一條龍服務(wù)，秉承以專業(yè)、用心的態(tài)度為用戶提供真誠的服務(wù)。我們深信只要達(dá)到每一位用戶的要求，就會得到認(rèn)可，從而選擇與我們長期合作。這樣，我們也可以走得更遠(yuǎn)！

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.

如果修改失?。?/p>

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

+---------------------------------------------------------------------------+
執(zhí)行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.
-查看日志看是否有報(bào)錯(cuò)：

[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

如果是多節(jié)點(diǎn)APP: 執(zhí)行順序是1-》2——》。。。。1

新聞標(biāo)題：oracleebs修改APPS用戶的密碼
網(wǎng)頁地址：http://bm7419.com/article0/ijpsoo.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供搜索引擎優(yōu)化、微信公眾號、服務(wù)器托管、軟件開發(fā)、自適應(yīng)網(wǎng)站、電子商務(wù)

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源：創(chuàng)新互聯(lián)

猜你還喜歡下面的內(nèi)容