Code Assistant don't working with Kerberos authentication in database

rua

Member
Hi all!
We have kerberos (AD authentication/empty password technology) installed in Oracle databases. But Code Assistant dont't working any more! Schema rights are the same as schema without kerberos authentication. In trace file I see following :
/*
The name + type results of these queries will be used by the Code Assistant
if the "Describe Context" option is enabled. After typing 3 or more characters
the Code Assistant will show a list of matching names.
Separate multiple queries with semi-colons and use the :schema bind variable
to restrict names to the currently connected user.
In case of an error the query results will be omitted. No error message will
be displayed.
Place this file in the PL/SQL Developer installation directory for all users,
or in the "%APPDATA%\PLSQL Developer" directory for a specific user.
*/
select object_name, object_type
from sys.all_objects o
where o.owner = :schema
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

Does anybody know , what is the file name we have to place in root directory or how we have to fix this issue at all?
 
This is from Help > Support Info :

Version 10.0.5.1710
01.726198 - 10 user license
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4 194 304 kB (4 194 304 available)
Paging file : 4 194 304 kB (4 194 304 available)
Virtual memory : 2 097 024 kB (1 872 984 available)

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

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: True

Preference Files
C:\Program Files (x86)\PLSQL Developer\Preferences\Default\Default.ini
C:\Users\admmaah\AppData\Roaming\PLSQL Developer\Preferences\admmaah\default.ini

Plug-Ins
*Active Query Builder (C:\Program Files (x86)\PLSQL Developer\PlugIns\ActiveQueryBuilder.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files (x86)\PLSQL Developer\PlugIns\plsqldoc.dll)
*Red Gate Deployment Plug-In (C:\Program Files (x86)\PLSQL Developer\PlugIns\RedGate.dll)
*Version Control Interface 1.2 (C:\Program Files (x86)\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)

Homes
OraClient11g_home1_32bit (D:\oracle\product\11.2.0\client_1)

DLLs
D:\oracle\product\11.2.0\client_1\bin\oci.dll

TNS File
D:\oracle\product\11.2.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient11g_home1_32bit
DLL: D:\oracle\product\11.2.0\client_1\bin\oci.dll
OCI: version 11.1
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0

Character Sets
Character size: 1 byte(s)
CharSetID: 171
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.CL8MSWIN1251
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: CL8MSWIN1251
inst_loc = C:\Program Files\Oracle\Inventory

SOFTWARE\ORACLE\KEY_OraClient11g_home1_32bit
ORACLE_HOME = D:\oracle\product\11.2.0\client_1
ORACLE_HOME_NAME = OraClient11g_home1_32bit
ORACLE_GROUP_NAME = Oracle - OraClient11g_home1_32bit
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = AMERICAN_AMERICA.CL8MSWIN1251
OLEDB = D:\oracle\product\11.2.0\client_1\oledb\mesg
OO4O = D:\oracle\product\11.2.0\client_1\oo4o\mesg
SQLPATH = D:\oracle\product\11.2.0\client_1\dbs
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient11g_home1_32bit
MSHELP_TOOLS = D:\oracle\product\11.2.0\client_1\MSHELP

SOFTWARE\ORACLE\KEY_OraClient11g_home1_32bit\OLEDB
CacheType = Memory
EnableCmdTimeout = 0
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
MetaDataCacheSize = 0
DBNotifications = 0
DeferUpdChk = 0

SOFTWARE\ORACLE\KEY_OraClient11g_home1_32bit\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = D:\oracle\product\11.2.0\client_1\oo4o\doc\oraclec.chm
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = D:\oracle\product\11.2.0\client_1\oo4o

SOFTWARE\ORACLE\ODP.NET

SOFTWARE\ORACLE\ODP.NET\2.112.4.0
DllPath = D:\oracle\product\11.2.0\client_1\bin
TraceFileName = C:\odpnet2.trc
TraceLevel = 0
TraceOption = 0
PromotableTransaction = promotable
SelfTuning = 1
StatementCacheWithUdts = 1
UdtCacheSize = 4096
PerformanceCounters = 0
MaxStatementCacheSize = 100
DemandOraclePermission = 0

SOFTWARE\ORACLE\ODP.NET\4.112.4.0
DllPath = D:\oracle\product\11.2.0\client_1\bin
TraceFileName = C:\odpnet4.trc
TraceLevel = 0
TraceOption = 0
SelfTuning = 1
MaxStatementCacheSize = 100
DemandOraclePermission = 0
PerformanceCounters = 0
PromotableTransaction = promotable
StatementCacheWithUdts = 1
UdtCacheSize = 4096

SOFTWARE\ORACLE\remexecservicectr
remaining_time = 120000

