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
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
Ranch Hand
Joined: Feb 18, 2002
Posts: 32
posted
0
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
Ranch Hand
Joined: Jul 11, 2001
Posts: 254
posted
0
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
Ranch Hand
Joined: Feb 18, 2002
Posts: 32
posted
0
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
0
but reasonably 
Had put this here!
