tag:blogger.com,1999:blog-3861185288268898476.comments2022-03-29T23:54:52.810+11:00DBA Daily Telegraphgoryunovhttp://www.blogger.com/profile/06851091789503158667noreply@blogger.comBlogger33125tag:blogger.com,1999:blog-3861185288268898476.post-11105428593940973042013-07-23T16:14:17.501+10:002013-07-23T16:14:17.501+10:00Hi Anu,
I think you got those steps rightHi Anu,<br /><br />I think you got those steps rightgoryunovhttps://www.blogger.com/profile/06851091789503158667noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-72748965938376293052013-07-22T12:55:56.585+10:002013-07-22T12:55:56.585+10:00Hi,
Can you please confirm if following steps are...Hi,<br /><br />Can you please confirm if following steps are ok for to<br />Put standby database in read only mode and convert it back to recovery managed using data guard broker utility (not active data guard.<br /><br /><br />- put standby database in read only mode uisng dgmgrl:<br /><br /><br /> DGMGRL> EDIT DATABASE '' SET STATE='READ-ONLY';<br /> <br /><br />- Anonymoushttps://www.blogger.com/profile/05521329434709461916noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-52547320961805309632013-01-23T19:44:19.904+11:002013-01-23T19:44:19.904+11:00Hello, I am seeing this error in 11gr2 as well, I ...Hello, I am seeing this error in 11gr2 as well, I think SGA/SQL tuning will be a better option rather than Oracle devtha's help!Anonymoushttps://www.blogger.com/profile/04310714199982422947noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-3203629699191356512012-06-15T08:52:50.121+10:002012-06-15T08:52:50.121+10:00Hi,
there should not be oracle home (that you try...Hi,<br /><br />there should not be oracle home (that you trying to install) related entries in inventory.xml which is located in $INV_LOC/ContentsXML/ and INV_LOC can be taken from /etc/oraInst.loc file (by default).<br />If they are there you can remove them but be cautious not to corrupt it.<br />Looking at variables you use most likely you are trying to use existing (for RDBMS) oracle home forgoryunovhttps://www.blogger.com/profile/06851091789503158667noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-2276324797318576622012-06-15T01:09:10.830+10:002012-06-15T01:09:10.830+10:00Hi
i have gone through your doc regardin install...Hi<br /> i have gone through your doc regardin installation oracle 10g grid installation.when i started silent installtion it gave me error saying that oracle_home with oms10g already exists give another name .but according your doc you said that please remove entries in oratab regarding this installation and enties from inventory.xml file.can please guide me in this please.<br />my oracle_homegouthamhttps://www.blogger.com/profile/10571555427449031067noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-36486921463051901462012-06-15T01:08:01.382+10:002012-06-15T01:08:01.382+10:00Hi
i have gone through your doc regardin install...Hi<br /> i have gone through your doc regardin installation oracle 10g grid installation.when i started silent installtion it gave me error saying that oracle_home with oms10g already exists give another name .but according your doc you said that please remove entries in oratab regarding this installation and enties from inventory.xml file.can please guide me in this please.<br />my oracle_homegouthamhttps://www.blogger.com/profile/10571555427449031067noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-77464014182893584662012-06-15T00:58:32.954+10:002012-06-15T00:58:32.954+10:00hi
I hope you are doing great.i got small probl...hi <br /> I hope you are doing great.i got small problem while installing 10g grid contro on oracle linux 5.when i just followed your doc after lot of time waste in installing grid control.when i am installing silent install i gave the oracle_home location it says already exists please specify another name for oracle home.you told in the doc that to remove entries from inventory.xml file as it gouthamhttps://www.blogger.com/profile/10571555427449031067noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-62328040496425168792011-07-19T21:46:30.515+10:002011-07-19T21:46:30.515+10:00I would guess that directories on the side you wer...I would guess that directories on the side you were clonig to did not exist prior to the duplicate- was the cause of your unexplained errors.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-87917958725804940732010-10-27T22:47:34.885+11:002010-10-27T22:47:34.885+11:00Since then I was trying to prove to support that o...Since then I was trying to prove to support that oraenv does not work properly and finally yesterday patch 8795124 for 11.2.0.1 on Linux x86-64 was suggested.<br />It has coraenv, oraenv utilities inside.<br />I took the code out of oraenv and substituted it with original one for 11.2.0.1 32-bit. It worked and I was able to switch oracle bases properly.<br />But it works as 11.2.0.2 version - it goryunovhttps://www.blogger.com/profile/06851091789503158667noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-6713332039204204152010-09-22T00:00:00.143+10:002010-09-22T00:00:00.143+10:00Hello Fadel,
unfortunately I have not tried after ...Hello Fadel,<br />unfortunately I have not tried after that to make it working. I just used the old fashion option.<br />I hope it works in 11.2.0 but have not tried it yetgoryunovhttps://www.blogger.com/profile/06851091789503158667noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-41571061809255725792010-09-17T05:06:38.866+10:002010-09-17T05:06:38.866+10:00hello there!
I'm having the same issue with d...hello there!<br /><br />I'm having the same issue with duplication a primary 32bit for standby 64bit with active option<br /><br />I'm glad that it's not only me!<br /><br />have you made work? any workaround?<br />just out of curiosity. an alternative I used is to drop the active option and duplicate it from a backupset<br /><br />thanks!Fadelhttps://www.blogger.com/profile/00076805089234653666noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-67567963729834378712010-05-27T10:57:19.504+10:002010-05-27T10:57:19.504+10:00For the "METALINK_USERNAME(MetaLinkUsername) ...For the "METALINK_USERNAME(MetaLinkUsername) Silent install cannot continue" errors, see Oracle KB [ID 762790.1].<br /><br />runInstaller -silent -responseFile 11107_rdbms.rsp DECLINE_SECURITY_UPDATES=TRUE<br /><br />... bypasses OCM configuration and prevents the Metalink step.Unknownhttps://www.blogger.com/profile/12635783007380366177noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-54846104720825221632010-03-05T13:29:28.514+11:002010-03-05T13:29:28.514+11:00To delete some specific user-defined metric(s) OSS...To delete some specific user-defined metric(s) OSS note can be used as guidline <br /><a href="https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bmDocType=HOWTO&bmDocDsrc=DOCUMENT&bmDocTitle=How%20do%20you%20remove%20a%20UDM%20with%20a%20template?&from=BOOKMARK&bmDocID=420256.1&viewingMode=1143))" rel="nofollow">How do yougoryunovhttps://www.blogger.com/profile/06851091789503158667noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-64920770076162339272009-12-01T08:00:26.488+11:002009-12-01T08:00:26.488+11:00Hi Andrey, I believe that you can also try the rec...Hi Andrey, I believe that you can also try the <a href="http://www.recoverytoolbox.com/corrupt_sql_server_database_recovery_tools_and_companies.html" rel="nofollow">recover corrupted sql system database in 2005</a> utility, it fixes database errors automaticallyUnknownhttps://www.blogger.com/profile/07692954989164147764noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-7251596949362113672009-11-14T04:02:27.271+11:002009-11-14T04:02:27.271+11:00Excellent , I had this kind of problem on AIX. Mod...Excellent , I had this kind of problem on AIX. Modifying the response file was the solution :=)<br />Thanks a lot !Unknownhttps://www.blogger.com/profile/16558711229983062604noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-14609033592439974722009-11-14T02:32:10.339+11:002009-11-14T02:32:10.339+11:00Hi Andrey, you may also try the file fix dbf prog...Hi Andrey, you may also try the <a href="http://www.recoverytoolbox.com/download_filefix_dbf.html" rel="nofollow">file fix dbf</a> program if something goes wrong, it automates the procedure of database recoverydaspeachttps://www.blogger.com/profile/07882283802002193798noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-52909617701866229622009-11-10T00:09:54.683+11:002009-11-10T00:09:54.683+11:00Unfortunately, I was not able to find Metalink Not...Unfortunately, I was not able to find Metalink Note that I mentioned in the post, looks like it was closed or removed, but those patterns should be based on regular expressions<br />How about to try the following pattern for warning message: ORA-<br />and for critical: ORA-[^(00060)]goryunovhttps://www.blogger.com/profile/06851091789503158667noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-51960963409407845692009-11-05T09:32:36.550+11:002009-11-05T09:32:36.550+11:00well, does not quite work as I expected. when i m...well, does not quite work as I expected. when i manully insert ORA-12012 in the alert log, i only got warning, which is not good.<br /><br />I was expecting one from critical since our aim is get all except ORA-00060.Rinkyhttps://www.blogger.com/profile/04957195654960101014noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-16198168731542285282009-11-05T02:10:20.474+11:002009-11-05T02:10:20.474+11:00Hi, this .*ORA-0[^(0060)].* seems to be working. ...Hi, this .*ORA-0[^(0060)].* seems to be working. I need to do some more testing to make sure we do not miss out any other ORA- errros. Can you tell me the source of this above sequence. Is it mentioned in any metalink note? I just need to document this and need a reference since the change will in production system.<br /><br />Thanks a lot.Rinkyhttps://www.blogger.com/profile/04957195654960101014noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-71772900963003859922009-10-27T10:06:20.153+11:002009-10-27T10:06:20.153+11:00I think you can try the following under critical t...I think you can try the following under critical threshold<br />.*ORA-0[^(0060)].* to ignore ORA-00060 errors and leave ORA- in warning fieldgoryunovhttps://www.blogger.com/profile/06851091789503158667noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-46649064367331528712009-10-27T05:15:51.759+11:002009-10-27T05:15:51.759+11:00Hi,
many thanks for your reply.
I do have seperate...Hi,<br />many thanks for your reply.<br />I do have seperate accounts setup. but for the production systems, we want all ORA errors alerts go to on 'oncall' account. That is why I have Critical threshold set as 'ORA-' I have to exclude ORA-00060 from the Critical and put it in Warning. how can I do that? is it something that requires a scripts or it can be done in the critical Rinkyhttps://www.blogger.com/profile/04957195654960101014noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-44073423223065193852009-10-16T09:21:19.295+11:002009-10-16T09:21:19.295+11:00Hi,
I would recommend to separate warning and cri...Hi,<br /><br />I would recommend to separate warning and critical alerts and create different accounts in addition to SYSMAN (or another Super acccount) like admin_crit, admin_warn<br />and create separate notifications <br />(for critical and warning alerts) and subscribe the new admin accounts to those notifications. In that case, you can have flexibility to assign e-mails what you want.goryunovhttps://www.blogger.com/profile/06851091789503158667noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-36261572887283301942009-10-16T09:10:24.744+11:002009-10-16T09:10:24.744+11:00Hi,
I found your post helpful. I have a question ...Hi,<br /><br />I found your post helpful. I have a question and it will be great if you can take a look.<br /><br />Right now I have Warning & Critical thresholds both set to ORA- . now I want to exclude ORA-00060 from the critical threshold because it sends alert to ON call. I still want to recieve an email using the warning threshold. I mean I do not want to filter it out completely using Rinkyhttps://www.blogger.com/profile/04957195654960101014noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-27335960113646241192009-10-07T08:55:03.622+11:002009-10-07T08:55:03.622+11:00I am glad it helped.I am glad it helped.goryunovhttps://www.blogger.com/profile/06851091789503158667noreply@blogger.comtag:blogger.com,1999:blog-3861185288268898476.post-2880311512929666002009-10-05T22:59:11.796+11:002009-10-05T22:59:11.796+11:00I also had with ORACLE_HOME and ORACLE_HOME_NAME s...I also had with ORACLE_HOME and ORACLE_HOME_NAME system variables problem when installing BI on AIX. Thanks to this post the installation started successfully.<br /><br />Regards, VladoVladohttps://www.blogger.com/profile/18004727517900794291noreply@blogger.com