Error: "ORA-28009: connection as SYS should be as SYSDBA or SYSOPER"
说明
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.
原因
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.
解决办法
WORKAROUND
None
RESOLUTION
Issue 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.
变更请求
BFER6461
其他信息
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.