• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

Oracle 9i Personal Edition password.

 
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Do I really need to provide one everytime I need to startup the database?
Thanks Nathan.
 
ranger
Posts: 17347
11
Mac IntelliJ IDE Spring
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 254
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 32
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 254
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 32
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 254
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic