Clusterware :: Manage Active Passive Cluster On SLES10 SP4

Feb 3, 2013

I have to manage an active passive cluster on SLES10 SP4. Oracle 10.2.0.4. All oracle binaries are on a DRBD Device on mountpoint /oradata. This mountpoint includes the binaries and all datafiles.

I havent installed these systems. At one stage on node died and got reinstalled by a system administrator. After a switch from the running node to the standby node, the cluster is not starting.

Jan 3 14:36:01 a logger: Cluster Ready Services waiting on dependencies. Diagnostics in /tmp/crsctl.6114.
Jan 3 14:36:14 a logger: Waiting for Oracle CSS service to be available before starting
Jan 3 14:36:14 a logger: ASM instance +ASM. Wait 2.

After issuing $ORACLE_HOME/bin/localconfig add the cluster is starting, the asm instance is coming up, and also the database instance is starting.

Shortly after that the db instance dies. Alert log is showing something like recursive sql error. Looks like writing to the datafiles is not working. In asmcmd the diskgroups are showing DISMOUNTED (show MOUNTED before)

so what to do ?
a) Why is it necessary to issue "localconfig add" to make the cluster starting ?
b) What could be a reason for not being able to write to the database ?
c) How to install an active/passive cluster ?
c1) Install OS on both nodes
c2) Install oracle binaries
c2.1) on both nodes in the local files system and do the mapping to the drbd afterwards?
c2.2) only on one node and just switch the mountpoint ?

View 2 Replies


ADVERTISEMENT

Clusterware :: Active / Passive Installation For Oracle 11gR2

Nov 20, 2012

I want to install an active / passive Oracle Configuration for our new 11gR2 system. We do not want to go full blown RAC as yet. We already have an 11gR2 instance that I plan to CLONE to the production server(s).

So. detail the steps that I need to follow .

i.e.
configure the 2 servers (VIFs/Interconnects)
Install GRID/CRS
Clone over the database (do I do this as a SINGLE NODE RAC?)

View 11 Replies View Related

Clusterware :: Oracle RAC And Ocfs2 On One Cluster

Aug 26, 2012

I have a RAC working with SAN raw devices presented to ASM and working fine. My situation has changed since the installation of the RAC. Now I need a shared storage (with a filesystem) to upload some files (so DB can read these as external tables) for this I have used OCFS2.

As you can see I have Oracle RAC on raw ASM + shared storage on OCFS2 and for the time been all seems to be well and working perfectly. Can these coexist with out effecting the other?

View 2 Replies View Related

RAC/ASM Clusterware Installation :: Patching Cluster From 11.2.0.1 To 11.2.0.3?

Aug 15, 2012

I'm a long time Oracle DBA but have only recently started with RAC and have never done any patching or upgrades in a RAC environment.

My environment consists of a 2 node RAC cluster, and 2 physical standbys at separate remote locations.

The database, GI, ASM, and clusterware are all at version 11.2.0.1.

I want to upgrade all components to the latest patchset which is 11.2.0.3. Eventually I also want to apply the latest PSU.

Can I do this without down time? It is a mission critical database where downtime could conceivably endanger lives. If it can't be done with zero downtime, then downtime must be kept to an absolute minimum (minutes, not hours).

I suspect the clusterware needs to be patched first and I do not know whether I can do it on one node at a time.

View 2 Replies View Related

Clusterware :: 2 Oracle SE Instances In 1 Cluster?

Jun 21, 2013

I would like to build a 2-node cluster without RAC.  I desire to operate 2 Oracle database instances for use by 2 separate applications.  I plan to run Linux.  I would like node1 to act as the primary server for the databases in application1 and node2 to act as the failover server for the databases in application1.  Conversely, I want node2 to act as the primary server for databases in application2 and node1 to act as the failover server for databases in application2.  Can Oracle SE and Oracle Clusterware be configured in this this way?

View 2 Replies View Related

RAC/ASM Clusterware Installation :: Virtual IP For Oracle 11gr2 Cluster?

Sep 8, 2012

I created Virtual Private Network for VIP and subnet is 255.255.255.255. I need VPN subnet as 255.255.255.0. How to i create

INS-40911:      Ensure that nodes in the list are up and reachable, and ensure that the node addresses are all in the same subnet.

View 2 Replies View Related

Clusterware :: CRS-4535 - Cannot Communicate With Cluster Ready Services

May 23, 2013

We have 3 node RAC. In one of the node clusterware is down and also CSSD process is down. I got to know that we have to clear socket files in that node.what needs to be done instead ofclearing socket files.

database
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
[code]...

View 3 Replies View Related

RAC/ASM Clusterware Installation :: CPU Usage On Oracle Cluster On AIX 6.1 With No Load

