4

I made a small application that should connect to an remote Oracle database running inside a virutal machine (W8.1).

On a sucessfull connection a showmessage should popup.

I folled those steps to ensure my application is able to connect: installing Oracle Instantclient on Mac OS/X without setting environment variables?

The application uses FireDac's Oracle FireDAC.Phys.Oracle driver to connect and TFDGUIxLoginDialog to login.

guianderror

Nothing really special indeed:

procedure TForm1.Button1Click(Sender: TObject);
begin
  FDConnection1.Connected := True;
end;

procedure TForm1.FDConnection1AfterConnect(Sender: TObject);
begin
  ShowMessage('Connected');
end;

procedure TForm1.FDConnection1Error(ASender: TObject;
  const AInitiator: IFDStanObject; var AException: Exception);
begin
  ShowMessage(AException.ToString);
end;

This is working fine and quick in Windows 8.1 and 10.

However in Mavericks i get the OID generation failed error as shown in the picture.

It doesn't matter if i use the VMs IP or DNS name to connect. It won't connect at all.

Oracle's SQL Developer is able to connect, tho.

The Oralce SQL Developer takes about 15 - 20s until it establishes a connection to the database.

My application isn't even trying that long to connect. It fails after ~7s.

Maybe it times out before a stable connection is available?

If so, is there any way to extend the login process time before throwing errors?

Or maybe this is a complete other problem?

Please note that i spent about 5 hours figuring out this problem already without success.

Any help is greatly appreciated.

Community
  • 1
  • 1
ChrisB
  • 2,497
  • 2
  • 24
  • 43
  • Did you edit your [hosts](http://chaos667.tumblr.com/post/20006357466/ora-21561-and-oracle-instant-client-11-2) file? – whosrdaddy Nov 16 '14 at 08:58
  • @whosrdaddy It was one of the first things i did. But i entered the wrong hostname. Your comment made me recheck the settings multiple times and i ended up finding out the correct one. Thanks again. Saved my day :) I will post an answer on what went wrong shortly! – ChrisB Nov 16 '14 at 10:04
  • I'm glad you found your problem :) – whosrdaddy Nov 16 '14 at 10:07

1 Answers1

3

Ok here is what went wrong.

The host file of my OSX Mavericks guest system was incorrect.

Like @whosrdaddy posted you have to change your host file like explained in this link: http://chaos667.tumblr.com/post/20006357466/ora-21561-and-oracle-instant-client-11-2

I did enter the Devicename one can find in Sharing -> Devicename in the OSX Control Panel.

osx control panel devicename

So what i did was entering this name in the host file.

osx hostfile

However i was using the incorrect name.

I got the correct name by using echo "127.0.0.1 $(hostname) which printed the correct name: 127.0.0.1 LionVM.local.

I didn't use this VM in a long time and probably forgotten that i renamed the devicename after upgrading to Mavericks some time ago.

Now my application is able to connect.

ChrisB
  • 2,497
  • 2
  • 24
  • 43