Re: Enterprise Manager

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