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

Migration Oracle to PostgreSQL_Sysadmin

… Create a new default schema in Oracle, customize it and push the data directly from PostgreSQL without intermediate export files by using oracle_fdw (foreign da<><> …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/setup/database-setup/migration-postgresql-oracle

Oracle database performance checks Admin Client_sysadmin

… 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_sysadmin

… 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

Install Oracle and PostgreSQL databases - SysAdmin

… 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_SysAdmin

… 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 …
https://documentation.censhare.com/censhare-2021/en/administrator-guide/install-and-upgrade/installation/database/extended-data-types-for-oracle-18