Once Source DB is configured to replicate the data using Oracle GoldenGate, Be ready with Target DB using this session. Check my previous session to Configure Source DB for replicate the data using Oracle GoldenGate. Step-1 Login to Target Database and check database process. Step-2 To enable Oracle GoldenGate, set the following database initialization parameter. …
Note:-We are using Oracle DB as source and Target both. Step-1 To enable Oracle GoldenGate, set the following database initialization parameter. ENABLE_GOLDENGATE_REPLICATION=true (on CDB level) Step-2 Oracle GoldenGate relies on the redo logs to capture the data that it needs to replicate source transactions. The Oracle redo logs on the source system must be configured …
We are Converting Oracle Database Standard Edition 19c to Oracle Database Enterprise Edition within same server. Existing DB Name:-SEORCL (19c Standard Edition 2) and Server Name:- pathindia Migrated DB Name:-SEORCL (19c Enterprise Edition) on same Server Name:- pathindia Step-1 We have running Oracle Database Standard Edition in ORACLE_HOME=/Data01/app/oracle/product/19.0.0/dbhome_1 Database is running with the version 19.22.0.0.0 …
We need Single server only, Below are the High-Level Steps: — Step-1 Install the most recent Oracle client on the GoldenGate hub server Download the Oracle instant client software from https://www.oracle.com/in/database/technologies/instant-client/linux-x86-64-downloads.html Step-2 Oracle GoldenGate for Microservices installation on Linux OS Execute the runInstaller as below snap On this screen, Provide the OGG_HOME for Software Location …
We are changing DB name only(NON-CDB), nothing else. Lets start this practice. Step-1 Take the full backup of the Database which we are going to rename. This is called gold backup of the database. Step-2 First, We checks the DBID of the existing database as below snap. Note:- DBID is 3923603378 and DB Name is …
Read more “Be careful, while changing the name of Oracle Database.”
ADG stands for Active Data Guard use to recovery from the Disaster known as Disaster Recovery and ensures the High Availability for the Data. First, we checks the Databases running or not as below snaps Database is running as Physical Standby and now we are going to open the database as below snap Once Database …
Click this –>Install Oracle binaries/Software in silent mode (without graphical interface)……………. Lets start to create Database using DBCA in silent mode Step-1 First, we need to set the environment as below export ORACLE_HOME=/Data01/app/oracle/product/19.0.0/dbhome_1 export PATH=$ORACLE_HOME/bin:$PATH [oracle@pathindia ~]$ Step-2 execute the below command to run DBCA in silent mode [oracle@pathindia ~]$ dbca -silent -createDatabase -templateName General_Purpose.dbc …
Read more “Now, We can create Database using DBCA silent (without graphical interface)…………….”
Hey, Are you facing challenges to install oracle database software/Binary using graphically due to GUI is not working? Don’t worry! Lets install software in silent mode(without GUI). Below are the steps to create database in silent mode(Without graphical interface) Step-1 Download Oracle DB software from OTN:- https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html OR Oracle edelivery:– https://edelivery.oracle.com/osdc/faces/Home.jspx Step-2 Transfer downloaded software …
Read more “Yes, we can install Oracle software in silent mode”
Are you searching for tool or software, which can replicate your changed transactional data from one Database to other database or anywhere? Oracle GoldenGate says, you are at the right place. Some of the top CDC software/tool available for your reference in 2024, But I love to use Oracle GoldenGate Let’s check, What type of …
We are trying to resolve the issue related to error ORA-12520 TNS:listener could not find available handler for requested type of server. Suddenly all the users are facing the issue and reported to DB team to resolve the issue. Lets start to check and resolve. DBA checked the connection and facing same issue as below snap …
Read more “ORA-12520 TNS:listener could not find available handler for requested type of server”