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

Recovering passwords from Oracle 8.0.4.1.1 database on Windows NT SP6 server

I have just been asked to get data out of our old membership database. It is Oracle 8.0.4.1.1 running on a Windows NT SP6 server. It has not been in production since 2000. No one is still here from the admininstration side from the last time it was used. We don't have the SYSTEM, SYS or internal password for Oracle. There was a client program that was programmed in magic8 that used to connect into it. When you try and connect through it you get a "ORA-01034: ORACLE not available" message. When you try and click on the enterprise manager you get a VOC.exe error: "The application failed to initialize properly." All services appear to be started. Is there a way to recover passwords? Any recommendations on how to go about trouble shooting this kind of problem? Am I out of luck without the passwords?

The ORA-1034 error message is indicating that your database is not up and running. You'll need to start the database and once it is running, you can change the SYS, SYSTEM, and any other account passwords to something that you know. To fix your problem, follow these steps:

  1. Sign on to the Windows server as an Administrator.
  2. Start a DOS command line window.
  3. Type: svrmgrl
  4. Type: connect internal
  5. Type: startup

The database should now be started. You can change the passwords of any account with the SQL like the following:

ALTER USER system IDENTIFIED BY manager;

Dig Deeper on Oracle database backup and recovery

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