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]
--
_______________________________________________
Lazarus mailing list
Lazarus@lists.lazarus.freepascal.org
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
