Oracle 11 Install without X

For Oracle 11g2 installation on a server, that has no X11 available you will have to use specific argument for install command:

[code]
runInstaller -silent -responsefile db.rsp
[/code]

db.rsp is an Oracle response file for providing required values for installation, that would be otherwise asked by graphical installer.
NB! Relative path to response file is not supported (like ../../db.rsp).

Here is an example of a response file for Oracle 11g2

[code]
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=localhost
UNIX_GROUP_NAME=oracle
INVENTORY_LOCATION=/opt/oracle/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1
ORACLE_BASE=/opt/oracle

oracle.install.db.InstallEdition=EE
oracle.install.db.EEOptionsSelection=false
oracle.install.db.optionalComponents=
oracle.install.db.DBA_GROUP=oracle
oracle.install.db.OPER_GROUP=oracle

oracle.install.db.CLUSTER_NODES=
oracle.install.db.isRACOneInstall=false
oracle.install.db.racOneServiceName=
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=
oracle.install.db.config.starterdb.SID=
oracle.install.db.config.starterdb.characterSet=
oracle.install.db.config.starterdb.memoryOption=false
oracle.install.db.config.starterdb.memoryLimit=
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.enableSecuritySettings=true
oracle.install.db.config.starterdb.password.ALL=
oracle.install.db.config.starterdb.password.SYS=
oracle.install.db.config.starterdb.password.SYSTEM=
oracle.install.db.config.starterdb.password.SYSMAN=
oracle.install.db.config.starterdb.password.DBSNMP=
oracle.install.db.config.starterdb.control=DB_CONTROL
oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
oracle.install.db.config.starterdb.automatedBackup.enable=false
oracle.install.db.config.starterdb.automatedBackup.osuid=
oracle.install.db.config.starterdb.automatedBackup.ospwd=
oracle.install.db.config.starterdb.storageType=
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
oracle.install.db.config.asm.diskGroup=
oracle.install.db.config.asm.ASMSNMPPassword=
MYORACLESUPPORT_USERNAME=
MYORACLESUPPORT_PASSWORD=
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true
PROXY_HOST=
PROXY_PORT=
PROXY_USER=
PROXY_PWD=
PROXY_REALM=
COLLECTOR_SUPPORTHUB_URL=
oracle.installer.autoupdates.option=SKIP_UPDATES
oracle.installer.autoupdates.downloadUpdatesLoc=
AUTOUPDATES_MYORACLESUPPORT_USERNAME=
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=

[/code]

Or download this response here: Oracle 11 Answer file

Using this response file you will install Oracle Enterprise edition without creating a database to /opt/oracle using user “oracle” and group “oracle“. You may change user, group and install folder by editing the response file.

NB!
Before running the installer ensure you have created user oracle and added permissions for /opt/oracle folder. Also install Oracle prerequisite packages by running:

[code]
yum install gcc gcc-c++ gcc-c++-devel glibc-devel libgcc libgcc-devel libaio libaio-devel compat-libstdc++-33 libstdc++ libstdc++-devel elfutils-libelf-devel ksh
[/code]

Block Skype connections

There is a popular belief that Skype client is very hard to block on the network layer, due to it’s Peer-To-Peer behavior and usage of HTTP/S ports.

Block Skype client

However at present time (December, 2012) Skype client connections can be blocked pretty simply by a few firewall rules.
After startup, Skype client receives a number of it’s master (login?) servers – dsnX.d.skype.net. Currently there are 16 DNS entries from dsn0.d.skype.net to dsn16.dsn.skype.net.

Using simple bash script (uses Linux DNS utility – dig) we can get most of these server’s IP addresses:

[code]
for i in {0..20} ; do dig +short dsn$i.d.skype.net; done | sort | uniq
[/code]

Just block all access to following networks and Skype client won’t be able to authenticate and connect.

111.221.74.0/24
111.221.77.0/24
157.55.130.0/24
157.55.235.0/24
157.55.56.0/24
157.56.52.0/24
213.199.179.0/24
64.4.23.0/24
65.55.223.0/24

For Linux router, with IPtables firewall, you may use following command:

[code]
for ip in 111.221.74.0/24 111.221.77.0/24 157.55.130.0/24 157.55.235.0/24 157.55.56.0/24 157.56.52.0/24 213.199.179.0/24 64.4.23.0/24 65.55.223.0/24; do iptables -A OUTPUT -d $ip -j DROP; done
[/code]

Windows 8 High CPU usage – interrupts

On some Windows 8 PCs, there is an issue with high CPU usage while computer is idle.
Load is caused by processes System and “System Interrupts”.

There was no obvious solution for the problem, however there were some clues on the web, to look into network devices.

There are 2 NICs in my PC, one integrated and one, pretty old – in PCI slot. I suspected the problem was caused by the older one.
After multiple tries, I dicovered that after disabling the second network card – CPU load dropped.
However this NIC was in use, for Internet sharing via WiFi router, so I couldn’t disable it

The solution was actually very simple – after disabling one option in device settngs (check screenshot) the load dropped back to normal.
NB! You may need to reboot for changes to take effect!

Windows 8 High CPU usage interrupts

Fastest Android ROM for Arc S

After trying many many different ROMs for my SonyEricsson Arc S. I have finally settled for stock .587 based custom ROM made by 4pda.ru forum member “gorolegov”.

Download Rom: mix Beautiful ICS.
Google apps are included in the ROM.

Kernel: Lupus v9
Kernel Wifi modules: Lupus v9

Some very useful additions:

DSP Manager
Long press volume buttons to skip tracks

Kernel must be flashed via fastboot (fastboot.exe flash boot LuPuS-ARC-S-v9-_-.img), all zip files should be installed through CWM Recovery.

Search recursively in file contents

There is a very useful command to search for a particular string in file in bash. It will search subdirectories as well and display a full path to the file, containing the string.
[code]
find . -type f -exec grep -Hn “emacs” {} \; 2>/dev/null
[/code]
Output:
./anaconda-ks.cfg:56:emacs
./install.log:282:Installing emacs-leim-21.4-24.el5.x86_64
./install.log:592:Installing emacs-common-21.4-24.el5.x86_64
./install.log:781:Installing emacs-21.4-24.el5.x86_64
./install.log:792:Installing emacspeak-23.0-3.el5.noarch

The 2>/dev/null argument will hide annoying errors like grep: line too long.
If you want to limit the depth of subdirectories, use -maxdepth X argument. Where X is >0.

For a search in current directory, grep alone is sufficient:

[code]
grep -Hn “string” *
[/code]