A crontab file has five fields for specifying day , date and time followed by the command to be run at that interval. #—————————————————————————————— #…
Leave a CommentAuthor: Brijesh Gogia
I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
[sc name="linkedin"][/sc]
Basic information on the types of tables that are there in EBS database which every Apps DBA should be aware of. Table-types and names used…
Leave a CommentThere are various components in Oracle Applications setup. Below commands can be used to find the exact version of the components: FIND APPS VERSION (11i/R12)…
1 CommentOracle provides a utility called FNDCPASS that allows you to change passwords in batch mode. It is highly advisable to back up the FND_ORACLE_USERID table…
2 CommentsCouple of Oracle Application Concurrent Manager related scripts which we use frequently. A) UNDER WHICH MANAGER THE REQUEST WAS RUN SELECT b.user_concurrent_queue_name FROM fnd_concurrent_processes a…
2 CommentsBelow are some of the useful scripts related to Oracle Applications database
–FIND DATABASE SIZE
select 'DATA_n_INDEX: ' || sum(bytes)/1024/1024/1024 || ' GBytes' DATABASE_SIZE from dba_data_files union select 'TEMP: ' || sum(bytes)/1024/1024/1024 || ' GBytes' from dba_temp_files union select 'REDO LOGS: ' || sum(bytes)/1024/1024/1024 || ' GBytes' from v$log union select 'CONTROLFILE: ' || sum(FILE_SIZE_BLKS*BLOCK_SIZE)/1024/1024 || ' MBytes' from v$controlfile;3 Comments
The look and feel of the Self Service EBS Application gets distorted with fonts showing garbled/distorted as shown below Below solutions have helped us…
Leave a CommentA Multipath disk provide failover by using redundant physical path components, eliminating a single point of failure with the Storage Area Network (SAN). Multipathing is a software technology…
3 CommentsMany times proper functioning of application demands that the account/password of the OS (Linux/UNIX) user which owns the application should not expire. chage is the OS…
Leave a CommentThe Data Guard broker logically groups primary and standby databases in a Data Guard setup into a broker configuration that allows the broker to manage and monitor…
Leave a Comment