Query to find the User preferences set for a User in Oracle Apps/EBS
Query to find the User preferences set for a User in Oracle Apps/EBS
We can use below query to check preferences set for a user. In this example I am checking the preferences set for user related to workflow/mails.
select * from fnd_user_preferences where PREFERENCE_NAME='MAILTYPE' and MODULE_NAME = 'WF' and user_name in ('HIMANSHU.SINGH');
select preference_value
from fnd_user_preferences
where user_name='HIMANSHU.SINGH'
and preference_name='MAILTYPE';
select distinct PREFERENCE_VALUE from fnd_user_preferences where PREFERENCE_VALUE like '%MAI%'
select PREFERENCE_VALUE
from FND_USER_PREFERENCES
where USER_NAME='-WF_DEFAULT-'
and MODULE_NAME='WF'
and PREFERENCE_NAME='MAILTYPE' ;
select * from wf_local_roles
where notification_preference in ('DISABLED','QUERY')
and orig_system='PER' and name in ('HIMANSHU.SINGH');
Some useful Commands/Scripts for ASM
Some useful Commands for ASM
I am sharing few useful commands related to ASM which can be used for DBA's.
1) Check if the ASM disk is a Member or not.
In the below example I am using condition to check the path because all my DISK name are configured with Instance name.
select path, header_status,name from v$asm_disk where header_status='MEMBER' and PATH like '%PROD%';
select path, header_status,name from v$asm_disk where header_status='FORMER' and PATH like '%PROD%';
2) List all DISK in ASM.
/usr/sbin/oracleasm listdisks
3) Find Serial Number for a DISK.
sudo /usr/local/bin/asm2serial "PROD_DATA01 PROD_DATA02"
PROD_DATA01 : 742b00000ac084 (/dev/mapper/inf01_asm_data08)
PROD_DATA02: 742b0000ac092 (/dev/mapper/inf01_asm_data09)
4) Find free and used space in DISKGROUP.
SELECT name, free_mb, total_mb, total_mb-free_mb "USED_MB", free_mb/total_mb*100 "%FREE" FROM v$asm_diskgroup;
5) Monitoring ASM Disk Operations
select GROUP_NUMBER, OPERATION, STATE, ACTUAL, SOFAR, EST_MINUTES from v$asm_operation;
If there is a operating going on (like rebalancing) the query will return some rows.
GROUP_NUMBER OPERA STAT ACTUAL SOFAR EST_MINUTES
------------ ----- ---- ---------- ---------- -----------
1 REBAL RUN 1 10 12
6) Find ASM Disks
select GROUP_NUMBER, NAME, PATH, STATE, TOTAL_MB, FREE_MB from v$asm_disk;
4) Find free and used space in DISKGROUP.
SELECT name, free_mb, total_mb, total_mb-free_mb "USED_MB", free_mb/total_mb*100 "%FREE" FROM v$asm_diskgroup;
5) Monitoring ASM Disk Operations
select GROUP_NUMBER, OPERATION, STATE, ACTUAL, SOFAR, EST_MINUTES from v$asm_operation;
If there is a operating going on (like rebalancing) the query will return some rows.
GROUP_NUMBER OPERA STAT ACTUAL SOFAR EST_MINUTES
------------ ----- ---- ---------- ---------- -----------
1 REBAL RUN 1 10 12
6) Find ASM Disks
select GROUP_NUMBER, NAME, PATH, STATE, TOTAL_MB, FREE_MB from v$asm_disk;
How to submit a concurrent program using the CONCSUB utility in Oracle Apps/EBS
In this post we are going to see how to submit a concurrent program using the CONCSUB utility
Syntax for CONCSUB utility
CONCSUB / \
[WAIT=N|Y|] \
CONCURRENT \
[PROGRAM_NAME=] \
LANGUAGE - R12 onwards only \
TERRITORY - R12 onwards only
[ORG_ID=<#>] - R12 onwards only
[REPEAT_TIME=] \
[REPEAT_INTERVAL= ] \
[REPEAT_INTERVAL_UNIT=< resubmission unit>] \
[REPEAT_INTERVAL_TYPE=< resubmission type>] \
[REPEAT_END=] \
[START=] \
[IMPLICIT=< type of concurrent request> \
[ ... ]
How to pass a parameter through CONCSUB:
Example:
'"08JUN96 23:55:00"'
Parameters and Meaning
Set WAIT=Y to have CONCSUB check the request status every 60 seconds and returns to the operating system prompt when the request is completed. One can also enter an integer value for a number of seconds, as in WAIT=30, for CONCSUB to check for request completion every
Attention: Using WAIT=Y or WAIT=
One may also use the PROGRAM_NAME parameter to indicate the batch that your request processes for programs that process a set of data, where there could be several requests for a given program that are active at the same time.
Attention: Do not use REPEAT_TIME with other resubmission parameters except for the optional parameters REPEAT_END and START.
Attention: Do not use REPEAT_INTERVAL and REPEAT_INTERVAL_UNIT with REPEAT_TIME.
Attention: Use REPEAT_INTERVAL_TYPE only if one uses REPEAT_INTERVAL.
DDMONRR HH24:MI:SS (as in 07APR02 18:32:05)
or
DDMONRRRR HH24:MI:SS (as in 07APR2002 18:32:05)
Note that because this date format includes a space, one must enclose the date in double quotation marks and single quotation marks. One can also specify just the date:
DDMONRR
or
DDMONRRRR
DDMONRR HH24:MI:SS (as in 07APR02 18:32:05)
Because this date format includes a space, one must enclose the date in double quotation marks and single quotation marks. If one does not specify a start time, the program submits immediately and is processed by the next available concurrent manager. The default value is the current time.
The value IMPLICIT=YES means that only the System Administrators privileged View Concurrent Requests form displays this request. Use this value if the request is not interesting to the user.
Specify IMPLICIT=ERROR or IMPLICIT=WARNING, respectively, if one wants the request to appear only if it fails or completes with warnings.
REPEAT_DAYS=1.5 resubmits the request every 36 hours.
Attention: Do not use REPEAT_DAYS with other re-submission parameters except for the optional parameters REPEAT_END and START.
Suggestion: REPEAT_DAYS will become obsolete in a future release. One may therefore want to use REPEAT_INTERVAL, REPEAT_INTERVAL_TYPE and REPEAT_INTERVAL_UNIT instead of REPEAT_DAYS.
Please note that the program specific parameters must be explicitly passed to CONCSUB, any default values that may be used when the program is submitted via the normal screens (ie Standard Report Submission or SRS) will not be used by CONCSUB.
Sample Examples:
In this example we are submitting concurrent request to gather stats of few schemas.
CONCSUB apps/apps FND 'System Administrator' SYSADMIN wait=N CONCURRENT FND FNDGSCST PROGRAM_NAME='"Gather Schema Statistics"' GL 10 '""' NOBACKUP '""' LASTRUN GATHER '""' N
CONCSUB apps/apps FND 'System Administrator' SYSADMIN wait=N CONCURRENT FND FNDGSCST PROGRAM_NAME='"Gather Schema Statistics"' XLA 10 '""' NOBACKUP '""' LASTRUN GATHER '""' N
CONCSUB apps/apps FND 'System Administrator' SYSADMIN wait=N CONCURRENT FND FNDGSCST PROGRAM_NAME='"Gather Schema Statistics"' ZX 10 '""' NOBACKUP '""' LASTRUN GATHER '""' N
CONCSUB apps/apps FND 'System Administrator' SYSADMIN wait=N CONCURRENT FND FNDGSCST PROGRAM_NAME='"Gather Schema Statistics"' AP 10 '""' NOBACKUP '""' LASTRUN GATHER '""' N
CONCSUB apps/apps FND 'System Administrator' SYSADMIN wait=N CONCURRENT FND FNDGSCST PROGRAM_NAME='"Gather Schema Statistics"' AR 10 '""' NOBACKUP '""' LASTRUN GATHER '""' N
Ref: How To Submit A Concurrent Request Using CONCSUB Syntax (Doc ID 457519.1)
How to Start/Stop services in Oracle Apps R12.2 on all nodes through single command
If we have a EBS instance in R12.2.x and it is configured with multiple nodes, then we can use the below commands to stop and start all services at one time.
This command will internally connect all the nodes via ssh as you would have enabled ssh as part of R12.2.x pre-requisites setup. If you have not enabled ssh, you will not be able to apply patches in remote nodes and it will get failed.
If we want to skip stopping of weblogic admin services then we can use below commands
To stop all services on all nodes
adstpall.sh apps/apps_password -mode=allnodes
To Start all services on all nodes
adstrtal.sh apps/apps_password -mode=allnodes
(The above commands will ask for WebLogic password)
This command will internally connect all the nodes via ssh as you would have enabled ssh as part of R12.2.x pre-requisites setup. If you have not enabled ssh, you will not be able to apply patches in remote nodes and it will get failed.
If we want to skip stopping of weblogic admin services then we can use below commands
adstpall.sh apps/apps -skipNM -skipAdmin
Subscribe to:
Posts
(
Atom
)
3 comments :
Post a Comment