Re: [Spam] Re: Issues Connecting to PDB

From: Andy Sayer <andysayer_at_gmail.com>
Date: Thu, 30 Jun 2022 08:09:27 -0700
Message-ID: <CACj1VR4xeGj_z7H7yFg644ska1FmVVo3FKJ7Q61VB1jkM_PFCg_at_mail.gmail.com>



Hi Scott,

This is a new error, so you are progressing.

The host ip in the tnsping is not the same ip you have for your listener.ora. You have started a listener on this ip but your local_listener parameter of your instance is not configured to point to it so it does not know about the service.

You can either use a tnsnames entry or an EZConnect string in your local_listener parameter to point to the 10.16.4.144 listener. Once you’ve set that, check the listener with lsnrctl status 10.16.4.144:1521 (you might need to wait a minute for LREG to update the listener - you can use 'alter system register;' to hurry it along). Once the service is registered, try with sqlplus again.

Thanks,
Andy

>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 30 2022 - 17:09:27 CEST

Original text of this message