Toad World® Forums

Can't connect to LINKed Oracle DB


#1

The Link works from the unix platform
SQL> select count(*) from adhoc.actuals@bccc;

COUNT(*)

1743484

but in Toad connected to the same oracle account
the DB link does not connect
see below Error

Lookup Error
ORA-02041: client database did not begin a transaction


#2

I checked with our domain expert. I assume you are using Oracle OCI or Direct connect as opposed to ODBC? If that is the case you can define a script to run after every new connection. He suggests your include --> “set transaction read only”, See if this handles the situation. See screenshot on where to set up this script in the options.

Debbie


#3

I clarified this our domain expert. He said,

“The statement isset transaction read only ; But it applies only to the current transaction, would have to be issued again after each commit or rollback (or any other statement that performs an implicit commit, like a create table)”

So using the startup script will not help. You would need to manually execute this after your commits.

Debbie