Re: Cloud Control Issue

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 30 Jul 2020 17:12:09 -0400
Message-ID: <cb474384-e88c-d724-f7d6-3716304f46b8_at_gmail.com>



Hi Scott,

Yes, I am talking about the database password file. I believe you should recreate it without the "format" option. As for the question why, I can only guess, just like you.  New feature perhaps?

Regards

On 7/30/20 5:02 PM, Scott Canaan wrote:
>
> I’m assuming you are talking about the database password file.  If so,
> then it was created using format=12, because it was 12c at the time.  
> Should I recreate it with a different format? Why would it have worked
> yesterday before I patched and not now?
>
> *Scott Canaan ‘88**
> */Sr Database Administrator
> /Information & Technology Services
> Finance & Administration **
>
> *Rochester Institute of Technology
> *o: (585) 475-7886 | f: (585) 475-7520**
>
> _srcdco_at_rit.edu <mailto:srcdco_at_rit.edu>_| c: (585) 339-8659
>
> *CONFIDENTIALITY NOTE*: The information transmitted, including
> attachments, is intended only for the person(s) or entity to which it
> is addressed and may contain confidential and/or privileged material.
> Any review, retransmission, dissemination or other use of, or taking
> of any action in reliance upon this information by persons or entities
> other than the intended recipient is prohibited. If you received this
> in error, please contact the sender and destroy any copies of this
> information.
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>
> *On Behalf Of *Mladen Gogala
> *Sent:* Thursday, July 30, 2020 4:53 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* Re: Cloud Control Issue
>
> I have had a similar problem with a client. I was able to log in using
> sqlplus but unable to log in using dgmgrl. The problem was the
> password file format. Client has specified 12c format, which doesn't
> enforce the security rules and that was fine for SQL*Plus but not fine
> for dgmgrl. Your description leads me to the conclusion that this is
> the same problem. However, the database that I was working with was
> 19.7, not 19.8. I am unable to reproduce this with 19.8.
>
> Regards
>
> On 7/30/20 4:42 PM, Scott Canaan wrote:
>
> Yesterday, I applied the July PSU to the database behind Cloud
> Control.  Now, I can’t log in via Cloud Control.  I try to log in
> and I get the message saying that the user or password is
> invalid.  But I can log into the database via SQL*Plus with the
> user / password.  How do I fix this?
>
> DB version = 19.8
>
> CC version = 13.3
>
> *Scott Canaan ‘88**
> */Sr Database Administrator
> /Information & Technology Services
> Finance & Administration
>
> *Rochester Institute of Technology
> *o: (585) 475-7886 | f: (585) 475-7520
>
> _srcdco_at_rit.edu <mailto:srcdco_at_rit.edu>_| c: (585) 339-8659
>
>
> *CONFIDENTIALITY NOTE*: The information transmitted, including
> attachments, is intended only for the person(s) or entity to which
> it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use
> of, or taking of any action in reliance upon this information by
> persons or entities other than the intended recipient is
> prohibited. If you received this in error, please contact the
> sender and destroy any copies of this information.
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 30 2020 - 23:12:09 CEST

Original text of this message