TKPROF

TKPROF

Obtain the trace file. The below will give the location on the database server:

select name, value from v$diag_info where name like '%Trace%';

OR

select name, value from v$parameter where name like 'user_dump_dest'

2. Convert to TKPROF

tkprof <filename.trc> <output_filename_SORT.txt> explain=apps/<password> sort='(prsela,exeela,fchela)' 

Oracle Listener (LSNRCTL)

>> Display Oracle Listener Status

$ lsnrctl status
>> Start Oracle Listener
$ lsnrctl start

>> Stop Oracle Listener
$ lsnrctl stop

>> Restart Oracle Listener
$ lsnrctl reload

>> Available Listener Commands 
$ lsnrctl help

• start - Start the Oracle listener
• stop - Stop the Oracle listener
• status - Display the current status of the Oracle listener
• services - Retrieve the listener services information
• version - Display the oracle listener version information
• reload - This will reload the oracle listener SID and parameter files. This is equivalent to lsnrctl stop and lsnrctl start.
• save_config – This will save the current settings to the listener.ora file and also take a backup of the listener.ora file before overwriting it. If there are no changes, it will display the message “No changes to save for LISTENER”
• trace - Enable the tracing at the listener level. The available options are ‘trace OFF’, ‘trace USER’, ‘trace ADMIN’ or ‘trace SUPPORT’
• spawn - Spawns a new with the program with the spawn_alias mentioned in the listener.ora file
• change_password – Set the new password to the oracle listener (or) change the existing listener password.
• show - Display log files and other relevant listener information.

>> Help menu for specific listener command
$ lsnrctl help show

Grant ACL to APPS account Oracle 11g

Grant ACL to APPS account Oracle 11g
 
1. Check if view dba_network_acls has any row. If yes, run below script to add privilege to APPS account:

DECLARE
acl_path VARCHAR2(4000);
BEGIN
SELECT acl INTO acl_path FROM dba_network_acls
WHERE host = '<SERVER NAME>' AND lower_port IS NULL AND upper_port IS NULL;
IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(acl_path,'APPS','connect') IS NULL THEN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl_path,'APPS', TRUE, 'connect');
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl_path,'APPS', TRUE, 'resolve');
END IF;
EXCEPTION
WHEN no_data_found THEN
-- below lines will create a ACL
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('apps.xml','ACL description', 'APPS', TRUE, 'connect');
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE('apps.xml','APPS', TRUE, 'resolve');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('apps.xml','<SERVER NAME>');
END;
/

SQL> commit;


SQL> select * FROM dba_network_acls;
SQL> select * from dba_network_acl_privileges;

Below two queries should return 1:

SQL> select DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE('/sys/acls/apps.xml','APPS','connect') from dual;

SQL> select DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE('/sys/acls/apps.xml','APPS','resolve') from dual;

NOTE: If view dba_network_acls has no data. You will need to create ACL for the user:
SQL> show user
USER is "SYS"

BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('apps.xml','APPS acess for UTL', 'APPS', TRUE, 'connect');
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => 'apps.xml', principal => 'APPS',is_grant => true, privilege => 'resolve');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('apps.xml','<SERVER NAME>');
END;
/

Sometimes, the domain name makes difference. It does not hurt to add full name to the access list:

BEGIN
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('apps.xml','SERVER_NAME.domain.com');
END;
/

SQL> commit;

NOTE:  If things does not work, you can start over by dropping entries in dba_network_acls.

SQL> begin
DBMS_NETWORK_ACL_ADMIN.DROP_ACL('apps.xml');
commit;
end;
/

Now dba_network_acls, dba_network_acl_privileges, net$_acl should have nothing on apps.xml and everything no ACL is cleaned up.
SQL> select * from dba_network_acls;
SQL> select * from dba_network_acl_privileges;
SQL> select * from net$_acl;

Could not get vmci driver version: The handle is invalid.

Could not get vmci driver version: The handle is invalid.

While starting VMWARE encountered below error :-

Could not get vmci driver version: The handle is invalid.
You have an incorrect version of driver "vmci.sys". Try reinstalling VMware Workstation.
Module DevicePowerOn power on failed.

SOLUTION :-
Search for in the base folder of installed VMWARE machine.

Example
If you have installed VNWARE in drive C and its machine e.g PROD1 in location E:\PROD1 then you need to go to PROD1 folder NOT on base VMWARE installed location.

Search for file named with extension .vmx
eg. PROD1.vmx
Open it with notepad


CHANGE below mentioned value
vmci0.present = "TRUE"
TO
vmci0.present = "FALSE"

Save and try to starting your machine.

ircntf.wft fails with: ITEM_TYPE ‘WFSTD’ is protected …

ircntf.wft fails with: ITEM_TYPE ‘WFSTD’ is protected …

Error message:
FAILED: file ircntf.wft on worker 1.

Access level: 20, Mode: UPGRADE
ITEM_TYPE ‘WFSTD’ is protected, no changes were saved.
ITEM_ATTRIBUTE ‘WFSTD/EVENTNAME’ is customized, no changes were saved.
ITEM_ATTRIBUTE ‘WFSTD/N’ is protected, no changes were saved.
…

Solution:
1. Run WFLOAD with FORCE option as the applmgr user:
$FND_TOP/bin/WFLOAD apps/<apps pwd> 0 Y FORCE $IRC_TOP/patch/115/import/US/ircntf.wft
2. Use adctrl hidden option #8, to skip the failed job.

Reference:
IRCNTF.WFT Fails During R12.1.1 Upgrade (Doc ID 1329530.1).
Oracle Support advice is to skip this error and complete the upgrade. This error should not impact any iRecruitment functionality apart from Generic Notifications in iRecruitment which is introduced in 12.1. Furthermore they suggest to apply Patch 9371492: IRCNTF.WFT FAILS DURING R12.1.1 UPGRADE. This isn’t possible during deployment of patch 6678700, so I run WFLOAD with the FORCE optio