Connection failure

[JHodson]

Upgraded my Oracle client and now I can't connect to the database:

TNS: Could not resolve the connect identifier specified.
Here is the info from the support section:

--- Info ---

PL/SQL Developer
Version 7.0.2.1076 (MBCS)
Windows XP version 5.5 (build 3790) Service Pack 1

Physical memory : 1,046,520 kB (200,896 available)
Paging file : 2,549,268 kB (1,892,752 available)
Virtual memory : 2,097,024 kB (1,975,548 available)

Parameters
C:\Program Files (x86)\PLSQL Developer\PLSQLDev.exe

Preferences
Session mode: Multi
OCI Library: C:\Oracle\product\10.1.0\Client_1\bin\oci.dll
Use OCI7: False

Preference Files
C:\Program Files (x86)\PLSQL Developer\Preferences\Default\Default.ini
C:\Program Files (x86)\PLSQL Developer\Preferences\hodsonjl\default.ini

Plug-Ins

Aliases
ICDB

Homes
OraClient10g_home1 (C:\Oracle\product\10.1.0\Client_1)
OraDb10g_home1 (C:\oracle\product\10.1.0\Db_1)

DLLs
C:\Oracle\product\10.1.0\Client_1\bin\oci.dll

TNS File
C:\Oracle\product\10.1.0\Client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient10g_home1
DLL: C:\Oracle\product\10.1.0\Client_1\bin\oci.dll
OCI: version 9.2

--- Registry ---

SOFTWARE\ORACLE
inst_loc = C:\Program Files (x86)\Oracle\Inventory
ORACLE_HOME = C:\oracle\ora90
ORACLE_HOME_NAME = OraHome90
API = C:\oracle\ora90\dbs
ORACLE_GROUP_NAME = Oracle - OraHome90
NLS_LANG = NA
ORA_CRS_HOME = C:\oracle\product\10.1.0\Db_1
VOBHOME2.0 = C:\Oracle\product\10.1.0\Client_1

SOFTWARE\ORACLE\ALL_HOMES
HOME_COUNTER = 2
DEFAULT_HOME = OraHome90
LAST_HOME = 1

SOFTWARE\ORACLE\ALL_HOMES\ID0
NAME = OraHome90
PATH = C:\oracle\ora90
NLS_LANG = NA

SOFTWARE\ORACLE\ALL_HOMES\ID1
NAME = OraHome92
PATH = C:\oracle\ora92
NLS_LANG = NA

SOFTWARE\ORACLE\HOME0
ID = 0
ORACLE_GROUP_NAME = Oracle - OraHome90
ORACLE_HOME_NAME = OraHome90
ORACLE_HOME = C:\oracle\ora90

SOFTWARE\ORACLE\HOME1
ID = 1
ORACLE_GROUP_NAME = Oracle - OraHome92
ORACLE_HOME_NAME = OraHome92
ORACLE_HOME = C:\oracle\ora92

SOFTWARE\ORACLE\KEY_OraClient10g_home1
ORACLE_HOME = C:\Oracle\product\10.1.0\Client_1
ORACLE_HOME_NAME = OraClient10g_home1
ORACLE_GROUP_NAME = Oracle - OraClient10g_home1
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
ORACLE_BUNDLE_NAME = Enterprise
OLEDB = C:\Oracle\product\10.1.0\Client_1\oledb\mesg
SQLPATH = C:\Oracle\product\10.1.0\Client_1\dbs
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient10g_home1
OO4O = C:\Oracle\product\10.1.0\Client_1\oo4o\mesg
MSHELP_TOOLS = C:\Oracle\product\10.1.0\Client_1\MSHELP

SOFTWARE\ORACLE\KEY_OraClient10g_home1\ODP.NET
TraceFileName = C:\ODPNET.trc
TraceLevel = 0
TraceOption = 0

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

