29 September 2011

PortConflicts and

Error :-  when i am running the Jdeveloper I am getting below error,

Port Conflicts and  <Info> <Management> <BEA-141281> <unable to get file lock, will retry ...>

Solution :
If Weblogic server fails to start due to unable to get file lock, then lock files need to be removed manually before restart WebLogic Server .

Reference :- 


BEA-141281
Info: unable to get file lock, will retry ...
Description
This message indicates that WLS can not get file lock because other process still holds the lock. W LS will try again before timeout.
Cause
This is an information-level message only.
Action
If WLS fails to start due to unable to get file lock, then lock files need to be removed manually before restart WLS.

25 September 2011

How to remove memory caches in Linux

[root@our12-db1 ~]# free -m -t
             total       used       free     shared    buffers     cached
Mem:         48288      46384       1904          0        315      38199
-/+ buffers/cache:       7870      40418
Swap:        32767        105      32662
Total:       81056      46490      34566
[root@our12-db1 ~]# sudo sync && sudo sysctl -w vm.drop_caches=3 && sudo sysctl -w vm.drop_caches=o
vm.drop_caches = 3
vm.drop_caches = o
[root@our12-db1 ~]# free -m -t
             total       used       free     shared    buffers     cached
Mem:         48288      11533      36755          0          2       4228
-/+ buffers/cache:       7302      40986
Swap:        32767        105      32662
Total:       81056      11638      69418
[root@our12-db1 ~]#

Oracle Installed Base You do not have access to this Functionality

When I click the Oracle Installed Base user Responsibility I am facing below Error 

Login Application using Sysadmin user 

User CRM HTML Administration responsibility --> User maintenance

Enter your username :  click Go

select  CSI_NORMAL_USER  or CSI_ADMIN  click update .


Now my problem Resolved



21 September 2011

problem after unexpected shutdown of host Failed to lock the file (16392)


Sep 21 08:47:26.355: vmx| VMXVmdb_LoadRawConfig: Loading raw config
Sep 21 08:47:26.359: vmx| DISK: OPEN scsi0:0 'D:\Linux\Clone of Red Hat Enterprise Linux 4 64-bit\Red Hat Enterprise Linux 4 64-bit-cl1.vmdk' persistent R[]
Sep 21 08:47:28.991: vmx| FILE: WaitForPossession timeout on 'D:\Linux\Clone of Red Hat Enterprise Linux 4 64-bit\Red Hat Enterprise Linux 4 64-bit-cl1.vmdk.lck\M48850.lck' due to a local process (5040)
Sep 21 08:47:28.992: vmx| FILE: FileIO_Lock on 'D:\Linux\Clone of Red Hat Enterprise Linux 4 64-bit\Red Hat Enterprise Linux 4 64-bit-cl1.vmdk' failed: Lock timed out
Sep 21 08:47:28.992: vmx| DISKLIB-LINK  : "D:\Linux\Clone of Red Hat Enterprise Linux 4 64-bit\Red Hat Enterprise Linux 4 64-bit-cl1.vmdk" : failed to open (Failed to lock the file).
Sep 21 08:47:28.992: vmx| DISKLIB-CHAIN : "D:\Linux\Clone of Red Hat Enterprise Linux 4 64-bit\Red Hat Enterprise Linux 4 64-bit-cl1.vmdk" : failed to open (Failed to lock the file).
Sep 21 08:47:28.992: vmx| DISKLIB-LIB   : Failed to open 'D:\Linux\Clone of Red Hat Enterprise Linux 4 64-bit\Red Hat Enterprise Linux 4 64-bit-cl1.vmdk' with flags 0xa (Failed to lock the file).
Sep 21 08:47:28.992: vmx| DISK: Cannot open disk "D:\Linux\Clone of Red Hat Enterprise Linux 4 64-bit\Red Hat Enterprise Linux 4 64-bit-cl1.vmdk": Failed to lock the file (16392).
Sep 21 08:47:28.992: vmx| Msg_Post: Error
Sep 21 08:47:28.992: vmx| [msg.disk.noBackEnd] Cannot open the disk 'D:\Linux\Clone of Red Hat Enterprise Linux 4 64-bit\Red Hat Enterprise Linux 4 64-bit-cl1.vmdk' or one of the snapshot disks it depends on.
Sep 21 08:47:28.992: vmx| [msg.disk.configureDiskError] Reason: Failed to lock the file.----------------------------------------
Sep 21 08:47:38.944: vmx| Module DiskEarly power on failed.


Solution :-

