Remotely SQLPlus as sysdba – ORA-01031: insufficient privileges

Hello,

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

>sqlplus sys/syspass@servername/instance as sysdba

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

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

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

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
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 https://docs.oracle.com/html/E25494_01/dba007.htm

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.

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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