DB : Getting the database environment variable in SQL propmt

Solution:

var OHM varchar2(1000);
EXEC dbms_system.get_env('ORACLE_HOME', :OHM);
print OHM

Windows : How to Check the number of Processor and cores

Solution:

Open Command prompt  and type the following commands:

To get the number of processors:

echo %NUMBER_OF_PROCESSORS%

To get the full details about CPU:

WMIC CPU Get /Format:List

EBS : SQL query to List the users on the system in the past N day

Solution:

select user_name,LAST_LOGON_DATE from FND_USER where USER_ID in ( select distinct user_id from icx_sessions where  last_connect > sysdate - N and user_id != '-N') order by 2;

Note: Substitute Value for N for the required number of days

EBS : Profile options to disable the personalization links in JSP pages EBS

Solution:

FND: Personalization Region Link Enabled - No
Personalize Self-Service Defn - No
Disable Self-Service Personal - No

EBS : Oracle EBS application page alignment issue

ISSUE:

Alignment of Buttons headers of the JSP pages are not aligned properly in IE but works fine in Chrome.

Solution:

1. Shutdown ALL services.

2. BACKUP the files in the following directories and then remove them :
Note: Once you complete these steps, all the above directories would still be present, but will be empty.
$OA_HTML/cabo/images/cache
$OA_HTML/cabo/styles/cache

3.Restart ALL services

4. Clear ALL browser cache and close ALL browser windows.

EBS : adrelink fails in RHEL 6+ while executing patches

Error:

Relink of module “MSONEW” failed.
…….
Relink of module “FEMCCE” failed.
…….
Relink of module “MSRNEW” failed.
…….
Relink of module “MSCCPP” failed.
…….
Relink of module “MSCMON” failed.
…….
Relink of module “MSCNEW” failed.
…….
Relink of module “MSCNSP” failed.
………
Relink of module “MSCNSPNM” failed.
………
Relink of module “MSCPCL” failed.
………
Relink of module “MSCPDW” failed.
………
Relink of module “MSCPRG” failed.
………
Relink of module “MSCSDW” failed.
………
Relink of module “MSCSLD” failed.
………


It asks us whether we want to continue patch session as Normal or else Stop

NO-Will stop the patch session and YES will allows us continue patching as if normal.

So to exit patch session type NO and once patch session ends. we have to perform below work around.

Solution:

To fix this problem, we are required to replace the following line under the Linux section of file ” $AD_TOP/bin/adrelinknew.sh”:

From:

CPP='g++'
CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh'

TO:

CPP='g++'
CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh -Wl,--noinhibit-exec'

DB : Space Used Free %used for Each Datafiles

SET PAGESIZE 60
SET LINESIZE 300
COLUMN "Tablespace Name" FORMAT A22
COLUMN "File Name" FORMAT A82

SELECT  Substr(df.tablespace_name,1,20) "Tablespace Name",
        Substr(df.file_name,1,80) "File Name",
        Round(df.bytes/1024/1024,0) "Size (M)",
        decode(e.used_bytes,NULL,0,Round(e.used_bytes/1024/1024,0)) "Used Space(M)",
        decode(f.free_bytes,NULL,0,Round(f.free_bytes/1024/1024,0)) "Free Space(M)",
        decode(e.used_bytes,NULL,0,Round((e.used_bytes/df.bytes)*100,0)) "% Used"
FROM    DBA_DATA_FILES DF,
       (SELECT file_id,
               sum(bytes) used_bytes
        FROM dba_extents
        GROUP by file_id) E,
       (SELECT Max(bytes) free_bytes,
               file_id
        FROM dba_free_space
        GROUP BY file_id) f
WHERE    e.file_id (+) = df.file_id
AND      df.file_id  = f.file_id (+)
ORDER BY df.tablespace_name,
         df.file_name
/