PFILE and SPFILE

The Default Location of SPFILE and PFILE for Linux and Windows

Posted on
Here is a quick glance at the default locations of SPFILE and PFILE in different platforms. For instance, Linux and Windows. For Linux/Unix SPFILE <ORACLE_HOME>/dbs/spfile<ORACLE_SID>.ora PFILE <ORACLE_HOME>/dbs/init<ORACLE_SID>.ora For Windows Please note that, for Windows, directory name and filename are case-insensitive. SPFILE <ORACLE_HOME>\database\spfile<ORACLE_SID>.ora PFILE <ORACLE_BASE>\admin\<ORACLE_SID>\pfile\init.ora.<n> There’s no typos in the above path. The default location of […]
Shell Script

How to Auto Start Oracle Database on Linux

Posted on
For Solaris OS, you should check this post: How to Auto Start Oracle Database on Solaris. Assuming that you already have some knowledge about how to start Oracle database manually and Oracle provided shell script dbstart, then we can keep going to design and deploy our automatic startup scripts. By default, Oracle software installation does […]
Linux

How to Migrate Local Databases to Remote Host or Vice Versa Without Dump Files

Posted on
For migrating a remote database, you can dump and pipe the whole database from remote server to local server via ssh tunnel without intermediate dump files.[root@test ~]# ssh 10.10.10.1 “mysqldump –routines -u root -p’xxxxxxxx’ chicago_db” | mysql -u root -p’xxxxxxxx’ -D boston_dbVice versa, you can migrate a local database to the remote server.[root@test ~]# mysqldump […]
Linux

How to Mount an Uploaded ISO file in Linux

Posted on
If you were limited to access /dev/cdrom, you can still utilize the content of an ISO by uploading and mounting it. The syntax is as the following:mount -o ro,loop <source_path> <target_path>For example, we can mount an uploaded ISO file as a media like this:[root@ovmm ~]# mount -o ro,loop /tmp/ovmm-3.4.2-installer-OracleLinux-b1384.iso /media[root@ovmm ~]# ll /mediatotal 157557drwxr-xr-x. 7 […]
VM

How to Install Oracle VM Manager 3.4.2

Posted on
For simplifying our procedures, I have to assume that you have installed Enterprise Linux 6.7 minimal on the server. The hardware requirements to install OVMM 3.4.2 safely is as of: 8GB memory or above: Any figure lower than 8GB will meet errors during installation.40GB disk space or so.A. Configure file hostname resolution.The name resolution is […]
Linux

How to Set Date Time of Linux OS Manually

Posted on
Sometimes, you can’t use NTP to adjust your server time, you can change it by a command line.[root@rac1 ~]# date -s ‘2017-02-18 17:30:00’Sat Feb 30 17:30:00 CST 2017The option “s” is set the time by its following string.[root@rac1 ~]# dateSat Feb 30 17:30:12 CST 2017Chances are, you may need to change a bunch of server […]
Virtualization

What Should be Changed after Cloning a VM

Posted on
You may know that you should change hostname and change NIC configurations after cloning a VM, but you may not know there could be iscsi initiator conflicts among VMs.Mostly, virtualization softwares will take care MAC addresses during cloning, but they may not take care the initiator name. Therefore, we should also change the initiator name.Assuming […]
bash

How to Increase Bash History Size

Posted on
Some valuable or complex commands may not be able to keep in your mind constantly when you need them. In this moment, you can leverage the command history to recall them. But as time goes by, you could lose them due to the size limitation of command history. The history always keep the most recent […]
Linux

How to Resolve RTNETLINK answers: Invalid argument Error adding default gateway

Posted on
RTNETLINK answers: Invalid argument When I restarted the newly configured network interface, it returned error rtnetlink answers: invalid argument like the following: [root@test ~]# service network restart … RTNETLINK answers: Invalid argument Error adding default gateway … Please check the gateway that you just set.[root@test ~]# vi /etc/sysconfig/network-scripts/ifcfg-eth2 … GATEWAY=192.168.25.1 If you were sure about […]