Toad World® Forums

Testing DBLink returns "ORA-01086: savepoint 'DBLINKTEST' never established in this session or is invalid"

While testing an existing and valid DB Link, the “ORA-01086: savepoint ‘DBLINKTEST’ never established in this session or is invalid” message is returned.

Appears to be a TOAD bug.

Any ideas on the correction?

TOAD for Oracle Xpert 12.0.1.2 with DBA Admin Add-on

Hi Kris,

Can you please send me the sequential steps to recreate this error in toad.

Thanks and with best regards

Anand

There are not many;

In the Schema Browser, choose DB Links for the object type.

Select a public DB Link. In my case, the issue is specifically with links that point to a SQL Server DB.

Click on ‘Test Database Link” button.

Wait a few seconds

See the error in a dialog box.

My thinking is that the test script

  1. Is attempting to create a SavePoint and either can’t but continues to a later step that throws the error

  2. never creates the SavePoint and a rollback to the non-existent SavePoint throws the error.

I’m logged on to an Oracle account that has DBA privileges.

Thanks for being willing to help.

There are not many;

In the Schema Browser, choose DB Links for
the object type.

Select a public DB Link. In my case, the
issue is specifically with links that point to a SQL Server DB.

Click on ‘Test Database Link” button.

Wait a few seconds

See the error in a dialog box.

My thinking is that the test script

  1.   Is attempting to create a SavePoint and either can’t but continues
    

to a later step that throws the error

  1.   never creates the SavePoint and a rollback to the non-existent SavePoint
    

throws the error.

I’m logged on to an Oracle account that
has DBA privileges.

Thanks for being willing to help.

Thanks

Kris Mason - Oracle Architect

American HomePatient, Inc

5200 Maryland Way

Brentwood, TN 37027

Office 615-221-8538


From: anand.coimbatore
[mailto:bounce-anandcoimbatore@toadworld.com]

Sent: Thursday, September 05, 2013
2:03 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle -
Discussion Forum] Testing DBLink returns “ORA-01086: savepoint
‘DBLINKTEST’ never established in this session or is invalid”

RE:
Testing DBLink returns "ORA-01086: savepoint ‘DBLINKTEST’ never
established in this session or is invalid"

Reply by anand.coimbatore

Hi
Kris,

Can
you please send me the sequential steps to recreate this error in toad.

Thanks
and with best regards

Anand

To reply, please
reply-all to this email.

Stop
receiving emails on this subject.

Or Unsubscribe
from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


This message is confidential, intended only for the named recipient and may contain information that is privileged or exempt from disclosure under applicable law. If you are not the intended recipient, you are notified that the dissemination, distribution or copying of this message is strictly prohibited. If you receive this message in error, or are not the named recipient, please notify the sender at the email address listed above.

Hi Kris,

Please check out the following link

forums.oracle.com/…/912801

Thanks

Anand

Thanks Kris,

It works without error when the DB Link connects to Oracle, but your guess below about what is happening is correct. I am surprised that no error is thrown
when we execute the query to create the savepoint. I’ll make a change so that the rollback error is ignored.

-John

From: kris.mason [mailto:bounce-krismason@toadworld.com]

Sent: Thursday, September 05, 2013 2:16 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Testing DBLink returns “ORA-01086: savepoint ‘DBLINKTEST’ never established in this session or is invalid”

RE: Testing DBLink returns "ORA-01086: savepoint
‘DBLINKTEST’ never established in this session or is invalid"

Reply by kris.mason

There are not many;

In the Schema Browser, choose DB Links for the object type.

Select a public DB Link. In my case, the issue is specifically with links that point to a SQL Server DB.

Click on ‘Test Database Link” button.

Wait a few seconds

See the error in a dialog box.

My thinking is that the test script

Is attempting to create a SavePoint and either can’t but continues to a later step that throws the error

never creates the SavePoint and a rollback to the non-existent SavePoint throws the error.

I’m logged on to an Oracle account that has DBA privileges.

Thanks for being willing to help.

Thanks

Kris Mason - Oracle Architect

American HomePatient, Inc

5200 Maryland Way

Brentwood, TN 37027

Office 615-221-8538


From: anand.coimbatore [mailto:bounce-anandcoimbatore@toadworld.com]

Sent: Thursday, September 05, 2013 2:03 PM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Testing DBLink returns “ORA-01086: savepoint ‘DBLINKTEST’ never established in this session or is invalid”

RE: Testing DBLink returns "ORA-01086: savepoint ‘DBLINKTEST’ never established in this session or is invalid"

Reply by anand.coimbatore

Hi Kris,

Can you please send me the sequential steps to recreate this error in toad.

Thanks and with best regards

Anand

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.


** This message is confidential, intended only for the named recipient and may contain information that is privileged or exempt from disclosure under applicable law. If you are not the
intended recipient, you are notified that the dissemination, distribution or copying of this message is strictly prohibited. If you receive this message in error, or are not the named recipient, please notify the sender at the email address listed above.**

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.