|
-
TNS.ora file for tgvirtualtwo:
--------------------------------
# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCLRAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tgvirtualtwo-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = tgvirtualone-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclrac.tgvirtual)
)
)
ORCLRAC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tgvirtualone-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclrac.tgvirtual)
(INSTANCE_NAME = orclrac2)
)
)
ORCLRAC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tgvirtualtwo-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclrac.tgvirtual)
(INSTANCE_NAME = orclrac1)
)
)
LISTENERS_ORCLRAC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tgvirtualtwo-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = tgvirtualone-vip)(PORT = 1521))
)
TGVIRTUALONE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tgvirtualtwo-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = tgvirtualone-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tgvirtualone.tgvirtual)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
TNS.ora file for tgvirtualone:
--------------------------------
# tnsnames.ora.tgvirtualone Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora.tgvirtualone
# Generated by Oracle configuration tools.
ORCLRAC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tgvirtualtwo-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = tgvirtualone-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclrac.tgvirtual)
)
)
ORCLRAC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tgvirtualone-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclrac.tgvirtual)
(INSTANCE_NAME = orclrac2)
)
)
ORCLRAC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tgvirtualtwo-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclrac.tgvirtual)
(INSTANCE_NAME = orclrac1)
)
)
LISTENERS_ORCLRAC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tgvirtualtwo-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = tgvirtualone-vip)(PORT = 1521))
)
TGVIRTUALONE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tgvirtualtwo-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = tgvirtualone-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tgvirtualone.tgvirtual)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|