Save Excel to CSV with different delimitor

By default if converting Excel (.xls or .xlsx)  to CSV the result is comma delimited. This is because setting list separator in your control panel.

If we want to convert excel to csv with different delimitor, for example, semicolon delimited, the easy way is the changing list separator in control panel.
In Windows 7:
1. Control Panel
2. Region and Language
3. Additional settings
4. List separator, change from comma (,) to semicolon (;)
5. Ok, -Finish-

OEM not working after windows patch KB2661254

See the following for more details:
http://blogs.technet.com/b/pki/archive/2012/07/13/blocking-rsa-keys-less-than-1024-bits-part-2.aspx
The above update will block the use of cryptographic keys that are less than 1024 bits. OEM uses a cryptographic key of 512.

The above article shows a workaround as follows:

1. open a CMD prompt,

2. enter the following command:
  Certutil -setreg chain\minRSAPubKeyBitLength 512

Alternatively, use Firefox instead of Internet Explorer.

SID_XDB service and SID_XPT Service 

In oracle 10g, when you check the listener service, you may notice two particular services registered:
[ccbqa] /orasw/app/oracle/admin/ >lsnrctl status|grep ccbqa
Service "ccbqa" has 1 instance(s).
  Instance "ccbqa", status READY, has 1 handler(s) for this service...
Service "ccbqaXDB" has 1 instance(s).
  Instance "ccbqa", status READY, has 1 handler(s) for this service...
Service "ccbqa_XPT" has 1 instance(s).
  Instance "ccbqa", status READY, has 1 handler(s) for this service...

ORA-01200

Sometimes when you try to start a database, you may get ORA-01200 error like:

ORA-01122: database file 8 failed verification check
ORA-01110: data file 8: '/bitest/oradata/bitest/cists02.dbf'
ORA-01200: actual file size of 64000 is smaller than correct size of 416256 blocks



The best solution is restore if you have a backup.
However if you don't have a backup, you can try to make the datafile have same block sizes registered in the control file to cheat oracle, but you may face data loses.

Steps as below (Caution: use at your own risk!!)

AIX - a sample script to start/stop OBIEE

#!/bin/ksh
# Check passed parameters
if [ $# -ne 2 ]
then
  echo "Please provide parameters"
  echo "Parameter 1 - Domain"
  echo "Parameter 2 - start or stop"
  exit
fi

Upgrade - Oracle Database 10.2.0.4 to 11.2.0.3

Oracle Database software uses 2 files (1 and 2) of the 11.2.0.3 patchset.
SQL> select name from v$database;
NAME
---------
TEST11G
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 – Production
CORE    10.2.0.4.0    Production
TNS for Linux: Version 10.2.0.4.0 – Production
NLSRTL Version 10.2.0.4.0 – Production

11gR2 Rac install on Centos 6.2 without Oracle ASMLib

Oracle ASMlib is available for linux prior to OL6 or RedHat 6. However, starting from 6, you can only use asmlib for UEK kernel.
On Linux, the built in udev is definitely a better solution to handle persistent device naming and permissions.
Without ASMLib, you don't need to worry about the raw disks everytime when there's a kernel update.