Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Linked server headaches - only failing when executed by sql server agent job Expand / Collapse
Author
Message
Posted Sunday, October 07, 2012 7:33 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 27, 2013 6:33 AM
Points: 121, Visits: 649
I have an Oracle 11g r2 linked server. Its currently working for queries and stored procedures. However, when attemping to execute a stored procedure that pulls database from the linked server, we're getting the
"ORA-12154: TNS:could not resolve the connect identifier specified". [SQLSTATE 01000] (Error 7412)

Error.

I checked the error logs, the 'executed as user' has the correct rights through the linked server. I can test the connection and even run the stored procedure manually with this user. Any ideas?

Also, this is a bit bizarre, but if I check the 'Allow in process' for the Oracle OLE DB provider, it breaks the linked server.
Post #1369589
Posted Monday, October 08, 2012 7:23 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 27, 2013 6:33 AM
Points: 121, Visits: 649
A reboot cleared this up.
Post #1369802
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse