Created On:  29 November 2010

Problem:

Why am I receiving “ORA-28009: connection as SYS should be as SYSDBA or SYSOPER” error message in the dbcreate.log?

2010 Teaminspector Database Schema creation starts...

Mon May 24 15:09:48 BST 2010 Attempting to connect to database as user 'sys'
Mon May 24 15:09:49 BST 2010 Connect as user 'sys' failed.
Mon May 24 15:09:49 BST 2010 Error: Failure connecting to database jdbc:oracle:thin:@XXXXXX:9999/ORCL
Mon May 24 15:09:49 BST 2010 java.sql.SQLException: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
....
 
Mon May 24 15:09:49 BST 2010 End of TeamInspector Schema creation

Resolution:

To resolve this issue use the SYSDBA or SYSOPER user credentials.  As shown below: