Re: SYS-SYSDBA

From: johnkoo <johnkoo_at_i-wave.net>
Date: Fri, 12 Mar 1999 19:49:06 -0000
Message-ID: <7cav3v$4du1@news.hk.linkage.net>

Hi Roberto,

That's simple, just make sure the username your are going to connect to Oracle as SYSDBA or SYSOPER actually defined in V$PWFILE_USERS. Note 1:Only SYS can view this table. NOTE 2: SYS is a default user in V$PWFILE_USERS. For example, start svrmgrl, and then "connect SYS/CHANGE_ON_INSTALL as SYSDBA"
Try if it work or not. NOTE 3: SYSTEM is NOT set to have SYSDBA role for security purpose by default.

John Koo
johnkoo_at_i-wave.net

Roberto wrote in message <36E8F1F0.F74DB72E_at_sunul-1.ita.es>...
>Hi
>i'm new in Oracle, i've installed Oracle8 Enterprise server and i put
>the user SYS and password for default, and i connect as normal, all work
>well, but when i connect as SYSDBA or SYSOPER i say me
>ORA-01017; invalid username/password;logon denied
>
>Whis is it?, How can i connect as SYSDBA ?
>
Received on Fri Mar 12 1999 - 13:49:06 CST