This article describes about the Oracle 19C new feature – Active Data Guard DML Redirection. ACTIVE DATA GUARD DML REDIRECT feature enables DML operation on the standby database to be redirected to and run on the primary database instead of failing, where the data changes will be applied. The updated data will then be streamed […]
CREATE GUARANTEED RESTORE POINT: Stop redo transport and redo apply a)If broker is not configured: On primary database: SQL> alter system set log_archive_dest_state_2=’defer’; On standby database: SQL> alter database recover managed standby database cancel; b)If broker is in place: DGMGRL> edit database db set state = ‘TRANSPORT-OFF’; DGMGRL> edit database db01 set state = ‘APPLY-OFF’; […]
In this post we will discuss the steps to decrypt WebLogic credential from Boot Properties. During OEM upgrade process when WebLogic password is required, if you have forget the password you can decrypt the WebLogic credential using below steps. 1.Go to your domain/bin directory where setDomainEnv.sh file present. oracle=>cd /u01/app/app00/cloudc/gc_inst/user_projects/domains/GCDomain/bin oracle=>ls -ltr total 60 drwxr-x—. […]
This post explains about the steps are used by DBAs to install OEM agent using Silent Method. On the OMS host, you need to login using the EMCLI command [Note that SYSMAN password is required] oracle=>emcli login -username=sysman 2.oracle=>emcli sync Synchronized successfully Note Message should be “synchronized successfully” 3) List support platforms [Run it on […]
Started seeing this OEM error alert mails for OEM agents. EM Incident: Critical:New: – Agent Blocked (Bounce Counter Mismatch) Cause For every agent in the repository OEM maintains a Bounce Counter.At the time of agent restart, if the agent side Bounce Counter value is not in sync with repository, then uploads from this agent is […]
Use the below command to Stop only the Oracle Management Service: emctl stop oms Use the below command to stop Oracle Management Service including Administartion Server, HTTP Server and Node Manager: emctl stop oms -all Use the below command to check the status of OMS: emctl status oms Use the below command to get detailed […]
In the last post, we installed Oracle 19c Database Software by running RPM Package. Now, we are going to create and configure a Database with default Setting.Log in as root and run the below command to configure an Oracle Database instance.
[root@oracle19c dbhome_1]# /etc/init.d/oracledb_ORCLCDB-19c configure
Configuring Oracle Database ORCLCDB.
[FATAL] [DBT-06103] The port (1,521) is already in use.
ACTION: Specify a free port.
Database configuration failed.
To resolve the above error, make sure /etc/hosts has configured properly and ping […]
Oracle 19c can be installed on Oracle Linux using an RPM. This article describes the RPM installation of Oracle Database 19c 64-bit on Oracle Linux 7 (OL7) 64-bit. The naming convention for RPM packages is name–version–release.architecture.rpm. Installing Oracle Database RPM Manually Login as Root and Download and install the Oracle Preinstallation RPM
[root@oracle19c sw]# curl -o oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 18244 100 18244 0 0 85585 0 --:--:-- --:--:-- --:--:-- 85652
[root@oracle19c sw]# yum -y localinstall oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm
Loaded plugins: langpacks, ulninfo
Examining oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm: oracle-database-preinstall-18c-1.0-1.el7.x86_64
oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm: does not update installed package.
Nothing to do
Download the .rpm […]
Oracle 12.2 came with a new feature , we can simply recover a single table in a database. In below example we will see how we can restore a table of pluggable database. Step 1 : Connect to RMAN Step 2 : Use following command to recover table I.E. here I have table TEST which […]
Few days ago i got the activity to create the 2 NODE RAC DR on EXADATA for 2 NODE RAC Production. Here I am listing few issues that made this activity perfect case for Data Guard beginners Environment:Production Database Name: Financedb_unique_name : finance Standby Database Name : Finstandbydb_unique_name : finstandby Production OS Node: agoracledba1 agoracledba2Standby […]