DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Re: ORA-01031: insufficient privileges when conn sys/password as sysdba

  1. #1
    Join Date
    Jul 2000
    Posts
    147

    Re: ORA-01031: insufficient privileges when conn sys/password as sysdba

    Any idea? It is newly copied db.
    I can connect localy. I get the error when I try to connect as sys remotely. All other user can connect okay, except sys. Any idea?

    Thanks!
    ----
    OS- Solaris
    10g

    # sqlnet.ora Network Configuration File: /opt/oracle/product/10.1.0/oradbhome/network/admin/sqlnet.ora
    # Generated by Oracle configuration tools.

    SQLNET.AUTHENTICATION_SERVICES=(NONE)
    NAMES.DIRECTORY_PATH= (NTS, TNSNAMES, EZCONNECT)


    Also remote_login_passwordfile=NONE
    Last edited by dba_dada; 10-04-2005 at 03:05 PM.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    how on earth you expect sysdba/sysoper working when you have this?

    remote_login_passwordfile=NONE

  3. #3
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    Check
    1. is service properly created in tnsnames.ora file
    2. r u using service name while connecting like sys/pass@ser1 as sysdba
    3. if os is windows then make SQLNET.authentication_services=(NTS)

    possible Suggestions
    1. Make remote operating system user, the member of oradba group at database server.
    ~KD.DBA~

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