-
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!
-
your ORACLE_HOME is probably set wrong - change it
-
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
-
yes it should be.
but you dont say what the error is either so its a bit hard to help
-
the error is ORA-01031: insufficient privileges
Oracle 8, 8i, 9i OCP DBA
Oracle 6/6i OCP DEV
Sun Solaris8 SCSA
MCDBA 2000
-
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
-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|