how to allow connect / as sysdba in windows 10.2
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: how to allow connect / as sysdba in windows 10.2

  1. #1
    Join Date
    Apr 2001
    Posts
    124

    how to allow connect / as sysdba in windows 10.2

    Hi,

    I have a 10.1.0.4 installed on windows, it uses password file, and ORA_DBA local group is created which contains the local user I use to login. I can use sqlplus / as sysdba to login.

    Then I upgrade it to 10.2.0.3, the following is how I did it:

    1. install 10.2.0.1 software on a new oracle home
    2. install 10.2.0.3 patchset on top of it
    3. use database upgrade assistant (DBUA) graphic tool to upgrade the database

    After that, I can no longer login using sqlplus / as sysdba, I have to use sqlplus sys/xxxxx as sysdba instead, which violates our company's security policy. How can I make sqlplus / as sysdba work again?

    Thanks a lot!

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    your ORACLE_HOME is probably set wrong - change it

  3. #3
    Join Date
    Apr 2001
    Posts
    124
    let's say my 10.1.0.4 home is c:/orahome_1, and my 10.2.0.3 home is c:/orahome_2, my ORACLE_HOME should be set to c:/orahome_2, right? that's the current value of ORACLE_HOME.
    Oracle 8, 8i, 9i OCP DBA
    Oracle 6/6i OCP DEV
    Sun Solaris8 SCSA
    MCDBA 2000

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    yes it should be.

    but you dont say what the error is either so its a bit hard to help

  5. #5
    Join Date
    Apr 2001
    Posts
    124
    the error is ORA-01031: insufficient privileges
    Oracle 8, 8i, 9i OCP DBA
    Oracle 6/6i OCP DEV
    Sun Solaris8 SCSA
    MCDBA 2000

  6. #6
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Hi,

    What is the output of :

    select * from v$pwfile_users;

    Also, Paste the content of sqlnet.ora

    Also, what is the value of :

    SQL> show parameter remote_

    Thanks,
    Paresh

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    Quote Originally Posted by pareshjavkar
    Hi,

    What is the output of :

    select * from v$pwfile_users;

    Also, Paste the content of sqlnet.ora

    Also, what is the value of :

    SQL> show parameter remote_

    Thanks,
    Paresh
    none of that has anything to do with anything this person wants

  8. #8
    Join Date
    Oct 2006
    Posts
    175
    Quote Originally Posted by zxmgh
    Hi,

    I have a 10.1.0.4 installed on windows, it uses password file, and ORA_DBA local group is created which contains the local user I use to login. I can use sqlplus / as sysdba to login.

    Then I upgrade it to 10.2.0.3, the following is how I did it:

    1. install 10.2.0.1 software on a new oracle home
    2. install 10.2.0.3 patchset on top of it
    3. use database upgrade assistant (DBUA) graphic tool to upgrade the database

    After that, I can no longer login using sqlplus / as sysdba, I have to use sqlplus sys/xxxxx as sysdba instead, which violates our company's security policy. How can I make sqlplus / as sysdba work again?

    Thanks a lot!
    May be I am wrong, but I think the poster should rather check v$pwfile_users. May be the remote_login_passwordfile mode is set to none. Also check if SQLNET.AUTHENTICATION_SERVICES is set to (NTS) or not, in sqlnet.ora file. It is applicable only in Windows environment. Also check if you are in OSDBA group in OS.

    HTH,
    gtcol

  9. #9
    Join Date
    Apr 2001
    Posts
    124
    SQL> select * from v$pwfile_users;

    USERNAME SYSDB SYSOP
    ------------------------------ ----- -----
    SYS TRUE TRUE


    SQL> show parameter remote_login_passwordfile

    NAME TYPE VALUE
    ------------------------------------ ----------- ----------------------
    remote_login_passwordfile string EXCLUSIVE

    in sqlnet.ora:

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (TNSNAMES, LDAP, EZCONNECT, ONAMES, HOSTNAME)

    There is no OSDBA group in OS, there is a ORA_DBA group in OS which contains:

    login_username (the local user I use to login)
    NT AUTHORITY\SYSTEM
    Oracle 8, 8i, 9i OCP DBA
    Oracle 6/6i OCP DEV
    Sun Solaris8 SCSA
    MCDBA 2000

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