ORA-01031: insufficient privileges while doing / sysdba

I copied one oracle home to some other server/mount and did the clone of binaries.
After completion when I was trying to log in to SQL as sysdba to create database here. There I found following message.


$sqlplus '/ as sysdba'

SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 7 05:12:22 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges

Enter user-name:



Looking like some permission issue. Checked the user and OS permission of files, which were looking OK.
SQLNET.ORA too looked ok, then found following.

Reason:- Running clone on binaries has overwritten $ORACLE_HOME/rdbms/lib/config.c, and it was missing group values.


#define SS_DBA_GRP ""
#define SS_OPER_GRP ""

Solution:- Changed it to

#define SS_DBA_GRP "oinstall"
#define SS_OPER_GRP "oinstall"


Then run $ORACLE_HOME/bin/relink.


On completion, 


$sqlplus '/ as sysdba'

SQL*Plus: Release 11.2.0.3.0 Production on Fri Feb 7 07:02:55 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL>

Worked well.

Autoconfig - ERROR: Could not retrieve mount point for product top

While running autoconfig on my 11.5.10 eBusiness environment I found following error message.

        Using Context file          : <File Path>.........
Context Value Management will now update the Context file
ERROR: Could not retrieve mount point for product top - <Custom Top Path>

Checking that all, I found that our custom top (for which this was failing) was added to context file with other product tops.

<COMMON_TOP oa_var="s_com">.......path..........</COMMON_TOP>
         <CUSTOM_TOP oa_var="s_hcttop" oa_type="PROD_TOP" oa_enabled="FALSE">........path...</CUSTOM_TOP>
     

Solution:-

I simply removed the CUSTOM TOP entry from context file and tried running autoconfig again. And yes it worked.

ORA-39181: Only partial table data may be exported due to fine grain access control

While running datapump on some of the schemas I faced following error.

ORA-39181: Only partial table data may be exported due to fine grain access control on <owner>.<table>.
A direct hit Oracle Note "422480.1" says it is caused if an unprivileged user who tries to export a table with a fine grain access control policy applied.
I have been using SYSTEM for export, and that doesn't look under privilege user.

But for such case, whatever the user we are using to run export/import.

SQL> Grant Exempt Access Policy to <User>;

In my case it was 

SQL> Grant Exempt Access Policy to System; 

Do the export/import task and again do not forget to 

SQL> Revoke Exempt Access Policy from <User>; 

It's usually not advisable to keep it granted, until unless you have a specific admin user for import - export.