0

I have been following this tutorial to setup an Oracle DBFS environment for testing.

A certain step of the tutorial is pointing to the use of the DBFS_CLIENT:

DBFS_CLIENT

When I try to authenticate on the dbfs_client using the "sys" credentials, it returns an error: The connection as SYS must have SYSDBA or SYSOPER privileges.

DBFS_CLIENT_ERROR

I understand that the privilege is granted by simply adjusting the "sys" credentials I wrote on the command line.

What am I doing wrong there? How can I solve this issue?

  • "What am I doing wrong there?" -- connecting as sys. Don't start a bad habit. – mustaccio Feb 14 at 19:29
  • I just want to test DBFS to see how it works locally on my machine. I mean no harm – Gabriel Robaina Feb 14 at 19:40
  • Create a separate Oracle user for that then. – mustaccio Feb 14 at 19:43
  • Shouldnt I be able to log in with sys? – Gabriel Robaina Feb 14 at 19:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.