netrusov / ZabbixDBA

Zabbix Database Monitoring Service (Oracle, Pg, MySQL, MS SQL, DB2, etc.)
MIT License
97 stars 55 forks source link

ORA-01017: invalid username/password #83

Closed lpossamai closed 6 years ago

lpossamai commented 6 years ago

Hi there.

I've installed ZabbixDBA on my Oracle test DB. When connecting to the DB via SQL Developer, it works. When running ZabbixDBA I get the following error:

[root@db2 zdba]# perl zdba.pl conf/config.pl 
Thread 1 terminated abnormally: failed to connect to 'DBI:Oracle:host=localhost;port=1521;sid=dbdev':\nORA-01017: invalid username/password; logon denied (DBD ERROR: OCISessionBegin) at /opt/zdba/lib/ZDBA/DBIx.pm line 43 thread 1.
    ZDBA::DBIx::connect(ZDBA::DBIx=HASH(0x385a698)) called at /opt/zdba/lib/ZDBA/DBIx.pm line 68 thread 1
    ZDBA::DBIx::BUILD(ZDBA::DBIx=HASH(0x385a698), HASH(0x34ba6e0)) called at (eval 101) line 79 thread 1
    ZDBA::DBIx::new("ZDBA::DBIx", HASH(0x36ff638)) called at /opt/zdba/lib/ZDBA.pm line 178 thread 1
    ZDBA::_build_dbi(ZDBA=HASH(0x36e33d8)) called at (eval 83) line 20 thread 1
    ZDBA::dbi(ZDBA=HASH(0x36e33d8)) called at /opt/zdba/lib/ZDBA.pm line 74 thread 1
    ZDBA::monitor(ZDBA=HASH(0x36e33d8), "dbdev") called at zdba.pl line 58 thread 1
    main::__ANON__() called at /root/perl5/perlbrew/perls/perl-5.26.0/lib/site_perl/5.26.0/x86_64-linux/forks.pm line 799 thread 1
    eval {...} called at /root/perl5/perlbrew/perls/perl-5.26.0/lib/site_perl/5.26.0/x86_64-linux/forks.pm line 799 thread 1
    threads::new("threads", CODE(0x36917f8)) called at zdba.pl line 59 thread 1

Oracle 11G. Red Hat 6.8. Selinux is disabled.

The SID looks right to me, and as I said before, I can connect via SQL Developer. Any ideas? Cheers!

lpossamai commented 6 years ago

Sorry, this was my mistake. I ended up putting the wrong password in the config.pl file.