Re: unable to do a remote sys connection to 12.2 container database

Jeff,

What is the service_name registered with the listener for the PDB, and does it match the service_name you're providing on the command line:

sqlplus sys/xxxx_at_newcdb as sysdba (is "newcdb" the service_name registered with the listener for the PDB?)

Chris

On Wed, Feb 12, 2020 at 8:42 AM Jeffrey Beckstrom <jbeckstrom_at_gcrta.org> wrote:

> I am trying to do a TNS connection as sys to the CDB and that's when I get
> the invalid username/password error. If I try a TNS connection as system to
> the CDB it works so TNS is correct.
> >>> angelo <angelolistas_at_gmail.com> 2/12/20 8:33 AM >>>
> Hello Jeff.
>
> If you try to connect onto your cdb using sys as sysdba, before.
> and next, change your session from cdb to container. e.g.
>
> SQL> alter session set container=newpdb;
> SQL> show con_id;
>
> Does it work ?
>
> what about services_name from pdb? In TNS, must be different from cdb.
> below, my db tnsnames for example.
>
> CDB =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = xxxdb01.lanocpsp.allspoc.oraclevcn.com)(PORT
> = 1521))
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = CDB01_gru196.lanocpsp.allspoc.oraclevcn.com)
> )
> )
>
> PDB =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = xxxdb01.lanocpsp.allspoc.oraclevcn.com)(PORT
> = 1521))
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = pdb01.lanocpsp.allspoc.oraclevcn.com)
> )
> )
>
>
> On Wed, 12 Feb 2020 at 09:51, Jeffrey Beckstrom <jbeckstrom_at_gcrta.org>
> wrote:
>
>> We have had non-container databases until now. We just built a container
>> and added a PDB to it. We can connect to the container as user "system" as
>> well as a user to the PDB via TNS. However, if we try connect
>> sys/xxxxxx_at_newcdb as sysdba, we get an invalid username/password error.
>> If we try the same connection on the server after setting oracle_sid and
>> not using tns, then it works. However, if we add the TNS string, it then
>> fails. We have created a password file and remote_login_passwordfile is set
>> to exclusive. We have followed our same steps as we would for setting this
>> up for an non-CDB database. We are at a loss as to what is wrong. Any help
>> would be appreciated.
>>
>> Jeffrey Beckstrom
>> Lead Database Administrator
>> Information Technology Department
>> Greater Cleveland Regional Transit Authority
>> 1240 W. 6th Street
>> Cleveland, Ohio 44113
>>
>>
>
> ------------------------------
> This email has been scanned for spam and viruses. Click here
> <https://attseg.cloud-protect.net/index01.php?mod_id=11&mod_option=logitem&mail_id=1581514403-I0hHpL_vQOl2&r_address=jbeckstrom%40gcrta.org&report=1>
> to report this email as spam.
>
>

--
http://www.freelists.org/webpage/oracle-l