Archive for May, 2008
SQL Script to generate privileges to be granted
Imagine you want to grant same exact privileges of existing user A to User B.
Login as a user who has a dba privilege and run below command to generate the list of privileges to be granted.
select
‘grant ‘ || privilege || ‘ on ‘ || owner || ‘.’ || table_name || ‘ to USER B;’
from
dba_tab_privs
where
grantee = [...]
SQL Script to list object privileges granted to a particular user
Login to database as sys / system / or any user who had dba privileges and run below command
select grantor || ‘ granted ‘ || privilege || ‘ on ‘ || table_name || ‘ owned by ‘|| owner || ‘ to ‘|| grantee
from dba_tab_privs where grantee like upper(‘&GRANTEE_NAME’) order by privilege;
where GRANTEE_NAME is the user [...]
R12 RUP4 Issue (6435000) with ce6157444.sql / ce5928260.sql
Last week, when i was applying RUP4 (6435000), i faced couple of issues:
1) Apps account was getting locked for no reason. After running for 2 to 3 hrs, patch would start failing with message “apps account is locked”. This was quite wierd and we didnt face this issue applying RUP4 in other environments. Simple solution [...]
How to compile a single jsp file in Oracle Applications 11i/R12
You can follow below steps to compile a single jsp file (seeded or custom) in Oracle Applications 11i/R12.
1. Copy the jsp file to $COMMON_TOP/webapps/oacore/html (this location translates to $OA_HTML).
Placing the file under $OA_HTML enables end users to access the file using the url http://hostname.domain:port/OA_HTML/[jspfile.jsp]
2. export PATH=$PATH:$FND_TOP/patch/115/bin
3. ojspCompile.pl – -compile -s ‘[jspfile.jsp]‘ (no space [...]
srvctl command line options
Thought this might be helpful.
Usage: srvctl [-V]
Usage: srvctl add database -d -o [-m ] [-p ] [-A /netmask] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY}] [-s ] [-n ] [-y {AUTOMATIC | MANUAL}]
Usage: srvctl add instance -d -i -n
Usage: srvctl add service -d -s -r “” [-a ""] [-P ]
Usage: [...]
Oracle Applications – 11i / R12 – Missing Patches Analysis
Every organisation has more than one oracle apps instance for different purpose viz., PROD, TEST, DEV etc. and generating a report on missing apps patches on the available instances is a pain if it has to be done manually.
Often, the TEST instances will have more patches when compared to PROD, reason being first the patch [...]
Diagnostics link is missing on the web page?
The diagnostics link on the self service page is controlled by two profile options “FND:Diagnostics” & “Personalize Self-Service Defn”
If the value is set to YES (default in R12) the link will appear if its set to NO it wont.
for more information check metalink note id: 400042.1
cheers,
OraclePitStop
How to identify to which mid-tier you are/will be connected to on a multi-node R12 environment?
Imagine you have a multi-node Oracle Apps R12 setup with 2 node RAC. How would you identify to which server you are/will be connected to when you issue the url. Obviously when you have multi-node setup, you will be accessing the login page using a virtual URL.
1. Open Internet Explorer or Firefox
2. Type in the [...]
How to copy / migrate printer definitions to a new instance using FNDLOAD
Imagine below situation:
1. Target had been cloned from source
2. Couple of new printers had been configured on source after the clone.
3. Now you want the same printer configurations on target instance similar to source.
Options:
1. Perform the steps manually on target instance
2. Clone target from source
3. Use FNDLOAD (Generic Loader Utility)
We will discuss FNDLOAD option in [...]
« Previous Entries
