oracle-db-appdev-monitoring icon indicating copy to clipboard operation
oracle-db-appdev-monitoring copied to clipboard

Published 20 hours ago • verified publisher icon oracle

Connect as SYSDBA user

Open savoir81 opened this issue 10 months ago • 1 comments

Hi,

Is there a possibility to connect as sysdba user? Option sysdba=true

As described in https://pkg.go.dev/github.com/godror/godror

savoir81 avatar Apr 16 '24 12:04 savoir81

Thanks for your suggestion, I will take a look at it and get back to you.

markxnelson avatar Apr 16 '24 19:04 markxnelson

Hi, I am adding a new DB_ROLE environment variable that you may set to either SYSDBA or SYSOPER, and the exporter will connect with the requested role. This is an optional env var, and it can be ignored if you don't need any role.

This will be available in release 1.3.0, should be in the next day or two.

Thanks again for yoru suggestion.

markxnelson avatar Jun 06 '24 17:06 markxnelson

@markxnelson was just thinking maybe it shouldn't be an env var and should be a config/connection param... I believe this is what godror does/takes anyway and then it's also less global and more dynamic/runtime.

paulparkinson avatar Jun 06 '24 19:06 paulparkinson

fixed in https://github.com/oracle/oracle-db-appdev-monitoring/releases/tag/1.3.0

markxnelson avatar Jun 06 '24 20:06 markxnelson