DBArtisan

[CrystalVis]

I'm using DBArtisan to connect to oracle db. I was able to do so from my NT machine with orcle 8i client installed. However, when I try to connect to the same db from an XP pro machine with oracle 9i client installed, I received the following error message: 'Error while trying to retrieve text for error ORA-01019'. The TNS setup are identical on both machines. Can someone please help me understand why I cannot connect to oracle instance on the XP machine? Your help/suggestion is greatly appreciated.
thanks

 

[Turkbear]

Hi, Almost anytime you get an error that starts with

'Error while trying to retrieve text for error...

It means that the Oracle_Home has not been set correctly so Oracle cannot locate its message files..

If that error code is correct the error is :

ORA-01019 unable to allocate memory in the user side

Cause: The user side memory allocator returned an error. 

Action: Increase the size of the process heap or switch to the old set of calls.

That is a very odd error and my be caused by a bad install of the Client software - which could account for the Oracle_Home issue as well.
Were there any error messages when installing the client on the XP box?

 

[CrystalVis]

Thanks for you response. Originally, I attempt to install oracle 8i client. However, it is not compatible with the XP box and pent 4 chip issue. So I went into registry and remove any entry that related to oracle. When I install ora 9i client, I didn't get any error message. I did notice that in the program menu, I do see ora 8i list there...should I look else where to ensure that ora 8i was completely remove from the box. Again, thanks for your help.

 

[CrystalVis]

by the way, I forgot to mention that I have no problem connecting to the db using sql worksheet on the xp box. my initial thought is the version of dbartisan I have (ver 5.0)is not compatible with ora 9i. could this be the possibility? thanks

 

[Turkbear]

Hi, It could be DBArtisan ( you can check with the manuf.), or it could have the wrong Oracle Home hard coded somewhere in its configuration parameters.

BTW, you have discovered Oracle's dirty little not-so-secret-anymore: The Uninstaller sucks!

Search Google's Oracle groups ( or maybe this forum) for info on completely cleaning a previous version of Oracle from a windows-based machine.