Sponsored Content
Operating Systems Solaris How to converting rac to one rac ? Post 302565537 by imtheone on Tuesday 18th of October 2011 07:14:16 AM
Old 10-18-2011
How to converting rac to one rac ?

hi everyone,

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

Database:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

Last edited by radoulov; 10-18-2011 at 06:52 PM.. Reason: Code tags.
 

9 More Discussions You Might Find Interesting

1. Gentoo

RAC on Linux

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)
Discussion started by: sriny
2 Replies

2. UNIX for Advanced & Expert Users

Oracle RAC on AIX

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)
Discussion started by: johnf
1 Replies

3. AIX

RAC on 5.3

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)
Discussion started by: johnf
2 Replies

4. UNIX and Linux Applications

Setting up Oracle RAC at home

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)
Discussion started by: luft
2 Replies

5. HP-UX

HP-UX oracle RAC problem

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)
Discussion started by: h@foorsa.biz
0 Replies

6. Shell Programming and Scripting

script for RAC information required

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)
Discussion started by: jnrpeardba
3 Replies

7. HP-UX

Serviceguard Extension for RAC

Dear All, From where to download freeware of Serviceguard Extension for RAC software for HP UNIX PA RISC B.11.11 OS. BR, Prasanth (3 Replies)
Discussion started by: prasanth438
3 Replies

8. AIX

VIO Oracle RAC

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)
Discussion started by: pashan
1 Replies

9. UNIX for Advanced & Expert Users

Different multipath softwares for RAC

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)
Discussion started by: vlkkck
5 Replies
install-solaris(1M)													       install-solaris(1M)

NAME
install-solaris - install the Solaris operating system SYNOPSIS
install-solaris install-solaris invokes the Solaris Install program. Depending on graphical capability and available memory at the time of invocation, install-solaris invokes either a text-based installer or a graphical installer. The following minimum requirements for physical memory dictate which features are available during installation: For SPARC machines: 128 MB Minimum physical memory for all installation types 128 MB Minimum physical memory required for windowing system 384 MB Minimum physical memory required for graphical-based installation For x86 machines: 256 MB Minimum physical memory for all installation types 256 MB Minimum physical memory required for windowing system 512 MB Minimum physical memory required for graphical-based installation In some cases, even if the minimum physical memory is present, available virtual memory after system startup can limit the number of fea- tures available. install-solaris exists only on the Solaris installation media (CD or DVD) and should be invoked only from there. Refer to the for more details. install-solaris allows installation of the operating system onto any standalone system. install-solaris loads the software available on the installation media. Refer to the for disk space requirements. Refer to the for more information on the various menus and selections. See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWcdrom (Solaris instal- | | |lation media) | +-----------------------------+-----------------------------+ |Interface Stability |Evolving | +-----------------------------+-----------------------------+ pkginfo(1), install(1M), pkgadd(1M), attributes(5) It is advisable to exit install-solaris by means of the exit options in the install-solaris menus. 23 Sep 2005 install-solaris(1M)
All times are GMT -4. The time now is 11:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy