AskDBA.org Forum » Recent Posts

AskDBA.org Forum » Recent Posts http://www.forum.askdba.org/ Forum for Oracle DBA's en Thu, 09 Feb 2012 21:29:38 +0000 e303868 on "ORACLE_HOME/(server_dbname)/sysman/recv/errors" http://www.forum.askdba.org/topic/oracle_homeserver_dbnamesysmanrecverrors#post-305 Sat, 14 Jan 2012 17:41:30 +0000 e303868 305@http://www.forum.askdba.org/ Hi I have recently installed oracle application server on windows server 2003. and I also configured our system on this application and working fine with no problem. The problem is that there are many errors generated under ORACLE INFRA_HOME/(server_dbname)/sysman/recv/errors filling up my hard disk. The Files like A0000000064.err_2007_06_29_17_45_53. The content of the files are similar, and begin with:- ============================= Time: 2011-12-17 16:53:49 From: <a href="http://testapp:1830/emd/main" rel="nofollow">http://testapp:1830/emd/main</a> --> <UPLOAD OMS_PROTOCOL_VERSION="10.1.0.2.0" UPLOAD_TYPE="metadata" EMD_URL="http://testapp:1830/emd/main" MERGE_TIMESTAMP="2011-12-17 16:53:49"> <ROWSET OMS_PROTOCOL_VERSION="10.1.0.2.0" TABLE="MGMT_TARGET_PROP_DEFS"> <ROW> <TARGET_TYPE>oracle_database</TARGET_TYPE> <TYPE_META_VER>3.1</TYPE_META_VER> <PROPERTY_NAME>OracleHome</PROPERTY_NAME> <PROPERTY_TYPE>INSTANCE</PROPERTY_TYPE> <PROPERTY_DISPLAY_NAME>Oracle home path</PROPERTY_DISPLAY_NAME> <PROPERTY_DISPLAY_NLSID>OracleHome_iprop</PROPERTY_DISPLAY_NLSID> <REQUIRED_FLAG>0</REQUIRED_FLAG> <CREDENTIAL_FLAG>0</CREDENTIAL_FLAG> <DEFAULT_VALUE/> =================================== What can I do to stop these generated files? Thank you. Pankaj Sharma on "Lost all voting disk on ASM in oracle 11gr2" http://www.forum.askdba.org/topic/lost-all-voting-disk-on-asm-in-oracle-11gr2#post-304 Tue, 27 Dec 2011 06:24:47 +0000 Pankaj Sharma 304@http://www.forum.askdba.org/ Hi, Sorry for the late reply. Amit:- This is external redundancy group. Saurabh:- That time I recovered the vote disk by restoring it. But just to get answer of your question, I have simulate the failure again, so that we can find out the reason for this unexpected behaviour of clusterware. This time my votedisk was on ASMDISK3 and corresponding os deveice is "/dev/sdd1" [BEFORE FAILURE] Below is the output from command "$ kfed read /dev/sdd1" [root@rac1 ~]# kfed read /dev/sdd1 kfbh.endian: 1 ; 0x000: 0x01 kfbh.hard: 130 ; 0x001: 0x82 kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD kfbh.datfmt: 1 ; 0x003: 0x01 kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0 kfbh.block.obj: 2147483648 ; 0x008: TYPE=0x8 NUMB=0x0 kfbh.check: 711410310 ; 0x00c: 0x2a674286 kfbh.fcn.base: 0 ; 0x010: 0x00000000 kfbh.fcn.wrap: 0 ; 0x014: 0x00000000 kfbh.spare1: 0 ; 0x018: 0x00000000 kfbh.spare2: 0 ; 0x01c: 0x00000000 kfdhdb.driver.provstr: ORCLDISKASMDISK3 ; 0x000: length=16 kfdhdb.driver.reserved[0]: 1145918273 ; 0x008: 0x444d5341 kfdhdb.driver.reserved[1]: 860574537 ; 0x00c: 0x334b5349 kfdhdb.driver.reserved[2]: 0 ; 0x010: 0x00000000 kfdhdb.driver.reserved[3]: 0 ; 0x014: 0x00000000 kfdhdb.driver.reserved[4]: 0 ; 0x018: 0x00000000 kfdhdb.driver.reserved[5]: 0 ; 0x01c: 0x00000000 kfdhdb.compat: 186646528 ; 0x020: 0x0b200000 kfdhdb.dsknum: 0 ; 0x024: 0x0000 kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNAL kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER kfdhdb.dskname: ASMDISK3 ; 0x028: length=8 kfdhdb.grpname: DATA2 ; 0x048: length=5 kfdhdb.fgname: ASMDISK3 ; 0x068: length=8 kfdhdb.capname: ; 0x088: length=0 kfdhdb.crestmp.hi: 32961169 ; 0x0a8: HOUR=0x11 DAYS=0x14 MNTH=0xc YEAR=0x7db kfdhdb.crestmp.lo: 252092416 ; 0x0ac: USEC=0x0 MSEC=0x1a8 SECS=0x30 MINS=0x3 kfdhdb.mntstmp.hi: 32961387 ; 0x0b0: HOUR=0xb DAYS=0x1b MNTH=0xc YEAR=0x7db kfdhdb.mntstmp.lo: 2314231808 ; 0x0b4: USEC=0x0 MSEC=0x18 SECS=0x1f MINS=0x22 kfdhdb.secsize: 512 ; 0x0b8: 0x0200 kfdhdb.blksize: 4096 ; 0x0ba: 0x1000 kfdhdb.ausize: 1048576 ; 0x0bc: 0x00100000 kfdhdb.mfact: 113792 ; 0x0c0: 0x0001bc80 kfdhdb.dsksize: 5114 ; 0x0c4: 0x000013fa kfdhdb.pmcnt: 2 ; 0x0c8: 0x00000002 kfdhdb.fstlocn: 1 ; 0x0cc: 0x00000001 kfdhdb.altlocn: 2 ; 0x0d0: 0x00000002 kfdhdb.f1b1locn: 2 ; 0x0d4: 0x00000002 kfdhdb.redomirrors[0]: 0 ; 0x0d8: 0x0000 kfdhdb.redomirrors[1]: 0 ; 0x0da: 0x0000 kfdhdb.redomirrors[2]: 0 ; 0x0dc: 0x0000 kfdhdb.redomirrors[3]: 0 ; 0x0de: 0x0000 kfdhdb.dbcompat: 168820736 ; 0x0e0: 0x0a100000 kfdhdb.grpstmp.hi: 32961169 ; 0x0e4: HOUR=0x11 DAYS=0x14 MNTH=0xc YEAR=0x7db kfdhdb.grpstmp.lo: 251921408 ; 0x0e8: USEC=0x0 MSEC=0x101 SECS=0x30 MINS=0x3 kfdhdb.vfstart: 96 ; 0x0ec: 0x00000060 kfdhdb.vfend: 128 ; 0x0f0: 0x00000080 kfdhdb.spfile: 0 ; 0x0f4: 0x00000000 kfdhdb.spfflg: 0 ; 0x0f8: 0x00000000 kfdhdb.ub4spare[0]: 0 ; 0x0fc: 0x00000000 kfdhdb.ub4spare[1]: 0 ; 0x100: 0x00000000 kfdhdb.ub4spare[2]: 0 ; 0x104: 0x00000000 kfdhdb.ub4spare[3]: 0 ; 0x108: 0x00000000 kfdhdb.ub4spare[4]: 0 ; 0x10c: 0x00000000 kfdhdb.ub4spare[5]: 0 ; 0x110: 0x00000000 kfdhdb.ub4spare[6]: 0 ; 0x114: 0x00000000 kfdhdb.ub4spare[7]: 0 ; 0x118: 0x00000000 kfdhdb.ub4spare[8]: 0 ; 0x11c: 0x00000000 kfdhdb.ub4spare[9]: 0 ; 0x120: 0x00000000 kfdhdb.ub4spare[10]: 0 ; 0x124: 0x00000000 kfdhdb.ub4spare[11]: 0 ; 0x128: 0x00000000 kfdhdb.ub4spare[12]: 0 ; 0x12c: 0x00000000 kfdhdb.ub4spare[13]: 0 ; 0x130: 0x00000000 kfdhdb.ub4spare[14]: 0 ; 0x134: 0x00000000 kfdhdb.ub4spare[15]: 0 ; 0x138: 0x00000000 kfdhdb.ub4spare[16]: 0 ; 0x13c: 0x00000000 kfdhdb.ub4spare[17]: 0 ; 0x140: 0x00000000 kfdhdb.ub4spare[18]: 0 ; 0x144: 0x00000000 kfdhdb.ub4spare[19]: 0 ; 0x148: 0x00000000 kfdhdb.ub4spare[20]: 0 ; 0x14c: 0x00000000 kfdhdb.ub4spare[21]: 0 ; 0x150: 0x00000000 kfdhdb.ub4spare[22]: 0 ; 0x154: 0x00000000 kfdhdb.ub4spare[23]: 0 ; 0x158: 0x00000000 kfdhdb.ub4spare[24]: 0 ; 0x15c: 0x00000000 kfdhdb.ub4spare[25]: 0 ; 0x160: 0x00000000 kfdhdb.ub4spare[26]: 0 ; 0x164: 0x00000000 kfdhdb.ub4spare[27]: 0 ; 0x168: 0x00000000 kfdhdb.ub4spare[28]: 0 ; 0x16c: 0x00000000 kfdhdb.ub4spare[29]: 0 ; 0x170: 0x00000000 kfdhdb.ub4spare[30]: 0 ; 0x174: 0x00000000 kfdhdb.ub4spare[31]: 0 ; 0x178: 0x00000000 kfdhdb.ub4spare[32]: 0 ; 0x17c: 0x00000000 kfdhdb.ub4spare[33]: 0 ; 0x180: 0x00000000 kfdhdb.ub4spare[34]: 0 ; 0x184: 0x00000000 kfdhdb.ub4spare[35]: 0 ; 0x188: 0x00000000 kfdhdb.ub4spare[36]: 0 ; 0x18c: 0x00000000 kfdhdb.ub4spare[37]: 0 ; 0x190: 0x00000000 kfdhdb.ub4spare[38]: 0 ; 0x194: 0x00000000 kfdhdb.ub4spare[39]: 0 ; 0x198: 0x00000000 kfdhdb.ub4spare[40]: 0 ; 0x19c: 0x00000000 kfdhdb.ub4spare[41]: 0 ; 0x1a0: 0x00000000 kfdhdb.ub4spare[42]: 0 ; 0x1a4: 0x00000000 kfdhdb.ub4spare[43]: 0 ; 0x1a8: 0x00000000 kfdhdb.ub4spare[44]: 0 ; 0x1ac: 0x00000000 kfdhdb.ub4spare[45]: 0 ; 0x1b0: 0x00000000 kfdhdb.ub4spare[46]: 0 ; 0x1b4: 0x00000000 kfdhdb.ub4spare[47]: 0 ; 0x1b8: 0x00000000 kfdhdb.ub4spare[48]: 0 ; 0x1bc: 0x00000000 kfdhdb.ub4spare[49]: 0 ; 0x1c0: 0x00000000 kfdhdb.ub4spare[50]: 0 ; 0x1c4: 0x00000000 kfdhdb.ub4spare[51]: 0 ; 0x1c8: 0x00000000 kfdhdb.ub4spare[52]: 0 ; 0x1cc: 0x00000000 kfdhdb.ub4spare[53]: 0 ; 0x1d0: 0x00000000 kfdhdb.acdb.aba.seq: 0 ; 0x1d4: 0x00000000 kfdhdb.acdb.aba.blk: 0 ; 0x1d8: 0x00000000 kfdhdb.acdb.ents: 0 ; 0x1dc: 0x0000 kfdhdb.acdb.ub2spare: 0 ; 0x1de: 0x0000 [root@rac1 ~]# [AFTER FAILURE] [root@rac1 ~]# kfed read /dev/sdd1 kfbh.endian: 0 ; 0x000: 0x00 kfbh.hard: 0 ; 0x001: 0x00 kfbh.type: 0 ; 0x002: KFBTYP_INVALID kfbh.datfmt: 0 ; 0x003: 0x00 kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0 kfbh.block.obj: 0 ; 0x008: TYPE=0x0 NUMB=0x0 kfbh.check: 0 ; 0x00c: 0x00000000 kfbh.fcn.base: 0 ; 0x010: 0x00000000 kfbh.fcn.wrap: 0 ; 0x014: 0x00000000 kfbh.spare1: 0 ; 0x018: 0x00000000 kfbh.spare2: 0 ; 0x01c: 0x00000000 ERROR!!!, failed to get the oracore error message [root@rac1 ~]# oracleasm querydisk -p ASMDISK3 Disk "ASMDISK3" defines an unmarked device Still the same findings as before like no error message, vote disk are still ONLINE. Let me know if you want any other information. Thanks Pankaj Amit Bansal on "Lost all voting disk on ASM in oracle 11gr2" http://www.forum.askdba.org/topic/lost-all-voting-disk-on-asm-in-oracle-11gr2#post-303 Wed, 21 Dec 2011 03:36:21 +0000 Amit Bansal 303@http://www.forum.askdba.org/ Pankaj, Is this a normal redundancy diskgroup? Regards Amit Saurabh Sood on "Lost all voting disk on ASM in oracle 11gr2" http://www.forum.askdba.org/topic/lost-all-voting-disk-on-asm-in-oracle-11gr2#post-302 Wed, 21 Dec 2011 02:47:08 +0000 Saurabh Sood 302@http://www.forum.askdba.org/ Hi Pankaj, Can you provide the output of following command to me: $ kfed read /dev/sdc1 Thanks, Saurabh Sood Pankaj Sharma on "Lost all voting disk on ASM in oracle 11gr2" http://www.forum.askdba.org/topic/lost-all-voting-disk-on-asm-in-oracle-11gr2#post-301 Tue, 20 Dec 2011 11:56:14 +0000 Pankaj Sharma 301@http://www.forum.askdba.org/ Hi, This is regarding Oracle 11gR2 RAC. I have a 2 node RAC on RHEL5. I have my voting file on ASM diskgroup named "+DATA1", which is created on device "/dev/sdc1". Below is the details: [root@rac1 ~]# oracleasm querydisk -p ASMDISK2 Disk "ASMDISK2" is a valid ASM disk /dev/sdc1: LABEL="ASMDISK2" TYPE="oracleasm" I was just want to test the scenario when I lost my all voting disk, then what happens actually. So I make the zero space the partition using below command: [root@rac1 ~]# dd if=/dev/zero of=/dev/sdc1 dd: writing to `/dev/sdc1': No space left on device 10474318+0 records in 10474317+0 records out 5362850304 bytes (5.4 GB) copied, 161.053 seconds, 33.3 MB/s My disktimeout was 200 seconds. But I waited for approx 8-10 minutes. Then I query the votedisk, but still it is showing ONLINE on DATA1 diskgroup. [root@rac1 ~]# crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 06d8300bb6af4fd3bfa2e1e5cda9c440 (ORCL:ASMDISK2) [DATA1] Located 1 voting disk(s). Also below are some findings in this situation: 1) ASMCA is not showing the diskgroup DATA1, it is deleted. 2) Cluster alert log is not displaying any message regarding the lost of voting disk. 3) cssd.log also not displaying any message regarding the lost of voting disk. 4) Cluster is still running and up. Also its working properly. As per documentation, oracle 11g r2 provide "rebootless node fencing" in case of all voting disk failure. But atleast it must display any message in log files or how the "crsctl query css votedisk" is still giving that voting disk is ONLINE ? I am not able to understand this situation. Please explain me the reason ? Thanks in advanced. Amit Bansal on "User Registrations" http://www.forum.askdba.org/topic/user-registrations#post-299 Wed, 16 Nov 2011 04:02:10 +0000 Amit Bansal 299@http://www.forum.askdba.org/ To tackle lot of spam being generated on this forum, I have modified the user registration process. Now when a user registers, he/she will not get immediate login and it will be stored in a moderation queue. Only once moderators approve, user will be able to login. In case registration is not approved for some time or password is not working, then send mail to <a href="mailto:amit.bansal@askdba.org">amit.bansal@askdba.org</a> Pankaj Sharma on "Voting Disk Location in Oracle 11gR2" http://www.forum.askdba.org/topic/voting-disk-location-in-oracle-11gr2#post-291 Fri, 04 Nov 2011 11:01:31 +0000 Pankaj Sharma 291@http://www.forum.askdba.org/ Hi All, Could you please tell me that in Oracle 11g, information regarding voting disk location is stored in which file ? I know that we can use "crsctl query css votedisk" to see the location of voting disk, but from which file or place this command pick the information ? Pankaj Sharma on "Regarding RAC concepts" http://www.forum.askdba.org/topic/regarding-rac-concepts#post-286 Wed, 02 Nov 2011 05:46:14 +0000 Pankaj Sharma 286@http://www.forum.askdba.org/ Hi Saurabh, Thanks for your reply, I will try to check it out using the alert logs. Saurabh Sood on "Problem Tracing Data" http://www.forum.askdba.org/topic/problem-tracing-data#post-285 Wed, 02 Nov 2011 04:28:20 +0000 Saurabh Sood 285@http://www.forum.askdba.org/ Hi, Please check the following information: <a href="http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/auditing.htm#DBSEG125" rel="nofollow">http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/auditing.htm#DBSEG125</a> You will get some idea about auditing and then you can get back to your friend and ask more about what he wants as there may be issues even if the auditing is enabled. -- Saurabh Sood Saurabh Sood on "Database Security" http://www.forum.askdba.org/topic/database-security#post-284 Wed, 02 Nov 2011 04:24:27 +0000 Saurabh Sood 284@http://www.forum.askdba.org/ Please check the following information: <a href="http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/auditing.htm#DBSEG125" rel="nofollow">http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/auditing.htm#DBSEG125</a> Hope this helps --Saurabh Sood kyrool on "Database Security" http://www.forum.askdba.org/topic/database-security#post-282 Mon, 31 Oct 2011 03:06:57 +0000 kyrool 282@http://www.forum.askdba.org/ Hi, What type of security can implement in database level? kyrool on "Problem Tracing Data" http://www.forum.askdba.org/topic/problem-tracing-data#post-281 Sat, 29 Oct 2011 06:39:04 +0000 kyrool 281@http://www.forum.askdba.org/ My friend said, to trace data "misuse" from operational database is hard if there unable the auditing. So, I want to know if the the auditing is already enable, there are still other problems? Because I quite new in DB auditing. :) Saurabh Sood on "Regarding RAC concepts" http://www.forum.askdba.org/topic/regarding-rac-concepts#post-280 Fri, 28 Oct 2011 13:24:54 +0000 Saurabh Sood 280@http://www.forum.askdba.org/ Pankaj, 1. I don't think it is writing anywhere else.. 2. The listeners scans vips are part of nodeapps and managed separately. Cannot comment about the nodes status , you have to check the alert log file to know this. -Saurabh Sood Saurabh Sood on "Creating One Node RAC using SAN replication" http://www.forum.askdba.org/topic/creating-one-node-rac-using-san-replication#post-279 Fri, 28 Oct 2011 13:12:30 +0000 Saurabh Sood 279@http://www.forum.askdba.org/ Hi Shashi, Yes it is possible to bring it up on one node... for that you need to set the cluster_database=false and threads=1 in the spfile and restore/recover (It will become a single instance database.) If you want it to be RAC then you can use "ONE NODE RAC" new feature for 11gR2. Please read on following link: <a href="http://download.oracle.com/docs/cd/E11882_01/install.112/e18069/whatsnew.htm#sthref14" rel="nofollow">http://download.oracle.com/docs/cd/E11882_01/install.112/e18069/whatsnew.htm#sthref14</a> Saurabh Sood on "Problem Tracing Data" http://www.forum.askdba.org/topic/problem-tracing-data#post-278 Fri, 28 Oct 2011 13:04:42 +0000 Saurabh Sood 278@http://www.forum.askdba.org/ Kyrool, The question seems to be very vague to me.. If you can explain in details about what you want..it will be easy to answer... if I know that..:) -Saurabh Sood kyrool on "Problem Tracing Data" http://www.forum.askdba.org/topic/problem-tracing-data#post-277 Fri, 28 Oct 2011 11:11:57 +0000 kyrool 277@http://www.forum.askdba.org/ Hi, I just doing final year project, I just want to know from your opinion, what is problem you are facing when tracing data from audit trail? shashikiran on "Creating One Node RAC using SAN replication" http://www.forum.askdba.org/topic/creating-one-node-rac-using-san-replication#post-263 Thu, 20 Oct 2011 07:23:49 +0000 shashikiran 263@http://www.forum.askdba.org/ Hi We have the following set up : 2 node 11gr2 (11.2.0.1) RAC using ASM. Business requirement is to have a DR site. SAN replication is used to replicate the data to the DR storage ie, the underling disks are replicated to DR site. On the SR site , we have only one server on which Both the Grid Infrastructure and oracle home will be installed. Is it possible to bring up the RAC DB on a single node . I haven't tried this before . Could you help me on this . Pankaj Sharma on "Regarding RAC concepts" http://www.forum.askdba.org/topic/regarding-rac-concepts#post-262 Mon, 17 Oct 2011 07:58:42 +0000 Pankaj Sharma 262@http://www.forum.askdba.org/ I also have some questions regarding RAC concepts: 1) As per my understanding, ocrconfig commands only updates the ocr.loc file on all the available nodes. Does it updates anywhere else also ? 2) As per my understanding, while clusterware is running, if we lost all OCR, then crsd.bin would be stopped and it won’t be restart automatically again due to unavailability of OCR. In this case we won’t be able to use commands like srvctl, crsctl, and ocrconfig which interact with OCR using crsd.bin process. But how will it affect other resources like database instance, listeners, scan, vips ? These all are still keep on running after losing all OCR and stopping the crsd.bin. Does all the nodes are still a part of the cluster or they behave as individually ? Thanks in advance. Pankaj Sharma on "Oracle 11g R2 - CRS is not starting" http://www.forum.askdba.org/topic/oracle-11g-r2-crs-is-not-starting#post-261 Mon, 17 Oct 2011 07:08:55 +0000 Pankaj Sharma 261@http://www.forum.askdba.org/ Hi Amit, I am using 11.2.0.1, so I used "crsctl start crs -excl", it worked for me perfactly. I shutdown the CRS on all other nodes and from node2, i used the below command: ocrconfig -repair -replace +DATA2 -replacement +DATA1 Now, all ocr.loc have the same entry on all nodes and I started the cluster on all nodes. Thanks a lot... Amit Bansal on "Oracle 11g R2 - CRS is not starting" http://www.forum.askdba.org/topic/oracle-11g-r2-crs-is-not-starting#post-260 Sat, 15 Oct 2011 05:32:46 +0000 Amit Bansal 260@http://www.forum.askdba.org/ Pankaj, Stop crs and start using following command crsctl start crs -excl -nocrs Then try ocrconfig restore . It should work -Amit Pankaj Sharma on "Oracle 11g R2 - CRS is not starting" http://www.forum.askdba.org/topic/oracle-11g-r2-crs-is-not-starting#post-259 Fri, 14 Oct 2011 04:53:54 +0000 Pankaj Sharma 259@http://www.forum.askdba.org/ Hi, I am getting problem while starting the CRS. Below is the necessary details: 1) I am using oracle 11g R2 RAC, with 2 node named RAC1 and RAC2 2) I have 3 diskgroup named DATA, DATA1, DATA2 3) OCR and voting disks are stored on ASM diskgroup On node RAC1, CRS is started and /etc/oracle/ocr.loc is having the below entry: ocrconfig_loc=+DATA ocrmirrorconfig_loc=+DATA1 On node RAC2, CRS is stopped and /etc/oracle/ocr.loc is having the below entry: ocrconfig_loc=+DATA ocrmirrorconfig_loc=+DATA2 Please note the difference in "ocrmirrorconfig_loc". The difference was occured because I updated the OCR location on RAC1 when RAC2 was down. Now I am trying to repair the OCR on the RAC2 using below command. This command must be run as root user when HA service is started but CRS must be stopped. ocrconfig -repair -replace +DAT2 -replacement +DATA1 but this showing error "PROT-21: Invalid parameter", because to run this command diskgroup must be mounted. But diskgroup cannot be mounted until the CRS start. SO this is a conflicting situation. Please suggest how to overcome from this problem ? Please let me know if you required any other details. daniesh on "ora.asm connection is not failing on another node" http://www.forum.askdba.org/topic/oraasm-connection-is-not-failing-on-another-node#post-251 Sun, 25 Sep 2011 18:43:00 +0000 daniesh 251@http://www.forum.askdba.org/ Hi , I have successfully installed oracle 11gR2 on IBX AIX. When i run the crsctl crs res -t command to check the status. I can see that ora.asm process is coming up on either of the node. ora.asm ONLINE ONLINE t24db1 Started ONLINE ONLINE t24db2 I dont know what is the problem if i start the cluster from node 2 then ora.asm service will start on node 2 and vice versa. Everything is running fine. I can connect to asm instance and database. All are up and running fine. Same problem is with my TNS. I am using the below TNS entry to connect to the database. T24PROD = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = t24db_scan.cbe.local)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = T24PROD) ) ) The same problem whichever instance will start last. The connection will failover only to that instances.Suppose I last started the instance 2 and i will try to connect remotely.The connection will failover to instance 2. I tried the 20-30 using tns connection it fails to instance 2 or instance 1 whichver is started last. I check the scan and scan listener they are running fine. Do you have any idea on this? Your help is much appreciated in this regards, Awaiting for your response. Thanks and Regards, Daniesh sagarsarkar on "Startup Force DBA" http://www.forum.askdba.org/topic/startup-force-dba#post-250 Tue, 20 Sep 2011 11:46:08 +0000 sagarsarkar 250@http://www.forum.askdba.org/ job of DBA? Amit Bansal on "Startup Force DBA" http://www.forum.askdba.org/topic/startup-force-dba#post-247 Wed, 10 Aug 2011 08:22:11 +0000 Amit Bansal 247@http://www.forum.askdba.org/ Came across this option today of starting up database. I was aware that startup force does a shutdown abort and then starts database normally. But if you issue 'startup force dba' , it will restrict access to users with the RESTRICTED SESSION privilege. Docs link - <a href="http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta060.htm" rel="nofollow">http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta060.htm</a> Saurabh Sood on "11g Useful Sql" http://www.forum.askdba.org/topic/11g-useful-sql#post-246 Fri, 22 Jul 2011 13:12:27 +0000 Saurabh Sood 246@http://www.forum.askdba.org/ Amit, In 10.2.0.4, if we do not want to apply patch, we can do this by setting event 5614566 at session level and then using dbms_shared_pool.purge (may have to run dbmspool.sql if purge is not present) Cheers!! Amit Bansal on "11g Useful Sql" http://www.forum.askdba.org/topic/11g-useful-sql#post-245 Fri, 22 Jul 2011 08:43:05 +0000 Amit Bansal 245@http://www.forum.askdba.org/ In 11g, we can flush a particular sql out of shared pool (also available in 10.2.0.4 by applying patch) select 'exec dbms_shared_pool.purge('''||ADDRESS||','||HASH_VALUE||''',''C'')' from V$SQLAREA where SQL_ID='&sqlid'; In a RAC environment, you optionally specify the INST_ID, shown when querying the GV$SESSION view. This allows you to kill a session on different RAC node. ALTER SYSTEM KILL SESSION 'sid,serial#,@inst_id'; ALTER SYSTEM KILL SESSION 'sid,serial#,@inst_id' immediate; Amit Bansal on "Script to generate oracle add service commands" http://www.forum.askdba.org/topic/script-to-generate-oracle-add-service-commands#post-243 Thu, 14 Jul 2011 07:51:16 +0000 Amit Bansal 243@http://www.forum.askdba.org/ Suppose you have 10g database which you are trying to migrate to 11g. You wish to create a file to generate command for adding services. You can use below script to do same <pre> srvctl config service -d db_name >services.lst cat services.lst|while read ln do echo $ln|sed 's/PREF//'|sed 's/AVAIL//'|awk -F : '{print "-s " $1 "-r" $2 "-a" $3}'|sed 's/ /,/g'|sed 's/-r,/-r/'|sed 's/,-a/ -a/'|sed 's/-a,/ -a / '|sed 's/-s,/ -s / '|sed 's/,-r/ -r / '|sed 's/-a$/ /'|sed 's/^/srvctl add service -d db_name/' done </pre> Thanks to Alok Kumar Amit Bansal on "Disaster recovery scenarios of RAC 11gR2" http://www.forum.askdba.org/topic/disaster-recovery-scenarios-of-rac-11gr2#post-233 Thu, 07 Jul 2011 03:55:35 +0000 Amit Bansal 233@http://www.forum.askdba.org/ Actually when you take backup on disk (assuming you have linked rman library with tape and set sbt_type) and are using catalog. Oracle will know which backup to restore. Check in Myoracle support for 'rman tape' and you will find many articles related to it. orabcn on "Disaster recovery scenarios of RAC 11gR2" http://www.forum.askdba.org/topic/disaster-recovery-scenarios-of-rac-11gr2#post-225 Mon, 04 Jul 2011 12:20:44 +0000 orabcn 225@http://www.forum.askdba.org/ Thank you, The new instance will use file system instead of ASM. I don't care about this part of restoring the database when the backup is in disk! I care about the part of restoring the FRA from the tape! Amit Bansal on "Disaster recovery scenarios of RAC 11gR2" http://www.forum.askdba.org/topic/disaster-recovery-scenarios-of-rac-11gr2#post-224 Mon, 04 Jul 2011 03:37:00 +0000 Amit Bansal 224@http://www.forum.askdba.org/ I think you should check regarding licensing terms with Oracle sales representative. I believe if you restore on new server and use it for some number of days, you have to pay license cost. Not sure on this. I have done ASM restore operation in past but don't have documented steps. You will have to create the ASM Diskgroup disk's prior to running the restore operation. Also if you are having any aliases like '+DG/orabcn (where orabcn is not oracle_sid), you will have to pre-create before starting restore. Regards Amit orabcn on "Disaster recovery scenarios of RAC 11gR2" http://www.forum.askdba.org/topic/disaster-recovery-scenarios-of-rac-11gr2#post-223 Fri, 01 Jul 2011 12:36:08 +0000 orabcn 223@http://www.forum.askdba.org/ than you, the thing is we don't have license to use dataguard. I have to think about the best, easier solution to restore from tapes and then restore/recover my database (database + ASM) to a dedicated single instance on a separated server located in another data center. could you share your experience and advice the step by step of doing it? Amit Bansal on "Disaster recovery scenarios of RAC 11gR2" http://www.forum.askdba.org/topic/disaster-recovery-scenarios-of-rac-11gr2#post-221 Thu, 30 Jun 2011 05:50:17 +0000 Amit Bansal 221@http://www.forum.askdba.org/ hi Orabcn, I think what you require is disaster recover solution which is provided by using Oracle dataguard. So you can create a bcp for your existing RAC database which will help in case your primary RAC servers are gone. Also note that restoring from tape can take time, so you should have 1 backup copy on disk's. Amit Bansal on "CRS and ORACLE_HOME wiped out accidentally on node1" http://www.forum.askdba.org/topic/crs-and-oracle_home-wiped-out-accidentally-on-node1#post-220 Thu, 30 Jun 2011 05:46:57 +0000 Amit Bansal 220@http://www.forum.askdba.org/ hi Ksingh, I think you can just copy the two oracle homes from other node and then run root102.sh/root.sh from CRS_HOME. No such thing is required for db home. -Amit Saurabh Sood on "CRS and ORACLE_HOME wiped out accidentally on node1" http://www.forum.askdba.org/topic/crs-and-oracle_home-wiped-out-accidentally-on-node1#post-219 Thu, 30 Jun 2011 04:50:17 +0000 Saurabh Sood 219@http://www.forum.askdba.org/ Hi, Please show us the errors that you are getting while doing this... ksingh25 on "CRS and ORACLE_HOME wiped out accidentally on node1" http://www.forum.askdba.org/topic/crs-and-oracle_home-wiped-out-accidentally-on-node1#post-218 Tue, 28 Jun 2011 17:42:10 +0000 ksingh25 218@http://www.forum.askdba.org/ File systems where datafiles,control and logfiles were located are fine, so only software filesystems had issues. I had asked tape team to restore ORACLE_HOME and CRS binaries filesystem, they had restored it to a separate file system location. I had tared the files/directoies from restore location and untared them under db_1 and crs_1 homes. But I am still not able to start crs.