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

Could you try also connect using OS authentication and change sys password using alter user...

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

> xxxxxxxx:/oracle/db/12_2_0_1/dbs:] $ ls -al orapwnewcdb
> -rw-r-----. 1 oradmin oinstall 11264 Feb 12 09:37 orapwnewcdb
> xxxxxxx:/oracle/db/12_2_0_1/dbs:] $
>
> >>> Sayan Malakshinov <xt.and.r_at_gmail.com> 2/12/20 9:35 AM >>>
> 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.
>>>
>>>
>
> ------------------------------
> 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=1581518140-025vOXKdWIif&r_address=jbeckstrom%40gcrta.org&report=1>
> to report this email as spam.
>
>

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