Skip to Main Content
Forums

Oracle Developer Tools for Visual Studio

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Developer Tools for Visual Studio 2017 (RC)

user10875158Jan 20 2017 — edited Feb 14 2018

Hi,

currently, I'm testing the release candidate of MS Visual Studio 2017. Because we're using Oracle, I need to establish a connection to the database in the Server-Manager.

Normally I use the Oracle Developer Tools which provides the Oracle Managed driver. Does anybody know something about a release of the Developer Tools

for VS 2017? Maybe a beta release of the Developer Tools exists, which I haven't found yet?!

Thanks.

Regards,

Thomas
This post has been answered by Alex Keh-Oracle on Jan 26 2017
Jump to Answer

Comments

mseberg

Hello;

Try setting TransportDisconnectedThreshold higher than the default of 30.

DGMGRL> EDIT DATABASE testfo SET PROPERTY TransportDisconnectedThreshold='120';

Best Regards

mseberg

BPeaslandDBA

I would start by looking in two logs...the standby's alert log and the DG Broker log. The DG Broker log can be found in the same directory as your alert log and normally has a file named drcinstance_name.log. See if there are messages in either of those on the standby side around the time you are getting this error. Since your standby is RAC, check all instances logs.

HTH,
Brian

1007321

Well, I had a look at these files of course... The standby alert.log shows nothing; as to

the Dataguard log it appends every X minutes the following:

Data Guard Broker Status Summary:

  Type                        Name                             Severity  Status

  Configuration               dgtestfo                          Warning  ORA-16608

  Primary Database            testfo                            Success  ORA-00000

  Physical Standby Database   testfos                           Warning  ORA-16857

which is the same error as that shown in DGMGRL, with no further detail whatsoever...

teits

issue has to do with network between primary and standby DB site.

probably your network latency is very bad OR intermittent failures occurs on your network.

a workaround is to increase  TransportDisconnectedThreshold database property:

DGMGRL> EDIT DATABASE testfo SET PROPERTY TransportDisconnectedThreshold='120';


Tobi

Tobi's Oracle DBA & UNIX Blog

Renu-Oracle

The 'TransportDisconnectedThreshold' is related to the connection to the Primary
There is another new parameter, related to the gap : TransportLagThreshold


Thanks

user10341747

Please check this out:

ORA-16857: standby disconnected from redo source for longer than specified threshold

Error code: ORA-16857

Description: standby disconnected from redo source for longer than specified threshold

Cause:
The amount of time the standby was disconnected from the redo source database exceeded the value specified by the 'TransportDisconnectedThreshold' database property. It is caused by no network connectivity between the redo source and the standby databases.

Action:

Ensure that there is network connectivity between the redo source and standby databases, and the redo source is working properly.

The above error is just a warning message and not actually a problem with the standby database. The error is received when the last communication from the primary database exceeds the value specified by 'TransportDisconnectedThreshold' property. The value is in seconds. Default value is 30 seconds


SOLUTION - Setting 'TransportDisconnectedThreshold' to 0 seconds will disable the alert. Alternatively we can set the property to a higher value.
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 14 2018
Added on Jan 20 2017
#oracle-developer-tools-for-visual-studio
63 comments
74,960 views