\n[oracle@luxor admin]$ cp sqlnet.ora sqlnet.ora.bkp\n[oracle@luxor admin]$ cat sqlnet.ora\nENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=\/opt\/oracle\/dcs\/commonstore\/wallets\/tde\/$ORACLE_UNQNAME)))\n \nSQLNET.ENCRYPTION_SERVER=REQUIRED\nSQLNET.CRYPTO_CHECKSUM_SERVER=REQUIRED\nSQLNET.ENCRYPTION_TYPES_SERVER=(AES256,AES192,AES128)\nSQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA1)\nSQLNET.ENCRYPTION_CLIENT=REQUIRED\nSQLNET.CRYPTO_CHECKSUM_CLIENT=REQUIRED\nSQLNET.ENCRYPTION_TYPES_CLIENT=(AES256,AES192,AES128)\nSQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA1)\nNAMES.DIRECTORY_PATH = (TNSNAMES, EZCONNECT)\n<\/pre><\/div>\n\n\nAp\u00f3s isso, ao reinicializar o listener, os servi\u00e7os dos PDBs s\u00e3o exibidos (at\u00e9 de um segundo novo PDB que eu havia criado, enquanto fazia a investiga\u00e7\u00e3o do problema):<\/p>\n\n\n
\n[opc@luxor ~]$ sudo su - grid\nLast login: Wed May 12 08:49:04 UTC 2021\n[grid@luxor ~]$ lsnrctl stop\n \nLSNRCTL for Linux: Version 19.0.0.0.0 - Production on 12-MAY-2021 08:49:59\n \nCopyright (c) 1991, 2020, Oracle. All rights reserved.\n \nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))\nThe command completed successfully\n[grid@luxor ~]$ lsnrctl start\n \nLSNRCTL for Linux: Version 19.0.0.0.0 - Production on 12-MAY-2021 08:50:05\n \nCopyright (c) 1991, 2020, Oracle. All rights reserved.\n \nStarting \/u01\/app\/19.0.0.0\/grid\/bin\/tnslsnr: please wait...\n \nTNSLSNR for Linux: Version 19.0.0.0.0 - Production\nSystem parameter file is \/u01\/app\/19.0.0.0\/grid\/network\/admin\/listener.ora\nLog messages written to \/u01\/app\/grid\/diag\/tnslsnr\/luxor\/listener\/alert\/log.xml\nListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))\n \nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))\nSTATUS of the LISTENER\n------------------------\nAlias LISTENER\nVersion TNSLSNR for Linux: Version 19.0.0.0.0 - Production\nStart Date 12-MAY-2021 08:50:06\nUptime 0 days 0 hr. 0 min. 0 sec\nTrace Level off\nSecurity ON: Local OS Authentication\nSNMP OFF\nListener Parameter File \/u01\/app\/19.0.0.0\/grid\/network\/admin\/listener.ora\nListener Log File \/u01\/app\/grid\/diag\/tnslsnr\/luxor\/listener\/alert\/log.xml\nListening Endpoints Summary...\n (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))\nThe listener supports no services\nThe command completed successfully\n[grid@luxor ~]$ lsnrctl service\n \nLSNRCTL for Linux: Version 19.0.0.0.0 - Production on 12-MAY-2021 08:50:21\n \nCopyright (c) 1991, 2020, Oracle. All rights reserved.\n \nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))\nServices Summary...\nService "CORTEXXDB.luxorsubnet.luxorvcn.oraclevcn.com" has 1 instance(s).\n Instance "CORTEX", status READY, has 1 handler(s) for this service...\n Handler(s):\n "D000" established:0 refused:0 current:0 max:1022 state:ready\n DISPATCHER <machine: luxor, pid: 8457>\n (ADDRESS=(PROTOCOL=tcp)(HOST=luxor.luxorsubnet.luxorvcn.oraclevcn.com)(PORT=50057))\nService "CORTEX_phx1hb.luxorsubnet.luxorvcn.oraclevcn.com" has 1 instance(s).\n Instance "CORTEX", status READY, has 2 handler(s) for this service...\n Handler(s):\n "DEDICATED" established:0 refused:0 state:ready\n LOCAL SERVER\n "DEDICATED" established:0 refused:0 state:ready\n LOCAL SERVER\nService "c1cf6dcea12f134de0539501000a20c1.luxorsubnet.luxorvcn.oraclevcn.com" has 1 instance(s).\n Instance "CORTEX", status READY, has 2 handler(s) for this service...\n Handler(s):\n "DEDICATED" established:0 refused:0 state:ready\n LOCAL SERVER\n "DEDICATED" established:0 refused:0 state:ready\n LOCAL SERVER\nService "c21efdff5eb40dcde0539501000ac2b8.luxorsubnet.luxorvcn.oraclevcn.com" has 1 instance(s).\n Instance "CORTEX", status READY, has 2 handler(s) for this service...\n Handler(s):\n "DEDICATED" established:0 refused:0 state:ready\n LOCAL SERVER\n "DEDICATED" established:0 refused:0 state:ready\n LOCAL SERVER\nService "hipofise1.luxorsubnet.luxorvcn.oraclevcn.com" has 1 instance(s).\n Instance "CORTEX", status READY, has 2 handler(s) for this service...\n Handler(s):\n "DEDICATED" established:0 refused:0 state:ready\n LOCAL SERVER\n "DEDICATED" established:0 refused:0 state:ready\n LOCAL SERVER\nService "hipofise2.luxorsubnet.luxorvcn.oraclevcn.com" has 1 instance(s).\n Instance "CORTEX", status READY, has 2 handler(s) for this service...\n Handler(s):\n "DEDICATED" established:0 refused:0 state:ready\n LOCAL SERVER\n "DEDICATED" established:0 refused:0 state:ready\n LOCAL SERVER\nThe command completed successfully\n[grid@luxor ~]$\n<\/pre><\/div>\n\n\nAjustando o service name no arquivo tnsnames.ora:<\/p>\n\n\n
\n[oracle@luxor admin]$ cat tnsnames.ora\n# tnsnames.ora Network Configuration File: \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/network\/admin\/tnsnames.ora\n# Generated by Oracle configuration tools.\n \nLISTENER_CORTEX =\n (ADDRESS = (PROTOCOL = TCP)(HOST = luxor.luxorsubnet.luxorvcn.oraclevcn.com)(PORT = 1521))\n \n \nCORTEX_PHX1HB =\n (DESCRIPTION =\n (ADDRESS = (PROTOCOL = TCP)(HOST = luxor.luxorsubnet.luxorvcn.oraclevcn.com)(PORT = 1521))\n (CONNECT_DATA =\n (SERVER = DEDICATED)\n (SERVICE_NAME = CORTEX_phx1hb.luxorsubnet.luxorvcn.oraclevcn.com)\n )\n )\n \nHIPOFISE1 =\n (DESCRIPTION =\n (ADDRESS = (PROTOCOL = TCP)(HOST = luxor.luxorsubnet.luxorvcn.oraclevcn.com)(PORT = 1521))\n (CONNECT_DATA =\n (SERVER = DEDICATED)\n (SERVICE_NAME = HIPOFISE1.luxorsubnet.luxorvcn.oraclevcn.com)\n )\n )\n<\/pre><\/div>\n\n\nRealizando teste, finalmente com sucesso:<\/p>\n\n\n
\n[oracle@luxor admin]$ sqlplus system@HIPOFISE1\n \nSQL*Plus: Release 12.2.0.1.0 Production on Wed May 12 09:00:08 2021\n \nCopyright (c) 1982, 2016, Oracle. All rights reserved.\n \nEnter password:\nLast Successful login time: Wed May 12 2021 08:59:34 +00:00\n \nConnected to:\nOracle Database 12c EE Extreme Perf Release 12.2.0.1.0 - 64bit Production\n \nSQL> SELECT * FROM DUAL;\n \nD\n-\nX\n<\/pre><\/div>\n\n\nObs: Este procedimento foi criado pelo senhor Ahmed Baraka (www.ahmedbaraka.com) e foi apenas reproduzido por mim em um laborat\u00f3rio pessoal para fins de aprendizado.<\/p>\n","protected":false},"excerpt":{"rendered":"
Ao criarmos nosso banco de dados em arquitetura Multitenant no OCI, vimos que a string de conex\u00e3o no arquivo tnsnames.ora possuir\u00e1 apenas o CDB$ROOT, como abaixo: Realizando teste de conex\u00e3o ao CDB$ROOT usando o TNS: Vamos coletar as informa\u00e7\u00f5es necess\u00e1rias para criarmos a nova string de conex\u00e3o do PDB. Por\u00e9m, percebo que o service name […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-4568","post","type-post","status-publish","format-standard","hentry","category-oci"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4568","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=4568"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4568\/revisions"}],"predecessor-version":[{"id":9139,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/4568\/revisions\/9139"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=4568"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=4568"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=4568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}