We are experiencing a problem where PL/SQL Dev crashes sometimes with Access Violation at 00000000..., hangs after that then sometimes just disappears when access a 10g database on an AIX box. I've tried to launch with the debugsql so I can send you a file, but the debug.txt doesn't get produced. I've included the info pages, but I'm not sure why the debug.txt file doesn't get created. Thanx in advance. Dan
--- Info ---
PL/SQL Developer
Version 6.0.4.906 (MBCS)
02.24835 - Unlimited user license
Windows XP version 6.0 (build 2600) Service Pack 2
Physical memory : 2,088,428 kB (1,352,980 available)
Paging file : 4,030,588 kB (2,921,116 available)
Virtual memory : 2,097,024 kB (2,029,656 available)
Parameters
C:\Program Files\PLSQL Developer\PLSQLDev.exe
Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Plug-Ins
*FTP File Interface 1.0 (C:\Program Files\PLSQL Developer\PlugIns\ftp.dll)
(* is Active)
Aliases
acct4d
acct4d.world
acct4p
acct4p.world
acct4q
...
Homes
ora9i (c:\ora9i)
DLLs
c:\ora9i\bin\oci.dll
TNS File
c:\ora9i\Network\Admin\tnsnames.ora
Using
Home: ora9i
DLL: c:\ora9i\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0
Character size: 1 byte(s)
--- Registry ---
SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
ORACLE_HOME = c:\ora9i
ORACLE_HOME_NAME = ora9i
API = c:\ora9i\dbs
ORACLE_GROUP_NAME = Oracle - ora9i
NLS_LANG = NA
OO4O = c:\ora9i\oo4o\mesg
OLEDB = c:\ora9i\oledb\mesg
SOFTWARE\ORACLE\ALL_HOMES
HOME_COUNTER = 1
DEFAULT_HOME = ora9i
LAST_HOME = 0
SOFTWARE\ORACLE\ALL_HOMES\ID0
NAME = ora9i
PATH = c:\ora9i
NLS_LANG = NA
SOFTWARE\ORACLE\HOME0
ID = 0
ORACLE_GROUP_NAME = Oracle - ora9i
ORACLE_HOME_NAME = ora9i
ORACLE_HOME = c:\ora9i
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
ORACLE_BUNDLE_NAME = Enterprise
SQLPATH = c:\ora9i\dbs
ORACLE_HOME_KEY = Software\ORACLE\HOME0
ORAMTS_CP_TRACE_LEVEL = 0
ORAMTS_CP_TRACE_DIR = c:\ora9i\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
SOFTWARE\ORACLE\JInitiator
SOFTWARE\ORACLE\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
SOFTWARE\ORACLE\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = c:\ora9i\MSHELP\oracleo.hlp
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = c:\ora9i\oo4o
SOFTWARE\ORACLE\OracleMTSRecoveryService
SOFTWARE\ORACLE\OracleMTSRecoveryService\Protid_0
Name = HTTP
Host = ncci-p6ossgzopn
Port = 2030
SOFTWARE\ORACLE\OracleMTSRecoveryService\Setup
NumberOfInstalls =
--- Path ---
c:\ora9i\bin
C:\Program Files\Oracle\jre\1.3.1\bin
C:\Program Files\Oracle\jre\1.1.8\bin
C:\WINDOWS\system32
C:\WINDOWS
C:\WINDOWS\System32\Wbem
C:\Program Files\Common Files\Roxio Shared\DLLShared
C:\Program Files\IBM\Trace Facility\
C:\Program Files\IBM\Personal Communications\
C:\PROGRA~1\IBM\SQLLIB\BIN
C:\PROGRA~1\IBM\SQLLIB\FUNCTION
C:\PROGRA~1\IBM\SQLLIB\SAMPLES\REPL
C:\PROGRA~1\NETMAN~1\System
C:\Program Files\SSH Communications Security\SSH Tectia\SSH Tectia AUX
C:\Program Files\SSH Communications Security\SSH Tectia\SSH Tectia Broker
C:\Program Files\SSH Communications Security\SSH Tectia\SSH Tectia Client
C:\PROGRA~1\NETMAN~1\COMMON
C:\PROGRA~1\NETMAN~1\APPS\EMULAT~1
C:\PROGRA~1\NETMAN~1\APPS\X
--- TNS names ---
##############################################################################
#
# Filename......: tnsnames.ora 06092006 for ntdesktop
#
##############################################################################
# Entry for acct4
#
acct4d,acct4d.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = acct4d))
)
acct4q,acct4q.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = acct4q))
)
acct4p,acct4p.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nccisp33.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = acct4p))
)
#
# Entry for aro
#
arod,arod.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr06.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = arod))
)
aroq,aroq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr05.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = aroq))
)
arop,arop.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr04.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = arop))
)
#
# Entry for art
#
artd,artd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr06.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = artd))
)
artq,artq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr05.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = artq))
)
artp,artp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr04.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = artp))
)
#
# Entry for crm
#
crmd,crmd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = crmd))
)
crmq,crmq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = crmq))
)
crmt,crmt.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = crmt))
)
crmp,crmp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr01.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = crmp))
)
bcrmp,bcrmp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr07.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = bcrmp))
)
#
# Entry for ctd
#
ctdd =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =aixr06.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ctdd))
)
ctdq =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =aixr05.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ctdq))
)
ctdp =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =aix6.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ctdp))
)
#
# Entry for ctsa
#
ctsad =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =devo.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ctsad))
)
ctsaq =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =nurse.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ctsaq))
)
ctsap =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =reef.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ctsap))
)
#
# Entry for data
#
datad,datad.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = datad))
)
dataq,dataq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nurse)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dataq))
)
datap,datap.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sand)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = datap))
)
#
# Entry for dba
#
dba,dba.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dba))
)
#
# Entry for dci
#
dcid,dcid.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr06.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dcid))
)
dcip,dcip.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nccisp23.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dcip))
)
dciq,dciq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr05.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dciq))
)
#
# Entry for dssh
#
dssh,dssh.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aix1.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dssh))
)
dsshd,dsshd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr09.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dsshd))
)
dsshq,dsshq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr08.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dsshq))
)
#
# Entry for ecm
#
ecmd=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr06.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ecmd))
)
ecmd2=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ecmd2))
)
ecmq=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ecmq))
)
ecmp=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr07.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ecmp))
)
#
# Entry for eprise
#
eprised,eprised.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = eprised))
)
epriseq,epriseq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = epriseq))
)
epriseqa,epriseqa.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = epriseqa))
)
eprisep,eprisep.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr07.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = eprisep))
)
#
# Entry for epsource
#
epsourced,epsourced.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = epsourced))
)
epsourceq,epsourceq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = epsourceq))
)
epsourcep,epsourcep.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr01.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = epsourcep))
)
#
# Entry for extproc
#
extproc_connection_data.world=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = extproc_key))
(CONNECT_DATA = (SID = extproc_agent))
)
#
#
# Entry for idb
#
qidb,qidb.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nurse)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = qidb))
)
idb,idb.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = idb))
)
pidb,pidb.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sand)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = pidb))
)
#
#
# Entry for lms
#
lmsd,lmsd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = lmsd))
)
lmsq,lmsq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = lmsq))
)
lmsp,lmsp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aix1.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = lmsp)))
#
# Entry for met
#
pmet,pmet.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sand)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = pmet))
)
qmet,qmet.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nurse)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = qmet))
)
dmet,dmet.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dmet))
)
#
# Entry for oap
#
OAPD,OAPD.world,OAPD.ncci.com=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr09.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = OAPD))
)
OAPQ,OAPQ.world,OAPQ.ncci.com=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr08.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = OAPQ))
)
OAPP,OAPP.world,OAPP.ncci.com=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aix1.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = OAPP))
)
OAPT,OAPT.world,OAPT.ncci.com=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = OAPT))
)
#
#
#
#
#
# Entry for oem
#
oemq=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = nurse.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = oemq))
)
oemp=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = sunpvol.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = oemp))
)
#
# Entry for ois
#
oisd,oisd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr09.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = oisd))
)
oisq,oisq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr08.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = oisq))
)
oisp,oisp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aix1.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = oisp))
)
#
# Entry for pcs
#
PCSQA,PCSQA.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aix6.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = PCSQA))
)
#
# Entry for point
#
pointd,pointd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = pointd))
)
pointq,pointq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = pointq))
)
pointp,pointp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr01.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = pointp))
)
#
# Entry for prs
#
prsz,prsz.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = lnoaesd.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = prsz))
)
#
# Entry for prs
#
prsd,prsd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr06.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = prsd))
)
prsq,prsq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr05.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = prsq))
)
prsp,prsp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr04.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = prsp))
)
prst,prst.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr06.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = prst))
)
#
# Entry for rmap
#
drmap,drmap.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr06)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = drmap))
)
drmap2,drmap2.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr06)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = drmap2))
)
qrmap,qrmap.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr05)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = qrmap))
)
PRMAP,PRMAP.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aix6.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = PRMAP))
)
#
#
# Entry for scb
#
scbd =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = scbd))
)
scbq =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = scbq))
)
scbp =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =aixr07.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = scbp))
)
#
# Entry for scbd2
#
scbd2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = scbd2))
)
#
# Entry for statdb
#
statdb,statdb.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =nurse)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = statdb))
)
#
# Entry for sysman
#
sysman,sysman.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = hammer.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = sysman))
)
#
#
# Entry for toc
#
dtoc,dtoc.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dtoc))
)
qtoc,qtoc.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nurse)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = qtoc))
)
ptoc,ptoc.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sand)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ptoc))
)
#
# Entry for trman
#
trman,trman.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sand)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = trman))
)
#
# Entry for trman3
#
trman3,trman3.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = trman3))
)
#
#
# Entry for uc4
#
uc4d =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr06.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = uc4d))
)
uc4q =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = uc4q))
)
uc4p =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nccisp33.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = uc4p))
)
#
# Entry for uc4g
#
uc4g =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr05.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = uc4g))
)
#
# Entry for uc4gp
#
uc4gp =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nccisp33.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = uc4gp))
)
#
# Entry for ucom
#
ucomd,ucomd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ucomd))
)
ucomq,ucomq.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =nurse)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ucomq))
)
ucomp,ucomp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sand)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ucomp))
)
#
# Entry for vdp
#
vdpd,vdpd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = vdpd))
)
vdpq,vdpq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nurse.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = vdpq))
)
vdpp,vdpp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sunpvol.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = vdpp))
)
#
# Entry for vda
#
## Voluntary Data Analysis database
vdad,vdad.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = vdad))
)
vdap,vdap.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sunpvol)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = vdap))
)
vdaq,vdaq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nurse)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = vdaq))
)
#
# Entry for vol
#
vold2,vold2.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = vold2))
)
volp2,volp2.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sunpvol)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = volp2))
)
volq2,volq2.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nurse)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = volq2))
)
#
#
# Entry for cap
#
## Capacity Planning database
capd,capd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = lnxdev)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = capd))
)
capp,capp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = lnxprod)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = capp))
)
capq,capq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = lnxqa)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = capq))
)
#
--- Info ---
PL/SQL Developer
Version 6.0.4.906 (MBCS)
02.24835 - Unlimited user license
Windows XP version 6.0 (build 2600) Service Pack 2
Physical memory : 2,088,428 kB (1,352,980 available)
Paging file : 4,030,588 kB (2,921,116 available)
Virtual memory : 2,097,024 kB (2,029,656 available)
Parameters
C:\Program Files\PLSQL Developer\PLSQLDev.exe
Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Plug-Ins
*FTP File Interface 1.0 (C:\Program Files\PLSQL Developer\PlugIns\ftp.dll)
(* is Active)
Aliases
acct4d
acct4d.world
acct4p
acct4p.world
acct4q
...
Homes
ora9i (c:\ora9i)
DLLs
c:\ora9i\bin\oci.dll
TNS File
c:\ora9i\Network\Admin\tnsnames.ora
Using
Home: ora9i
DLL: c:\ora9i\bin\oci.dll
OCI: version 9.2
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0
Character size: 1 byte(s)
--- Registry ---
SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
ORACLE_HOME = c:\ora9i
ORACLE_HOME_NAME = ora9i
API = c:\ora9i\dbs
ORACLE_GROUP_NAME = Oracle - ora9i
NLS_LANG = NA
OO4O = c:\ora9i\oo4o\mesg
OLEDB = c:\ora9i\oledb\mesg
SOFTWARE\ORACLE\ALL_HOMES
HOME_COUNTER = 1
DEFAULT_HOME = ora9i
LAST_HOME = 0
SOFTWARE\ORACLE\ALL_HOMES\ID0
NAME = ora9i
PATH = c:\ora9i
NLS_LANG = NA
SOFTWARE\ORACLE\HOME0
ID = 0
ORACLE_GROUP_NAME = Oracle - ora9i
ORACLE_HOME_NAME = ora9i
ORACLE_HOME = c:\ora9i
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
ORACLE_BUNDLE_NAME = Enterprise
SQLPATH = c:\ora9i\dbs
ORACLE_HOME_KEY = Software\ORACLE\HOME0
ORAMTS_CP_TRACE_LEVEL = 0
ORAMTS_CP_TRACE_DIR = c:\ora9i\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
SOFTWARE\ORACLE\JInitiator
SOFTWARE\ORACLE\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
SOFTWARE\ORACLE\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = c:\ora9i\MSHELP\oracleo.hlp
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = c:\ora9i\oo4o
SOFTWARE\ORACLE\OracleMTSRecoveryService
SOFTWARE\ORACLE\OracleMTSRecoveryService\Protid_0
Name = HTTP
Host = ncci-p6ossgzopn
Port = 2030
SOFTWARE\ORACLE\OracleMTSRecoveryService\Setup
NumberOfInstalls =
--- Path ---
c:\ora9i\bin
C:\Program Files\Oracle\jre\1.3.1\bin
C:\Program Files\Oracle\jre\1.1.8\bin
C:\WINDOWS\system32
C:\WINDOWS
C:\WINDOWS\System32\Wbem
C:\Program Files\Common Files\Roxio Shared\DLLShared
C:\Program Files\IBM\Trace Facility\
C:\Program Files\IBM\Personal Communications\
C:\PROGRA~1\IBM\SQLLIB\BIN
C:\PROGRA~1\IBM\SQLLIB\FUNCTION
C:\PROGRA~1\IBM\SQLLIB\SAMPLES\REPL
C:\PROGRA~1\NETMAN~1\System
C:\Program Files\SSH Communications Security\SSH Tectia\SSH Tectia AUX
C:\Program Files\SSH Communications Security\SSH Tectia\SSH Tectia Broker
C:\Program Files\SSH Communications Security\SSH Tectia\SSH Tectia Client
C:\PROGRA~1\NETMAN~1\COMMON
C:\PROGRA~1\NETMAN~1\APPS\EMULAT~1
C:\PROGRA~1\NETMAN~1\APPS\X
--- TNS names ---
##############################################################################
#
# Filename......: tnsnames.ora 06092006 for ntdesktop
#
##############################################################################
# Entry for acct4
#
acct4d,acct4d.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = acct4d))
)
acct4q,acct4q.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = acct4q))
)
acct4p,acct4p.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nccisp33.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = acct4p))
)
#
# Entry for aro
#
arod,arod.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr06.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = arod))
)
aroq,aroq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr05.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = aroq))
)
arop,arop.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr04.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = arop))
)
#
# Entry for art
#
artd,artd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr06.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = artd))
)
artq,artq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr05.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = artq))
)
artp,artp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr04.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = artp))
)
#
# Entry for crm
#
crmd,crmd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = crmd))
)
crmq,crmq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = crmq))
)
crmt,crmt.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = crmt))
)
crmp,crmp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr01.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = crmp))
)
bcrmp,bcrmp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr07.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = bcrmp))
)
#
# Entry for ctd
#
ctdd =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =aixr06.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ctdd))
)
ctdq =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =aixr05.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ctdq))
)
ctdp =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =aix6.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ctdp))
)
#
# Entry for ctsa
#
ctsad =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =devo.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ctsad))
)
ctsaq =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =nurse.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ctsaq))
)
ctsap =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =reef.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ctsap))
)
#
# Entry for data
#
datad,datad.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = datad))
)
dataq,dataq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nurse)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dataq))
)
datap,datap.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sand)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = datap))
)
#
# Entry for dba
#
dba,dba.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dba))
)
#
# Entry for dci
#
dcid,dcid.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr06.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dcid))
)
dcip,dcip.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nccisp23.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dcip))
)
dciq,dciq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr05.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dciq))
)
#
# Entry for dssh
#
dssh,dssh.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aix1.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dssh))
)
dsshd,dsshd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr09.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dsshd))
)
dsshq,dsshq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr08.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dsshq))
)
#
# Entry for ecm
#
ecmd=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr06.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ecmd))
)
ecmd2=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ecmd2))
)
ecmq=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ecmq))
)
ecmp=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr07.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ecmp))
)
#
# Entry for eprise
#
eprised,eprised.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = eprised))
)
epriseq,epriseq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = epriseq))
)
epriseqa,epriseqa.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = epriseqa))
)
eprisep,eprisep.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr07.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = eprisep))
)
#
# Entry for epsource
#
epsourced,epsourced.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = epsourced))
)
epsourceq,epsourceq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = epsourceq))
)
epsourcep,epsourcep.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr01.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = epsourcep))
)
#
# Entry for extproc
#
extproc_connection_data.world=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = extproc_key))
(CONNECT_DATA = (SID = extproc_agent))
)
#
#
# Entry for idb
#
qidb,qidb.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nurse)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = qidb))
)
idb,idb.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = idb))
)
pidb,pidb.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sand)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = pidb))
)
#
#
# Entry for lms
#
lmsd,lmsd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = lmsd))
)
lmsq,lmsq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = lmsq))
)
lmsp,lmsp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aix1.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = lmsp)))
#
# Entry for met
#
pmet,pmet.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sand)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = pmet))
)
qmet,qmet.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nurse)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = qmet))
)
dmet,dmet.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dmet))
)
#
# Entry for oap
#
OAPD,OAPD.world,OAPD.ncci.com=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr09.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = OAPD))
)
OAPQ,OAPQ.world,OAPQ.ncci.com=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr08.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = OAPQ))
)
OAPP,OAPP.world,OAPP.ncci.com=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aix1.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = OAPP))
)
OAPT,OAPT.world,OAPT.ncci.com=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = OAPT))
)
#
#
#
#
#
# Entry for oem
#
oemq=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = nurse.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = oemq))
)
oemp=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = sunpvol.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = oemp))
)
#
# Entry for ois
#
oisd,oisd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr09.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = oisd))
)
oisq,oisq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aixr08.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = oisq))
)
oisp,oisp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(Host = aix1.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = oisp))
)
#
# Entry for pcs
#
PCSQA,PCSQA.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aix6.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = PCSQA))
)
#
# Entry for point
#
pointd,pointd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = pointd))
)
pointq,pointq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = pointq))
)
pointp,pointp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr01.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = pointp))
)
#
# Entry for prs
#
prsz,prsz.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = lnoaesd.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = prsz))
)
#
# Entry for prs
#
prsd,prsd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr06.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = prsd))
)
prsq,prsq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr05.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = prsq))
)
prsp,prsp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr04.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = prsp))
)
prst,prst.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr06.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = prst))
)
#
# Entry for rmap
#
drmap,drmap.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr06)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = drmap))
)
drmap2,drmap2.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr06)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = drmap2))
)
qrmap,qrmap.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr05)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = qrmap))
)
PRMAP,PRMAP.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aix6.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = PRMAP))
)
#
#
# Entry for scb
#
scbd =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = scbd))
)
scbq =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = scbq))
)
scbp =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =aixr07.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = scbp))
)
#
# Entry for scbd2
#
scbd2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =aixr03.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = scbd2))
)
#
# Entry for statdb
#
statdb,statdb.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =nurse)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = statdb))
)
#
# Entry for sysman
#
sysman,sysman.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = hammer.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = sysman))
)
#
#
# Entry for toc
#
dtoc,dtoc.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = dtoc))
)
qtoc,qtoc.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nurse)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = qtoc))
)
ptoc,ptoc.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sand)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ptoc))
)
#
# Entry for trman
#
trman,trman.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sand)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = trman))
)
#
# Entry for trman3
#
trman3,trman3.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = trman3))
)
#
#
# Entry for uc4
#
uc4d =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr06.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = uc4d))
)
uc4q =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr02.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = uc4q))
)
uc4p =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nccisp33.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = uc4p))
)
#
# Entry for uc4g
#
uc4g =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = aixr05.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = uc4g))
)
#
# Entry for uc4gp
#
uc4gp =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nccisp33.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = uc4gp))
)
#
# Entry for ucom
#
ucomd,ucomd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ucomd))
)
ucomq,ucomq.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host =nurse)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ucomq))
)
ucomp,ucomp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sand)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ucomp))
)
#
# Entry for vdp
#
vdpd,vdpd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = vdpd))
)
vdpq,vdpq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nurse.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = vdpq))
)
vdpp,vdpp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sunpvol.ncci.com)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = vdpp))
)
#
# Entry for vda
#
## Voluntary Data Analysis database
vdad,vdad.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = vdad))
)
vdap,vdap.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sunpvol)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = vdap))
)
vdaq,vdaq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nurse)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = vdaq))
)
#
# Entry for vol
#
vold2,vold2.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = devo)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = vold2))
)
volp2,volp2.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = sunpvol)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = volp2))
)
volq2,volq2.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = nurse)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = volq2))
)
#
#
# Entry for cap
#
## Capacity Planning database
capd,capd.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = lnxdev)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = capd))
)
capp,capp.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = lnxprod)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = capp))
)
capq,capq.world=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = TCP.world)
(PROTOCOL = TCP)
(Host = lnxqa)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = capq))
)
#
