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 -> sys and system in 9i

sys and system in 9i

From: Ed Wong <ewong_at_mail.com>
Date: 4 Jul 2003 15:27:50 -0700
Message-ID: <a5ae1554.0307041427.1ae6d623@posting.google.com> 





I've migrated an instance from 8.1.7 to 9.2.0.  After the migration, I
can connect to system by connection string "system/password_at_tnsnames"
but can't do that as sys.  I got an error ORA-28009: connection to sys
should be as sysdba or sysoper.    Is it a normal behavior?



If I need to do "connect / as sysdba" instead of connecting
sys/password, why oracle doesn't make "system" account the same way?



Thanks,


ewong
Received on Fri Jul 04 2003 - 17:27:50 CDT












Original text of this message













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