Newbie question, about the db link connection problems-CodePudding

Friend send me a connection, I could not use other libraries to connect is how to return a responsibility? Password quotes, and the libraries are no problem.

CodePudding user response:

Did you create the dblink? Use the select sysdate directly from dual @ dblink test connection

CodePudding user response:

What's the problem, for 19706? Or is there a link directly to:
http://www.laoxiong.net/scn-ora-19706-_external_scn_rejection_threshold_hours-parameter.html

CodePudding user response:

refer to the second floor minsic78 response:

19706 questions, how do you say? Or is there a link directly to:
http://www.laoxiong.net/scn-ora-19706-_external_scn_rejection_threshold_hours-parameter.html

Beginners can't understand this you wrote

CodePudding user response:

reference rex0520 reply: 3/f

Quote: refer to the second floor minsic78 response:

What's the problem, for 19706? Or is there a link directly to:
http://www.laoxiong.net/scn-ora-19706-_external_scn_rejection_threshold_hours-parameter.html

Beginners can't understand this you wrote

Is not I write,
This article is written I saw 19706 of the best, don't understand that can only see don't understand the

Most simply want to avoid 19706, is don't use dblink, in fact, in most cases, this is the only way to completely eliminate the error

CodePudding user response:

reference 4 floor minsic78 response:

Quote: reference rex0520 reply: 3/f

Quote: refer to the second floor minsic78 response:

What's the problem, for 19706? Or is there a link directly to:
http://www.laoxiong.net/scn-ora-19706-_external_scn_rejection_threshold_hours-parameter.html

Beginners can't understand this you wrote

Is not I write,
This article is written I saw 19706 of the best, don't understand that can only see don't understand the

Want to avoid, 19706, is the most simply don't use dblink, in fact, in most cases, this is the only way to completely eliminate the error

Don't dblink, how to take out the library table data, to ask.

CodePudding user response:

Data synchronization tool kettle, ogg, also like to write their own procedures

CodePudding user response:

If you just want to temporary solution to the problem, you can try to modify _external_scn_rejection_threshold_hours hidden parameter, the default is 24, went to a small change, but change to a minimum of 1, changed to 1 after 19706 is that the road is blocked, and this is your current library of SCN smaller than distal library, if, in turn, you will have to wait for, wait for the remote repository of SCN big enough a leap to synchronize with your library,

CodePudding user response:

reference 1st floor baidu_36457652 response:

did you create the dblink? Use the select sysdate directly from dual @ dblink test connection.

Can be connected. Have time to show