Remotely SQLPlus as sysdba – ORA-01031: insufficient privileges


SQLPlus as SYSDBA remotely can throw the following error due to security reason :

>sqlplus sys/syspass@servername/instance as sysdba

SQL*Plus: Release Production on Mer. Ao¹t 30 14:25:48 2017

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

ORA-01031: insufficient privileges


To allow to connection, connect locally using SQLPlus and make sure the parameter “remote_login_passwordfile” is set to ‘”EXCLUSIVE” :

SQL> show parameter remote_login_passwordfile

------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE


Then check a password file exist for your instance :

SQL> select * from v$pwfile_users;

no selected row.


It appears it does not exist and needs to be created to allow remote connection. We will create on a Windows Server and I will refer to Oracle doc

D:\oracle\11.2.0\db\BIN>orapwd.exe file=D:\oracle\11.2.0\db\database\PWDINSTANCENAME.ora

Enter password for SYS:


You can now log on remotely.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s