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

And show please file permissions for your pwfile. ls -la

ср, 12 февр. 2020 г., 17:33 Sayan Malakshinov <xt.and.r_at_gmail.com>:

> 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