Querying indexes on table and build script

Often times we are asked to rebuild indexes on tables, but are unaware of what all indexes are on the table. We can query dba_ind_columns to get indexes  on the columns or for general indexes against the table we can query dba_indexes. A general query would look like this: select owner,table_name,index_name from dba_indexes where table […]

Creating ‘LIKE’ users in the Oracle Database

This post I’m providing allows you to create a new database user modeled after an existing database user. We recently hired numerous dbas and wanted to provide the same access as existing dbas here. Using this script is permitted. As with any script on my blog or others please take caution. This has been verified […]

Tracing concurrent request and creating TKPROF

I) Generate Trace File 1) Enable Tracing for the Concurrent Program a) select the ‘Enable Trace’ Checkbox 2) Turn on Tracing a) Login as a user with ‘system administrator’ responsibility b) Navigate: Profiles > System c) Query Profile Option ‘Concurrent: Allow Debuggin’ d) Set profile to ‘YES’ 3) Run Concurrent Program with Tracing Turnv On […]

adpatch details and its options

Below is the help criteria for the adpatch command line utility. I plan on doing another piece on autopatch once I get some hands on with it. relpmgr:/home/relpmgr #adpatch help=y usage: adpatch [help=y] adpatch Pre-Install Mode [preinstall=y|n] adpatch Test Mode [apply=y|n] adpatch Non-Interactive mode [defaultsfile=<$APPL_TOP/admin/SID/defaultsfile>] [logfile=][interactive=y|n][workers=] [patchtop= ][driver=][restart=y|n] [abandon=y|n][wait_on_failed_job=y|n][stdin=y|n] adpatch [localworkers=][workers=] [printdebug=y|n][parallel_index_threshold= ] [order=] [flags=][options=] […]

Increasing speed of applying patches (eBusiness)

We recently went through our quarterly Oracle outage and had more than 30+ patches to install on 8 nodes. There are only 2 shared APPL_TOPS and 2 in the DMZ. This makes us have to install each patch 4 times. This process took 8+ hours to complete. We even had 15 rolled into a merge […]

Loss of Oracle Responsibilities – Part 2 Responsibility Trust Level

Oracle applications has many security features build in. Allowing responsibilities to be accessed internally and externally is just 1 example. At INSTABC there are many custom responsibilities that users and suppliers access. A particular responsibility called ‘IBU Normal User’ allows customers and employees to see Product information. During a recent deployment to relp.instabc.com only internal […]

Loss of Oracle Responsibilities – Part 1 VPN & iExpense

Quick background about this post: Oracle eBusiness Suite 11.5.10.2 Oracle Database 11.2.0.2 Cisco AnyConnect VPN Microsoft AD/DNS My company INSTABC uses eBusiness Suite for it’s application front end. We will call it ‘RELP’ for use in this post. Access is granted using the application itself. We do not do LDAP, Single Sign on or OID […]