Novell Home

Trouble Running Inventory Reports

Novell Cool Solutions: Tip
By David Frey

Digg This - Slashdot This

Posted: 14 Oct 2004
 

Also contributing: Karen Keller & Michelle Basiliere of Southwest Gas Corporation, Las Vegas

Problem

ZfD 4.0.1 IR4
ConsoleOne 1.3.6, 1.3.5
Oracle 8.1.7

When attempting to run ZENworks reports, the following error message appears: "Unable to log into the database. Ensure that the ODBC driver is installed properly."

The ZENworks inventory database is running on Oracle 8.1.7. The ODBC driver is installed correctly along with the Oracle 8.1.7 client on the PC.

Cause

A single TNSNAMES.ORA file for the enterprise is located on a shared network drive and is flagged read-only. The C1 reporting plug-in attempts to update a local copy of the file (ORACLE_HOME path) to add the zenworks_reports SID and does not "see" the shared network copy.

Solution

Manually add the ZENworks_reports SID to the TNSNAMES.ORA file:

zenworks_reports.world = (DESCRIPTION=ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) 
(HOST=<x.x.x.x>)(PORT=1537))) (CONNECT_DATA=SID=<databaseSID>)))

Modify HOST=<x.x.x.x> with IP address of host
Modify SID=<databaseSID> with inv database SID

Email questions/comments to: dfreyREMOVETHIS@genesys-computer.com after removing the words REMOVETHIS from the email address.


Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions. www.webwiseone.com

© 2014 Novell