ScoobyNet.com - Subaru Enthusiast Forum - Recover SYS password for oracle 9.2 database?

ScoobyNet.com - Subaru Enthusiast Forum (https://www.scoobynet.com/)

- Computer & Technology Related (https://www.scoobynet.com/computer-and-technology-related-34/)

- - Recover SYS password for oracle 9.2 database? (https://www.scoobynet.com/computer-and-technology-related-34/466510-recover-sys-password-for-oracle-9-2-database.html)

TopBanana

26 October 2005 12:54 PM

Recover SYS password for oracle 9.2 database?

One of the devs left and he's taken the password with him for one of our dev servers. I'm trying to sort out this stuff out before I close the project down, so anyone have any ideas?

Ta muchly

T4molie

26 October 2005 01:02 PM

Have spoken to one of my DBA's and they suggest (assuming you know it) Login to the DB as the SYSTEM user and then use

ALTER USER SYS IDENTIFIED BY <type in new password>

Wurzel

26 October 2005 09:25 PM

On the oracle server

su - oracle

sqlplus /nolog

connect /as sysdba

alter user sys identified by ***********

All times are GMT +1. The time now is 12:16 PM.