This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Password for Oracle startup database

 
nav hunjan
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have downloaded Oracle 9i personal edition for windows 98 OS from oracle website. The problem is, when i start SQLPLUS after giving the login name and password i.e system and manager it asks for oracle 9i database startup password which i donot know. I need to know the password for that. An early comment will be really appreciated.
Thank you in advance
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think you haven't started the database up.
You should have a startup menu item in your start menu, under programs, and then somewhere in an Oracle submenu.
When you installed you might have been asked to create as sys user with password, this should be the password to startup the database.
Mark
 
Nathan Johnson
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
 
Nathan Johnson
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Anyone? Please? Mark?
 
Beksy Kurian
Ranch Hand
Posts: 254
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am not sure about 9i. But in 8i personal edition,there is a registry parameter DBA_AUTHORIZATION that can be set to the value of your INTERNAL password (defaults to ORACLE and can be found in regedit->hkey_loacal_machine ->software->oracle).
Best regards
Beksy
 
Nathan Johnson
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Beksy,
I am at work now but I will certainly try that out later!
Nav,
Have you had any joy yet?
 
nav hunjan
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Nathan ,
No luck so far. Tried most of the things but nothing so far. Please someone help me out here.
 
Beksy Kurian
Ranch Hand
Posts: 254
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try deleting and re-creating the PWDsid.ora file in the
%ORACLE_HOME%\database directory
Beksy
 
Bal Sharma
Ranch Hand
Posts: 273
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hummm! I am using Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production. I tried to download Personal Edition did not have luck. It is really big file. I bought Enterprise Edition for learning purpose. It cost me $39.99 plus shipping handling all together $55. Oracle shiped me 21 CDs. I only installed 3CDs out of them. I do not know what other CDs are. Hope some day I will know it.
I had no problem for start up data base. I used following user and password. System liked it.
USER PASSWORD
Syschange_on_install
Systemmanager
Scotttiger
Hope it helps a little bit. -Bal
 
Nathan Johnson
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
 
Rene Larsen
Ranch Hand
Posts: 1179
Eclipse IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi
This is what the dokumentation says:
Oracle9 i Personal Edition
Installation Guide
Release 1 (9.0.1.1.0) for Windows 98
Unlocking and Changing Passwords
At the end of installation, several configuration assistants automatically start to
create and configure your database and network environments. One such assistant
is the Oracle Database Configuration Assistant. When Oracle Database
Configuration Assistant finishes your database configuration, it displays a screen
with your database information and the Password Management button. Use the
Password Management button to change this information immediately after
installation.
To change a password during the database installation and configuration process:
1. From the Oracle Database Configuration Assistant window, choose the
Password Management button.
2. Select the username and clear the check mark.
3. Enter a new password and confirm the new password for each username.
Alternatively, use SQL*Plus to unlock accounts and change passwords any time
after the installation process.
Note: The Password Management button is not available when
using Oracle Database Configuration Assistant as a standalone tool.
Note: If you unlock a password, but do not specify a new
password, then the password is expired until the next time you
access that account.

/Ren´┐Ż
 
nav hunjan
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks to all of you. I will definetly try these options today and let you (all) about this.
Thanks alot in advance

Nav
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic