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

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Wed, 12 Feb 2020 22:29:47 +0300
Message-ID: <CAOVevU5-T9YFf5MY_MU6ToN8Uu1j-YRKTeONBpcXhbxc0eczHg_at_mail.gmail.com>



Is ORACLE_SID=newcdb? Have you tried simple passwords without special characters?

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

> did a
> connect / as sysdba
> alter user sys identified by xxxxxx
> connect sys/xxxxx_at_newcdb as sysdba
> ora-1017
> >>> Seth Miller <sethmiller.sm_at_gmail.com> 2/12/20 1:13 PM >>>
> It really sounds like you are using the wrong password. The only way to be
> sure is to use OS auth to connect and change the sys password as Sayan
> suggested.
>
> On Wed, Feb 12, 2020 at 9:21 AM Jeffrey Beckstrom <jbeckstrom_at_gcrta.org>
> wrote:
>
>> [dbsorat08:/oracle/db/12_2_0_1/dbs:newcdb] $ orapwd describe
>> file=orapwnewcdb
>> Password file Description : format=12.2
>>
>> >>> "Sweetser, Joe" <JSweetser_at_icat.com> 2/12/20 10:10 AM >>>
>> (really far) Left field idea. Can you check the format of your password
>> file?
>> I had issues with 19c (and the format of the password file) where I had
>> to recreate my password file with the 12.2 format (it was 12 after creating
>> a database). Probably not directly related to your issue but…
>> $ orapwd describe file=orapwqa19c1
>> Password file Description : format=12
>> $ mv orapwqa19c1 orapwqa19c1.format12
>> $ orapwd file=orapwqa19c1 entries=10 format=12.2
>> Enter password for SYS:
>> $ orapwd describe file=orapwqa19c1
>> Password file Description : format=12.2
>> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
>> Behalf Of *Sayan Malakshinov
>> *Sent:* Wednesday, February 12, 2020 7:45 AM
>> *To:* Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
>> *Cc:* oracle-l-freelist <oracle-l_at_freelists.org>; angelo <
>> angelolistas_at_gmail.com>; Chris Taylor <christopherdtaylor1994_at_gmail.com>
>> *Subject:* 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
>> <https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Fxxxdb01.lanocpsp.allspoc.oraclevcn.com%2F&data=02%7C01%7CJSweetser%40icat.com%7C8f70d35e63a94b9b122e08d7afca58eb%7C5d3bf30e9adb4c17b2425c17523e6e5e%7C0%7C0%7C637171155924404567&sdata=LN5oKhznGC9DbkX4SidnrvRMZWzsaP8OPFaAQuG11RQ%3D&reserved=0>)(PORT
>> = 1521))
>> (CONNECT_DATA =
>> (SERVER = DEDICATED)
>> (SERVICE_NAME = CDB01_gru196.lanocpsp.allspoc.oraclevcn.com
>> <https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Fcdb01_gru196.lanocpsp.allspoc.oraclevcn.com%2F&data=02%7C01%7CJSweetser%40icat.com%7C8f70d35e63a94b9b122e08d7afca58eb%7C5d3bf30e9adb4c17b2425c17523e6e5e%7C0%7C0%7C637171155924414563&sdata=hmdf6Dr1Y2pRgPiTZcX%2F0Bdfx7g4KbH73yZexXkQnx8%3D&reserved=0>
>> )
>> )
>> )
>>
>> PDB =
>> (DESCRIPTION =
>> (ADDRESS = (PROTOCOL = TCP)(HOST = xxxdb01.lanocpsp.allspoc.oraclevcn.com
>> <https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Fxxxdb01.lanocpsp.allspoc.oraclevcn.com%2F&data=02%7C01%7CJSweetser%40icat.com%7C8f70d35e63a94b9b122e08d7afca58eb%7C5d3bf30e9adb4c17b2425c17523e6e5e%7C0%7C0%7C637171155924414563&sdata=4Bf5F%2BmTVuJOhhEqa7nn5VqaC3qSWMKVic%2BMDn8%2F06w%3D&reserved=0>)(PORT
>> = 1521))
>> (CONNECT_DATA =
>> (SERVER = DEDICATED)
>> (SERVICE_NAME = pdb01.lanocpsp.allspoc.oraclevcn.com
>> <https://nam05.safelinks.protection.outlook.com/?url=http%3A%2F%2Fpdb01.lanocpsp.allspoc.oraclevcn.com%2F&data=02%7C01%7CJSweetser%40icat.com%7C8f70d35e63a94b9b122e08d7afca58eb%7C5d3bf30e9adb4c17b2425c17523e6e5e%7C0%7C0%7C637171155924424556&sdata=Mona%2FUrNiad2fmklc3G8L%2BJY8C5zKKvWz9cVvS7ECtM%3D&reserved=0>
>> )
>> )
>> )
>> 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://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fattseg.cloud-protect.net%2Findex01.php%3Fmod_id%3D11%26mod_option%3Dlogitem%26mail_id%3D1581514403-I0hHpL_vQOl2%26r_address%3Djbeckstrom%2540gcrta.org%26report%3D1&data=02%7C01%7CJSweetser%40icat.com%7C8f70d35e63a94b9b122e08d7afca58eb%7C5d3bf30e9adb4c17b2425c17523e6e5e%7C0%7C0%7C637171155924424556&sdata=hSqL8wL6mgwfxArt85lYihzgvrA5zgNbIi9sJR1EWFs%3D&reserved=0>
>> to report this email as spam.
>>
>> ------------------------------
>> This email has been scanned for spam and viruses. Click here
>> <https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fattseg.cloud-protect.net%2Findex01.php%3Fmod_id%3D11%26mod_option%3Dlogitem%26mail_id%3D1581517284-i5rj7HAk6gz8%26r_address%3Djbeckstrom%2540gcrta.org%26report%3D1&data=02%7C01%7CJSweetser%40icat.com%7C8f70d35e63a94b9b122e08d7afca58eb%7C5d3bf30e9adb4c17b2425c17523e6e5e%7C0%7C0%7C637171155924424556&sdata=G3K4QF6nCWRDUXBeSAgX4BaUfNTOMUf4arGofqk2sHo%3D&reserved=0>
>> to report this email as spam.
>>
>> ------------------------------
>> This email has been scanned for spam and viruses. Click here
>> <https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fattseg.cloud-protect.net%2Findex01.php%3Fmod_id%3D11%26mod_option%3Dlogitem%26mail_id%3D1581518140-025vOXKdWIif%26r_address%3Djbeckstrom%2540gcrta.org%26report%3D1&data=02%7C01%7CJSweetser%40icat.com%7C8f70d35e63a94b9b122e08d7afca58eb%7C5d3bf30e9adb4c17b2425c17523e6e5e%7C0%7C0%7C637171155924434551&sdata=W4Y0www842NDsvghxb9ClDl9pgP8%2FXK7y10QjkX7VEA%3D&reserved=0>
>> to report this email as spam.
>>
>> This e-mail transmission and any attachments that accompany it may
>> contain information that is privileged, confidential or otherwise exempt
>> from disclosure under applicable law and is intended solely for the use of
>> the individual's to whom it was intended to be addressed. If you have
>> received this e-mail by mistake, or you are not the intended recipient, any
>> disclosure, dissemination, distribution, copying or other use or retention
>> of this communication or its substance is prohibited. If you have received
>> this communication in error, please immediately reply to the author via
>> e-mail that you received this message by mistake and also permanently
>> delete the original and all copies of this e-mail and any attachments from
>> your computer. Please note that coverage cannot be bound or altered by
>> sending an email. You must receive written confirmation from a
>> representative of our firm to put coverage in force or make changes to an
>> existing policy.
>> ------------------------------
>> 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=1581520211-nSJY438esRrv&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=1581531198-ASwHQa7HLrDc&r_address=jbeckstrom%40gcrta.org&report=1>
> to report this email as spam.
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 12 2020 - 20:29:47 CET

Original text of this message