Win a copy of Microservices Testing (Live Project) this week in the Spring forum!

Nathan Johnson

Ranch Hand
+ Follow
since Feb 18, 2002
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by 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
20 years ago
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!
20 years ago
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!
20 years ago
Can I do this online i.e. by e-mail!
20 years ago
Do I really need to provide one everytime I need to startup the database?
Thanks Nathan.
20 years ago
Oh okay!
Apologises if any offence has been taken. So as not to digress from the subject matter of this thread I am about to start a new thread re: 9i Oracle PE and database startup passwords.
My apologises yet again, in my eagerness to really get stuck into Oracle I seemed have forgotten my manners!
20 years ago
Thanks Beksy,
I don't appear to have said scripts so I'll have to get in touch with Oracle.
Thanks again!
20 years ago
.. or 'DEMF' don't expect much feedback!
20 years ago
I have just managed to successfully install Oracle9i PE Release 9.0.1.1.1.
However, it looks as if the new sample schemas i.e. HR, OE, PM, etc., introduced to show off the newer capabilities of the Oracle database has not been included in this release of Oracle.
I am pretty certain this is the case as when I attempt to unlock one of the users in one of the new sample schemas I get an ORA-01918: user does not exist error message.
Is this some sort of oversight by Oracle? Or do they have a valid reason for this omission? Or am I just to dim to locate these new schemas?
20 years ago
Nav,
I can now startup the database even though I am still prompted for a password.
Here is what I had to do in the end.
De-install the Oracle software using the Oracle Installer (after stopping any services if you managed to start any!).
Remove the Oracle directory.
Remove any entries in the Registry.
Remove the Oracle branch from HKEY_LOCAL_MACHINE | SOFTWARE
Remove all Oracle services from HKEY_LOCAL_MACHINE | SOFTWARE | CurrentControlSet | Services.
The Oracle Installer should have removed Oracle entries in the Win98 environment. If not do so!
Re-install Oracle 9i
Change the SYS and SYSTEM passwords when prompted by Password Management Tool (I made them both the same!)
Re-boot PC.
Now use the new password when starting up the database.
Curiously, during installation, towards the end there is a part, which claims to set the Startup Database Auto, even though this succeeded, I am still prompted for a password when starting up. Very strange! I’d be interested to know if this happens to you as well!
Also because I used identical passwords for SYS and SYSTEM (and in all honesty being a bit of a novice with all things Oracle), I am not entirely sure which password is used to start up the database – SYS or SYSTEM (or both!), I’ll look into it a bit more another time, or perhaps one of the guru’s looking in might be able to help!
In any case, after days of tinkering with it the thing now works!
20 years ago
Thanks Beksy,
I am at work now but I will certainly try that out later!
Nav,
Have you had any joy yet?
20 years ago
Anyone? Please? Mark?
20 years ago
I am sorry I also have this password problem with starting the 9i database for the Personal Edition and I have tried logging on as you have suggested but I am still not having any success.
Any other suggestion? Please!
20 years ago
Thanks Sita!
20 years ago
JSP