Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2004
    Location
    Redwood City, CA
    Posts
    4

    Unanswered: Cannot connect as sysdba using oracle account in 9i - insufficient privileges

    ( I searched this forum, but still could not get the answer)

    Installed Oracle Applications 11i (9i + iAS + Apps 11.5.9). Then, tried to connect to sysdba issuing:
    sqlplus /nolog
    then issuing either one of the following commands:
    connect / as sysdba
    connect sys/change_on_install as sysdba
    connect system/manager as sysdba
    connect sys/sys as sysdba

    For all of them, I always get the following error:
    ORA-01031: insufficient privileges

    I tried all sort of variations, like entering things in quotes, etc... did not work.

    Additional information:
    -------------------------------------------------------------------------------
    * OS: RedHat Linux 9
    * Machine: Dell Dimension 2350
    * Server Name: msoares-dsk
    * Domain: comcast.net
    * User: oracle
    * Primary Group: dba
    * Sys password: change_on_install
    * System password: change_on_install
    * TNS_ADMIN is set; tnsnames.ora and listener.ora are in the specified location; no sqlnet.ora file in the location specified in TNS_ADMIN
    * Listener is up (tcp, port 1521)
    * ORACLE_SID=vis01
    * TWO_TASK=vis01
    * ORACLE_HOME=/d02/oracle/vis01db/9.2.0


    What am I missing?


    Thanks in advance.

    MSoares.

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    How did you install the database software?
    What is returned from ls -l $ORACLE_HOME/bin/oracle ?

    To use O/S authentication (connect / as sysdba) you will need to be in the same group as the oracle software owner.

    To connect as a database user (connect user/password as sysdba) you will need to create a password file and add the user to that password file.

  3. #3
    Join Date
    Mar 2004
    Location
    Redwood City, CA
    Posts
    4
    (Thanks for your reply)
    Here it is:
    [oracle@msoares-dsk oracle]$ ls -l $ORACLE_HOME/bin/oracle
    -rwsr-s--x 1 oracle dba 51691769 Mar 30 13:16 /d02/oracle/vis01db/9.2.0/bin/oracle

  4. #4
    Join Date
    Mar 2004
    Location
    Redwood City, CA
    Posts
    4
    please note that I'm using the oracle user itself to try to login to the database, but still I cannot connect.

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    unset=TWO_TASK
    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.

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

    unset TWO_TASK

    is correct command to be issued.
    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.

  7. #7
    Join Date
    Mar 2004
    Location
    Redwood City, CA
    Posts
    4

    Talking

    Yep!!!

    Problem Solved!!! Thanks a million!!!

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    When TWO_TASK is set, then SQL*Net will be used to connect to the DB.
    The defaults upon installation is that the DB can not be started/stopped remotely (using SQL*Net) due to security concerns.
    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
  •