Oracle

Unable to load action group library when using Oracle database

02/10/2022April Daniels
Symptom  When opening Scheduler from Alarm Monitoring or System Administration, some of the following error messages are shown: “An error has occurred while loading actions” “An error has occurred while loading action type...

Event description from Event table is not published in reports; Oracle 12c

07/19/2021Content Creator
Symptom Events description column data from Event table is not published in the reports such as “Access Denials, Grants and Other Badge Events” report. Resolution Remove DYSYS package from Oracle 12. The DVSYS package is an additional...

Installing 32-bit Oracle 12c Client on Windows Server 2012 R2

07/26/2016April Daniels
Problem Overview Problem installing 32-bit Oracle 12c Client on Windows Server 2012 R2 Detailed Description The installation wizard cannot install 32-bit Oracle 12c Client on a Windows Server 2012 R2 workstation. To install the 32-bit Ora...

Oracle Database purge time

10/27/2013April Daniels
Symptom Oracle databases take a long time to purge records. Resolution This is due to the number of commits, but certain settings can be modified by an Oracle DBA.   Commit behavior: alter system set commit_logging='IMMED...

Can't start the Login Driver (or run any OnGuard application) when Oracle Express is the database

08/30/2011April Daniels
Symptom In a OnGuard system using Oracle Express as the database, the Login Driver will not run properly (and therefore OnGuard applications cannot be used). Resolution In the Oracle ODBC Driver Configuration, on the Applica...

Oracle Systems Need to be Set Up to Use Windows Authentication by Default

05/25/2010April Daniels
Problem Overview Oracle Systems Need to be Set Up to Use Windows Authentication by Default Detailed Description Oracle systems need to be set up to use Windows Authentication by default. After an upgrade, Windows authentication to the databa...

ORA-01013 errors in System Administration or during DataExchange script execution

12/15/2009April Daniels
Symptom You may encounter ORA-01013 errors in the following situations where Oracle is the database used by the OnGuard system: - When you add or edit hardware, cardholders, etc. in System Administration, and then click [OK] to save the c...

Multiple pre- or post-SQL execution actions fail in DataExchange with an Oracle database

10/24/2008April Daniels
Symptom In a system using an Oracle database, multiple pre-SQL execution actions or post-SQL execution actions may fail in DataExchange. Resolution To resolve this issue, follow the steps below. 1) Verify that each pre-SQL execution action ...

Basic Import Utility will not work with Oracle database

12/19/2007April Daniels
Symptom Import utility fails when run with Oracle "Unexpected application error occurred. Write these codes down, Error 3011 internal code 11196100. The Microsoft jet data base engine could not find the object 'badge'. Make sure th...

What is the TNSNAMES.ORA file?

10/22/2007April Daniels
Question What is the TNSNAMES.ORA file? Is there an example of this file for Oracle 10g that applies to OnGuard? Answer TNSNAMES.ORA is a SQL*Net configuration file that defines databases addresses for establishing connections to them. ...