Oracle LOCAL_LISTENER parameter in a RAC database.

I read the manual from oracle with regard to the configuration of listener in a RAC database.http://download-west.oracle.com/docs/cd/B19306_01/install.102/b14203/undrstnd.htm#BEIHGBADThe manual said that if you have configured "REMOTE_LISTENER", you MUSTconfigured "LOCAL_LISTENER".I created a test R ...

Oracle Compatability Parameter change in 10.2.0.2 RAC

We have a huge production DB in 10.2.0.2 RAC with three nodes, Before the RAC implementation the database was on a single instance under 9.2.0.8 Version,But the compatability parameter still on 9.2.0.8 after the 10.2.0.2 RAC conversion, How do we change the compatability parameter from 9.2.0.8 to 10 ...

Oracle RAC parameter file

I was reading thru a RAC book and came across the following."In RAC environment, all instancess shoud share the system parameter file".Could someone provide me sample system parmaeter file in 2 or more node RAC environment?In unix/linux environment. ...

Oracle setting active_instance_count RAC parameter

I try to set the active_instance_count parameter in my 2 nodes RAC database and it was nit successful, here bellow the steps i followed.1- create a pfile from spfile in all nodes2- modify the pfile created in adding the *.active_instance_count=1 for all nodes3- shutdown the instance ifor all nodes4- ...

Oracle What parameter need to set in order to enable parallel execution query RAC

Oracle db version 10.2.0.4.0.OS:- RHEL 4.I want to use parallel feature of Oracle RAC .I have two node RAC .In node 1 i have set following parameterinstance_groups dev,dev1parallel_instance_group devfor second node instance_groups dev,dev2parallel_instance_group devrest of following parallel paramet ...

Oracle Should I specify the Parallel parameter for an non-RAC database?

The Oracle documatation state as the following:"The Oracle Database 10g Release 2 database controls and balances all parallel operations, based upon available resources, request priorities and actual system load." It show that Oracle can optimize the Parallel level automaticly.Should I specify the P ...

Oracle nproc kernel parameter for HP-UX in RAC

There is one kernel parameter "nproc" to configure in the HP-UX kernel. The default value is 4096. It is important because more other parameters depends up this.Could you tell me somebady Wich value its better for this parameter? ...

Oracle Changing parameter in RAC node one by one

I want to change the following log_buffer in two node RAC cluster.alter system set log_buffer=5242880 scope=spfile;To ensure availability, how the command can be issued on each node avoiding any downtime of both the nodes. Means, reflecting the change in one node first after finishing the tasks, do ...

Oracle RAC 11g Rel2 - clusterware wont come up after ASM parameter changes Help!

I was tring to make the below parameter change in ASM, but got the below error messageSQL> alter system set db_cache_size=200M scope=spfile sid='*';alter system set db_cache_size=200M scope=spfile sid='*'*ERROR at line 1:ORA-32017: failure in updating SPFILEORA-00384: Insufficient memory to grow ...

Oracle log sequence in RAC database

10.2 Doc. says: http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta008.htm#RCMRF106Although the SEQUENCE parameter does not require that THREAD be specified, a given log sequence always implies a threadDoes this mean that the log sequence is unique for all threads ? If not what d ...

RAC on windows : A query

FolksI have a small query if soneone can respond. I want to know if there is any issue in running Windows Domain controller service on a Windows cluster which is running Oracle Real application cluster. The configuration is 2 nodes Windows 2000 cluster and RAC ( Oracle ver. 9.2.0.4). We frequently e ...

Problem running root.sh during RAC install.

I'm having trouble with an install of RAC 10gR2 (10.0.2.0.1.0). It's a 2-node system running on vmware. The OS is RHEL 4.I'm using two shared raw drives (virtual of course) as ocr, voting.When I run root.sh I get the following:Setting the permissions on OCR backup directory Setting up NS directories ...

Oracle how to Change REMOTE_LOGIN_PASSWORDFILE Parameter

in two node RAC how i can change parameter REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE in spfile.I tried to copy spfile to init file but it doesnot shows REMOTE_LOGIN_PASSWORDFILE parameter ...

