Re: connect as sys as sysdba gives error

  ""Anurag Minocha"" <aminocha_at_herold.com> wrote in message news:EBBA6D3A81229C42981E3AEA79BF5A4E111230_at_jshemail.herold.com...   Hi All,
   I am trying to connect as username sys as sysdba but it gives me a error 'Insufficient' privileges.    

  SQL> connect sys/change on install_at_orcl as sysdba   ERROR:
  ORA-01031: insufficient privileges    

  Warning: You are no longer connected to ORACLE.    

  I am trying to do this from a windows 98 machine and trying to connect a oracle 8.0.5 database.    

  Is there anything I am doing wrong here.    

  Thanks
  Anurag

  Yeah sure

  First of all: You post in html (and from Outlook I can't seem to switch it off), please don't do that, as many newsreaders out there (Forte [Free] Agent) will be incapable of reading it.

  Secondly, you are connecting *remotely*. Without further measures, this form of connecting can only be used *locally*. In order to be capable to do it remotely you must set remote login password file = exclusive in init<sid>.ora and bounce the database.   You should only do this when your network is secure,

  Hth,

  Sybrand Bakker, Oracle DBA

--