Re: Which account to use for SYSDBA so DBA Studio doesn't make attributes read-only?

From: Brandon <oracle.admin_at_home.com>
Date: Mon, 24 Sep 2001 21:53:52 GMT
Message-ID: <QXNr7.100545$xb.54147091_at_news1.mntp1.il.home.com>


[Quoted] The contents of entire Oracle DBA brains can be found on http://otn.oracle.com. That includes the documentation that we all memorized, too (several versions worth). ;)

Brandon

"Marky Mark" <DontSpamMe_at_Nospam.org> wrote in message news:6eetqto5hua4fk681hpf454biu6ebovs33_at_4ax.com...
> More useful help. Never mind. That was intended to be somewhat funny
> but hey, I'm just dumb, clueless newbie with no manuals to read. Of
> the various news groups that I sometimes post questions to, this one
> has the most attitude and the least useful information. Just another
> reason to love oracle; look what it does to those who live and
> breath it.
>
> Mark
>
> On Sat, 22 Sep 2001 19:27:03 +0200, "Sybrand Bakker"
> <postbus_at_sybrandb.demon.nl> while speculating on the nature of life,
> the universe and everything, wrote:
>
> >
> >"Marky Mark" <DontSpamMe_at_Nospam.org> wrote in message
> >news:uglnqtccaf424m6t775s5p7158r8avc73q_at_4ax.com...
> >> I'm using Oracle 8.1.6 and trying to use DBA Studio with the
> >> Enterprise Manager Server.
> >>
> >> Two things:
> >>
> >> 1. Although I have the Enterprise Manager service set to "Automatic"
> >> on Windows 2000 Advanced Server, it doesn't start. I have to
> >> manually start it. Anyone know how to fix this?
> >>
> >> 2. I just installed Enterprise Manager and I want to use DBA Studio
> >> to do things like backups. However, it keeps complaining about
> >> default credentials not being set in E.M. First, I'm not sure which
> >> accounts to use for things like "node", etc. Then, when I set
> >> userid's for the database and default database, I can't get DBA
> >> studio to let me alter initialization params. It just says that the
> >> account doesn't have SYSDBA. Now I'm totally confused.
> >>
> >> I've used sysman to log into Enterprise Manager, and have tried both
> >> system and sys as the credentials for the database entry. However, I
> >> can't seem to log onto either one using anything other than SYSOPER
> >> or NORMAL and both of those make DBA Studio bitch about not having
> >> SYSDBA.
> >>
> >> Other than using Oracle, what am I doing wrong?
> >>
> >> Thanks,
> >> Mark
> >>
> >
> >
> >Just because of your last phrase, you're just asking for it:
> >
> >Hacking away, and not reading any Oracle provided documentation.
> >
> >
> >Regards,
> >
> >Sybrand Bakker, Senior Oracle DBA
> >
> >
>
>
Received on Mon Sep 24 2001 - 23:53:52 CEST

Original text of this message