Aug 22, 2012

After installing a 4 node cluster 11.2.0.3 with 16 CPU's (4 on each node) on IBM 795 with aix 6.1 each server is using 0.5 CPU with no user load on the system. Running SIHA on one server typically uses 0.05 CPU with no user load on the system.

View 5 Replies View Related

RAC/ASM Clusterware Installation :: CRS-4535 / Cannot Communicate With Cluster Ready Services

Dec 7, 2012

im having problems with CRS in a Rac installation. Because of this i cant start the database.I installed Oracle Rac 11.2.0.1 with ASM in a Red Hat 5.8 linux server. Everything was ok until a server reboot. I have 2 nodes, nodo1 and nodo2. Both got rebooted and after that im not able to start the cluster.

All the other resources seem to be just fine .

At nodo1:
[root@nodo1 oracle]# crsctl start cluster -all
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'nodo1'
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'nodo2'
CRS-2676: Start of 'ora.cssdmonitor' on 'nodo1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'nodo1'
CRS-2672: Attempting to start 'ora.diskmon' on 'nodo1'
CRS-2676: Start of 'ora.cssdmonitor' on 'nodo2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'nodo2'

[code]....

View 5 Replies View Related

RAC/ASM Clusterware Installation :: Microsoft Cluster Service And ApEX - Compatible?

Jul 25, 2012

I have been asked to look at making an existing Oracle server resilant. The technology I need to use are:

- Windows 2008 R2 Enterprise SP2
- Microsoft Cluster Services
- Oracle Enterprise 11g release 2
- Oracle Fail-Safe (latest version available)

Unfortunately ApEX 4.1 and Mod_plsql are install on the existing stand-alone server. I'm afraid i know very little about Oracle and ApEX but i need to make a design decision and check fiesablilty.