Oracle 9i RAC Load Balancing

I need some advice for this.INTRO:I got 2 instances of a 9i RAC registered with each's listener via REMOTE_LISTENER parameter but I am not sure if there is any load-balancing being done among these 2 instances. I am using Dedicated server configuration for my RAC.QUESTION:Does the server-side load-b ...

Oracle LOCAL_LISTENER on RAC

I am trying to setup a DISPATCHER to assist SQLPlus communication across a Firewall but I need to setup a LOCAL_LISTENER parameter for that. The Database is a 10g RAC so I am not sure what to set the Host parameter to in both of these variable definitions. Do I have to put the LOCAL_LISTENER and DIS ...

Oracle archive log on RAC (per instance) error

I am facing a problem.I implemented RAC 9oracle 9.2) on IBM aix.I enabled archive log per instances cos i dont ahve shared disk except RAwdevices.I done the following steps to accomplish that one1)set on fisrt node SIH1cluster_Database=FALSElog_archive_dest_1='location=/s01/orabak/archlog1'log_archi ...

Oracle tnsname for RAC

I am working on RAC.And I want to connect client to the database but I don't know the tnsname's parameter. I tried the normal way which is configuring the IP address and port number and SID and it didn't work. Please help if there is a different way to configure the tnsnames on RAC.Wessam ...

Oracle Problems starting ASM on 10g RAC (Centos 4.1)

I am in the process of installing 10G (10.2.0) RAC on an x86 box with CentOs 4.1.Everything appears to have installed ok oncluding ocfs2. However when I try to configure ASM the following occurs:I run "dbca &" having first run ssh-add and ensured no passwords are required.I select Oracle RAC dat ...

INSTALL Oracle 10g RAC on Windows 2003. ERROR on starting services

During installation assistances try to configure and start RAC services,but I get next message with error:Starting to execute configuration assistants Launched configuration assistant 'Oracle Cluster Ready Services Configuration Assistant'Tool type is: Optional.The command being spawned is: 'C:\orac ...

INSTALL Oracle 10g RAC on Windows 2003. ERROR on starting services

During installation assistances try to configure and start RAC services,but I get next message with error:Starting to execute configuration assistants Launched configuration assistant 'Oracle Cluster Ready Services Configuration Assistant'Tool type is: Optional.The command being spawned is: 'C:\orac ...

Oracle CRS-0210: Could not find resource while start ASM on 10G RAC

I'm trying to install 10g RAC on Redhat 4.1. At the point at which I try to start ASM it fails with the messageORA-03113: end-of-file on communication channelselect value from v$parameter where name='instance_type'*ERROR at line 1:ORA-01034: ORACLE not availableThis seems to be due to a failure CRS. ...

Oracle Configure a data source to connect to RAC 10g

I am trying to connect to a Oracle RAC 10g and had a question regarding the connection parameter. I do not want the connection to be pinned to a specific RAC instance rather have RAC listener do load balancing when I send the request to the RAC. What should my db url in my connection look like to co ...

Oracle Character set conversion with CSALTER script on RAC database 10G

i have the following problem, my database is configured with characterset WE8ISO8859P1 and I want to convert it to WE8ISO8859P15 in order to support the Euro symbol.I did csscan to check if I run in problems when i convert the database and here is a part of the logfile output which shows that i shou ...

Oracle RAC:error logging of control files

pls help me in this problemThere are two active - active nodes in RAC environment.- appdb01 andappdb02. And each node is running two instances - ASM1/nsdl1 on appdb01and ASM2/nsdl2 on appdb02 respectively. RMAN database has been configured into primary databse i.e-on appdb01 node.Storage area is SAN ...

Oracle OCFS2 RAC Failover Problem

I've a 2 node RAC setup with RHEL4 U3+10gR1( 32 bit )+OCFS2 1.2.1The processes are not able to failover to the 2nd node whenever i switch off the first node. And when i startup the first node again, it hangs at the "Enabling Swap Space" point. The same setup was working fine when i had ASM installed ...

Oracle Setting SDU size in RAC environment

