Help: Lost sys/system password

From: Joe Bayerii <joebayerii(--)_at_ureach.com>
Date: Tue, 26 Jul 2005 09:51:51 GMT
Message-ID: <XInFe.2444$3p2.951@trndny04>

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?

Your help is highly appreciated.

The system is Oracle 9204 on RedHat Linux AS, (3.0) Received on Tue Jul 26 2005 - 04:51:51 CDT