Can we connect as sysasm by our exporter?

[kokoforworldpeace]

Hi, I want to know whether we can login database as 'sqlplus / as sysasm' by our exporter?

[wes-pro]

Hi I'm doing it in this way: DATA_SOURCE_NAME=asmsnmp:@<asm_listener_ip>:1525/+asm?as=sysdba'

You need to use address on which ASM listener is listening, not the SCAN or VIP

[dkovalua]

Hi

For sysasm connection you can try to use this string: DATA_SOURCE_NAME=user/user_pass@//db.hostname.domain:1521/+ASM?as=sysasm

It works fine for me

[daiguadaidai]

use sysdba, DATA_SOURCE_NAME add should be ?dba privilege=sysdba username: C##AABBCC export DATA_SOURCE_NAME="oracle://C%23%AABBCC:[email protected]:1521/orcl?dba privilege=sysdba"

use system, DATA_SOURCE_NAME add should be ?dba privilege=SYSOPER username: C##AABBCC export DATA_SOURCE_NAME="oracle://C%23%AABBCC:[email protected]:1521/orcl?dba privilege=SYSOPER"

definition: https://github.com/sijms/go-ora file: connetion_string.go

type DBAPrivilege int

const (
	NONE    DBAPrivilege = 0
	SYSDBA  DBAPrivilege = 0x20
	SYSOPER DBAPrivilege = 0x40
)

...

func DBAPrivilegeFromString(s string) DBAPrivilege {
	S := strings.ToUpper(s)
	if S == "SYSDBA" {
		return SYSDBA
	} else if S == "SYSOPER" {
		return SYSOPER
	} else {
		return NONE
	}
}