Re: Connection to database and cluster database RACDB as user sys failed.

  • From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
  • To: Peter Nedeljkovich <pnedeljkovich@xxxxxxxxxxxxxxx>
  • Date: Thu, 27 Jan 2011 17:59:04 -0300

I tried as system as well, got the same error. The drop down that allows you
to choose the connection role (sysdba) is greyed out and set as sysdba...

cheers
Alan.-


On Thu, Jan 27, 2011 at 5:11 PM, Peter Nedeljkovich <
pnedeljkovich@xxxxxxxxxxxxxxx> wrote:

>  I think you have to login as system, not sys
>
>
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Guillermo Alan Bort
> *Sent:* Thursday, January 27, 2011 3:07 PM
> *To:* oracle-l-freelists
> *Subject:* Connection to database and cluster database RACDB as user sys
> failed.
>
>
>
> 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.-
>
> --
> This message was scanned by the Georgian College ESVA and is believed to be
> clean.
>

Other related posts: