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