EBS R12修改密码

注意：
修改密码时应保证所有用户已退出， 最好是关闭应用实例。不用关闭数据库。在修改密码之前一定要改备下数据库中的FND_ORACLE_USERID和FND_USER表。
FNDCPASS工具会自动把APPS用户的密码和APPLSYS用户的密码和APPLSYS用户的密码同步设置成一样的。
在修改完APPLSYS和APPS用户的密码后， 需要重新启动并发管理器。
在修改完APPLSYS和APPS用户的密码后，要求将已经处在登录状态的用户完全退出， 然后重新登录。
修改APPS用户的密码不支持直接在数据库中使用ALTER USER 命令。
在任何情况下，都不能直接使用操纵数据库的密码去直接修改APPS用户密码。
一定要用FNDCPASS去修改APPS密码， 在ORACLE 12.1.2中可以用AFPASSWD命令。
在修改密码过程中，要仔细，反复确认FNDCPASS日志，如果在FNDCPASS日志中发现了任何错误信息，在没弄清楚错误原因之前不要手动去运行AUTOCONFIG命令。
在修改用户密码过程中，如果出现ERP系统不能登录的问题， 不要再随便运行AUTOCONFIG命讼。

密码修改失败以后修复办法：

truncate table fnd_user;
truncate table fnd_oracle_userid;
insert into fnd_user select * from 前面的备份表;
insert into fnd_oracle_userid select * from ......;
commit;

修改案例：
1. 停止实例：

[ebsapp@gd1ebs132 ~]$ /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adstpall.sh apps/apps

You are running adstpall.sh version 120.10.12010000.4

The logfile for this session is located at /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adstpall.log
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/jtffmctl.sh stop
script returned:
****************************************************

You are running jtffmctl.sh version 120.3

Shutting down Fulfillment Server for PROD on port 9307 ...

jtffmctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adcmctl.sh stop
script returned:
****************************************************

You are running adcmctl.sh version 120.17.12010000.5

Shutting down concurrent managers for PROD ...
ORACLE Password:
Submitted request 403157 for CONCURRENT FND SHUTDOWN 


adcmctl.sh: exiting with status 0


adcmctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adcmctl.txt for more information ...  


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adoafmctl.sh stop
script returned:
****************************************************

You are running adoafmctl.sh version 120.8

Stopping OPMN managed OAFM OC4J instance ...

adoafmctl.sh: exiting with status 0

adoafmctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adoafmctl.txt for more information ...  


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adformsctl.sh stop
script returned:
****************************************************

You are running adformsctl.sh  version 120.16.12010000.3

Stopping OPMN managed FORMS OC4J instance  ...

adformsctl.sh: exiting with status 0

adformsctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adformsctl.txt for more information ...  


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adoacorectl.sh stop
script returned:
****************************************************

You are running adoacorectl.sh version 120.13

Stopping OPMN managed OACORE OC4J instance ...

adoacorectl.sh: exiting with status 0

adoacorectl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adoacorectl.txt for more information ...  


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adapcctl.sh stop
script returned:
****************************************************

You are running adapcctl.sh version 120.7.12010000.2

Stopping OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl: stopping opmn managed processes...

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adapcctl.txt for more information ...  


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adalnctl.sh stop
script returned:
****************************************************

adalnctl.sh version 120.3

Shutting down listener process APPS_PROD.

adalnctl.sh: exiting with status 0


adalnctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adalnctl.txt for more information ...  


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adopmnctl.sh stop
script returned:
****************************************************

You are running adopmnctl.sh version 120.6.12010000.5

Stopping Oracle Process Manager (OPMN)  and the managed processes ...
opmnctl: stopping opmn and all managed processes...

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adopmnctl.txt for more information ...  


.end std out.

.end err out.

****************************************************


All enabled services on this node are stopped.

adstpall.sh:Exiting with status 0

adstpall.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adstpall.log for more information ...  

2. 进入数据库备份相关表：

SQL> conn apps/apps
Connected.
SQL> create table fnd_user_bak as select * from fnd_user;

Table created.

SQL> create table fnd_oracle_userid_bak as select * from fnd_oracle_userid;

Table created.

3. 修改密码：

[ebsapp@gd1ebs132 ~]$ FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS vipshop 
Log filename : L403158.log


Report filename : O403158.out

查看日志：

[ebsapp@gd1ebs132 ~]$ more L403158.log
+---------------------------------------------------------------------------+
Application Object Library: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

 module: 
+---------------------------------------------------------------------------+

Current system time is 13-JUN-2013 11:15:15

