Cluster split - 2 nodes for DSS and 1 Node for OLTP The requirement is to allocate 1 node exclusively to OLTP enviroment out of 3 node cluster. The logic is based on the setting up the service_name SQL> show parameter service_name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ service_names string orclexperts.info SQL> SQL> alter system set service_names='OLTP_experts' sid='ORCLEXPERTS3'; System altered. SQL> [oracle@s262381ch3el101 ~]$ lsnrctl services | grep -i orclexperts Service "ORCLEXPERTS.info" has 3 instance(s). Instance "ORCLEXPERTS1", status READY, has 2 handler(s) for this service... Instance "ORCLEXPERTS2", status READY, has 1 handler(s) for this service... Instance "ORCLEXPERTS3", status READY, has 1 handler(s) for this service... Service "ORCLEXPERTSXDB.info" has 3 instance(s). Instance "ORCLEXPERTS1", status READY, has 1 handler(s) for this service... Instance "ORCLEXPERTS2", status READY, has 1 handler(s) for this service... Instance "ORCLEXPERTS3", status READY, has 1 handler(s) for this service... Service "ORCLEXPERTS_XPT.info" has 3 instance(s). Instance "ORCLEXPERTS1", status READY, has 2 handler(s) for this service... Instance "ORCLEXPERTS2", status READY, has 1 handler(s) for this service... Instance "ORCLEXPERTS3", status READY, has 1 handler(s) for this service... Service "OLTP_ORCLEXPERTS.info" has 1 instance(s). Instance "ORCLEXPERTS3", status READY, has 1 handler(s) for this service... [oracle@experts1 admin]$ sqlplus system/xxxx@OLTP_ORCLEXPERTS SQL*Plus: Release 10.2.0.2.0 - Production on Wed Feb 6 22:35:44 2008 Copyright (c) 1982, 2005, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Data Mining options SQL> SQL> show parameter service_name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ service_names string OLTP_ORCLEXPERTS, ORCLEXPERTS.info TNS: OLTP_ORCLEXPERTS = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orclexperts3-vip)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = OLTP_ORCLEXPERTS.info) (INSTANCE_NAME = ORCLEXPERTS3) ) ) All OLTP connection strings changed to use the above string value. |