Unable to run the plsql developer import option, getting "Not Connected to Oracle" error

[Natarajan]

Hi there,

PLSQL Developer version: 10.05.1710 on Windows Server 2008 R2 Std (01.07852 - 20 user licence)

I am trying to export from one tier onto another, I got succeeded in exporting a schema to a pde file. However when I tried to import using the same file, it created table, however failed to import the rows and threw an ORA-03114: not connected to ORACLE error. After this error, the plsql window abruptly hanged and the Oracle session went inactive, and I had to kill the session.

I see the same issue was discussed in this forum itself, but no solution was given.https://forums.allroundautomations....83&PHPSESSID=2e3c1b028a66500ae8a1730abc88b993

In the above discussion, you asked to give some additional information, which I am giving underneath.

Can you find out the cause for the issue and provide a solution?

Thanks in advance,

Natarajan

Info:
=====
PL/SQL Developer
Version 10.0.5.1710
01.87852 - 20 user license
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4,193,848 kB (1,003,520 available)
Paging file : 4,194,304 kB (1,578,000 available)
Virtual memory : 2,097,024 kB (1,868,964 available)

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

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

Preference Files
C:\Users\natarajan_s\AppData\Roaming\PLSQL Developer\Preferences\default\Default.ini
C:\Users\natarajan_s\AppData\Roaming\PLSQL Developer\Preferences\natarajan_s\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)

Aliases
ARD1XEDB
ARP1XEDB
ARQ1XEDB
ART1XEDB
DEV
PROD
QA
TEST

Homes
OraClient11g_home1 (C:\Oracle\product\11.2.0\client_1)

DLLs
C:\Oracle\product\11.2.0\client_1\bin\oci.dll

TNS File
C:\Oracle\product\11.2.0\client_1\Network\Admin\tnsnames.ora

Using
Home: OraClient11g_home1
DLL: C:\Oracle\product\11.2.0\client_1\bin\oci.dll
OCI: version 11.1
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0

Character Sets
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: AMERICAN_AMERICA.AL32UTF8
NLS_CHARACTERSET: AL32UTF8
NLS_NCHAR_CHARACTERSET: AL16UTF16

Registry:
=========

SOFTWARE\ORACLE
inst_loc = C:\Program Files (x86)\Oracle\Inventory

SOFTWARE\ORACLE\KEY_OraClient11g_home1
ORACLE_HOME = C:\Oracle\product\11.2.0\client_1
ORACLE_HOME_NAME = OraClient11g_home1
ORACLE_GROUP_NAME = Oracle - OraClient11g_home1
ORACLE_BUNDLE_NAME = Enterprise
NLS_LANG = AMERICAN_AMERICA.AL32UTF8
OLEDB = C:\Oracle\product\11.2.0\client_1\oledb\mesg
OO4O = C:\Oracle\product\11.2.0\client_1\oo4o\mesg
ORACLE_HOME_KEY = SOFTWARE\ORACLE\KEY_OraClient11g_home1
MSHELP_TOOLS = C:\Oracle\product\11.2.0\client_1\MSHELP
SQLPATH = C:\Oracle\product\11.2.0\client_1\dbs

SOFTWARE\ORACLE\KEY_OraClient11g_home1\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\OO4O
CacheBlocks = 20
FetchLimit = 100
FetchSize = 4096
HelpFile = C:\Oracle\product\11.2.0\client_1\oo4o\doc\oraclec.chm
PerBlock = 16
SliceSize = 256
TempFileDirectory = c:\temp
OO4O_HOME = C:\Oracle\product\11.2.0\client_1\oo4o

SOFTWARE\ORACLE\ODP.NET

SOFTWARE\ORACLE\ODP.NET\2.112.1.0
DllPath = C:\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

Path:
=====

C:\Oracle\product\11.2.0\client_1\bin
C:\Windows\system32
C:\Windows
C:\Program Files\TortoiseSVN\bin
C:\Program Files\SourceGear\Common\DiffMerge\

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).