Re: 9i on linux, connect as sys problem

From: D.Y. <dyou98_at_aol.com>
Date: 2 Nov 2002 03:11:33 -0800
Message-ID: <f369a0eb.0211020311.1cea2d52@posting.google.com>

"charlie cs" <cs3526_at_ureach.com> wrote in message news:<LyDw9.659$t1.587_at_nwrddc02.gnilink.net>...
> I installed 9i on Linux 2.4
>
> if I connect as follows
> SQL> connect sys/passwd_at_c_rac1
> Connected.
> SQL> connect / as sysdba
> Connected.
>
> But if I do
> SQL> connect sys/passwd_at_c_rac1 as sysdba
> ERROR:
> ORA-01017: invalid username/password; logon denied
> Warning: You are no longer connected to ORACLE.
> SQL>
>

Look in v$pwfile_users. If SYS is not one of the users, you probably don't have a password file. Use orapwd to create one. Also set remote_login_passwordfile=exclusive and restart your instance. Don't forget to recreate your spfile.

> Did anybody have similar problem?
>
> Thanks for your help.
Received on Sat Nov 02 2002 - 05:11:33 CST