Importing logs into an Oracle Database

[BarryStiefel]

Importing logs into an Oracle Database



Published in oldfaq 2002-Dec-28 00:48 dwelchATphoneboyDOTcom

Jim Edwards wrote a set of scripts for switching the logs, ftping them to another box and loading them into an Oracle database.

• db_load.tar: Database Load (tarball)
• DB_LOAD.ZIP: Database Load (zipfile)

-- RayLodato - 15 Jan 2004

FAQForm FAQs.Class: LoggingAndAlertingFAQs FAQs.OS: FAQs.Version:

[kjk66]

Hi all,

does anyone have these two scripts available ?
I would take a look but the download links are broken.

thanks in advance

kjk


PS: If anyone can help to import the log-data into an Oracle DB I would appreciate for any hints ...

[dsb.nepo]

In newer versions you can export the logs direct into oracle.
Take a look into the CheckPoint_R6x_CLI_UserGuide.pdf and search for log_export or oracle.
I cannot confirm if this is working since I never done this.

does anyone have these two scripts available ?
I would take a look but the download links are broken.

I will send you a PM with an url to this files.

[kjk66]

No, it doesn't work with the log_export-utility.

At first it crashs with an error when it wants to register a .dll with a wrong name. Seems to be the first bug inside the compiled code of the util.
After manual register the correct .dll it wrote a few lines into the database but then it crashes with the following error:


COracleDBInsertOperation::Insert: Error >> OCIStmtSetPieceInfo failed:
ORA-24307: invalid length for piece
CLogExportManager::PutLogInTheDatabase: Error >> ILogExport_DBInsertOperation::Insert failed.
CLogExportManager::LogRecordFetchedCB: Error >> PutLogInTheDatabase failed.
An error occured in the record handler, ending session

In fact, although this tool is from the newest release of SVN-Foundation it doesn't work either with 10g nor 8i Oracle client/database.
Seems to be that CP doesn't like the idea that their customers push the log-data into an independed database ;o)

Maybe, if we have the time to go for it we are trying to develop a small LEA-application for ourself to get the needed log-information.

thanks for answers and help so far ...

greets

kjk