Oracle creates the dblink can't use-CodePudding

Create dblink statement is as follows:

 the create database link TO_YYW connect to "phone_test" identified by 14546. "sa" using '(the DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(TCP) PROTOCOL=(HOST=10.1.4.67) (1521) PORT=) 
) 
(CONNECT_DATA=
 https://bbs.csdn.net/topics/(SERVICE_NAME=former) 
) 
) ';

Error:

CodePudding user response:

Confirm the remote database password is correct, and then look at the far end: database server firewall Settings. Database software sqlnet. Ora file is set up in black and white list

CodePudding user response:

Don't build DBLINK in this way, please use the following this way create DBLINK, direct reference alias TNS, example:
The create database link dblinkname connect to user identified by password using 'wouldn';
If you have questions, can direct messages me!!!!!!!