Re: VMWare with Oracle database link

Oliver Huppert wrote:

> we've got a problem with Oracle 8i under Windows 2000 and VMWare.
> The thing is that we want to make a database link from the Oracle instance
> on Windows 2000 to a Oracle instance installed under VMWare with Win 2000
> on the same machine.
> It doesn't work --> ORA-02085

Did you actually looked up this error message?

02085, 00000, "database link %s connects to %s"

// *Cause: a database link connected to a database with a different name.
//  The connection is rejected.
// *Action: create a database link with the same name as the database it
//  connects to, or set global_names=false.

The fix seems pretty straight forward and simple to me.

> When try to connect from the client instance to the instance on VMWare
> with sqlplus, it is very slow.

Obviously, as you're running *two* operating systems, each with its own high performance database, on the *same* single hardware platform.

How much RAM do you have on the system? Number of CPUs? Have you looked at Window's Performance Manager in the native o/s and in the guest o/s to see what the actual bottleneck is?

> Has someone experience with such a constellation??

Been to the Horse Head Nebula once. But that's another story.

--
Billy