Tag: oratidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in January 2019. Hope you find these helpful to learn something new or to remind you of its existence and use.

#oratidbit #goldengate Oracle Database 18c and later support replication of identity columns using Golden Gate. It requires usage of the Integrated Extract and Integrated Replicat or Integrated Parallel Replicat.

#oratidbit #goldengate The Classic Extract (capture) is deprecated as of Oracle GoldenGate 18c (18.1.0). There will be no further enhancements to the Classic Capture (Extract) process.

#oratidbit #goldengate Oracle GoldenGate Veridata compares one set of data to another and identifies data that is out-of-sync, and allows you to repair any data that is found out-of-sync (while data sources are online).

#oratidbit The RMAN block change tracking file can be enabled on an Oracle Active Data Guard standby that is using multi-instance Redo Apply in 18c (18.1.0)

#oratidbit #oracleatp #oraclecloud The default data and temporary tablespaces for the Autonomous Transaction Processing database are configured automatically. Adding, removing, or modifying tablespaces is not allowed.

#oratidbit #oracleatp #oraclecloud Compression is not enabled by default on Autonomous Transaction Processing instance, but ATP honors a compression clause if compression is specified on a table.

#oratidbit A Global Data Services configuration and its global services are created and managed using the GDSCTL command-line interface, which is similar to the SRVCTL command-line interface used to manage an Oracle RAC database and its services.

#oratidbit To enable secure communication between Oracle Analytics Cloud and Oracle Autonomous Data Warehouse Cloud, upload trusted SSL certificates from Oracle Autonomous Data Warehouse Cloud to Oracle Analytics Cloud.

#oratidbit “dbms_xdb_config.setglobalportenabled(TRUE)” enables global port for EM Express which enables you to use EM Express to connect to all of the PDBs in the CDB using the HTTPS port for the CDB.

#oratidbit Using the EM Express Performance Hub you can view performance statistics for a standby database in an Oracle Active Data Guard environment. Only real-time data for the standby database can be viewed in the Performance Hub.

#oratidbit Optimizer Statistics Advisor is built-in diagnostic software that analyzes the quality of statistics and statistics-related tasks. The advisor task runs automatically in the maintenance window.

#oratidbit An on-premise database can be duplicated to Oracle Cloud using the DUPLICATE PLUGGABLE DATABASE command in 18c. Similarly, you can duplicate a database in Oracle Cloud as an on-premise database.

#oratidbit #exadata Starting with Oracle Exadata System 19.1.0, Database Machine provides automated, cloud-scale performance monitoring including CPU, memory, file system, IO, and network. This feature combines AI, real-world performance experience, and best practices.

#oratidbit #db18c DBMS_PDB.EXPORTRMANBACKUP procedure exports the RMAN backup information that belongs to a pluggable database to its dictionary before unplug so that pre-plugin backups can be used. Use for non-CDB to PDB migration. Not needed for PDB relocation.

#oratidbit A PDB snapshot is a named copy of a PDB at a specific point in time. When a PDB is enabled for PDB snapshots, you can create up to eight snapshots of it. The set of snapshots is called a snapshot carousel.

#oratidbit The Oracle Database password file in ORACLE_BASE allows Oracle home to be used as a static repository of database files enabling the Oracle home to be configured in read-only mode and used as a software image that can be shared across multiple database servers.

#oratidbit Passwords in database links are encrypted in #db18c. Oracle Data Pump handles the export and import of these passwords. Import operations from older versions and export operations to older versions can still be used.

#oratidbit #db18c The DataPump Import DATA_OPTIONS parameter CONTINUE_LOAD_ON_FORMAT_ERROR option. If DataPump encounters a stream format error when loading table data, attempts to skip forward to find the start of the next row and continue loading data from that location.

#oratidbit #db18c The DATA_OPTIONS parameter of the DBMS_DATAPUMP.SET_PARAMETER procedure option KU$_DATAOPT_CONT_LOAD_ON_FMT_ERR tells DataPump to continue loading data from the next row if it encounters stream format errors in the table data.

#oratidbit In Oracle Database 18c, RMAN preserves the PDB backup history for PDBs, even if it is moved from one CDB to another. Use syntax RESTORE/RECOVER PLUGGABLE DATABASE <pdb> FROM PREPLUGIN BACKUP.

“Oracle *daily* TidBits” (#oratidbit) published on  Facebook, Twitter, and Google+ during weekdays in December 2018. The list is short as there were no #oratidbit during the Christmas holidays. Hope you find these helpful to learn something new or to remind you of its existence and use.

HAPPY NEW YEAR 2019!

#oratidbit #orcldb When you move the online data file using ALTER DATABASE MOVE DATAFILE ‘filename’; without the TO clause, the file will be moved to DB_FILE_CREATE_DEST as Oracle Managed File – the DB_FILE_CREATE_DEST location can be ASM diskgroup or file system.

#oratidbit #orcldb Certain initialization parameters in a multitenant database could have different values for individual pluggable database. Such parameter values are stored in PDB_SPFILE$ and are queriable using V$SYSTEM_PARAMETER. CON_ID identifies the puluggable database.

#oratidbit The SEC_RETURN_SERVER_RELEASE_BANNER parameter controls the display of the product version information in a client connection. An intruder could use db release number to find information about security vulnerabilities. Default value is FALSE (hide product info).

#oratidbit If the Oracle Database 12c database hosts a database link to an Oracle Database 10g database, then the SQLNET.ALLOWED_LOGON_VERSION_CLIENT parameter should be set to SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10 (sqlnet.ora) for the dblink to work.

#oratidbit #SQLPlus With SET FEEDBACK ONLY command, so you can run queries but the resulting rows are not shown in the display. They are still queried and fetched, only the feedback is shown, not rows. Best for testing performance.

#oratidbit #db18c A CDB fleet is a collection of CDBs that you manage as one logical CDB. A lead CDB is the central location for monitoring and managing the CDBs in the fleet.

#oratidbit #orcldb If JOB_QUEUE_PROCESSES parameter is 0 in a PDB, then DBMS_JOB and Oracle Scheduler jobs cannot run in this PDB, regardless of the JOB_QUEUE_PROCESSES setting in the CDB root.

#oratidbit #sqlplus SQL*Plus product-level security feature will be unavailable in Oracle Database 19c. The PRODUCT_USER_PROFILE (PUP) table provides a mechanism to control product-level security. Starting in 18c, the SQL*Plus PUP table is deprecated.

#oratidbit #sqlplus #db18c The SET FEEDBACK SQL_ID command displays the sql_id for the currently executed SQL or PL/SQL statement. The sql_id will be assigned to the predefined variable _SQL_ID.

#oratidbit #orcldb #sql Use ALTER DATABASE DICTIONARY to encrypt obfuscated database link passwords and use the TDE framework to manage the encryption key. Encrypt sensitive credential data stored in SYS.LINK$ and SYS.SCHEDULER$_CREDENTIAL system tables.

#oratidbit #oraclecloud You can programmatically provision and manage Oracle Database Cloud Service instances and associated database deployments by using REST (REpresentational State Transfer) application programming interfaces (APIs).

#oratidbit #orcl101 V$RSRC_CONSUMER_GROUP shows CPU utilization statistics for each consumer group when the Oracle Database Resource Manager is running.

#oratidbit #oraclecloud The Oracle Cloud at Customer includes Oracle Advanced Support Gateway (OASG), which includes the hardware and software required to securely connect your Oracle Cloud at Customer environment to the remote Oracle Operations team.