Re: Help: Lost sys/system password

From: Moritz Klein <mklein_at_students.uni-mainz.de>
Date: Tue, 26 Jul 2005 12:26:24 +0200
Message-ID: <dc52v3$869$1@news1.zdv.uni-mainz.de>

Joe Bayerii schrieb:
> 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".

I always thought you have to use "connect / as sysdba" to use Operation System Authentification. Maybe should try this one.

> 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.

Use other connect syntax as shown above.

hth,
Moritz Received on Tue Jul 26 2005 - 05:26:24 CDT