How Oracle Purge RecycleBin
In this post, we'll talk about the following topics. Feature of Recyclebin Prerequisite of Using Recyclebin Ways to Purge Recyclebin Feature of Recyclebin Since 10g,… Read More »How Oracle Purge RecycleBin
Oracle Database 11g
How to Resolve ORA-28001: the password has expired
ORA-28001 ORA-28001 means that your password has been expired according to your profile. Normally, you should change the password, but you can still work around… Read More »How to Resolve ORA-28001: the password has expired
How to Resolve TNS-12546 Error Message
TNS-12546: TNS:permission denied I got TNS-12546 when I tried to start the listener as oracle. oracle@solaris11vm:~$ lsnrctl startLSNRCTL for Solaris: Version 11.2.0.4.0 - Production on… Read More »How to Resolve TNS-12546 Error Message
How to Resolve OC4J Configuration issue
An error occurred when I tried to start up dbconsole of Oracle database 11g. oracle@solaris11vm:~$ emctl start dbconsole OC4J Configuration issue. /u01/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/OC4J_DBConsole_localhost_ORCL not found. Looked… Read More »How to Resolve OC4J Configuration issue
How to Resolve Error in invoking target 'agent_nmhs' of makefile ins_emagent.mk
ins_emagent.mk During the installation of Oracle 11.2.0.4 on Enterprise Linux 7.2, I met this error about ins_emagent.mk below: In the installation log, we saw a… Read More »How to Resolve Error in invoking target 'agent_nmhs' of makefile ins_emagent.mk
Duplicate a Standby Database (1/4) - With Active Database
Duplicate a Standby Database (0/4) - An Overview For 19c Standby database duplication, you may check the post: How to Duplicate a 19c Physical Standby… Read More »Duplicate a Standby Database (1/4) - With Active Database
Duplicate a Standby Database (0/4) - An Overview
There are many purposes to create a clone database, one of which is to create a standby database in a data guard environment to fulfill… Read More »Duplicate a Standby Database (0/4) - An Overview
How Oracle Enable ARCHIVELOG Mode
What is Archivinglog Mode? The process of copying inactive redo log files into archived files is called archiving. Archiving is only effective on databases which… Read More »How Oracle Enable ARCHIVELOG Mode