Oracle

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 types” “Unable to load Act...

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

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 database va...

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 Application tab, ...

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='IMMEDIATE' sco...

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

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

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

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

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 that the object...