Sys not able to connect through sysdba/sysoper in Oraclev9i!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Sys not able to connect through sysdba/sysoper in Oraclev9i!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi all!

    Working on Oracle v9i on Sun Solaris v8.0.

    I am not able to connect Sys through sysdba/sysoper in Oraclev9i!But system is getting connected through sysdba/sysoper over sql*plus!

    I get the error:Insufficient privileges!

    What could I be missing on sys part!

    But sys with sysdba/sysoper is getting connected over DBASTUDIO!

    Thanks & Regards,

    Amit.
    Oracle DBA (OCP) v8i,v9i

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Did you type: CONNECT / AS SYSDBA?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Originally posted by julian
    Did you type: CONNECT / AS SYSDBA?
    cant be that dumb can he...?!?!?

  4. #4
    Join Date
    Feb 2001
    Posts
    286

    Connect sys/pwd@dbname as sysdba leads to insufficient priviliges!

    Hi pando!

    It's not a matter of dumbness but understandability!!!

    The syntax:
    Connect sys/pwd@dbname as sysdba leads to insufficient priviliges error.

    Connect system/pwd@dbname as sysdba leads to insufficient priviliges eror!

    Now what could have gone wrong here!

    Regards,

    Amit.
    Oracle DBA (OCP) v8i,v9i

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    remote database ==> password file, do you have it?

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