Connections to this server are no longer supported

[dtamburin]

Having a problem after upgrading to pl/sql 7 and Oracle client 10.

I support Oracle databases from verions 7 (yes that old) all the way to oracle 10. After upgrading I can no longer connect to my oracle 7 database. There is no way my client will upgrade this database, so that it out of the question. Is there anyway to still connect to this database?

I tried installing a second version of ps/sql developer (my old version), but that version can no longer read my tnsnames.ora file. Is there any way to rig it so it can?

I'd hate to have to install my old version of pl/sql and oracle client on a second box just to do my work.

Thank you,
Dtamburin

 

[Marco Kalter]

Maybe this is an environment problem. Can you go to Help > Support Info, press the 'Copy all pages' button on this info screen, and paste this text into an e-mail reply?

 

[dtamburin]

Here you go...

--- Info ---

PL/SQL Developer
Version 7.0.2.1076 (MBCS)
01.34187 - 1 user license
Windows XP version 6.0 (build 2600) Service Pack 2

Physical memory : 1,046,704 kB (524,492 available)
Paging file : 2,518,192 kB (2,117,768 available)
Virtual memory : 2,097,024 kB (1,996,272 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\Davidt\default.ini

Plug-Ins

Aliases
enet
enetdev
ESMS.Klingon
lottodb.brgvspoc1
lottodb.lottodb
lottodb.prlvspoc1

Homes
OraClient10g_home1 (C:\oracle\product\10.2.0\client_1)

DLLs
C:\oracle\product\10.2.0\client_1\bin\oci.dll

TNS File
C:\oracle\product\10.2.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient10g_home1
DLL: C:\oracle\product\10.2.0\client_1\bin\oci.dll
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.1.0
Character size: 1 byte(s)

--- Registry ---

SOFTWARE\ORACLE
inst_loc = C:\Program Files\Oracle\Inventory
VOBHOME2.0 = C:\oracle\product\10.2.0\client_1

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
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\ODP.NET
TraceFileName = C:\ODPNET.trc
TraceLevel = 0
TraceOption = 0
StatementCacheSize = 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
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

--- Path ---

C:\oracle\product\10.2.0\client_1\bin
C:\WINDOWS\system32
C:\WINDOWS
C:\WINDOWS\System32\Wbem
C:\Program Files\ATI Technologies\ATI Control Panel

--- TNS names ---

# TNSNAMES.ORA Network Configuration File:
# Generated by Oracle configuration tools.

enetdev =
(DESCRIPTION=
(ADDRESS=
(PROTOCOL = TCP)
(HOST = furby)
(PORT = 1522)
)
(CONNECT_DATA =
(SID = enetdev)
(SERVICE_NAME = enetdev.emaps)
)
)

enet =
(DESCRIPTION=
(ADDRESS=
(PROTOCOL = TCP)
(HOST = empis)
(PORT = 1521)
)
(CONNECT_DATA =
(SID = enet)
(SERVICE_NAME = enet.emaps)
)
)

lottodb.lottodb =
(DESCRIPTION=
(ADDRESS=
(PROTOCOL = TCP)
(HOST = lottodb)
(PORT = 1521)
)
(CONNECT_DATA =
(SID = lottodb)
(SERVICE_NAME = lottodb.nyenet)
)
)

lottodb.prlvspoc1 =
(DESCRIPTION=
(ADDRESS=
(PROTOCOL = TCP)
(HOST = prlvspoc1)
(PORT = 1521)
)
(CONNECT_DATA =
(SID = lottodb)
)
)

lottodb.brgvspoc1 =
(DESCRIPTION=
(ADDRESS=
(PROTOCOL = TCP)
(HOST = brgvspoc1)
(PORT = 1521)
)
(CONNECT_DATA =
(SID = lottodb)
)
)

ESMS.Klingon =
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=klingon)
(PORT=1521)
)
)
(CONNECT_DATA=
(SID=ESMS)
)
)

 

[CTzen]

Oracle Client 10G is not compatible with Oracle 7 Databases. See compatibility matrix .

You will need to install Client version 9.0.1 or less, and select it manually in PL/SQL Developer settings (Tools -> Preferences -> Oracle -> Connection -> Oracle Home)

 

[dtamburin]

Thanks Slava