Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help: Lost sys/system password

Re: Help: Lost sys/system password

From: Trociu <trociu_at_autonom.ict.pwr.wroc.pl>
Date: 29 Jul 2005 02:38:47 GMT
Message-ID: <slrndej5jd.10m.trociu@autonom.ict.pwr.wroc.pl>


On 2005-07-26, Joe Bayerii wrote:
> One of my client lost his sys/system password. After I sudo to oracle user,
> re-generated password file with "Orapwd file =xxx password=test123",, I try
> to use "sqlplus /nolog", "connect sys as sysdba", oracle asked for my
> password, after I typed test123, it retured error "insufficient privilege".
>
> In most of my system, I do not even need to provide password to login as
> sys, as long as I sudo to oracle user.
>
> What should I do now? The passwordfile init parameter is set to
> "exclusive". what is wrong with this box?

Hello. I just did this three days ago. In my case it was:

root_at_DEV # su - oracle
root_at_DEV $ id
uid=300(oracle) gid=300(dba)
root_at_DEV $ sqlplus /nolog

SQL*Plus: Release 9.2.0.5.0 - Production on Fri Jul 22 15:46:04 2005 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL> connect as sysdba
Enter user-name: sys
Enter password:
Connected.
SQL> alter user sys identified by s;
User altered.
SQL> where password I left blank (just pressed ENTER) Maybe try like this

Trociu

-- 
Plain-text over all!!!
/**********/
write me   : trociu_at_autonom ict pwr wroc pl
search me  : gg: 1382729
Received on Thu Jul 28 2005 - 21:38:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US