Menu de navegação

[Sousa04Participante]

Olá pessoal,

Estou tentando configurar o Heterogeneous Service realizando a seguinte configuração nos arquivos:

initSID.ora
listener.ora
tnsnames.ora

/u01/app/oracle/product/10.2.0/db_1/hs/admin/inittoolsdb.ora
#PARAMETRO
HS_FDS_CONNECT_INFO=TOOLSDB
HS_FDS_SHAREABLE_NAME=/usr/lib/libodbc.so
HS_DB_NAME = TOOLSDB
HS_FDS_TRACE_LEVEL=4
HS_FDS_TRACE_FILE_NAME = $ORACLE_HOME/admin/trace/hsodbc.lob
set ODBCINI=/etc/odbc.ini

/u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC=
(SID_NAME = TOOLSDB)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = hsodbc)
(ENVS=LD_LIBRARY_PATH=/usr/lib:/home/oracle/db2_cli_odbc_driver/clidriver/lib:/u01/app/oracle/product/10.2.0/db_1/lib)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = LinuxOracle.infra.com.br)(PORT = 1521))
)
)

/u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = LinuxOracle.infra.com.br)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

TOOLSDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.68.36.33)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TOOLSDB)
)
(HS = OK)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

Dai realizei o teste para ver se está tudo ok

$ tnsping toolsdb

TNS Ping Utility for Linux: Version 10.2.0.1.0 – Production on 21-MAR-2011 13:25:00

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
/u01/app/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.68.36.33)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = TOOLSDB)) (HS = OK))
OK (10 msec)

testei tbm a conexão com o ambiente heterogêneo para ver se está tudo ok

$ isql -v toolsdb db2inst1 db2inst1
+—————————————+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+—————————————+
SQL>

Então parti para criação dos dblinks no Oracle

SQL> CREATE PUBLIC DATABASE LINK TOOLSDB
CONNECT TO DB2INST1
IDENTIFIED by DB2INST1
USING ‘toolsdb’;

SQL> select tabname from syscat.tables@toolsdb;
select tabname from syscat.tables@toolsdb
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][H006] The init parameter
is not set. Please set it in init.ora file.
ORA-02063: preceding 2 lines from TOOLSDB

Conclusão:

Estou ferrado. Alguém pode me ajudar?

[leandrolbsParticipante]

isto pode lhe ajudar.

http://www.easysoft.com/applications/oracle/hsodbc.html

[Sousa04Participante]

Bom dia pessoal

Fazendo alguns testes

alterei o nome do arquivo
/u01/app/oracle/product/10.2.0/db_1/hs/admin/inittoolsdb.ora

para

/u01/app/oracle/product/10.2.0/db_1/hs/admin/initTOOLSDB.ora

e imaginem vcs

recebi outro erro rsrsrs

SQL> select * from dual@toolsdb
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]DRV_InitTdp: DB_ODBC_INTERFACE (2082): ; [unixODBC][IBM][CLI Driver] SQL30082N Security processing failed with reason “24” (“USERNAME AND/OR
PASSWORD INVALID”). SQLSTATE=08001
(SQL State: 08001; SQL Code: -30082)
ORA-02063: preceding 3 lines from TOOLSDB

Pelo menos acho que agora está mais fácil de resolver

vamos lá!!!

[leandrolbsParticipante]

seu datalink está com a senha errada

USERNAME AND/OR PASSWORD INVALID

[Sousa04Participante]

Vlw era isso mesmo

Dropei o db link e recriei mas dessa vez utilizando aspas na senha

Abraços!!

[Autor]

Posts