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.

ccg installation

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

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

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
THALAIMUTHU	Application Developer
THALAIMUTHU	System Administrator
THALAIMUTHU	Oracle Sales Administrator
THALAIMUTHU	Quality
THALAIMUTHU	Bills of Material
THALAIMUTHU	Inventory
THALAIMUTHU	Workflow Administrator Web Applications
THALAIMUTHU	Order Management Super User
THALAIMUTHU	Oracle Pricing Manager
THALAIMUTHU	CRM Resource Manager
THALAIMUTHU	CRM Task Manager
THALAIMUTHU	SFM System Administrator
THALAIMUTHU	Quoting Sales Manager
THALAIMUTHU	Customer Support
THALAIMUTHU	CRM Administrator
THALAIMUTHU	CRM HTML Administration
THALAIMUTHU	Call Center Administration
THALAIMUTHU	Oracle Installed Base Admin
THALAIMUTHU	Oracle Installed Base User
THALAIMUTHU	CRM Application Foundation User
THALAIMUTHU	CRM Employee
THALAIMUTHU	XML Publisher Administrator
THALAIMUTHU	Workflow Administrator Event Manager
THALAIMUTHU	Workflow Administrator Web (New)
THALAIMUTHU	Workflow User Web (New)
THALAIMUTHU	Number Management
THALAIMUTHU	Number Management User
THALAIMUTHU	Qtel Installation Team
THALAIMUTHU	Qtel BackOffice Responsibility
THALAIMUTHU	NMS Admin
THALAIMUTHU	Call Center Agent
THALAIMUTHU	Ban 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>