Retour
-
Titre
Error: "ORA-28009: connection as SYS should be as SYSDBA or SYSOPER" -
Description
Error: "ORA-28009: connection as SYS should be as SYSDBA or SYSOPER" when attempting to use the sys account as the functional account of a Oracle system. -
Cause
ORA-28009 oracle error is raised when the sys user tries to connect without providing "as sysdba" . This is controlled by the O7_DICTIONARY_ACCESSIBILITY parameter. When this parameter value is set to FALSE, sys users experience this ORA-28009 error. Access to dictionary objects is restricted to the users with the system privileges SYSDBA and SYSOPER. Connecting as SYSDBA gives a user unrestricted privileges to perform any operation on a database or the objects within a database. Data dictionary objects is under SYS schema and is protected by O7_DICTIONARY_ACCESSIBILITY to FALSE settings. -
Résolution
WORKAROUND
None
RESOLUTIONIssue fixed in version 2.5.912. The latest version of TPAM can be downloaded from here
BFER 6461 Now allow functional account of “sys” to be used for Oracle. -
Demande de changement
BFER6461 -
Informations supplémentaires
Note that the ability to connect to Oracle using the SYS account via PSM -- BFER 6541 ("PSM session using SYS account not working for Oracle platforms.") was added in TPAM 2.5.921.