Who know the oracle himself to create a new database will appear after the variable name wrong question:

I used to make links with oracle server is ok, then create a new database, due to the new created some software will collapse, will give new deleted, and then I went to see the link server links will not be able to use the
Error:

Link server "pod" OLE DB access interface "OraOLEDB. Oracle" returned message "ORA - 12560: TNS: protocol adapter error",
Message 7303, level 16, state 1, line 1
Unable to initialize the link server "pod" OLE DB access interface "OraOLEDB. Oracle data source object,"

Actually returns or the oracle error, so please help the great god, encountered this problem how to solve the

Online strategy not solve the problem of reference
http://www.cnblogs.com/xwdreamer/archive/2011/07/05/2296988.html

CodePudding user response:

This kind of circumstance, PLSQL the library before it can be normal, but the link server will have a problem, I put the link server mode 1:

The EXEC sp_addlinkedserver @ server=N 'pod, - to create a link to the server alias
@ srvproduct=N 'Oracle' - product name
@ the provider=N 'OraOLEDB. Oracle, - OLE DB driver name
@ datasrc=https://bbs.csdn.net/topics/N 'LCJK'

The EXEC sp_addlinkedsrvlogin 'pod', 'false', NULL, 'system', '123'

CodePudding user response:

You should be the instance name didn't match well

CodePudding user response:

Instance associated with listening is correct