[Lazarus] TOracleConnector connect as SYSDBA

[Mark Morgan Lloyd]

Leonardo M. Ramé wrote:
> El 19/01/16 a las 15:55, Leonardo M. Ramé escribió:
>> Hi, does anyone know how to connect to Oracle as SYSDBA?, I'm getting
>> "ORA-01017: invalid username/password; logon denied" when I set these
>> params:
>>
>> Hostname: 127.0.0.1
>> Database: MYDB
>> User: sys as SYSDBA
>> Pass: MYPASSWORD
>> Role: SYSDBA (this field is not taken into account -apparently-)
>>
>> If, instead of using "sys as SYSDBA" I use "sys" alone, I get
>> "ORA-28009: connection as SYS should be as SYSDBA or SYSOPER".
> 
> I've found a solution, instead of using "sys as SYSDBA" I used the 
> username "system", and leave Role empty.

Thanks for updating us. I'd imagine that quite a few people are in the 
position of not using Oracle routinely but being interested in looking 
at evaluation copies etc.

I wonder whether some form of quoting would have made your origianl 
attempt work.

-- 
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]