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-00651: implementation type in Aggregate/Table function should be a valid type

1 Answers  


NNL-00234: Auto-refresh failure-retry expiration period is currently string

1 Answers  


PCC-01102: Invalid label at line number in file string

1 Answers  


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

1 Answers  


ORA-38429: invalid datatype for a stored attribute: string

1 Answers  






EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help

1 Answers  


NNL-00412: Number of requests: number

1 Answers  


RMAN-06572: database is open and datafile number is not offline

1 Answers  


display details of employee's who are seniour to there own manager ? ( In a Emp Table )

2 Answers  


RMAN-04021: target database DBID string does not match channel's DBID string

1 Answers  


ORA-32505: too many watchpoints

1 Answers  


ORA-06904: CMX: no transport address available for remote application

1 Answers  


Categories