Thursday, November 6, 2008

ORA-38029: object statistics are locked

While trying to analyze a table if the statistics are locked then this eror will occur
unlock the table stats

exec dbms_stats.unlock_table_stats('{owner}','{table name}');

also  we  can  lock  table statistics  like
exec dbms_stats.lock_table_stats('{owner}','{table name}');

PRKR-1005 : adding of cluster database PROC-5 PROC-5: User does not have permission

srvctl add database -d DOHATRAC -o /dohathome/oracle/app/oracle/product/10g -r PHYSICAL_STANDBY -s mount

PRKR-1005 : adding of cluster database DOHATRAC configuration failed, PROC-5: User does not have permission to perform a cluster registry operation on this key.

looks like database key was added by root initially because of this you are
not able add database using oracle user

crs_setperm ora.DOHATRAC.db -o oracle
crs_setperm ora.DOHATRAC.db -g dba