Skip to content
This repository has been archived by the owner on Jan 15, 2019. It is now read-only.

[dev.icinga.com #1291] database port for oracle not honoured in ido2db.cfg #580

Closed
icinga-migration opened this issue Mar 16, 2011 · 4 comments

Comments

@icinga-migration
Copy link

This issue has been migrated from Redmine: https://dev.icinga.com/issues/1291

Created by pdeneu on 2011-03-16 14:40:18 +00:00

Assignee: (none)
Status: Closed (closed on 2011-05-19 08:51:33 +00:00)
Target Version: (none)
Last Update: 2014-12-08 14:46:16 +00:00 (in Redmine)

Icinga Version: 1.10.0
OS Version: any

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


Relations:

@icinga-migration
Copy link
Author

Updated by mfriedrich on 2011-03-16 14:46:30 +00:00

  • 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

@icinga-migration
Copy link
Author

Updated by Tommi on 2011-03-20 08:22:43 +00:00

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

@icinga-migration
Copy link
Author

Updated by mfriedrich on 2011-05-19 08:51:33 +00:00

  • 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.

@icinga-migration
Copy link
Author

Updated by mfriedrich on 2014-12-08 14:46:16 +00:00

  • Project changed from 18 to Core, Classic UI, IDOUtils
  • Category set to IDOUtils
  • Icinga Version set to 1
  • OS Version set to any

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant