Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2008
    Posts
    12

    Unanswered: connecting as sysdba

    Dear all
    I need to connect to a database using OS authentication /user root

    (OS solaris 9 oracle 9i)
    I did the following

    -su
    -newgrp dba (the dba group is that compiled with oracle)
    -export ORACLE_HOME=..
    -export ORACLE_SID=...
    -export PATH=...
    -sqlplus /nolog
    -connect / as sysdba

    I got the following error

    ORA-01031: insufficient privileges
    can somebody help?
    thanks

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Have you made a password file?

  3. #3
    Join Date
    Mar 2008
    Posts
    12
    thanks for the answer
    there is a password file orap***
    I read that we use either os authentication or passwrd authentication
    however when connecting with password it works.
    in My case I want to connect without password (locally)

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    From MetaLink

    UNIX: Checklist for Resolving Connect AS SYSDBA Issues
    Doc ID: 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.

  5. #5
    Join Date
    Mar 2008
    Posts
    12
    I verified the checklist in Metalink and opened a case there

    I have another question
    suppose my database uses Os authentication can I set a password file also and use the two ways to connect

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >can I set a password file also and use the two ways to connect
    I give up. Can you?
    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.

Posting Permissions

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