Archive for December, 2008
Single Putty Window – Multiple Tabs – for multiple server connections
Is it possible to have a tabbed putty like firefox or internet explorer? Yes you can, check out below URL
Turbocharge PuTTY with 12 Powerful Add-Ons – Software for Geeks #3
Look for Putty connection Manager.
cheers,
OraclePitStop.
How to migrate PUTTY settings from one windows desktop/laptop to the other?
Migrating putty settings from one desktop/laptop to the other box comes in handy when you had already customized your putty with saved sessions. The migration will also help a new member of an exisitng DBA support team.
Here are the steps
Start -> Run (or Windows Button + R)
Type in ‘regedit’ and press enter – this command will open the registry editor window
Go to HKEY_CURRENT_USER -> Software -> SimonTatham
Right Click on SimonTatham and select Export
Provide a file name and save the file.
Copy and execute the exported file on the new box – voila .. you are all set with the putty on the new box.
Note: this will only bring the putty configurations and NOT the putty executable itself.
cheers,
OraclePitStop
Oracle Apps R12 : How to find the list of responsibilities assigned to user(s)
SELECT FURGA.USER_ID
, FU.USER_NAME
, FURGA.RESPONSIBILITY_ID
, FRTL.RESPONSIBILITY_NAME
, FURGA.RESPONSIBILITY_APPLICATION_ID
, FA.APPLICATION_SHORT_NAME
, FURGA.SECURITY_GROUP_ID
, FSG.SECURITY_GROUP_KEY
, FURGA.START_DATE
, FURGA.END_DATE
, FURGA.CREATED_BY
, FUCB.USER_NAME
, FURGA.CREATION_DATE
, FURGA.LAST_UPDATED_BY
, FULUB.USER_NAME
, FURGA.LAST_UPDATE_DATE
, FURGA.LAST_UPDATE_LOGIN
, FULUL.USER_NAME
FROM
FND_USER_RESP_GROUPS_ALL FURGA,
FND_USER FU,
FND_USER FUCB,
FND_USER FULUB,
FND_USER FULUL,
FND_APPLICATION FA,
FND_RESPONSIBILITY_TL FRTL,
FND_SECURITY_GROUPS FSG
WHERE
FURGA.USER_ID = FU.USER_ID (+)
AND FURGA.CREATED_BY = FUCB.USER_ID (+)
AND FURGA.LAST_UPDATED_BY = FULUB.USER_ID (+)
AND FURGA.LAST_UPDATE_LOGIN = FULUL.USER_ID (+)
AND FURGA.RESPONSIBILITY_APPLICATION_ID = FA.APPLICATION_ID (+)
AND FURGA.RESPONSIBILITY_ID = FRTL.RESPONSIBILITY_ID (+)
AND FRTL.LANGUAGE = ‘US’
AND FURGA.SECURITY_GROUP_ID = FSG.SECURITY_GROUP_ID (+)
ORDER BY START_DATE;
— ADD CONDITION ON START_DATE FOR RESPONSIBILITIES ADDED AFTER A SPECIFIC DATE LIKE “WHERE FURGA.START_DATE > TO_DATE(’22-JUL-2008′)”
cheers,
OraclePitStop
dbca – Creating RAC Database using dbca in silent mode
During the course of the DBA life, we all know how irritating it is to create a DB or to install a Oracle Software on a UNIX Flavour box from a remote machine using a X – Server. Each click would take minutes to react (My favourite is the tab button on the keyboard) but still at-times we have to make use of the mouse. Anyways, recently we installed 10203 on a HP server which already has cluster setup. Everything went good in terms of 10201 installation, 10203 upgrade (both binaries) and even dbca 14 screens. But nothing happened when clicked on the finish button in dbca (14th screen). No useful information in the log files. I pressed cancel and re-launched it again and did the dbca exercise all the way till the end, still no luck. By this time my patience level was minus 25. It is at this stage i thought how about creating the database in silent mode and you know what, creating the DB in silent mode is 200 times faster than the GUI and the db creation completed in less than 5 minutes.
Syntax to create a General Purpose RAC Database on a Cluster File System.
dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName opitstop -sid opitstop -sysPassword opitstop123 -systemPassword opitstop123 -emConfiguration NONE -datafileDestination /opt/oracle/oradata/opitstop -storageType CFS -nodelist RAC_NODE_1,RAC_NODE_2 -characterSet WE8IS08859P15 -listeners opitstop -memoryPercentage 30 -continueOnNonFatalErrors true
Place above command in a .sh file (shell script) say createRACDB.sh and just run it. Before running the script make sure the cluster services (crs) are running and also you have user equivelance between the rac nodes for the oracle owner ie., eg. if the oracle owner username is oraracdb in RAC_NODE_1 and RAC_NODE_2 then when you do a ssh from RAC_NODE_1 to RAC_NODE_2 it should go without asking for the password.
There are more options available with dbca. Some of them are -createDatabase, -createTemplateFromDB, -createCloneTemplate, -generateScripts, -deleteDatabase, -configureASM, -deleteInstance. For a complete list of the usage execute dbca -help.
DBCA Log Location: $ORACLE_HOME/cfgtoollogs/dbca/[SID]
Happy DB creation(s) !!!
cheers,
OraclePitStop.
Interesting enhancements in 12.0.6 – R12.ATG_PF.A.DELTA.6
Oracle Applications Technology Stack Release Update Pack 6 (R12.ATG_PF.A.DELTA.6)
Autoconfig has two new options
1. Parallel Mode
2. Profile Mode
Parallel Mode
This mode enables autoconfig to be executed parallel across all mid-tiers. Oh man, i love this feature … it really helps when you have multiple mid-tiers.
Just add -parallel to your normal adconfig command
Profile Mode
This option provides a drill down HTML report of the autoconfig run.
Just add -profile to your normal adconfig command
For more information on above options refer to Metalink Note 742110.1
cheers,
OraclePitStop
OraclePitStop - Lets share some knowledge 