I need to set SDU size in a RAC environment. The instance does a dynamic registration with listener. I am not able to find documents on how to set the sdu in rac. Pl let me know if this can be done in local_listener parameter. ...

Oracle Application responds FASTER with one of two RAC instances DOWN.

Anyone in the forum ever had a case where a twon-node RAC database's application responds fast when only one of instances are alive?We have performed serveral tests, and the evidence is clear: if both instances are running, the response time is slower than with only one instance up. It doesn't matte ...

Oracle Oralce 10g RAC listener

I installed Oracle 10g R2 RAC on RHEL4(U4), the RAC nodes work fine, but after I restart all nodes, I found the listener was listening on 0.0.0.0(1521), instead of the vip and local IP. tcp 0 0 0.0.0.0:1521 0.0.0.0:* LISTEN 17043/tnslsnrBefore reboot, it is like: (2.147 is the vip) tcp 0 0 172.16.2. ...

Oracle 10gR2 RAC installation on RHEL4: node's hostname must be lower case?

everyone, I am installing 10gR2 RAC on RHEL4, 2 node. hostnamepublic private vipRAC1 RAC1-priv RAC1-vipRAC2 RAC2-priv RAC2-vipbut when I run the root.sh in the second node, I got this error:[root@RAC2 ~]# /home/oracle/app/oracle/product/10.2.0/db_1/root.shWARNING: directory '/home/oracle/app/oracle/ ...

Install Oracle10gR2 RAC on Enterprise Linux

i'm trying to install rac on enterprise linux but i get an error during the launch of VIPCA. This is a log:./root.shWARNING: directory '/orclsw/app/10.2' is not owned by rootWARNING: directory '/orclsw/app' is not owned by rootWARNING: directory '/orclsw' is not owned by rootChecking to see if Oracl ...

Oracle Parameter Q

I just looked on some parameters in one of ours db and got confused by:v$spparameter - timed_statistics=FALSEv$parameter - timed_statistics=TRUEIt is a 2 nodes RAC.1.Any clues why there is difference in parameters?2. What is the way to navigate to location on the shared storage?( +xxxx/prd/spfileprd ...

Oracle rac & client connection

i have 3 nodes of 9204 RAC under rhel 2.1SQL> host lsnrctl statusLSNRCTL for Linux: Version 9.2.0.4.0 - Production on 19-FEB-2007 10:53:44Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1pub)(PORT=1521)))STATUS of the LI ...

Oracle Hi i have problem in RAC Environment

HiI have one two node RAC environment with two instances of database.Our problem is whenever user connects with our database it always connects to instance one. so there is heavy load on one instance while another instance is idle.Is there any way to solve this problem? Is there any parameter which ...

Enabling oracle TAF on RAc environment

We are using Oracle 10g with RAC and ASM, i'm in testign phase now and i test if the one node is down automatically database connexion will use the other node. Note that we have only 02 nodes. For doing that i ahve seen to a documentation by creating CRM service to enable TAF (Transparent Applicatio ...

Database writing very slow (oracle 10g with RAC and ASM disk)

I have a problem of database server. When i import data it's very slow i mean importing is very slow and inserting data to database too. I don't know why but reading is fine. I'm running with HPUX and RAC and oracle database 10g real 2 with ASM. I don't with ASm configuration is wrong but i'm new to ...

Oracle [Urgent!! ] spfile path with RAC

I would like to use spfile when I startup a instance, which consists of a RAC database.I issued the following : create spfile='\\.\spfile' from pfile;shutdown immediatestartup Now, the instance is open.However, the instance is open with "pfile" , not "spfile"; SQL> show parameter spfileNAME TYPE ...

Oracle Order By Parameter UNION Issue!!

i have a query in which i have to order by a parameter.but my problem is order by works only for non-union query if i add union to the query it gives error.please see following.. SQL> SELECT H.BOL_NUMBER BOL_NUMBER,2 H.PICKUP_NUMBER,3 to_char(H.PICKUP_DATE,'DD-MON-YYYY') PICKUP_DATE,4 RAC.CUSTOME ...

Oracle Loadbalancing in RAC

