Browse by Category
Browse by category
Author:mukesh kumar
DBA
DBA
finding installed patches in apps
select DRIVER_FILE_NAME
from AD_PATCH_DRIVERS
/
select DRIVER_FILE_NAME
from AD_PATCH_DRIVERS
where DRIVER_FILE_NAME like '%3258830%';
5. Pin SGA packages
from AD_PATCH_DRIVERS
/
select DRIVER_FILE_NAME
from AD_PATCH_DRIVERS
where DRIVER_FILE_NAME like '%3258830%';
5. Pin SGA packages
The Installation Manual also suggests that if database objects are updated by the patch (a ‘D’ driver is run), the scripts ADXGNPIN.sql and ADXGNPNS.sql are run again to pin new packages and sequences in your Oracle System Global Area. Details on this function are also documented in the Installation Manual.
* To find the latest application version */
select
ARU_RELEASE_NAME||'.'||MINOR_VERSION||'.'||TAPE_VERSION version,
START_DATE_ACTIVE updated,ROW_SOURCE_COMMENTS "how it is done",
BASE_RELEASE_FLAG "Base version" FROM AD_RELEASES where
END_DATE_ACTIVE IS NULL
select a.DRIVER_FILE_NAME,b.patch_level
from
AD_PATCH_DRIVERS a, AD_PATCH_DRIVER_MINIPKS b
where
DRIVER_FILE_NAME like '%3258830%'
and
a.PATCH_DRIVER_ID=b.PATCH_DRIVER_ID
and
app_short_name=:SHort_name
Latest postings
Oracle applications version details
Oracle Apps Version select release_name from apps.fnd_product_Groups; Application AD patch set select patch_level from fnd_product_installation... more >>
Oracle Apps Version select release_name from apps.fnd_product_Groups; Application AD patch set select patch_level from fnd_product_installation... more >>
Database users with deadly system privilages assigned to them.
select grantee, privilege, admin_optionfrom sys.dba_sys_privs where (privilege like '% ANY %' or privilege in ('BECOME USER', 'UNLIMITED TABLESP... more >>
select grantee, privilege, admin_optionfrom sys.dba_sys_privs where (privilege like '% ANY %' or privilege in ('BECOME USER', 'UNLIMITED TABLESP... more >>
Important tables in oracle APPS
Concurrent Manager FND_CONCURRENT_QUEUES FND_CONCURRENT_PROGRAMS FND_CONCURRENT_REQUESTS FND_CONCURRENT_PROCESSES FND_CONCURRENT_QUEUE_SIZE FND ... more >>
Concurrent Manager FND_CONCURRENT_QUEUES FND_CONCURRENT_PROGRAMS FND_CONCURRENT_REQUESTS FND_CONCURRENT_PROCESSES FND_CONCURRENT_QUEUE_SIZE FND ... more >>
trigger for preventing tools on oracle DB
CREATE OR REPLACE TRIGGER block_tools_from_prod AFTER LOGON ON DATABASEDECLARE v_prog sys.v_$session.program%TYPE;BEGIN SELECT program INTO v_prog ... more >>
CREATE OR REPLACE TRIGGER block_tools_from_prod AFTER LOGON ON DATABASEDECLARE v_prog sys.v_$session.program%TYPE;BEGIN SELECT program INTO v_prog ... more >>
Business
Current Trends in Software Testing
Agile testing, E2E testing, Customer Experience Testing, Increm... more >>
By Nita Bhupatrai
Agile testing, E2E testing, Customer Experience Testing, Increm... more >>
By Nita Bhupatrai
Good Read : The Recession: A Silver Lining for Corporate Recruiters
The Recession: A Silver Lining for Corporate Recruiters Posted b... more >>
By Hariharan Janardhanan
The Recession: A Silver Lining for Corporate Recruiters Posted b... more >>
By Hariharan Janardhanan
TRONICA CITY GHAZIABAD
Tronica City is sprawled over nearly 1300 acres of land in the No... more >>
By deepak tiwari
Tronica City is sprawled over nearly 1300 acres of land in the No... more >>
By deepak tiwari
A history on how US responded to financial crisis in the past
Banks failed, stock prices collapsed, and panic descended on Wall... more >>
By shiva m
Banks failed, stock prices collapsed, and panic descended on Wall... more >>
By shiva m
How to Manage a Deadbeat Employee
A deadbeat employee is an employer's nightmare. You know the emp... more >>
By Soumya Adhikary
A deadbeat employee is an employer's nightmare. You know the emp... more >>
By Soumya Adhikary
Guest contributors
Our sponsors