Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Migrate oracle 9i to oracle 11g but now dblink's it's no working

Vitor Jr.Jan 26 2012 — edited Jan 26 2012
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!
This post has been answered by sb92075 on Jan 26 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 23 2012
Added on Jan 26 2012
4 comments
363 views