Make sure that your ORACLE_HOME and ORACLE_SID are correct To see the current values in windows, at the command prompt type echo %ORACLE_HOME% Then echo %ORACLE_SID% If the values are…
💡 In this article I am going to give you the steps of restoring an oracle DB on a new server: Step 1: Install the Oracle Software on the new server…
💡 Recently I tried to setup some new physical standby databases and got the following strange message: DGMGRL> ADD DATABASE “XXXX” as connect identifier is “XXXX” maintained as physical; Error:…
<aside> 💡 The Oracle database has been upgraded from 11.2.0.4 to 12.2.0.1 and the standby database (physical) was able to synchronize the data; but we see the error “ORA-16795: the…
💡 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.…
💡 Do không tìm thấy thư mục datafile trên máy auxiliary database server (có thể do server primary datafile để ở nhiều thư mục khác nhau) hoặc do do k…
alter pluggable database emr open; or alter pluggable database all open; or alter session set container=emr; >startup alter session set container=CDB$ROOT; Đóng alter pluggable database all close;
💡 [INS-32025] The chosen installation conflicts with software already installed in the given Oracle home Resolved 1. Locate your central inventory location @ /etc/oraInst.loc 2 cd <oraInventory path>/oraInventory/ContextXML (In windows…