Recovery not working

[cct]

I have just had another instance of the recovery not working.

I was running a test which hung, and when I tried to cancel execution it hung - which does seem to happen occasionally. So I killed the whole session (I do run multiple instances against different databases) via the X box, and told windows to close it.

I then started a new instance, and was not prompted that there were windows to recover. I had lost some significant changes to a package body. I managed to find the recovery file from the PLS-Recovery directory, so manually recovered from that.

Any ideas why this should happen?

Support info:

--- Info ---

PL/SQL Developer
Version 11.0.4.1774
86.103834 - 10 user license
Service Contract: 01/10/2016
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,822,976 available)

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

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

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

License File
C:\Users\townleyc\AppData\Roaming\PLSQL Developer\aalf.dat

Debug file
C:\Users\townleyc\AppData\Roaming\PLSQL Developer\PlSqlDev.elf

Plug-Ins
*Active Query Builder (C:\Program Files (x86)\PLSQL Developer\PlugIns\ActiveQueryBuilder.dll)
*FTP File Interface 2.1 (C:\Program Files (x86)\PLSQL Developer\PlugIns\ftp.dll)
*PL/SQL Documentation (plsqldoc) (C:\Program Files (x86)\PLSQL Developer\PlugIns\plsqldoc.dll)
*Version Control Interface 1.2 (C:\Program Files (x86)\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)

Aliases
CMSPROD
DEFULL
DEPROD
DETEST
DEVLMUK
...

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 10.2
Oracle Database 11g Release 11.2.0.3.0

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

Monitors
Id = 0
Primary = True
Handle = 592763
Left = 0
Top = 0
Width = 1920
Height = 1080

Id = 1
Primary = False
Handle = 216727877
Left = 1920
Top = 0
Width = 1680
Height = 1050

MainFormOnTaskbar = False

--- Registry ---

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

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 = ENGLISH_UNITED KINGDOM.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

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

SOFTWARE\ORACLE\ODP.NET

SOFTWARE\ORACLE\ODP.NET\1.102.3.0
DllPath = C:\oracle\product\10.2.0\client_1\bin
TraceFileName = C:\odp.net1.trc
TraceLevel = 0
TraceOption = 0
StatementCacheSize = 10

--- Path ---

C:\oracle\product\10.2.0\client_1\bin
C:\oracle\ODAC
C:\oracle\ODAC\bin
c:\oracle\ODAC\odp.net\bin\4
C:\ProgramData\Oracle\Java\javapath
c:\Program Files (x86)\Intel\iCLS Client\
c:\Program Files\Intel\iCLS Client\
C:\windows\system32
C:\windows
C:\windows\System32\Wbem
C:\windows\System32\WindowsPowerShell\v1.0\
C:\Program Files\WIDCOMM\Bluetooth Software\
C:\Program Files\WIDCOMM\Bluetooth Software\syswow64

C:\Program Files\Intel\Intel(R) Management Engine Components\DAL
C:\Program Files\Intel\Intel(R) Management Engine Components\IPT
C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL
C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT
C:\Program Files\Intel\WiFi\bin\
C:\Program Files\Common Files\Intel\WirelessCommon\
C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86
C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x64
C:\PROGRA~2\IBM\CLIENT~1
C:\PROGRA~2\IBM\CLIENT~1\Shared
C:\PROGRA~2\IBM\CLIENT~1\Emulator
C:\Program Files\SourceGear\Common\DiffMerge\
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\
C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\
C:\Program Files\jEdit
C:\Program Files\Microsoft SQL Server\100\DTS\Binn\
C:\Program Files (x86)\Java\jdk1.7.0_51\bin\
c:\Program Files (x86)\GnuWin32\bin\
C:\Program Files (x86)\Windows Kits\8.1\Windows Performance Toolkit\
C:\Program Files\Microsoft SQL Server\110\Tools\Binn\
C:\Program Files (x86)\Microsoft SDKs\TypeScript\1.0\
C:\Program Files\Microsoft SQL Server\120\Tools\Binn\
C:\Program Files (x86)\Skype\Phone\

