Bug #1291

database port for oracle not honoured in ido2db.cfg

Added by pdeneu about 3 years ago. Updated almost 3 years ago.

Status:ClosedStart date:03/16/2011
Priority:LowDue date:
Assignee:-% Done:

0%

Category:-
Target version:-
Icinga Version: DB Type:
IDO Version: DB Version:

Description

Hey,

same bug like this for postgresql (https://dev.icinga.org/issues/825) is actual in 1.3 for oracle.
After creating a iptables nat policies from port 1521 to port 1522 in my configuration the ido process wrote my data to the database.

Environment is rhel6 x64 with ocilib-3.8.1 and oracle 11.x on remote site.

kind regards,
philipp


Related issues

Related to IDOUtils - Bug #1283: update oracle hints in ido2db.cfg with tnsnames.ora and p... Resolved 03/11/2011

History

#1 Updated by dnsmichi about 3 years ago

  • Status changed from New to Feedback
  • Priority changed from High to Low

you have to define that in your tnsnames.ora since the port is not passed to ocilib. if you find an option in ocilib to assign that to the connection establishment through oracle libs, let me know.

see #1283

#2 Updated by Tommi about 3 years ago

you might consider use of Oracle EZConnect-Syntax for db_name, which allows to set different port ([//][host][:port][/service_name] see http://www.orafaq.com/wiki/EZCONNECT ). You need to add ezconnect adapter to your sqlnet.ora (NAMES.DIRECTORY_PATH=(ezconnect, tnsnames) for enabling this

#3 Updated by dnsmichi almost 3 years ago

  • Status changed from Feedback to Closed

hints have been added to ido2db.cfg and tnsnames.ora is also mentioned on the docs. should be sufficient for future configurations.

Also available in: Atom PDF