Meaningless Drivel is fun!*
The moose likes Oracle/OAS and the fly likes Password for Oracle startup database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Password for Oracle startup database" Watch "Password for Oracle startup database" New topic
Author

Password for Oracle startup database

nav hunjan
Greenhorn

Joined: May 12, 2002
Posts: 7
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

Joined: Feb 05, 2001
Posts: 17258
    
    6

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


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Nathan Johnson
Ranch Hand

Joined: Feb 18, 2002
Posts: 32
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

Joined: Feb 18, 2002
Posts: 32
Anyone? Please? Mark?
Beksy Kurian
Ranch Hand

Joined: Jul 11, 2001
Posts: 254
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

Joined: Feb 18, 2002
Posts: 32
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

Joined: May 12, 2002
Posts: 7
Nathan ,
No luck so far. Tried most of the things but nothing so far. Please someone help me out here.
Beksy Kurian
Ranch Hand

Joined: Jul 11, 2001
Posts: 254
Try deleting and re-creating the PWDsid.ora file in the
%ORACLE_HOME%\database directory
Beksy
Bal Sharma
Ranch Hand

Joined: Sep 19, 2001
Posts: 273
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

Joined: Feb 18, 2002
Posts: 32
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

Joined: Oct 12, 2001
Posts: 1179

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´┐Ż


Regards, Rene Larsen
Dropbox Invite
nav hunjan
Greenhorn

Joined: May 12, 2002
Posts: 7
Thanks to all of you. I will definetly try these options today and let you (all) about this.
Thanks alot in advance

Nav
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Password for Oracle startup database