Hi There,
We have a set of new users created and these new users are trying to access to DB as a proxy user for other schema. But, we have noticed that upon accessing the DB with these new users, it it giving us an error as ORA-12154. We are getting the same error upon logging in with SQL Plus application.
These newly created users could connect as proxy user from PL/SQL Developer installed on other machine.
Below are the application details-
--- Info ---
PL/SQL Developer
Version 9.0.6.1665
175.78298 - Unlimited user license
Windows 7 6.1 Build 7601 (Service Pack 1)
Physical memory : 2,097,152 kB (869,352 available)
Paging file : 4,194,304 kB (2,963,256 available)
Virtual memory : 2,097,024 kB (1,898,736 available)
Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe
Preferences
Session mode: Multi
OCI Library: C:\Oracle\product\11.2.0\client_1\bin\oci.dll
Use OCI7: True
Allow Multiple Connections: True
Preference Files
C:\Users\REDDYDI1\AppData\Roaming\PLSQL Developer\Preferences\default\Default.ini
C:\Users\REDDYDI1\AppData\Roaming\PLSQL Developer\Preferences\REDDYDI1\default.ini
Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer\PlugIns\plsqldoc.dll)
*Red Gate Deployment Plug-In (C:\Program Files\PLSQL Developer\PlugIns\RedGate.dll)
*Version Control Interface 1.2 (C:\Program Files\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)
Aliases
ACTB.ph.chbs
AD01
AD01.ph.chbs
AD02
AD02.ph.chbs
...
Homes
OraClient10g_home1 (C:\oracle\product\10.2.0\client_1)
OraClient11g_home1 (C:\Oracle\product\11.2.0\client_1)
DLLs
C:\oracle\product\10.2.0\client_1\bin\oci.dll
TNS File
C:\Oracle-TNSnames\tnsnames.ora
Using
Home: OraClient10g_home1
DLL: C:\Oracle\product\11.2.0\client_1\bin\oci.dll
OCI: version 11.1
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
Character Sets
Character size: 4 byte(s)
CharSetID: 0
NCharSetID: 0
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
NLS_CHARACTERSET: AL32UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16
--- Registry ---
SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
SOFTWARE\ORACLE\KEY_OraClient10g_home1
ORACLE_HOME = C:\oracle\product\10.2.0\client_1
ORACLE_HOME_NAME = OraClient10g_home1
ORACLE_GROUP_NAME = Oracle - OraClient10g_home1
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
StatementCacheSize = 0
OLEDB = C:\oracle\product\10.2.0\client_1\oledb\mesg
StmtCacheSize = 0
ORAMTS_CP_TRACE_LEVEL = 0
ORAMTS_CP_TRACE_DIR = C:\oracle\product\10.2.0\client_1\oramts\Trace
ORAMTS_CONN_POOL_TIMEOUT = 120
ORAMTS_SESS_TXNTIMETOLIVE = 120
ORAMTS_NET_CACHE_MAXFREE = 5
ORAMTS_NET_CACHE_TIMEOUT = 120000
ORAMTS_OSCREDS_MATCH_LEVEL = OS_AUTH_LOGIN
SQLPATH = C:\oracle\product\10.2.0\client_1\dbs
OO4O = C:\oracle\product\10.2.0\client_1\oo4o\mesg
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient10g_home1
MSHELP_TOOLS = C:\oracle\product\10.2.0\client_1\MSHELP
SOFTWARE\ORACLE\KEY_OraClient10g_home1\OLEDB
CacheType = Memory
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
StmtCacheSize = 0
SOFTWARE\ORACLE\KEY_OraClient10g_home1\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = C:\oracle\product\10.2.0\client_1\oo4o\doc\oracleo.hlp
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\oracle\product\10.2.0\client_1\oo4o
SOFTWARE\ORACLE\KEY_OraClient11g_home1
ORACLE_HOME = C:\Oracle\product\11.2.0\client_1
ORACLE_HOME_NAME = OraClient11g_home1
ORACLE_GROUP_NAME = Oracle - OraClient11g_home1
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
OLEDB = C:\Oracle\product\11.2.0\client_1\oledb\mesg
ORAMTS_CP_TRACE_LEVEL = 0
ORAMTS_CP_TRACE_DIR = C:\Oracle\product\11.2.0\client_1\oramts\Trace
ORAMTS_CONN_POOL_TIMEOUT = 120
ORAMTS_SESS_TXNTIMETOLIVE = 120
ORAMTS_NET_CACHE_MAXFREE = 5
ORAMTS_NET_CACHE_TIMEOUT = 120000
ORAMTS_OSCREDS_MATCH_LEVEL = OS_AUTH_LOGIN
OO4O = C:\Oracle\product\11.2.0\client_1\oo4o\mesg
MSHELP_TOOLS = C:\Oracle\product\11.2.0\client_1\MSHELP
SQLPATH = C:\Oracle\product\11.2.0\client_1\dbs
SOFTWARE\ORACLE\KEY_OraClient11g_home1\OLEDB
CacheType = Memory
EnableCmdTimeout = 0
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
StmtCacheSize = 0
MetaDataCacheSize = 0
DBNotifications = 0
DeferUpdChk = 0
SOFTWARE\ORACLE\KEY_OraClient11g_home1\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = C:\Oracle\product\11.2.0\client_1\oo4o\doc\oraclec.chm
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\Oracle\product\11.2.0\client_1\oo4o
SOFTWARE\ORACLE\ODP.NET
SOFTWARE\ORACLE\ODP.NET\1.102.3.0
DllPath = C:\oracle\product\10.2.0\client_1\bin
TraceFileName = C:\odp.net1.trc
TraceLevel = 0
TraceOption = 0
StatementCacheSize = 10
SOFTWARE\ORACLE\ODP.NET\1.102.5.0
DllPath = C:\oracle\product\10.2.0\client_1\bin
FetchSize = 65536
TraceFileName = C:\odp.net1.trc
TraceLevel = 0
TraceOption = 0
StatementCacheSize = 10
SOFTWARE\ORACLE\ODP.NET\2.112.1.0
DllPath = C:\Oracle\product\11.2.0\client_1\bin
TraceFileName = C:\odpnet2.trc
TraceLevel = 0
TraceOption = 0
PromotableTransaction = promotable
SelfTuning = 1
StatementCacheWithUdts = 1
UdtCacheSize = 4096
PerformanceCounters = 0
MaxStatementCacheSize = 100
DemandOraclePermission = 0
SOFTWARE\ORACLE\OracleMTSRecoveryService
SOFTWARE\ORACLE\OracleMTSRecoveryService\Protid_0
Name = HTTP
Host = PHINHY-L71228.
Port = 2030
SOFTWARE\ORACLE\OracleMTSRecoveryService\Setup
NumberOfInstalls = 2
--- Path ---
C:\Oracle\product\11.2.0\client_1\bin
C:\Program Files\Intel\iCLS Client\
C:\WINDOWS\system32
C:\WINDOWS
C:\WINDOWS\System32\Wbem
C:\WINDOWS\System32\WindowsPowerShell\v1.0\
C:\WINDOWS\System32\WindowsPowerShell\v1.0\
C:\Program Files\Microsoft Application Virtualization Client
C:\Program Files\Intel\Intel(R) Management Engine Components\DAL
C:\Program Files\Intel\Intel(R) Management Engine Components\IPT
C:\Program Files\Common Files\Entrust\ESP\
C:\Program Files\Intel\WiFi\bin\
C:\Program Files\Common Files\Intel\WirelessCommon\
C:\Oracle\product\10.2.0\client_1\bin
--- TNS names ---
AD01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0097.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD01)
(GLOBAL_NAME = AD01.ph.chbs)
)
)
AD01.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0097.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD01)
(GLOBAL_NAME = AD01.ph.chbs)
)
)
AD02 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD02)
(GLOBAL_NAME = AD02.ph.chbs)
)
)
AD02.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD02)
(GLOBAL_NAME = AD02.ph.chbs)
)
)
AD03 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD03)
(GLOBAL_NAME = AD03.ph.chbs)
)
)
AD03.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD03)
(GLOBAL_NAME = AD03.ph.chbs)
)
)
AD04 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD04)
(GLOBAL_NAME = AD04.ph.chbs)
)
)
AD04.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD04)
(GLOBAL_NAME = AD04.ph.chbs)
)
)
AD05 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD05)
(GLOBAL_NAME = AD05.ph.chbs)
)
)
AD05.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD05)
(GLOBAL_NAME = AD05.ph.chbs)
)
)
AD06 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD06)
(GLOBAL_NAME = AD06.ph.chbs)
)
)
AD06.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD06)
(GLOBAL_NAME = AD06.ph.chbs)
)
)
AD07 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD07)
(GLOBAL_NAME = AD07.ph.chbs)
)
)
AD07.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD07)
(GLOBAL_NAME = AD07.ph.chbs)
)
)
AD08 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD08)
(GLOBAL_NAME = AD08.ph.chbs)
)
)
AD08.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD08)
(GLOBAL_NAME = AD08.ph.chbs)
)
)
AD09 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD09)
(GLOBAL_NAME = AD09.ph.chbs)
)
)
AD09.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD09)
(GLOBAL_NAME = AD09.ph.chbs)
)
)
AD10 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0097.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD10)
(GLOBAL_NAME = AD10.ph.chbs)
)
)
AD10.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0097.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD10)
(GLOBAL_NAME = AD10.ph.chbs)
)
)
AD11 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD11)
(GLOBAL_NAME = AD11.ph.chbs)
)
)
AD11.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD11)
(GLOBAL_NAME = AD11.ph.chbs)
)
)
AD12 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD12)
(GLOBAL_NAME = AD12.ph.chbs)
)
)
AD12.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD12)
(GLOBAL_NAME = AD12.ph.chbs)
)
)
AD13 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD13)
(GLOBAL_NAME = AD13.ph.chbs)
)
)
AD13.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD13)
(GLOBAL_NAME = AD13.ph.chbs)
)
)
AD14 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD14)
(GLOBAL_NAME = AD14.ph.chbs)
)
)
AD14.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD14)
(GLOBAL_NAME = AD14.ph.chbs)
)
)
AD15 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0097.eu.novartis.net)
(Port = 1521))
)
(CONNECT_DATA =
(SID = AD15)
(GLOBAL_NAME = AD15.ph.chbs)
)
)
AD15.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0097.eu.novartis.net)
(Port = 1521))
)
(CONNECT_DATA =
(SID = AD15)
(GLOBAL_NAME = AD15.ph.chbs)
)
)
AD16 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD16)
(GLOBAL_NAME = AD16.ph.chbs)
)
)
AD16.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD16)
(GLOBAL_NAME = AD16.ph.chbs)
)
)
AD17 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD17)
(GLOBAL_NAME = AD17.ph.chbs)
)
)
AD17.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD17)
(GLOBAL_NAME = AD17.ph.chbs)
)
)
AD18 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD18)
(GLOBAL_NAME = AD18.ph.chbs)
)
)
AD18.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD18)
(GLOBAL_NAME = AD18.ph.chbs)
)
)
AD19 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD19)
(GLOBAL_NAME = AD19.ph.chbs)
)
)
AD19.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD19)
(GLOBAL_NAME = AD19.ph.chbs)
)
)
AD20 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD20)
(GLOBAL_NAME = AD20.ph.chbs)
)
)
AD20.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD20)
(GLOBAL_NAME = AD20.ph.chbs)
)
)
AD21 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD21)
(GLOBAL_NAME = AD21.ph.chbs)
)
)
AD21.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD21)
(GLOBAL_NAME = AD21.ph.chbs)
)
)
AD22 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD22)
(GLOBAL_NAME = AD22.ph.chbs)
)
)
AD22.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD22)
(GLOBAL_NAME = AD22.ph.chbs)
)
)
AD23 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD23)
(GLOBAL_NAME = AD23.ph.chbs)
)
)
AD23.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD23)
(GLOBAL_NAME = AD23.ph.chbs)
)
)
AD24 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD24)
(GLOBAL_NAME = AD24.ph.chbs)
)
)
AD24.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD24)
(GLOBAL_NAME = AD24.ph.chbs)
)
)
AD25 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD25)
(GLOBAL_NAME = AD25.ph.chbs)
)
)
AD25.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD25)
(GLOBAL_NAME = AD25.ph.chbs)
)
)
AD26 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD26)
(GLOBAL_NAME = AD26.ph.chbs)
)
)
AD26.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD26)
(GLOBAL_NAME = AD26.ph.chbs)
)
)
AD27 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD27)
(GLOBAL_NAME = AD27.ph.chbs)
)
)
AD27.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD27)
(GLOBAL_NAME = AD27.ph.chbs)
)
)
AD28 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD28)
(GLOBAL_NAME = AD28.ph.chbs)
)
)
AD28.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD28)
(GLOBAL_NAME = AD28.ph.chbs)
)
)
AD29 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD29)
(GLOBAL_NAME = AD29.ph.chbs)
)
)
AD29.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD29)
(GLOBAL_NAME = AD29.ph.chbs)
)
)
AD30 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD30)
(GLOBAL_NAME = AD30.ph.chbs)
)
)
AD30.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD30)
(GLOBAL_NAME = AD30.ph.chbs)
)
)
AD31 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD31)
(GLOBAL_NAME = AD31.ph.chbs)
)
)
AD31.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD31)
(GLOBAL_NAME = AD31.ph.chbs)
)
)
AD32 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD32)
(GLOBAL_NAME = AD32.ph.chbs)
)
)
AD32.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD32)
(GLOBAL_NAME = AD32.ph.chbs)
)
)
AD33 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD33.PH.CHBS)
)
)
COREWARE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = 187.45.247.76)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = COREWARE)
)
)
AD33.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD33.PH.CHBS)
)
)
AD34 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD34.PH.CHBS)
)
)
AD34.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD34.PH.CHBS)
)
)
AD35 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD35.PH.CHBS)
)
)
AD35.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD35.PH.CHBS)
)
)
AD36 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD36.PH.CHBS)
)
)
AD36.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD36.PH.CHBS)
)
)
AD37 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD37.PH.CHBS)
)
)
AD37.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD37.PH.CHBS)
)
)
AD38 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD38.PH.CHBS)
)
)
AD38.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD38.PH.CHBS)
)
)
AD39 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD39.PH.CHBS)
)
)
AD39.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD39.PH.CHBS)
)
)
AD40 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD40.PH.CHBS)
)
)
AD40.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD40.PH.CHBS)
)
)
AD41 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD41.PH.CHBS)
)
)
AD41.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD41.PH.CHBS)
)
)
AD42 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD42.PH.CHBS)
)
)
AD42.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD42.PH.CHBS)
)
)
AD43 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD43.PH.CHBS)
)
)
AD43.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD43.PH.CHBS)
)
)
AD44 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD44.PH.CHBS)
)
)
AD44.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD44.PH.CHBS)
)
)
AD45 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD45.PH.CHBS)
)
)
AD45.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD45.PH.CHBS)
)
)
AD46 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD46.PH.CHBS)
)
)
AD46.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD46.PH.CHBS)
)
)
AD47 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD47.PH.CHBS)
)
)
AD47.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD47.PH.CHBS)
)
)
AD48 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD48.PH.CHBS)
)
)
AD48.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD48.PH.CHBS)
)
)
AD49 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD49.PH.CHBS)
)
)
AD49.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD49.PH.CHBS)
)
)
AD50 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD50.PH.CHBS)
)
)
AD50.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD50.PH.CHBS)
)
)
AD51 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD51.PH.CHBS)
)
)
AD51.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD51.PH.CHBS)
)
)
AD52 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD52.PH.CHBS)
)
)
AD53 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD53)
)
)
AD52.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD52.PH.CHBS)
)
)
ADREP.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = ADREP.PH.CHBS)
)
)
ADPROD.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux135.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = ADPROD))
)
ADTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux134.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = ADTEST))
)
ADTEST.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux134.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = ADTEST))
)
AESP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux67.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AESP))
)
GRDRP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux67.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = GRDRP))
)
AESP.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux67.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AESP))
)
AESP.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux67.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AESP))
)
AEGIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux332.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AEGIST))
)
AF03 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = lhotse.ph.chbs)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AF03)
(GLOBAL_NAME = AF03.ph.chbs)
)
)
AF03.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = lhotse.ph.chbs)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AF03)
(GLOBAL_NAME = AF03.ph.chbs)
)
)
AIDA_DEV.PHARMA.NOVARTIS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = phchbs-sd254)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = aida.pharma.novartis.com)
)
)
AIDA_PROD.PHARMA.NOVARTIS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = phchbs-S3541)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = aida.pharma.novartis.com)
)
)
AIDA_TEST.PHARMA.NOVARTIS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = phchbs-SI210)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = aida.pharma.novartis.com)
)
)
AIDA_TRAIN.PHARMA.NOVARTIS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = phchbs-SD449)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = aida.pharma.novartis.com)
)
)
AISP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = u42aixot.eu.novartis.net)(PORT = 1521))
(CONNECT_DATA = (SID = AISP)))
amosp.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = TCP.pharma.novartis.com)
(PROTOCOL = TCP)
(Host = mykene.ph.chbs)
(Port = 1526)
)
(CONNECT_DATA =
(SID = AMOSP)
(GLOBAL_NAME = amosp.pharma.novartis.com)
)
)
AP21 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0506.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP21)
(GLOBAL_NAME = AP21.ph.chbs)
)
)
AP21.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0506.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP21)
(GLOBAL_NAME = AP21.ph.chbs)
)
)
AP21O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = kaba.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP21)
(GLOBAL_NAME = AP21.ph.chbs)
)
)
AP22 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0506.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP22)
(GLOBAL_NAME = AP22.ph.chbs)
)
)
AP22.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0506.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP22)
(GLOBAL_NAME = AP22.ph.chbs)
)
)
AP22O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = kaba.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP22)
(GLOBAL_NAME = AP22.ph.chbs)
)
)
AP23 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP23)
(GLOBAL_NAME = AP23.ph.chbs)
)
)
AP23T =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux39.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AP23))
)
AP23.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP23)
(GLOBAL_NAME = AP23.ph.chbs)
)
)
AP23O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = kaba.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP23)
(GLOBAL_NAME = AP23.ph.chbs)
)
)
AP24 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP24)
(GLOBAL_NAME = AP24.ph.chbs)
)
)
AP24.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP24)
(GLOBAL_NAME = AP24.ph.chbs)
)
)
AP24O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = kaba.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP24)
(GLOBAL_NAME = AP24.ph.chbs)
)
)
AP26 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP26)
(GLOBAL_NAME = AP26.ph.chbs)
)
)
AP26.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP26)
(GLOBAL_NAME = AP26.ph.chbs)
)
)
AP26O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = kaba.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP26)
(GLOBAL_NAME = AP26.ph.chbs)
)
)
AP33 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = dom.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP33)
(GLOBAL_NAME = AP33.ph.chbs)
)
)
AP33.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = dom.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP33)
(GLOBAL_NAME = AP33.ph.chbs)
)
)
AP33.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = dom.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP33)
(GLOBAL_NAME = AP33.ph.chbs)
)
)
AP66 =
( DESCRIPTION =
( ADDRESS_LIST =
( ADDRESS =
( COMMUNITY = tcp_comm )
( PROTOCOL = TCP )
( Host = ichn52.eu.novartis.net )
( Port = 1521 )
)
)
( CONNECT_DATA =
( SID = AP66 )
( GLOBAL_NAME = AP66.ph.chbs )
)
)
AP66.ph.chbs =
( DESCRIPTION =
( ADDRESS_LIST =
( ADDRESS =
( COMMUNITY = tcp_comm )
( PROTOCOL = TCP )
( Host = ichn52.eu.novartis.net )
( Port = 1521 )
)
)
( CONNECT_DATA =
( SID = AP66 )
( GLOBAL_NAME = AP66.ph.chbs )
)
)
AP67 =
( DESCRIPTION =
( ADDRESS_LIST =
( ADDRESS =
( COMMUNITY = tcp_comm )
( PROTOCOL = TCP )
( Host = ichn52.eu.novartis.net )
( Port = 1521 )
)
)
( CONNECT_DATA =
( SID = AP67 )
( GLOBAL_NAME = AP67.ph.chbs )
)
)
AP67.ph.chbs =
( DESCRIPTION =
( ADDRESS_LIST =
( ADDRESS =
( COMMUNITY = tcp_comm )
( PROTOCOL = TCP )
( Host = ichn52.eu.novartis.net )
( Port = 1521 )
)
)
( CONNECT_DATA =
( SID = AP67 )
( GLOBAL_NAME = AP67.ph.chbs )
)
)
AP71 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = ichn13.is.chbs)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP71)
)
)
AP71.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = ichn13.is.chbs)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP71)
)
)
AP73 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = ichn19.is.chbs)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP73)
)
)
AP73.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = ichn19.is.chbs)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP73)
)
)
ARSDENU =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = u52aixbs.eu.novartis.net)(PORT = 1521))
(CONNECT_DATA = (SID = ARSDENU)))
AS02 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = lhotse.ph.chbs)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AS02)
)
)
AS02.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = lhotse.ph.chbs)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AS02)
)
)
AT44 =
( DESCRIPTION =
( ADDRESS_LIST =
( ADDRESS =
( COMMUNITY = tcp_comm )
( PROTOCOL = TCP )
( Host = ichn51.eu.novartis.net )
( Port = 1524 )
)
)
( CONNECT_DATA =
( SID = AT44 )
( GLOBAL_NAME = AT44.ph.chbs )
)
)
AT44.ph.chbs =
( DESCRIPTION =
( ADDRESS_LIST =
( ADDRESS =
( COMMUNITY = tcp_comm )
( PROTOCOL = TCP )
( Host = ichn51.eu.novartis.net )
( Port = 1524 )
)
)
( CONNECT_DATA =
( SID = AT44 )
( GLOBAL_NAME = AT44.ph.chbs )
)
)
AT71.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = ichn15.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AT71)
)
)
AT71R.ph.chbs =
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = ichn71.eu.novartis.net)
(Port = 1521)
)
(CONNECT_DATA =
(SID = AT71R)
(GLOBAL_NAME = AT71R.ph.chbs)
)
)
AT71R =
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = ichn71.eu.novartis.net)
(Port = 1521)
)
(CONNECT_DATA =
(SID = AT71R)
(GLOBAL_NAME = AT71R.ph.chbs)
)
)
BP29T =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux39.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = BP29))
)
bapp.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.pharma.novartis.com)
(PROTOCOL = TCP)
(Host = USEHUX30.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = bapp)
(GLOBAL_NAME = bapp.pharma.novartis.com)
)
)
bapq =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.pharma.novartis.com)
(PROTOCOL = TCP)
(Host = usehux68.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = bapq)
(GLOBAL_NAME = bapq.pharma.novartis.com)
)
)
BD71_n =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux137.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = BD71))
)
BD72_n =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux137.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = BD71))
)
BD90 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux119.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = BD90))
)
BD91 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux137.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = BD91))
)
BP03.fttm.useh =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.fttm.useh)
(PROTOCOL = TCP)
(Host = usehux54.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP03)
(GLOBAL_NAME = BP03.fttm.useh)
)
)
BP21 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0506.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP21)
(GLOBAL_NAME = BP21.fttm.useh)
)
)
BP21O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux126.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP21)
(GLOBAL_NAME = BP21.fttm.useh)
)
)
BP21.fttm.useh =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0506.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP21)
(GLOBAL_NAME = BP21.fttm.useh)
)
)
BP22 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0506.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP22)
(GLOBAL_NAME = BP22.fttm.useh)
)
)
BP22.fttm.useh =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0506.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP22)
(GLOBAL_NAME = BP22.fttm.useh)
)
)
BP22.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux336.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP22)
(GLOBAL_NAME = BP22.fttm.useh)
)
)
BP22O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux126.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP22)
(GLOBAL_NAME = BP22.fttm.useh)
)
)
BP23 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP23)
(GLOBAL_NAME = BP23.fttm.useh)
)
)
BP23.fttm.useh =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP23)
(GLOBAL_NAME = BP23.fttm.useh)
)
)
BP23.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP23)
(GLOBAL_NAME = BP23.fttm.useh)
)
)
BP23O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux126.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP23)
(GLOBAL_NAME = BP23.fttm.useh)
)
)
BP24 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux67.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP24)
(GLOBAL_NAME = BP24.fttm.useh)
)
)
BP24.fttm.useh =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux67.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP24)
(GLOBAL_NAME = BP24.fttm.useh)
)
)
BP25 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP25)
(GLOBAL_NAME = BP25.fttm.useh)
)
)
BP25.fttm.useh =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP25)
(GLOBAL_NAME = BP25.fttm.useh)
)
)
BP25O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux126.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP25)
(GLOBAL_NAME = BP25.fttm.useh)
)
)
BP26 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP26)
(GLOBAL_NAME = BP26.fttm.useh)
)
)
BP26.fttm.useh =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP26)
(GLOBAL_NAME = BP26.fttm.useh)
)
)
BP26.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP26)
(GLOBAL_NAME = BP26.fttm.useh)
)
)
BP26O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux126.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP26)
(GLOBAL_NAME = BP26.fttm.useh)
)
)
BP27 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux67.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP27)
(GLOBAL_NAME = BP27.fttm.useh)
)
)
BP27.fttm.useh =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux67.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP27)
(GLOBAL_NAME = BP27.fttm.useh)
)
)
BP29 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = chbsux0506.eu.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = BP29))
)
BP29.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = chbsux0506.eu.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = BP29))
)
BP29.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = chbsux0506.eu.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = BP29))
)
BP29O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux126.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = BP29))
)
BP31 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.fttm.useh)
(PROTOCOL = TCP)
(Host = usehux67.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP31)
(GLOBAL_NAME = BP31.fttm.useh)
)
)
BP31.fttm.useh =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.fttm.useh)
(PROTOCOL = TCP)
(Host = usehux67.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP31)
(GLOBAL_NAME = BP31.fttm.useh)
)
)
BP64 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux125.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA =
(SID = BP64)
)
)
BT44 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux124.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA =
(SID = BT44)
)
)
BT71 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = usehux36.na.novartis.net)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = BD71)
)
)
BT72 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = usehux36.na.novartis.net)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = BD72)
)
)
BT81 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = usehux37.na.novartis.net)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = BD81)
)
)
BT82 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = usehux37.na.novartis.net)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = BD82)
)
)
CAWATSD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =(COMMUNITY=tcp_comm)(PROTOCOL=TCP)(Host=usca4d-scan.na.novartis.net)(Port=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=cawatsd.na.novartis.net)
)
)
CHCTDEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0274.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP21)
(GLOBAL_NAME = AP21.ph.chbs)
)
)
CHCTPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0274.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP22)
(GLOBAL_NAME = AP22.ph.chbs)
)
)
CHCTTRN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0274.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP23)
(GLOBAL_NAME = AP23.ph.chbs)
)
)
AFMDEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux60.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AFMDEV))
)
AFMDEV.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux60.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AFMDEV))
)
CAPTSD =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE = ON)
(ADDRESS = (PROTOCOL = TCP)(Host = uscalx4000vip.na.novartis.net)(Port = 1521))
(ADDRESS = (PROTOCOL = TCP)(Host = uscalx4001vip.na.novartis.net)(Port = 1521)))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CAPTSD)))
AFMTST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux69.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AFMTST))
)
AFMPRD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux119.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AFMPRD))
)
AFMPRD.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux119.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AFMPRD))
)
AFMTST.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux69.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AFMTST))
)
CAMDRD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = uscalx4026.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = CAMDRD))
)
CAMDRT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = uscalx7039.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = CAMDRT))
)
CISD_9i =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux69.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = CISD))
)
CISD_9i.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux69.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = CISD))
)
CISD_9i.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux69.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = CISD))
)
CISP_9i =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux67.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = CISP))
)
CISP_9i.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux67.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = CISP))
)
CLARAPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux335.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = CLARAPROD))
)
CM_INT.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = phchbs-s6260)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = chromtrd.r607)
)
)
CM_PROD.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = phchbs-s6259)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = chromtrd.r607)
)
)
CM_TEST.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = phchbs-s6264)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = chromtrd.r607)
)
)
CM_TRAIN.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = phchbs-s6263)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = chromtrd.r607)
)
)
CMTRD_DEV.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = CMTRD-DEVDB.eu.novartis.net)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = CMTRD)
)
)
CMTRD_INT.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = CMTRD-INTDB.eu.novartis.net)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = CMTRD)
)
)
CMTRD_PROD.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = CMTRD-PRODDB.eu.novartis.net)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = CMTRD)
)
)
CMTRD_TRAIN.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = CMTRD-TRAINDB.eu.novartis.net)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = CHROMTRD)
)
)
CP21 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = CP21)
)
)
CP21O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = USEHUX126.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = CP21)
)
)
CT21 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = jpuxrd12.jp.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = CT21)
)
)
CP22 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0506.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_D
We have a set of new users created and these new users are trying to access to DB as a proxy user for other schema. But, we have noticed that upon accessing the DB with these new users, it it giving us an error as ORA-12154. We are getting the same error upon logging in with SQL Plus application.
These newly created users could connect as proxy user from PL/SQL Developer installed on other machine.
Below are the application details-
--- Info ---
PL/SQL Developer
Version 9.0.6.1665
175.78298 - Unlimited user license
Windows 7 6.1 Build 7601 (Service Pack 1)
Physical memory : 2,097,152 kB (869,352 available)
Paging file : 4,194,304 kB (2,963,256 available)
Virtual memory : 2,097,024 kB (1,898,736 available)
Parameters
C:\Program Files\PLSQL Developer\plsqldev.exe
Preferences
Session mode: Multi
OCI Library: C:\Oracle\product\11.2.0\client_1\bin\oci.dll
Use OCI7: True
Allow Multiple Connections: True
Preference Files
C:\Users\REDDYDI1\AppData\Roaming\PLSQL Developer\Preferences\default\Default.ini
C:\Users\REDDYDI1\AppData\Roaming\PLSQL Developer\Preferences\REDDYDI1\default.ini
Plug-Ins
*Active Query Builder (C:\Program Files\PLSQL Developer\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer\PlugIns\plsqldoc.dll)
*Red Gate Deployment Plug-In (C:\Program Files\PLSQL Developer\PlugIns\RedGate.dll)
*Version Control Interface 1.2 (C:\Program Files\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)
Aliases
ACTB.ph.chbs
AD01
AD01.ph.chbs
AD02
AD02.ph.chbs
...
Homes
OraClient10g_home1 (C:\oracle\product\10.2.0\client_1)
OraClient11g_home1 (C:\Oracle\product\11.2.0\client_1)
DLLs
C:\oracle\product\10.2.0\client_1\bin\oci.dll
TNS File
C:\Oracle-TNSnames\tnsnames.ora
Using
Home: OraClient10g_home1
DLL: C:\Oracle\product\11.2.0\client_1\bin\oci.dll
OCI: version 11.1
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
Character Sets
Character size: 4 byte(s)
CharSetID: 0
NCharSetID: 0
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.WE8MSWIN1252
NLS_CHARACTERSET: AL32UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16
--- Registry ---
SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
SOFTWARE\ORACLE\KEY_OraClient10g_home1
ORACLE_HOME = C:\oracle\product\10.2.0\client_1
ORACLE_HOME_NAME = OraClient10g_home1
ORACLE_GROUP_NAME = Oracle - OraClient10g_home1
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
StatementCacheSize = 0
OLEDB = C:\oracle\product\10.2.0\client_1\oledb\mesg
StmtCacheSize = 0
ORAMTS_CP_TRACE_LEVEL = 0
ORAMTS_CP_TRACE_DIR = C:\oracle\product\10.2.0\client_1\oramts\Trace
ORAMTS_CONN_POOL_TIMEOUT = 120
ORAMTS_SESS_TXNTIMETOLIVE = 120
ORAMTS_NET_CACHE_MAXFREE = 5
ORAMTS_NET_CACHE_TIMEOUT = 120000
ORAMTS_OSCREDS_MATCH_LEVEL = OS_AUTH_LOGIN
SQLPATH = C:\oracle\product\10.2.0\client_1\dbs
OO4O = C:\oracle\product\10.2.0\client_1\oo4o\mesg
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient10g_home1
MSHELP_TOOLS = C:\oracle\product\10.2.0\client_1\MSHELP
SOFTWARE\ORACLE\KEY_OraClient10g_home1\OLEDB
CacheType = Memory
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
StmtCacheSize = 0
SOFTWARE\ORACLE\KEY_OraClient10g_home1\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = C:\oracle\product\10.2.0\client_1\oo4o\doc\oracleo.hlp
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\oracle\product\10.2.0\client_1\oo4o
SOFTWARE\ORACLE\KEY_OraClient11g_home1
ORACLE_HOME = C:\Oracle\product\11.2.0\client_1
ORACLE_HOME_NAME = OraClient11g_home1
ORACLE_GROUP_NAME = Oracle - OraClient11g_home1
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
OLEDB = C:\Oracle\product\11.2.0\client_1\oledb\mesg
ORAMTS_CP_TRACE_LEVEL = 0
ORAMTS_CP_TRACE_DIR = C:\Oracle\product\11.2.0\client_1\oramts\Trace
ORAMTS_CONN_POOL_TIMEOUT = 120
ORAMTS_SESS_TXNTIMETOLIVE = 120
ORAMTS_NET_CACHE_MAXFREE = 5
ORAMTS_NET_CACHE_TIMEOUT = 120000
ORAMTS_OSCREDS_MATCH_LEVEL = OS_AUTH_LOGIN
OO4O = C:\Oracle\product\11.2.0\client_1\oo4o\mesg
MSHELP_TOOLS = C:\Oracle\product\11.2.0\client_1\MSHELP
SQLPATH = C:\Oracle\product\11.2.0\client_1\dbs
SOFTWARE\ORACLE\KEY_OraClient11g_home1\OLEDB
CacheType = Memory
EnableCmdTimeout = 0
ChunkSize = 100
DistribTX = 1
FetchSize = 100
OSAuthent = 0
PLSQLRset = 0
PwdChgDlg = 1
SchRstLng = 10000
UserDefFn = 0
DisableRetClause = 1
VCharNull = 1
TraceCategory = 0
TraceFileName = c:\OraOLEDB.trc
TraceLevel = 0
TraceOption = 0
SPPrmDefVal = 0
StmtCacheSize = 0
MetaDataCacheSize = 0
DBNotifications = 0
DeferUpdChk = 0
SOFTWARE\ORACLE\KEY_OraClient11g_home1\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = C:\Oracle\product\11.2.0\client_1\oo4o\doc\oraclec.chm
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\Oracle\product\11.2.0\client_1\oo4o
SOFTWARE\ORACLE\ODP.NET
SOFTWARE\ORACLE\ODP.NET\1.102.3.0
DllPath = C:\oracle\product\10.2.0\client_1\bin
TraceFileName = C:\odp.net1.trc
TraceLevel = 0
TraceOption = 0
StatementCacheSize = 10
SOFTWARE\ORACLE\ODP.NET\1.102.5.0
DllPath = C:\oracle\product\10.2.0\client_1\bin
FetchSize = 65536
TraceFileName = C:\odp.net1.trc
TraceLevel = 0
TraceOption = 0
StatementCacheSize = 10
SOFTWARE\ORACLE\ODP.NET\2.112.1.0
DllPath = C:\Oracle\product\11.2.0\client_1\bin
TraceFileName = C:\odpnet2.trc
TraceLevel = 0
TraceOption = 0
PromotableTransaction = promotable
SelfTuning = 1
StatementCacheWithUdts = 1
UdtCacheSize = 4096
PerformanceCounters = 0
MaxStatementCacheSize = 100
DemandOraclePermission = 0
SOFTWARE\ORACLE\OracleMTSRecoveryService
SOFTWARE\ORACLE\OracleMTSRecoveryService\Protid_0
Name = HTTP
Host = PHINHY-L71228.
Port = 2030
SOFTWARE\ORACLE\OracleMTSRecoveryService\Setup
NumberOfInstalls = 2
--- Path ---
C:\Oracle\product\11.2.0\client_1\bin
C:\Program Files\Intel\iCLS Client\
C:\WINDOWS\system32
C:\WINDOWS
C:\WINDOWS\System32\Wbem
C:\WINDOWS\System32\WindowsPowerShell\v1.0\
C:\WINDOWS\System32\WindowsPowerShell\v1.0\
C:\Program Files\Microsoft Application Virtualization Client
C:\Program Files\Intel\Intel(R) Management Engine Components\DAL
C:\Program Files\Intel\Intel(R) Management Engine Components\IPT
C:\Program Files\Common Files\Entrust\ESP\
C:\Program Files\Intel\WiFi\bin\
C:\Program Files\Common Files\Intel\WirelessCommon\
C:\Oracle\product\10.2.0\client_1\bin
--- TNS names ---
AD01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0097.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD01)
(GLOBAL_NAME = AD01.ph.chbs)
)
)
AD01.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0097.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD01)
(GLOBAL_NAME = AD01.ph.chbs)
)
)
AD02 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD02)
(GLOBAL_NAME = AD02.ph.chbs)
)
)
AD02.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD02)
(GLOBAL_NAME = AD02.ph.chbs)
)
)
AD03 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD03)
(GLOBAL_NAME = AD03.ph.chbs)
)
)
AD03.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD03)
(GLOBAL_NAME = AD03.ph.chbs)
)
)
AD04 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD04)
(GLOBAL_NAME = AD04.ph.chbs)
)
)
AD04.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD04)
(GLOBAL_NAME = AD04.ph.chbs)
)
)
AD05 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD05)
(GLOBAL_NAME = AD05.ph.chbs)
)
)
AD05.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD05)
(GLOBAL_NAME = AD05.ph.chbs)
)
)
AD06 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD06)
(GLOBAL_NAME = AD06.ph.chbs)
)
)
AD06.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD06)
(GLOBAL_NAME = AD06.ph.chbs)
)
)
AD07 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD07)
(GLOBAL_NAME = AD07.ph.chbs)
)
)
AD07.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD07)
(GLOBAL_NAME = AD07.ph.chbs)
)
)
AD08 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD08)
(GLOBAL_NAME = AD08.ph.chbs)
)
)
AD08.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD08)
(GLOBAL_NAME = AD08.ph.chbs)
)
)
AD09 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD09)
(GLOBAL_NAME = AD09.ph.chbs)
)
)
AD09.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD09)
(GLOBAL_NAME = AD09.ph.chbs)
)
)
AD10 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0097.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD10)
(GLOBAL_NAME = AD10.ph.chbs)
)
)
AD10.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0097.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD10)
(GLOBAL_NAME = AD10.ph.chbs)
)
)
AD11 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD11)
(GLOBAL_NAME = AD11.ph.chbs)
)
)
AD11.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD11)
(GLOBAL_NAME = AD11.ph.chbs)
)
)
AD12 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD12)
(GLOBAL_NAME = AD12.ph.chbs)
)
)
AD12.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD12)
(GLOBAL_NAME = AD12.ph.chbs)
)
)
AD13 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD13)
(GLOBAL_NAME = AD13.ph.chbs)
)
)
AD13.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD13)
(GLOBAL_NAME = AD13.ph.chbs)
)
)
AD14 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD14)
(GLOBAL_NAME = AD14.ph.chbs)
)
)
AD14.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD14)
(GLOBAL_NAME = AD14.ph.chbs)
)
)
AD15 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0097.eu.novartis.net)
(Port = 1521))
)
(CONNECT_DATA =
(SID = AD15)
(GLOBAL_NAME = AD15.ph.chbs)
)
)
AD15.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0097.eu.novartis.net)
(Port = 1521))
)
(CONNECT_DATA =
(SID = AD15)
(GLOBAL_NAME = AD15.ph.chbs)
)
)
AD16 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD16)
(GLOBAL_NAME = AD16.ph.chbs)
)
)
AD16.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD16)
(GLOBAL_NAME = AD16.ph.chbs)
)
)
AD17 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD17)
(GLOBAL_NAME = AD17.ph.chbs)
)
)
AD17.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD17)
(GLOBAL_NAME = AD17.ph.chbs)
)
)
AD18 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD18)
(GLOBAL_NAME = AD18.ph.chbs)
)
)
AD18.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD18)
(GLOBAL_NAME = AD18.ph.chbs)
)
)
AD19 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD19)
(GLOBAL_NAME = AD19.ph.chbs)
)
)
AD19.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD19)
(GLOBAL_NAME = AD19.ph.chbs)
)
)
AD20 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD20)
(GLOBAL_NAME = AD20.ph.chbs)
)
)
AD20.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD20)
(GLOBAL_NAME = AD20.ph.chbs)
)
)
AD21 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD21)
(GLOBAL_NAME = AD21.ph.chbs)
)
)
AD21.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD21)
(GLOBAL_NAME = AD21.ph.chbs)
)
)
AD22 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD22)
(GLOBAL_NAME = AD22.ph.chbs)
)
)
AD22.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD22)
(GLOBAL_NAME = AD22.ph.chbs)
)
)
AD23 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD23)
(GLOBAL_NAME = AD23.ph.chbs)
)
)
AD23.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD23)
(GLOBAL_NAME = AD23.ph.chbs)
)
)
AD24 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD24)
(GLOBAL_NAME = AD24.ph.chbs)
)
)
AD24.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD24)
(GLOBAL_NAME = AD24.ph.chbs)
)
)
AD25 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD25)
(GLOBAL_NAME = AD25.ph.chbs)
)
)
AD25.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD25)
(GLOBAL_NAME = AD25.ph.chbs)
)
)
AD26 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD26)
(GLOBAL_NAME = AD26.ph.chbs)
)
)
AD26.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD26)
(GLOBAL_NAME = AD26.ph.chbs)
)
)
AD27 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD27)
(GLOBAL_NAME = AD27.ph.chbs)
)
)
AD27.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD27)
(GLOBAL_NAME = AD27.ph.chbs)
)
)
AD28 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD28)
(GLOBAL_NAME = AD28.ph.chbs)
)
)
AD28.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521))
)
(CONNECT_DATA =
(SID = AD28)
(GLOBAL_NAME = AD28.ph.chbs)
)
)
AD29 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD29)
(GLOBAL_NAME = AD29.ph.chbs)
)
)
AD29.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD29)
(GLOBAL_NAME = AD29.ph.chbs)
)
)
AD30 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD30)
(GLOBAL_NAME = AD30.ph.chbs)
)
)
AD30.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD30)
(GLOBAL_NAME = AD30.ph.chbs)
)
)
AD31 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD31)
(GLOBAL_NAME = AD31.ph.chbs)
)
)
AD31.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD31)
(GLOBAL_NAME = AD31.ph.chbs)
)
)
AD32 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD32)
(GLOBAL_NAME = AD32.ph.chbs)
)
)
AD32.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD32)
(GLOBAL_NAME = AD32.ph.chbs)
)
)
AD33 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD33.PH.CHBS)
)
)
COREWARE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = 187.45.247.76)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = COREWARE)
)
)
AD33.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD33.PH.CHBS)
)
)
AD34 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD34.PH.CHBS)
)
)
AD34.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD34.PH.CHBS)
)
)
AD35 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD35.PH.CHBS)
)
)
AD35.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD35.PH.CHBS)
)
)
AD36 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD36.PH.CHBS)
)
)
AD36.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD36.PH.CHBS)
)
)
AD37 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD37.PH.CHBS)
)
)
AD37.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD37.PH.CHBS)
)
)
AD38 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD38.PH.CHBS)
)
)
AD38.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD38.PH.CHBS)
)
)
AD39 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD39.PH.CHBS)
)
)
AD39.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD39.PH.CHBS)
)
)
AD40 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD40.PH.CHBS)
)
)
AD40.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD40.PH.CHBS)
)
)
AD41 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD41.PH.CHBS)
)
)
AD41.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD41.PH.CHBS)
)
)
AD42 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD42.PH.CHBS)
)
)
AD42.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD42.PH.CHBS)
)
)
AD43 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD43.PH.CHBS)
)
)
AD43.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD43.PH.CHBS)
)
)
AD44 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD44.PH.CHBS)
)
)
AD44.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD44.PH.CHBS)
)
)
AD45 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD45.PH.CHBS)
)
)
AD45.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD45.PH.CHBS)
)
)
AD46 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD46.PH.CHBS)
)
)
AD46.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD46.PH.CHBS)
)
)
AD47 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD47.PH.CHBS)
)
)
AD47.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD47.PH.CHBS)
)
)
AD48 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD48.PH.CHBS)
)
)
AD48.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD48.PH.CHBS)
)
)
AD49 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD49.PH.CHBS)
)
)
AD49.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD49.PH.CHBS)
)
)
AD50 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD50.PH.CHBS)
)
)
AD50.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD50.PH.CHBS)
)
)
AD51 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD51.PH.CHBS)
)
)
AD51.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD51.PH.CHBS)
)
)
AD52 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD52.PH.CHBS)
)
)
AD53 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AD53)
)
)
AD52.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = AD52.PH.CHBS)
)
)
ADREP.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = chbsux0097.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = ADREP.PH.CHBS)
)
)
ADPROD.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux135.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = ADPROD))
)
ADTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux134.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = ADTEST))
)
ADTEST.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux134.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = ADTEST))
)
AESP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux67.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AESP))
)
GRDRP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux67.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = GRDRP))
)
AESP.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux67.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AESP))
)
AESP.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux67.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AESP))
)
AEGIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux332.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AEGIST))
)
AF03 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = lhotse.ph.chbs)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AF03)
(GLOBAL_NAME = AF03.ph.chbs)
)
)
AF03.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = lhotse.ph.chbs)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AF03)
(GLOBAL_NAME = AF03.ph.chbs)
)
)
AIDA_DEV.PHARMA.NOVARTIS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = phchbs-sd254)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = aida.pharma.novartis.com)
)
)
AIDA_PROD.PHARMA.NOVARTIS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = phchbs-S3541)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = aida.pharma.novartis.com)
)
)
AIDA_TEST.PHARMA.NOVARTIS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = phchbs-SI210)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = aida.pharma.novartis.com)
)
)
AIDA_TRAIN.PHARMA.NOVARTIS.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = phchbs-SD449)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = aida.pharma.novartis.com)
)
)
AISP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = u42aixot.eu.novartis.net)(PORT = 1521))
(CONNECT_DATA = (SID = AISP)))
amosp.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = TCP.pharma.novartis.com)
(PROTOCOL = TCP)
(Host = mykene.ph.chbs)
(Port = 1526)
)
(CONNECT_DATA =
(SID = AMOSP)
(GLOBAL_NAME = amosp.pharma.novartis.com)
)
)
AP21 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0506.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP21)
(GLOBAL_NAME = AP21.ph.chbs)
)
)
AP21.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0506.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP21)
(GLOBAL_NAME = AP21.ph.chbs)
)
)
AP21O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = kaba.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP21)
(GLOBAL_NAME = AP21.ph.chbs)
)
)
AP22 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0506.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP22)
(GLOBAL_NAME = AP22.ph.chbs)
)
)
AP22.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0506.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP22)
(GLOBAL_NAME = AP22.ph.chbs)
)
)
AP22O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = kaba.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP22)
(GLOBAL_NAME = AP22.ph.chbs)
)
)
AP23 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP23)
(GLOBAL_NAME = AP23.ph.chbs)
)
)
AP23T =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux39.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AP23))
)
AP23.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP23)
(GLOBAL_NAME = AP23.ph.chbs)
)
)
AP23O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = kaba.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP23)
(GLOBAL_NAME = AP23.ph.chbs)
)
)
AP24 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP24)
(GLOBAL_NAME = AP24.ph.chbs)
)
)
AP24.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP24)
(GLOBAL_NAME = AP24.ph.chbs)
)
)
AP24O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = kaba.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP24)
(GLOBAL_NAME = AP24.ph.chbs)
)
)
AP26 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP26)
(GLOBAL_NAME = AP26.ph.chbs)
)
)
AP26.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP26)
(GLOBAL_NAME = AP26.ph.chbs)
)
)
AP26O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = kaba.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP26)
(GLOBAL_NAME = AP26.ph.chbs)
)
)
AP33 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = dom.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP33)
(GLOBAL_NAME = AP33.ph.chbs)
)
)
AP33.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = dom.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP33)
(GLOBAL_NAME = AP33.ph.chbs)
)
)
AP33.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = dom.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP33)
(GLOBAL_NAME = AP33.ph.chbs)
)
)
AP66 =
( DESCRIPTION =
( ADDRESS_LIST =
( ADDRESS =
( COMMUNITY = tcp_comm )
( PROTOCOL = TCP )
( Host = ichn52.eu.novartis.net )
( Port = 1521 )
)
)
( CONNECT_DATA =
( SID = AP66 )
( GLOBAL_NAME = AP66.ph.chbs )
)
)
AP66.ph.chbs =
( DESCRIPTION =
( ADDRESS_LIST =
( ADDRESS =
( COMMUNITY = tcp_comm )
( PROTOCOL = TCP )
( Host = ichn52.eu.novartis.net )
( Port = 1521 )
)
)
( CONNECT_DATA =
( SID = AP66 )
( GLOBAL_NAME = AP66.ph.chbs )
)
)
AP67 =
( DESCRIPTION =
( ADDRESS_LIST =
( ADDRESS =
( COMMUNITY = tcp_comm )
( PROTOCOL = TCP )
( Host = ichn52.eu.novartis.net )
( Port = 1521 )
)
)
( CONNECT_DATA =
( SID = AP67 )
( GLOBAL_NAME = AP67.ph.chbs )
)
)
AP67.ph.chbs =
( DESCRIPTION =
( ADDRESS_LIST =
( ADDRESS =
( COMMUNITY = tcp_comm )
( PROTOCOL = TCP )
( Host = ichn52.eu.novartis.net )
( Port = 1521 )
)
)
( CONNECT_DATA =
( SID = AP67 )
( GLOBAL_NAME = AP67.ph.chbs )
)
)
AP71 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = ichn13.is.chbs)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP71)
)
)
AP71.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = ichn13.is.chbs)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP71)
)
)
AP73 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = ichn19.is.chbs)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP73)
)
)
AP73.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = ichn19.is.chbs)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP73)
)
)
ARSDENU =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = u52aixbs.eu.novartis.net)(PORT = 1521))
(CONNECT_DATA = (SID = ARSDENU)))
AS02 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = lhotse.ph.chbs)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AS02)
)
)
AS02.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = lhotse.ph.chbs)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AS02)
)
)
AT44 =
( DESCRIPTION =
( ADDRESS_LIST =
( ADDRESS =
( COMMUNITY = tcp_comm )
( PROTOCOL = TCP )
( Host = ichn51.eu.novartis.net )
( Port = 1524 )
)
)
( CONNECT_DATA =
( SID = AT44 )
( GLOBAL_NAME = AT44.ph.chbs )
)
)
AT44.ph.chbs =
( DESCRIPTION =
( ADDRESS_LIST =
( ADDRESS =
( COMMUNITY = tcp_comm )
( PROTOCOL = TCP )
( Host = ichn51.eu.novartis.net )
( Port = 1524 )
)
)
( CONNECT_DATA =
( SID = AT44 )
( GLOBAL_NAME = AT44.ph.chbs )
)
)
AT71.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = ichn15.eu.novartis.net)(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AT71)
)
)
AT71R.ph.chbs =
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = ichn71.eu.novartis.net)
(Port = 1521)
)
(CONNECT_DATA =
(SID = AT71R)
(GLOBAL_NAME = AT71R.ph.chbs)
)
)
AT71R =
(DESCRIPTION =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = ichn71.eu.novartis.net)
(Port = 1521)
)
(CONNECT_DATA =
(SID = AT71R)
(GLOBAL_NAME = AT71R.ph.chbs)
)
)
BP29T =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux39.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = BP29))
)
bapp.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.pharma.novartis.com)
(PROTOCOL = TCP)
(Host = USEHUX30.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = bapp)
(GLOBAL_NAME = bapp.pharma.novartis.com)
)
)
bapq =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.pharma.novartis.com)
(PROTOCOL = TCP)
(Host = usehux68.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = bapq)
(GLOBAL_NAME = bapq.pharma.novartis.com)
)
)
BD71_n =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux137.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = BD71))
)
BD72_n =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux137.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = BD71))
)
BD90 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux119.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = BD90))
)
BD91 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux137.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = BD91))
)
BP03.fttm.useh =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.fttm.useh)
(PROTOCOL = TCP)
(Host = usehux54.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP03)
(GLOBAL_NAME = BP03.fttm.useh)
)
)
BP21 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0506.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP21)
(GLOBAL_NAME = BP21.fttm.useh)
)
)
BP21O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux126.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP21)
(GLOBAL_NAME = BP21.fttm.useh)
)
)
BP21.fttm.useh =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0506.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP21)
(GLOBAL_NAME = BP21.fttm.useh)
)
)
BP22 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0506.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP22)
(GLOBAL_NAME = BP22.fttm.useh)
)
)
BP22.fttm.useh =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0506.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP22)
(GLOBAL_NAME = BP22.fttm.useh)
)
)
BP22.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux336.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP22)
(GLOBAL_NAME = BP22.fttm.useh)
)
)
BP22O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux126.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP22)
(GLOBAL_NAME = BP22.fttm.useh)
)
)
BP23 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP23)
(GLOBAL_NAME = BP23.fttm.useh)
)
)
BP23.fttm.useh =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP23)
(GLOBAL_NAME = BP23.fttm.useh)
)
)
BP23.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP23)
(GLOBAL_NAME = BP23.fttm.useh)
)
)
BP23O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux126.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP23)
(GLOBAL_NAME = BP23.fttm.useh)
)
)
BP24 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux67.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP24)
(GLOBAL_NAME = BP24.fttm.useh)
)
)
BP24.fttm.useh =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux67.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP24)
(GLOBAL_NAME = BP24.fttm.useh)
)
)
BP25 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP25)
(GLOBAL_NAME = BP25.fttm.useh)
)
)
BP25.fttm.useh =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP25)
(GLOBAL_NAME = BP25.fttm.useh)
)
)
BP25O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux126.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP25)
(GLOBAL_NAME = BP25.fttm.useh)
)
)
BP26 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP26)
(GLOBAL_NAME = BP26.fttm.useh)
)
)
BP26.fttm.useh =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP26)
(GLOBAL_NAME = BP26.fttm.useh)
)
)
BP26.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP26)
(GLOBAL_NAME = BP26.fttm.useh)
)
)
BP26O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux126.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP26)
(GLOBAL_NAME = BP26.fttm.useh)
)
)
BP27 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux67.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP27)
(GLOBAL_NAME = BP27.fttm.useh)
)
)
BP27.fttm.useh =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = usehux67.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP27)
(GLOBAL_NAME = BP27.fttm.useh)
)
)
BP29 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = chbsux0506.eu.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = BP29))
)
BP29.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = chbsux0506.eu.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = BP29))
)
BP29.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = chbsux0506.eu.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = BP29))
)
BP29O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux126.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = BP29))
)
BP31 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.fttm.useh)
(PROTOCOL = TCP)
(Host = usehux67.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP31)
(GLOBAL_NAME = BP31.fttm.useh)
)
)
BP31.fttm.useh =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.fttm.useh)
(PROTOCOL = TCP)
(Host = usehux67.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = BP31)
(GLOBAL_NAME = BP31.fttm.useh)
)
)
BP64 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux125.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA =
(SID = BP64)
)
)
BT44 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux124.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA =
(SID = BT44)
)
)
BT71 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = usehux36.na.novartis.net)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = BD71)
)
)
BT72 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = usehux36.na.novartis.net)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = BD72)
)
)
BT81 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = usehux37.na.novartis.net)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = BD81)
)
)
BT82 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = usehux37.na.novartis.net)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = BD82)
)
)
CAWATSD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =(COMMUNITY=tcp_comm)(PROTOCOL=TCP)(Host=usca4d-scan.na.novartis.net)(Port=1521))
)
(CONNECT_DATA=
(SERVICE_NAME=cawatsd.na.novartis.net)
)
)
CHCTDEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0274.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP21)
(GLOBAL_NAME = AP21.ph.chbs)
)
)
CHCTPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0274.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP22)
(GLOBAL_NAME = AP22.ph.chbs)
)
)
CHCTTRN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0274.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = AP23)
(GLOBAL_NAME = AP23.ph.chbs)
)
)
AFMDEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux60.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AFMDEV))
)
AFMDEV.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux60.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AFMDEV))
)
CAPTSD =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCE = ON)
(ADDRESS = (PROTOCOL = TCP)(Host = uscalx4000vip.na.novartis.net)(Port = 1521))
(ADDRESS = (PROTOCOL = TCP)(Host = uscalx4001vip.na.novartis.net)(Port = 1521)))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CAPTSD)))
AFMTST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux69.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AFMTST))
)
AFMPRD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux119.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AFMPRD))
)
AFMPRD.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux119.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AFMPRD))
)
AFMTST.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux69.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = AFMTST))
)
CAMDRD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = uscalx4026.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = CAMDRD))
)
CAMDRT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = uscalx7039.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = CAMDRT))
)
CISD_9i =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux69.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = CISD))
)
CISD_9i.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux69.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = CISD))
)
CISD_9i.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux69.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = CISD))
)
CISP_9i =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux67.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = CISP))
)
CISP_9i.ph.chbs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux67.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = CISP))
)
CLARAPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = usehux335.na.novartis.net)(PORT = 1521))
)
(CONNECT_DATA = (SID = CLARAPROD))
)
CM_INT.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = phchbs-s6260)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = chromtrd.r607)
)
)
CM_PROD.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = phchbs-s6259)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = chromtrd.r607)
)
)
CM_TEST.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = phchbs-s6264)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = chromtrd.r607)
)
)
CM_TRAIN.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = phchbs-s6263)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = chromtrd.r607)
)
)
CMTRD_DEV.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = CMTRD-DEVDB.eu.novartis.net)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = CMTRD)
)
)
CMTRD_INT.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = CMTRD-INTDB.eu.novartis.net)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = CMTRD)
)
)
CMTRD_PROD.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = CMTRD-PRODDB.eu.novartis.net)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = CMTRD)
)
)
CMTRD_TRAIN.pharma.novartis.com =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = CMTRD-TRAINDB.eu.novartis.net)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = CHROMTRD)
)
)
CP21 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0505.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = CP21)
)
)
CP21O =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = USEHUX126.na.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = CP21)
)
)
CT21 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = jpuxrd12.jp.novartis.net)
(Port = 1521)
)
)
(CONNECT_DATA =
(SID = CT21)
)
)
CP22 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp_comm)
(PROTOCOL = TCP)
(Host = chbsux0506.eu.novartis.net)
(Port = 1521)
)
)
(CONNECT_D
