Forum Stats

  • 3,855,574 Users
  • 2,264,523 Discussions
  • 7,906,071 Comments

Discussions

How to publish 18c XE pluggable XEPDB1

Jose Aróstegui
Jose Aróstegui Member Posts: 1,358 Silver Badge
edited Sep 8, 2019 10:18PM in Multitenant

Hi experts,

I'm pretty new with multitenant and I've just created an empty virtual cloud server and installed XE database 18c for testing purposes.

After installing and configuring, a pluggable database XEPDB1 is created and I've test that I can connect to it from my remote PC with this syntax:

sqlplus system/[email protected]:1521/xepdb1

I'd need to connect from my PC using the tradicional tnsnames+listener like:

sqlplus system/[email protected]

But I'm struggling with it without success... can anybody help, please?

Thanks,
Jose.

Answers

  • Gaz in Oz
    Gaz in Oz Member Posts: 3,785 Bronze Crown
    edited Sep 8, 2019 10:18PM

    On your remote client create a tnsnames.ora file and set TNS_ADMIN to the directory where you created it.

    You can copy the database entry tnsnames.ora into the client tnsnames.ora. It will look something like:

    XEPDB1 =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = your_db_server)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = xepdb1)    )  )

    As you have displayed no errors, it is assumed you have sqlplus already on your remote client machine, if not you can download instantclient: basic or basiclikte,  along with  sqlplus from here:

    https://www.oracle.com/database/technologies/instant-client/downloads.html