Automatic database cleanup of asset history

… Why is my asset history cleaned up without further notice? The Cleanup Database (automatic) server action has the task to clean up older events, messages, and a …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/operation/monitor-database-performamce/automatic-database-cleanup-of-asset-history

Oracle database performance checks (Admin Client)

… The censhare Admin Client offers a built-in performance analysis tools for the connected Oracle database. Context The check is located in censhare-Server/app/mo …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/operation/monitor-database-performamce/oracle-database-performance-checks-admin-client

Oracle database performance checks

… A collections of commands to check your Oracle database performance. Prerequisites ssh access to the database server as user oracle (optional) Internet connecti<<<<<<<<<<<<<<<<<<<< …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/operation/monitor-database-performamce/oracle-database-performance-checks

Database

… Describe what users learn in this article and when they need this. icon related-topics Optionally, assign a Font Awesome icon to the page. Enter the class attri …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/install-and-upgrade/installation/database

Install Oracle and PostgreSQL databases

… The whitepaper describes which parameters to set so that customers and partners can install Oracle, PostgreSQL, and AWS-RDS PostgreSQL databases on their own. P …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/install-and-upgrade/installation/database/install-oracle-and-postgresql-databases

Oracle database installation

… General recommendations Please follow these general recommendations for every Oracle Database installation Parameter NLS_CHARACTERSET must be AL32UTF8. The appl< $ORACLE_HOME/network/admin/tnsnames.ora Back up the configuration copy the lates backup_rman.sh script from GIT and create this cron job 0 21 * * * /home/oracle/bin/backup_rman.sh > …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/install-and-upgrade/installation/database/oracle-database-installation

Extended data types for Oracle 18

… Set up a fresh Oracle 18 database. The steps described here are required to work with the censhare Server, independently from the Oracle database installation t< $(pwd)/css/database/create-db.sql Adapt the connection URL Adapt the main database configuration file on the censhare Server in ~/cscs/app/services/database/config.$CSS_ID.xml. CSS_ID is the name of the database, for example config.master.xml. In the configuration in the < $(pwd)/css/database/create-db.sql Adapt the connection URL Adapt the main database configuration file on the censhare Server in ~/cscs/app/services/database/config.$CSS_ID.xml. CSS_ID is the name of the database, for example config.master.xml. In the configuration in the < $(pwd)/css/database/create-db.sql Adapt the connection URL Adapt the main database configuration file on the censhare Server in ~/cscs/app/services/database/config.$CSS_ID.xml. CSS_ID is the name of the database, for example config.master.xml. In the configuration in the < $(pwd)/css/database/create-db.sql Adapt the connection URL Adapt the main database configuration file on the censhare Server in ~/cscs/app/services/database/config.$CSS_ID.xml. CSS_ID is the name of the database, for example config.master.xml. In the configuration in the …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/install-and-upgrade/installation/database/extended-data-types-for-oracle-18

Oracle Extended Data Types - SysAdmin

… Extended Data Types is a feature as of Oracle 12c. It allows to increase the maximum size of VARCHAR2, NVARCHAR2, and RAW columns in a table. Prerequisites Orac …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/setup/database-setup/oracle-extended-data-types

Export Oracle database_SysAdmin

… Execution time: 5 minutes + export wait time = 10-40 minutes for a standard censhare database. Prerequisites ssh access to the database server as user in Oracle< …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/setup/database-setup/export-oracle-database

Oracle compression licensing - SysAdmin

… As an Enterprise Edition is needed for key compression as of version 12c, the "compress" instruction is now removed from create-db.sql script. It cannot be used …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/setup/database-setup/oracle-compression-licensing

Import Oracle database_sysadmin

… Execution time: 5 minutes + copy dumpfile time + import wait time = 20-60 minutes for a standard censhare database. Prerequisites ssh access to the database ser< …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/setup/database-setup/import-oracle-database

Enhance security in Oracle database environments_sysadmin

… Separate users and permissions for the application and the application's updates to enhance security. Context Change of the deprecated synonym.sql environment t …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/setup/database-setup/enhance-security-in-oracle-database-environments

Migration Oracle to PostgreSQL - Sysadmin

… Create a new default schema in PostgreSQL, customize it and pool the data directly from Oracle without intermediate export files by using oracle_fdw (foreign da<5.7 because current_timestamp is a reserved word in postgresql: # only for <= v5.7 set search_path='public'; alter table stored_transformation drop column current_timestamp; Final check to see if there is any difference in the schemas: SELECT table_name, column_name FROM information_schema.columns WHERE table_schema='public' and column_name not in ('rowid') EXCEPT SELECT table_name, column_name FROM information_schema.columns WHERE table_schema='corpus' order by 1,2; SELECT table_name, column_name FROM information_schema.columns WHERE table_schema='corpus' and table_name not in ('plan_table','plan_view', 'timetrackerinterface') EXCEPT SELECT table_name, column_name FROM information_schema.columns WHERE table_schema='public' order by 1,2; Let PostgreSQL pool the data from Oracle For big databasese, you should extend the undo retention in Oracle, otherwise your import shall fail with error message ORA-01555: oracle@oracle-host $ sqlplus / as sysdba SQL> …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/setup/database-setup/migration-oracle-postgresql

Database setup_SysAdmin

… The platform’s underlying semantic database structure saves all structured information and metadata in objects, along with their relationships with each other. …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/setup/database-setup

Cheatsheet - Oracle and PostgresSQL - SysAdmin

… Differences in daily work with Oracle and PostgreSQL databases. Task Oracle PostgreSQL WARNING: commit differences by default: SQL> show autocommit autocommit O<> …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/setup/database-setup/cheatsheet-oracle-and-postgressql