tag:blogger.com,1999:blog-38611852882688984762024-02-19T16:23:00.867+11:00DBA Daily Telegraphgoryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.comBlogger52125tag:blogger.com,1999:blog-3861185288268898476.post-56659690617581141202011-11-07T23:51:00.001+11:002011-11-07T23:51:32.056+11:00RMAN duplicate in details
(originally published at Pythian)
Its all started from the question on communities.oracle.comAn "enhancement" in 11.2 prevents RMAN duplicating non self-contained subset of a databasewhere new feature of RMAN in 11.2 was shown which prevents duplication of sets of tablespaces if they are not self-contained.I took debug of duplication and figured out that RMAN internally executes procedure goryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-67388124147342243162011-10-12T21:37:00.004+11:002011-11-15T09:56:29.991+11:00Dear DBA_SCHEDULER_RUNNING_JOBS, where have you been?!
originally published at Pythian
(story based on real events) Where: Meeting room, Pythian office, Sydney, Australia.When: Afternoon, after lunch time.What: Discussion of planned maintenance for one of clients.DBA1: We should check DBA_JOBS_RUNNING and DBA_SCHEDULER_RUNNING_JOBSthat there are no running jobs. And if there are no any we should continue with next step of our plan.DBA2: Do you mean goryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-90598083589167410302011-08-23T11:08:00.006+10:002011-08-30T10:33:41.262+10:00RDBMS Online Patching(originally published at Pythian)
If you support Oracle RDBMS 11.2.0.2 and want to zero downtime applying
patches to databases then it is time to have a look at new possibility
of Online Patching delivered with 11.2.0.2 version and described here
RDBMS Online Patching Aka Hot Patching [ID 761111.1]
The syntax is "opatch apply online -connectString ... " but I could not find description
of the goryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-59645535799482475082011-08-22T22:58:00.020+10:002011-08-26T10:36:45.517+10:00CheckSystemSpace ignorance(originally published at Pythian)
Every installation is unique. It can be the same software and hardware
but one installation will squease you like a lemon in jucier another one
will make you feel that you and only you is the boss here.
The way how it behaves depends not only on stars location and on
Saturn position in Zenith but also on how scripts finished, what SA did not
implement and changegoryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-69008139260159757792011-07-26T14:21:00.008+10:002011-07-27T21:34:21.337+10:00MOS KB articles for July 27, 2011Checking recent articles I noticed that there are lots of Master Note type of notesappeared on MyOracleSupport that come like aggregation of different linksrelated to topics. Exadata, RAC, Data Guard, Data Warehousing, etc..It might be very useful when problems appeared or when knowledgeabout the technology should be gotten. I wish those topics had RSSfeeds that can keep you informed about goryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-41262434913153072142011-07-20T21:08:00.007+10:002011-07-20T22:05:51.067+10:00MOS KB articles for July 20, 2011During search in knowledge base on My Oracle Support site noticedthat now list of prompts appears based on typed letters, words.It can be helpful despite results of search do not even have the samephrase which were selected from suggested list.Another observation - combination "ORA-" does not show any match,might be because of too long list of similarities?Today's Hot Topics e-mail got list of goryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-53059506692753537192011-07-19T21:53:00.007+10:002011-07-19T22:20:08.103+10:00MOS KB articles for July 19, 2011Several articles in Hot Topics e-mails drew my attention today:10.2.0.5.5 Grid Control Patch Set Update (PSU) [ID 1335690.1]good to know that PSU5 as well as PSU4 are OMS pathes only."hcheck.sql" script to check for known problems in Oracle8i, Oracle9i, Oracle10g and Oracle 11g [ID 136697.1]script creates a package under SYS schema that checks data dictionary for common dictionary problems.Mastergoryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-72144020187996099912011-07-17T22:45:00.003+10:002011-07-17T23:15:53.919+10:00MOS KB articles for July 17, 2011There are things that being executed fast and some of them are:Exadata queries and... vacation. Looks like I have not had it,but that's it and I am back to winter Sydney from Russian summer.But back to business...Reviewing recent Oracle Support Hot Topics e-mails I noticed thatfrom July 10th format of the table with bugs had been updatedand now there are names of bugs already shown.Great job goryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-6345694190412201662011-06-08T23:05:00.007+10:002011-06-08T23:25:48.862+10:00MOS KB articles for June 08, 2011Everyday Hot Topics e-mail did not bring any news on my servicerequest created about why public synonym created on non-existedobject in non-existed schema (11.2) is always in valid status(even recompilation runs without errors), but there are severalarticles in the e-mail that I think are worth to have a look at:OCR / Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE) [ID 428681.1]The goryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-80948870697966757732011-06-07T22:43:00.007+10:002011-06-07T23:14:27.782+10:00MOS KB articles for June 07, 2011From several articles that came on June 07, 2011 I chose these to have a look at:Troubleshooting when srvctl can't start RAC instance, but sqlplus can start it [ID 844272.1]Unable to Manage the Manually Configured Listener with Oracle Restart [ID 987825.1]it is the problem of standalone GI 11.2.0.1, not 11.2.0.2Things to Consider Before Upgrade to 11.2.0.2 Database Performance [ID 1320966.1]it goryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-28610297251564677712011-06-06T13:26:00.006+10:002011-06-06T21:09:54.556+10:00Oracle Support knowledge articlesRecent reviews of bugs with latest numbers showed that there are notonly bugs that already taken to work on but also lots of other createdproblems/issues/questions that sometimes just related to wrong syntax,misunderstanding of commands or can be duplication of already loggedbugs.Considering all that, I decided to do review of Knowledge Articlessent in Hot Topics e-mail since it has already goryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-79969910265132262222011-06-03T12:49:00.003+10:002011-06-03T23:48:35.319+10:00MOS Bugs for June 02, 2011Some of recently created MOS bugsBug IDProductDescriptionTypeVersionPlatform12616206Oracle Server - Enterprise EditionMRP KILLS RFS ITERATIVELLY AND CANNOT RESOLVE ARCHIVE GAPDefect11.2.0.2Linux x86-6412615371Oracle Server - Enterprise EditionROWS LOST IN ARRAY UPDATE IF UPDATE CURSOR IS INVALIDATEDDefect11.2.0.1Linux x86-6412614895Enterprise Manager Grid Control11G OMS NOTIFICATION ISSUE - goryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-85689087122931497922011-06-02T13:42:00.005+10:002011-06-02T14:12:12.826+10:00MOS Bugs for June 01, 2011Along with everyday list of bugs reference to one of insteresting notes came todayin Hot Topics e-mailRACcheck - RAC Configuration Audit ToolIt states that tool supports Oracle Enteprise Edition from 10.2.0.1 to 11.2.0.2for Linux 32 and 64-bit, AIX and SPARC Solaris. No support for Solaris x86 and LinuxItanium yet.It would be interesting to see script reaction for execution on Standard Editionandgoryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-60807994834507478762011-06-01T21:24:00.007+10:002011-06-01T22:07:28.739+10:00role of _FIX_CONTROLThere is a note Init.ora Parameter "_FIX_CONTROL" [Hidden] Reference Note [ID 567171.1]on My Oracle Support that not only explains the role of the hidden parameter but alsocontains references to known bugs in different versions wherethe parameter controls fixes.A full list of bugs and their status (OFF or ON: column VALUE - 0 or 1)for system and session level (for current session) can be foundin goryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-17215521042623616222011-06-01T13:18:00.003+10:002011-06-01T13:32:16.403+10:00MOS Bugs for May 31, 2011I put some modifications to the table that represents information aboutlatest bugs caught from Hot Topics e-mail.There are 5 bugs for May 31, 2011:Bug IDProductDescriptionTypeVersionPlatform12606936Enterprise Manager Grid ControlINCORRECTLY REPORTING CPU_COUNT=0Defect11.1.0.1.0Linux x86-6412606721Oracle Server - Enterprise EditionIF APPLICATION VIP EXISTS, DBCA FAILS TO CREATE DB RESOURCE WITH goryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-11502547812114332262011-05-31T12:48:00.010+10:002011-05-31T22:42:29.373+10:00MOS bugs for May 30, 2011One of the helpful features that MOS providesis "Hot Topics via e-mail" newsletter that gives information on recently updatedknowledge articles and freshly created product bugs.Knowledge articles come as links named after articles but bugs appear in the e-mailjust as IDs belong to area of interest like "Oracle Server - Enterprise Edition", etc.which is not allowing to understand how applicable togoryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-31774303317089833602010-11-23T23:09:00.006+11:002010-11-23T23:15:00.682+11:00Data Pump monitoring(originally published at Pythian)During database maintenance one of the main questions is when long running processeslike export, import, backup, recovery, flashback, etc. are finished.I usually use v$session_longops which allows to get some estimation of when process finished:select message, time_remaining/3600 hrs from v$session_longops where sofar <> totalworkAfter one of the recent Data Pump goryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-73218072512363478832010-11-01T09:49:00.004+11:002010-11-01T09:53:57.113+11:00installer 11.2.0.2 downloadUpdates option(originally published at Pythian)The new functionality to download latest patches or either apply saved onescame with installer of Oracle 11.2.0.2 (Software Updates Option)It can be used not only through OUI but with silent installation too.There are several options and variables available to get patches from MOS:oracle.installer.autoupdates...MYORACLESUPPORT_...AUTOUPDATES_MYORACLESUPPORT_...goryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-90160129904841788082010-10-25T23:29:00.007+11:002010-10-25T23:35:52.394+11:00chopt utility(originally published at Pythian)There is a new tool came with Oracle 11g Rel.2 that helps to modify options ininstalled oracle home (Enabling and Disabling Database Options)It is very simple and straightforward utility that recompiles database kernelwith different flags.[oracle@r1 bin]$ choptusage:chopt <enable|disable> <option>options: dm = Oracle Data Mining RDBMSgoryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-38991906125008500542010-10-07T00:37:00.005+11:002010-10-07T00:42:45.150+11:00Redo Transport Compressionoriginally published at PythianI was co-presenting recently at Sydney Oracle Meetupabout Data Guard Compression and in preparation I didsome tests to see how it works for 11.2.0.1 (Linux x86-64)...and I am still not able to see it working.There is a note"Redo Transport Compression in a Data Guard Environment [ID 729551.1]"on MOS how to set compression for redo transport destinationand for log goryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-26427346348718341162010-06-05T20:12:00.007+10:002010-06-05T22:45:25.694+10:00Silent installation of Enteprise Manager Grid Control 11g(originally posted at Pythian)One of the first questions that I asked myself when EM GC 11g came out is how would a silentinstallation go especially taking into account the use of WebLogic server as the http server.But before any attempt of silent installation I started the GC 11g GUI installation to local VM machine(Oracle Enterprise Linux 5.4 64-bit) with an allocated 2Gb of memory and got goryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-35803276050704046062009-12-17T14:36:00.010+11:002009-12-18T15:00:32.338+11:00Oracle 11.2 silent installation on opensolarisEven it is not certified but after appearance of Oracle 11.2 for Solaris (x86-64)I decided to give a try for silent installation of Oracle on opensolarisI downloaded Solaris iso and installed it as 64-bit on one of virtualmachines with 1Gb of RAM. Installation of OS went without problemand shortly I was enjoying a great look of OpenSolaris.I stopped myself admiring good looking interface (goryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-8346577915662224962009-09-21T16:38:00.005+10:002009-09-21T23:11:54.924+10:00Exadata Simulation testAs you know, 11gR2 came with new feature that you can simulate performance effectsfrom Exadata Storage Server on your workload.Just to check that functionality I installed Oracle 11g Release 2 on my local VM(Oracle EL 5.2 32bit) and created test database called o1102I created a user, a table with 5000000 entries, tuning set after that and executed analysisusing the script provided in $ORACLE_HOMEgoryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-83261140876878789812009-07-06T21:18:00.009+10:002009-07-06T22:11:08.986+10:00Silent installation of Oracle Scheduler AgentOne of the Oracle 11g New Features is Remote External JobsTo be able execute external jobs on remote host Oracle Scheduler Agent should be installed.It is coming as part of Oracle Database Gateways 11g installation and can be installed in silent mode.Giving that, I decided to install the agent using silent mode: created response file undertemporary location and left only entries with defined goryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com0tag:blogger.com,1999:blog-3861185288268898476.post-3828625258787779052009-06-24T14:55:00.013+10:002009-06-24T16:13:21.221+10:00duplicate target database from active databaseIt is always educational to get errors, problems during testing or creation of new systemsespecially when you are learning new features or investigating how different configurationsbehave and real lfie cases sometimes are not the same as it described in documentation.That's why I prefer not to think about configuration of test databases on VM religiouslybut to create them in minimal configurationgoryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.com3