EBS R12 修改 apps 密码[Z]
注意：修改密码时应保证所有用户已退出， 最好是关闭应用实例。不用关闭数据库。在修改密码之前一定要改备下数据库中的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命讼。
密码修改失败以后修复办法：
view plaincopy
[*]truncate table fnd_user;
[*]truncate table fnd_oracle_userid;
[*]insert into fnd_user select * from 前面的备份表;
[*]insert into fnd_oracle_userid select * from ......;
[*]commit;
修改案例：
1. 停止实例：
view plaincopy
[*]$ /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.shversion 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. 进入数据库备份相关表：
view plaincopy
[*]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. 修改密码：
view plaincopy
[*]$ FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS vipshop
[*]Log filename : L403158.log
[*]
[*]
[*]Report filename : O403158.out
查看日志：
view plaincopy
[*]$ 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. 以新密码启动应用。
view plaincopy
[*]$ 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
[*]$ 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>
[*]
[*]
[*]$ /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.shversion 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 ...
页:
[1]