connect sys as sysdba
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: connect sys as sysdba

  1. #1
    Join Date
    Aug 2002
    Posts
    40

    Arrow connect sys as sysdba

    I have installed oracle 9i database on one machine.On command line when i run-
    c:>set oracle_sid=orcl
    c:>sqlplus /nolog
    sql>connect sys as sysdba..this gives me error insuffiecient privileges.
    however when i connect sytem/manager...it allows me to connect.but my problem is that i have to create another database on the same machine for which i have to connect sys as sysdba.please suggest..?
    secondly i tried to change the password file by running orapwd utility-
    c:>orapwd file=c:\orahome\database\PWDorcl password=oracle entries=50;
    this helped once but when i rebooted the computer again same problem of insuffient privileges exists.please suggest...thanks

  2. #2
    Join Date
    Jun 2000
    Posts
    295
    Try to login on as adminstrator or whoever installed
    Oracle software.

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