qdo vc mudou o listener vc deu restart :? tente select sysdate from d...@dblink ;
2009/3/13 Leonardo Santos da Mata <leonardodam...@gmail.com>: > bom eu acho que está faltando alguma coisa no Hs para configura pois o odbc > tá funcionando... > eu vou pesquisar esse erro ora e ver se acho algum resposta. > > 2009/3/13 Alex Castro <alexlucianocas...@gmail.com> > >> Estranho não e rede , pq o yns ping pingou . >> >> Vou pensar aqui e te falo rs >> >> 2009/3/13 Leonardo Santos da Mata <leonardodam...@gmail.com>: >> > vamos lá os resultados: >> > >> > Eu criei o dblink conforme vc mandou e fiz o select segue o resultado: >> > >> > Erro na Linha de Comando:1 Coluna:40 >> > Relatório de Erro: >> > Erro SQL: ORA-28545: error diagnosed by Net8 when connecting to an agent >> > Unable to retrieve text of NETWORK/NCR message 65535 >> > ORA-02063: precedendo 2 lines a partir de SIGESP_DBLINK.COM.BR >> > 28545. 0000 - "error diagnosed by Net8 when connecting to an agent" >> > *Cause: An attempt to call an external procedure or to issue SQL >> > to a non-Oracle system on a Heterogeneous Services database >> link >> > failed at connection initialization. The error diagnosed >> > by Net8 NCR software is reported separately. >> > *Action: Refer to the Net8 NCRO error message. If this isn't clear, >> > check connection administrative setup in tnsnames.ora >> > and listener.ora for the service associated with the >> > Heterogeneous Services database link being used, or with >> > 'extproc_connection_data' for an external procedure call. >> > >> > agora o TNSPING >> > >> > TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on >> 13-MAR-2009 >> > 14:35:48 >> > >> > Copyright (c) 1997, 2005, Oracle. All rights reserved. >> > >> > Used parameter files: >> > /u01/app/oracle/product/10.1.0/db_1/network/admin/sqlnet.ora >> > >> > >> > Used TNSNAMES adapter to resolve the alias >> > Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = >> > 99.999.9.9)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = Sigesp)) >> (HS=OK)) >> > OK (0 msec) >> > >> > >> > o drop do dblink >> > >> > olha o resultado ... >> > drop public database bem-sucedido. >> > >> > mais alguma dica? >> > >> > 2009/3/13 Alex Castro <alexlucianocas...@gmail.com> >> > >> >> tente assim >> >> >> >> create public database link LINK_NOME.COM.BR connect to USUARIO >> >> identified by "senha " using 'TNS_NAME_CRIADO'; >> >> >> >> SELECT "CAMPO" FROM tab...@link ; >> >> TESTE USAR ASPAS NO SELECT >> >> >> >> TESTE TB >> >> >> >> tnsping TNS_NAME_CRIADO e me fala qual o retorno >> >> >> >> drop public database link LINK_ACCESSW.UNIBH.BR >> >> >> >> >> >> select * from tabela_acc...@link_accessw.unibh.br >> >> >> >> 2009/3/13 Leonardo Santos da Mata <leonardodam...@gmail.com>: >> >> > CREATE DATABASE LINK "XXXXXX.REGRESS.RDBMS.DEV.US.ORACLE.COM" >> >> > CONNECT TO "USUARIO" IDENTIFIED BY VALUES 'SENHA' >> >> > USING 'Xxxxxx'; >> >> > >> >> > 2009/3/13 Alex Castro <alexlucianocas...@gmail.com> >> >> > >> >> >> me passa o comando de criacao do dblink >> >> >> >> >> >> deve ser questao de " . >> >> >> >> >> >> me passa q te retorno com uams possiveis mudanças uam deals deve >> >> funcionaer >> >> >> >> >> >> 2009/3/13 Leonardo Santos da Mata <leonardodam...@gmail.com>: >> >> >> > oi alex, >> >> >> > eu segui o que mandou >> >> >> > já chequei duas vezes ... >> >> >> > qdo criou do DBlink e mando testar está vindo a seguinte msg de >> erro. >> >> >> > >> >> >> > Erro na Linha de Comando:1 Coluna:19 >> >> >> > Relatório de Erro: >> >> >> > Erro SQL: ORA-28545: error diagnosed by Net8 when connecting to an >> >> agent >> >> >> > Unable to retrieve text of NETWORK/NCR message 65535 >> >> >> > ORA-02063: precedendo 2 lines a partir de SIGESP >> >> >> > 28545. 0000 - "error diagnosed by Net8 when connecting to an >> agent" >> >> >> > *Cause: An attempt to call an external procedure or to issue SQL >> >> >> > to a non-Oracle system on a Heterogeneous Services >> database >> >> >> link >> >> >> > failed at connection initialization. The error diagnosed >> >> >> > by Net8 NCR software is reported separately. >> >> >> > *Action: Refer to the Net8 NCRO error message. If this isn't >> clear, >> >> >> > check connection administrative setup in tnsnames.ora >> >> >> > and listener.ora for the service associated with the >> >> >> > Heterogeneous Services database link being used, or with >> >> >> > 'extproc_connection_data' for an external procedure call. >> >> >> > >> >> >> > vc sabe como eu resolvo isso? >> >> >> > Obrigado >> >> >> > 2009/3/11 Alex Castro <alexlucianocas...@gmail.com> >> >> >> > >> >> >> >> HS ORACLE >> >> >> >> ------------------------------------------------------------ >> >> >> >> >> >> >> >> Verifique a existência de <ORACLE_HOME>HS >> >> >> >> Caso não exista execute : >> >> >> >> <ORACLE_HOME>\network\admin\caths.sql >> >> >> >> >> >> >> >> >> >> >> >> 2 - Você precisa ter o serviço odbc instalado e configurado . >> >> >> >> >> >> >> >> Exemplo : >> >> >> >> >> >> >> >> [myodbc] >> >> >> >> Driver = /usr/local/lib/libmyodbc.so >> >> >> >> Description = MySQL ODBC 2.50 Driver DSN >> >> >> >> SERVER = localhost >> >> >> >> PORT = >> >> >> >> USER = root >> >> >> >> Password = >> >> >> >> Database = test >> >> >> >> OPTION = 3 >> >> >> >> SOCKET = >> >> >> >> >> >> >> >> Configure esse arquivo em /etc/odbc.ini ( Como root ) >> >> >> >> >> >> >> >> Nosso caso vou usar myodbc como nome do dns do odbc >> >> >> >> >> >> >> >> EDITE <ORACLE_HOME>\network\admin\listener.ora >> >> >> >> >> >> >> >> Vai ficar mais ou menos assim : >> >> >> >> >> >> >> >> SID_LIST_LISTENER = >> >> >> >> (SID_LIST = >> >> >> >> (SID_DESC = >> >> >> >> (SID_NAME = PLSExtProc) >> >> >> >> (ORACLE_HOME = C:\oraclexe\app\oracle\product\10.2.0\server) >> >> >> >> (PROGRAM = extproc) >> >> >> >> ) (SID_DESC = >> >> >> >> (PROGRAM = hsodbc) >> >> >> >> (SID_NAME = interbase) >> >> >> >> (ORACLE_HOME = >> C:\oraclexe\app\oracle\product\10.2.0\server)) >> >> >> >> ) >> >> >> >> >> >> >> >> ATENÇÃO : >> >> >> >> >> >> >> >> A LINHA ACRESCENTADA FOI ESSA : >> >> >> >> >> >> >> >> o SID_NAME É O nome no qual vou dar para o serviço . >> >> >> >> Nosso caso sid_myodbc >> >> >> >> >> >> >> >> (SID_DESC = >> >> >> >> (PROGRAM = hsodbc) >> >> >> >> (SID_NAME = sid_myodbc) >> >> >> >> (ORACLE_HOME = >> C:\oraclexe\app\oracle\product\10.2.0\server)) >> >> >> >> >> >> >> >> >> >> >> >> Em seguida você vai em : >> >> >> >> >> >> >> >> <ORACLE_HOME>\network\admin\tnsnames.ora ( TNS CLIENT ) >> >> >> >> >> >> >> >> E add a linha : >> >> >> >> >> >> >> >> MYODBC = >> >> >> >> (DESCRIPTION = >> >> >> >> (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) >> >> >> >> (CONNECT_DATA = >> >> >> >> (SERVICE_NAME = sid_myodbc) >> >> >> >> ) >> >> >> >> (HS=OK) >> >> >> >> ) >> >> >> >> >> >> >> >> ATENÇÃO O SERVICE_NAME E O NOME DADO PARA O SID NO LISTENER >> >> >> >> >> >> >> >> >> >> >> >> em seguida criar um arquivo seguinte : >> >> >> >> >> >> >> >> <ORACLE_HOME>\hs\admin\init******.ora >> >> >> >> >> >> >> >> ****** é o nome dado ao SID_NAME . nosso caso sid_myodbc >> >> >> >> >> >> >> >> Nosso caso : initsid_myodbc.ora >> >> >> >> >> >> >> >> Sendo seu conteudo : >> >> >> >> >> >> >> >> HS_FDS_CONNECT_INFO = myodbc >> >> >> >> >> >> >> >> HS_FDS_TRACE_LEVEL = off >> >> >> >> >> >> >> >> HS_NLS_DATE_LANGUAGE ='DD-MM-YYYY' >> >> >> >> HS_NLS_DATE_FORMAT ='DD-MM-YYYY' >> >> >> >> >> >> >> >> OBS : HS_FDS_CONNECT_INFO RECEBE O NOEM DO SEU SERVIÇO ODBC (DNS) >> >> >> >> >> >> >> >> <ORACLE_HOME>\network\admin\sqlnet.ora >> >> >> >> >> >> >> >> Vai deixar o seu sqlnet.ora assim : >> >> >> >> >> >> >> >> SQLNET.AUTHENTICATION_SERVICES= (NONE) >> >> >> >> NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) >> >> >> >> >> >> >> >> * Sempre lembre de tirar backup dos arquivos , antes de altera-los >> >> >> >> >> >> >> >> >> >> >> >> AGORA BASTA CRIAR : >> >> >> >> >> >> >> >> CREATE PUBLIC DATABASE LINK LNK_HSODBC >> >> >> >> CONNECT TO DB_ACCESS >> >> >> >> IDENTIFIED BY DB_PASSWORD >> >> >> >> USING ‘MYODBC’ ; >> >> >> >> >> >> >> >> ** USING LEVA O NOME DO SEU TNS_NAME CRIADO >> >> >> >> >> >> >> >> DEPOIS BASTA : >> >> >> >> >> >> >> >> SELECT >> >> >> >> * >> >> >> >> FROM >> >> >> >> stu_...@lnk_hsodbc ; >> >> >> >> >> >> >> >> >> >> >> >> 2009/3/11 Leonardo Santos da Mata <leonardodam...@gmail.com>: >> >> >> >> > Alex aproveitando o espaço eu tenho interesse nisso tb. >> >> >> >> > >> >> >> >> > Tipo eu tenho oracle 10g instalado no linux e tenho interesse em >> >> fazer >> >> >> o >> >> >> >> > dblink para mysql e Ms sql server. >> >> >> >> > >> >> >> >> > Sevc pode me ajudar eu te agradeço. >> >> >> >> > >> >> >> >> > 2009/3/11 Alex Castro <alexlucianocas...@gmail.com> >> >> >> >> > >> >> >> >> >> Para qual finalidade ? >> >> >> >> >> Provavelmente vc deve querer fazer um dblink para um outro >> banco . >> >> >> >> >> Preciso saber qual banco e qual plataforma para te passar o >> >> tutorial >> >> >> >> >> adequado >> >> >> >> >> >> >> >> >> >> 2009/3/10 fsilva6 <fsil...@yahoo.com.br <fsilva6% >> 40yahoo.com.br >> >> >>: >> >> >> >> >> >> >> >> >> >> > Como faço para configurar o Heterogeneous Services nos >> >> servidores >> >> >> onde >> >> >> >> o >> >> >> >> >> > oracle está instalado no UNIX? >> >> >> >> >> > >> >> >> >> >> > >> >> >> >> >> >> >> >> >> >> -- >> >> >> >> >> Alex Luciano Castro e Castro - Analista de Banco de Dados >> >> >> >> >> >> >> >> >> >> >> >> >> >> > >> >> >> >> > -- >> >> >> >> > ______________________________________________ >> >> >> >> > Leonardo Santos da Mata >> >> >> >> > skype lsmata | msn leonardodam...@hotmail.com >> >> >> >> > ______________________________________________ >> >> >> >> > >> >> >> >> > [As partes desta mensagem que não continham texto foram >> removidas] >> >> >> >> > >> >> >> >> > >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> -- >> >> >> >> Alex Luciano Castro e Castro - Analista de Banco de Dados >> >> >> >> >> >> >> >> >> >> >> >> ------------------------------------ >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> -------------------------------------------------------------------------------------------------------------------------- >> >> >> >> >Atenção! As mensagens do grupo ORACLE_BR são de acesso público e >> de >> >> >> >> inteira responsabilidade de seus remetentes. >> >> >> >> Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ >> >> >> >> >> >> >> >> >> >> >> >> >> >> -------------------------------------------------------------------------------------------------------------------------- >> >> >> >> >Apostilas » Dicas e Exemplos » Função » Mundo Oracle » Package » >> >> >> Procedure >> >> >> >> » Scripts » Tutoriais - O GRUPO ORACLE_BR TEM SEU PROPRIO ESPAÇO! >> >> >> VISITE: >> >> >> >> http://www.oraclebr.com.br/ >> >> >> >> >> >> >> >> >> >> ------------------------------------------------------------------------------------------------------------------------ >> >> >> >> Links do Yahoo! Grupos >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> > >> >> >> > >> >> >> > -- >> >> >> > ______________________________________________ >> >> >> > Leonardo Santos da Mata >> >> >> > skype lsmata | msn leonardodam...@hotmail.com >> >> >> > ______________________________________________ >> >> >> > >> >> >> > >> >> >> > [As partes desta mensagem que não continham texto foram removidas] >> >> >> > >> >> >> > >> >> >> > >> >> >> > ------------------------------------ >> >> >> > >> >> >> > >> >> >> >> >> >> -------------------------------------------------------------------------------------------------------------------------- >> >> >> >>Atenção! As mensagens do grupo ORACLE_BR são de acesso público e de >> >> >> inteira responsabilidade de seus remetentes. >> >> >> > Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ >> >> >> > >> >> >> >> >> >> -------------------------------------------------------------------------------------------------------------------------- >> >> >> >>Apostilas » Dicas e Exemplos » Função » Mundo Oracle » Package » >> >> >> Procedure » Scripts » Tutoriais - O GRUPO ORACLE_BR TEM SEU PROPRIO >> >> ESPAÇO! >> >> >> VISITE: http://www.oraclebr.com.br/ >> >> >> > >> >> >> >> >> >> ------------------------------------------------------------------------------------------------------------------------ >> >> >> Links do Yahoo! Grupos >> >> >> > >> >> >> > >> >> >> > >> >> >> >> >> >> >> >> >> >> >> >> -- >> >> >> Alex Luciano Castro e Castro - Analista de Banco de Dados >> >> >> >> >> >> >> >> >> ------------------------------------ >> >> >> >> >> >> >> >> >> >> >> >> -------------------------------------------------------------------------------------------------------------------------- >> >> >> >Atenção! As mensagens do grupo ORACLE_BR são de acesso público e de >> >> >> inteira responsabilidade de seus remetentes. >> >> >> Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ >> >> >> >> >> >> >> >> >> -------------------------------------------------------------------------------------------------------------------------- >> >> >> >Apostilas » Dicas e Exemplos » Função » Mundo Oracle » Package » >> >> Procedure >> >> >> » Scripts » Tutoriais - O GRUPO ORACLE_BR TEM SEU PROPRIO ESPAÇO! >> >> VISITE: >> >> >> http://www.oraclebr.com.br/ >> >> >> >> >> >> ------------------------------------------------------------------------------------------------------------------------ >> >> >> Links do Yahoo! Grupos >> >> >> >> >> >> >> >> >> >> >> > >> >> > >> >> > -- >> >> > ______________________________________________ >> >> > Leonardo Santos da Mata >> >> > skype lsmata | msn leonardodam...@hotmail.com >> >> > ______________________________________________ >> >> > >> >> > >> >> > [As partes desta mensagem que não continham texto foram removidas] >> >> > >> >> > >> >> > >> >> > ------------------------------------ >> >> > >> >> > >> >> >> -------------------------------------------------------------------------------------------------------------------------- >> >> >>Atenção! As mensagens do grupo ORACLE_BR são de acesso público e de >> >> inteira responsabilidade de seus remetentes. >> >> > Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ >> >> > >> >> >> -------------------------------------------------------------------------------------------------------------------------- >> >> >>Apostilas » Dicas e Exemplos » Função » Mundo Oracle » Package » >> >> Procedure » Scripts » Tutoriais - O GRUPO ORACLE_BR TEM SEU PROPRIO >> ESPAÇO! >> >> VISITE: http://www.oraclebr.com.br/ >> >> > >> >> >> ------------------------------------------------------------------------------------------------------------------------ >> >> Links do Yahoo! Grupos >> >> > >> >> > >> >> > >> >> >> >> >> >> >> >> -- >> >> Alex Luciano Castro e Castro - Analista de Banco de Dados >> >> >> >> >> >> ------------------------------------ >> >> >> >> >> >> >> -------------------------------------------------------------------------------------------------------------------------- >> >> >Atenção! As mensagens do grupo ORACLE_BR são de acesso público e de >> >> inteira responsabilidade de seus remetentes. >> >> Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ >> >> >> >> >> -------------------------------------------------------------------------------------------------------------------------- >> >> >Apostilas » Dicas e Exemplos » Função » Mundo Oracle » Package » >> Procedure >> >> » Scripts » Tutoriais - O GRUPO ORACLE_BR TEM SEU PROPRIO ESPAÇO! >> VISITE: >> >> http://www.oraclebr.com.br/ >> >> >> ------------------------------------------------------------------------------------------------------------------------ >> >> Links do Yahoo! Grupos >> >> >> >> >> >> >> > >> > >> > -- >> > ______________________________________________ >> > Leonardo Santos da Mata >> > skype lsmata | msn leonardodam...@hotmail.com >> > ______________________________________________ >> > >> > >> > [As partes desta mensagem que não continham texto foram removidas] >> > >> > >> > >> > ------------------------------------ >> > >> > >> -------------------------------------------------------------------------------------------------------------------------- >> >>Atenção! As mensagens do grupo ORACLE_BR são de acesso público e de >> inteira responsabilidade de seus remetentes. >> > Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ >> > >> -------------------------------------------------------------------------------------------------------------------------- >> >>Apostilas » Dicas e Exemplos » Função » Mundo Oracle » Package » >> Procedure » Scripts » Tutoriais - O GRUPO ORACLE_BR TEM SEU PROPRIO ESPAÇO! >> VISITE: http://www.oraclebr.com.br/ >> > >> ------------------------------------------------------------------------------------------------------------------------ >> Links do Yahoo! Grupos >> > >> > >> > >> >> >> >> -- >> Alex Luciano Castro e Castro - Analista de Banco de Dados >> >> >> ------------------------------------ >> >> >> -------------------------------------------------------------------------------------------------------------------------- >> >Atenção! As mensagens do grupo ORACLE_BR são de acesso público e de >> inteira responsabilidade de seus remetentes. >> Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ >> >> -------------------------------------------------------------------------------------------------------------------------- >> >Apostilas » Dicas e Exemplos » Função » Mundo Oracle » Package » Procedure >> » Scripts » Tutoriais - O GRUPO ORACLE_BR TEM SEU PROPRIO ESPAÇO! VISITE: >> http://www.oraclebr.com.br/ >> ------------------------------------------------------------------------------------------------------------------------ >> Links do Yahoo! Grupos >> >> >> > > > -- > ______________________________________________ > Leonardo Santos da Mata > skype lsmata | msn leonardodam...@hotmail.com > ______________________________________________ > > > [As partes desta mensagem que não continham texto foram removidas] > > > > ------------------------------------ > > -------------------------------------------------------------------------------------------------------------------------- >>Atenção! As mensagens do grupo ORACLE_BR são de acesso público e de inteira >>responsabilidade de seus remetentes. > Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ > -------------------------------------------------------------------------------------------------------------------------- >>Apostilas » Dicas e Exemplos » Função » Mundo Oracle » Package » Procedure » >>Scripts » Tutoriais - O GRUPO ORACLE_BR TEM SEU PROPRIO ESPAÇO! VISITE: >>http://www.oraclebr.com.br/ > ------------------------------------------------------------------------------------------------------------------------ > Links do Yahoo! Grupos > > > -- Alex Luciano Castro e Castro - Analista de Banco de Dados ------------------------------------ -------------------------------------------------------------------------------------------------------------------------- >Atenção! As mensagens do grupo ORACLE_BR são de acesso público e de inteira >responsabilidade de seus remetentes. Acesse: http://www.mail-archive.com/oracle_br@yahoogrupos.com.br/ -------------------------------------------------------------------------------------------------------------------------- >Apostilas » Dicas e Exemplos » Função » Mundo Oracle » Package » Procedure » >Scripts » Tutoriais - O GRUPO ORACLE_BR TEM SEU PROPRIO ESPAÇO! VISITE: >http://www.oraclebr.com.br/ ------------------------------------------------------------------------------------------------------------------------ Links do Yahoo! Grupos <*> Para visitar o site do seu grupo na web, acesse: http://br.groups.yahoo.com/group/oracle_br/ <*> Para sair deste grupo, envie um e-mail para: oracle_br-unsubscr...@yahoogrupos.com.br <*> O uso que você faz do Yahoo! Grupos está sujeito aos: http://br.yahoo.com/info/utos.html