ocptechnology - Tumblr blog

[ocptechnology]

scripts

blwt set lines 400 pages 600 select sid,/*+RULE*/ DECODE(request,0,'HOLDER: ','Waiter: ')||sid sess,inst_id,id1,id2,lmode,request,type from gv$lock where (id1,id2,type) IN (select /*+RULE*/ id1,id2,type from gv$lock where request>0) order by id1, request / ap select * from table(dbms_xplan.display_cursor('&sqlid',&child)) / ev set lines 400 pages 400 select…

[ocptechnology]

test

THis is a test product

[ocptechnology]

Oracle 23c installation on Linux

Here we will learn Oracle 23c installation on Linux step by step. In this article we will also learn how to Create and Configure Oracle Database instead of DBCA. Software Used In this practice, we are using the following software: VirtualBox 7.0 We are using Oracle Linux 8.4 Oracle Database 23c Free System Requirements The system should be configured as per the below…

[ocptechnology]

Export from 11g and import to 19c

In this article, we are going to learn how to export from 11g and import to 19c. As you know the Oracle DATA PUMP is a very powerful tool and using the Export and Import method we can load the from the lower Oracle database version to the higher Oracle Database version and vice versa. Step 1. Create a backup directory To perform the export/import first we need to create a backup directory at…

[ocptechnology]

how to Activate Standby Database as Primary after Failover

When it comes to database management, the ability to failover to a standby database is an essential feature for high availability and disaster recovery. In the event of a failure in the primary database, the standby database can take over as the new primary database. (Activate Standby Database as Primary after Failover) However, once the issue with the primary database has been resolved, it’s…

[ocptechnology]

Manual Reinstate old Primary Using Flashback

In this article, we will learn how to reinstate old primary using flashback (Oracle Data Guard). This is a lengthy task of rebuilding the corrupt or lost primary database, but with flashback technology, it is a very easy task now. Steps to Reinstate old Primary Using Flashback in Oracle DataGuard NoteIn Dataguard after reinstating the old Primary Database it will become a standby, once…

[ocptechnology]

How to reinstate the old Primary as a Standby after Failover in Oracle

In this practice, we reinstate the old primary as a standby after failover in oracle. Currently, my primary database name “digital” is still active. NoteBefore performing the activity, you should enable the FLASHBACK and then complete the training. My Environment: For this practice below are my environment details: Primary Database: The primary database name is DIGITAL. Standby…

[ocptechnology]

Oracle Dataguard Switchover with broker

To perform an Oracle Data Guard switchover with broker, you can follow these general steps: Prepare for the switchover Before starting the switchover process, make sure that both the primary and standby databases are synchronized and that all required logs have been applied to the standby database. Also, ensure that the broker is configured and running on both the primary and standby…

[ocptechnology]

How to setup Data Guard Broker Configuration

Setting up Data Guard Broker Configuration involves the following steps. Before DG Broker setup you must have a Data Guard setup Read How to switchover in Data Guard Step 1. Current status of Broker Check the current status of DG Broker on both sides: Primary Side: SQL> show parameter DG_BROKER_START NAME TYPE VALUE ------------------------------------ ----------- --------- dg_broker_start…

[ocptechnology]

Oracle 19c Dataguard setup with PDB

Oracle 19c Dataguard setup with PDB, Dataguard is a disaster recovery solution that provides a high level of data protection and availability.

Oracle 19c Dataguard setup with PDB, Dataguard is a disaster recovery solution that provides a high level of data protection and availability for Oracle databases. It provides real-time data protection, and automatic failover protection, and enables the creation of one or more standby databases for a primary database. Dataguard with PDB (Pluggable Database), a PDB in a CDB (Container Database)…

[ocptechnology]

Patching 19.3 to 19.16 step by step

Patching 19.3 to 19.16 step by step

In this article, we are going to learn how to apply patching from 19.3 to 19.16 step by step. Today we applying patch number 34133642 on the Linux platform. NoteBefore applying the patch make sure the below point should be clear. You must go throw the README fileDownload Patch p34133642_19.16.00_Linux-x86-64Make sure the minimum OPATCH version is 12.2.0.1.30 Download OPATCH Version To update…

[ocptechnology]

ORA-16019: Cannot Use Db_recovery_file_dest With LOG_ARCHIVE_DEST Or LOG_ARCHIVE_DUPLEX_DEST

SQL> alter system set log_archive_dest_2=’service=ocp_dr noaffirm async valid_for=(online_logfiles,primary_role) db_unique_name=ocp_dr’;alter system set log_archive_dest_2=’service=ocp_dr noaffirm async valid_for=(online_logfiles,primary_role) db_unique_name=ocp_dr’* ERROR at line 1:ORA-02097: parameter cannot be modified because specified value is invalidORA-16019: cannot use LOG_ARCHIVE_DEST_2…

[ocptechnology]

oracle installation on susi

oracle installation on susi

/etc/sysctl.conf fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr =…

[ocptechnology]

Content Marketing

[ocptechnology]

AUTOMATICALLY KILL INACTIVE SESSIONS

create script which automatically kill inactive sessions in oracle database. Here i'm going to kill 15 minutes old inactive sessions. #oracle #oracledba #oracledatabase

Hi, today we are going to create script which automatically kill inactive sessions in oracle database. Here i’m going to kill 15 minutes old inactive sessions. Related Keywords: oracle inactive sessions not clearing, kill inactive session in oracle more than 60 minutes,shell script to kill inactive sessions in oracle, jdbc thin client inactive sessions, script to kill inactive sessions in oracle…

[ocptechnology]

Upgrade Oracle 11g to 19c using AutoUpgrade utility

how to upgrade the oracle database using the AutoUpgrade utility. The Autoupgrade is a new utility that is introduced in Oracle 19c."11g to 19c using AutoUpgrade" #oracle #oracledba #oracledatabase #autoupgrade

Hi, in this article we are going to learn how to upgrade the oracle database using the AutoUpgrade utility. The Autoupgrade is a new utility that is introduced in Oracle 19c.”11g to 19c using AutoUpgrade” How do I upgrade Oracle database to 19c? To upgrade oracle 11g to 19c we are going to following the below steps. Install ORACLE 19C Software only with seprate ORACLE_HOMEDOWNLOAD new auto…

[ocptechnology]

Check the Patch Applied to the Oracle Database

multiple ways to find Patch is Applied or not in the Database. Here i give all the ways to get the details about the same. #oracle #oracledba #databaseadmin #oracledatabase

In Oracle Database we have multiple ways to find Patch is Applied or not in the Database. Here i give all the ways to get the details about the same. how to check patch is applied or not in oracle, sql query to find patches applied in oracle 11g, How do I know if a patch is applied in Oracle 19c? Check applied patch list Here we have two ways to find the patch list and patch list with…