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

Hi,

Have you tried to set authentication_services=(none) in sqlnet.ora?

ср, 12 февр. 2020 г., 17:28 Jeffrey Beckstrom <jbeckstrom_at_gcrta.org>:

> I am trying to connect to the cdb not the pdb.
>
> connect sys/xxxx_at_newcdb as sysdba - fails
> connect system/xxxxx_at_newcdb - works
> >>> Chris Taylor <christopherdtaylor1994_at_gmail.com> 2/12/20 9:21 AM >>>
> 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.
>>
>>
>
> ------------------------------
> 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=1581517284-i5rj7HAk6gz8&r_address=jbeckstrom%40gcrta.org&report=1>
> to report this email as spam.
>
>

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