Are you over 18 and want to see adult content?
More Annotations
A complete backup of materielagricole.info
Are you over 18 and want to see adult content?
A complete backup of reversecallerlookup.com
Are you over 18 and want to see adult content?
Favourite Annotations
A complete backup of www.pravda.com.ua/rus/news/2020/02/24/7241499/
Are you over 18 and want to see adult content?
A complete backup of www.bbc.co.uk/news/business-51626529
Are you over 18 and want to see adult content?
A complete backup of viapais.com.ar/argentina/1607650-divina-comida-grego-rossello-recibio-en-su-casa-pero-le-criticaron-todo-y-
Are you over 18 and want to see adult content?
Text
R12.2.
STEP BY STEP INSTALLING AND CONFIGURING ORACLE 19C Step:-2 Click Oracle RAC installation and next. Step:-3 Double check both nodes selected and next. Step:-4 Click EE and next. Step:-5 Check oracle base location and next. Step:-6 Check the group owners and next. Step:-7 Enter root password. Step:-8 We didn’t configured SCANip
ORACLE 12C ONLINE REDEFINITION TIPS AND TRICKS Table Online Redefinition :- Table fragmentation deteriorate the database performance, and the rate of fragmentation in a table greatly impacts response time. It's more likely get fragmented with high DML activity on table.These fragmentation effects operation on full table scans, instead of reading blocks with data it also reads empty blocks. The table online redefinition method doesn't need ORACLE 19C-STEP BY STEP MANUAL DATA GUARD SWITCHOVER Switchover Operation Procedure: After configuring data guard, databases would be either primary and standby database role, and we can altered these roles without loss of data or without resetting logs called Switchover. A database can be in one of two mutually exclusive modes (primary or standby). These roles can be altered at runtime without loss of data or resetting of redo logs. This ORACLE 19C – DISABLE FAST START FAILOVER IN DATAGUARD Description:-If the primary and target standby database have a network connection, use DISABLE FAST_START FAILOVER without the FORCE option to disable fast-start failover on all databases in the brokerconfiguration.
GENERATE DDL FOR ALL USERS # This script generate DDL for ALL USERS # ##### SCRIPT_NAME=”all_users_ddl” ORACLE 12C-2 NODE RAC TO SINGLE INSTANCE STANDBY DATABASE Steps for creating Single instance standby database from RAC primary database :- Change the archive log mode : $ sqlplus / as sysdba SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination +DG01 Oldest online log sequence 299300 Next log sequence to archive ORACLE19C-EXPORT DATA FROM PHYSICAL STANDBY DATABASE USING 1. Physical standby database should be in READ-ONLY MODE ( ACTIVE DATA GUARD) 2.We cannot run expdp directly on physical standby database. Because data pump job can be created only on a read-write database (OPEN). So to achieve this, we will use the NETWORK_LINK parameter and run the expdp job from any non-standby database (OPEN database) ORA-39173: ENCRYPTED DATA HAS BEEN STORED UNENCRYPTED IN $ expdp system/Chennai#123@pdb1 directory=TEST_DIR SCHEMAS=hr dumpfile=hr.dmp logfile=hr.log Export: Release 18.0.0.0.0 - Production on Sat Jun QUERY TO FIND OUT THE DISK GROUP DETAILS IN RAC Conn as sqlplus '/ as sysasm' Query --------- set lines 255 col path for a35 col Diskgroup for a15 col DiskName for a20 col disk# for 999 col total_mb for 999,999,999 col free_mb for 999,999,999 compute sum of total_mb on DiskGroup compute sum of free_mb on DiskGroup break on DiskGroup skip 1 on report set pages 255 select a.name DiskGroup, b.disk_number Disk#, b.name DiskName, ORACLEDBWR | BY HARIPRASATH RAJARAM Find Application URL From Database and Context File in Oracle AppR12.2.
STEP BY STEP INSTALLING AND CONFIGURING ORACLE 19C Step:-2 Click Oracle RAC installation and next. Step:-3 Double check both nodes selected and next. Step:-4 Click EE and next. Step:-5 Check oracle base location and next. Step:-6 Check the group owners and next. Step:-7 Enter root password. Step:-8 We didn’t configured SCANip
ORACLE 12C ONLINE REDEFINITION TIPS AND TRICKS Table Online Redefinition :- Table fragmentation deteriorate the database performance, and the rate of fragmentation in a table greatly impacts response time. It's more likely get fragmented with high DML activity on table.These fragmentation effects operation on full table scans, instead of reading blocks with data it also reads empty blocks. The table online redefinition method doesn't need ORACLE 19C-STEP BY STEP MANUAL DATA GUARD SWITCHOVER Switchover Operation Procedure: After configuring data guard, databases would be either primary and standby database role, and we can altered these roles without loss of data or without resetting logs called Switchover. A database can be in one of two mutually exclusive modes (primary or standby). These roles can be altered at runtime without loss of data or resetting of redo logs. This ORACLE 19C – DISABLE FAST START FAILOVER IN DATAGUARD Description:-If the primary and target standby database have a network connection, use DISABLE FAST_START FAILOVER without the FORCE option to disable fast-start failover on all databases in the brokerconfiguration.
GENERATE DDL FOR ALL USERS # This script generate DDL for ALL USERS # ##### SCRIPT_NAME=”all_users_ddl” ORACLE 12C-2 NODE RAC TO SINGLE INSTANCE STANDBY DATABASE Steps for creating Single instance standby database from RAC primary database :- Change the archive log mode : $ sqlplus / as sysdba SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination +DG01 Oldest online log sequence 299300 Next log sequence to archive ORACLE19C-EXPORT DATA FROM PHYSICAL STANDBY DATABASE USING 1. Physical standby database should be in READ-ONLY MODE ( ACTIVE DATA GUARD) 2.We cannot run expdp directly on physical standby database. Because data pump job can be created only on a read-write database (OPEN). So to achieve this, we will use the NETWORK_LINK parameter and run the expdp job from any non-standby database (OPEN database) ORA-39173: ENCRYPTED DATA HAS BEEN STORED UNENCRYPTED IN $ expdp system/Chennai#123@pdb1 directory=TEST_DIR SCHEMAS=hr dumpfile=hr.dmp logfile=hr.log Export: Release 18.0.0.0.0 - Production on Sat Jun QUERY TO FIND OUT THE DISK GROUP DETAILS IN RAC Conn as sqlplus '/ as sysasm' Query --------- set lines 255 col path for a35 col Diskgroup for a15 col DiskName for a20 col disk# for 999 col total_mb for 999,999,999 col free_mb for 999,999,999 compute sum of total_mb on DiskGroup compute sum of free_mb on DiskGroup break on DiskGroup skip 1 on report set pages 255 select a.name DiskGroup, b.disk_number Disk#, b.name DiskName, ORACLE 12C ONLINE REDEFINITION TIPS AND TRICKS Table Online Redefinition :- Table fragmentation deteriorate the database performance, and the rate of fragmentation in a table greatly impacts response time. It's more likely get fragmented with high DML activity on table.These fragmentation effects operation on full table scans, instead of reading blocks with data it also reads empty blocks. The table online redefinition method doesn't need STEP BY STEP ORACLE 19C INSTALLATION ON LINUX Step 6: Enter Database name. Step 7: Enter database file location. Step 8: Enable Archivelog mode option for database. Step 9: Enter SYS and SYSTEM user password. Step 10: Check OS groups for installation. Step 11: Check Prerequisite checks for 19c database installation. Step12: Check Summary.
ORACLE DATABASE WRITER BACKGROUND PROCESS Description:- In this article we are going to see Oracle Database Writer Background Process. Database writer process (DBWn) is an Oracle background process created when you start a database instance. Database writer process (DBWn) is a background process that writes buffers in the database buffer cache to data files. Database writer is one of the mandatory process.The task of dbwriter process ON-PREMISE RMAN BACKUP TO OBJECT STORAGE Check here Demo:- How to Backing Up A Database From On-Premise To Object Storage Using RMAN The Oracle Cloud provides for this purpose Object Storage, and we get 20GB for free forever. This storage is also being used when you want to make backups of the database, and use Datapump to export and import data. You can optionally use compression when backing up Oracle databases to Oracle ORACLE DATABASE 19C: HOW TO CREATE THE CONTAINER DATABASE Description:- In Oracle Database 12c Release 1 the concept of multitenant environment has been introduced. The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB) that includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and nonschema objects that VOTING DISK IN ORACLE RAC DATABASE Description:- In this article we are going to see Voting Disk In Oracle Rac Database concepts Oracle Clusterware uses voting disk files to determine which nodes are members of a cluster. You can configure voting disks on Oracle ASM, or you can configure voting disks on shared storage. If you do not configure voting disks on Oracle ASM, then for high availability, Oracle recommends that you ORACLE 19C DATABASE UPGRADE FROM 11.2.0.4 TO 19.2.0.0 Description:- A manual upgrade consists of running SQL scripts and utilities from a command line to upgrade a database to the new OracleDatabase release.
TO GET THE ORACLE TABLE SIZE AND INDEX SIZE To Get The Oracle Table size and index size. select segment_name, TABLESPACE _NAME ,segment_type, bytes/1024/1024/1024 size_gb from dba_segments where segment_name = ‘&segment_name’ or segment_name in (select index_name from dba_indexes where table_name=’&tablename’ and table_owner=’&owner’); scripts. ORACLE 19C-PERFORMING REINSTATING A FAILED PRIMARY Description:- If your former primary database was configured with Flashback Database, you can easily reinstate the failed primary database as a standby database of the new primary database. The failed primary database will be reinstated as a standby type that matches the old standby database. For example, if you failed over to a physical standby database, the old primary will be reinstated as QUERY TO FIND OUT THE DISK GROUP DETAILS IN RAC Conn as sqlplus '/ as sysasm' Query --------- set lines 255 col path for a35 col Diskgroup for a15 col DiskName for a20 col disk# for 999 col total_mb for 999,999,999 col free_mb for 999,999,999 compute sum of total_mb on DiskGroup compute sum of free_mb on DiskGroup break on DiskGroup skip 1 on report set pages 255 select a.name DiskGroup, b.disk_number Disk#, b.name DiskName, ORACLEDBWR | BY HARIPRASATH RAJARAM Find Application URL From Database and Context File in Oracle AppR12.2.
STEP BY STEP INSTALLING AND CONFIGURING ORACLE 19C Step:-2 Click Oracle RAC installation and next. Step:-3 Double check both nodes selected and next. Step:-4 Click EE and next. Step:-5 Check oracle base location and next. Step:-6 Check the group owners and next. Step:-7 Enter root password. Step:-8 We didn’t configured SCANip
ORACLE 12C ONLINE REDEFINITION TIPS AND TRICKS Table Online Redefinition :- Table fragmentation deteriorate the database performance, and the rate of fragmentation in a table greatly impacts response time. It's more likely get fragmented with high DML activity on table.These fragmentation effects operation on full table scans, instead of reading blocks with data it also reads empty blocks. The table online redefinition method doesn't need ORACLE 19C-STEP BY STEP MANUAL DATA GUARD SWITCHOVER Switchover Operation Procedure: After configuring data guard, databases would be either primary and standby database role, and we can altered these roles without loss of data or without resetting logs called Switchover. A database can be in one of two mutually exclusive modes (primary or standby). These roles can be altered at runtime without loss of data or resetting of redo logs. This ORACLE 19C – DISABLE FAST START FAILOVER IN DATAGUARD Description:-If the primary and target standby database have a network connection, use DISABLE FAST_START FAILOVER without the FORCE option to disable fast-start failover on all databases in the brokerconfiguration.
GENERATE DDL FOR ALL USERS # This script generate DDL for ALL USERS # ##### SCRIPT_NAME=”all_users_ddl” ORACLE 12C-2 NODE RAC TO SINGLE INSTANCE STANDBY DATABASE Steps for creating Single instance standby database from RAC primary database :- Change the archive log mode : $ sqlplus / as sysdba SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination +DG01 Oldest online log sequence 299300 Next log sequence to archive ORACLE19C-EXPORT DATA FROM PHYSICAL STANDBY DATABASE USING 1. Physical standby database should be in READ-ONLY MODE ( ACTIVE DATA GUARD) 2.We cannot run expdp directly on physical standby database. Because data pump job can be created only on a read-write database (OPEN). So to achieve this, we will use the NETWORK_LINK parameter and run the expdp job from any non-standby database (OPEN database) ORA-39173: ENCRYPTED DATA HAS BEEN STORED UNENCRYPTED IN $ expdp system/Chennai#123@pdb1 directory=TEST_DIR SCHEMAS=hr dumpfile=hr.dmp logfile=hr.log Export: Release 18.0.0.0.0 - Production on Sat Jun QUERY TO FIND OUT THE DISK GROUP DETAILS IN RAC Conn as sqlplus '/ as sysasm' Query --------- set lines 255 col path for a35 col Diskgroup for a15 col DiskName for a20 col disk# for 999 col total_mb for 999,999,999 col free_mb for 999,999,999 compute sum of total_mb on DiskGroup compute sum of free_mb on DiskGroup break on DiskGroup skip 1 on report set pages 255 select a.name DiskGroup, b.disk_number Disk#, b.name DiskName, ORACLEDBWR | BY HARIPRASATH RAJARAM Find Application URL From Database and Context File in Oracle AppR12.2.
STEP BY STEP INSTALLING AND CONFIGURING ORACLE 19C Step:-2 Click Oracle RAC installation and next. Step:-3 Double check both nodes selected and next. Step:-4 Click EE and next. Step:-5 Check oracle base location and next. Step:-6 Check the group owners and next. Step:-7 Enter root password. Step:-8 We didn’t configured SCANip
ORACLE 12C ONLINE REDEFINITION TIPS AND TRICKS Table Online Redefinition :- Table fragmentation deteriorate the database performance, and the rate of fragmentation in a table greatly impacts response time. It's more likely get fragmented with high DML activity on table.These fragmentation effects operation on full table scans, instead of reading blocks with data it also reads empty blocks. The table online redefinition method doesn't need ORACLE 19C-STEP BY STEP MANUAL DATA GUARD SWITCHOVER Switchover Operation Procedure: After configuring data guard, databases would be either primary and standby database role, and we can altered these roles without loss of data or without resetting logs called Switchover. A database can be in one of two mutually exclusive modes (primary or standby). These roles can be altered at runtime without loss of data or resetting of redo logs. This ORACLE 19C – DISABLE FAST START FAILOVER IN DATAGUARD Description:-If the primary and target standby database have a network connection, use DISABLE FAST_START FAILOVER without the FORCE option to disable fast-start failover on all databases in the brokerconfiguration.
GENERATE DDL FOR ALL USERS # This script generate DDL for ALL USERS # ##### SCRIPT_NAME=”all_users_ddl” ORACLE 12C-2 NODE RAC TO SINGLE INSTANCE STANDBY DATABASE Steps for creating Single instance standby database from RAC primary database :- Change the archive log mode : $ sqlplus / as sysdba SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination +DG01 Oldest online log sequence 299300 Next log sequence to archive ORACLE19C-EXPORT DATA FROM PHYSICAL STANDBY DATABASE USING 1. Physical standby database should be in READ-ONLY MODE ( ACTIVE DATA GUARD) 2.We cannot run expdp directly on physical standby database. Because data pump job can be created only on a read-write database (OPEN). So to achieve this, we will use the NETWORK_LINK parameter and run the expdp job from any non-standby database (OPEN database) ORA-39173: ENCRYPTED DATA HAS BEEN STORED UNENCRYPTED IN $ expdp system/Chennai#123@pdb1 directory=TEST_DIR SCHEMAS=hr dumpfile=hr.dmp logfile=hr.log Export: Release 18.0.0.0.0 - Production on Sat Jun QUERY TO FIND OUT THE DISK GROUP DETAILS IN RAC Conn as sqlplus '/ as sysasm' Query --------- set lines 255 col path for a35 col Diskgroup for a15 col DiskName for a20 col disk# for 999 col total_mb for 999,999,999 col free_mb for 999,999,999 compute sum of total_mb on DiskGroup compute sum of free_mb on DiskGroup break on DiskGroup skip 1 on report set pages 255 select a.name DiskGroup, b.disk_number Disk#, b.name DiskName, ORACLE 12C ONLINE REDEFINITION TIPS AND TRICKS Table Online Redefinition :- Table fragmentation deteriorate the database performance, and the rate of fragmentation in a table greatly impacts response time. It's more likely get fragmented with high DML activity on table.These fragmentation effects operation on full table scans, instead of reading blocks with data it also reads empty blocks. The table online redefinition method doesn't need STEP BY STEP ORACLE 19C INSTALLATION ON LINUX Step 6: Enter Database name. Step 7: Enter database file location. Step 8: Enable Archivelog mode option for database. Step 9: Enter SYS and SYSTEM user password. Step 10: Check OS groups for installation. Step 11: Check Prerequisite checks for 19c database installation. Step12: Check Summary.
ORACLE DATABASE WRITER BACKGROUND PROCESS Description:- In this article we are going to see Oracle Database Writer Background Process. Database writer process (DBWn) is an Oracle background process created when you start a database instance. Database writer process (DBWn) is a background process that writes buffers in the database buffer cache to data files. Database writer is one of the mandatory process.The task of dbwriter process ON-PREMISE RMAN BACKUP TO OBJECT STORAGE Check here Demo:- How to Backing Up A Database From On-Premise To Object Storage Using RMAN The Oracle Cloud provides for this purpose Object Storage, and we get 20GB for free forever. This storage is also being used when you want to make backups of the database, and use Datapump to export and import data. You can optionally use compression when backing up Oracle databases to Oracle ORACLE DATABASE 19C: HOW TO CREATE THE CONTAINER DATABASE Description:- In Oracle Database 12c Release 1 the concept of multitenant environment has been introduced. The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB) that includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and nonschema objects that VOTING DISK IN ORACLE RAC DATABASE Description:- In this article we are going to see Voting Disk In Oracle Rac Database concepts Oracle Clusterware uses voting disk files to determine which nodes are members of a cluster. You can configure voting disks on Oracle ASM, or you can configure voting disks on shared storage. If you do not configure voting disks on Oracle ASM, then for high availability, Oracle recommends that you ORACLE 19C DATABASE UPGRADE FROM 11.2.0.4 TO 19.2.0.0 Description:- A manual upgrade consists of running SQL scripts and utilities from a command line to upgrade a database to the new OracleDatabase release.
TO GET THE ORACLE TABLE SIZE AND INDEX SIZE To Get The Oracle Table size and index size. select segment_name, TABLESPACE _NAME ,segment_type, bytes/1024/1024/1024 size_gb from dba_segments where segment_name = ‘&segment_name’ or segment_name in (select index_name from dba_indexes where table_name=’&tablename’ and table_owner=’&owner’); scripts. ORACLE 19C-PERFORMING REINSTATING A FAILED PRIMARY Description:- If your former primary database was configured with Flashback Database, you can easily reinstate the failed primary database as a standby database of the new primary database. The failed primary database will be reinstated as a standby type that matches the old standby database. For example, if you failed over to a physical standby database, the old primary will be reinstated as QUERY TO FIND OUT THE DISK GROUP DETAILS IN RAC Conn as sqlplus '/ as sysasm' Query --------- set lines 255 col path for a35 col Diskgroup for a15 col DiskName for a20 col disk# for 999 col total_mb for 999,999,999 col free_mb for 999,999,999 compute sum of total_mb on DiskGroup compute sum of free_mb on DiskGroup break on DiskGroup skip 1 on report set pages 255 select a.name DiskGroup, b.disk_number Disk#, b.name DiskName, ORACLEDBWR | BY HARIPRASATH RAJARAM Find Application URL From Database and Context File in Oracle AppR12.2.
ORACLE 12C ONLINE REDEFINITION TIPS AND TRICKS Table Online Redefinition :- Table fragmentation deteriorate the database performance, and the rate of fragmentation in a table greatly impacts response time. It's more likely get fragmented with high DML activity on table.These fragmentation effects operation on full table scans, instead of reading blocks with data it also reads empty blocks. The table online redefinition method doesn't need STEP BY STEP INSTALLING AND CONFIGURING ORACLE 19C Step:-2 Click Oracle RAC installation and next. Step:-3 Double check both nodes selected and next. Step:-4 Click EE and next. Step:-5 Check oracle base location and next. Step:-6 Check the group owners and next. Step:-7 Enter root password. Step:-8 We didn’t configured SCANip
CHECK ORACLE ACTIVE AND INACTIVE SESSIONS Total Count of sessions select count(s.status) TOTAL_SESSIONS from gv$session s; Total Count of Inactive sessions select count(s.status) INACTIVE_SESSIONS from ORACLE 18C DATAPUMP-DIRECTORY PARAMETER DIRECTORY : Directory parameter is used for keeping dumpfiles and logfiles. Users running Data Pump operations are only able to read and write files in the directories that they have been granted access to. Before a user will be able to run a Data Pump operation, the administrator must pre-create a directory and grant privileges to the user on that directory. Unlike the non Data Pump version ORACLE 18C DATAPUMP-DATABASE LEVEL Oracle 18c Datapump-Database Level Description:- In this article we are going to see the Oracle 18c Datapump-Full Database level backup Syntax : expdp system/Chennai#123 directory=test_dir full=y dumpfile=full.dmp logfile=full.log Let's start the Demo: Pre-steps:-create a directory in the filesystem and creates a directory $ mkdir –p /u01/app/oracle/datapump[oracle@testdb
ORACLE 12C BACKGROUND PROCESS-LREG (LISTENER REGISTRATION LREG (Listener Registration Process) :- LREG (Listener Registration) is an Oracle background process created when you start an Oracle 12c or higher database instance. This function was handled by the PMON process in earlier releases.It registers the instance with the listeners. The Listener Registration process attempts register the information about the database instance and services if the ORACLE 19C – DISABLE FAST START FAILOVER IN DATAGUARD Description:-If the primary and target standby database have a network connection, use DISABLE FAST_START FAILOVER without the FORCE option to disable fast-start failover on all databases in the brokerconfiguration.
ORACLE 19C DATABASE UPGRADE FROM 11.2.0.4 TO 19.2.0.0 Description:- A manual upgrade consists of running SQL scripts and utilities from a command line to upgrade a database to the new OracleDatabase release.
ORACLE19C-EXPORT DATA FROM PHYSICAL STANDBY DATABASE USING 1. Physical standby database should be in READ-ONLY MODE ( ACTIVE DATA GUARD) 2.We cannot run expdp directly on physical standby database. Because data pump job can be created only on a read-write database (OPEN). So to achieve this, we will use the NETWORK_LINK parameter and run the expdp job from any non-standby database (OPEN database) ORACLEDBWR | BY HARIPRASATH RAJARAM Find Application URL From Database and Context File in Oracle AppR12.2.
ORACLE 12C ONLINE REDEFINITION TIPS AND TRICKS Table Online Redefinition :- Table fragmentation deteriorate the database performance, and the rate of fragmentation in a table greatly impacts response time. It's more likely get fragmented with high DML activity on table.These fragmentation effects operation on full table scans, instead of reading blocks with data it also reads empty blocks. The table online redefinition method doesn't need STEP BY STEP INSTALLING AND CONFIGURING ORACLE 19C Step:-2 Click Oracle RAC installation and next. Step:-3 Double check both nodes selected and next. Step:-4 Click EE and next. Step:-5 Check oracle base location and next. Step:-6 Check the group owners and next. Step:-7 Enter root password. Step:-8 We didn’t configured SCANip
CHECK ORACLE ACTIVE AND INACTIVE SESSIONS Total Count of sessions select count(s.status) TOTAL_SESSIONS from gv$session s; Total Count of Inactive sessions select count(s.status) INACTIVE_SESSIONS from ORACLE 18C DATAPUMP-DIRECTORY PARAMETER DIRECTORY : Directory parameter is used for keeping dumpfiles and logfiles. Users running Data Pump operations are only able to read and write files in the directories that they have been granted access to. Before a user will be able to run a Data Pump operation, the administrator must pre-create a directory and grant privileges to the user on that directory. Unlike the non Data Pump version ORACLE 18C DATAPUMP-DATABASE LEVEL Oracle 18c Datapump-Database Level Description:- In this article we are going to see the Oracle 18c Datapump-Full Database level backup Syntax : expdp system/Chennai#123 directory=test_dir full=y dumpfile=full.dmp logfile=full.log Let's start the Demo: Pre-steps:-create a directory in the filesystem and creates a directory $ mkdir –p /u01/app/oracle/datapump[oracle@testdb
ORACLE 12C BACKGROUND PROCESS-LREG (LISTENER REGISTRATION LREG (Listener Registration Process) :- LREG (Listener Registration) is an Oracle background process created when you start an Oracle 12c or higher database instance. This function was handled by the PMON process in earlier releases.It registers the instance with the listeners. The Listener Registration process attempts register the information about the database instance and services if the ORACLE 19C – DISABLE FAST START FAILOVER IN DATAGUARD Description:-If the primary and target standby database have a network connection, use DISABLE FAST_START FAILOVER without the FORCE option to disable fast-start failover on all databases in the brokerconfiguration.
ORACLE 19C DATABASE UPGRADE FROM 11.2.0.4 TO 19.2.0.0 Description:- A manual upgrade consists of running SQL scripts and utilities from a command line to upgrade a database to the new OracleDatabase release.
ORACLE19C-EXPORT DATA FROM PHYSICAL STANDBY DATABASE USING 1. Physical standby database should be in READ-ONLY MODE ( ACTIVE DATA GUARD) 2.We cannot run expdp directly on physical standby database. Because data pump job can be created only on a read-write database (OPEN). So to achieve this, we will use the NETWORK_LINK parameter and run the expdp job from any non-standby database (OPEN database) ORACLE DATABASE WRITER BACKGROUND PROCESS Description:- In this article we are going to see Oracle Database Writer Background Process. Database writer process (DBWn) is an Oracle background process created when you start a database instance. Database writer process (DBWn) is a background process that writes buffers in the database buffer cache to data files. Database writer is one of the mandatory process.The task of dbwriter process UNDERSTANDING ORACLE SYSTEM TABLESPACE From Oracle 10g, the smallest Oracle database is two tablespaces. This applies to Oracle 11g. SYSTEM – stores the data dictionary. SYSAUX – stores data for auxiliary applications (sysaux page link). In reality, a typical production database has numerous tablespaces. These include SYSTEM and NON-SYSTEM tablespaces. SYSTEM – a tablespace that is always used to store SYSTEM data that ORACLE 19C DATABASE UPGRADE FROM 11.2.0.4 TO 19.2.0.0 Description:- A manual upgrade consists of running SQL scripts and utilities from a command line to upgrade a database to the new OracleDatabase release.
WHAT IS ANISBLE?
Ansible is an open source automation platform. It is very, very simple to setup and yet powerful. Ansible can help you with configuration management, application deployment, task automation. Ansible is an open-source IT automation engine which can remove drudgery from your work life, and will also dramatically improve the scalability, consistency, and reliability of your IT environment. It can ORACLE 18C DATAPUMP-DIRECTORY PARAMETER DIRECTORY : Directory parameter is used for keeping dumpfiles and logfiles. Users running Data Pump operations are only able to read and write files in the directories that they have been granted access to. Before a user will be able to run a Data Pump operation, the administrator must pre-create a directory and grant privileges to the user on that directory. Unlike the non Data Pump version ORACLE DATABASE 19C: HOW TO CREATE THE CONTAINER DATABASE Description:- In Oracle Database 12c Release 1 the concept of multitenant environment has been introduced. The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB) that includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and nonschema objects that GENERATE DDL FOR ALL USERS # This script generate DDL for ALL USERS # ##### SCRIPT_NAME=”all_users_ddl” HEALTH CHECKS FOR THE ORACLE STACK USING ORACHK Pre check: #./orachk -u -o pre This version of orachk was released on 26-May-2016 and its older than 120 days. No new version of orachk is available in RAT_UPGRADE_LOC. It is highly recommended that you download the latest version of orachk from my oracle support to ensure the highest level of accuracy of the data contained within the report. ORACLE 19C STEP BY STEP TO CONFIGURE DATA GUARD PHYSICAL Description:- In this article we are going to see step by Step to configure Oracle 19c Data Guard Physical Standby The environment is single instance database. Environment Details:- Primary Server side Configurations:- Step1:-Change Archivelog mode and force logging mode $ export ORACLE_SID=chennai $ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 ORACLE 18C DATAPUMP-FILESIZE PARAMETER FILESIZE : It specifies the maximum size of each dump file. If the size is reached for any member of the dump file set, that file is closed and an attempt is made to create a new file, if the file specification contains a substitution variable. You can set filesize parameter limits for the dumpfile size same as below,[FILESIZE=integer where B is bytes, K is KB, M isMB and G is
ORACLEDBWR | BY HARIPRASATH RAJARAM Find Application URL From Database and Context File in Oracle AppR12.2.
ORACLE 12C ONLINE REDEFINITION TIPS AND TRICKS Table Online Redefinition :- Table fragmentation deteriorate the database performance, and the rate of fragmentation in a table greatly impacts response time. It's more likely get fragmented with high DML activity on table.These fragmentation effects operation on full table scans, instead of reading blocks with data it also reads empty blocks. The table online redefinition method doesn't need STEP BY STEP INSTALLING AND CONFIGURING ORACLE 19C Step:-2 Click Oracle RAC installation and next. Step:-3 Double check both nodes selected and next. Step:-4 Click EE and next. Step:-5 Check oracle base location and next. Step:-6 Check the group owners and next. Step:-7 Enter root password. Step:-8 We didn’t configured SCANip
CHECK ORACLE ACTIVE AND INACTIVE SESSIONS Total Count of sessions select count(s.status) TOTAL_SESSIONS from gv$session s; Total Count of Inactive sessions select count(s.status) INACTIVE_SESSIONS from ORACLE 18C DATAPUMP-DIRECTORY PARAMETER DIRECTORY : Directory parameter is used for keeping dumpfiles and logfiles. Users running Data Pump operations are only able to read and write files in the directories that they have been granted access to. Before a user will be able to run a Data Pump operation, the administrator must pre-create a directory and grant privileges to the user on that directory. Unlike the non Data Pump version ORACLE 18C DATAPUMP-DATABASE LEVEL Oracle 18c Datapump-Database Level Description:- In this article we are going to see the Oracle 18c Datapump-Full Database level backup Syntax : expdp system/Chennai#123 directory=test_dir full=y dumpfile=full.dmp logfile=full.log Let's start the Demo: Pre-steps:-create a directory in the filesystem and creates a directory $ mkdir –p /u01/app/oracle/datapump[oracle@testdb
ORACLE 12C BACKGROUND PROCESS-LREG (LISTENER REGISTRATION LREG (Listener Registration Process) :- LREG (Listener Registration) is an Oracle background process created when you start an Oracle 12c or higher database instance. This function was handled by the PMON process in earlier releases.It registers the instance with the listeners. The Listener Registration process attempts register the information about the database instance and services if the ORACLE 19C – DISABLE FAST START FAILOVER IN DATAGUARDORACLE 19C CLIENTORACLE 19C DOCUMENTATIONORACLE 19C NEW FEATURES PDFORACLE 19CVERSION NUMBER
Description:-If the primary and target standby database have a network connection, use DISABLE FAST_START FAILOVER without the FORCE option to disable fast-start failover on all databases in the brokerconfiguration.
ORACLE 19C DATABASE UPGRADE FROM 11.2.0.4 TO 19.2.0.0 Description:- A manual upgrade consists of running SQL scripts and utilities from a command line to upgrade a database to the new OracleDatabase release.
ORACLE19C-EXPORT DATA FROM PHYSICAL STANDBY DATABASE USING 1. Physical standby database should be in READ-ONLY MODE ( ACTIVE DATA GUARD) 2.We cannot run expdp directly on physical standby database. Because data pump job can be created only on a read-write database (OPEN). So to achieve this, we will use the NETWORK_LINK parameter and run the expdp job from any non-standby database (OPEN database) ORACLEDBWR | BY HARIPRASATH RAJARAM Find Application URL From Database and Context File in Oracle AppR12.2.
ORACLE 12C ONLINE REDEFINITION TIPS AND TRICKS Table Online Redefinition :- Table fragmentation deteriorate the database performance, and the rate of fragmentation in a table greatly impacts response time. It's more likely get fragmented with high DML activity on table.These fragmentation effects operation on full table scans, instead of reading blocks with data it also reads empty blocks. The table online redefinition method doesn't need STEP BY STEP INSTALLING AND CONFIGURING ORACLE 19C Step:-2 Click Oracle RAC installation and next. Step:-3 Double check both nodes selected and next. Step:-4 Click EE and next. Step:-5 Check oracle base location and next. Step:-6 Check the group owners and next. Step:-7 Enter root password. Step:-8 We didn’t configured SCANip
CHECK ORACLE ACTIVE AND INACTIVE SESSIONS Total Count of sessions select count(s.status) TOTAL_SESSIONS from gv$session s; Total Count of Inactive sessions select count(s.status) INACTIVE_SESSIONS from ORACLE 18C DATAPUMP-DIRECTORY PARAMETER DIRECTORY : Directory parameter is used for keeping dumpfiles and logfiles. Users running Data Pump operations are only able to read and write files in the directories that they have been granted access to. Before a user will be able to run a Data Pump operation, the administrator must pre-create a directory and grant privileges to the user on that directory. Unlike the non Data Pump version ORACLE 18C DATAPUMP-DATABASE LEVEL Oracle 18c Datapump-Database Level Description:- In this article we are going to see the Oracle 18c Datapump-Full Database level backup Syntax : expdp system/Chennai#123 directory=test_dir full=y dumpfile=full.dmp logfile=full.log Let's start the Demo: Pre-steps:-create a directory in the filesystem and creates a directory $ mkdir –p /u01/app/oracle/datapump[oracle@testdb
ORACLE 12C BACKGROUND PROCESS-LREG (LISTENER REGISTRATION LREG (Listener Registration Process) :- LREG (Listener Registration) is an Oracle background process created when you start an Oracle 12c or higher database instance. This function was handled by the PMON process in earlier releases.It registers the instance with the listeners. The Listener Registration process attempts register the information about the database instance and services if the ORACLE 19C – DISABLE FAST START FAILOVER IN DATAGUARDORACLE 19C CLIENTORACLE 19C DOCUMENTATIONORACLE 19C NEW FEATURES PDFORACLE 19CVERSION NUMBER
Description:-If the primary and target standby database have a network connection, use DISABLE FAST_START FAILOVER without the FORCE option to disable fast-start failover on all databases in the brokerconfiguration.
ORACLE 19C DATABASE UPGRADE FROM 11.2.0.4 TO 19.2.0.0 Description:- A manual upgrade consists of running SQL scripts and utilities from a command line to upgrade a database to the new OracleDatabase release.
ORACLE19C-EXPORT DATA FROM PHYSICAL STANDBY DATABASE USING 1. Physical standby database should be in READ-ONLY MODE ( ACTIVE DATA GUARD) 2.We cannot run expdp directly on physical standby database. Because data pump job can be created only on a read-write database (OPEN). So to achieve this, we will use the NETWORK_LINK parameter and run the expdp job from any non-standby database (OPEN database) ORACLE DATABASE WRITER BACKGROUND PROCESS Description:- In this article we are going to see Oracle Database Writer Background Process. Database writer process (DBWn) is an Oracle background process created when you start a database instance. Database writer process (DBWn) is a background process that writes buffers in the database buffer cache to data files. Database writer is one of the mandatory process.The task of dbwriter process UNDERSTANDING ORACLE SYSTEM TABLESPACE From Oracle 10g, the smallest Oracle database is two tablespaces. This applies to Oracle 11g. SYSTEM – stores the data dictionary. SYSAUX – stores data for auxiliary applications (sysaux page link). In reality, a typical production database has numerous tablespaces. These include SYSTEM and NON-SYSTEM tablespaces. SYSTEM – a tablespace that is always used to store SYSTEM data that ORACLE 19C DATABASE UPGRADE FROM 11.2.0.4 TO 19.2.0.0 Description:- A manual upgrade consists of running SQL scripts and utilities from a command line to upgrade a database to the new OracleDatabase release.
WHAT IS ANISBLE?
Ansible is an open source automation platform. It is very, very simple to setup and yet powerful. Ansible can help you with configuration management, application deployment, task automation. Ansible is an open-source IT automation engine which can remove drudgery from your work life, and will also dramatically improve the scalability, consistency, and reliability of your IT environment. It can ORACLE 18C DATAPUMP-DIRECTORY PARAMETER DIRECTORY : Directory parameter is used for keeping dumpfiles and logfiles. Users running Data Pump operations are only able to read and write files in the directories that they have been granted access to. Before a user will be able to run a Data Pump operation, the administrator must pre-create a directory and grant privileges to the user on that directory. Unlike the non Data Pump version ORACLE DATABASE 19C: HOW TO CREATE THE CONTAINER DATABASE Description:- In Oracle Database 12c Release 1 the concept of multitenant environment has been introduced. The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB) that includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and nonschema objects that GENERATE DDL FOR ALL USERS # This script generate DDL for ALL USERS # ##### SCRIPT_NAME=”all_users_ddl” HEALTH CHECKS FOR THE ORACLE STACK USING ORACHK Pre check: #./orachk -u -o pre This version of orachk was released on 26-May-2016 and its older than 120 days. No new version of orachk is available in RAT_UPGRADE_LOC. It is highly recommended that you download the latest version of orachk from my oracle support to ensure the highest level of accuracy of the data contained within the report. ORACLE 19C STEP BY STEP TO CONFIGURE DATA GUARD PHYSICAL Description:- In this article we are going to see step by Step to configure Oracle 19c Data Guard Physical Standby The environment is single instance database. Environment Details:- Primary Server side Configurations:- Step1:-Change Archivelog mode and force logging mode $ export ORACLE_SID=chennai $ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 ORACLE 18C DATAPUMP-FILESIZE PARAMETER FILESIZE : It specifies the maximum size of each dump file. If the size is reached for any member of the dump file set, that file is closed and an attempt is made to create a new file, if the file specification contains a substitution variable. You can set filesize parameter limits for the dumpfile size same as below,[FILESIZE=integer where B is bytes, K is KB, M isMB and G is
ORACLEDBWR | BY HARIPRASATH RAJARAMHow to resolve
ORACLE 12C ONLINE REDEFINITION TIPS AND TRICKS Table Online Redefinition :- Table fragmentation deteriorate the database performance, and the rate of fragmentation in a table greatly impacts response time. It's more likely get fragmented with high DML activity on table.These fragmentation effects operation on full table scans, instead of reading blocks with data it also reads empty blocks. The table online redefinition method doesn't need CHECK ORACLE ACTIVE AND INACTIVE SESSIONS Total Count of sessions select count(s.status) TOTAL_SESSIONS from gv$session s; Total Count of Inactive sessions select count(s.status) INACTIVE_SESSIONS from ORACLE 18C DATAPUMP-DIRECTORY PARAMETER DIRECTORY : Directory parameter is used for keeping dumpfiles and logfiles. Users running Data Pump operations are only able to read and write files in the directories that they have been granted access to. Before a user will be able to run a Data Pump operation, the administrator must pre-create a directory and grant privileges to the user on that directory. Unlike the non Data Pump version ORACLE 18C DATAPUMP-DATABASE LEVEL Oracle 18c Datapump-Database Level Description:- In this article we are going to see the Oracle 18c Datapump-Full Database level backup Syntax : expdp system/Chennai#123 directory=test_dir full=y dumpfile=full.dmp logfile=full.log Let's start the Demo: Pre-steps:-create a directory in the filesystem and creates a directory $ mkdir –p /u01/app/oracle/datapump[oracle@testdb
STEP BY STEP INSTALLING AND CONFIGURING ORACLE 19C Description:- In this article we are going to see Step by Step Installing And Configuring Oracle 19c Binaries for Rac Database Demo:- Install the Oracle 19c ORACLE 12C BACKGROUND PROCESS-LREG (LISTENER REGISTRATION LREG (Listener Registration Process) :- LREG (Listener Registration) is an Oracle background process created when you start an Oracle 12c or higher database instance. This function was handled by the PMON process in earlier releases.It registers the instance with the listeners. The Listener Registration process attempts register the information about the database instance and services if the ORACLE 19C – DISABLE FAST START FAILOVER IN DATAGUARDORACLE 19C CLIENTORACLE 19C DOCUMENTATIONORACLE 19C NEW FEATURES PDFORACLE 19CVERSION NUMBER
Description:-If the primary and target standby database have a network connection, use DISABLE FAST_START FAILOVER without the FORCE option to disable fast-start failover on all databases in the brokerconfiguration.
ORACLE 19C DATABASE UPGRADE FROM 11.2.0.4 TO 19.2.0.0 Description:- A manual upgrade consists of running SQL scripts and utilities from a command line to upgrade a database to the new OracleDatabase release.
ORACLE19C-EXPORT DATA FROM PHYSICAL STANDBY DATABASE USING Description:- 1. Physical standby database should be in READ-ONLY MODE (ACTIVE DATA GUARD) 2.We cannot run expdp directly on physical standbydatabase. Because
ORACLEDBWR | BY HARIPRASATH RAJARAMHow to resolve
ORACLE 12C ONLINE REDEFINITION TIPS AND TRICKS Table Online Redefinition :- Table fragmentation deteriorate the database performance, and the rate of fragmentation in a table greatly impacts response time. It's more likely get fragmented with high DML activity on table.These fragmentation effects operation on full table scans, instead of reading blocks with data it also reads empty blocks. The table online redefinition method doesn't need CHECK ORACLE ACTIVE AND INACTIVE SESSIONS Total Count of sessions select count(s.status) TOTAL_SESSIONS from gv$session s; Total Count of Inactive sessions select count(s.status) INACTIVE_SESSIONS from ORACLE 18C DATAPUMP-DIRECTORY PARAMETER DIRECTORY : Directory parameter is used for keeping dumpfiles and logfiles. Users running Data Pump operations are only able to read and write files in the directories that they have been granted access to. Before a user will be able to run a Data Pump operation, the administrator must pre-create a directory and grant privileges to the user on that directory. Unlike the non Data Pump version ORACLE 18C DATAPUMP-DATABASE LEVEL Oracle 18c Datapump-Database Level Description:- In this article we are going to see the Oracle 18c Datapump-Full Database level backup Syntax : expdp system/Chennai#123 directory=test_dir full=y dumpfile=full.dmp logfile=full.log Let's start the Demo: Pre-steps:-create a directory in the filesystem and creates a directory $ mkdir –p /u01/app/oracle/datapump[oracle@testdb
STEP BY STEP INSTALLING AND CONFIGURING ORACLE 19C Description:- In this article we are going to see Step by Step Installing And Configuring Oracle 19c Binaries for Rac Database Demo:- Install the Oracle 19c ORACLE 12C BACKGROUND PROCESS-LREG (LISTENER REGISTRATION LREG (Listener Registration Process) :- LREG (Listener Registration) is an Oracle background process created when you start an Oracle 12c or higher database instance. This function was handled by the PMON process in earlier releases.It registers the instance with the listeners. The Listener Registration process attempts register the information about the database instance and services if the ORACLE 19C – DISABLE FAST START FAILOVER IN DATAGUARDORACLE 19C CLIENTORACLE 19C DOCUMENTATIONORACLE 19C NEW FEATURES PDFORACLE 19CVERSION NUMBER
Description:-If the primary and target standby database have a network connection, use DISABLE FAST_START FAILOVER without the FORCE option to disable fast-start failover on all databases in the brokerconfiguration.
ORACLE 19C DATABASE UPGRADE FROM 11.2.0.4 TO 19.2.0.0 Description:- A manual upgrade consists of running SQL scripts and utilities from a command line to upgrade a database to the new OracleDatabase release.
ORACLE19C-EXPORT DATA FROM PHYSICAL STANDBY DATABASE USING Description:- 1. Physical standby database should be in READ-ONLY MODE (ACTIVE DATA GUARD) 2.We cannot run expdp directly on physical standbydatabase. Because
ORACLE DATABASE WRITER BACKGROUND PROCESS Description:- In this article we are going to see Oracle Database Writer Background Process. Database writer process (DBWn) is an Oracle background process created when you start a database instance. Database writer process (DBWn) is a background process that writes buffers in the database buffer cache to data files. Database writer is one of the mandatory process.The task of dbwriter process UNDERSTANDING ORACLE SYSTEM TABLESPACE From Oracle 10g, the smallest Oracle database is two tablespaces. This applies to Oracle 11g. SYSTEM – stores the data dictionary. SYSAUX – stores data for auxiliary applications (sysaux page link). In reality, a typical production database has numerous tablespaces. These include SYSTEM and NON-SYSTEM tablespaces. SYSTEM – a tablespace that is always used to store SYSTEM data that ORACLE 18C DATAPUMP-DIRECTORY PARAMETER DIRECTORY : Directory parameter is used for keeping dumpfiles and logfiles. Users running Data Pump operations are only able to read and write files in the directories that they have been granted access to. Before a user will be able to run a Data Pump operation, the administrator must pre-create a directory and grant privileges to the user on that directory. Unlike the non Data Pump version ORACLE 19C DATABASE UPGRADE FROM 11.2.0.4 TO 19.2.0.0 Description:- A manual upgrade consists of running SQL scripts and utilities from a command line to upgrade a database to the new OracleDatabase release.
WHAT IS ANISBLE?
Ansible is an open source automation platform. It is very, very simple to setup and yet powerful. Ansible can help you with configuration management, application deployment, task automation. Ansible is an open-source IT automation engine which can remove drudgery from your work life, and will also dramatically improve the scalability, consistency, and reliability of your IT environment. It can ORACLE DATABASE 19C: HOW TO CREATE THE CONTAINER DATABASE Description:- In Oracle Database 12c Release 1 the concept of multitenant environment has been introduced. The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB) that includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and nonschema objects that GENERATE DDL FOR ALL USERS # This script generate DDL for ALL USERS # ##### SCRIPT_NAME=”all_users_ddl” HEALTH CHECKS FOR THE ORACLE STACK USING ORACHK Pre check: #./orachk -u -o pre This version of orachk was released on 26-May-2016 and its older than 120 days. No new version of orachk is available in RAT_UPGRADE_LOC. It is highly recommended that you download the latest version of orachk from my oracle support to ensure the highest level of accuracy of the data contained within the report. ORACLE 19C STEP BY STEP TO CONFIGURE DATA GUARD PHYSICAL Description:- In this article we are going to see step by Step to configure Oracle 19c Data Guard Physical Standby The environment is single instance database. Environment Details:- Primary Server side Configurations:- Step1:-Change Archivelog mode and force logging mode $ export ORACLE_SID=chennai $ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 ORACLE 18C DATAPUMP-FILESIZE PARAMETER FILESIZE : It specifies the maximum size of each dump file. If the size is reached for any member of the dump file set, that file is closed and an attempt is made to create a new file, if the file specification contains a substitution variable. You can set filesize parameter limits for the dumpfile size same as below,[FILESIZE=integer where B is bytes, K is KB, M isMB and G is
__
* About Me
* Conferences/UsersGroup* My Photos
__
* Database
* 19c database
* 18c Database
* 12cR2 database
* 11g Database
__
* Rac
* 11g Rac
* 12c Rac
__
* Asm
* 12c Asm
* 11g Asm
__
* Dataguard
* 19c Dataguard
* 18c Dataguard
* 12c Dataguard
* 11g Dataguard
__
* Multitenant
* 19c Multitenant
* 18c Multitenant
* 12c Multitenant
__
* Upgrade
* 19c upgrade
* 18c upgrade
* 12c upgrade
__
* Datapump
* 19c Datapump
* 18c Datapump
__
* Oracle Cloud
* AutonomousDB
__ * Ansible
* Tuning
__
__ __
__
__
__
* About Me
* Conferences/UsersGroup* My Photos
* Database
* 19c database
* 18c Database
* 12cR2 database
* 11g Database
* Rac
* 11g Rac
* 12c Rac
* Asm
* 12c Asm
* 11g Asm
* Dataguard
* 19c Dataguard
* 18c Dataguard
* 12c Dataguard
* 11g Dataguard
* Multitenant
* 19c Multitenant
* 18c Multitenant
* 12c Multitenant
* Upgrade
* 19c upgrade
* 18c upgrade
* 12c upgrade
* Datapump
* 19c Datapump
* 18c Datapump
* Oracle Cloud
* AutonomousDB
* Ansible
* Tuning
__
__
* About Me
* Conferences/UsersGroup* My Photos
* Database
* 19c database
* 18c Database
* 12cR2 database
* 11g Database
* Rac
* 11g Rac
* 12c Rac
* Asm
* 12c Asm
* 11g Asm
* Dataguard
* 19c Dataguard
* 18c Dataguard
* 12c Dataguard
* 11g Dataguard
* Multitenant
* 19c Multitenant
* 18c Multitenant
* 12c Multitenant
* Upgrade
* 19c upgrade
* 18c upgrade
* 12c upgrade
* Datapump
* 19c Datapump
* 18c Datapump
* Oracle Cloud
* AutonomousDB
* Ansible
* Tuning
__
__
DEINSTALLATION RELEASE UPDATE PATCH ON ORACLE 19C (PATCH 29834717) APPLY PATCHING ON ORACLE 19C DATABASE RELEASE UPDATE 19.4.0.0.0 CLONING ORACLE 19C PDBS USING DBCA IN SILENT MODE 3 PDBS AT ORACLE 19C WITHOUT A MULTITENANT LICENSE ORACLE 19C NEW DATABASE PARAMETER (MAX_DATAPUMP_PARALLEL_PER_JOB) ORACLE 19C NEW DATABASE PARAMETER (MAX_DATAPUMP_JOBS_PER_PDB) ORACLE DIAGNOSTIC TOOLS ORACLE 18C NEW INITIALIZATION PARAMETERS ORACLE STREAMS APPLY PROCESS IS SLOW ON GOLDENGATE INTEGRATEDREPLICAT:
REPLICAT ABENDING WITH MAPPING ERROR AND DISCARD FILE SHOWS MISSINGKEY COLUMNS
ORACLE 18C NEW FEATURE – FINDING DATABASE VERSION USING ORAVERSIONUTILITY
ORACLE19C-RESTORE USING RMAN TO CREATE ORACLE 19C DATABASE ON SCRATCHSERVER
ORACLE19C-USING RMAN INCREMENTAL BACKUPS TO REFRESH STANDBY DATABASE ORACLE19C-EXPORT DATA FROM PHYSICAL STANDBY DATABASE USING DATAPUMP ORACLE RAC INTERVIEW QUESTIONS ORACLE-19C RECOVER A LOSS OF ALL ONLINE REDO LOG FILES USING RMAN ORACLE DATABASE 18C (18.3.0) UPGRADE AND MIGRATION HANDS-ON LAB ORACLE 19C RPM BASED INSTALLATION AND DATABASE ORACLE 19C-CREATING NON-CDB DATABASE IN SILENT MODE ORACLE 19C-CONVERT PHYSICAL STANDBY TO ACTIVE DATAGUARD ORACLE 19C DEINSTALL DATABASE ORACLE 19C-CONVERT PHYSICAL STANDBY TO SNAPSHOT STANDBY STEP BY STEP TO CONFIGURE ORACLE 19C DATA GUARD PHYSICAL STANDBY ORACLE DATABASE 19C: HOW TO CREATE THE CONTAINER DATABASE CREATING DATABASE USING DBCA IN ORACLE 19C ORACLE 19C – RESTORE A LOSS OF CONTROLFILE USING AUTOBACKUP ORACLE 19C – RECOVERING DATAFILE WITHOUT RMAN BACKUP ORACLE19C – RMAN RECOVERY THROUGH RESETLOGS ORACLE 19C – TABLE RECOVERY USING RMAN BACKUP MANUALLY CREATING AN ORACLE 19C DATABASE ORACLE 19C-RMAN PERFORMANCE OF BLOCK CHANGE TRACKING (BCT) HOW TO CHANGE ARCHIVELOG MODE AND DESTINATION IN ORACLE 19C ORACLE 19C-POINT IN TIME RECOVERY USING RMAN DATA RECOVERY ADVISOR IN ORACLE DATABASE 19C STEP BY STEP ORACLE 19C INSTALLATION ON LINUX ORACLE DATABASE 19C NOW AVAILABLE ON LINUX ORACLE 19C DATABASE CLONING USING HOT BACKUP DUPLICATE A DATABASE USING RMAN IN ORACLE DATABASE 19C RELEASE ORACLE 19C DATABASE UPGRADE FROM 11.2.0.4 TO 19.2.0.0 USING DBUA STEP BY STEP TO CONFIGURE ORACLE 19C DATA GUARD PHYSICAL STANDBY ORACLE 19C-STEP BY STEP MANUAL DATA GUARD SWITCHOVER ORACLE GATHER STATS FOR A TABLE ORACLE SCHEMA GATHER STATS ORACLE ARCHIVELOG GENERATION PER HOUR ORACLE DATABASE SIZE GET DDL OF ALL TABLESPACES ORACLE 19C-STEP BY STEP MANUAL DATA GUARD FAILOVER ORACLE 19C-STEP BY STEP CONFIGURE SNAPSHOT STANDBY DATABASE ORACLE 18C DATABASE UPGRADE FROM 12.2.0.1 TO 18.3.0.0 USING DBUA ORACLE 19C DATABASE UPGRADE FROM 11.2.0.4 TO 19.2.0.0 USING MANUALMETHOD
POSTS NAVIGATION
1 2 3
… 9
Next
SEARCH
CATEGORIES
* Ansible (6)
* Asm (2)
* 11g Asm (2)
* AutonomousDB (10) * Conferences/UsersGroup(10)
* Database (93)
* 11g Database
(15)
* 12cR2 database
(37)
* 18c Database
(33)
* 19c database
(22)
* Dataguard (42)
* 11g Dataguard
(10)
* 12c Dataguard
(16)
* 18c Dataguard
(9)
* 19c Dataguard
(8)
* Datapump (65)
* 18c Datapump
(63)
* 19c Datapump
(2)
* General (1)
* Goldengate (13)
* Migration (4)
* Multitenant (29)
* 12c Multitenant
(21)
* 18c Multitenant
(6)
* 19c Multitenant
(2)
* My Photos (3)
* OEM (2)
* Ora-Errors (12)
* Oracle APEX (2)
* Oracle Cloud (17)* OS Installation
(1)
* Patching (8)
* Rac (21)
* 11g Rac (13)
* 12c Rac (11)
* Rman (24)
* 12c Rman
(5)
* 18c Rman
(12)
* 19c Rman
(9)
* Scripts (56)
* Tuning (16)
* Uncategorized (2)* Upgrade (18)
* 12c upgrade
(4)
* 18c upgrade
(11)
* 19c upgrade
(3)
ARCHIVES
Archives Select Month October 2019 (4) September 2019 (3) August 2019 (4) July 2019 (10) June 2019 (4) May 2019 (10) April 2019 (3) March 2019 (13) February 2019 (23) January 2019 (34) December 2018 (22) November 2018 (31) October 2018 (37) September 2018 (7) August 2018 (75) July 2018 (30) June 2018 (73) May 2018 (25)TAGS
11g database 11g Datapump12c database
12c Rac
18c
18c database
19c
19c database
19c dataguard
19c rman
aioug
ansible
Asm
Autonomous
cdb
chennai chapter
cloning
Cloud
conference
cross platform
database
datafiles
Dataguard
Datapump
dbca
Goldengate
Installation
migration
Multitenant
Ora-Errors
oracle 19c
oracle19c
oracle rman
Patching
pdb
Rac
Rman
scripts
sysaux
system
table
Tablespaces
Tuning
upgrade
windows
TRENDING NOW
RECENT POSTS
* Deinstallation Release Update Patch on oracle 19c (Patch 29834717) * Apply Patching On Oracle 19c Database Release Update 19.4.0.0.0 * Cloning Oracle 19c PDBs Using DBCA in Silent Mode * 3 PDBs at Oracle 19c without a Multitenant license * Oracle 19c New Database Parameter (MAX_DATAPUMP_PARALLEL_PER_JOB)GET UPDATED
__ __
__
__
__ __
__
__
2019 Oracledbwr - All Rights Reserved.__
* __
* __
* __
* __
* __
Generic selectors
Exact matches only
Exact matches only
Search in title
Search in title
Search in content
Search in content
Search in excerpt
Search in posts
Search in posts
Search in pages
Search in pages
Scroll up the results Scroll down the resultsMore results...
Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0