SOFTWARE\ORACLE\KEY_OraClient10g_home1\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = C:\Oracle\product\10.1.0\Client_1\oo4o\doc\oracleo.hlp
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\Oracle\product\10.1.0\Client_1\oo4o

SOFTWARE\ORACLE\KEY_OraDb10g_home1
ORACLE_HOME = C:\oracle\product\10.1.0\Db_1
ORACLE_HOME_NAME = OraDb10g_home1
ORACLE_GROUP_NAME = Oracle - OraDb10g_home1
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = AMERICAN_AMERICA.WE8MSWIN1252
OLEDB = C:\oracle\product\10.1.0\Db_1\oledb\mesg
OO4O = C:\oracle\product\10.1.0\Db_1\oo4o\mesg
SQLPATH = C:\oracle\product\10.1.0\Db_1\dbs
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraDb10g_home1
ORACLE_BASE = C:\oracle\product\10.1.0
MSHELP_TOOLS = C:\oracle\product\10.1.0\Db_1\MSHELP
RDBMS_CONTROL = C:\oracle\product\10.1.0\Db_1\DATABASE
RDBMS_ARCHIVE = C:\oracle\product\10.1.0\Db_1\DATABASE\ARCHIVE

SOFTWARE\ORACLE\KEY_OraDb10g_home1\ODP.NET
TraceFileName = C:\ODPNET.trc
TraceLevel = 0
TraceOption = 0

SOFTWARE\ORACLE\KEY_OraDb10g_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

SOFTWARE\ORACLE\KEY_OraDb10g_home1\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = C:\oracle\product\10.1.0\Db_1\oo4o\doc\oracleo.hlp
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\oracle\product\10.1.0\Db_1\oo4o

SOFTWARE\ORACLE\Ocr
ocrconfig_loc = C:\oracle\product\10.1.0\Db_1\cdata\localhost\local.ocr
Local_Only = TRUE

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\SCR

SOFTWARE\ORACLE\Workflow
Icon Directory = C:\Oracle\product\10.1.0\Client_1\WF\ICON
Level = 100
Version = 2.6.3.0.0

SOFTWARE\ORACLE\Workflow\Languages

--- Path ---

C:\Oracle\product\10.1.0\Client_1\bin
C:\Oracle\product\10.1.0\Client_1\jre\1.4.2\bin\client
C:\Oracle\product\10.1.0\Client_1\jre\1.4.2\bin
C:\oracle\product\10.1.0\Db_1\bin
C:\oracle\product\10.1.0\Db_1\jre\1.4.2\bin\client
C:\oracle\product\10.1.0\Db_1\jre\1.4.2\bin
C:\Program Files (x86)\Windows Resource Kits\Tools\
C:\PROGRA~2\GRADKE~1\DBSIGN~1\lib
C:\WINDOWS\system32
C:\WINDOWS
C:\WINDOWS\System32\Wbem
c:\Program Files\ATI Technologies\ATI Control Panel\
C:\WINDOWS\sysWOW64
C:\Program Files (x86)\Microsoft SQL Server\80\Tools\BINN
C:\Program Files (x86)\ActivCard\ActivCard Gold\Resources
Resources
C:\Program Files (x86)\Common Files\Roxio Shared\DLLShared
C:\Program Files (x86)\ApproveIt\ThirdParty\Bin\
C:\Program Files (x86)\ApproveIt\
C:\Program Files (x86)\Tumbleweed\Desktop Validator\
C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\

--- TNS names ---

# tnsnames.ora Network Configuration File: C:\Oracle\product\10.1.0\Client_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ICDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 143.83.63.194)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = icdb.amed.ds.army.mil)
)
)

 

[Marco Kalter]

The Oracle Client upgrade probably assigned a new Primary Oracle Home, which was not yet configured with the Oracle Net Configuration Assistant. You can either do so now, or use the Oracle Home Selector to change the Primary Oracle Home, or start PL/SQL Developer without connecting and select "OraDb10g_home1" from the Oracle Home selection list.