Re: Enterprise Manager

The following is absolutely correct: you cannot log in as SYSDBA - Oracle should/must remove the option entirely, so as to make this clear. It's buried in the documentation that you MUST log in as NORMAL! Regards. Brendan

Mr_DBA_at_hotmail.com wrote:

> You should not be loggin into OEM with sys account. Read OEM
> documentation for detail, but the general order of you actions should be
> like this: 1. Create repository tablespace in the database (20Mb will be
> enough). 2. Create user account in Oracle for OEM user (repository
> account) and grant connect, resource, dba, snmpagent to this user (I
> appologize if I omitted something). Make sure you specify repository
> tablespace as a default for this user. 3. Create NT user account with the
> same userid / password as repository account. Make sure this account is
> in the administrators group. Then go to user rights, select advanced
> rights and grant "logon as batch job" to this account - you will need it
> to run Oracle Intelligent Agent. 4. Restart (it it is already running)
> Oracle Agent. When it's down, delete *.q files from
> ORACLE_HOME\network\agent directory. 5. Log into OEM using that
> account/password. It will create repository (in repository tablespace, of
> course).
>
> In short, do not use "SYS as SYSDBA".
>
> In article <19980124025500.VAA06171_at_ladder02.news.aol.com>,
> reddayz_at_aol.com (RED DAYZ) wrote:
> >
> > I ran across that problem too, I think what you have to do (can't remember how
> > I fixed the problem) is to set the PASSWORD variable in the init<sid>.ora file
> > to EXTERNAL (or something like that). Then it should work fine.
> >
> > PASSWORD = EXTERNAL
> > Please forgive me, this happened too long agao for me to remember what the
> > exact wording was. E-mail me if it didn't work out, and I'll give you the
> > correct setting.
> >
> > Satar Naghshineh
> > satarnag_at_microcad.com
> >
> > >>Hi,
> > >>
> > >>I have installed Oracle 7.3.3 on Windows NT4.0 (the database was created
> > >>automaticaly).
> > >>
> > >>When i try to connect to Enterprise Manager with SYS (and the correct
> > >>password) as SYSDBA, an error occur (ORA-1031:Insufficient privileges).Why?
> > >>(Note:I can connect in line mode with Svrmgr23)
> > >>
> > >>Thanks
> > >
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Wed Jan 28 1998 - 00:00:00 CST