Re: unable to do a remote sys connection to 12.2 container database
Date: Wed, 12 Feb 2020 10:33:09 -0300
Message-ID: <CAEX1xDWEg=Jv=JeKyJuim+H34Jk=XGy0wh9c1UTgCa2_iybxuw_at_mail.gmail.com>
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
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 12 2020 - 14:33:09 CET