ORA-28009: connection to sys should be as sysdba or sysoper

Answers were Sorted based on User's Feedback



ORA-28009: connection to sys should be as sysdba or sysoper..

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

ORA-28009: connection to sys should be as sysdba or sysoper..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-22164: delete element operation is not allowed for variable-length array

1 Answers  


ORA-01147: SYSTEM tablespace file string is offline

1 Answers  


ORA-30019: Illegal rollback Segment operation in Automatic Undo mode

1 Answers  


ORA-03293: Cluster to be truncated is a HASH CLUSTER

1 Answers  


ORA-08343: srclose: failed to close a redo server connection

1 Answers  






DRG-11837: Reauthorization Required

1 Answers  


PROC-00010: Cannot delete the cluster registry key as subkeys exist.

1 Answers  


ORA-37078: (XSMCSESS06) The dimension being maintained (workspace object) cannot also be used as a step dimension.

1 Answers  


KUP-04075: no read access to directory object string

1 Answers  


LPX-00604: Invalid attribute value '~1S', for attribute '~2s'.

1 Answers  


ORA-22317: typecode number is not legal as a number type

1 Answers  


ORA-07489: scgrcl: cannot get lock status.

1 Answers  


Categories