Hi Radoulov,
sorry maybe my english isnt well .
if unix shell scripts will run on our RAC , i want to direct the unix scripts to first instance for running. i dont want to run those at second instance.
1. Connect directly to a single instance: let's assume you have instanceA and instanceB which both serve n services: serviceA, serviceB ... serviceN.
You could connect to a specific service:
(using sqlplus for the example):
Or connect to a single instance:
You may also limit the instances a specific service could run on (and use that service).
If parallel slaves are involved, you may check the PARALLEL_FORCE_LOCAL parameter (and check MOS for negative effects).
1. Connect directly to a single instance: let's assume you have instanceA and instanceB which both serve n services: serviceA, serviceB ... serviceN.
You could connect to a specific service:
(using sqlplus for the example):
Or connect to a single instance:
You may also limit the instances a specific service could run on (and use that service).
If parallel slaves are involved, you may check the PARALLEL_FORCE_LOCAL parameter (and check MOS for negative effects).
i remember that, but i dont use any connectio because executing job runs on server. you know util.RunThis java class ? that runs all shell scripts on servers.
i know PARALLEL_FORCE_LOCAL parameter , but i use parallel_instance_group and instance_group parameter.
Hi,
I have a RAC installation on 2 solaris 11 nodes. (With ASM)
Disks' mpath are managed by EMC Powerpath on both nodes.
I want to migrate mpath software to Solaris multipath without downtime.
My plan is first migrate node1 to solaris mpath, then after some days migrate node2 to sol.mpath.
My... (5 Replies)
Hi All
I wonder if someone can help me, I'm busy adding an Etherchannel for an Oracle RAC setup on AIX6.1.
en0/ent0 is crrently available on the Lpar... do i need to add another network(SEA) adapter to the Lpar via VIO and if so how do I add and configure the Virtual adapter to the LPAR through... (1 Reply)
Hello,
is it possible for someone to generate a shell script that will do the following, please. UNIX Shell script novice who is after a script to look at a few things within an Oracle RAC environment
Hopefully if this works, I can schedule this via cron
Many thanks
I can execute these... (3 Replies)
Hi all i have a problem which we can't fix
we have 2 hp blades loaded with HP-UX11iv3 and Oracle RAC 11g R1 accessing HP Sotrage works xp 24000
the oracle cluster cannot access the
/dev/oracle/ocr1
i ran
#ioscan -em lun
the result came as follows " please note output turncated for... (0 Replies)
Hello,
I'm planning to set up Oracle 10g RAC at home. I was initaillay planning to get a windows desktop and install Cent OS after wiping out the existing windows OS. I have some questions with regards to this.
1) For setting up RAC, I would have to install an additional NIC besides the one... (2 Replies)
I am setting this up on 5.3 and the problem is I cannot remember how to allocate two IP addresses to a NIC. I have setup an alias on EN0 but when I list it with ifconfig -a it still only shows 1 network address (after a reboot). I know there is something I must do but for the life of me cannot... (2 Replies)
I am setting this up on 5.3 and the problem is I cannot remember how to allocate two IP addresses to a NIC. I have setup an alias on EN0 but when I list it with ifconfig -a it still only shows 1 network address (after a reboot). I know there is something I must do but for the life of me cannot... (1 Reply)
HI have Couple of computer below.
And I would like to know if can use these to practice two node 10GR2 RAC on linux at home.
If I can, what else needed for shared storage and etc.
HP Pavilion a6350z AMD Athlon 64 X2 4200+ 2.2GHz 2GB Ram 250GB HP Pavilion s3300z AMD Athlon 64 BE2400 2.3GHz 2GB... (2 Replies)