We have rac system which has two sun solaris M5000s and two oracle 11gR2 databases respectively. Also , we have unix codes on one rac and these unix codes extract txt files for external tables during first step of ETL.
We run our unix codes using Util.RunThis java code and creating dba jobs of oracle. When we run our unix codes, each dba job choose the rac node randomly. So if any dba job choose second rac , we get error, because unix codes does not exist on our second rac.
We tried to solving that problem with following workaround, but not sucessfull: First we stop listener and vip ip of our second rac. But still dba job manager does continue to choose second rac randomly.
So,...
1) During first step of ETL, how can we use one node without closing second database node ?
2) After first step of ETL is completed, we want continue to use both rac’s. How this is possible ???
Our configuration:
unix system:
Code:
-bash-3.00$ uname -a
SunOS koccrm1 5.10 Generic_142909-17 sun4u sparc SUNW,SPARC-Enterprise
Could you please clarify what do you mean by "we get error, because unix codes does not exist on our second rac"? What exactly doesn't exist on one of the nodes?
Anyway you could:
1. Connect directly to one of the instances (not to a service) and most of the operations will run only on one node.
2. Create a new service that runs only on one node and use it for your ETL processing.
I consider both possibilities dirty workarounds though ...
Could you please clarify what do you mean by "we get error, because unix codes does not exist on our second rac"? What exactly doesn't exist on one of the nodes?
Anyway you could:
1. Connect directly to one of the instances (not to a service) and most of the operations will run only on one node.
2. Create a new service that runs only on one node and use it for your ETL processing.
I consider both possibilities dirty workarounds though ...
Hi Radoulov,
some of our the etl codes are unix shell script and other of them are owb mappings.
the shell scripts are at first node of RAC. and we execute them on server side not client side. the dba jobs of oracle choose a node of RAC for executing those codes. if the dba jobs choose the second node , we get error. because unix shell scripts are only at first node.
we generate util.runthis java class on oracle database for running the unix shell scripts . So i cant connect direct one node.
about your second solution , i dont know anything about create new service.
if we create new service for our etl processes , all nodes of rac will run synchronize ?
First you need to configure OWB with your RAC.
Did you follow the official documentation (OWB should be installed on all RAC nodes).
Check also this MOS note:
How to Verify if OWB is Installed Correctly on RAC and Exadata (Doc ID 455999.1)
Hi radoulov,
we have not got any problems with owb and owb mappings.
Our problem is how to run our shell scripts at first rac?
because second rac does not exists shell scripts .
What I'm trying to say is that your shell scripts should not be bind to one node.
If you need to access regular files from within the database,
then you should make them available to all your instance (by using cluster filesystem, Oracle ACFS comes to mind).
What I'm trying to say is that your shell scripts should not be bind to one node.
If you need to access regular files from within the database,
then you should make them available to all your instance (by using cluster filesystem, Oracle ACFS comes to mind).
i dont wanna make them all my instance. if i wanna use one node for sql , i can do it about using parallel_instance_group and instance_group paremeters.
but when i run shell scripts code i cant do it.
i wanna set one node on RAC , when i run shell scripts.
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)
