AskDBA.org Forum » View: Support topics that are resolved

AskDBA.org Forum » View: Support topics that are resolved http://www.forum.askdba.org/ Forum for Oracle DBA's en Sat, 11 Feb 2012 13:09:59 +0000 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. deepika.dhamija@gmail.com on "Executing SQL from Shell Script" http://www.forum.askdba.org/topic/executing-sql-from-shell-script#post-112 Wed, 23 Dec 2009 07:25:14 +0000 deepika.dhamija@gmail.com 112@http://www.forum.askdba.org/ Hi, I have a two node RAC Cluster Setup (10R2) and I want to execute sql queries from a shell script, to be run as root. I have the foll test.sh script #! /bin/bash echo "In BASH" sqlplus / <<+ENDOFSQL+ select name, path from v$asm_disk; exit +ENDOFSQL+ echo "Back to Bash" exit and I get the foll O/P In BASH SQL*Plus: Release 10.2.0.1.0 - Production on Wed Dec 23 07:25:32 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12546: TNS:permission denied Enter user-name: SP2-0306: Invalid option. Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] where <logon> ::= <username>[/<password>][@<connect_identifier>] | / Enter user-name: Enter password: ERROR: ORA-12546: TNS:permission denied SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus Back to Bash What permissions should for this? 2) Also I need to know the node names of the nodes that form the clustre. I add the foll lines to my script NODE_NAMES=<code>olsnodes</code> echo $NODE_NAMES ad I get O/P linux-1 linux-2 Is it possible to store these space separated node names in diff variables that can then be used. (the number of nodes are variable) Any suggestion/advise is appreciated. Thanks deepika.dhamija@gmail.com on "ASM and Multipathing" http://www.forum.askdba.org/topic/asm-and-multipathing#post-103 Tue, 08 Dec 2009 09:37:34 +0000 deepika.dhamija@gmail.com 103@http://www.forum.askdba.org/ Hi I have a 2node RAC Setup 10gR2. I have three ASM Volumes configured, out of devices sdb2, sdb3, sdb4 /etc/init.d/oracleasm createdisk VOL1 /dev/sdb2 /etc/init.d/oracleasm createdisk VOL2 /dev/sdb3 /etc/init.d/oracleasm createdisk VOL3 /dev/sdb4. where VOL1 & VOL2 belong to the Disk Group ORCL_DATA1 and Vol3 to the group FLASH_RECOVERY_AREA. I want to use the multipath disks namely /dev/multipath/sdb2, /dev/multipath/sdb3 and /dev/multipath/sdb4 for asm volumes. I created the multipath disks on node1 and edited the file /etc/sysconfig/oracleasm and set ORACLEASM_SCANORDER="multipath" and ORACLEASM_SCANEXCLUDE="sdb2 sdb3 sdb4". After a Reboot, the crs_stat shows On Node1 -------------------------------------------------------------------------------- Name Type Target State Host -------------------------------------------------------------------------------- ora....SM1.asm application ONLINE ONLINE linux1 ora....X1.lsnr application ONLINE ONLINE linux1 ora.linux1.gsd application ONLINE ONLINE linux1 ora.linux1.ons application ONLINE ONLINE linux1 ora.linux1.vip application ONLINE ONLINE linux1 ora....SM2.asm application ONLINE ONLINE linux2 ora....X2.lsnr application ONLINE ONLINE linux2 ora.linux2.gsd application ONLINE ONLINE linux2 ora.linux2.ons application ONLINE ONLINE linux2 ora.linux2.vip application ONLINE ONLINE linux2 ora.orcl.db application ONLINE ONLINE linux1 ora....l1.inst application ONLINE OFFLINE ora....l2.inst application ONLINE ONLINE linux2 ora....test.cs application ONLINE ONLINE linux2 ora....cl1.srv application ONLINE OFFLINE ora....cl2.srv application ONLINE ONLINE linux2 oracle@linux1 ~$ sqlplus "/ as sysdba" SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 8 12:04:53 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL> select name, path from v$asm_disk; select name, path from v$asm_disk * ERROR at line 1: ORA-01034: ORACLE not available I try to start the instance manually, oracle@linux1 ~$ srvctl start instance -d orcl -i orcl1 PRKP-1001 : Error starting instance orcl1 on node linux1 CRS-0215: Could not start resource 'ora.orcl.orcl1.inst'. Also from sql SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+ORCL_DATA1/orcl/spfileorcl.ora' ORA-17503: ksfdopn:2 Failed to open file +ORCL_DATA1/orcl/spfileorcl.ora ORA-15077: could not locate ASM instance serving a required diskgroup On Node2 -------------------------------------------------------------------------------- oracle@linux2 ~$ sqlplus "/ as sysdba" SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 8 11:56:13 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options SQL> select name, path from v$asm_disk; NAME -------------------------------------------------------------------------------- PATH -------------------------------------------------------------------------------- VOL1 ORCL:VOL1 VOL2 ORCL:VOL2 VOL3 ORCL:VOL3 Plz note, that I have the multipath devices only on one node currently. I am new to the multipathing concept. Plz advise, on what (above) steps are wrong and what additional things are to be taken care of. And the causes/solutions to the errors. daniesh on "ORA-29760: instance_number parameter not specified" http://www.forum.askdba.org/topic/ora-29760-instance_number-parameter-not-specified#post-73 Thu, 30 Jul 2009 23:05:20 +0000 daniesh 73@http://www.forum.askdba.org/ Hi I have installed ASM on the cluster. its a 2 node cluter. i have installed pfile locally. i am not able to start asm instance using pfile. startup pfile=/u01/app/admin/+ASM/pfile/init+ASM.ora ORA-29760: instance_number parameter not specified. but i have mentioned the above parameter in my pfile. you can find below my pfile parameter setting. instance_type=asm +ASM1.instance_name=+ASM1 +ASM2.instance_name=+ASM2 +ASM1.instance_number=1 +ASM2.instance_number=2 I dont know where i am going wrong. please help me on this. Thanks, JuanCarlosDoohan on "Oracle RAC with many versions" http://www.forum.askdba.org/topic/oracle-rac-with-many-versions-1#post-71 Tue, 14 Jul 2009 09:27:04 +0000 JuanCarlosDoohan 71@http://www.forum.askdba.org/ Hi wisers, I have a project implementation with oracle RAC, the necessities are, Oracle 8, oracle 9 and Oracle 10, because we have deferents front ends, But we need considerate make this implementation in oracle rac, I think that, the solution is oracle rac in virtualization, but yours have another propose, Best regards, Juan Carlos daniesh on "clone database using Hot backup" http://www.forum.askdba.org/topic/clone-database-using-hot-backup#post-39 Mon, 24 Nov 2008 09:09:57 +0000 daniesh 39@http://www.forum.askdba.org/ Hi , I am an Oracle DBA. I am cloning the development database from production. I have some dount. while cloninng the database using hot backup. do we need to copy redo log to the target location. I am getting an error. I am done with the creation of control file but i have not copied the online redo log file. do i need to do copy it manually. Thanks in advance. Daniesh