ORA-28009: connection to sys should be as sysdba or sysoper
Answers were Sorted based on User's Feedback
Answer / ehsan ullah
first connect with System/Password
then write down the following statement
conn as sysdba [Enter]
Enter user-name: sys [Enter]
Enter password: password
it will confirm work
| Is This Answer Correct ? | 10 Yes | 4 No |
Answer / guest
Cause: connect sys/<password> is no longer a valid syntax
Action: Try connect sys/<password> as sysdba or connect
sys/<password> as sysoper
Please add more information about this Error
| Is This Answer Correct ? | 3 Yes | 3 No |
ORA-02031: no ROWID for fixed tables or for external-organized tables
ORA-13835: invalid attribute name specified
ORA-32603: invalid FREEPOOLS LOB storage option value
ORA-30082: datetime/interval column to be modified must be empty to decrease fractional second or leading field precision
QSM-01060: illegal subquery in the HAVING clause
ORA-27060: could not set close-on-exec bit on file
ORA-16607: one or more databases have failed
ORA-38482: no elementary attributes defined in the attribute set
IMG-00606: unable to access image data
ORA-14256: invalid resulting partition description(s)
ORA-32332: cannot refresh materialized view "string"."string" as type evolution has occured
ORA-31191: Resource string is already checked out