--- TNS names ---

# tnsnames.ora Network Configuration File: C:\Oracle\10.1.0\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

#
# Infor development database
#
UKDEVINFOR =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ukdevinfordb.spicers.europe)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = UKDEVINFOR)
)
)

#
# Infor TEST database
#
UKTSTINFOR =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = uktstinfordb.spicers.europe)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = UKTSTINFOR)
)
)

#
# Infor Production database
#
UKINFOR =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ukinfordb.spicers.europe)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = UKINFOR)
)
)

# UKINFOR again under a different name - for running DPSI from my PC...
LIVE_UKINFOR =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ukinfordb.spicers.europe)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = UKINFOR)
)
)

#
# Infor modelling database - separate instance on the production DB server
#
UKINFMDL =
(DESCRIPTION =
(SDU=32767)
(TDU=32767)
(ADDRESS = (PROTOCOL = TCP)(HOST = ukinfordb)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = UKINFMDL)
)
)

#
# Development Database
#
EUDEVDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mozart)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = EUDEVDB)
)
)

#
# Production ESS Databases
#
UKPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = UKPROD)(PORT = 1520))
)
(CONNECT_DATA =
(SERVICE_NAME = PRODESS)
)
)

DEPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DEPROD)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = PROD)
)
)

FRPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = FRPROD.spicers.net)(PORT = 1524))
)
(CONNECT_DATA =
(SID = FRPROD)
)
)

ESPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ESPROD.SPICERS.NET)(PORT = 1525))
)
(CONNECT_DATA =
(SID = PRODESP)
)
)

ITPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ITPROD)(PORT = 1523))
)
(CONNECT_DATA =
(SERVICE_NAME = ITPROD)
)
)

#
# Test systems on Brahms/Liszt
#
#
TESTUKTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TESTUKPROD)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = UKTEST)
)
)

TESTUKPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TESTUKPROD)(PORT = 1520))
)
(CONNECT_DATA =
(SERVICE_NAME = PRODESS)
)
)

TESTUK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = brahms)(PORT = 1520))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST)
)
)

PRODUK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = brahms)(PORT = 1520))
)
(CONNECT_DATA =
(SERVICE_NAME = PRODESS)
)
)

TESTESPROD.SPICERS.NET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TESTESPROD)(PORT = 1525))
)
(CONNECT_DATA =
(SID = PRODESP)
)
)

TESTFRPROD.SPICERS.NET =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TESTFRPROD)(PORT = 1524))
)
(CONNECT_DATA =
(SID = FRPROD)
)
)

TESTDEPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TESTDEPROD)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = PROD)
)
)

TESTITPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TESTITPROD)(PORT = 1523))
)
(CONNECT_DATA =
(SERVICE_NAME = ITPROD)
)
)

# Mozart Development systems

ESFULL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mozart)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ESFULL)
)
)

ESTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mozart)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ESTEST)
)
)

ITTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MOZART.SPICERS.NET)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ITTEST)
)
)

ITFULL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MOZART.SPICERS.NET)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ITFULL)
(SERVER = DEDICATED)
)
)

UKTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mozart)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = UKTEST)
)
)

UKFULL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = MOZART.SPICERS.NET)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = UKFULL)
)
)

DEFULL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mozart)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DEFULL)
)
)

DETEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mozart)(PORT = 1521))
)
(CONNECT_DATA =
(SID = DETEST)
(SERVER = DEDICATED)
)
)

FRFULL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mozart)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = FRFULL)
)
)

FRTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mozart)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = FRTEST)
)
)

FRRECTST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = mozart)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = FRRECTST)
)
)

# Other

CMSPROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.84.105)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = CMSPROD)
)
)

# Dev LM7 UK
DEVLMUK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = devoradb)(PORT = 1521))
)
(CONNECT_DATA =
(SID = DEVLMUK)
(SERVER = DEDICATED)
)
)

# ProductionLM7 UK
LMUK =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = lmuk)(PORT = 1521))
)
(CONNECT_DATA =
(SID = LMUK)
(SERVER = DEDICATED)
)
)

# End

 

