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 […]
Oracle Client

Difference between Oracle Client and Oracle Instant Client

Posted on
Here I list their differences including features, pros and cons for you to evaluate which one should be used for your clients: Oracle Client Features Install-based software All-in-one functions General-purpose package Oracle database enterprise edition download page Oracle clients stay with Oracle database software, so there’s no dedicated download page for Oracle clients. Pros One-stop […]

4 Types of SQL in Relational Database

Posted on
Types of SQL Statements SQL statements in relational database management system (RDBMS) could sometimes be too complicated to be analyzed for. As SQL developers, we should at least be able to distinguish what types of the statements that are using. According to conventional SQL classification, there are 4 basic types of SQL statements. Data Query […]

How to Change SPFILE Location

Posted on
Change SPFILE Location Generally, we don’t change SPFILE location, because it should be found in the default location, $ORACLE_HOME/dbs/spfile$ORACLE_SID.ora any time to startup the instance without any explicit indication. SQL> startup Which means, the database will find appropriate SPFILE or PFILE in the default location to startup the instance. Of course, anything is not impossible […]
Control File

How to Change Control File Location

Posted on
Change Control File Location Here are the steps to change the location of control file: Stop Database Service Copy Control File to New Location Create PFILE from Current SPFILE Modify Control File Location in PFILE Restore SPFILE from Modified PFILE Startup NOMOUNT to Check New Setting Open Database If you’d like to move SPFILE as […]
Original Export / Import

How to Set Export Import Character Set

Posted on
Garbled Text Garbled data was found after importing a normal dump file. After doing some inspections, I found there’s NLS_LANG environment variable for user oracle in the source database server, but no NLS_LANG in the target server. Default Character Set of Sessions Since there’s no NLS_LANG to set NLS parameters at session-level, the import session […]

How to Export Column Comment DDL

Posted on
Column Comment DDL During metadata migration, I found all column comments with multi-byte characters are garbled. So what I was going to do next is to correct the garbled data and then feed all column comment into the target database. Now where we can find column comment DDL? For exporting column comments, we can use […]