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

From: Marky Mark <DontSpamMe_at_Nospam.org>
Date: Sun, 23 Sep 2001 21:50:34 -0700
Message-ID: <6eetqto5hua4fk681hpf454biu6ebovs33_at_4ax.com>


[Quoted] 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 - 06:50:34 CEST

Original text of this message