Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2011

    Unanswered: SYS login from server - insufficient privileges

    Hi all,
    I have a problem with my Oracle Server (10g - under Red Hat Linux.
    When logged into the server as the Oracle user, I can log in using the commands:

    "sqlplus / as sysdba"

    "sqlplus /nolog"
    SQL> conn / as sysdba;

    "sqlplus /nolog"
    SQL> conn sys/password@dbname as sysdba;

    For any of these cases, I am able to connect and do not receive and error.

    When I modify the login to include the entry from the tnsnames file and attempt to log in using the sys user and password directly from the command prompt:

    "sqlplus sys/password@dbname as sysdba"

    I receive an insufficient privileges message. ORA-01031

    I seem to remember something about logging in explicitly as the SYS user, but can't find it in my books.
    Any help would be appreciated.
    Last edited by rknralf; 09-09-11 at 15:00. Reason: clarification of commands used

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    UNIX: Checklist for Resolving Connect AS SYSDBA Issues NOTE: 69642.1.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2011
    if you include the sid in the connect string, you are in effect logging in over TNS which you need to be configured for

    have you TNS in your connect in sqlnet.ora?

Posting Permissions

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