Erro ao tentar conectar do Cliente 11g Servidor TS no Oracle Database 11g Release 11.2.0.4.0 em Real Application Clusters and Automatic Storage Management
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
oracle@bdora-11g ~]$ rlwrap sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed Jun 19 23:24:37 2019 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production With the Real Application Clusters and Automatic Storage Management options Verificando o nome do serviço SQL> select value from v$parameter where name='service_names'; VALUE -------------------------------------------------------------------------------- BD11G_iad18f.privatesubnet.natvcn.oraclevcn.com |
Ajustando tsnames
Editar o /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/tnsnames.ora
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0.4/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. BD11G_IAD18F = (DESCRIPTION = (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = BD11G_iad18f.privatesubnet.natvcn.oraclevcn.com) ) ) BD11G = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = bdora-11g.privatesubnet.natvcn.oraclevcn.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = BD11G_iad18f.privatesubnet.natvcn.oraclevcn.com ) ) ) |
Resolvido!