Hi,
I am having a problem connecting to the DB. I get the ORA-12154: TNS:could not resolve the connection identifier specified. This previously worked on my machine, but I had to get a new machine because my harddrive was dying. The only wrinkle is that they copied my profile from the old machine and put it on the new machine. So, while I still needed to re-install the software (because it was a fresh image), if you store any program related information in the Windows Profile, that could be the cause of the conflict.
I can connect using Oracle SQL developer, using the connection name from TNS, so I think it is something to do with this software installation specifically.
Below is the output of my about pages.
Thanks,
Ian
--- Info ---
PL/SQL Developer
Version 7.1.2.1363
01.45423 - 5 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 2)
Physical memory : 1,047,916 kB (484,464 available)
Paging file : 2,518,672 kB (2,020,936 available)
Virtual memory : 2,097,024 kB (1,995,728 available)
Parameters
C:\Program Files\PLSQL Developer\PlSqlDev.exe
Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Preference Files
C:\Program Files\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files\PLSQL Developer\Preferences\239507\default.ini
Plug-Ins
Aliases
DFRSETU1.GO.SSA.GOV
DRFADMN1
DRFADMN1_S306AC9
DRFADMN1_S306AEE
DRFDEVL1
...
Homes
OraClient10g_home1 (C:\ORANT)
DLLs
C:\ORANT\bin\oci.dll
TNS File
C:\ORANT\Network\Admin\tnsnames.ora
Using
Home: OraClient10g_home1
DLL: C:\ORANT\bin\oci.dll
OCI: version 9.2
--- Registry ---
SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
SOFTWARE\ORACLE\JInitiator
SOFTWARE\ORACLE\JInitiator\1.3.1.21
JavaHome = C:\Program Files\Oracle\JInitiator 1.3.1.21
SOFTWARE\ORACLE\JInitiator\1.3.1.29
JavaHome = C:\Program Files\Oracle\JInitiator 1.3.1.29
SOFTWARE\ORACLE\KEY_OraClient10g_home1
ORACLE_HOME = C:\ORANT
ORACLE_HOME_NAME = OraClient10g_home1
ORACLE_GROUP_NAME = Oracle - OraClient10g_home1
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
StatementCacheSize = 0
OLEDB = C:\ORANT\oledb\mesg
StmtCacheSize = 0
OO4O = C:\ORANT\oo4o\mesg
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient10g_home1
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:\ORANT\oo4o\doc\oracleo.hlp
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\ORANT\oo4o
SOFTWARE\ORACLE\ODP.NET
SOFTWARE\ORACLE\ODP.NET\1.102.3.0
DllPath = C:\ORANT\bin
TraceFileName = C:\odp.net1.trc
TraceLevel = 0
TraceOption = 0
StatementCacheSize = 0
--- Path ---
C:\ORANT\bin
D:\ORACLE\BITOOLSHOME_1\BIN
D:\ORACLE\BITOOLSHOME_1\JRE\1.4.2\BIN\CLIENT
D:\ORACLE\BITOOLSHOME_1\JRE\1.4.2\BIN
D:\ORAHOME_1\BIN
D:\ORAHOME_1\JRE\1.4.2\BIN\CLIENT
D:\ORAHOME_1\JRE\1.4.2\BIN
C:\PROGRAM FILES\MKS\INTEGRITYCLIENT\BIN
D:\ORACLE\PRODUCT\10.2.0\CLIENT_1\BIN
C:\ORA-ADI\BIN
C:\WINNT\SYSTEM32
C:\WINNT
C:\WINNT\SYSTEM32\WBEM
C:\PROGRA~1\ESWM\CLIENT~1\BIN
C:\PROGRAM FILES\IBM\PERSONAL COMMUNICATIONS\
C:\WINNT\ESISOFT
C:\PROGRAM FILES\LIGHTS~1\LSNVS
C:\PROGRAM FILES\SYBASE\SHARED\MERANTODBC
C:\DBASE
C:\WP
\C:\WPLIB
Y:\
C:\ORA WIN\BIN
C:\PROGRAM FILES\EXECUTIVE SOFTWARE\DISKEEPER
C:\PROGRAM FILES\INTERNET EXPLORER
C:\SQLLIB\BIN
C:\SQLLIB\FUNCTION
C:\SQLLIB\HELP
C:\PROGRA~1\CA\COMMON\SCANEN~1
C:\PROGRA~1\CA\ETRUST~1
C:\PROGRAM FILES\COMMON FILES\COMPUWARE
C:\PROGRAM FILES\IBM\TRACE FACILITY\
C:\PROGRAM FILES\DISKEEPER CORPORATION\DISKEEPER\
C:\PROGRAM FILES\WINDOWS IMAGING\
--- TNS names ---
# TNSNAMES.ORA Network Configuration File: c:\orant91\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
utest=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1206.ssa.gov)(PORT=1539))
(CONNECT_DATA=
(SID=utest)
)
)
vtest =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = s0b1205)(Port = 1552))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = vtest)
)
)
DRFTTE1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s0b1205.ssa.gov)(PORT = 1531))
)
(CONNECT_DATA =
(SERVICE_NAME = DRFTTE1)
)
)
ERFACT01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s0b1204.ssa.gov)(PORT = 40000))
)
(CONNECT_DATA =
(SERVICE_NAME = erfact01)
)
)
T10 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s0b1204.ssa.gov)(PORT = 1525))
)
(CONNECT_DATA =
(SERVICE_NAME = T10)
)
)
DRFVALD1_S306AEF =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s306aef)(PORT = 40700))
)
(CONNECT_DATA =
(SID = drfvald1)
(SERVER = DEDICATED)
)
)
DRFSAND1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1205.ssa.gov)(PORT=1561))
(CONNECT_DATA=
(SID=DRFSAND1)
)
)
DRFSETU1 =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1206)(PORT=1532))
(CONNECT_DATA=(SID=drfsetu1))
)
DRFSEU1_S306AEF =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s306aef)(PORT = 40110))
)
(CONNECT_DATA =
(SID = DRFSEU1)
(SERVER = DEDICATED)
)
)
DRFSAN1_S306AEE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s306aee)(PORT = 40410))
)
(CONNECT_DATA =
(SID = drfsan1)
(SERVER = DEDICATED)
)
)
drftest1 = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1206)(PORT=1534))
(CONNECT_DATA=(SID=drftest1))
)
WRFACT01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s0b1204.ssa.gov)(PORT = 46000))
)
(CONNECT_DATA =
(SERVICE_NAME = wrfact01)
)
)
DFRSETU1.GO.SSA.GOV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s306ac9.ba.ssa.gov)(PORT = 40100))
)
(CONNECT_DATA =
(SID = dfrsetu1)
(SERVER = DEDICATED)
)
)
DRFSETU1.GO.SSA.GOV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s306ac9.ba.ssa.gov)(PORT = 40100))
)
(CONNECT_DATA =
(SID = drfsetu1)
(SERVER = DEDICATED)
)
)
RCAT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s306aee)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = rcat)
)
)
MCASTEST_172.17.111.91 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.111.91)(PORT = 30000))
)
(CONNECT_DATA =
(SID = MCASTEST)
(SERVER = DEDICATED)
)
)
DRFINTG1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s0b1206)(PORT = 1536))
)
(CONNECT_DATA =
(SID = drfintg1)
(SERVER = DEDICATED)
)
)
TRFACT01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s0b1203.ssa.gov)(PORT = 40300))
)
(CONNECT_DATA =
(SID = trfact01)
(SERVER = DEDICATED)
)
)
DRFDEVL1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s0b1205.ssa.gov)(PORT = 1551))
)
(CONNECT_DATA =
(SID = drfdevl1)
(SERVER = DEDICATED)
)
)
DRFADMN1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s306aee.ba.ssa.gov)(PORT = 40000))
)
(CONNECT_DATA =
(SERVICE_NAME = drfadmn1)
(SERVER = DEDICATED)
)
)
irfact01=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=S0B1200.ssa.gov)(PORT=55000))
(CONNECT_DATA=
(SERVICE_NAME=irfact01)
(INSTANCE_NAME=irfact011)
)
)
IRFACT011_S0B1200 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = S0B1200)(PORT = 55000))
)
(CONNECT_DATA =
(SID = IRFACT011)
(SERVER = DEDICATED)
)
)
####################################
# Date..........: Thu Aug 22 16:38:10 EDT 2002
####################################
MCASDEVL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s306cff.ba.ssa.gov)(PORT = 1541))
)
(CONNECT_DATA =
(SID = mcasdevl)
(SERVER = DEDICATED)
)
)
RCAT_S306AEE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s306aee)(PORT = 1521))
)
(CONNECT_DATA =
(SID = RCAT)
(SERVER = DEDICATED)
)
)
FEDVISI3_S306AC9 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s306ac9)(PORT = 1523))
)
(CONNECT_DATA =
(SID = fedvisi3)
(SERVER = DEDICATED)
)
)
DRFVALD1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s306aef.ba.ssa.gov)(PORT = 40700))
)
(CONNECT_DATA =
(SERVICE_NAME = drfvald1)
)
)
DRFADMN1_S306AEE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s306aee)(PORT = 40000))
)
(CONNECT_DATA =
(SID = drfadmn1)
(SERVER = DEDICATED)
)
)
DRFADMN1_S306AC9 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s306ac9)(PORT = 40003))
)
(CONNECT_DATA =
(SID = drfadmn1)
(SERVER = DEDICATED)
)
)
MCASTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.111.91)(PORT = 30000))
)
(CONNECT_DATA =
(SID = mcastest)
(SERVER = DEDICATED)
)
)
DRFGOLD1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s306aef.ba.ssa.gov)(PORT = 40300))
)
(CONNECT_DATA =
(SID = drfgold1)
(SERVER = DEDICATED)
)
)
PRFACT01 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s0b1202.ssa.gov)(PORT = 55000))
(ADDRESS = (PROTOCOL = TCP)(HOST = s0b1203.ssa.gov)(PORT = 55000))
)
(CONNECT_DATA =
(SID = prfact011)
(SERVER = DEDICATED)
)
)
DRFSETU1_S306AEF =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s306aef)(PORT = 40100))
)
(CONNECT_DATA =
(SID = drfsetu1)
(SERVER = DEDICATED)
)
)
DRFSETU1_S306AEE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s306aee)(PORT = 40100))
)
(CONNECT_DATA =
(SID = DRFSETU1)
(SERVER = DEDICATED)
)
)
VRFACT01 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = s0b1200.ssa.gov)(PORT = 1531))
(CONNECT_DATA =(SID = VRFACT01))
)
DRFINTE1 = (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1205)(PORT=1541))
(CONNECT_DATA=(SID=DRFINTE1))
)
DRFSETU1_S306AEF.BA.SSA.GOV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s306aef.ba.ssa.gov)(PORT = 40100))
)
(CONNECT_DATA =
(SID = drfsetu1)
(SERVER = DEDICATED)
)
)
drftest2=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=s306cff.ba.ssa.gov)(PORT=1531))
(CONNECT_DATA=
(SID=drftest2)
)
)
VIS=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=s0b1201.ssa.gov)(PORT=1524))
(CONNECT_DATA=
(SID=VIS)
)
)
r12=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=s306aef.ba.ssa.gov)(PORT=1531))
(CONNECT_DATA=
(SID=r12)
)
)
R12DEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = s306aef.ba.ssa.gov)(PORT = 1541))
)
(CONNECT_DATA =
(SID = R12DEV)
(SERVER = DEDICATED)
)
)