I have a Delphi application that connects to an oracle database.
When I try to log in as SYSDBA, I get the error:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
When I try to log in with a user of "SYS AS SYSDBA", I get the error:
ORA-01017: invalid username/password; logon denied
How can I log in as sysdba using a dbExpress connection?
Specify the user as "Joseph as SYSDBA" instead of Joseph
I found a checklist but not sure whether it is useful or not. Just have a look.
I found nothing specific for special dbexpress driver. But try to add a connection parameter DBA privilege with the value SYSDBA.
Connection.Params.Append('DBA Privilege=SYSDBA');
I have no delphi installed to check the concrete syntax of the parameter name. Please try using an underscore instead of the blank.
This page shows several connection strings used in certain tools to connect to oracle database.