I have just been asked to get data out of our old membership database. It is Oracle 126.96.36.199.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:
- Sign on to the Windows server as an Administrator.
- Start a DOS command line window.
- Type: svrmgrl
- Type: connect internal
- 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;