Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2016-01

TOracleConnector connect as SYSDBA

3 messages · 2 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Leonardo M. Ramé

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".

Regards,

Leonardo M. Ram? http://leonardorame.blogspot.com

Reply by email

Leonardo M. Ramé
to Leonardo M. Ramé

El 19/01/16 a las 15:55, Leonardo M. Ram? escribi?:

Show quoted text 12 lines
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.

Leonardo.

Reply by email

Mark Morgan Lloyd
to Leonardo M. Ramé
Leonardo M. Ram? wrote 16 lines
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]

Reply by email