finding out which instance is the resource master of a object.Also select * from V$GCSPFMASTER_INFO
returns zero rows.
Does this mean dynamic remastering is disabled???if so which instance will own a object?
I'm using dynamic sql (DBMS_SQL) to define columns of ref cursor. It works Ok but the problem is when i'm using PL/SQL CURSOR in the REF CURSOR. Then,I'm getting :
Error at line 3
ORA-00932: inconsistent datatypes: expected NUMBER got CURSER
ORA-06512: at "SYS.DBMS_SQL", line 1830
ORA-06512: at "TW.PRINT_REF_CURSOR", line 28
ORA-06512: at line 9
Here is my code:
set serveroutput on
exec DBMS_OUTPUT.ENABLE(1000000);
declare
l_cursor sys_refcursor;
begin
[code]....
Is there a solution or bypass?
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
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 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.
We have to perform migration for our RAC database to new SAN that is at new data centre. Since OS is IBM AIX, we can take backup from mksysb for VG and and storage will migrate data from OLD SAN to NEW SAN.
But even we restore VG and SAN data but since our old SAN is emc and new SAN is hitachi, so disk path for all the asm disk group will be changed.
So is there will be any way to rename this disk path for disk group..
We have an Implementation of Non-RAC (Single Instance with Existing ASM-RAC as storage) and below is the Details,
The client have a Real Application Cluster configuration on their AIX Server from there Data Center and they want to implement a Single instance Database that will used ASM as Storage and the storage or Disk that they want to use is the same Disk or Mirror copy of the Disk from their RAC Database.
Scenario:
-The AIX Server that they have is a one-way Hardware Mirroring (PPRC) only and it is not designed to run a 24/7 activity.
-DATAGUARD is not an option.
I have 2 node 11gR1 running on Unix, I want to add 3 more RAC node to it. What are all the steps involved and should I first add 3rd node and then the 4th node or I should add both at the same time? is there any difference between these two methods?
View 1 Replies View RelatedI heard, in RAC environment both clusterware software and oracle software should have similar version.how to find the version of both softwares ?
View 2 Replies View RelatedDo we need to start rsh and rexec services in oracle 11gR2 RAC database servers? Is it required to setup and run RAC database?
View 1 Replies View RelatedTell me the difference between Oracle RAC and Non RAC database including commands and architecture?
View 4 Replies View RelatedI need to change Virtual IP for one of my RAC node as it is conflicting with another server's IP.
View 1 Replies View RelatedAre Oracle cluster and Oracle clusterware are same and has same in meaning in RAC ?
View 6 Replies View Relatedi need to make RAC database setup ,so where can i get the operating system Rpm like bleow
compat-gcc-7.3-2.96.128.i386.rpm
compat-libstdc++-7.3-2.96.128.i386.rpm
compat-libstdc++devel-17.3.3.96.128.i386
compat-gcc-c++7.3.296.128.i386
send me link for the above require rpm for linux AS4.
we have RAC database on two node here on windows server 2008 unfortunately today morning my one my one node os crash its on windows server 2008 my other node its working ok so my database is accessible so i just want to ask if i install again this os on node -1 system so i just want to install only again crs only.because my database is accessible through my other node-2
View 6 Replies View RelatedI have DB on cluster and it set to active/active. ASM disk currently using raw device and connect to SAN storage. So i want to add new ASM disk on current environment.
Does oracle have this doc? What i can see from their said just show adding new ASM to new installation. Does it same as adding new ASM disk to current system? Does it success on implementation?
I get following error when i'm configuring ASM.
I'm using Enterprise Linux and Oracle 11.1.0.6.0
[U]Note:[/U]
[root@RAC1 ~]# rpm -qa|grep asm
oracleasm-2.6.9-78.0.0.0.1.EL-2.0.3-2
oracleasm-support-2.0.3-2
only these two packages in my server. should i have to install oracleasmlib??
[root@RAC1 ~]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM librarydriver. The following questions will determine whether the driver isloaded on boot and what permissions it will have. The current valueswill be shown in brackets ('[]'). Hitting <ENTER> without typing an answer will keep that current value. Ctrl-C will abort.
Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: y
Fix permissions of Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: [ OK ]
[B]Loading module "oracleasm": Unable to load module "oracleasm"
[FAILED][/B]
I don't have this package in my installation cd, when i searched in the web i could not find
I am planning to install oracle RAC 11g R2 on RHEL 5.3. I have 2 RAC nodes and one openfiler NAS. I need to understand how will I configure SCAN IP. Do I need to configure it some where in DSN and OS level or just I need to give this IP and SCAN name while grid install and oracle will create these things?overall steps to configure this or direct me to some documentation where this thing is detailed.
View 6 Replies View RelatedIs there any document available for 10g to 11gR2 RAC upgrade on AIX?
View 1 Replies View Relatedi got a problem while configuring asm in linux operation system for practice purpose and it troughs error the folllowing details are as fallows.
operting system = oracle enterprise linux 5
software =oracle 10g version= 10.1.0.2.0
oerating system kernel parameters=2.6.18-194.el5PAE
when i'as issuing commed(Localconfig add) on root users i'm getting the following error
[root@prod ~] localconfig add
/uo1/app/oracle/product/10.1.0/db_1/bin/localconfig : line 392: /etc/init.d./init.cssd : no such file or directory
/bin/rm: cannot remove '/etc/init.d/init.cssd' no such file or directory
/uo1/app/oracle/product/10.1.0/db_1/bin/localconfig : line 402: /etc/oracle/ocr.loc no such file or directory
in/rm : cannot remove /etc/oracle/ocr.loc' no such file or directory
bin/rm: missing operand
try '/bin/rm --help for more information
solution i tried for this errror
1.i tried to locate lidbl.so.2 libraies using locate libdl.so.2 and cpoied to location create soft link but still its the same error.
2)i tried ti install rpm pakages for kernel 2.6.18-194.el5PAE but still same eror.
3)i export the library path in bash_profile but still i got same problem
up gradation steps from 10g RAC to 11gr2 RAC.
View 1 Replies View RelatedI am having an issue when trying to run a backup from node 207...Initially When trying to run the backup I got this error.
scrbdefrmr207:orarer 54> brbackup -u / -c force -t online -m all -p initRER_online.sap
BR0051I BRBACKUP 7.00 (40)
BR0055I Start of database backup: begnlswy.anf 2011-08-11 21.29.08
BR0484I BRBACKUP log file: /oracle/RER/sapbackup/begnlswy.anf
BR0477I Oracle pfile /oracle/RER/102_64/dbs/initRER001.ora created from spfile /oracle/RER/102_64/dbs/spfileRER001.ora
BR0280I BRBACKUP time stamp: 2011-08-11 21.29.13
BR1351I Configuration of database services:
RER001 PREF: RER001 AVAIL:
RER002 PREF: RER002 AVAIL:
DVEBMGS50_scrbdefrmr207 PREF: RER001 AVAIL: RER002
DVEBMGS50_scrbdefrmr208 PREF: RER002 AVAIL: RER001
[code]....
I have many other rac servers and sids setup this way and they all work,,I can login to sqlplus and do any changes .. no issues going into sqlplus in node 207 and node 208..I have checked the directory i.e mesg and teh files are there ..
scrbdefrmr207:orarer 56> pwd
/oracle/RER/102_64/sqlplus/mesg
scrbdefrmr207:orarer 57> ls
cpyus.msb cpyus.msg sp1us.msb sp1us.msg sp2us.msb sp2us.msg
I think the message is decieving as it complains about oracle home and sp1<lang>.msb not found ,, when i tis there.I have also checked my env variables .. they all there i.e
scrbdefrmr207:orarer 58> env |grep ORA
dbms_type=ORA
ORACLE_SID=RER001
ORACLE_HOME=/oracle/RER/102_64
ORACLE_BASE=/oracle
scrbdefrmr207:orarer 59> env | grep LD_
LD_LIBRARY_PATH=/usr/sap/RER/SYS/exe/run:/oracle/RER/102_64/lib
I an run archives log backups perfectly.. So its only when its trying to connect into the db.
My application uses below jdbc url for database connectivity. Today one of the db node was down for one hour and FAIL OVER did not happen.
<connection-url>
jdbcracle:thin:@(DESCRIPTION=(LOAD_BALANCE=ON)(FAILOVER=ON )(ADDRESS=(PROTOCOL=TCP)(HOST=viphost1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=viphost2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=serv ice_name)))
</connection-url>
We are planning the RAC installations. We are allocate 3TB on HP SAN Storage to be used to setup rac environment with 2 nodes.
Question.
1. Do we accept one 3 TB from SAN engineers or ( Which RAID)
2. Multiple Luns totality to 3 TB.
3. Remember this is 11g R1 OCR and VOTING DISK cannot be managed by ASM.
I am trying to install oracle 10g RAC on CentOS release 5.4 (Final), But when I am not able to configure SSH between oracle users on both node.
Node 1
--------
[oracle@node1 ~]$ id
uid=600(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)
[oracle@node1 ~]$ date
Thu Dec 30 05:14:10 IST 2010
[oracle@node1 ~]$
------------
Node2
----------
[oracle@node2 ~]$ id
uid=600(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)
[oracle@node2 ~]$ date
Thu Dec 30 05:15:32 IST 2010
[oracle@node2 ~]$
---------
OS
----------
[oracle@node2 .ssh]$ cat /etc/redhat-release
CentOS release 5.4 (Final)
[oracle@node2 .ssh]$ date
---------
Host for both node
--------
[oracle@node2 .ssh]$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
# Public
10.1.1.10 node1
10.1.1.11 node2
#Private
20.1.1.10 node1-priv
20.1.1.11 node2-priv
#Virtual
10.1.1.21 node1-vip
10.1.1.22 node2-vip
------------------------
I am using the command to configure SSH provide in the link
[URL].......
We have a script which uses the duplicate functionality of RMAN. It was designed for a standalone database. Now I need to make it work for a cluster DB (RAC installation).
1. Does RMAN support this?
2. Do I need to make separate executions for both the nodes of the cluster?
We are currently blocked because we have no way of getting our system running without this!
******************************8
First attempt:
oracle@sf23> ./nsr_adv_duplicate_db.sh -d ADVFRW_sf25 -t ADVFRW1 -r RCAT -n sys -p sys ->
3808 11:52:49 ----- Starting Cloning Procedure -----
3808 11:52:50 INFO: Client host 'sf25' says, it is 'sf25'.
3808 11:52:51 Getting Original DB Name on the source host (referred by ADVFRW_sf25 TNS-name)...
...
3808 RMAN: GROUP 8 ( '/export/home/oracle/dev/ADVFRW/ADVFRW.redo181' ) SIZE 134217728 REUSE
3808 RMAN: DATAFILE
3808 RMAN: '/export/home/oracle/dev/ADVFRW/ADVFRW.system'
3808 RMAN: CHARACTER SET WE8ISO8859P1
[code]....
Second attempt:
oracle@sf23> ./nsr_adv_duplicate_db.sh -d ADVFRW_sf25 -t ADVFRW -r RCAT -n sys -p sys -c sf25 -s sf04 -g Srv_scl04-backup_DB_grp -l american_america.WE8ISO8859P1
5548 12:27:05 ----- Starting Cloning Procedure -----
5548 12:27:06 INFO: Client host 'sf25' says, it is 'sf25'.
5548 12:27:07 Getting Original DB Name on the source host (referred by ADVFRW_sf25 TNS-name)...
5548 12:27:07 Original DB is 'ADVFRW'
5548 12:27:08 INFO: BGROUP=Srv
[code].......
Now we have contrary error messages. Target DB name ADVFRW does not work, because on the target nodes there are configuration files for the node specific DB names (ADVFRW1.ora on first node resp. ADVFRW2.ora on second node). But with the node specific DB name the script fails, because it does not match with the DB name of the source system.
OS :
6100-01-09-1015
oralce:
11.2.0.1.0 - 64bit RAC
I'm trying to install Oracle 11gR2 RAC on AIX, do we need to turn on Multicasting, can we install without multicasting? Also can I have the ASM disk with external redundancy for OCR and Voting Disk?
View 3 Replies View RelatedSteps for installing Oracle Cluster 10?
View 9 Replies View RelatedI want to restart a 10g database on ASM ? startp and shutdown sequence?I would like to shutdown everything including database, ASM and cluster and startup again
I read at various places but not sure of the sequence For database DB with database instance DB01 and DB02 having ASM instances ASM01 and ASM02 on node1 and node2, I understand following would be the sequence
1)
Login as root on node1
cd $CRS_HOME/bin
./crsctl start crs
2)
Login as root on node2
cd $CRS_HOME/bin
./crsctl start crs
3)
login as oracle on node1
$ORACLE_HOME/bin/srvctl start nodeapps -n node1
4)
login as oracle on node2
$ORACLE_HOME/bin/srvctl start nodeapps -n node2
5)
login as oracle on node1
start ASM instance on node1
$ORACLE_HOME/bin/srvctl start asm01 -n node1
6)
login as oracle on node2
start ASM instance on node2
$ORACLE_HOME/bin/srvctl start asm02 -n node2
7)
Start oracle database (from any node)
$ORACLE_HOME/bin/srvctl start database -d DB
A. confirm if the above sequence is correct?
B. This sequence if corrrect, is same for 10g and 11g?
C. Is shutdown sequence exact reverse of the above?
How to find out which node is master node in oracle 9i RAC database.
View 7 Replies View RelatedWe are about to undertake a storage migration of our RAC environment from EMC to XIV storage.
The migration method we are using means that we will be presented with identical disks post the migration, however the UNIX paths to the disk devices will be changing. Using our migration method it is not possible to present the old and new devices at the same time.
Therefore once the migration is complete i need to update the device configuration to reflect the new paths. I believe this is done using the following techniques but I am unsure as some of the documentation is ambiguous and I have not done this before
Changing path to Voting Disks
crsctl add css votedisk <new_path_to_disk> -force
crsctl delete css votedisk <old_path_to_disk> -force
Changing path to OCR Disks
ocrconfig repair ocr <new_path_to_ocr>
ocrconfig repair ocrmirror <new_path_to_ocrmirror>
Changing paths to ASM disks
alter system set asm_diskstring='<new_device_path>' scope=both;