Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.

You are encouraged to leave a comment.








Saturday, August 17, 2013

Oracle Fusion Applications DB Users account expired

If you receive the error while starting the fusion applications like

FunctionalSetupServer_1 [ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'  WLS Kernel 1376716681974 BEA-001129 Received exception while creating connection for pool "ApplicationDB": ORA-28001: the password has expired


To solve this,

For Oracle Fusion installations, you need to change all fusion-related accounts if you find one of them has expired or is going to expire.  To find the account status and its expiry date, you can use:

SQL> select username, account_status, lock_date, expiry_date from dba_users;


USERNAME                       ACCOUNT_STATUS                   EXPIRY_DA
------------------------------ -------------------------------- ---------
SCM_FUSION_MDS_SOA             EXPIRED                          17-JUL-13
SCM_FUSION_SOAINFRA            EXPIRED                          16-JUL-13
FUSION_OTBI                    EXPIRED                          17-JUL-13
FUSION_BIPLATFORM              EXPIRED                          16-JUL-13
HCM_FUSION_SOAINFRA            EXPIRED                          16-JUL-13
FUSION_ORA_ESS                 EXPIRED                          16-JUL-13
SETUP_FUSION_MDS_SOA           EXPIRED                          16-JUL-13
PRC_FUSION_SOAINFRA            EXPIRED                          16-JUL-13
FUSION_PORTLET                 EXPIRED                          18-JUL-13
PRC_FUSION_MDS_SOA             EXPIRED                          18-JUL-13
OIC_FUSION_MDS_SOA             EXPIRED                          18-JUL-13


To extract the encrypted password for the users who have expired accounts



select
  'alter user "'||username||'" identified by values '''||
  extract(xmltype(dbms_metadata.get_xml('USER',username)),
  '//USER_T/PASSWORD/text()').getStringVal()||''';'  old_password
from
   dba_users where account_status='EXPIRED'




Verify the passwords and usernames are correctly populated like this one.

alter user "SCM_FUSION_MDS_SOA" identified by values '163ADA6508E9D1C3';
alter user "SCM_FUSION_SOAINFRA" identified by values 'D912786349BA6EA3';
alter user "FUSION_OTBI" identified by values '66E632C33281B01E';
alter user "FUSION_BIPLATFORM" identified by values 'EA482B1786E8F466';
alter user "HCM_FUSION_SOAINFRA" identified by values '1D1C913177201A02';
alter user "FUSION_ORA_ESS" identified by values 'E35CAA10530BC219';
alter user "SETUP_FUSION_MDS_SOA" identified by values '9594CA5CD06C3825';
alter user "PRC_FUSION_SOAINFRA" identified by values 'F89E2FC5B64583F9';
alter user "FUSION_PORTLET" identified by values '18BE75B962643F54';
alter user "PRC_FUSION_MDS_SOA" identified by values '35A07CDF207B6F04';
alter user "OIC_FUSION_MDS_SOA" identified by values 'A4E4736B03BB24FF';
alter user "OIC_FUSION_SOAINFRA" identified by values '442823F64859765D';


Execute these statements agaist SQL*PLUS as sys user only.

SQL> alter user "SCM_FUSION_MDS_SOA" identified by values '163ADA6508E9D1C3';

User altered.

Cheers!!!



3 comments:

Microsoft Dynamics said...


Valuable information and excellent design you got here! I would like to thank you for sharing your thoughts and time into the stuff you post!!
Latest jobs

Microsoft Dynamics said...

Hey very nice blog!!
Hi there,I enjoy reading through your article post, I wanted to write a little comment to support you and wish you a good continuationAll the best for all your blogging efforts.
Appreciate the recommendation! Let me try it out.
Keep working ,great job!
Microsoft dynamics training

Microsoft Dynamics said...

Hi
I read this post two times.
I like it so much, please try to keep posting.
Let me introduce other material that may be good for our community.

Hadoop training

Related Posts Plugin for WordPress, Blogger...

Let us be Friends...

Share |

Popular Posts

Labels

11.5.1. to 11.5.5 Cloning Procedure. 11g 11i 11i and R12 11i Autoconfig 11i Cloning 12.1.1 SSL 2 Node RAC Adconfig.sh errors out adgennls.pl adop Advanced Replication Apache version Apex Apex for Oracle database Apex Installation Apex Installation on Oracle E Business Suite. 11i with Apex Apex on 11i Apex on Oracle 11i Apex402 apexins.sql APPL_TOP Character Application Express Application server Issue APPLSYS password Apps Password Asynchronous Replication Autoconfig Autoconfig Managed Beehive Bit of operating system Block block media corrupt BPEL Central Inventory Character Set Conversion Cloning of 11i Cloning of Oracle Applications Clusterware Concurrent CPU 2011 CPU 2012 April CPU 2012 January. CPU 2012 October CRS custom top Custom Top Creation Database . Database Query Dataguard DBMS_REPAIR Demantra . Domain Name E Business Suite Migration EBS 12.2 EPM exp/imp Oracle Applications Flashback table flows_020200 FND_TOP/resource FNDCPASS FNDCPUCF Forms server upgrade Forms startup FRM-92101 Fusion Middleware Hostname Hot Backup Hot cloning HotBackup Hotbackup Cloning of Oracle Apps hrglobal.drv. NLS Saudi Arabian HRMS hyperion Import and Export Oracle Applications Install Oracle Installation of R12 Installation Steps integration Oracle EBS Issues Database issues Oracle EBS Issues with Upgrade 12.1.1 Java Mission Control Java Upgrade java/sql/SavePoint JInitiator Junk Characters Language Translation Linux Linux Migration listener trace Listner version Local Inventory Login Page Master-Master Replication Memory Tuning Multiple Language NLS Non-Autoconfig Enabled OBIEE 11g Installation OBIEE Issues OIM Opatch version OpenSSL ora-01031 Oracle oracle 11g Oracle Announcement Oracle Application servers Oracle Application services Oracle Applications Oracle Applications 11i oracle applications 12.2 Oracle Applications Cloning Oracle Applications Upgrade Oracle Applications. Oracle Apps cloning Oracle BPEL oracle certifications oracle database Oracle Database RMAN Oracle Database upgradation Oracle DB oracle E Business suite 12.2 Oracle EBS oracle EPM Oracle Forms Logo oracle Fusion Applications Oracle Inventory oracle news Oracle OUI Oracle R12 oracle Sun Solaris Oracle Tuning Oracle Virtual Box Oracle Webgate Oracle WMA configuration orcladmin password for Oracle Applications Pasta Configuration pasta.cfg patch PDF Performance Physical Standby Platform migration Printer Configuration Profile Option R12 RAC Rapid Install Rapidwiz Real Application Clusters 10g Recovery RMAN RMAN Recovery SA Gosi Service Oriented Architecture SOA SQLTXPLAIN SSL Configuration step-by-step upgrade Sun solaris Swap Tablespace Trace Enable Trace file Translation Synchronization Patch transport tablespace tuning Tuning SGA uifont.ali Underscore Universal Content Management updates.oracle.com Upgradation of 12.0.5 to 12.1.1 Upgrade Upgrade 11g Upgrade Apps Upgrade DB Upgrade to 11g UTF8 version of oracle applications versions Web server upgrade weblogic windows workflow version XML Publisher version