Oracle 9i Personal Edition password.

[Nathan Johnson]

Do I really need to provide one everytime I need to startup the database?
Thanks Nathan.

[Mark Spritzler]

Well, I think the answer is yes. And the reason I say that is because, would you like your database to be able to be started up by any user on your computer.
Yes, I know your laptop might never leave your side and no other person ever touches it. But what about having it on your work machine, that someone could walk into you office and startup your database, and do what they want. I think it is the security issue that you need this. In Oracle you still have to be logged in as SYS to startup your database.
Mark

[Beksy Kurian]

Nathan,
Read this link to know that you are not alone in this startup password mess.
http://www.oracle.com/forums/find.jsp?t=startup%20password
I assume that none of the suggestions we have given in the previous thread started by Nuv worked!
As a last option, try whatever mentioned in this link.
http://www.orafaq.com/msgboard/windows/messages/1368.htm
Beksy

[Nathan Johnson]

Thanks Mark and Beksy,
Yes, the thread started by Nav help me tremendously, although I had to uninstall 9i and remnants of 8i floating about in the registry and then re-install and made sure I change the password's SYS and SYSTEM using the password management tool.
After this the database was fine, apart from not being able to load the new sample schemas provided with 9i as the required directory cannot be found anywhereon my laptop.
I can appreciate the security aspect of having a password to startup the database in 9i, I am just surprised that this was not the case with the 8i Personal Edition and I suppose this is really what I am asking, if this is new feature with 9i Personal Edition.
To further complicate the issue, my colleague at work has 9i PE for Win98 on his NT laptop and he is not asked to supply a password everytime he starts the database up! but reasonably
Thanks again!

[Nathan Johnson]

As a last option, try whatever mentioned in this link.
http://www.orafaq.com/msgboard/windows/messages/1368.htm
Beksy
Now I'm confused! People were having these problems(?) with 8i as well?
I suppose there can be no harm in de-installing and installing a couple of times, but I must say this does not impress me one bit.
Hopefully, I get my sample schemas loaded eventually as I can now live with and in all honesty, prefer the password option for starting the datbase, although according to the link this may now disappear.
If so can it be re-instated somehow? Had put this here!

[Beksy Kurian]

Nathan,
I understand the frustration. Installing 2 or 3 times should not be a solution to any problem. Unfortunately I do not have windows98 with me to atleast try it out. Since I thought the thread was interesting, I decided to research it in different forums and found the above suggestions.
Let me ask you one more question?
What is the value of REMOTE_LOGIN_PASSWORDFILE in your init.ora file?
And, value of sqlnet.authentication_services in the sqlnet.ora file?
Beksy
[ June 18, 2002: Message edited by: Beksy Kurian ]

[Nathan Johnson]

Sorry Beksy,
This de and re-installing Oracle has finally rendered my laptop useless and I have been busy trying to return some sanity to the laptop recently.
Which is why I am just replying to your post. I am presently at work my laptop is at home, I will have a look when I get back.
Thanks for replying

[Beksy Kurian]