Re: internal password of oracle 8i on win2000

I wouldn't say it was typical.

Let's leave aside SYS for the moment, because he can be authenticated in several different ways that can complicate the situation.

You say you changed SYSTEM's password. I take it you did an 'alter user system identified by blah' command. If so, that change goes into the data dictionary, so the only way you could ever face a problem with an incorrect username or password (apart from an astounding inability to type accurately) would be if you weren't connecting to the right database (and hence were connecting to a different data dictionary). So: does connecting as SYSTEM work?

Then we come to connecting internal. Don't, is the short advice. Connect someone/password AS SYSDBA is the proper way to connect in 8i. The usual password at that point is "oracle", but if you've changed SYS's password, then it should be the one you specified.

The only other thing I can say is that 8.1.5 is not certified on Windows 2000, and would, even if it were, be the version I would use if Beelzebub and all his evil minions insisted upon it, and even then only after an appeal to the High Court. Talk about bugs: that version is a walking arboretum.

Regards
HJR

--
------------------------------------------
Resources for Oracle : www.hjrdba.com
============================

"ams" <amitsaddi_at_hotmail.com> wrote in message
news:3301a0bb.0203312134.651b540c_at_posting.google.com...


> i m facin a typical problem on win2000 server.

> i have installed oracle 8i(8.1.5) on win2000. after installation ,

> thru svrmgrl i had changed the passwords for sys and system users.

> once the system is rebooted, i could not login into oracle using

> internal password which i had set for sys account.

> i m given the error of wrong password/username.

> this had happaned many times as i have been trying installing the same

> again and again even over fresh win2000.

> any suggestions pl.

> thanx

>

> amit