It
is a surprise to me that my blogger page views are reset to zero today(15-Oct-2012) and a
fresh counter started. This is the first time I am seeing this problem in my
blogging life. As per the blogger support team it is a known issue.
Rail Radar: How to Live Locate Indian Railway Trains in Google Map!!
Indian railway launched live locator
for the trains running on the Indian railway tracks with the help of the
Google Maps. When you launch the web site you will get the Indian map with train indicators and you
can zoom-in and zoom-out as like in Google Maps.
Index Rebuild Online Failed Oracle 11gR2: ORA-01450: maximum key length (3215) exceeded
Problem Description:
Index creation or rebuild with online clause failed with following
error in Oracle 11gR2.
ORA-00604:
error occurred at recursive SQL level 1
ORA-01450:
maximum key length (3215) exceeded
Fix Oracle 11g Client sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
Error Description:
Oracle
11g Client SQL* PLUS is failing with following error.
$ORACLE_HOME/bin/sqlplus
/opt/oracle/client_11_2/bin/sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
/opt/oracle/client_11_2/bin/sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
How to Find out / Check / Set Values for Hidden Underscore _ Parameters in Oracle?
Short Note on Hidden/Undocumented
Parameters:
Undocumented parameters need to be
tested in test database before implementing in production. Also, better to get
support from oracle before going to production. Hidden parameters are for
internal purpose of the oracle. You have to be very careful before implementing
as they are very dangerous. It starts with ‘_’.
Validate Exception Queue: ORA-24017: cannot enable enqueue on QUEUE
Error Description:
exec
DBMS_AQADM.START_QUEUE('AQ$_TEST_TABQ_E'); command is failing with following
error.
SQL> exec
DBMS_AQADM.START_QUEUE('AQ$_TEST_TABQ_E');
BEGIN
DBMS_AQADM.START_QUEUE('AQ$_TEST_TABQ_E'); END;
Data Pump EXPDP Error: ORA-39181: Only partial table data may be exported due to fine grain access control on
Error Description:
Data pump expdp log shows following error for some tables during the export.
ORA-39181: Only partial table data may be exported due to fine grain access control on "SCOTT"."CONTROL_ITEMS"
Solution Description:
This error occurs when a unprivileged user tries to export the tables which are enabled with Fine Grain Access Control policies. You can verify these kind of tables using the below query.
select * from dba_policies where OBJECT_OWNER='SCOTT' AND OBEJCT_NAME=’CONTROL_ITEMS’
