Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!elnk-pas-nf1!elnk-nf2-pas!newsfeed.earthlink.net!newshub.sdsu.edu!nx02.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail Date: Fri, 05 May 2006 14:59:58 -0700 From: DA Morgan Organization: Puget Sound Oracle Users Group User-Agent: Thunderbird 1.5.0.2 (Windows/20060308) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Oracle 10g RAC load-balancing configuration References: <1145978255.505369.80390@i39g2000cwa.googlegroups.com> In-Reply-To: <1145978255.505369.80390@i39g2000cwa.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Message-ID: <1146866402.490352@bubbleator.drizzle.com> Cache-Post-Path: bubbleator.drizzle.com!unknown@oracle.advtechserv.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) Lines: 235 X-Complaints-To: abuse@csolutions.net Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:266984 sudhanshu.goswami@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 > > LSNRCTL for HPUX: Version 10.1.0.2.0 - Production on 25-APR-2006 > 20:16:12 > > Copyright (c) 1991, 2004, Oracle. All rights reserved. > > 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 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