ORA-01031: insufficient privileges
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01031: insufficient privileges

  1. #1
    Join Date
    Jan 2002
    Posts
    7
    Hi,
    I have the following problem.
    I just install new Oracle 8.1.7 database server and
    I am getting "ORA-01031: insufficient privileges " when I am using the following command:
    sqlplus internal@prod
    SQL*Plus: Release 8.1.7.0.0 - Production on Wed Apr 24 16:07:49 2002

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    ERROR:
    ORA-01031: insufficient privileges

    However "sqlplus internal" works fine.
    I can tnsping prod.
    Please help.
    Thank you,
    Inessa.

  2. #2
    Join Date
    Apr 2002
    Posts
    5
    You must have SYSDBA privilege in order to 'connect internal'. The ORA-01031 error is telling you that you do not have this privilege context, so it will not permit the connection.

    The difference between the two connections you describe is that one is specifying a database that must be listed in your naming service (local naming or Oracle Names), and that database can reside on another machine. The other tells SQL*Plus to obtain information about the database--especially the database SID--from the O/S environment.

    You did not mention whether 'prod' was on the same or another server. If it is on another server (from where you are running SQL*Plus), then SYSDBA privileges are not automatically available remotely in this way. They have to be setup. If it is on the same server, then you obtain SYSDBA privilege by using an O/S user account that is a member of the DBA or ORADBA group. (Group name is O/S dependent.)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width