Monday, June 15, 2015

SqlDeveloper 4.0 or later freezes

Starting from version 4.0, you may notice SqlDeveloper "freezes" quite regularly; it simply does nothing and does not accept keyboard input or mouse clicks. It remains in that state for 20 or 30 seconds, then continues to work normally. No error message or log entry.

It seems to be a java bug. Updating NVIDIA video driver can improve the performance. The recommended workaround from the Java Bug DB -- set this property by adding a line in sqldeveloper.conf:

AddVMOption -Dsun.awt.nopixfmt=true

Monday, April 13, 2015

windows process perl.exe Consumes High CPU

  • The Database Control (DB Control) Consumes High CPU - BEGIN EMD_NOTIFICATION.QUEUE_READY (Doc ID 734536.1)
  • Grid Control Agent Consumes High CPU when Executing parse-log1.pl / Log File Monitoring Metric (Doc ID 757877.1)

Friday, March 13, 2015

Aix get last day of current month

cal | awk '($0 != "") {F=$NF} END {print F}'
or
cal |grep .|fmt -1|tail -1

You can also find out the last day of any month by providing month and year to cal. for example:
cal 2 2012|awk '($0 != "") {F=$NF} END {print F}'
29
cal 10 2011|awk '($0 != "") {F=$NF} END {print F}'
11

Thursday, April 3, 2014

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-

Monday, July 15, 2013

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.

Wednesday, February 6, 2013

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...


Thursday, January 31, 2013

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!!)