Importing Tables using PLSQL fails - Ora 003114 Not Connected to Oracle

[Claus Bohm]

Hi there,

PLSQL Developer version: 10.05.1710 on Windows 8.1 Enterprise.

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, 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.

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

Thanks in advance,

Claus

--- Info ---

PL/SQL Developer
Version 10.0.5.1710
01.100682 - 1 user license
Windows 8 (64-bit) 6.2 Build 9200
Language: German (C.O.M. Computer Output Management GmbH)

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.862.880 available)

Parameters
C:\Oracle\PLSQL Developer\plsqldev.exe
DebugSQL

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

Preference Files
C:\Users\mg1boc1.METAGLUE\AppData\Roaming\PLSQL Developer\Preferences\default\Default.ini
C:\Users\mg1boc1.METAGLUE\AppData\Roaming\PLSQL Developer\Preferences\mg1boc1\default.ini

Plug-Ins
*Active Query Builder (C:\Oracle\PLSQL Developer\PlugIns\ActiveQueryBuilder.dll)
*Version Control Interface 1.2 (C:\Oracle\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)

Aliases

DB11G

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.1.0

Character Sets
Character size: 4 byte(s)
CharSetID: 873
NCharSetID: 2000
Unicode Support: True
NLS_LANG: GERMAN_GERMANY.WE8MSWIN1252
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 = GERMAN_GERMANY.WE8MSWIN1252
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:\Informatica\9.5.1\clients\DT\bin
C:\Informatica\9.5.1\clients\tools\datadirect
C:\Informatica\9.5.1\clients\tools\odbcdrv
C:\ProgramData\Oracle\Java\javapath
C:\Windows\system32
C:\Windows
C:\Windows\System32\Wbem
C:\Windows\System32\WindowsPowerShell\v1.0\
C:\Program Files\Condusiv Technologies\ExpressCache\
C:\Program Files\Intel\WiFi\bin\
C:\Program Files\Common Files\Intel\WirelessCommon\
C:\Program Files (x86)\Common Files\lenovo\easyplussdk\bin
C:\Program Files (x86)\Common Files\Lenovo
.

--- TNS names ---

DB11G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = s2014lnx01.metaglue.local)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DB11G)
)
)

 

[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).

 

[fairwaywood]

I'm encountering the same issue. Any solution that can be shared? Thanks.