| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 10g RAC load-balancing configuration
sudhanshu.goswami_at_gmail.com wrote:
> Hi,
> I am new to RAC administration. I have been trying to configure
> load-balancing across two nodes in a cluster. 192.168.2.5, 192.168.2.6
> are public IP addresses of the nodes and 192.168.2.9, 192.168.2.10 are
> the VIP addresses. My configuration files look like this:
>
>
> -------------------- SQLNET.ORA ---------------------------
> TRACE_LEVEL_CLIENT = OFF
> names.directory_path = (TNSNAMES)
> names.default_domain = world
> name.default_zone = world
> break_poll_skip=2000000000
> ----------------------------------------------------------------------------
>
> --------------------- TNSNAMES.ORA --------------------------
>
> TPCC.world =
> (DESCRIPTION =
> (load_balance = on)
> (failover = on)
> (ADDRESS_LIST =
> (FAILOVER = ON)
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.9)(PORT = 1521))
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.10)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = tpcc)
> )
> )
>
>
> TPCC1.world =
> (DESCRIPTION =
> (load_balance = on)
> (failover = on)
> (ADDRESS_LIST =
> (FAILOVER = ON)
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.9)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = tpcc)
> )
> )
>
>
> TPCC2.world =
> (DESCRIPTION =
> (load_balance = on)
> (failover = on)
> (ADDRESS_LIST =
> (FAILOVER = ON)
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.10)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = tpcc)
> )
> )
>
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> (CONNECT_DATA =
> (SID=PLSExtProc)(PRESENTATION=RO)))
>
> LISTENERS_TPCC =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.9)(PORT = 1521))
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.10)(PORT = 1521))
> )
> ----------------------------------------------------------------------------
>
>
> --------------------- LISTENER.ORA --------------------------
> LISTENER_TPCC1 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.9)(PORT = 1521))
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.5)(PORT = 1521))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> )
>
> LISTENER_TPCC2 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.10)(PORT = 1521))
> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.6)(PORT = 1521))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> )
>
> ----------------------------------------------------------------------------
>
> --------------------------------- INIT.ORA ---------------------------
> BACKGROUND_DUMP_DEST =
> /home/oracle/app/oracle/OraHome_1/rdbms/log
> USER_DUMP_DEST =
> /home/oracle/app/oracle/OraHome_1/rdbms/log
> control_files = ?/dbs/tpcc_disks/control_001
> parallel_max_servers = 48
> DB_BLOCK_SIZE = 2048
> recovery_parallelism = 20
> compatible = 10.1.0.2
> db_name = tpcc
> db_files = 200
> db_file_multiblock_read_count = 16
> pga_aggregate_target = 800m
> dml_locks = 500
> log_checkpoint_interval = 100000000
> log_checkpoints_to_alert = TRUE
> open_cursors = 400
> processes = 200
> sessions = 600
> transactions = 400
> transactions_per_rollback_segment = 1
> cursor_sharing = force
> cursor_space_for_time = TRUE
> timed_statistics = TRUE
> disk_asynch_io = TRUE
> db_writer_processes = 5
> hpux_sched_noage = 178
>
> db_cache_size = 2700m
> java_pool_size = 0
> large_pool_size = 300m
> shared_pool_size = 1000m
>
> log_buffer = 1024000
> db_recycle_cache_size = 16m
> db_cache_advice = ON
> plsql_optimize_level = 2
> undo_management = AUTO
>
> #####cluster parameter #######################
> cluster_database = true
> cluster_database_instances = 2
> tpcc1.thread = 1
> tpcc1.instance_name = tpcc1
> tpcc1.instance_number = 1
> tpcc1.undo_tablespace = UNDOTBS1
> tpcc2.thread = 2
> tpcc2.instance_name = tpcc2
> tpcc2.instance_number = 2
> tpcc2.undo_tablespace = UNDOTBS2
> tpcc1.local_listener = 'LISTENER_TPCC1'
> tpcc2.local_listener = 'LISTENER_TPCC2'
> remote_listener = 'LISTENERS_TPCC'
> #############################################
>
> -------------------------------------------------------------------
>
> On both the nodes I have started the listeners LISTENER_TPCC1 and
> LISTENER_TPCC2 respectively and their status looks similar to this:
>
>
> -------------------------------------------------------------------
>> lsnrctl start LISTENER_TPCC1
hpuxrac is correct. you can not run RAC with a pfile. And your TNSNAMES file is rather incomplete. You have FAILOVER = ON but which failover mode? How many retries? With what delay?
Consider the TNSNAMES.ORA file in Morgan's Library at www.psoug.org. Click on RAC.
Daniel Morgan
www.psoug.org
Received on Fri May 05 2006 - 16:59:58 CDT
 |
 |