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}');
Thursday, November 6, 2008
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
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
Subscribe to:
Posts (Atom)