Oracle 10g RAC load-balancing configuration

From: <sudhanshu.goswami_at_gmail.com>
Date: 25 Apr 2006 08:17:35 -0700
Message-ID: <1145978255.505369.80390@i39g2000cwa.googlegroups.com>

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

LSNRCTL for HPUX: Version 10.1.0.2.0 - Production on 25-APR-2006 20:16:12

Starting /home/oracle/app/oracle/OraHome_1/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version 10.1.0.2.0 - Production System parameter file is
/home/oracle/app/oracle/OraHome_1/bench/bench1000/benchrun/network/listener.ora Log messages written to
/home/oracle/app/oracle/OraHome_1/network/log/listener_tpcc1.log Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.9)(PORT=1521))) Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.5)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.9)(PORT=1521))) STATUS of the LISTENER

Alias                     LISTENER_TPCC1
Version                   TNSLSNR for HPUX: Version 10.1.0.2.0 -
Production
Start Date                25-APR-2006 20:16:12
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF

Listener Parameter File
/home/oracle/app/oracle/OraHome_1/bench/bench1000/benchrun/network/listener.ora Listener Log File
/home/oracle/app/oracle/OraHome_1/network/log/listener_tpcc1.log Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.9)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.5)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

The listener supports no services
The command completed successfully

Everytime I try to start the database instances I get the following error:

SQL> startup pfile=init.ora

ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENERS_TPCC'
ORA-01078: failure in processing system parameters

Can somebody please help me out in pointing out what am I doing wrong?

Thanks a lot,
Sudhanshu Received on Tue Apr 25 2006 - 10:17:35 CDT