Shulou(Shulou.com)06/01 Report--

We often encounter this error when deploying dblink between dm7-oracle:

[description] when an external link is created and tested on the dm7 client after the dblink is deployed, the problem encountered is that no matter how the test is performed on the dm side.

How can we solve this kind of problem?

There are two ways.

# 1 check if there is a problem with the deployment.

2. Log in to the oracle database using sqlplus to see if you can log in.

Treatment method

Treatment method 1:

Summary description

The fastest way to dblink dm7-oracle is as follows:

Additional details: create an external link on the dm7 client and test it after deployment.

Troubleshooting method: if it doesn't work, there may be a problem in the deployment of dblink, and the above deployment method is the most convenient.

Treatment method 2:

Summary description

Use sqlplus to log in to the oracle database and see if you can log in.

Add details

[root@DMMpp1 lib64] #. / sqlplus username / password @ ip:1521/orcl

SQL*Plus: Release 11.2.0.4.0 Production on Mon Jan 7 13:24:27 2019

Copyright (c) 1982, 2013, Oracle. All rights reserved.

ERROR:

ORA-21561: OID generation failed

Solution:

Enter: ~ hostname on the terminal

China

View / etc/hosts file: ~ cat / etc/hosts

127.0.0.1 localhost

Just keep the name of hostname consistent with that of 127.0.0.1 in the hosts file!

If there is no exception when sqlplus logs in again, then the test of the external link is absolutely successful.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.