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.

ERROR:
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.

Posted on 03.10.2007, in Oracle and tagged . Bookmark the permalink. Comments Off on ORA-01031: insufficient privileges while logged on with CopSSH.

Comments are closed.