Removing Oracle 9.2 from a Windows 2003 server

Posted on 2012-09-09
Medium Priority
Last Modified: 2013-02-08
I have a 2003 server which I have been brought in to support and I need to remove the old oracle databases that are no longer being used, but no one knows the sys password.  How can I get around this?
Question by:PCIDSSman
  • 2
LVL 23

Accepted Solution

OP_Zaharin earned 2000 total points
ID: 38381544
- do you want to remove Oracle software completely from the system or just the database? if you want to remove Oracle software and the database from the server, you can use Oracle Universal Installer (OUI). it should available in the Windows Start Menu for Oracle.

- if you need the password just to remove 1 database,  i can't remember if you can change sys password directly however you can change the password using the following steps using sqlplus on dos prompt:

1- from dos prompt run sqlplus with sysdba:
c:> sqlplus "/ as sysdba"

2- change the SYSTEM password first
sql> passw system
Changing password for system
New password:
Retype new password:
Password changed

3- quit sqlplus then login as SYSTEM
SQL> quit

c:> sqlplus system
Enter password:

4- then change the SYS password:
SQL> passw sys
Changing password for sys
New password:
Retype new password:
Password changed

SQL> quit

- you can also refer to the doc for using GUI to change the password or using the default password if its never been changed after the installation:

Author Comment

ID: 38381598
Thank you for your quick response.  I found the password in a .bat file that had been created to do a backup and restore of the database, so I am good to go.

Author Closing Comment

ID: 38868623
It worked great thank you

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses
Course of the Month14 days, 13 hours left to enroll

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question