Listener Log

Where to Find Oracle Listener Log Location

Posted on
The Default Location of Oracle Listener Log If you have read Where to Find Oracle Alert Log Location, you may have some clues to find the right listener.log. But there’re some differences between them. For 11g and above The default location of listener log for 11g or above can be found at: [oracle@ora11g ~]$ ll […]

How to Resolve ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

Posted on
Found ORA-19602 When I tried to backup a NOARCHIVELOG database in MOUNT state, I got ORA-19602 like the following case: RMAN> startup mount; … RMAN> backup database tag ‘20190416-before-yearly-import’; Starting backup at 16-APR-19 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=393 device type=DISK channel ORA_DISK_1: starting full datafile […]
Database Link

What DB Link Can and Cannot Do

Posted on
Can and Cannot For better understanding the features of a database link which may play an important role in data migration, we should study what a database link can and cannot do in a distributed database system in order to develop our data migration strategy. Generally speaking, you can perform Data Query Language (DQL) and […]

How to Resolve ORA-00903: invalid table name

Posted on
In this post, I will introduce 3 main error patterns about ORA-00903, they are: Violating Naming Rules Missing Quotes Incorrect Syntax ORA-00903 due to Violating Naming Rules Without complying with database object naming rules, we can’t create a table with unusual strings in normal way. Let’s see some cases that throw ORA-00903. First of all, […]
Data Guard

How to Resolve ORA-01579 in MRP

Posted on
ORA-01579 in MRP After shrinking (i.e. resizing) a data file successfully, I was worry about the applying state of the standby database. Not surprisingly, I found ORA-01579: write error occurred during recovery in Managed Recovery Process (MRP) log. oracle@boston>tail -f orcl_mrp0_23309410.trc … *** 2019-03-15 08:51:13.521 Media Recovery Log /oradata/ORCL/ARCH/ORCL_1_342376.arc *** 2019-03-15 09:02:01.230 Media Recovery Log […]

How to Resolve WebLogic Startup Slow

Posted on
WebLogic Startup Slow After long WebLogic installation, I found that every time I startup WebLogic Server, it took about 10 to 15 minutes to complete. Which is unbearable and unacceptable for a production environment. Rationale This is because JVM library used for random number generation relies on /dev/random by default for UNIX platforms. This can […]

How to Resolve ORA-00904 Invalid Identifier

Posted on
Oracle Database Object Name Recognition Examples
General Naming Rules about ORA-00904 Normally, Oracle treats most identifiers as case insensitive ones excepts password. But there’re some special usages should be taken care of in case of ORA-00904 invalid identifier generated. Not only ORA-00904, but ORA-00903 and ORA-00911 are also related to invalid usage on object identifiers. More specifically, ORA-00903 alerts users for […]
Installation and Upgrade

How to Install Oracle Software in Silent Mode

Posted on
With a Response File First of all, we have prepared a response file for installing Oracle software only as following. Let’s see the effective content of the response file. [oracle@ora11g ~]$ egrep -v “(^(#|$)|=$)” install-software-only-for-11g.rsp oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 oracle.install.option=INSTALL_DB_SWONLY ORACLE_HOSTNAME=ora11g UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/app/oraInventory SELECTED_LANGUAGES=en,zh_TW ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 ORACLE_BASE=/u01/app/oracle oracle.install.db.InstallEdition=EE oracle.install.db.EEOptionsSelection=false oracle.install.db.DBA_GROUP=dba oracle.install.db.isRACOneInstall=false oracle.install.db.config.starterdb.type=GENERAL_PURPOSE oracle.install.db.config.starterdb.memoryOption=false oracle.install.db.config.starterdb.installExampleSchemas=false oracle.install.db.config.starterdb.enableSecuritySettings=true oracle.install.db.config.starterdb.control=DB_CONTROL oracle.install.db.config.starterdb.automatedBackup.enable=false SECURITY_UPDATES_VIA_MYORACLESUPPORT=false DECLINE_SECURITY_UPDATES=true […]

How to Stop XMLRPC Attack in WordPress

Posted on
XML-RPC Attack
Saw a HTTP attack, it sent 12 to 20 requests per second on /xmlrpc.php, then made web server jam. In HTTP access log, we saw a lot of requests like this: – – [03/Mar/2019:21:35:40 -0500] “POST /xmlrpc.php HTTP/1.1” 200 401 – – [03/Mar/2019:21:35:40 -0500] “POST /xmlrpc.php HTTP/1.1” 200 401 – – [03/Mar/2019:21:35:40 […]