|
-
 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
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
|
Reply With Quote