Forum Discussion
maxvalt
Apr 09, 2024Copper Contributor
linked server oracle error ORA-01034
Hi everyone
Does anyone have an idea why this error occurs?
I thank you in advance
Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "MyOracle".
OLE DB provider "OraOLEDB.Oracle" for linked server "MyOracle" returned message "ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory". (Microsoft SQL Server, Error: 7303)
That's small sample file
Helper range expands automatically if you change the table except spills in column N shall be drag down. Data validation formula is
=XLOOKUP($H4&$I4,$L$9:L10&$M$9:$M10,$N$9:$N10)#
It is expandable if take care about absolute/relative references.
Just mock-up, perhaps it could be done more elegant.
5 Replies
Sort By
- olafhelperBronze ContributorThat's to less on information for diagnostic.
First, the error message comes from Oracle (data provider), not from MS SQL Server.
> Linux-x86_64
Are you using SQL Server on Linux?
AFAIK currently linked server to a RDBMS different the MS SQL Server are not supported.- maxvaltCopper Contributor
Linux, database version 11.2.0.4 (upgraded last week from version 10)
but with the previous version it worked correctly
any other ideas?- olafhelperBronze ContributorHave you edited your origin pots; it's now a different error?
And the error still comes from Oracle, not SQL Server. Search for, for example:
https://forums.oracle.com/ords/apexds/post/ora-27101-shared-memory-realm-does-not-exist-linux-x86-64-e-3732