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 only internal […]

Loss of Oracle Responsibilities – Part 1 VPN & iExpense

Quick background about this post: Oracle eBusiness Suite Oracle Database 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 […]