I have renamed D:\Linux\Clone of Red Hat Enterprise Linux 4 64-bit\Red Hat Enterprise Linux 4 64-bit-cl1.vmdk.lck  to  D:\Linux\Clone of Red Hat Enterprise Linux 4 64-bit\Red Hat Enterprise Linux 4 64-bit-cl1.vmdk.old
D:\Linux\Red Hat Enterprise Linux 4 64-bit\Red Hat Enterprise Linux 4 64-bit-cl1.vmdk.lck  to D:\Linux\Red Hat Enterprise Linux 4 64-bit\Red Hat Enterprise Linux 4 64-bit-cl1.vmdk.old

20 September 2011

Step by Step Installation of Weblogic Server 10.3.3.0 on Windows


How to get the FND User name and Responsibility


SELECT c.user_name , RESPONSIBILITY_NAME
    FROM FND_USER_RESP_GROUPS_DIRECT a,
            FND_RESPONSIBILITY_VL b,
            fnd_user c
   WHERE     a.user_id(+) = c.user_id
         AND a.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID(+)
         AND c.user_name = NVL (:user_name, c.user_name)
         --and RESPONSIBILITY_NAME is null
ORDER BY 1;
:user_name =  Enter your username
Output :-
USER_NAME        RESPONSIBILITY
THALAIMUTHUApplication Developer
THALAIMUTHUSystem Administrator
THALAIMUTHUOracle Sales Administrator
THALAIMUTHUQuality
THALAIMUTHUBills of Material
THALAIMUTHUInventory
THALAIMUTHUWorkflow Administrator Web Applications
THALAIMUTHUOrder Management Super User
THALAIMUTHUOracle Pricing Manager
THALAIMUTHUCRM Resource Manager
THALAIMUTHUCRM Task Manager
THALAIMUTHUSFM System Administrator
THALAIMUTHUQuoting Sales Manager
THALAIMUTHUCustomer Support
THALAIMUTHUCRM Administrator
THALAIMUTHUCRM HTML Administration
THALAIMUTHUCall Center Administration
THALAIMUTHUOracle Installed Base Admin
THALAIMUTHUOracle Installed Base User
THALAIMUTHUCRM Application Foundation User
THALAIMUTHUCRM Employee
THALAIMUTHUXML Publisher Administrator
THALAIMUTHUWorkflow Administrator Event Manager
THALAIMUTHUWorkflow Administrator Web (New)
THALAIMUTHUWorkflow User Web (New)
THALAIMUTHUNumber Management
THALAIMUTHUNumber Management User
THALAIMUTHUQtel Installation Team
THALAIMUTHUQtel BackOffice Responsibility
THALAIMUTHUNMS Admin
THALAIMUTHUCall Center Agent
THALAIMUTHUBan Call Centre Representative

How to recover deleted Procedure Package Table


Backup your current Procedure:-SQL> select text from dba_source where name='XXQTL_DATA';
TEXT
--------------------------------------------------------------------------------
PACKAGE BODY XXQTL_DATA
PACKAGE              xxqtl_data
PACKAGE BODY              xxqtl_data
IS
IS   --Set of global variable for holding event sources to get DN and  EN values
IS
/******************************************************************************
   g_delen               VARCHAR2 (50)  := 'EN';
/******************************************************************************
Package       : APPS_APPLMGR.xxqtl_data
   --Global variable to hold DEL  EN event source.
Package       : APPS_APPLMGR.xxqtl_comptel
.............
         fnd_file.put_line (fnd_file.LOG, 'Exception Occured ' || SQLERRM);
         DBMS_OUTPUT.put_line ('Exception Occured ' || SQLERRM);
   END process;
END;
27551 rows selected.
Drop your Current Procedure :-
SQL> drop procedure XXQTL_DATA;
Procedure dropped.
SQL> connect / as sysdba
Connected.
Recover your old Procedure :-
SQL> SELECT text FROM dba_source AS OF TIMESTAMP SYSTIMESTAMP - INTERVAL '180' MINUTE WHERE name = 'XXQTL_DATA';
TEXT
--------------------------------------------------------------------------------
PACKAGE BODY XXQTL_DATA
PACKAGE              xxqtl_data
PACKAGE BODY              xxqtl_data
IS
IS   --Set of global variable for holding event sources to get DN and  EN values
IS
/******************************************************************************
   g_delen               VARCHAR2 (50)  := 'EN';
/******************************************************************************
Package       : APPS_APPLMGR.xxqtl_data
   --Global variable to hold DEL  EN event source.
Package       : APPS_APPLMGR.xxqtl_comptel
.............
         fnd_file.put_line (fnd_file.LOG, 'Exception Occured ' || SQLERRM);
         DBMS_OUTPUT.put_line ('Exception Occured ' || SQLERRM);
   END process;
END;
27551 rows selected.

How to add Responsibility using PL/SQL


BEGIN
   fnd_user_pkg.addresp ('MUTHU',                   /*Application User Name */
                         'SYSADMIN',                 /*get from Query Below */
                         'SYSTEM_ADMINISTRATOR',     /*get from Query Below */
                         'STANDARD',                  /* Most of cases it is ‘STANDARD’ so you can hard code it */
                         'SystemAdmin',            /* Any comments you want */
                         SYSDATE,                     /* Sysdate From Today */
                         NULL);    /* Sysdate + 365 Rights for Next One Year*/
