Re: Connection to database and cluster database RACDB as user sys failed.
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: Gus Spier <gus.spier@xxxxxxxxx>
- Date: Fri, 28 Jan 2011 17:48:35 -0300
Gus,
Thanks, but I think you are misunderstanding the point. These are the
database credentials that are giving me troubles, no the EM. In fact, I am
logged in as a superadministrator to EM, so this should not be a problem.
cheers
Alan.-
On Thu, Jan 27, 2011 at 9:14 PM, Gus Spier <gus.spier@xxxxxxxxx> wrote:
> According to *Oracle® Enterprise Manager Administration 10g Release 5
> (10.2.0.5)*,
> http://download.oracle.com/docs/cd/B16240_01/doc/em.102/e14586/user_setup.htm#BABCFBCA,
> there is a Super Administrator account, SYSMAN. Quoting the documentation,
> The super administrator account can manage all other administrator accounts
> and set up all administrator credentials. The super administrator can:
>
> -
>
> Create Enterprise Manager privileges and roles
> -
>
> Perform the initial setup of Enterprise Manager, for example, defining
> e-mail configurations and defining global notifications rules
> -
>
> Add targets to Enterprise Manager
> -
>
> Perform any action on any target in the system
>
> Oracle recommends that you create an administrator account for each
> individual user. The super administrator account should not be used to
> conduct daily administration tasks.
>
> Perhaps this is the account you must logged in with?
>
> v/r,
>
> Gus
>
>
> On Thu, Jan 27, 2011 at 3:07 PM, Guillermo Alan Bort <cicciuxdba@xxxxxxxxx
> > wrote:
>
>> Listers,
>>
>> I find myself at a loss right now.
>>
>> this is an 11g EM (11.1.0.1.0) on Linux x86_64. I am trying to connect to
>> the 'services' page of a cluster (10.2.0.4.0) of 4 nodes.
>>
>> I connect to the EM, then go to targets, Databases, click on RACDB, then
>> the availability tab, then cluster managed service database. Then it asks to
>> specify both an OS and a DB user. The db user needs to be sysdba. So I
>> provide the 'oracle' credentials and the 'sys' credentials and I get
>> Connection to database and cluster database RACDB as user sys failed.
>>
>> This is consistently happening.
>>
>> I am certain that the password I am using for both the sys and oracle
>> users are correct. (connecting from sqlplus and toad works ok)
>>
>> I tried to create a new sysdba users with the dba and connect roles and I
>> got the same error.
>>
>> from the OMS server I am unable to connect using sql*plus because the
>> target host does not exist. I checked and the OMS home does not have a
>> tnsnames file. I assume that since the target was configured and is
>> otherwise working flawlessly, this has nothing to do with that.
>>
>> I checked and I have both access to the listener and agent port. The same
>> with ssh port.
>>
>> I tried google and metalink, but the error is too generic and neither was
>> much help. Is there a log or a trace I can enable or something to see a more
>> detailed error?
>>
>> thanks in advance
>>
>>
>> Alan.-
>>
>
>
Other related posts:
