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

PLS-00123: program too large

1 Answers  


ORA-00702: bootstrap verison 'string' inconsistent with version 'string'

1 Answers  


RMAN-06140: cannot specify TAG option with LIST INCARNATION

1 Answers  


ORA-07283: sksaprd: invalid volume size for archive destination.

1 Answers  


ORA-01253: cannot start online backup - file string in recovery manager backup

1 Answers  






ORA-14618: cannot drop the last value of subpartition

1 Answers  


PLS-00661: RETURN statement in a CONSTRUCTOR cannot include an expression

1 Answers  


IMP-00003: ORACLE error number encountered

1 Answers  


RMAN-03999: Oracle error occurred while while converting a date: ORA-number: string

1 Answers  


TNS-02515: Encryption/crypto-checksumming: unknown control type

1 Answers  


RMAN-06118: a backup controlfile older than SCN string must be used for this recovery

1 Answers  


QSM-02019: mv references another mv in FROM clause

1 Answers  


Categories