-
Title
ORA-28009 error during login as SYS and ORA-01031 error during Clone / Copy of user. -
Description
1) During login to SYS user as SYSDBA (especially if logging in for the 3rd time or if no one has not logged in to a particular user in a while), ‘sometimes’ the user will get the “ORA-28009: connection as SYS should be as SYSDBA or SYSOPER” error.
2) Schema Browser | Users | right-click a user | Clone / Copy | it will work, but doing the exact same steps again will ‘sometimes’ get the “ORA-01031: insufficient privileges” error. If the user clicks on YES in the error box to see more details, it states “Error – No Connection”.
-
Resolution
RESOLUTION 1:
Ensure user has or is part of the ORA_DBA group.
RESOLUTION 2:
Doing BOTH the two items below may resolved the issue.
1) Copy the ‘full’ tnsnames.ora file (the file with ALL the TNS entries in it; not just a network path to the location of the tnsnames.ora file) in your default "…Network\Admin" folder for your Oracle Home Client.
Note: IFILE is not supported by Toad.
2) Go to Toad Options | Oracle | Transactions | check mark “Execute queries in threads …” | restart Toad.