Error ORA-01400: cannot insert NULL into (“RASYS”.”BCF”.”CKP_TIME”) on ZDL Recovery Appliance Catalog

23 de dezembro de 2024

Due to a series of tests performed in a development environment, we forced the cancellation of some operations that were being executed on ZDL. As a result, metadata became lost and inconsistent, with missing records and values in required fields in one of the internal views of the RASYS user. The error below was encountered … Mais Error ORA-01400: cannot insert NULL into (“RASYS”.”BCF”.”CKP_TIME”) on ZDL Recovery Appliance Catalog

Rename Datafile on Physical Data Guard Fixing Error ORA-01111 and ORA-01110

16 de dezembro de 2024

Sometimes, because you forget to set standby_file_management to AUTO for example, or any other reason you can get the issues below on alert log or starting database, you can rename datafile with a new feature on Data Guard. This tip help you fix the issue without copy datafiles via RMAN or have to set tablespaces … Mais Rename Datafile on Physical Data Guard Fixing Error ORA-01111 and ORA-01110

Using Recover Standby Database From Service To Fix Physical Data Guard

11 de dezembro de 2024

Oracle Data Guard is a secondary database environment used for disaster recovery, failover, or data recovery, however, this environment can also experience failures, such as synchronization issues, maintenance, and others. Oracle has simplified the process of fixing the database in the Data Guard environment with the command Recover Standby Database From Service, which uses a connection … Mais Using Recover Standby Database From Service To Fix Physical Data Guard

Safe Process To Reboot Storage Server on Exadata Hardware For Maintenance

4 de dezembro de 2024

If you work with Exadata, ZDL or any other Engineered System that you use Exadata hardware and need a hardware part replacement on storage server, you can follow the steps below to reboot the hardware safely, without impact the ASM structure. I my example, I am going to replace a controller disk battery on a … Mais Safe Process To Reboot Storage Server on Exadata Hardware For Maintenance

Duplicate Database Cluster Oracle Environment Using Backup From Zero Data Loss

27 de novembro de 2024

In this article, we will clone a RAC environment by extracting the backup of the source database from the Recovery Appliance. The clone will be created with a single-node environment and then converted to a cluster, as per the original environment. Below are some details in the table: Source Database ORDB Source Node 1 oraordb01 … Mais Duplicate Database Cluster Oracle Environment Using Backup From Zero Data Loss

Error ORA-12547: TNS:lost contact Trying To Connect on SQLPLUS After Duplicate

26 de novembro de 2024

At the end of a duplicate process and cluster environment configuration, I encountered an error commonly seen in network, communication, and net services configuration issues related to Oracle: The reason for this issue is almost unbelievable; however, it is simply a slash at the end of the ORACLE_HOME directory, as per Oracle’s Doc ID: Sqlplus … Mais Error ORA-12547: TNS:lost contact Trying To Connect on SQLPLUS After Duplicate

How to Rename a Protected Database Name on ZDL

16 de novembro de 2024

For any reason you need to change protected database name on ZDL, such as after enroll a Data Guard on configuration or migrating databases with same DBID, but different names on the cluster, you can use an internal command to change that name. If you try change the names directly, you will get an error … Mais How to Rename a Protected Database Name on ZDL

NOTE: unable to execute orapwd… ret:255 sig:0 err: ASMCMD-9454 Creating orapw file Inside ASM

29 de outubro de 2024

This week, creating a new database, I faced an issue, already got for me sometimes ago, but I didn’t remember how I fixed that. So I decide to document because, usually, when we have to duplicate or restore a database, tables and schemas as well, is an urgent task for our customers. I faced that … Mais NOTE: unable to execute orapwd… ret:255 sig:0 err: ASMCMD-9454 Creating orapw file Inside ASM

Adding New Routes On OEM Server Operational System to Fix Monitoring ZDL Connectivity

1 de outubro de 2024

Some weeks ago, I went through a situation where client monitoring OEM agent was not able to connect to Oracle Enterprise Manager to monitor the Oracle Zero Data Loss. We received the error message below: “Communication between the Oracle Management Service to the Agent is unavailable. Any features or displayed information requiring this communication will … Mais Adding New Routes On OEM Server Operational System to Fix Monitoring ZDL Connectivity