ORA-01031: insufficient privileges while logged on with CopSSH
Our preferred OpenSSH port for Windows OS is CopSSH.
In one scenario we’re using CopSSH to connect to the Oracle server to run shutdown script for the database. In this script we’re using “connect / as sysdba”, relying on the ORA_DBA membership of the database administrator using SSH session. Well, despite of the fact that the bash shell is indeed running under local user account that is a member of ORA_DBA, it is not enough to avoid error, such as:
SQL*Plus: Release 10.2.0.3.0 - Production on Ned Okt 28 17:14:07 2007
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
ORA-01031: insufficient privileges
ORA-01012: not logged on
This forum note is (yet) another yellow sticky note to remind me (us) what to do to avoid such error.
All you need to do is to add local user account under which CopSSH is running (default SvcCOPSSH) to ORA_DBA group as well.