PLSQL Developer 7.1 not logged on error

G

GPDotcomm

Member
I have attached the debug file details below. Can someone please review it and let me know what is wrong. The software was working fine till now, it stopped working today. I can login but after logging in I get the error message - "not logged on"

Debug text -
PL/SQL Developer
Version 7.1.4.1390
Windows Vista (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4,194,304 kB (3,408,080 available)
Paging file : 4,194,304 kB (4,194,304 available)
Virtual memory : 2,097,024 kB (1,966,668 available)

Parameters
C:\PLSQL Developer\PlSqlDev.exe
debugsql

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Preference Files

Plug-Ins

7/28/2016 3:58:14 PM Application started
7/28/2016 3:58:14 PM InitPreferences
7/28/2016 3:58:14 PM Load C:\PLSQL Developer\Preferences\Default = 0
7/28/2016 3:58:14 PM PreferenceSet.Load C:\PLSQL Developer\Preferences\Default\Default.ini
7/28/2016 3:58:14 PM PreferenceSet.Load OK
7/28/2016 3:58:14 PM Determine LocalPrefPath
7/28/2016 3:58:14 PM [1]: C:\PLSQL Developer\Preferences
7/28/2016 3:58:14 PM LocalPrefPath: C:\PLSQL Developer\Preferences\Gpatil
7/28/2016 3:58:14 PM Load C:\PLSQL Developer\Preferences\Gpatil = 0
7/28/2016 3:58:14 PM PreferenceSet.Load C:\PLSQL Developer\Preferences\Gpatil\default.ini
7/28/2016 3:58:14 PM PreferenceSet.Load OK
7/28/2016 3:58:14 PM PreferenceSet.Load C:\PLSQL Developer\Preferences\Gpatil\user.prefs
7/28/2016 3:58:14 PM PreferenceSet.Load OK
7/28/2016 3:58:14 PM InitPreferences end
7/28/2016 3:58:14 PM SortPreferenceSets
7/28/2016 3:58:14 PM - Default Gpatil
7/28/2016 3:58:14 PM - System Default
7/28/2016 3:58:14 PM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
7/28/2016 3:58:14 PM ReadString OK
7/28/2016 3:58:14 PM pfReadRegistry: "C:\PLSQL Developer\PlSqlDev.exe" "%1"
7/28/2016 3:58:14 PM LoadPreferences
7/28/2016 3:58:14 PM LoadPreferences searching for default
7/28/2016 3:58:14 PM C:\PLSQL Developer\Preferences\Gpatil\default.ini
7/28/2016 3:58:14 PM LoadPreferences NewPref := nil
7/28/2016 3:58:14 PM LoadPreferences
7/28/2016 3:58:14 PM LoadPreferences Reading preferences
7/28/2016 3:58:14 PM pfReadRegistry(PL/SQL Developer\Shell\Open\Command, )
7/28/2016 3:58:14 PM ReadString OK
7/28/2016 3:58:14 PM pfReadRegistry: "C:\PLSQL Developer\PlSqlDev.exe" "%1"
7/28/2016 3:58:14 PM LoadPreferences ReadPosition
7/28/2016 3:58:14 PM LoadPreferences ToolsBrowserItemClick(nil)
7/28/2016 3:58:14 PM LoadPreferences CreateBrowserFilters...
7/28/2016 3:58:14 PM LoadPreferences Files
7/28/2016 3:58:14 PM LoadPreferences Logon
7/28/2016 3:58:14 PM LoadPreferences Buttons
7/28/2016 3:58:14 PM LoadPreferences Printer
7/28/2016 3:58:14 PM LoadPreferences BrowserFolders
7/28/2016 3:58:14 PM LoadPreferences
7/28/2016 3:58:14 PM LoadPreferences end
7/28/2016 3:58:14 PM MacroLibFilename: C:\PLSQL Developer\Macro\Gpatil.emlib
7/28/2016 3:58:14 PM FormCreate Logon.Execute
7/28/2016 3:58:18 PM TOracleSession PLSQLDevForm.Session Start Session.LogOn as apps@DOTEBDEV
7/28/2016 3:58:19 PM TOracleQuery BytesPerCharacterQuery Start Query.Execute
SQL = select length(chr(2000000000)) l4, length(chr(2000000)) l3, length(chr(20000)) l2, 'c' c1 from dual
7/28/2016 3:58:19 PM TOracleQuery BytesPerCharacterQuery End
Result = ORA-01012: not logged on
Duration = 0.015
7/28/2016 3:58:19 PM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
7/28/2016 3:58:19 PM TOracleQuery Query End
Result = ORA-01012: not logged on
Duration = 0
7/28/2016 3:58:22 PM LogonHistorySave start
7/28/2016 3:58:22 PM ChangeUserPref LogonHistory,
7/28/2016 3:58:22 PM ChangeUserPref DSA,
7/28/2016 3:58:22 PM ChangeUserPref end
7/28/2016 3:58:22 PM ChangeUserPref ColumnAssociations,
7/28/2016 3:58:22 PM ChangeUserPref end
7/28/2016 3:58:22 PM ChangeUserPref ImportAssociations,
7/28/2016 3:58:22 PM ChangeUserPref end
7/28/2016 3:58:22 PM ChangeUserPref BrowserFilters,
7/28/2016 3:58:22 PM ChangeUserPref end
7/28/2016 3:58:22 PM ChangeUserPref BrowserFolders,
7/28/2016 3:58:22 PM ChangeUserPref end
7/28/2016 3:58:22 PM ChangeUserPref SessionQueries,
7/28/2016 3:58:22 PM ChangeUserPref end
7/28/2016 3:58:22 PM ChangeUserPref ExternalTools,
7/28/2016 3:58:22 PM ChangeUserPref end
7/28/2016 3:58:22 PM ChangeUserPref Documents,
7/28/2016 3:58:22 PM ChangeUserPref end
7/28/2016 3:58:22 PM ChangeUserPref Reports,
7/28/2016 3:58:22 PM ChangeUserPref end
7/28/2016 3:58:22 PM LogonHistorySave end
7/28/2016 3:58:22 PM FormCreate Session.Connected
7/28/2016 3:58:22 PM FormCreate Logon.Executed -1
7/28/2016 3:58:22 PM FormCreate TDBNames.Make
7/28/2016 3:58:22 PM FormCreate SessionChanged
7/28/2016 3:58:22 PM TOracleQuery Query Start Query.Execute
SQL = select * from v$version
7/28/2016 3:58:22 PM TOracleQuery Query End
Result = ORA-01012: not logged on
Duration = 0.016
7/28/2016 3:58:22 PM SessionChanged SetDBAViews
7/28/2016 3:58:22 PM TOracleQuery $05031090 Start Query.Execute
SQL = select null from all_synonyms where 1=0
7/28/2016 3:58:22 PM TOracleQuery $05031090 End
Result = ORA-01012: not logged on
Duration = 0
7/28/2016 3:58:22 PM TOracleQuery $05031090 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
7/28/2016 3:58:22 PM TOracleQuery $05031090 End
Result = ORA-01012: not logged on
Duration = 0
7/28/2016 3:58:22 PM SessionChanged Authorizations.Load
7/28/2016 3:58:22 PM TOracleQuery $05030F30 Start Query.Execute
SQL = select grantee, name from
sys.plsqldev_authorization
where grantee in (user, 'PUBLIC')
or grantee in (select role from sys.session_roles)
7/28/2016 3:58:22 PM TOracleQuery $05030F30 End
Result = ORA-01012: not logged on
Duration = 0
7/28/2016 3:58:22 PM SessionChanged EnableAuthorizedMenus
7/28/2016 3:58:22 PM TOracleSession $02C5BFD0 Start Session.LogOn as apps@DOTEBDEV
7/28/2016 3:58:23 PM TOracleQuery Query Start Query.Execute
SQL = select to_char(userenv('SESSIONID')) from dual
7/28/2016 3:58:23 PM TOracleQuery Query End
Result = ORA-01012: not logged on
Duration = 0.016
7/28/2016 3:58:23 PM SetSessionAction starts: Main session
7/28/2016 3:58:23 PM TOracleQuery $05031090 Start Query.Execute
SQL = select null from dual
7/28/2016 3:58:23 PM TOracleQuery $050311F0 Start Query.Execute
SQL = select object_name, object_type
from sys.user_objects o
where o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
7/28/2016 3:58:23 PM TOracleQuery $05031090 End
Result = ORA-01012: not logged on
Duration = 0.016
7/28/2016 3:58:23 PM TOracleQuery $05031090 Start Query.Execute
SQL = begin sys.dbms_application_info.set_module('PL/SQL Developer', :action); end;
:ACTION = Main session
7/28/2016 3:58:23 PM TOracleQuery $050311F0 End
Result = ORA-01012: not logged on
Duration = 0.031
7/28/2016 3:58:23 PM TOracleQuery $050311F0 Start Query.Execute
SQL = select s.synonym_name object_name, o.object_type
from sys.all_synonyms s,
sys.all_objects o
where s.owner in ('PUBLIC', user)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')
7/28/2016 3:58:23 PM TOracleQuery $05031090 End
Result = ORA-01012: not logged on
Duration = 0.015
7/28/2016 3:58:23 PM SetSessionAction ends
7/28/2016 3:58:23 PM ExecuteConnectScript starts
7/28/2016 3:58:23 PM ExecuteConnectScript ends
7/28/2016 3:58:23 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from v$nls_parameters where parameter = 'NLS_LENGTH_SEMANTICS'
7/28/2016 3:58:23 PM TOracleQuery $050311F0 End
Result = ORA-01012: not logged on
Duration = 0
7/28/2016 3:58:23 PM TOracleSession $02C5BFD0 Start Session.LogOff
7/28/2016 3:58:23 PM TOracleQuery PLSQLDevForm.DynamicQuery End
Result = ORA-01012: not logged on
Duration = 0
7/28/2016 3:58:23 PM SessionChanged LoadRecentObjects
7/28/2016 3:58:23 PM SessionChanged Notify children
7/28/2016 3:58:23 PM SessionChanged Logoff secondary sessions
7/28/2016 3:58:23 PM SessionChanged SessionMode = smMulti
7/28/2016 3:58:23 PM SessionChanged EnableChildFunctions
7/28/2016 3:58:23 PM SessionChanged
OracleHomeKey: SOFTWARE\ORACLE\KEY_oracleas1
OracleHomeDir: C:\OraHome_1
Found: oci.dll
Using: C:\OraHome_1\bin\oci.dll
7/28/2016 3:58:23 PM TOracleQuery PLSQLDevForm.DynamicQuery Start Query.Execute
SQL = select value from sys.nls_database_parameters where parameter = 'NLS_CHARACTERSET'
7/28/2016 3:58:23 PM TOracleQuery PLSQLDevForm.DynamicQuery End
Result = ORA-01012: not logged on
Duration = 0
7/28/2016 3:58:23 PM SortPreferenceSets
7/28/2016 3:58:23 PM - Default Gpatil
7/28/2016 3:58:23 PM - System Default
7/28/2016 3:58:23 PM TOracleQuery $05030DD0 Start Query.Execute
SQL = select null from all_synonyms where 1=0
7/28/2016 3:58:23 PM TOracleQuery $05030DD0 End
Result = ORA-01012: not logged on
Duration = 0
7/28/2016 3:58:23 PM TOracleQuery $05030DD0 Start Query.Execute
SQL = select null from dba_synonyms where 1=0
7/28/2016 3:58:23 PM TOracleQuery $05030DD0 End
Result = ORA-01012: not logged on
Duration = 0
7/28/2016 3:58:23 PM WMUpdatePopups starts
7/28/2016 3:58:23 PM GetCrashList: 328680.cfg
7/28/2016 3:58:23 PM GetCrashList: 788398.cfg
7/28/2016 3:58:23 PM GetCrashList: 328680.cfg
7/28/2016 3:58:23 PM GetCrashList: 788398.cfg
7/28/2016 3:58:25 PM LoadDesktop starts
7/28/2016 3:58:25 PM LoadDesktop ends
7/28/2016 3:58:25 PM WMUpdatePopups ends
7/28/2016 3:58:28 PM Create TSQLForm Start
7/28/2016 3:58:28 PM Create TSQLForm Inherited
7/28/2016 3:58:28 PM TSQLForm.FormCreate Start
7/28/2016 3:58:28 PM SQLForm
7/28/2016 3:58:28 PM TSQLForm.FormCreate Finished
7/28/2016 3:58:28 PM Create TSQLForm SetupMainFont
7/28/2016 3:58:28 PM Create TSQLForm Activate
7/28/2016 3:58:28 PM Create TSQLForm Activate done
7/28/2016 3:58:28 PM Create TSQLForm UpdateWindowList
7/28/2016 3:58:28 PM Create TSQLForm Positioning
7/28/2016 3:58:28 PM Create TSQLForm Finished
7/28/2016 3:58:28 PM NavigationBookmarks.EnableButtons(Rebuild)
7/28/2016 3:58:28 PM NavigationBookmarks: Backward=0, Forward=0
7/28/2016 3:58:32 PM SQLForm Initializing...
7/28/2016 3:58:32 PM SetConnected starts
7/28/2016 3:58:32 PM SetConnected: Connect starts
7/28/2016 3:58:32 PM TOracleSession $02C5F990 Start Session.LogOn as apps@DOTEBDEV

 
Last edited:
This is probably a problem with the database server. Can you connect to the database in SQL*Plus and execute a query? If this also leads to ORA-01012, then you may need to restart the database instance and/or check the server log files for a related problem.
 
You must log in or register to reply here.

Similar threads

C
  • Discussion Discussion
PL/SQL Developer 15 slow to open
Replies
4
Views
3K
TomOzi
T
R
  • Discussion Discussion
Very slow closing all windows
Replies
8
Views
7K
Marco Kalter
Marco Kalter
S
  • Discussion Discussion
PLSQL Developer 13 - Window List issue
Replies
2
Views
2K
Sztefi
S
J
  • Discussion Discussion
ORA-03114 Import PDE
Replies
2
Views
2K
Marco Kalter
Marco Kalter
B
  • Discussion Discussion
Pl/Sql Developer closed with External Exception Error C0000006
Replies
1
Views
7K
Marco Kalter
Marco Kalter
Back
Top