https://dbwiki.co.uk/ 2026-04-18T23:38:38+00:00 https://dbwiki.co.uk/ https://dbwiki.co.uk/_media/wiki/dokuwiki.svg text/html 2025-03-08T22:24:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/adaptiveplans?rev=1741472655&do=diff Adaptive Plans Adaptive Plans in Oracle Database 12c allow runtime changes to execution plans. At runtime the cardinality of operations is checked and compared to the cardinality estimates used to generate the execution plan. If the cardinality of the operation is not as expected, an alternative subplan can be used. text/html 2025-03-08T22:24:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/adrenhancements?rev=1741472655&do=diff ADR Enhancements DDL Log By enabling an initialisation parameter you can now log all DDL commands ALTER SYSTEM SET enable_ddl_logging=true; The logs can be found in the following locations $ADR_BASE/diag/rdbms/{dbname}/{SID}/log/ddl_{SID}.log $ADR_BASE/diag/rdbms/{dbname}/{SID}/log/ddl/log.xml text/html 2025-03-08T22:24:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/alert_script?rev=1741472655&do=diff Monitoring Script for GoldenGate #!/bin/ksh # Script : monitor_gg.sh # Usage : monitor_gg.sh ORACLE_SID GGHOME # Example : monitor_gg.sh DBNAME /u07/goldengate # # ****************** # Functions # ****************** # Usage function. function show_usage { echo " " echo "Usage: ./monitor_gg.sh ORACLE_SID $GGHOME" echo " ORACLE_SID : Database Instance. " echo " GGHOME : Directory where GoldenGate is installed. " echo "Example: ./monitor_gg.sh DBNAME /u07/go… text/html 2025-03-08T22:24:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/automaticdiagnosticrepository?rev=1741472655&do=diff Automatic Diagnostic Repository ADRCI When starting adrci, if you get a message saying there is no base you can set it manually adrci> set base /u01/app/oracle adrci> show homes adrci> set homepath ..... adrci> show alert -tail -f adrci> show alert -p "message_text like '%ORA-%'" adrci> show alert -p "ORIGINATING_TIMESTAMP > systimestamp -1/24" text/html 2025-03-08T22:24:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/character_sets?rev=1741472655&do=diff Character Sets Current Character Set In order to discover the Character Set that the Oracle Database is using ... select parameter, value from v$NLS_PARAMETERS where parameter = 'NLS_CHARACTERSET'; text/html 2025-03-08T22:24:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/cloudcontrol?rev=1741472655&do=diff Cloud Control 12c Installation of Agent (Linux) Before installing confirm that you can ssh to target from OMS host. 1. Setup --> Add Target --> Add Targets Manually 2. Enter hostname including domain and select Linux x86-64 3. Installation Base Directory : /u01/app/oracle/middleware12c Instance Directory : /u01/app/oracle/middleware12c/agent_inst Named Credential : Use previous or create new one Privileged Delegation Setting : Remove default text, should be b… text/html 2025-03-08T22:24:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/concurrentstatistics?rev=1741472655&do=diff Concurrent Statistics Utilises three components * Scheduler * Advanced Queueing * Resource Manager Enabling * JOB_QUEUE_PROCESSES parameter must be set to at least 4 * Resource Manager must be enabled * CONCURRENT preference of the DBMS_STATS.SET_GLOBAL_PREFS must be MANUAL, AUTOMATIC or ALL text/html 2025-03-08T22:24:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/databaseauditing?rev=1741472655&do=diff Database Auditing Disabling Create Session Auditing By default, from 11gR1, when a database is created using DBCA, the database auditing parameter will be turned on. SQL> show parameter audit_trail NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ audit_trail string DB text/html 2025-03-08T22:24:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/databaseexpress?rev=1741472655&do=diff Database Express Configuration SQL> SELECT DBMS_XDB_CONFIG.gethttpsport FROM dual; GETHTTPSPORT ------------ 0 SQL> EXEC DBMS_XDB_CONFIG.sethttpsport(5500); PL/SQL procedure successfully completed. The URL will therefore be <https://hostname:5500/em> A user that has been granted EM_EXPRESS_BASIC or EM_EXPRESS_ALL roles can login. text/html 2025-03-08T22:24:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/datapump?rev=1741472655&do=diff Data Pump Fully Transportable Export TRANSPORTABLE = ALWAYS VERSION = 12 FULL = Y Disable Logging TRANSFORM = DISABLE_ARCHIVE_LOGGING:Y Exporting Views as Tables VIEWS_AS_TABLES = <VIEW_NAME>:<TABLE_NAME> Compressing Data During an Import text/html 2025-03-08T22:24:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/dataredaction?rev=1741472655&do=diff Data Redaction Uses the DBMS_REDACT package. The following procedures can be used ... * ADD_POLICY * ALTER_POLICY * DISABLE_POLICY * DROP_POLICY * ENABLE_POLICY The following Function Types are available ... * DBMS_REDACT.NONE * DBMS_REDACT.FULL text/html 2025-03-08T22:24:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/documents?rev=1741472655&do=diff Documents RMAN: Backups RMAN: Full Restore New Server RMAN: Full Restore Same Server RMAN: Point in Time Recovery RMAN: Restore Datafile Flashback Scenarios Data Guard: Physical Standby text/html 2025-03-08T22:24:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/dp10g?rev=1741472655&do=diff Data Pump Parameters for 10g MailOnline Schema EXTRACT DPMOL01 SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1") USERID ggate@andracaa, PASSWORD password RMTHOST 10.250.135.168, mgrport 7809, compress, tcpbufsize 262144, tcpflushbytes 262144 RMTTRAIL ./dirdat/target/ml PASSTHRU TABLE MAILONLINE.*; text/html 2025-03-08T22:24:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/dp12c?rev=1741472655&do=diff Data Pump Parameters for 12c MailOnline Schema EXTRACT DPMOL01 SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1") USERID ggate@andracaa, PASSWORD password RMTHOST 10.250.135.168, mgrport 7809, compress, tcpbufsize 262144, tcpflushbytes 262144 RMTTRAIL ./dirdat/target/ml, format release 11.2 PASSTHRU TABLE MAILONLINE.*; text/html 2025-03-08T22:24:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/error_messages?rev=1741472655&do=diff Error Messages and Resolution The settings in the MGR parameter file mean that any process that abends will be automatically restarted. If, after 3 attempts, the process cannot restart then it is left in an abended state. Supplemental Log Data Issues text/html 2025-03-08T22:24:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/exceptions?rev=1741472655&do=diff Exception Handling Setup An Exception table will hold the details of all Conflicts that have occured within GoldenGate. This is neccessary because Conflict Detection and Resolution (CDR) will be in place. Create Exception Table As the GGATE user create the EXCEPTIONS table text/html 2025-03-08T22:24:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/extendeddatatypes?rev=1741472655&do=diff Extended Datatypes Datatype Pre 12c 12c VARCHAR2 4000 bytes 32767 bytes NVARCHAR2 4000 bytes 32767 bytes RAW 2000 bytes 32767 bytes Parameter MAX_STRING_SIZE (Default is STANDARD). alter system set max_string_size = EXTENDED scope=spfile; SHUTDOWN IMMEDIATE; STARTUP UPGRADE; @?/rdbms/admin/utl32k.sql SHUTDOWN IMMEDIATE; STARTUP; text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/extract10?rev=1741472656&do=diff Extract Parameter for 10g EXTRACT EXTMOL01 SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1") SETENV (ORACLE_SID=molint1) USERID ggate, PASSWORD ggate123 TRANLOGOPTIONS DBLOGREADER TRANLOGOPTIONS BUFSIZE 4096000 TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000 TRANLOGOPTIONS EXCLUDEUSER GGATE DISCARDFILE ./dirrpt/discmol.txt, APPEND, MEGABYTES 100 DISCARDROLLOVER ON MONDAY EXTTRAIL ./dirdat/ml NODYNAMICRESOLUTION TABLE MAILONLINE.PARSED_ARTICLES, GETBEFORECOLS (ON UPDATE KEYINCLUD… text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/extract10g?rev=1741472656&do=diff Extract Parameters for 10g MailOnline Schema EXTRACT EXTMOL01 SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1") USERID ggate@andracaa, PASSWORD password TRANLOGOPTIONS DBLOGREADER TRANLOGOPTIONS BUFSIZE 4096000 TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000 TRANLOGOPTIONS EXCLUDEUSER GGATE DISCARDFILE ./dirrpt/discEXTMOL.txt, APPEND, MEGABYTES 100 DISCARDROLLOVER ON MONDAY WARNLONGTRANS 30m, CHECKINTERVAL 5m REPORTCOUNT EVERY 10 MINUTES, RATE REPORTROLLOVER AT 00:00 ON MONDAY EXTTRAIL ./dirda… text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/extract12?rev=1741472656&do=diff Extract Parameter for 12c Database EXTRACT EXTMOL02 SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1") SETENV (ORACLE_SID=molintpc1) USERID ggate, PASSWORD ggate123 CACHEMGR CACHESIZE 8G TRANLOGOPTIONS DBLOGREADER TRANLOGOPTIONS BUFSIZE 4096000 TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000 TRANLOGOPTIONS EXCLUDEUSER GGATE -- DISCARDFILE ./dirrpt/discmol.txt, APPEND, MEGABYTES 100 -- DISCARDROLLOVER ON MONDAY EXTTRAIL ./dirdat/lm, format release 11.2 TABLE MAILONLINE.PARSED_ARTICLES, GETB… text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/extract12c?rev=1741472656&do=diff Extract Parameters for 12c MailOnline Schema EXTRACT EXTMOL01 SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1") USERID ggate@andracaa, PASSWORD password TRANLOGOPTIONS DBLOGREADER TRANLOGOPTIONS BUFSIZE 4096000 TRANLOGOPTIONS DBLOGREADERBUFSIZE 4096000 TRANLOGOPTIONS EXCLUDEUSER GGATE DISCARDFILE ./dirrpt/discEXTMOL.txt, APPEND, MEGABYTES 100 DISCARDROLLOVER ON MONDAY WARNLONGTRANS 30m, CHECKINTERVAL 5m REPORTCOUNT EVERY 10 MINUTES, RATE REPORTROLLOVER AT 00:00 ON MONDAY -- NOTE: Format … text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/flashbackdataarchive?rev=1741472656&do=diff Flashback Data Archive User-Context Tracking The user context can now be tracked with FDA and therefore see which user made changes to a table. Use DBMS_FLASHBACK_ARCHIVE.SET_CONTEXT_LEVEL procedure to do this ... ALL : All contexts from the SYS_CONTEXT function are stored. TYPICAL : Only basic auditing attributes from the USERENV context are stored. NONE : No context information is stored. EXEC DBMS_FLASHBACK_ARCHIVE.SET_CONTEXT_LEVEL('TYPICAL'); text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/global?rev=1741472656&do=diff Global Parameter -- 10g GGSCHEMA GGATE CHECKPOINTTABLE GGATE.CHKPTAB -- 12c GGSCHEMA GGATE TRAIL_SEQLEN_6D CHECKPOINTTABLE GGATE.CHKPTAB text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/globalspar?rev=1741472656&do=diff Globals Parameter 10g Database GGSCHEMA GGATE CHECKPOINTTABLE GGATE.CHKPTAB 12c Database GGSCHEMA GGATE CHECKPOINTTABLE GGATE.CHKPTAB TRAIL_SEQLEN_6D text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/goldengate?rev=1741472656&do=diff GoldenGate Work for 16th October [GoldenGate Database Initial Setup] [GoldenGate Uni-Directional Replication] [GoldenGate Bi-Directional Replication] [GoldenGate as a Clusterware Resource] [ Checking and Diagnosing GoldenGate] [Converting Bi-Directional to Uni-Directional] [ GoldenGate Best Practices - Bi-Directional] [ GoldenGate High Availability with RAC] Parameter Files Globals Manager 10g Database Extract Data Pump Replicat 12c Database Extract Data Pump Replicat … text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/grandnational?rev=1741472656&do=diff Grand National Sweepstake (Oracle) Create User CREATE USER GRANDNATIONAL IDENTIFIED BY horses; GRANT CREATE SESSION TO GRANDNATIONAL; GRANT CREATE TABLE TO GRANDNATIONAL; GRANT CREATE PROCEDURE TO GRANDNATIONAL; GRANT CREATE VIEW TO GRANDNATIONAL; GRANT CREATE SEQUENCE TO GRANDNATIONAL; GRANT UNLIMITED TABLESPACE TO GRANDNATIONAL; text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/grandnationaloracle?rev=1741472656&do=diff Grand National Sweepstake (Oracle) Create User CREATE USER GRANDNATIONAL IDENTIFIED BY horses; GRANT CREATE SESSION TO GRANDNATIONAL; GRANT CREATE TABLE TO GRANDNATIONAL; GRANT CREATE PROCEDURE TO GRANDNATIONAL; GRANT CREATE VIEW TO GRANDNATIONAL; GRANT CREATE SEQUENCE TO GRANDNATIONAL; GRANT UNLIMITED TABLESPACE TO GRANDNATIONAL; text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/grandnationalpostgresql?rev=1741472656&do=diff Grand National Sweepstake (PostgreSQL) Create Database CREATE DATABASE GrandNational; Create tables and insert data -- Lists the entrants in the sweepstake Drop table participants; Create table if not exists participants (ID serial, Name varchar(20) PRIMARY KEY NOT NULL CHECK (length(Name) > 0)); insert into participants (name) values ('Ian'); insert into participants (name) values ('Pat'); insert into participants (name) values ('Graham'); insert… text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/histograms?rev=1741472656&do=diff Histograms Top Frequency Histograms The optimiser normally creates a frequency histogram if the number of distinct values in a column is less than the number of histogram buckets you specify. This is where the histogram concentrates on only the popular values. text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/identitycolumns?rev=1741472656&do=diff Identity Columns Force use of identity, generate error if statement references identity column CREATE TABLE test_table ( id NUMBER GENERATED ALWAYS AS IDENTITY, description VARCHAR2(40) ); If statement references identity column then use that value. text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/ilm?rev=1741472656&do=diff Information Lifecycle Management Heat Map By default the Heat Map initialisation parameter is set to OFF. It can be changed at the session and system level. ALTER SYSTEM SET HEAT_MAP = ON; Causes the database to track read and write access of all segments. text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/indatabasearchiving?rev=1741472656&do=diff In Database Archiving Enabling Can be enabled with CREATE or ALTER TABLE commands ... CREATE TABLE employees ( id NUMBER, description VARCHAR2(20) ) ROW ARCHIVAL; ALTER TABLE employees ROW ARCHIVAL; This will create a hidden column called ORA_ARCHIVE_STATE. text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/installmysql?rev=1741472656&do=diff Installing MySQL Using APT Repository Debian / Ubuntu * Download software from <https://dev.mysql.com/downloads/repo/apt> * dpkg -i mysql-apt-config_0.8.12-1_all.deb * During installation choose version of MySQL. * apt-get update * apt-get install mysql-server Using YUM Repository text/html 2025-06-03T08:11:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/instantclient?rev=1748938318&do=diff Oracle Instant Client Installation sudo apt install -y libaio1 mkdir oracle && cd "$_" wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-basic-linux.x64-23.7.0.25.01.zip wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-sqlplus-linux.x64-23.7.0.25.01.zip wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-sdk-linux.x64-23.7.0.25.01.zip wget https://download.oracle.com/otn_software/… text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/logminer?rev=1741472656&do=diff Log Miner EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '/u03/oradata/fast_recovery_area/arc_60463_seq.0001', OPTIONS => DBMS_LOGMNR.NEW); EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG); text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/mgr?rev=1741472656&do=diff MGR Parameter -- 10g PORT 7809 AUTOSTART EXTRACT * AUTORESTART EXTRACT *, RETRIES 3, WAITMINUTES 5, RESETMINUTES 60 PURGEOLDEXTRACTS /u01/goldengate/dirdat/ml*, USECHECKPOINTS, MINKEEPHOURS 4 PURGEOLDEXTRACTS /u01/goldengate/dirdat/rc*, USECHECKPOINTS, MINKEEPHOURS 4 PURGEOLDEXTRACTS /u01/goldengate/dirdat/rg*, USECHECKPOINTS, MINKEEPHOURS 4 PURGEOLDEXTRACTS /u01/goldengate/dirdat/lm*, USECHECKPOINTS, MINKEEPHOURS 4 PURGEOLDEXTRACTS /u01/goldengate/dirdat/cr*, USECHECKPOINTS, MINKEEPHOURS 4 PUR… text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/mgrpar?rev=1741472656&do=diff Manager Parameter 10g Database PORT 7809 DYNAMICPORTLIST 7820-7835 AUTOSTART ER * AUTORESTART ER *, RETRIES 3, WAITMINUTES 5, RESETMINUTES 60 PURGEOLDEXTRACTS /u07/goldengate/dirdat/source/*, USECHECKPOINTS, MINKEEPDAYS 2 PURGEOLDEXTRACTS /u07/goldengate/dirdat/target/*, USECHECKPOINTS, MINKEEPDAYS 2 LAGREPORTMINUTES 5 LAGINFOSECONDS 30 LAGCRITICALMINUTES 5 text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/multitenantarchitecture?rev=1741472656&do=diff Multitenant Architecture Advantages * Database Consolidation * Reduced Costs * Rapid Implementation * Simplified Management * Separation of Duties * Simplified Tuning * Simplified Patching Creating a CDB Create spfile setting parameter ENABLE_PLUGGABLE_DATABASES = TRUE text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/multithreaded?rev=1741472656&do=diff Multi Threaded Architecture Only the processes that are needed will be running for a particular instance. Now Oracle can run in multi-threaded mode in Linux (Similar to Windows). ALTER SYSTEM SET threaded_execution=true SCOPE=SPFILE; The database must be administered by an account that is authenticated through a password file. text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/mysqlcertification?rev=1741472656&do=diff MySQL Certification <https://education.oracle.com/mysql-57-database-administrator/pexam_1Z0-888> Installing MySQL Install MySQL Identify installed Files and Directories Understand Initial Configuration Start and Stop MySQL Configuring MySQL Understand Server Options, Variables, and the Command Line Define Option Files Use System Variables User Management Identify MySQL Privilege System Create and Modify User Accounts text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/mysqlcommands?rev=1741472656&do=diff MySQL Commands mysql -u root -p mysql -h ubuntu-vb -u root -p mysql -u root -p football select version(), curdate(), curtime(), now(), current_user; show databases; create database football; use football; show tables; select database(); mysqlshow -u root -p --count football show binary logs; show master status; flush binary logs; show status like '%Connections%'; show variables like '%bin%'; show engine innodb status\G show processlist; <OR> SELECT * FROM information_schema.processlist O… text/html 2025-03-08T22:24:16+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/mysqlfilesdirectories?rev=1741472656&do=diff Installed Files and Directories Linux Data Directory On Ubuntu this defaults to /var/lib/mysql A separate directory will be created for each database, apart from INFORMATION_SCHEMA. Also stored here by default are ... * Log Files * InnoDB tablespace and log files text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/mysqlperformance?rev=1741472657&do=diff MySQL Performance <http://www.speedemy.com/17-key-mysql-config-file-settings-mysql-5-7-proof/> <http://speedemy.com/files/mysql/my.cnf> Slow Query Log Analysis wget percona.com/get/pt-query-digest \\ chmod 750 pt-query-digest \\ ./pt-query-digest /var/lib/mysql/slow-query.log > /root/slow-query-log.out Performance Schema Scripts -- Unused Indexes select * from sys.schema_unused_indexes; select object_schema, object_name, index_name from performance_schema.table_io_waits_summary_by_i… text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/mysqlreplication?rev=1741472657&do=diff MySQL Replication 192.168.56.102 ubuntu-master 192.168.56.103 ubuntu-slave Set Server ID on Slave set persist server_id = 2; service mysql restart systemctl restart mysql Create Replication User on Master create user 'repl'@'ubuntu-slave' identified by 'teapot'; grant replication slave on *.* to 'repl'@'ubuntu-slave'; text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/onlineddl?rev=1741472657&do=diff New Online DDL Capabilities Drop Index DROP INDEX ian.idx1 ONLINE; Drop Constraint ALTER TABLE ian.tab1 DROP CONSTRAINT name_fk ONLINE; Mark Index Unusable ALTER INDEX ian.idx2 UNUSABLE ONLINE; Mark Column Unused ALTER TABLE ian.tab1 SET UNUSED (name) ONLINE; text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/oracle12cnewfeatures?rev=1741472657&do=diff Oracle 12c New Features Adaptive Plans ADR Enhancements Concurrent Statistics Data Pump Data Redaction EM Database Express Extended Datatypes Flashback Data Archive Histograms Identity Columns In Database Archiving Information Lifecycle Management (ILM) Multitenant Architecture Multi Threaded Architecture Online DDL Capabilities Privilege Analysis Real-Time Database Operation Monitoring Resource Manager Row Limiting Clause (SQL) Unified Auditing Valid Time Temporal text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/oracledataguard?rev=1741472657&do=diff Oracle Data Guard Enable / Stop Redo Apply ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DELAY 240 DISCONNECT FROM SESSION; ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/oracledataguardbroker?rev=1741472657&do=diff Data Guard Broker Configuration Example below ... Primary Database: DUBEPRD on DBOR01 Standby Database: DUBESDBY on DBOR02 On the Physical and Standby database set the following initialisation parameters: SQL> alter system set dg_broker_config_file1 = ‘D:\oracle\product\11.2.0\dbhome_1\database\DR1DUBEPRD01.DAT’; SQL> alter system set dg_broker_config_file2 = ‘D:\oracle\product\11.2.0\dbhome_1\database\DR2DUBEPRD02.DAT’; SQL> alter system set dg_broker_start = TRUE; text/html 2025-04-01T08:34:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/performancetuning?rev=1743496471&do=diff Performance Tuning Simple Explain Plan EXPLAIN PLAN FOR SELECT * FROM dba_users; SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY); Get Active Sessions SET LINES 2000 TRIMSPOOL ON PAGES 10000 COLUMN EVENT FORMAT A30 COLUMN secw FORMAT 99999 COLUMN username FORMAT A15 COLUMN sqlid_chno FORMAT A20 ACCEPT usr PROMPT 'Username (blank for all): ' SELECT sw.SID, s.username, sw.SEQ#, sw.EVENT, sw.WAIT_TIME, sw.SECONDS_IN_WAIT secw, SQL_ID||' '||SQL_CHILD_NUMBER sqlid_chno, sw.STATE,… text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/plsql_sequence?rev=1741472657&do=diff Sequence PL/SQL Instructions Before executing the below procedures make sure the following has been done ... * Database Links created on both databases * The following tables have been created as GGATE user ... * sync_sequences_log * mol_gg_sequences (10g Database only) text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/postgresqlbarman?rev=1741472657&do=diff Barman Commands barman list-backup all barman list-server barman show-server all barman show-backup <server> <backup_id> barman status all Main configuration file: /etc/barman.conf Server configuration files located in /etc/barman.d directory text/html 2025-04-17T10:16:53+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/postgresqlcommands?rev=1744885013&do=diff Installation Linux <https://www.postgresql.org/download/linux/debian/> <https://www.postgresql.org/download/linux/redhat/> Create Cluster The Debian or Ubuntu installation will create a default instance. Create new instances using the commands below ... # Debian / Ubuntu pg_createcluster -d /var/lib/postgresql/17/main 17 main # Redhat / Fedora # Default Data Directory: /var/lib/pgsql/17/data sudo /usr/pgsql-17/bin/postgresql-17-setup initdb /usr/pgsql-17/bin/initdb -D /var/lib/pgsql… text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/postgresqlextensions?rev=1741472657&do=diff PostgreSQL Extensions pg_cron <https://github.com/citusdata/pg_cron/> Can be installed using the apt.postgresql.org repository sudo apt install postgresql-13-cron Add the following entries in the postgresql.conf file ... shared_preload_libraries = 'pg_cron' cron.database = '<database_name>' text/html 2025-03-26T14:58:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/postgresqlflexible?rev=1743001101&do=diff Entra ID Authentication <https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-manage-azure-ad-users> Logon az login az account get-access-token --resource-type oss-rdbms --output tsv --query accessToken $env:PGPASSWORD='<Access_Token>' psql "host=server.postgres.database.azure.com user=postgres_users dbname=postgres sslmode=require" text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/postgresqlfunctions?rev=1741472657&do=diff SQL and PL/pgSQL JSON | JSON Cheat Sheet Arrays Arrays can be displayed as ARRAY[1,2,3] or {1,2,3}. Operators SELECT 1 WHERE 'ian' = ANY(ARRAY['ian','bob']); --True SELECT 1 WHERE 'ian' = ALL(ARRAY['ian','bob']); --False -- Does each element appearing in the 2nd array equal some element of the 1st array SELECT ARRAY[1,2,3] @> ARRAY[1,3]; --True SELECT ARRAY[1,2,3] @> ARRAY[1,3,4]; --False -- Does each element appearing in the 1st array equal some element of the 2n… text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/postgresqlimdb?rev=1741472657&do=diff IMDB Database The import of the data was based on the script here: Import IMDB Datasets into Postgres Run the below script as the postgres user to avoid permission issues. printf "Removing and create folder \n" rm -rf imdb-datasets/ mkdir imdb-datasets/ printf "Download datasets from https://datasets.imdbws.com \n" cd imdb-datasets curl -O https://datasets.imdbws.com/name.basics.tsv.gz curl -O https://datasets.imdbws.com/title.akas.tsv.gz curl -O https://datasets.imdbws.com/title.basics.t… text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/postgresqlpartioning?rev=1741472657&do=diff Partitioning List CREATE TABLE USERS_PART ( user_id serial, username varchar(50), user_role varchar(1), created_date DATE DEFAULT CURRENT_DATE, last_updated_ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) PARTITION BY LIST (user_role); -- Inserts would currently fail as we haven't defined any partitions for this table CREATE TABLE USERS_PART_A PARTITION OF USERS_PART FOR VALUES IN ('A'); -- Inserts will now only work with a user_role of A text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/postgresqlreplication?rev=1741472657&do=diff Binary Replication Settings Description Value Primary Server 192.168.0.2 Standby Server 192.168.0.3 Default Port 5432 Create Replication User # su - postgres # createuser -U postgres repmgr -P -c 5 --replication Configure pg_hba.conf Add a rule that will allow the database user from the standby access the primary. text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/postgresqlupgrade?rev=1741472657&do=diff PostgreSQL Upgrades Using pg_upgrade <https://www.postgresql.org/docs/14/pgupgrade.html> /usr/lib/postgresql/14/bin/pg_upgrade --old-datadir=/var/lib/postgresql/10/main --new-datadir=/var/lib/postgresql/14/main --old-bindir=/usr/lib/postgresql/10/bin --new-bindir=/usr/lib/postgresql/14/bin --old-options='-c config_file=/… text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/postgresqlvacuum?rev=1741472657&do=diff Vacuuming Parameters autovacuum_analyze_scale_factor | Number of DML prior to analyze as a fraction of reltuples. autovacuum_analyze_threshold | Minimum number of DML prior to analyze. autovacuum_vacuum_scale_factor | Number of DML prior to vacuum as a fraction of reltuples. autovacuum_vacuum_threshold | Minimum number of tuple DML prior to vacuum. text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/privilegeanalysis?rev=1741472657&do=diff Privilege Analysis It is possible to use privilege analysis without having Database Vault configured. Define Policy Below shows an example of a Role and Context Policy BEGIN DBMS_PRIVILEGE_CAPTURE.CREATE_CAPTURE ( name => 'rolecontext_policy', type => DBMS_PRIVILEGE_CAPTURE.g_role_and_context, roles => role_name_list('DBA', 'EXP_FULL_DATABASE') condition => 'SYS_CONTEXT(''USERENV'', ''SESSION_USER'') = ''SYSTEM'''); END; text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/prod_install?rev=1741472657&do=diff Zero Downtime Database Migration The following details the steps needed to setup bi-directional replication. There is no database upgrade in this case. Installation Number Date Description Commands112/09/2016Install GoldenGate on both hosts using shared storage visible by both RAC nodes. text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/pythonpostgresql?rev=1741472657&do=diff psycopg psycopg Homepage psycopg2 Installation Connecting to PostgreSQL import psycopg2 import psycopg2.extras conn = psycopg2.connect(database="doob", user = "ian", password = "pwd", host = "localhost") print "Connection Successful" #cur = conn.cursor() cur = conn.cursor(cursor_factory=psycopg2.extras.DictCursor) query = "SELECT usename, usesuper FROM pg_user" cur.execute(query) rows = cur.fetchall() for row in rows: print(row) print(f"{row['usename']} {row['usesuper']}") cur.… text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/rac?rev=1741472657&do=diff Oracle Real Application Clusters (RAC) Command Line (11g/12c) Voting Disk [root] $GRID_HOME/bin/crsctl query css votedisk [root] $GRID_HOME/bin/crsctl replace votedisk +FRA Oracle Cluster Registry (OCR) [root] cat /etc/oracle/ocr.loc [root] $GRID_HOME/bin/ocrcheck [root] $GRID_HOME/bin/ocrconfig -delete -DATA [root] $GRID_HOME/bin/ocrconfig -add -DATA [root] $GRID_HOME/bin/ocrconfig -replace +DATA -replacement -DATA2 [oracle] $GRID_HOME/bin/ocrconfig -showbackup text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/redo_logs?rev=1741472657&do=diff Redo Logs Resizing Online Add New Log Groups If we are using OMF then all that is needed is the below 3 commands. ALTER DATABASE ADD LOGFILE GROUP 4 SIZE 500M; ALTER DATABASE ADD LOGFILE GROUP 5 SIZE 500M; ALTER DATABASE ADD LOGFILE GROUP 6 SIZE 500M; text/html 2025-03-08T22:24:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/replicat10g?rev=1741472657&do=diff Replication Parameters for 10g MailOnline Schema REPLICAT REPMOL01 SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1") USERID ggate@molbb, PASSWORD password ASSUMETARGETDEFS DBOPTIONS SUPPRESSTRIGGERS DISCARDFILE ./dirrpt/discREPMOL.dsc, APPEND, MEGABYTES 100 DISCARDROLLOVER ON MONDAY DDL INCLUDE ALL DDLOPTIONS REPORT DDLERROR 955 DISCARD DDLERROR 1031 DISCARD DDLERROR 24344 DISCARD REPORTCOUNT EVERY 10 MINUTES, RATE REPORTROLLOVER AT 00:00 ON MONDAY INCLUDE ./dirprm/macros/exceptions.inc … text/html 2025-03-08T22:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/replicat12c?rev=1741472658&do=diff Replication Parameters for 12c There are currently no differences between the replicat process in 10g and 12c MailOnline Schema REPLICAT REPMOL01 SETENV (NLS_LANG="ENGLISH_UNITED KINGDOM.WE8ISO8859P1") USERID ggate@molbb, PASSWORD password ASSUMETARGETDEFS DBOPTIONS SUPPRESSTRIGGERS DISCARDFILE ./dirrpt/discREPMOL.dsc, APPEND, MEGABYTES 100 DISCARDROLLOVER ON MONDAY DDL INCLUDE ALL DDLOPTIONS REPORT DDLERROR 955 DISCARD DDLERROR 1031 DISCARD DDLERROR 24344 DISCARD REPORTCOUNT EVERY 10 MINUT… text/html 2025-03-08T22:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/resourcemanager?rev=1741472658&do=diff Resource Manager CDB Resource Plan This will control the resource usage between pluggable databases. Package / Procedures DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN DBMS_RESOURCE_MANAGER.DELETE_CDB_PLAN DBMS_RESOURCE_MANAGER.CREATE_CDB_PLAN_DIRECTIVE DBMS_RESOURCE_MANAGER.UPDATE_CDB_PLAN_DIRECTIVE DBMS_RESOURCE_MANAGER.DELETE_CDB_PLAN_DIRECTIVE text/html 2025-03-08T22:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/rman?rev=1741472658&do=diff RMAN Parameters export NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI" CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u03/oracle/backup/%F'; CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1; CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u03/oracle/backup/%U'; text/html 2025-03-08T22:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/rowlimitingclause?rev=1741472658&do=diff Row Limiting Clause Display the highest 5 salaries SELECT id, description, salary FROM employees ORDER BY salary DESC FETCH FIRST 5 ROWS ONLY; Display the 6th to the 10th highest salaries SELECT id, description, salary FROM employees ORDER BY salary DESC OFFSET 5 ROWS FETCH NEXT 5 ROWS ONLY; text/html 2025-03-08T22:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/rtdatabaseopmonitoring?rev=1741472658&do=diff Real-Time Database Operation Monitoring Enabling The default behaviour is for the database to start tracing an operation only if it is sufficiently expensive. * SQL Statement that runs in parallel * SQL Statement that takes more than 5 seconds of CPU or I/O time. text/html 2025-03-08T22:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/sequence10?rev=1741472658&do=diff PL/SQL Code for 10g Database This package should be installed as the GGATE user on the 10g Database (Source) Before installing you need to create the database link and tables from here Function MOL_SEQUENCE_CHECK_LINK contains a database link that may need to be renamed. text/html 2025-03-08T22:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/sequence12?rev=1741472658&do=diff PL/SQL Code for 12c Database This package should be installed as the GGATE user on the 12c Database (Target) Before installing you need to create the database link and tables from here Function MOL_SEQUENCE_CHECK_LINK contains a database link that may need to be renamed. text/html 2025-03-08T22:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/sequenceother?rev=1741472658&do=diff PL/SQL for Other Objects Below is the code required in order to create ... * Database Links * Tables * Scheduled Jobs ... for sequences in a bi-directional format. -- Create on 10g Database Create public database link ggmolbb connect to ggate identified by ggate123 using 'molintpc'; -- Create on 12c Database Create public database link ggandraca connect to ggate identified by ggate123 using 'molinta'; Create table sync_sequences_log (owner varchar2(20), sequence_name varchar(50), … text/html 2025-03-08T22:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/sqlplus?rev=1741472658&do=diff SQL*Plus glogin.sql You can alter the default prompt and editor for SQL*Plus using the glogin.sql file. This can be found at $ORACLE_HOME\sqlplus\admin define _editor=vi set sqlprompt "_USER'@'_CONNECT_IDENTIFIER> " You can add here any other “ text/html 2025-03-27T15:50:13+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/start?rev=1743090613&do=diff Database Wiki PostgreSQL Articles PostgreSQL Information PostgreSQL Replication PostgreSQL Partitioning PostgreSQL Barman PostgreSQL Upgrades PostgreSQL Extensions PostgreSQL Vacuum PostgreSQL pl/pgpsql PostgreSQL Flexible Server for Azure Python and PostgreSQL Terraform and PostgreSQL Grand National Sweepstake Code IMDB Database ---------- Oracle Database Articles Automatic Diagnostic Repository Character Sets Cloud Control 12c Database Auditing Data Guard Da… text/html 2025-03-08T22:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/statistics?rev=1741472658&do=diff Database Statistics Restore -- View historic table stats for the problematic tables SELECT table_name, stats_update_time FROM ALL_TAB_STATS_HISTORY WHERE OWNER = 'SCANPRD1' AND TABLE_NAME in ('DM_SYSOBJECT_R','DM_SYSOBJECT_S') ORDER BY TABLE_NAME, STATS_UPDATE_TIME; text/html 2025-03-08T22:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/tablespaces?rev=1741472658&do=diff Tablespaces Current Tablespace Usage SET PAGESIZE 140 LINESIZE 200 COLUMN used_pct FORMAT A11 COLUMN size_mb FORMAT 999,999 COLUMN free_mb FORMAT 999,999 COLUMN max_size_mb FORMAT 999,999 COLUMN max_free_mb FORMAT 999,999 SELECT tablespace_name, size_mb, free_mb, max_size_mb, max_free_mb, TRUNC((max_free_mb/max_size_mb) * 100) AS free_pct FROM ( SELECT a.tablespace_name, b.size_mb, a.free_mb, b.max_si… text/html 2025-03-08T22:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/terraformpostgresql?rev=1741472658&do=diff Terraform with PostgreSQL Microsoft Azure and PostgreSQL Flexible Server Useful Links [<https://learn.microsoft.com/en-us/azure/developer/terraform/get-started-windows-powershell]> [<https://learn.microsoft.com/en-us/azure/developer/terraform/authenticate-to-azure-with-microsoft-account]> [<https://learn.microsoft.com/en-us/azure/developer/terraform/deploy-postgresql-flexible-server-database?tabs=azure-cli]> [<https://github.com/Azure/terraform/tree/master/quickstart/201-postgresql-fs-db]>… text/html 2025-03-08T22:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/unifiedauditing?rev=1741472658&do=diff Unified Auditing Check if Enabled select VALUE from V$OPTION where PARAMETER='Unified Auditing'; Enable * Shutdown Database * cd $ORACLE_HOME/rdbms/lib * make -f ins_rdbms.mk uniaud_on ioracle * set AUDIT_TRAIL = NONE, otherwise both auditing mechanisms will run concurrently text/html 2025-08-07T09:11:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/usefulscripts?rev=1754557881&do=diff Scripts Tablespaces / Data Files / Blocks SET PAGESIZE 140 LINESIZE 200 COLUMN used_pct FORMAT A11 COLUMN size_mb FORMAT 9,999,999 COLUMN free_mb FORMAT 9,999,999 COLUMN max_size_mb FORMAT 9,999,999 COLUMN max_free_mb FORMAT 9,999,999 SELECT tablespace_name, size_mb, free_mb, max_size_mb, max_free_mb, TRUNC((max_free_mb/max_size_mb) * 100) AS free_pct FROM ( SELECT a.tablespace_name, b.size_mb, a.free_mb, … text/html 2025-03-08T22:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/validtimetemporal?rev=1741472658&do=diff Valid Time Temporal Create Tables Create a period using existing columns CREATE TABLE student_modules ( id NUMBER(10) NOT NULL, student_id NUMBER(10) NOT NULL, module_id NUMBER(10) NOT NULL, start_date DATE, end_date DATE, PERIOD FOR student_module_period (start_date, end_date) ); text/html 2025-03-08T22:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/weblogicinstallation?rev=1741472658&do=diff Weblogic / Fusion Middleware Installation Certification Check with the following documents to make sure that the operating system, JDK, Weblogic and Fusion Middleware are all compatible. Forms / Reports 11.1.1.x Certification Matrix Forms / Reports 11.1.2.x Certification Matrix Fusion Middleware 12.1.3 text/html 2025-03-08T22:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/windowscommands?rev=1741472658&do=diff Powershell Disable WSUS Windows Server Update Services Check Registry Key ... [HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate] Stop-Service -Name wuauserv Remove-Item HKLM:\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate -Recurse Start-Service -name wuauserv Stop-Service -Name wuauserv New-Item -Path "HKLM:\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate" New-ItemProperty -Path "HKLM:\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate" -Name "TargetGroupEnable… text/html 2025-03-08T22:24:18+00:00 Anonymous (anonymous@undisclosed.example.com) https://dbwiki.co.uk/work16thoct?rev=1741472658&do=diff Setting Up Sequences in Bi-Directional GoldenGate Log on as GGATE user Run on ANDRACAA exec mol_sequences.mol_seqoddeven('FBIAGENT'); exec mol_sequences.mol_seqoddeven('MAILONLINE'); Run on MOLBB exec mol_sequences.mol_seq_alternate('FBIAGENT'); exec mol_sequences.mol_seq_alternate('MAILONLINE');