ORA-1041

[GWS]

We have two versions of the database to access. One is 9.2.0.7 (no problems) and 8.1.7.4.

For the latter I am getting the "hostdef" error. I wonder if this has to do with character sets? The 9.2.0.7 is multi-byte, but the 8.1.7.4 is not. I recall changing something having to do with NLS in response to a popup warning from PL/SQL Developer shortly after we started using the 9.2.0.7 database.

Also, I have multiple Oracle homes - maybe I should point to the 9.2 one?

Here's the "about" info:
PL/SQL Developer
Version 7.1.1.1339
01.42691 - 55 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 2)

Physical memory : 1,046,892 kB (475,408 available)
Paging file : 3,041,880 kB (2,337,056 available)
Virtual memory : 2,097,024 kB (2,005,432 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\datlgsa\default.ini

Plug-Ins
*PL/Formatter Interface (C:\Program Files\PLSQL Developer\PlugIns\plformatter.dll)
(* is Active)

Aliases
ACPT
ADAYTUM
AMOSDPT
awac
awad
...

Homes
DEFAULT_HOME (C:\orant)
OraHome92 (C:\oracle\ora92)

DLLs
C:\orant\bin\oci.dll
C:\orant\bin\ORA803.DLL
C:\orant\bin\ORA804.DLL
C:\orant\bin\ora805.dll

TNS File
C:\orant\Net80\Admin\tnsnames.ora

Using
Home: DEFAULT_HOME
DLL: C:\orant\bin\oci.dll
OCI: Version 8.0

Character Sets
Character size: 1 byte(s)
CharSetID: 873
NCharSetID: 0
Unicode Support: True
NLS_LANG: UTF8

 

[Marco Kalter]

Perhaps you can try your 9.2 client? Just go to Tools > Preferences > Oracle / Connection and select "OraHome92" from the Oracle Home selection list, restart PL/SQL Developer, and try again.

 

[GWS]

That fixed it! Thank you very much.