C:\ProgramData\Oracle\Java\javapath
D:\oracle\product\11.2.0\client_2\bin
C:\Windows\system32
C:\Windows
C:\Windows\System32\Wbem
C:\Windows\System32\WindowsPowerShell\v1.0\
C:\Windows\System32\WindowsPowerShell\v1.0\
V:\Tools\prog\bin
C:\Program Files\Java\jre7\bin\
C:\Program Files\TortoiseGit\bin
C:\Program Files\PuTTY\
Application:
--------------------------------------------------------------
1.1 Start Date : Wed, 14 Aug 2013 08:56:01 +0400
1.2 Name/Description: plsqldev.exe - (PL/SQL Developer)
1.3 Version Number : 10.0.5.1710
1.4 Parameters :
1.5 Compilation Date: Thu, 11 Jul 2013 16:19:46 +0400
1.6 Up Time : 1 day, 5 hours, 58 minutes, 34 seconds

Exception:
--------------------------------------------------------------------------------------
2.1 Date : Thu, 15 Aug 2013 14:54:36 +0400
2.2 Address : 4B77482A
2.3 Module Name : plsqldev.exe - (PL/SQL Developer)
2.4 Module Version: 10.0.5.1710
2.5 Type : EAccessViolation
2.6 Message : Access violation at address 4B77482A. Write of address 4B77482A.
2.7 ID : 6FD0
2.8 Count : 50

Active Controls:
---------------------
4.1 Form Class :
4.2 Form Text :
4.3 Control Class:
4.4 Control Text :

Computer:
---------------------------------------------------------------------
5.2 Total Memory : 4095 Mb
5.3 Free Memory : 1241 Mb
5.4 Total Disk : 30 Gb
5.5 Free Disk : 0.38 Gb
5.6 System Up Time: 9 days, 29 minutes, 6 seconds
5.7 Processor : Intel(R) Xeon(R) CPU X5650 @ 2.67GHz
5.8 Display Mode : 1280 x 1024, 16 bit
5.9 Display DPI : 96
5.10 Video Card : (driver )
5.11 Printer :

Operating System:
--------------------------------------
6.1 Type : Microsoft Windows 2003
6.2 Build # : 3790
6.3 Update : Service Pack 2
6.4 Language: Russian
6.5 Charset : 204