To setup a proper loadbalancing in a three node RAC, what parameter need to be defined and where? We have installed RAC and we are using CRS and but it seemds load balancing is not properly happening. Can any one please advice on it. ...

Oracle [urgent] 10gR2 RAC Load Balancing Configuration (client and server side)!!

An oracle engineer working with me created a RAC database 10gR2 by runninga database creation script, not DBCA that is recommended from oracle in creating a RAC database. The following is from oracle."http://download-west.oracle.com/docs/cd/B19306_01/rac.102/b28759/configwlm.htm#CHDJIAJH#CHDJIAJH"Th ...

Oracle Need Help on RAC

I am new to RAC environment. Please suggest some documents.And i need the procedure for shutting down database/nodes/pakages procedureplus i need to know how to change static parameters (like processes etc) in one database.In my environment, we have two nodes.We are using Raw devices+asm for storing ...

Oracle Tnsnames problem on RAC server for Different Host Names

We have RAC database setup and we are facing one issue on tnsnames.My Hostfile has these entries:127.0.0.1 loopback localhost# Public Network204.7.242.215 oradb1204.7.242.217 oradb2# Management network174.19.1.151 oradb1_mgt174.19.1.154 oradb2_mgt# Rac VIP204.7.242.216 oradb1-vip1204.7.242.218 oradb ...

Oracle RAC Instances using different spfile

I have ASM instance is running on both the RAC servers and I am using SPFILE. I made some changes in SPFILE of the database instances and tried to modify few parameters with scope=both and also with scope =spfile and then bounced both the database instances.All the changes can be seen in both the in ...

Oracle How to switch from noarchivelog to archivelog in 9i RAC db?

I have a 9i rac db which is in noarchivelog mode, I tried to switch it to archivelog but failed. I seen documents about setting the CLUSTER DATABASE=FALSE to first then use start the instance in nomount state and alter db to archivelog mode. But when I set the CLUSTER DATABASE parameter in spfile of ...

Oracle problem for 10g RAC upgrading.

try to upgrade RAC(two nodes) from 10.2.0.1 to 10.2.0.3oracle clusterware and database patching is done well.now want to use dbua to upgrade database.to use dbua, firstly, I need to start up instance on each node.I found out a problem:I ONLY can start up node1's instance1 (esbstg1) using ASM shared ...

Oracle RAC option

hellowhen i query the v$option view i noticed that the "Real Application Cluster" option is FalseSQL> select * from v$option where parameter like '%Real%';PARAMETER VALUE Real Application ClustersFALSEdoes this mean that i cant use this database as a cluster database if i install oracle cluster s ...

Oracle 10G RAC - Streams config intra database fails with instantiation

Apologies if this topic has already been covered elsewhere... but...I have a four node 10G RAC running on Windows X64 and Oracle Enterprise 10.2.0.3. I use a service name to connect to the Cluster and use TAF and load balancing.I need to replicate DML only changes between two different schemas withi ...

Oracle Switch off Archive log in RAC.

I am trying to switch off the archive log on our test databases due to space issues frequently. There are 3 databases on RAC in 2 node cluster, out of three databases2 databases are using spfile and one is using pfile. I am trying to do the following steps in order to switch off the log and I would ...

Oracle RAC problem

following is the error Iam getting while trying to start my node2 in a RAC:SQL> startupORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '/oracle/oracle10g/product/10.2.0/db_1/dbs/initorcl1.ora'my RAC is on RHEL 4 and using oracle 10.2there are in all two ...

Oracle Question on RAC

I've one basic question related to our RAC and ETL Client setup.Here is a scenario:RAC Cluster consisting of following nodes:Node1, Node2, Node3ETL Client consists of:Node4There is a log directory "/var/opt/log/" on Node4 (to log ETL execution messages)I would like to log all my DB query execution m ...

Oracle RAC and fast_start_mttr_target

I am trying to set the above parameter in a database in a 2 node clusterI am using the following commandalter system set fast_start_mttr_target = 10 scope=both sid='NAME'however when I try to look at the parameter I get the followingDB is 10.2.0.2 on linuxSQL> show parameter fast   NAME TYPE ...