KOTC Posted March 14, 2013 Author Report Posted March 14, 2013 You most probably don't need RMAN catalog database https://plus.google.com/u/1/107075205411714880234/posts/RWgbSJzmeRt
KOTC Posted March 14, 2013 Author Report Posted March 14, 2013 [b][color=#000000][font=Tahoma, Verdana, Helvetica, sans-serif][b][right]TFA Collector- The Preferred Tool for Automatic or ADHOC Diagnostic Gathering Across All Cluster Nodes [ID 1513912.1][/right][/b][/font][/color][/b]
Joey_Tribbiani Posted March 14, 2013 Report Posted March 14, 2013 script deniki kavalo cheppandi bhayya , i can help !!
Joey_Tribbiani Posted March 14, 2013 Report Posted March 14, 2013 Collection of Scripts !! http://www.oracle-base.com/dba/scripts.php
KOTC Posted March 18, 2013 Author Report Posted March 18, 2013 Database thursday night ki point of recovery cheyali? naku thursday night di incremental database backup undi?so point of recovery time e time di petali?after the backup right?
KOTC Posted March 20, 2013 Author Report Posted March 20, 2013 RMAN>backup database; ante ani datafiles backup avaledhu,kani eppudu aithe sql nuchi V$rman views lo emo DBFULL ani chupistundi kani oka datafile matram backup avaledhu.
KOTC Posted March 20, 2013 Author Report Posted March 20, 2013 ORACLE RAC meda rolling patch apply chesina vallu evaru ayina unnaru,unte koncham documentation share cheyandi vayaa
CheGuevara Posted March 20, 2013 Report Posted March 20, 2013 [quote name='STFU' timestamp='1363811384' post='1303458440'] ORACLE RAC meda rolling patch apply chesina vallu evaru ayina unnaru,unte koncham documentation share cheyandi vayaa [/quote] em documentation kavali..em patch vestunnav
KOTC Posted March 20, 2013 Author Report Posted March 20, 2013 [quote name='CheGuevara' timestamp='1363811455' post='1303458449'] em documentation kavali..em patch vestunnav [/quote] PSU patches for oracle RAC 11.2.0.3.0 to [color=#333333][font=Tahoma, Verdana, Helvetica, sans-serif][size=2][background=rgb(250, 250, 250)]11.2.0.3.5 [/background][/size][/font][/color]
CheGuevara Posted March 20, 2013 Report Posted March 20, 2013 [quote name='STFU' timestamp='1363811936' post='1303458533'] PSU patches for oracle RAC 11.2.0.3.0 to [color=#333333][font=Tahoma, Verdana, Helvetica, sans-serif][size=2][background=rgb(250, 250, 250)]11.2.0.3.5 [/background][/size][/font][/color] [/quote] em help kavali neeku andulo...read me lo untadi kda patch ela veyyalo...what more are you looking for?
KOTC Posted March 20, 2013 Author Report Posted March 20, 2013 [quote name='CheGuevara' timestamp='1363813581' post='1303458710'] em help kavali neeku andulo...read me lo untadi kda patch ela veyyalo...what more are you looking for? [/quote] http://learnwithme11g.wordpress.com/2011/05/05/applying-psu-patch-11-2-0-1-2-to-a-two-node-rac/ ila evaru ayina chesara ani,read me chusa.but already evaru ayina chesi unte easy ga avutundi ani
KOTC Posted March 25, 2013 Author Report Posted March 25, 2013 evaru ayin PSU interim patch apply chesara RAC ki andulo oka doubt OCM(oracle configuration manager) [b] . OCM Configuration.[/b] [color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][indent=1]Create ocm response file using the following command and provide appropriate values for the prompts.[/background][/size][/font][/color][/indent] [color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][indent=1.8][i]$GRID_ORACLE_HOME/OPatch/ocm/bin/emocmrsp[/i][/background][/size][/font][/color][/indent] [color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][indent=1]Verify the created file using,[/background][/size][/font][/color][/indent] [color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][indent=1.8][i]$GRID_ORACLE_HOME/OPatch/ocm/bin/emocmrsp –verbose ocm.rsp[/i][/background][/size][/font][/color][/indent] [color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][indent=1]NOTE: The Opatch utility will prompt for your OCM (Oracle Configuration Manager) response file when it is run. Without which we cant proceed further.[/background][/size][/font][/color][/indent] [color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][indent=1]http://learnwithme11g.wordpress.com/2011/05/05/applying-psu-patch-11-2-0-1-2-to-a-two-node-rac[/background][/size][/font][/color][/indent] [background=rgb(250, 252, 255)][indent=1][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2]3 point lo na GRID_HOME/Opatch/ocm travtha bin emocmrsp ledhu na environment lo [/size][/font][/color][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2]evaru ayina chesara a OCM response file ela create chestara /bin/emocmrsp lekapothe. [/size][/font][/color][/background][/indent] [background=rgb(250, 252, 255)][indent=1][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2]asalu $GRID_HOME/Opatch/ocm --ikkada bin folder e ledhu na envi loo[/size][/font][/color][/background][/indent] [color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][indent=1]http://www.oracleportal.org/knowledge-base/oracle-database/database-administration/installation-and-patching/general/how-to-create-an-ocm-response-file.aspx[/background][/size][/font][/color][/indent]
CheGuevara Posted March 25, 2013 Report Posted March 25, 2013 [quote name='STFU' timestamp='1364233801' post='1303484776'] evaru ayin PSU interim patch apply chesara RAC ki andulo oka doubt OCM(oracle configuration manager) [b] . OCM Configuration.[/b] [indent=1]Create ocm response file using the following command and provide appropriate values for the prompts.[/indent] [indent=1][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)]8][i]$GRID_ORACLE_HOME/OPatch/ocm/bin/emocmrsp[/i][/background][/size][/font][/color][/indent] [indent=1][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)]Verify the created file using,[/background][/size][/font][/color][/background][/size][/font][/color][/indent] [indent=1][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)]8][i]$GRID_ORACLE_HOME/OPatch/ocm/bin/emocmrsp –verbose ocm.rsp[/i][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color][/indent] [indent=1][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)]NOTE: The Opatch utility will prompt for your OCM (Oracle Configuration Manager) response file when it is run. Without which we cant proceed further.[/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color][/indent] [indent=1][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][url="http://learnwithme11g.wordpress.com/2011/05/05/applying-psu-patch-11-2-0-1-2-to-a-two-node-rac"]http://learnwithme11...-a-two-node-rac[/url][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color][/indent] [indent=1][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2]3 point lo na GRID_HOME/Opatch/ocm travtha bin emocmrsp ledhu na environment lo [/size][/font][/color][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2]evaru ayina chesara a OCM response file ela create chestara /bin/emocmrsp lekapothe. [/size][/font][/color][/background][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color][/indent] [indent=1][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][background=rgb(250, 252, 255)][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2]asalu $GRID_HOME/Opatch/ocm --ikkada bin folder e ledhu na envi loo[/size][/font][/color][/background][/background][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color][/indent] [indent=1][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][background=rgb(250, 252, 255)][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][url="http://www.oracleportal.org/knowledge-base/oracle-database/database-administration/installation-and-patching/general/how-to-create-an-ocm-response-file.aspx"]http://www.oraclepor...ponse-file.aspx[/url][/background][/size][/font][/color][/background][/background][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color][/indent] [color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][background=rgb(250, 252, 255)][background=rgb(250, 252, 255)][color=#2A2A2A][font=Verdana, Tahoma, Arial, sans-serif][size=2][background=rgb(250, 252, 255)][/quote][/background][/size][/font][/color][/background][/background][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color] i didnt do all this. Read me lo unna instructions follow ayya ante...
Joey_Tribbiani Posted March 25, 2013 Report Posted March 25, 2013 Can we change User passwords when DB is just mounted / not opened ?
KOTC Posted March 25, 2013 Author Report Posted March 25, 2013 [quote name='CheGuevara' timestamp='1364234721' post='1303484871'] [/background][/size][/font][/color][/background][/background][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color][/background][/size][/font][/color] i didnt do all this. Read me lo unna instructions follow ayya ante... [/quote] docment em ayina chesava?
Recommended Posts