Call Stack Information:
-----------------------------------------------------------------------------------------------------
|Address |Module |Unit |Class |Procedure/Method |Line |
-----------------------------------------------------------------------------------------------------
|Running Thread: ID=18880; Priority=??; Class= |
|---------------------------------------------------------------------------------------------------|
|7C81BB65|ntdll.dll | | |ExpInterlockedPopEntrySListResume| |
|7C829E20|ntdll.dll | | |RtlGetNtGlobalFlags | |
|7C829DFF|ntdll.dll | | |RtlGetNtGlobalFlags | |
|7C81BB65|ntdll.dll | | |ExpInterlockedPopEntrySListResume| |
|7C829E20|ntdll.dll | | |RtlGetNtGlobalFlags | |
|7C829DFF|ntdll.dll | | |RtlGetNtGlobalFlags | |
|7C81A1F3|ntdll.dll | | |RtlLeaveCriticalSection | |
|77E6242E|kernel32.dll| | |LocalFree | |
|77E62442|kernel32.dll| | |LocalFree | |
|7C82F4FA|ntdll.dll | | |RtlAddAccessAllowedAce | |
|7C8269F7|ntdll.dll | | |NtAccessCheck | |
|7C827587|ntdll.dll | | |NtQueryVirtualMemory | |
|7C82757D|ntdll.dll | | |NtQueryVirtualMemory | |
|77E768AD|kernel32.dll| | |UnhandledExceptionFilter | |
|7739DBBA|USER32.dll | | |ClientThreadSetup | |
|7C8283C9|ntdll.dll | | |KiUserExceptionDispatcher | |
|7C827637|ntdll.dll | | |NtReleaseSemaphore | |
|77E5BFA7|kernel32.dll| | |ReleaseSemaphore | |
|---------------------------------------------------------------------------------------------------|
| |
|Running Thread: ID=10692; Priority=0; Class=; [Main] |
|---------------------------------------------------------------------------------------------------|
|7C827B77|ntdll.dll | | |ZwWaitForSingleObject | |
|7C827B6D|ntdll.dll | | |ZwWaitForSingleObject | |
|7C81A1A8|ntdll.dll | | |RtlEnterCriticalSection | |
|004D3048|plsqldev.exe|Forms.pas |TApplication |WndProc |7775[77] |
|7739C062|USER32.dll | | |CallNextHookEx | |
|77393C8C|USER32.dll | | |DefWindowProcA | |
|77393C30|USER32.dll | | |DefWindowProcA | |
|004D2C0A|plsqldev.exe|Forms.pas | |Default |7681[1] |
|004D2BE0|plsqldev.exe|Forms.pas | |Default |7680[0] |
|004D32FA|plsqldev.exe|Forms.pas |TApplication |WndProc |7844[146]|
|7739C062|USER32.dll | | |CallNextHookEx | |
|7739CF99|USER32.dll | | |PeekMessageA | |
|004D395C|plsqldev.exe|Forms.pas |TApplication |ProcessMessage |8095[2] |
|004D3948|plsqldev.exe|Forms.pas |TApplication |ProcessMessage |8093[0] |
|004D3A7E|plsqldev.exe|Forms.pas |TApplication |HandleMessage |8135[1] |
|004D3A74|plsqldev.exe|Forms.pas |TApplication |HandleMessage |8134[0] |
|004CFC9F|plsqldev.exe|Forms.pas |TCustomForm |ShowModal |5822[29] |
|00FE4788|plsqldev.exe|PLSCommon.pas | |DSAMessageBox |2762[153]|
|00FE3FD8|plsqldev.exe|PLSCommon.pas | |DSAMessageBox |2609[0] |
|00FE4A4D|plsqldev.exe|PLSCommon.pas | |DSAMessageBox |2802[14] |
|00FE49B4|plsqldev.exe|PLSCommon.pas | |DSAMessageBox |2788[0] |
|00FE5493|plsqldev.exe|PLSCommon.pas | |MessageBox |2963[4] |
|00FE53A0|plsqldev.exe|PLSCommon.pas | |MessageBox |2959[0] |
|00E70B3E|plsqldev.exe|SQLUnit.pas |TSQLForm |FormCloseQuery |3273[55] |
|00F0DB8C|plsqldev.exe|ChildForm.pas |TChildForm |FormCloseQuery |7972[5] |
|004CF632|plsqldev.exe|Forms.pas |TCustomForm |CloseQuery |5624[8] |
|004CF60C|plsqldev.exe|Forms.pas |TCustomForm |CloseQuery |5621[5] |
|004CE597|plsqldev.exe|Forms.pas |TCustomForm |WMQueryEndSession |5088[1] |
|773A145B|USER32.dll | | |GetPropA | |
|7739C09A|USER32.dll | | |CallNextHookEx | |
|004CB48B|plsqldev.exe|Forms.pas |TCustomForm |WndProc |3512[136]|
|004CAF38|plsqldev.exe|Forms.pas |TCustomForm |WndProc |3376[0] |
|00D487B8|plsqldev.exe|MainUnit.pas |TPLSQLDevForm |WndProc |7095[15] |
|0054AC94|plsqldev.exe|tntControls.pas |TWinControlTrap|WindowProc |684[19] |
|7739C062|USER32.dll | | |CallNextHookEx | |
|7739BF6F|USER32.dll | | |CallWindowProcW | |
|7739BF59|USER32.dll | | |CallWindowProcW | |
|0054A8E8|plsqldev.exe|tntControls.pas |TWinControlTrap|Win32Proc |572[12] |
|7739C062|USER32.dll | | |CallNextHookEx | |
|77393C8C|USER32.dll | | |DefWindowProcA | |
|77393C30|USER32.dll | | |DefWindowProcA | |
|004D2C0A|plsqldev.exe|Forms.pas | |Default |7681[1] |
|004D2BE0|plsqldev.exe|Forms.pas | |Default |7680[0] |
|004D32FA|plsqldev.exe|Forms.pas |TApplication |WndProc |7844[146]|
|7739C062|USER32.dll | | |CallNextHookEx | |
|7739CF99|USER32.dll | | |PeekMessageA | |
|004D395C|plsqldev.exe|Forms.pas |TApplication |ProcessMessage |8095[2] |
|004D3948|plsqldev.exe|Forms.pas |TApplication |ProcessMessage |8093[0] |
|004D3A7E|plsqldev.exe|Forms.pas |TApplication |HandleMessage |8135[1] |
|004D3A74|plsqldev.exe|Forms.pas |TApplication |HandleMessage |8134[0] |
|004D3D73|plsqldev.exe|Forms.pas |TApplication |Run |8234[20] |
|004D3CC0|plsqldev.exe|Forms.pas |TApplication |Run |8214[0] |
|01004602|plsqldev.exe|PlSqlDev.dpr | | |154[15] |
|---------------------------------------------------------------------------- New message. Click to scroll to the bottom. (javascript:void(0))
 
Back
Top