Friday, December 23, 2011

Abasa is busy with my laptop

Now Abasa is about 1 year and 6 months old. He loves my new Camera and laptop very much. He plays with Laptop keyboard and Camera's touch screen. Whatever I do he try to follow that. Yesterday I took some photos of him with my new Camera.









These photos are taken from my Samsung Galaxy 5830 Ace phone. I tried to buy HTC or iphone but at last I had to choose this one as there is no authorized dealer for HTC and iphone is not authorized for Bangladesh.

Wednesday, December 21, 2011

Upgrade of Samsung Galaxy Ace S5830 to Android v2.3 fails with insufficient disk space

Recently I have bought Samsung Galaxy Ace S5830. Though I did not analyzed much but after I bought I am disappointed with their video Camera resolution which is QVGA@15fps. Except video everything seems perfect for me. I see it is using Android OS, v2.2 (Froyo). So, I wanted to consider to upgrade it to Android v2.3 as officially they say it is up-gradable to v2.3. I downloaded the SAMSUNG Kies software from their site http://www.samsung.com/hk_en/consumer/mobile/mobile-phones/smartphone/GT-S5830OKATGY/index.idx?pagetype=prd_detail&tab=support and installed in my pc. Then while upgrading my firmware to Android 2.3 it fails with message below.

"The drive does not have sufficient free disk space to perform the upgrade operation. You need at least 3000 MB free." This is in fact on your computer hard disk space particularly containing the %TEMP% or %TMP% folder on windows. Normally %TEMP% or %TMP% folder is the drive in which your operating system is installed.

You can simply check it by opening a command line window and just echo the environmental variable.

For example:
C:\>echo %TEMP%
D:\TEMP
Your %TEMP% must have at least 3G free space to perform Android upgrade operation. If you don't have this much space you have two options available.

1) Delete any unnecessary files on that drive and make 3G space free.
2) Change %TEMP% directory location to a drive where there is more than 3G space available.

Once you follow any of the two options close the Kies software and then open again and launch the firmware upgrade operation.

Monday, December 19, 2011

Audit Vault Server database show error ORA-01031: insufficient privileges

Problem Description
In the alert log of Audit Vault we see following errors "ORA-01031: insufficient privileges".
Sat Dec 17 12:00:02 2011
GATHER_STATS_JOB encountered errors.  Check the trace file.
Sat Dec 17 12:00:02 2011
Errors in file /u01/oracle/product/10.2.3/av_1/admin/av/bdump/av_j003_5071.trc:
ORA-01031: insufficient privileges
Sat Dec 17 16:31:11 2011
KZAM: Forced cleanup invoked for Standard Audit Trail, A truncate operation being invoked for Standard Audit Trail
Sat Dec 17 16:31:11 2011
KZAM: Forced cleanup invoked for FGA Audit Trail, A truncate operation being invoked for FGA Audit Trail

If we open the trace file, we will see following entries:
*** SERVICE NAME:(SYS$USERS) 2011-12-15 17:47:52.902
*** SESSION ID:(174.346) 2011-12-15 17:47:52.902
*** 2011-12-15 17:47:52.902
ORA-12012: error on auto execute of job 89
ORA-06550: line 1, column 97:
PLS-00201: identifier 'DVSYS.SYNCHRONIZE_POLICY_FOR_OBJECT' must be declared
ORA-06550: line 1, column 97:
PL/SQL: Statement ignored
*** 2011-12-16 04:00:02.941
*** ACTION NAME:(GATHER_STATS_JOB) 2011-12-16 04:00:02.941
*** MODULE NAME:(DBMS_SCHEDULER) 2011-12-16 04:00:02.941
*** SERVICE NAME:(SYS$USERS) 2011-12-16 04:00:02.941
*** SESSION ID:(174.348) 2011-12-16 04:00:02.941
ORA-01031: insufficient privileges
*** 2011-12-16 04:00:02.941
GATHER_STATS_JOB: GATHER_TABLE_STATS('"AVSYS"','"AV$METRICS"','""', ...)
ORA-01031: insufficient privileges
*** 2011-12-16 04:00:02.947
GATHER_STATS_JOB: GATHER_TABLE_STATS('"AVSYS"','"AV_NOTIFICATION_TEMPLATES"','""', ...)
ORA-01031: insufficient privileges
*** 2011-12-16 04:00:02.953
GATHER_STATS_JOB: GATHER_TABLE_STATS('"AVSYS"','"AV_LANG_MAP"','""', ...)
ORA-01031: insufficient privileges
*** 2011-12-16 04:00:02.957
GATHER_STATS_JOB: GATHER_TABLE_STATS('"AVSYS"','"AV_EXCLUDE_COLS"','""', ...)
ORA-01031: insufficient privileges
GATHER_STATS_JOB: GATHER_TABLE_STATS('"AVSYS"','"AV_ALERT_STATUSES"','""', ...)
ORA-01031: insufficient privileges
Cause of the Problem
This is Oracle Bug 7212724 ORA-1031 during DBMS_STATS.GATHER_SCHEMA_STATS with Data Vault.

Solution of the Problem
The bug fires due to Oracle database version. If your Oracle database version of Audit Vault server is 10.2.0.4 or lower then you are very likely to hit the above bug. This bug is solved in 10.2.0.5 (Server Patch Set). However, the AV warehouse database, i.e the database used as repository by the AV server cannot be upgraded manually. The better is to upgrade the audit vault version 10.3 both the AV server and agent, which uses the 11.2.0.3 database version, much less exposed to the bugs in 10.2.0.4 and consequently requiring less patches.

However if you don't want to upgrade the audit vault sever you can do following:
1. upgrade your AV agent and server to 10.2.3.2.6.

2. apply any of the merges:
9537908
9054851
9708333
10232437
10307028
12796658
12819446