Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Kiwi Syslog, Log to Oracle error

Posted on 2013-11-02
7
Medium Priority
?
609 Views
Last Modified: 2013-11-06
I'm running latest Kiwi Syslog version on Windows 2008 R2. I want Kiwi Syslog to Log to Oracle 12c which is running on the same server. The DSN is set and works. When I try to set Kiwi Syslog to Log to Oracle I select the DSN, type the user and password and get an unspecified error.
0
Comment
Question by:strivoli
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39621372
What are the Bit versions involved?

There are two ODBC admin programs on a 64Bit system:
http://support.microsoft.com/kb/942976

you also need the correct Bit version of the Oracle ODBC driver.
0
 
LVL 20

Author Comment

by:strivoli
ID: 39621523
Oracle Net Manager is version 12.1.0.0.2.
Oracle ODBC Driver is version 12.01.00.01.
Both became available as part of the 12c setup.

The Oracle ODBC Driver is available ONLY on the x64 ODBC Admin. The x86 ODBC Admin doesn't list the Oracle ODBC Driver. I've created a User DSN and it works (the connection test returns OK). When I set Kiwi Syslog to use this DSN I get the error.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39621531
Is Kiwi Syslog 32Bit or 64Bit software?
0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 20

Author Comment

by:strivoli
ID: 39621571
Both Service and Manager are 32bit.
I know what you are going to tell me, but, where do I get Oracle 12c x86 (32bit) ODBC Drivers? Perhaps you know Oracle's site better than me.
Thank you for taking the time. Let me know.
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 39621586
I would go with the Instant Client:
http://www.oracle.com/technetwork/topics/winsoft-085727.html


You will need two downloads:
Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications
*Instant Client Package - ODBC: Additional libraries for enabling ODBC applications

The ODBC add-on should have an install program or BAT file.  There should be a readme file that explains how to install it.
0
 
LVL 20

Author Comment

by:strivoli
ID: 39626934
I couldn't set successfully the Instant Client (32 bit) on the same server hosting Oracle 64 bit. There must be some kind of coexistence issue when both Oracle components (32 and 64 bit) are on the same box... but that is another issue I must investigate upon.

In order to make sure Kiwi is able to Log to Oracle 12c and close this question, I installed the Oracle 32 bit client on a fresh box (a 7 x64 with no Oracle installed). I set the connection using Oracle's Net Manager (test OK), set the ODBC using the TSN created (test OK), set Kiwi to Log to Oracle (test OK!).

The result is: Kiwi can Log to Oracle as long as you have a working 32 bit ODBC driver.

Thank you for your help.
0
 
LVL 20

Author Closing Comment

by:strivoli
ID: 39626937
My last post explains in detail.
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
PRTG Network Monitor lets you monitor your bandwidth usage, so you know who is using up your bandwidth, and what they're using it for.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question