Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: cannot connect to Oracle as sysdba

    I try to login to our Oracle 9iR2 on Solaris 8 database instance and get errors as either sysdba or system users. I checked to see if the Oracle processes are running and they are:

    bash-2.03# ps -ef|grep ora
    oracle 2748 1 0 17:02:27 ? 0:00 ora_s000_sapxl
    root 3021 2994 0 18:23:37 pts/1 0:00 grep ora
    oracle 2742 1 0 17:02:27 ? 0:00 ora_reco_sapxl
    oracle 2734 1 0 17:02:26 ? 0:00 ora_dbw0_sapxl
    oracle 2736 1 0 17:02:26 ? 0:02 ora_lgwr_sapxl
    oracle 2754 1 0 17:02:27 ? 0:00 ora_arc1_sapxl
    oracle 2732 1 0 17:02:26 ? 0:00 ora_pmon_sapxl
    oracle 2738 1 0 17:02:26 ? 0:00 ora_ckpt_sapxl
    oracle 2744 1 0 17:02:27 ? 0:00 ora_cjq0_sapxl
    oracle 2746 1 0 17:02:27 ? 0:07 ora_qmn0_sapxl
    oracle 2752 1 0 17:02:27 ? 0:00 ora_arc0_sapxl
    oracle 2750 1 0 17:02:27 ? 0:00 ora_d000_sapxl
    oracle 2740 1 0 17:02:26 ? 0:01 ora_smon_sapxl

    But I cannot get sysdba or system users to work.

    bash-2.03# sqlplus /nolog

    SQL*Plus: Release 9.2.0.1.0 - Production on Wed Aug 11 18:23:45 2004

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    SQL> connect / as sysdba
    ERROR:
    ORA-01031: insufficient privileges


    SQL> create user
    2 ermuser
    3 identified by ermuser
    4 ;
    SP2-0640: Not connected
    SQL> connect / as sysdba
    ERROR:
    ORA-01031: insufficient privileges


    SQL> connect system/manager
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    SVR4 Error: 2: No such file or directory

    Does anyone know how to fix this type of problem? Thanks!

    -Ben

  2. #2
    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.

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    please post the contents of your SQLNET.ora file located in:
    $ORACLE_HOME/network/admin
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    You can only use the connect / as sysdba if you are logged in as the install user for oracle.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    Quote Originally Posted by beilstwh
    You can only use the connect / as sysdba if you are logged in as the install user for oracle.
    actually you cannot do that without configuring this parameter in
    SQLNET.ora file:

    SQLNET.AUTHENTICATION_SERVICES
    Purpose
    Use the parameter SQLNET.AUTHENTICATION_SERVICES to enable one or more authentication services. If authentication has been installed, it is recommended that this parameter be set to either none or to one of the authentication methods.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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