grant sysdba to sys??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: grant sysdba to sys??

  1. #1
    Join Date
    Jan 2001
    Posts
    72

    Angry

    Does sys auomatically have sysdba priveledges?
    I tried to grant sysdba to sys but it failed.
    Below is what I did:


    SQL> connect internal
    Connected.
    SQL> grant sysdba to sys;
    grant sysdba to sys
    *
    ERROR at line 1:
    ORA-01994: GRANT failed: cannot add users to public password file

    SO I DID:

    SQL> show parameter password

    NAME TYPE VALUE
    -------------------------- ------- -----
    remote_login_passwordfile string NONE
    SQL>

    According to ORA-01994 I need set the password file to exclusive which I did.
    So I started the database as follows and got an error:


    SQL> startup
    ORACLE instance started.

    Total System Global Area 45268884 bytes
    Fixed Size 73620 bytes
    Variable Size 31916032 bytes
    Database Buffers 13107200 bytes
    Redo Buffers 172032 bytes
    ORA-01990: error opening password file
    '/oracle/app/oracle/product/8.1.7/dbs/orapw'

    All I want is to grant sysdba to sys.
    Any help?


  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,015
    Connecting as Internal is the same as
    connect sys/pwd as sysdba

    so when you are connecting as internal and granting privileges to sys you are granting privileges to yourself. Its possible that your password file is corrupt. You should use the ORAPWD command to recreate it. You will want to delete/rename the file before you try to recreate it.

  3. #3
    Join Date
    Jan 2001
    Posts
    72
    Okay lets make this as simple as possible.
    What user should I connect as inorder to give
    sys the sysdba priveledge?

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you have to create your password file if you wanna use that feature

  5. #5
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    C:\>orapwd
    Usage: orapwd file= password= entries=

    where
    file - name of password file (mand),
    password - password for SYS and INTERNAL (mand),
    entries - maximum number of distinct DBA and OPERs (opt),
    There are no spaces around the equal-to (=) character.

    Be sure about entries=n because you cannot grant sysdba to users beyond n.


    [Edited by Raminder on 11-26-2001 at 11:27 PM]

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

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