ScoobyNet.com - Subaru Enthusiast Forum

Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Recover SYS password for oracle 9.2 database?

Thread Tools
 
Search this Thread
 
Old Oct 26, 2005 | 12:54 PM
Share
  #1  
TopBanana's Avatar
TopBanana
Thread Starter
Scooby Regular
 
Joined: Jan 2001
Posts: 9,781
Likes: 0
Question 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
Reply
0
Old Oct 26, 2005 | 01:02 PM
Share
  #2  
T4molie's Avatar
T4molie
Scooby Regular
 
Joined: Dec 2002
Posts: 2,617
Likes: 0
From: Dum dum de dum....
Default
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>
Reply
0
Old Oct 26, 2005 | 09:25 PM
Share
  #3  
Wurzel's Avatar
Wurzel
Scooby Senior
iTrader: (1)
 
Joined: Nov 2000
Posts: 9,708
Likes: 73
From: Wildberg, Germany/Reading, UK
Default
On the oracle server

su - oracle

sqlplus /nolog

connect /as sysdba

alter user sys identified by ***********
Reply
0
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
How long does it take
Iqy7861
Insurance
5
Oct 1, 2015 07:57 PM
Possible ecu (syvecs) power issue.
DogsofWar
Engine Management and ECU Remapping
16
Sep 23, 2015 07:41 PM
Android Lollipop users - time to lower your security
JackClark
Computer & Technology Related
7
Sep 17, 2015 04:23 PM
Civic, Bimma or Scooby?
MOFO wit 44
ScoobyNet General
8
Aug 24, 2001 07:45 PM
I`m no detective ,but..
Moz
ScoobyNet General
1
Mar 17, 2000 02:27 PM
Back to Subforum
Computer & Technology Related
View Next Unread
Anyone know wher I can get this connector from




Advanced Search
Reply Closed Thread Share
Forum Jump

All times are GMT +1. The time now is 10:32 PM.