If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I applied two patches to my base 8.1.6 (8i) last night to bring it to 8.1.6.3.8 Now, when entering the database I can't connect sys or internal as sysdba - only as normal. The error tells me that it is an invalid username or password but I can use the same username and password to connect as normal. What is the best way to remedy this? I am on a windows 2000 platform.

Originally posted by ratfink I applied two patches to my base 8.1.6 (8i) last night to bring it to 8.1.6.3.8 Now, when entering the database I can't connect sys or internal as sysdba - only as normal. The error tells me that it is an invalid username or password but I can use the same username and password to connect as normal. What is the best way to remedy this? I am on a windows 2000 platform.

While you're at it, did you try connecting as
connect internal/pwd@string as sysdba
That shud have worked.
Interesting note:
I ended up similarly with a rather unexplainable situation. I had a pwd veify fxn ran on my test db, after a certain period of time ,which was today i was prompted in my sql*plus to change pwd of user sys, so i did.
Now within the sql*plus i did again
connect sys/newpwd@string as sysdba
no luck!
then i did
internal/pwd@string as sysdba
ok!
and then i said hey let's try
connect sys/oldpwd@string as sysdba.
OK!!!?
I for now don't have a clue but i'll prod on..............

So far nothing has worked. Tried the v$pwfile_users and it returned no rows! Tried your connect internal trick - nada! Tried changing the internal password using oradim - nothing. Recreated the password file multiple times - rebooted - nothing! We are tearing our hair out now.... sys will logon fine as sysoper or normal but not sysdba. Internal can't logon as all. System still will work with normal. Any more ideas??? Nothing that I have gotten from metalink has worked.

We finally figured it out. Thank you everyone for your help. As you read this you will see how everyone's contribution fit in. We had the correct stuff - just the wrong order of things and I hadn't shut down the db and services. This is what we did and it worked - I have two sids that I had to do this with.

To change the password for “internal”
Stop the database and all services first.
at the command line:
Make sure you are in the correct SID by first typing
SET ORACLE_SID=
Then SET ORACLE_SID to make sure that it worked

oradim –edit –sid –intpwd

Also – while the services are still off – rename or remove the password file for the sid located in InstallDrive:/Oracle/Ora81/DATABASE.
at the command line (make sure that Oracle/Ora81/BIN is in path):