[Marco Kalter]

I'm not sure what could cause this. We'll look into it.

 

[cct]

I think I have a handle on this.

ISTR the behaviour used to be to check for recovery files whenever a new instance was created, but it now only seems to check when starting the first instance. As I always have thing running on my machine, I only do this after periodic reboots - often months apart.

I rebooted a few days ago, and got warned of two sessions to be recovered, both from last year, so I selected one. I then opened a new instance, but was not prompted again.

I have just had another freeze, so I killed the instance, and restarted another - no prompt.

Is the behaviour switchable?

Chris

 

[Laurent Feltz]

Hi Marco,

I have the same problem, the recovery mode doesn't work always. I hope that you can soon resolve this problem because we OFTEN use this "feature": we have to reboot regularly our machines (at least one time per week) and because I always have a lot of opened windows/packages, I just kill pl/sql dev and start it again after rebooting using the recovery mode (btw it could be a great new feature for pl/dev it we could manually save a state of the opened windows without using projects).

Regards,

Laurent

 

[Touster]

I also use this feature in PL/SQL developer -very often.

From not that long ago I'm using two additioanal monitors + laptop screen. One daythe recovery didn't work and I looked into c:\Users\%user%\AppData\Roaming\PLSQL Developer\PLS-Recovery.

There were two folders. One named Monitors-1600-1920-1920 and other Monitors-1600-1920. So I closed the laptop screen and recovery worked again. Hope this will help.

I also vote for manually saving state of opened windows. But without monitor+resolution folder naming for recovery.

 

[djohle]

I came to the forums today to post exactly what Laurent posted (post #52967). I very much want the ability to "recover" a clean exit just as much as an unexpected one. Much like the "restore previous session" ability found in many modern web browsers.

My entire team has been using this software for many many years, and I know I always have at least two instances running on my machine at any given moment. While some of my sql/command/etc. windows are saved to files & will be re-opened automatically, the majority of them are just for ad hoc queries. When it comes time to reboot (which is at least once every week or two...thanks Microsoft ) I have to remember to first kill each of my instances via task manager beforehand so that I can "recover" the state later. It's quite annoying to have to "work around" this issue before it happens.

I would expect that the "Autosave desktop" preference would handle this exact scenario, but it seems to only deal with a very limited set of conditions. Combined with the fact that closing the application implicitly calls close on every child window first, even giving leaves no way to restore them without giving each and every one a unique filename. This is a nuisance and creates clutter (esp. for short term / ad hoc queries), so it's easier to just kill the process. It works, but something about it just doesn't seem right.

 

[IvanZ]

You should try destop= functionality.
It is more reliable than crashing PLD.

 

[ariffe]

I would also like to have an "Autosave open SQL windows" feature.

I frequently have many Ad-hoc SQL windows open at the end of a work day. I don't want to save each one individually but would like to be able to close PL/SQL Developer and have them open again when I restart. Currently I just leave the app open and disconnect the session but when rebooting I don't have that option.

It is probably just me, but when I start PL/SQL developer connected to the LAN I get a different desktop/recovery than when I start from the WAN. Any idea what causes this?

 

[Jeff Kandt]

You should try destop= functionality.
It is more reliable than crashing PLD.

Can you explain what this functionality is? I searched the User's Guide for "desktop" and didn't see anything that seemed to match what you're describing. Is that a command-line parameter?

 

[IvanZ]

Yep, the documentation is lacking in this regard.
I use "desktop=desk nosplash nologon" command line params for several instances.
Use normally.
To shutdown I hit close button, tick "Do the same for all windows" -> No. Despite this confusing dialog everything is saved and next time you start PLD windows will pop up with the same content and order.
Some window types do not recover. Session, for ex.

 

[parmeisan]

I have experienced this periodically, and am fairly certain that it is because of the X session you created. PL/SQL Developer for some reason uses a different folder to read/write recovery sessions (and desktop= workspaces) when your monitor configuration has changed, e.g. when using a remote desktop or when sharing files on a network.

See this thread for some discussion & workarounds:https://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=54096

 

[Natalen]

thank you for information.