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)(HOS
T=192.168.2.9)(PORT=1521)))
Listening on:
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOS
T=192.168.2.5)(PORT=1521)))
Listening on:  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY
=EXTPROC)))

Connecting to
 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOS
T=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)(HOS
T=192.168.2.9)(PORT=1521)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOS
T=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

[ Post a follow-up to this message ]

sudhanshu.gosw...@gmail.com wrote:

> 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?

Umm well my rac instances all use an spfile not a pfile.

You can certainly start up a "single instance" with a pfile if for that
instance cluster_database is set to false.

But I don't know ( suspect not ) if you can bring up a real rac
instance all the way using a pfile.

>
> Thanks a lot,
> Sudhanshu

[ Post a follow-up to this message ]

On 2006-04-25, hpuxrac <johnbhurley@sbcglobal.net> wrote:
> sudhanshu.gosw...@gmail.com wrote:
> 
>
> Umm well my rac instances all use an spfile not a pfile.
>
> You can certainly start up a "single instance" with a pfile if for that
> instance cluster_database is set to false.
>
> But I don't know ( suspect not ) if you can bring up a real rac
> instance all the way using a pfile.

RAC has no problems using a pfile. You can get yourself into the
position where you can't create an spfile from it, but it works just fine.

--
Linux: because everyone should get to drink the beer of their    |||
choice and not merely be limited to pretensious imports or hard cider.  / | 
\

Posted Via mcse.ms Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.mcse.ms

[ Post a follow-up to this message ]

Actually the clustered database comes up without any problems on both
nodes using a pfile - if I remove the "LOCAL_LISTENER" and
"REMOTE_LISTENER" parameters from the pfile. The problem is
load-balancing is not getting configured without these. Is there
anything else that could be wrong with the configuration?

[ Post a follow-up to this message ]

On 2006-04-26, sudhanshu.goswami@gmail.com <sudhanshu.goswami@gmail.com> wrote:
> Actually the clustered database comes up without any problems on both
> nodes using a pfile - if I remove the "LOCAL_LISTENER" and
> "REMOTE_LISTENER" parameters from the pfile. The problem is
> load-balancing is not getting configured without these. Is there
> anything else that could be wrong with the configuration?

Can you modifiy these online? Perhaps you should just try to
alter these config items once the instance are up and see what works.

--
If you think that an 80G disk can hold HUNDRENDS of           |||
hours of DV video then you obviously haven't used iMovie either.  / | \

Posted Via mcse.ms Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.mcse.ms

[ Post a follow-up to this message ]

Try to remove quotes:

'LISTENERS_TPCC'   => LISTENERS_TPCC'

Jan

[ Post a follow-up to this message ]

Try to remove quotes in the pfile:

'LISTENERS_TPCC'   => LISTENERS_TPCC

Jan

[ Post a follow-up to this message ]

Thanks for your time guys. I tried quite a few things in the pfile -
single quotes, without quotes, double quotes - finally I just took the
entry from the tnsnames.ora and pasted it there in the pfile itself. So
the entries in the new pfile look like this:

tpcc1.local_listener  = '(ADDRESS =
(PROTOCOL=TCP)(HOST=192.168.2.9)(PORT=1521))'
tpcc2.local_listener  = '(ADDRESS =
(PROTOCOL=TCP)(HOST=192.168.2.10)(PORT=1521))'
remote_listener = '(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.2.9) (PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.2.10)(PORT = 1521)))'

After this the database came up without problems. Still connection load
balancing was not working. So I figured it had to do something with
tnsnames.ora. I rewrote the tnsnames.ora file as:

TPCC.WORLD =
(DESCRIPTION =
(load_balance = on)
(failover = on)
(ADDRESS_LIST =
(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 = (PROTOCOL = TCP)(HOST = 192.168.2.9)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = tpcc)
(INSTANCENAME = tpcc1)
(SERVER = DEDICATED)
)
)

TPCC2.WORLD =
(DESCRIPTION =
(load_balance = on)
(failover = on)
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.10)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = tpcc)
(INSTANCENAME = tpcc2)
(SERVER = DEDICATED)
)

---------------------------------------------------------------------------

Restarting the listeners the new status was like this:

--------------------------------------------------------------------------------------------
---------------------------
> lsnrctl services LISTENER_TPCC1

LSNRCTL for HPUX: Version 10.1.0.2.0 - Production on 27-APR-2006
11:54:26

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Connecting to  (DESCRIPTION=(address=(protocol=ipc)(key
=extproc)))
Services Summary...
Service "plsextproc" has 1 instance(s).
Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this
service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "tpcc" has 2 instance(s).
Instance "tpcc1", status READY, has 2 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.9)(PORT=1521))
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Instance "tpcc2", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
REMOTE SERVER
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.10)(PORT=1521))
The command completed successfully

----------------------------------------------------------------------------
----------------
After checking several connections using:
sqlplus "tpcc@tpcc/tpcc"

I could see the connections were being load balanced properly between
the two nodes.
Thanks a lot for your time guys! Seems the problem had to do with
entries in tnsnames.ora and pfile.

- Sudhanshu

[ Post a follow-up to this message ]

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 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/listene
r.ora
> Log messages written to
> /home/oracle/app/oracle/OraHome_1/network/log/listener_tpcc1.log
> Listening on:
>  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOS
T=192.168.2.9)(PORT=1521)))
> Listening on:
>  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOS
T=192.168.2.5)(PORT=1521)))
> Listening on:  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY
=EXTPROC)))
>
> Connecting to
>  (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOS
T=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/listene
r.ora
> Listener Log File
> /home/oracle/app/oracle/OraHome_1/network/log/listener_tpcc1.log
> Listening Endpoints Summary...
>    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOS
T=192.168.2.9)(PORT=1521)))
>    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOS
T=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

[ Post a follow-up to this message ]

DA Morgan wrote:

> 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?
>

Thanks for your reply, Daniel. However, my RAC cluster is up and
running with the pfile I am using. And I currently do not care about
FAILOVER really. My purpose is to determine the max performance I can
eek out of this cluster with load-balancing.

Thanks,
Sudhanshu

[ Post a follow-up to this message ]