Topics with the most posts

Topics with the most posts http://www.forum.askdba.org/ Forum for Oracle DBA's en Sat, 11 Feb 2012 11:44:34 +0000 deepika.dhamija@gmail.com on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-111 Wed, 09 Dec 2009 12:29:40 +0000 deepika.dhamija@gmail.com 111@http://www.forum.askdba.org/ Amit, I am finally able to achieve what I intended to do. Many Thanks to you for your valuable suggestions. daniesh on "clone database using Hot backup" http://www.forum.askdba.org/topic/clone-database-using-hot-backup#post-46 Wed, 26 Nov 2008 07:15:52 +0000 daniesh 46@http://www.forum.askdba.org/ Hi Amit, Thanks for your time and input. Saurabh Sood on "DR rebuild- Data restore issue" http://www.forum.askdba.org/topic/dr-rebuild-data-restore-issue#post-140 Sun, 14 Mar 2010 06:15:39 +0000 Saurabh Sood 140@http://www.forum.askdba.org/ Please update the complete backup script that you are using to take backup Amit Bansal on "Multiple Oracle home RAC" http://www.forum.askdba.org/topic/multiple-oracle-home-rac#post-26 Tue, 30 Sep 2008 11:28:21 +0000 Amit Bansal 26@http://www.forum.askdba.org/ 1) Yes, you need to use only one ASM and CRS version. 2) Yes, in this case it will support 10.2 and 10.1 databases 3) Yes it can support. But again if there is any feature which is available in newer release , you will not be able to use it with lower release database. Starting from 11g, you have COMPATIBLE.ASM and COMPATIBLE.RDBMS disk group attributes which specify the compatibility settings for Oracle ASM and database instances. Check following for more detail <a href="http://download.oracle.com/docs/cd/B28359_01/server.111/b31107/asmdiskgrps.htm#CHDDIGBJ" rel="nofollow">http://download.oracle.com/docs/cd/B28359_01/server.111/b31107/asmdiskgrps.htm#CHDDIGBJ</a> Saurabh Sood on "Adding datafile" http://www.forum.askdba.org/topic/adding-datafile#post-52 Mon, 19 Jan 2009 15:05:43 +0000 Saurabh Sood 52@http://www.forum.askdba.org/ Hi Daniesh, Please let me know once you are through these steps. Cheers!!!!!!! Saurabh Saurabh Sood on "error in invoking target 'client_sharedlib'" http://www.forum.askdba.org/topic/error-in-invoking-target-client_sharedlib#post-69 Wed, 08 Jul 2009 04:51:41 +0000 Saurabh Sood 69@http://www.forum.askdba.org/ Daniesh, paste the content of installation log file, it will help me to know what exactly is happening at your end. -- Saurabh Sood Anonymous on "PKRS-1009 failed to start ASM instance" http://www.forum.askdba.org/topic/pkrs-1009-failed-to-start-asm-instance#post-156 Wed, 02 Jun 2010 08:12:10 +0000 Anonymous 156@http://www.forum.askdba.org/ Permissions on init+ASM2.ora is right.I am only facing this problem when i was starting ASM through srvctl command otherwise it's working fine. Please note this point. Anonymous on "how to connect 11gR2 RAC db using sql" http://www.forum.askdba.org/topic/how-to-connect-11gr2-rac-db-using-sql#post-159 Sat, 12 Jun 2010 11:06:24 +0000 Anonymous 159@http://www.forum.askdba.org/ HI, Looking like a interesting thread going on. Its good that people are actually willing to share their views on this topic. 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. Amit Bansal on "CPU patch and catcpu.sql" http://www.forum.askdba.org/topic/cpu-patch-and-catcpusql#post-62 Tue, 24 Mar 2009 13:48:08 +0000 Amit Bansal 62@http://www.forum.askdba.org/ Daniesh, I would say it's a question which never came to my mind. This is my understanding from the captcpu.sql notes. Catcpu.sql inturn calls a script called catbundle.sql which is located under $ORACLE_HOME/rdbms/admin This script will load sql files in database by looking in bundledata_CPU.xml for file information for particular patch. It will be creating a dynamic apply sql file and run it. Hope this helps. Cheers Amit Amit Bansal on "asmcmd register" http://www.forum.askdba.org/topic/asmcmd-register#post-96 Thu, 01 Oct 2009 10:26:02 +0000 Amit Bansal 96@http://www.forum.askdba.org/ Daniel, Please find below response to your questions.. 1)In RAC all instances will show same data from asmcmd. To use asmcmd, you need to export ORACLE_SID to +ASM4 by logging on 4th instance. 2)When you create database using DBCA, oracle automatically add's database to the OCR. In case you wish to add instance, then use DBCA instance management option to add instance which will also register the database. In case you created db/added instance manually, then you need to use srvctl command for same Refer srvctl reference guide for more details <a href="http://download.oracle.com/docs/cd/B19306_01/rac.102/b14197/srvctladmin.htm" rel="nofollow">http://download.oracle.com/docs/cd/B19306_01/rac.102/b14197/srvctladmin.htm</a> Saurabh Sood on "Datapump dumpfile with dates" http://www.forum.askdba.org/topic/datapump-dumpfile-with-dates#post-152 Thu, 20 May 2010 09:34:05 +0000 Saurabh Sood 152@http://www.forum.askdba.org/ Hi, As you mentioned earlier, and that i missed..... You are using this on windows .. The syntax which I have mentioned is not for windows but will work only for unix platforms only.. Amit Bansal on "register standby database in recovery catalog." http://www.forum.askdba.org/topic/register-standby-database-in-recovery-catalog#post-188 Sun, 17 Oct 2010 04:15:52 +0000 Amit Bansal 188@http://www.forum.askdba.org/ Daniesh, Apologies, didnt read the question properly. I have not seen any configuration using different catalog for primary and standby (there could be but I havent seen it). Moreover purpose of using rman at standby site is to reduce workload on primary so that in case of failure you can restore the backup. In case of failure, you would need to connect to this very catalog. Anyways I think you can register first primary database at catalog and then take standy backups. Checked docs (<a href="http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmcatdb.htm#CIHECCEF" rel="nofollow">http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmcatdb.htm#CIHECCEF</a>) and they mention that registration can only be done at primary database. -Amit Ashish on "Pre Installation Reqrtment" http://www.forum.askdba.org/topic/pre-installation-reqrtment#post-214 Mon, 27 Jun 2011 08:32:36 +0000 Ashish 214@http://www.forum.askdba.org/ Thanx Saurabh 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 Amit Bansal on "ASM not starting up after system reboot" http://www.forum.askdba.org/topic/asm-not-starting-up-after-system-reboot#post-15 Fri, 29 Aug 2008 07:21:04 +0000 Amit Bansal 15@http://www.forum.askdba.org/ Cool!! Do update ASM alert log entry also in case issue does not resolve.. Ashish on "RMAN Backup" http://www.forum.askdba.org/topic/rman-backup#post-205 Thu, 09 Jun 2011 10:20:06 +0000 Ashish 205@http://www.forum.askdba.org/ Hi Amit, Still i am confused on this point, When we take database in backup mode (User-manage Backup) so more redo is generated . and In RAMAN , if u take DB in Backup mode Redo generated? If it genarate less than User-manage ,so how? Please cleare my confusion. Regards, Ashish Saurabh Sood on "master node configuration on surviving nodes" http://www.forum.askdba.org/topic/master-node-configuration-on-surviving-nodes#post-197 Sun, 06 Feb 2011 07:03:36 +0000 Saurabh Sood 197@http://www.forum.askdba.org/ Daniesh, I am not sure that instance with most recent scn will become master node. to find out the master node number, as I stated earlier: $ vi ocssd.log and fine out for value "master node number", it will show you the number of master node. Other than this, I am not aware of any particular command to find out master node number. With Regards, 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 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 Saurabh Sood on "ASM installation" http://www.forum.askdba.org/topic/asm-installation#post-8 Thu, 07 Aug 2008 02:45:52 +0000 Saurabh Sood 8@http://www.forum.askdba.org/ Did the installation completed successfully? Sasi on "Error while creating of Snapshot" http://www.forum.askdba.org/topic/error-while-creating-of-snapshot#post-16 Fri, 29 Aug 2008 17:13:39 +0000 Sasi 16@http://www.forum.askdba.org/ Monash_aus, << trying to create a snapshot in a different schema to that of base >> thats an interesting one.. creating a MV/snapshot in a different schema to that of base schema. Snapshots were used in 8i. From 9i we should use materialized views (MV) . To create a fast refresh MV we need to create a MV log first in the source schema and give access to this MV log to the target schema. In case if you are not familiar with Materialized View (MV) , refer the below steps to create a MV that will get refreshed once an hour. ----------------------------------- Start ------------------------------------------------------------------- Lets say you have two schemas , SAM and JOHN . Now ,SAM wants to create a materialized view (TAB1_MV) on JOHN.TAB1 table, 1st SAM should have the following privileges granted to him 1.As sysdba grant the following privileges to SAM. grant create materialized view to SAM; grant global query rewrite to SAM; grant on commit refresh to SAM; 2.Login as user JOHN and grant the required table access to SAM, grant select on JOHN.TAB1 to SAM; create materialized view log on JOHN.TAB1 with primary key; The above sql will create a MV log named MLOG$_TAB1 in JOHN schema. grant select on JOHN.MLOG$_TAB1 to SAM; 3.Now connect to SAM schema and run the follwoing SQLs, create materialized view TAB1_MV build immediate refresh fast start with sysdate next sysdate+1/24 with primary key enable query rewrite as SELECT * from TAB1; This creates the required MV and populates the data and refresh takes ple every hour. Hope this helps. ----------------------------------------------------------------------- Note 1: To check if SAM has appropriate privileges to create a materialized view run the following, select grantee,privilege from user_sys_privs ; create materialized global query rewrite on commit refresh should see an output something like above Note 2: If the materialized view log name is more than 30 characters then the name would be trunacted automatically while creating MV log. This will give an error as table not found while creating MV. ----------------------------------------------------- End ---------------------------------------------- For more info on MV refer, (9i) <a href="http://download.oracle.com/docs/cd/B10501_01/server.920/a96567/repmview.htm" rel="nofollow">http://download.oracle.com/docs/cd/B10501_01/server.920/a96567/repmview.htm</a> Amit Bansal on "Audit SELECT" http://www.forum.askdba.org/topic/audit-select#post-30 Fri, 07 Nov 2008 05:23:50 +0000 Amit Bansal 30@http://www.forum.askdba.org/ Hi, Just to add to Suarabh's reply. You can audit select's in database using schema level auditing. e.g audit select on employees will log selects on the employee table. In case of FGA ,we can do fine grained auditing i.e we can define filters and also do auditing at column level. Saurabh Sood on "Database Back up Space optimisation" http://www.forum.askdba.org/topic/database-back-up-space-optimisation#post-55 Fri, 30 Jan 2009 07:34:09 +0000 Saurabh Sood 55@http://www.forum.askdba.org/ Hi, Adding to what Amit said, you can also revisit your backup policy. If it allows you to create incremental backups, then go for it, as only the changed blocks will be backed up and less space will be consumed for next backup. You did not mentioned the version of your DB, if it is 10g then it is worth to read about block_change_tracking feature of 10g. Refer to following oracle documentation about Incremental backups: <a href="http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/bkup004.htm" rel="nofollow">http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/bkup004.htm</a> Cheers!!! Saurabh <a href="http://askdba.org/weblog/" rel="nofollow">http://askdba.org/weblog/</a> Saurabh Sood on "ORA-29760: instance_number parameter not specified" http://www.forum.askdba.org/topic/ora-29760-instance_number-parameter-not-specified#post-75 Fri, 31 Jul 2009 10:26:39 +0000 Saurabh Sood 75@http://www.forum.askdba.org/ Hi, Try to put the following parameters in this pfile: *.cluster_database=true *.cluster_database_instances=2 *.instance_type=asm Regards, Saurabh Sood Anonymous on "ORA-16055" http://www.forum.askdba.org/topic/ora-16055#post-154 Wed, 02 Jun 2010 08:08:05 +0000 Anonymous 154@http://www.forum.askdba.org/ you have a standby database and the standby needs a log that likely you already removed where it thinks it should be /u05/arch/ deepika.dhamija@gmail.com on "Executing SQL from Shell Script" http://www.forum.askdba.org/topic/executing-sql-from-shell-script#post-114 Thu, 24 Dec 2009 10:50:40 +0000 deepika.dhamija@gmail.com 114@http://www.forum.askdba.org/ Thanks Amit. I was able to execute the SQL using the command sqlplus <username>/<password>@<orcl_sid> deepika.dhamija@gmail.com on "ASM Volumes and DiskGroups" http://www.forum.askdba.org/topic/asm-volumes-and-diskgroups#post-117 Wed, 30 Dec 2009 04:19:40 +0000 deepika.dhamija@gmail.com 117@http://www.forum.askdba.org/ Thanks Amit for your reply. I am working for a company that makes protection software and we are planning to extend it to support RAC. Yes, we do realize that RAC Databases are complex and we therefore are also getting in touch with a DBA. These were some of the preliminary doubts that I had. Thanks anyways for your response. upratap on "OS Memory issue" http://www.forum.askdba.org/topic/os-memory-issue#post-132 Thu, 11 Mar 2010 05:36:22 +0000 upratap 132@http://www.forum.askdba.org/ Check the memory usage, as seen from oracle. Check if any process is consuming high memory. then we can check what that session is doing. col name format a30 select sid,name,value from v$statname n,v$sesstat s where n.STATISTIC# = s.STATISTIC# and name like 'session%memory%' order by 3 asc; One thing regarding the inactive sessions is, it is better to set IDLE_TIME in PROFILE or set up DCD(Dead Connection Detection) if it is the problem of client being disconnected and sessions still there.. This helps in cleanup of such sessions.. -Pratap Amit Bansal on "tns issue / sqlnet issue" http://www.forum.askdba.org/topic/tns-issue-sqlnet-issue#post-172 Tue, 10 Aug 2010 08:23:43 +0000 Amit Bansal 172@http://www.forum.askdba.org/ Mic, Why are there two entries for Description in tns entry <pre> (DESCRIPTION=(DESCRIPTION= </pre> You have mentioned that this entries are mentioned in alert log. Have you checked the client from which it is coming. Also as Suvv sugested try checking local_listener and remote_listener value. Note that if you are using scan (11gr2), remote_listener should be scanname:<port> -Amit taraldesai on "ASM DiskGroup" http://www.forum.askdba.org/topic/asm-diskgroup#post-182 Wed, 15 Sep 2010 15:09:36 +0000 taraldesai 182@http://www.forum.askdba.org/ Sorry for late reply I was on vacation. Thanks Amit for information. 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... 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 "error while addign a disk to asm diskgroup" http://www.forum.askdba.org/topic/error-while-addign-a-disk-to-asm-diskgroup#post-19 Fri, 12 Sep 2008 16:18:31 +0000 Saurabh Sood 19@http://www.forum.askdba.org/ Anu, 1. Does the disk appear under v$asm_disk? You can check it as: select group_number, name, path from v$asm_disk; 2. Is this a new LUN created? 3. Have you used asmtoolg to delete any existing lun ? If asmtoolg was used to delete any existing lun then it is mandatory to bounce the ASM instance and then try to add a lun from scratch. -Saurabh Sood Saurabh Sood on "Rman duplicate with cold backup" http://www.forum.askdba.org/topic/rman-duplicate-with-cold-backup#post-27 Thu, 02 Oct 2008 07:20:10 +0000 Saurabh Sood 27@http://www.forum.askdba.org/ Hi Ani, It requires target database in either MOUNT or OPEN stage to duplicate database using RMAN. Could you give the complete RMAN command that you are using to duplicate the database?