Removing Oracle 9.2 from a Windows 2003 server

Posted on 2012-09-09
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
    LVL 23

    Accepted Solution

    - 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

    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

    It worked great thank you

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    Via a live example, show how to take different types of Oracle backups using RMAN.

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now