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 -> Re: sys,SYSTEM can not login to OEM

Re: sys,SYSTEM can not login to OEM

From: koert54 <koert54_at_nospam.com>
Date: Tue, 26 Feb 2002 22:00:56 GMT
Message-ID: <sATe8.198128$rt4.21022@afrodite.telenet-ops.be>

> Besides, if I want remote connect with 'sys' without specify 'AS SYSDBA',
> can I still login?
> This is the case when I install 9iAS on another computer(NT/2000).
>

This is the case when you run portal configuration assistent - for this to work on 9i databases
you should set
O7_DICTIONARY_ACCESSIBILITY=TRUE
in your init.ora or spfile.ora file...
This will make it possible to connect as sys 'without' 'as sysdba'... Received on Tue Feb 26 2002 - 16:00:56 CST

Original text of this message

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