Q
Problem solve Get help with specific problems with your technologies, process and projects.

Password and error problems with installation of Personal Oracle

I had downloaded Personal Oracle 9i for Windows 98 from the Oracle site. During the installation, I selected the option to install the starter database and gave the global database name as SIMI.SIMON and SID as SIMI. Now, when I try to start the instance, it asks me for a password, which I don't know. Also, when I try to start DBCA, it fails without throwing any error.

I had downloaded Personal Oracle 9i for Windows 98 from the Oracle site. During the installation, I selected the option to install the starter database and gave the global database name as SIMI.SIMON and SID as SIMI. Now, when I try to start the instance, it asks me for a password, which I don't know. Also, when I try to start DBCA, it fails without throwing any error. I tried running the dbca.bat file in the Bin directory and get the error "oracle.dbca not available." Please help.
If you are being asked for a password, it likely means that the database is using a password file and you are being asked to authenticate since you are logging in as SYSDBA or SYSOPER. OS authentication, however, takes precedence over the password file so if you are a member of the OSDBA or OSOPER groups, you could try not entering a password and just pressing ENTER.

If this does not work, try changing the init.ora parameter REMOTE_LOGIN_PASSWORDFILE to NONE rather than EXCLUSIVE. This should allow you to connect as SYSDBA or SYSOPER without a password to start the database. At this point, you can recreate the password file, change the init.ora parameter back to its original value and then change the password for SYS.

With respect to your problem using DBCA, check in $ORACLE_HOMEassistantsdbcalogs for a log file. If DBCA is failing, it will usually create a log in this location.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close