I believe the HTTP service and Mod_plsql can be moved to a independant server which should work but ApEX itself must remian on the database server (i'm told).Will ApEX work in a MSCS setup? I can only find references to RAC support, RAC is out of scope.

View 0 Replies View Related

RAC & Failsafe :: Creating Cluster Resources For Oracle Enterprise Manager Using Clusterware

Oct 24, 2012

My application consists of Oracle RAC and Oracle Enterprise Manage (OEM) on same two nodes. I am exploring the idea of utilizing Oracle Clusterware (which is already installed with Oracle RAC) to support OEM in active passive mode.

Here is the scenario.

Node A running Solaris 10.9 on SPARC and Node B running Solaris 10.9 on SPARC.
Node A and Node B are both Oracle RAC Nodes ( Active Active ) which use Shared Storage for Oracle using ASM.

Node A and Node B will run Oracle Enterprise Manager (OEM) Application in active passive scenario which will be using Oracle RAC for its database. So, both Oracle RAC and OEM are sharing same server A and B for its clusters.

Now, OEM application need a third party clusterware to fail it over. It needs clusterware to provide floating VIP and shared folder of the size of 20GB which will keep software libraries. If node A goes down, node B have access to same libraries and will come up as active.

Do you know if oracle clusterware which comes with Oracle RAC can support OEM for failing over i.e. it can provide floating VIP and shared file system?

View 3 Replies View Related

RAC/ASM Clusterware Installation :: Adding New OCFS Disk To Oracle Cluster On Windows

Oct 17, 2013

We have 2 servers running Oracle 11gR2 Window server 2008 64 bit  RAC. Today I  add new shared disk visible from both servers. All our data placed on ASM partitions, but we need Windows volume for exchanging some data between servers & users;Actions:then i have prepare disk on shared storage from 1st node, run diskmfmt.msc & rescan disks when windows recognizes new hdd, initialize it.create an Extended partition & Logical drive & Assign drive letter. from another nodes, make sure no drive letter is assigned.

Sometimes Windows automatically assign drive letter. If drive letter is assigned, right click & Change drive letter & Remove. from 1st node, format this logical drive using ocfsFormat.exe after execute below scripts i have face some issues  

 E:app11.2.0gridcfs>ocfsformat /m P: /c 1024 /v DATA /f /d /aReg Get Cluster Name(): Reg Query ValueEx for CFS_CLUSTER_NAME failed with error 203

This indicates that the Cluster Name has not been configured on this node for OCFSThe volume formatted in this condition will be seen by all nodes running OCFS. 

View 3 Replies View Related

Clusterware :: Grid On Standalone Server Cluster Daemons Not Starting During Server Boot

Jul 4, 2012

I have installed Oracle Grid on a standalone server and setup Oracle db 11.2.0.2 on Oracle Linux 6.2 64 bit server.When I reoot the server and run crs_stat -t,several daemons havent started thus the ASM and db instances are also down as below

Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type OFFLINE OFFLINE
ora.FRADG.dg ora....up.type OFFLINE OFFLINE
ora....ER.lsnr ora....er.type ONLINE ONLINE amldb01dc
ora.amldb.db ora....se.type OFFLINE OFFLINE
ora.asm ora.asm.type OFFLINE OFFLINE
ora.cssd ora.cssd.type ONLINE OFFLINE
ora.diskmon ora....on.type ONLINE OFFLINE
ora.evmd ora.evm.type ONLINE ONLINE amldb01dc
ora.ons ora.ons.type OFFLINE OFFLINE

I am forced to manually start the daemons via command crsctl start resource -all then I manually start the ASM and db instances. Yet when I run the commands

crsctl config has
CRS-4622: Oracle High Availability Services autostart is enabled.

crsctl check has
CRS-4638: Oracle High Availability Services is online.

Thus I would assume the daemons would start automatically during boot.

View 5 Replies View Related

RAC/ASM Clusterware Installation :: Query On Adding New Node To Existing 2 Node Cluster

Jun 15, 2012

current environment

Oracle VM 2 Node RAC cluster
Oracle 11G 11.2.0.3.0
Oracle 11g rel 2 GI

on current 2 node cluster we have GI and RAC db configured Nodes: vmorarac1,vmorarac2

we shutdown vmorarac1 to clone it to vmorarac5

on new node I have changed the hostname to vmorarac5 In /etc/sysconfig/network-scripts/ifcfg-eth0 change ip to new ip and same for /etc/sysconfig/network-scripts/ifcfg-eth1 152.144.199.210,152.144.199.211

mad echanges to /etc/hosts on vmorarac1/2 for 2 new IP address assigned to vmorarac5

152.144.199.171 vmorarac1.pbi.global.pvt vmorarac1
192.168.2.30 vmorarac1-priv.pbi.global.pvt vmorarac1-priv
152.144.199.184 vmorarac1-vip.pbi.global.pvt vmorarac1-vip

[Code]....

Query is is that all ok to reboot the new node to reflect changes as below and change the hostname to vmorarac2

152.144.199.210 vmorarac2.pbi.global.pvt vmorarac2
192.168.2.32 vmorarac2-priv.pbi.global.pvt vmorarac2-priv
152.144.199.211 vmorarac2-vip.pbi.global.pvt vmorarac2-vip

hostname change in /etc/sysconfig/network

On new node vmorarac5, there is alreay software for RAC DB and GUI cloned from vmorarac1

addnode.sh is used to add existing node, but as part of pre-requisite configuratoin is there any config step missing

View 3 Replies View Related

RAC/ASM Clusterware Installation :: Multiple Cluster Installation In Blade Server?

Dec 6, 2012

I am using newstart cluster software. currently I have two blade servers in my system and I have configured cluster as well. right now I have one issue. I am using the ip address of 10.34.14.0/28 network for cluster but this can not be accessed from all network so I want to use different range of IP of 10.68.1.0/28 network in the same blade servers. Can I configure two different floating (cluster) IP? the first IP range is for signalling and second IP range 10.68.1.0/28 network is for OMM. I need to use both IP in two blade servers.

View 1 Replies View Related

Oracle 10gR2 Installation Failed On SLES10

Jul 15, 2008

While installing Oracle10gR2 on zlinux machine where the OS is SLES10 SP1 I got this error

In installActions2008-07-15_04-37-15PM.log

INFO: /usr/lib64/gcc/s390x-suse-linux/4.1.2/../../../../s390x-suse-linux/bin/ld: skipping incompatible /opt/oracle/10g/lib/stubs/libdl.so when searching for -ldl
/usr/lib64/gcc/s390x-suse-linux/4.1.2/../../../../s390x-suse-linux/bin/ld: skipping incompatible /opt/oracle/10g/lib/stubs/libm.so when searching for -lm

[Code]....

View 1 Replies View Related

RAC & Failsafe :: Two Nodes Active / Active Configuration

Oct 15, 2013

I am getting starting with rac environments. I need to configure a two nodes active/active with rac and I need to know if always using rac both nodes will be active or if I have to do that at some point when installing. I have reading some docs from oracle and others authors about rac and its configuration process but that is not understood for my yet.

View 5 Replies View Related

Backup & Recovery :: RMAN Backup Strategy For Active-active Deployments Using Streams

Jul 25, 2012

We are using oracle as database in our application. For high availability we have a cluster of multiple nodes and the data is replicated using oracle streams. All the nodes in the cluster are active. We do not have any concept of stand-by.

Now we are planning to use oracle RMAN for backup and recovery. RMAN user's guide doesn't recommend any strategies for such deployments. It mainly focuses on primary/stand-by deployments.

View 1 Replies View Related

How To Manage Two Projects For Same User

Jan 9, 2013

I am using Oracle XE with SQL Developer to teach a course on databases.

The students complete a number of small projects. How can a student separate the projects so as to be able to open in SQL Developer only the tables pertaining to a specific project? Ideally, the student would be able to assign the same name to two tables that belong to different projects.

I know that this can be done by naming conventions and filtering, but this is awkward.

View 7 Replies View Related

Backup & Recovery :: How To Manage Archived Log

Jun 8, 2012

How to manage your archived log?

View 9 Replies View Related

SQL & PL/SQL :: Manage Transaction When Called From Java?

Jun 21, 2010

A Java program would call a sequence of 5 PLSQL procedures, and they all need to participates the Tranasction defined in Java.

What do I do for the transactions inside PLSQL to ensure all 5 pariticpate in the Java transaction? I suppose I just do not specify any COMMIT in the PLSQL, but that probably would not work as PLSQL would COMMIT by default after exiting the proc?

View 2 Replies View Related

RMAN :: Manage Incremental Backups?

Feb 15, 2013

We just purchased NAS (Raid5) unit to manage our data storage. I am planning to create a virtual partition on this nas device and use one partition for oracle data storage and another virtual partition will be used by other data (files and may be sqlserver data files....etc..)

We will have oracle installed on seperate oracle server. Can we use RMAN to manage incremental backups in this environment? May main worry point is that our data storage device will have many different type of datas and will we be able to tell RMAN to make backups only from certain virtual drives?

View 3 Replies View Related

Oracle 10g - How To Manage Partition Sizes Dynamically

Jun 6, 2012

We are using oracle 10g. with our code, Currently Oracle partitions are size the same way, each partition is using 10MB for data and 12MB for indexes (with the 6 default indexes); even of very few records are written in the partition.

We create partitions in advance as a part of nightly job with 10 minutes duration.Can some intelligence can be added where based on statistics we can decide the size of partition dynamically? Lot of space is getting wasted because of this reason.

View 1 Replies View Related

Enterprise Manage Console Closing Automatically?

Jul 25, 2013

I have successfully installed the Oracle 10g standerd version with a sample database on Windows server 2008 standard server. Then I installed the client so that I could use the Enterprise manage console that comes with it. Once installed, I was able to successfully configured the Net service. Now when I use either Enterprise manage console or SQL plus to login to the service that I created, once I enter the user id and password and click ok, system automatically closes both applications. I am not sure what is missing. I installed the same client on a windows XP pc and the enterprise manage console is working perfect.

View 1 Replies View Related

Which ASM Process Will Manage Copy Of Data To New Failgroup

Jan 10, 2013

I have a diskgroup with normal redundancy level (2 two failure groups) working fine. I desire add a new failgroup to diskgroup (changing the redundancy level to high).

Which ASM process will manage the copy of data to new failgroup? Are there some way to control or tuning this process?

View 1 Replies View Related

SQL & PL/SQL :: How To Manage Rule Link With Utl_mail Package

Aug 3, 2011

I have 2 questions :

1. How many oracle mechanism can link with oracle send mail mechanism ??
2. Any samples which the oracle send mail mechanism to run with some oracle alert mechanism.

View 3 Replies View Related

Forms :: Beans Items To Manage Movies

Apr 27, 2010

My technical envirment is Winxp, dev9i AS vers9.0.2, Jinit vers1.3.1.9, OracleDB9i.

i want to create a form conatining a BEAN item through which i want to insert and select a BLOB movie from a Table in a database.

View 3 Replies View Related

Application Express :: 4.2 - Can't Go To (INTERNAL) Manage Instance

Oct 16, 2012

I upgraded my APEX instance from 4.1 to 4.2 and now I can't go to (INTERNAL) Manage Instance->Instance Settings I see only ORA-28817: PL/SQL function returned an error.

View 5 Replies View Related

JDeveloper, Java & XML :: How To Manage Large Number Of Record In ArrayList

Feb 5, 2013

how to manage large number of record in ArrayList.i.e abc table has 20 million record and jvm size is 2 GB.

View 1 Replies View Related

Application Express :: How To Manage Positions Of Different Display Points Of Theme

Apr 6, 2013

I'm developing, or trying, on Apex 4.2...The issue is about themes and how to manage the positions of diferents Display Points of a theme.

Everybody know that any theme have a map where its position all differents parts of this map (Body1, Body2, Body3, position01, position02 and so). So when you choice any theme, it come with all this Display points defined. You can see this map rendering any region page and in the item Display Point you can see this map clicking on the light.

There is anyway to can manage this map and change position or behavior of those points?. For example , I'm interested that under the tabs, to have at the same height, 3 diferentes position, one at left, one at center and other at right.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved