Migrate oracle 9i to oracle 11g but now dblink's it's no working
First of all, sorry for my English.
Realized an export from old to new db_links and now are not working.
Oracle 9i - working
13:52:45 cartao>@banco
mostra user, instance, host e startup time - pressione enter para continuar
USER é "SYSTEM"
INSTANCE_NAME HOST_NAME STATUS STARTUP_TIME
---------------- ---------------------------------------------------------------- ------------ --------------
cartao atlas1 OPEN 23-01-12 17:53
Decorrido: 00:00:00.03
BANNER
----------------------------------------------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for Linux: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production
Decorrido: 00:00:00.03
13:52:46 cartao>
13:52:59 cartao>@dblink
Informe o valor para db_link: scapr
OWNER DB_LINK USERNAME HOST CREATED
-------------------- ------------------------------ -------------------- ------------------------------ --------------
PUBLIC SCAPROD.PANVEL.COM.BR LINK SCA 17-11-11 14:35
Decorrido: 00:00:00.03
13:53:03 cartao>desc dual@scaprod
Nome
-------------------------------------------------------------------------------------------------------------------------
DUMMY
13:53:07 cartao>desc dual@scaprod.panvel.com.br
Nome
-------------------------------------------------------------------------------------------------------------------------
DUMMY
13:53:16 cartao>
13:53:16 cartao>show parameter global
NAME TYPE VALUE
------------------------------------ ----------- -------------
global_context_pool_size string
global_names boolean FALSE
13:53:40 cartao>
Oracle 11g - not working, just work with the full name of db_link:
13:53:57 new11>@banco
mostra user, instance, host e startup time - pressione enter para continuar
USER é "SYSTEM"
INSTANCE_NAME HOST_NAME STATUS STARTUP_TIME
---------------- ---------------------------------------------------------------- ------------ -----
cartao aquarius OPEN 26-01-12 13:42
Decorrido: 00:00:00.01
BANNER
----------------------------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
Decorrido: 00:00:00.04
13:53:58 new11>
13:54:12 new11>@dblink
Informe o valor para db_link: scapr
OWNER DB_LINK USERNAME HOST CREATED
-------------------- ------------------------------ -------------------- ---------------------------
PUBLIC SCAPROD.PANVEL.COM.BR LINK SCA 26-01-12 13:02
Decorrido: 00:00:00.03
13:54:16 new11>desc dual@SCAPROD.PANVEL.COM.BR
Nome
---------------------------------------------------------------------------------------------------
DUMMY
13:54:23 new11>desc dual@scaprod
ERROR:
ORA-02019: descrição de conexão para o banco de dados remoto não localizada
13:54:26 new11>
13:54:41 new11>show parameter global
NAME TYPE VALUE
------------------------------------ ----------- ------------------
global_context_pool_size string
global_names boolean FALSE
global_txn_processes integer 1
13:54:45 new11>
Any help? :)
Thanks!