+---------------------------------------------------------------------------+

Working...


+---------------------------------------------------------------------------+
Concurrent request completed successfully
Current system time is 13-JUN-2013 11:15:15

+---------------------------------------------------------------------------+
修改正常。

4. 以新密码启动应用。

[ebsdb@gd1ebs131 ~]$ sqlplus apps/apps

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jun 13 11:11:54 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name: ^C
[ebsdb@gd1ebs131 ~]$ sqlplus apps/vipshop 

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jun 13 11:12:06 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> 


[ebsapp@gd1ebs132 ~]$ /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adstrtal.sh apps/vipshop

You are running adstrtal.sh version 120.15.12010000.3

The logfile for this session is located at /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adstrtal.log
Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adopmnctl.sh start
script returned:
****************************************************

You are running adopmnctl.sh version 120.6.12010000.5

Starting Oracle Process Manager (OPMN) ...
opmnctl: opmn started.

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adopmnctl.txt for more information ...  


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adalnctl.sh start
script returned:
****************************************************

adalnctl.sh version 120.3

Checking for FNDFS executable.
Starting listener process APPS_PROD.

adalnctl.sh: exiting with status 0


adalnctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adalnctl.txt for more information ...  


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adapcctl.sh start
script returned:
****************************************************

You are running adapcctl.sh version 120.7.12010000.2

Starting OPMN managed Oracle HTTP Server (OHS) instance ...
opmnctl: opmn is already running.
opmnctl: starting opmn managed processes...

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adapcctl.txt for more information ...  


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adoacorectl.sh start
script returned:
****************************************************

You are running adoacorectl.sh version 120.13

Starting OPMN managed OACORE OC4J instance  ...

adoacorectl.sh: exiting with status 0

adoacorectl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adoacorectl.txt for more information ...  


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adformsctl.sh start
script returned:
****************************************************

You are running adformsctl.sh  version 120.16.12010000.3

Starting OPMN managed FORMS OC4J instance  ...
Calling txkChkFormsDeployment.pl to check whether latest FORMSAPP.EAR is deployed...
Program : /u01/PROD/PROD/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl started @ Thu Jun 13 11:18:14 2013

*** Log File = /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/rgf/TXK/txkChkFormsDeployment_Thu_Jun_13_11_18_14_2013/txkChkFormsDeployment_Thu_Jun_13_11_18_14_2013.log 

File "/u01/PROD/PROD/apps/tech_st/10.1.3/j2ee/forms/applications/forms/formsweb/WEB-INF/lib/frmsrv.jar" exists. Proceeding to check the size...

=============================================
*** Latest formsapp.ear has been deployed ***
=============================================


Program : /u01/PROD/PROD/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkChkFormsDeployment.pl completed @ Thu Jun 13 11:18:14 2013

Perl script txkChkFormsDeployment.pl got executed successfully

 

adformsctl.sh: exiting with status 0

adformsctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adformsctl.txt for more information ...  


.end std out.
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** Log File = /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/rgf/TXK/txkChkFormsDeployment_Thu_Jun_13_11_18_14_2013/txkChkFormsDeployment_Thu_Jun_13_11_18_14_2013.log 

.end err out.

****************************************************


Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adoafmctl.sh start
script returned:
****************************************************

You are running adoafmctl.sh version 120.8

Starting OPMN managed OAFM OC4J instance  ...

adoafmctl.sh: exiting with status 0

adoafmctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adoafmctl.txt for more information ...  


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/adcmctl.sh start
script returned:
****************************************************

You are running adcmctl.sh version 120.17.12010000.5

Starting concurrent manager for PROD ...
Starting PROD_0613@PROD Internal Concurrent Manager
Default printer is noprint

adcmctl.sh: exiting with status 0


adcmctl.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adcmctl.txt for more information ...  


.end std out.

.end err out.

****************************************************


Executing service control script:
/u01/PROD/PROD/inst/apps/PROD_gd1ebs132/admin/scripts/jtffmctl.sh start
script returned:
****************************************************

You are running jtffmctl.sh version 120.3

Validating Fulfillment patch level via /u01/PROD/PROD/apps/apps_st/comn/java/classes
Fulfillment patch level validated.
Starting Fulfillment Server for PROD on port 9307 ...

jtffmctl.sh: exiting with status 0


.end std out.

.end err out.

****************************************************


All enabled services for this node are started.

adstrtal.sh: Exiting with status 0

adstrtal.sh: check the logfile /u01/PROD/PROD/inst/apps/PROD_gd1ebs132/logs/appl/admin/log/adstrtal.log for more information ...