END;
commit;Execute Below Query You will get the detail :-
 
SELECT MUT.APPLICATION_SHORT_NAME, MUT.APPLICATION_NAME,SHI.RESPONSIBILITY_KEY, SHI.RESPONSIBILITY_NAME
FROM FND_APPLICATION_VL MUT, FND_RESPONSIBILITY_VL SHI
WHERE SHI.APPLICATION_ID=MUT.APPLICATION_ID
ORDER BY SHI.RESPONSIBILITY_NAME;

How to change the FND USER password with out Old password using PL/sql script


begin
fnd_user_pkg.changepassword('USERNAME', 'PASSWORD');
 end;
-- Input (Mandatory)
-- username: User Name
-- newpassword New Password
Examble :-
declare
 x  boolean;
     BEGIN
        x  :=    FND_USER_PKG.CHANGEPASSWORD ('MUTHU','shibanikutty');
     END;
 commit;

How to change the FND USER password with Old password using PL/sql script


BEGIN
   fnd_user_pkg.changepassword ('USERNAME', 'OLDPASSWORD', 'NEWPASSWORD');
END;
  Input (Mandatory)
  username:       User Name
  oldpassword     Old Password
  newpassword     New PasswordExample:-
DECLARE
   x   BOOLEAN;
BEGIN
   x := fnd_user_pkg.changepassword ('SHIBANI', 'shibanikutty', 'welcome');
END;

How to delete the Resposibility using PL/SQL script


BEGIN
   fnd_user_pkg.delresp ('SCOTT',  ---- User Name
                         'FND',    ---Application Short Name
                         'APPLICATION_DEVELOPER', ---Responsibility Key
                         'STANDARD');   --Security Group Key
END;Execute below Query you will get the Application Short Name and Responsibility Key
SELECT MUT.APPLICATION_SHORT_NAME, SHI.RESPONSIBILITY_KEY, SHI.RESPONSIBILITY_NAME
 FROM FND_APPLICATION_VL MUT, FND_RESPONSIBILITY_VL SHI
 WHERE SHI.APPLICATION_ID=MUT.APPLICATION_ID
 ORDER BY SHI.RESPONSIBILITY_NAME;
Examble:-
BEGIN
   fnd_user_pkg.delresp ('MUTHU',
                         'INV',
                         'INVENTORY',
                         'STANDARD');
END;

How to recover Oracle Dropped Table


[oracle@testserver db_1]$ sqlplus scott/oracleSQL> select * from emp;
OWNER OBJECT_NAME
------------------------------ ------------------------------
ORIGINAL_NAME OPERATION TYPE
-------------------------------- --------- -------------------------
TS_NAME CREATETIME DROPTIME
------------------------------ ------------------- -------------------
DROPSCN PARTITION_NAME CAN CAN RELATED BASE_OBJECT
---------- -------------------------------- --- --- ---------- -----------
PURGE_OBJECT SPACE
------------ ----------
SCOTT BIN$p1LI8Mt6uzXgQAB/AQAetw==$0
EMP DROP TABLE
USERS 2005-10-22:22:23:20 2011-07-05:18:10:12
OWNER OBJECT_NAME
------------------------------ ------------------------------
ORIGINAL_NAME OPERATION TYPE
-------------------------------- --------- -------------------------
TS_NAME CREATETIME DROPTIME
------------------------------ ------------------- -------------------
DROPSCN PARTITION_NAME CAN CAN RELATED BASE_OBJECT
---------- -------------------------------- --- --- ---------- -----------
PURGE_OBJECT SPACE
------------ ----------
636508 YES YES 51151 51151
51151 8
SQL>drop table EMP;
Table dropped.
SQL> select * from EMP;
select * from EMP
ERROR at line 1:
ORA-00942: table or view does not exist
SQL>conn sys/oracle as sysdba ---- Login as sysdba
Connected.
SQL> FLASHBACK TABLE SCOTT.EMP TO BEFORE DROP;
Flashback complete.
SQL> conn scott/oracle
Connected.
SQL>select * from emp;
OWNER OBJECT_NAME
------------------------------ ------------------------------
ORIGINAL_NAME OPERATION TYPE
-------------------------------- --------- -------------------------
TS_NAME CREATETIME DROPTIME
------------------------------ ------------------- -------------------
DROPSCN PARTITION_NAME CAN CAN RELATED BASE_OBJECT
---------- -------------------------------- --- --- ---------- -----------
PURGE_OBJECT SPACE
------------ ----------
SCOTT BIN$p1LI8Mt6uzXgQAB/AQAetw==$0
EMP DROP TABLE
USERS 2005-10-22:22:23:20 2011-07-05:18:10:12
OWNER OBJECT_NAME
------------------------------ ------------------------------
ORIGINAL_NAME OPERATION TYPE
-------------------------------- --------- -------------------------
TS_NAME CREATETIME DROPTIME
------------------------------ ------------------- -------------------
DROPSCN PARTITION_NAME CAN CAN RELATED BASE_OBJECT
---------- -------------------------------- --- --- ---------- -----------
PURGE_OBJECT SPACE
------------ ----------
636508 YES YES 51151 51151
51151 8
SQL>

oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.;


<!--StartFragment-->oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.;
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1987)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:509)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:430)
at _oa__html._OA._jspService(_OA.java:84)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:534)
## Detail 0 ##
oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1509)
at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:362)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(ExtendedProfileStore.java:210)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:169)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:148)
at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1201)
at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1044)
at oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:1013)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:980)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:967)
at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:570)
at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:987)
at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:964)
at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:918)
at oracle.apps.fnd.common.AppsContext.<init>(AppsContext.java:752)
at oracle.apps.fnd.common.WebAppsContext.<init>(WebAppsContext.java:1002)
at oracle.apps.fnd.framework.server.OAUtility.getWebAppsContext(OAUtility.java:352)
at oracle.apps.fnd.framework.webui.OAServerDelegate.getWebAppsContext(OAServerDelegate.java:1684)
at oracle.apps.fnd.framework.webui.OAPageBean.createRFURL(OAPageBean.java:6153)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:730)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:509)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:430)
at _oa__html._OA._jspService(_OA.java:84)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:534)
Caused by: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
at oracle.apps.fnd.common.Pool.createObject(Pool.java:1321)
at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:1062)
at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:752)
at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:256)
at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1951)
at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2617)
at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2550)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2408)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2212)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2126)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2139)
at oracle.apps.fnd.common.Context.getJDBCConnection(Context.java:1682)
at oracle.apps.fnd.cache.GenericCacheLoader.load(GenericCacheLoader.java:168)
at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1500)
... 31 more
Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-28000: the account is locked
at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1422)
at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1004)
at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:899)
at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:888)
at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:616)
at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:246)
at sun.reflect.GeneratedConstructorAccessor83.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at oracle.apps.fnd.common.Pool.createObject(Pool.java:1308)
... 44 more
Caused by: java.sql.SQLException: ORA-28000: the account is locked
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.O3log.receive2nd(O3log.java:510)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:279)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:371)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:551)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:351)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1409)
... 53 more
oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1509)
at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:362)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(ExtendedProfileStore.java:210)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:169)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:148)
at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1201)
at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1044)
at oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:1013)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:980)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:967)
at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:570)
at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:987)
at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:964)
at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:918)
at oracle.apps.fnd.common.AppsContext.<init>(AppsContext.java:752)
at oracle.apps.fnd.common.WebAppsContext.<init>(WebAppsContext.java:1002)
at oracle.apps.fnd.framework.server.OAUtility.getWebAppsContext(OAUtility.java:352)
at oracle.apps.fnd.framework.webui.OAServerDelegate.getWebAppsContext(OAServerDelegate.java:1684)
at oracle.apps.fnd.framework.webui.OAPageBean.createRFURL(OAPageBean.java:6153)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:730)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:509)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:430)
at _oa__html._OA._jspService(_OA.java:84)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:534)
Caused by: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
at oracle.apps.fnd.common.Pool.createObject(Pool.java:1321)
at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:1062)
at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:752)
at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:256)
at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1951)
at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2617)
at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2550)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2408)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2212)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2126)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2139)
at oracle.apps.fnd.common.Context.getJDBCConnection(Context.java:1682)
at oracle.apps.fnd.cache.GenericCacheLoader.load(GenericCacheLoader.java:168)
at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1500)
... 31 more
Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-28000: the account is locked
at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1422)
at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:1004)
at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:899)
at oracle.apps.fnd.security.AppsConnectionManager.localAppsConnect(AppsConnectionManager.java:888)
at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:616)
at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:246)
at sun.reflect.GeneratedConstructorAccessor83.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
at oracle.apps.fnd.common.Pool.createObject(Pool.java:1308)
... 44 more
Caused by: java.sql.SQLException: ORA-28000: the account is locked
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.O3log.receive2nd(O3log.java:510)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:279)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:371)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:551)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:351)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1409)
... 53 more
Solution :-
Please unlock the apps user
Example : -
SQL > alter user apps account unlock;