how to allow connect / as sysdba in windows 10.2

[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!

[davey23uk]

your ORACLE_HOME is probably set wrong - change it

[zxmgh]

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.

[davey23uk]

yes it should be.

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

[zxmgh]

the error is ORA-01031: insufficient privileges

[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

[davey23uk]

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

[gtcol]

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

[zxmgh]

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