Toad World® Forums

SQL Navigator 5.5 and Oracle Cliente 11g


#1

Hi, eventhough i’ve been using sql navigator for a while im still a newbie at many things and hope that somebody can help me out.

Yesterday I installed an Oracle 11G client on my computer (which is running windows vista 32 bit) that i need to use on a new version on an oracle product. After i installed the client and tried to open navigator 5.5 it stated showing me this error message

**Problem
Unhandled Exception at startup - OCI version 11.1.0.1.0 is not supported
Solution
Report the problem to Quest Support. Application will be terminated (some memory loss is possible) when you press OK

Problem
Access violation at address 010191F3 in module ‘SQLNav5.exe’. Read of address 00000000
Solution
No action required. Report the problem to Quest Support. Application will be terminated (some memory loss is possible) when you press OK.
**So before coming here i started surfing the web and read somewhere that this was cause by the new oracle 11g client. So i tried to download the navigator 6.2 trial version to see if i would had the same problem with a newer version.

First I uninstalled the 5.5 version using the uninstaller and then i installed the full for 6.2 trial but when i try to open the 6.2 version it gives me the following error.

Problema
Only trial keys may be entered for this version
Solution
Please make sure you have entered valid authorization code.

It seems that when it tries to deploy it looks and finds my version 5.5 autorization kwy and thats why it doesnt work.

Before i posted I read through the forum and tried to do many things said like trying an intallation on a folder diffentes from the deafult, tried deleting some of the registry keys (maybe i didnt delete all), tried deleting all te folders that were lef behing on the uninstallion but nothing seems to work.

Even though im despertate cause i have to been using plus jaja im not that worried cause my collegues havent installed the oracle 11 client and they can still be working fine but when the time comes it seems that it is going to be a dark one.

For any help thanks.


#2

Hi Estuardo,

Support for 11g client has been added since v5.5.4. You might use v5.5.0 and would need to get an upgrade of SQL Navigator to work with Oracle 11g.

Regarding licence key SQL Navigator currently shares the same licence key folder for all versions and Trial product does not accept Commercial key (which you already have on your system with v5.5). It is already on our list to do in a future release in the licensing area to address this case.

If you would like test it out with v6.2 trial now before upgrading, Please do the following steps:

Rename your current licence key file which locates in C:\Documents and Settings\yourusername\Application Data\Quest Software\SQLNavigator\QSAuthorize12.key to Commercial_QSAuthorize12.key

Then run SQL Navigator 6.2 Trial, please enter this 30 days Trial key
1-86555-88910-19531-63660 (expires 14 Sept 09), or a Trial Key which you might already have received with your download.

Your SQL Navigator v5.5 will also work with this Trial key until it expires. Once the trial key expires, please rename Commercial_QSAuthorize12.key back to QSAuthorize12.key so that you can use v5.5.

Hope that the info would help.

Thanks and regards,
Bruce

Message was edited by: bruceduong


#3

Hello Bruce, thanks for all the tips and yeah we are using sql navigator 5.5.3

It took me a while but i found the QSAuthorize12.key file and renamed just as you said and installed the SQL Navigator 6.2 and it worked fine. I managed to connect to our databases but I didn’t have installed the oracle 11G client at that momment.

I continued to install the oracle 11G client and when i tried to open navigator 6.2 it gave me this error:

**Problem
Access violation at address 7783A685 in module ‘ntdll.dll’. Write of address 04194A55
Solution
Make sure connection parameters are correct and try again
**So at first i though that i was going to have the same problem as with 5.5 but negative sql navigator didnt close so i was happy and what i did was set de ORACLE HOME/CLIENT to my default_home in whih i have my tnsnames and through which i connected the first time with 6.2 and it gives me the same error every time a chance de ORACLE HOME/CLIENT to where the 11G client is installed.

So again with the ORACLE HOME/CLIENT set to my default_home i tried to log on to our databases and if i type my wrong password it tells me that i typed a wrong password. My new problem is that when i type my correct password no windows pop out but instead on the output window on where im supposed to be connect is just shows the following message ! 10:11:52 Operation aborted so if i try to make a query it doesnt give me any data cause at least on the spool it says that im not connect.

So again i ask for your help to tell me if there is any way through which i can determined why it disconnects me automatically every time i connect .

For all your help thank you.


#4

Bruce never mind a tried among my other Oracle Home / Clients and it worked just fine (I have 3 - my default with the oracle client installation, the one that was created when i installed my datawarehouse and the third was when i installed the oracle 11 g client). With my original oracle home negative it didnt work, with the last one it gives the error violation but with the datawarehouse it works fine .

Thanks for all your help.


#5

Hi Estuardo,

We would like to look into this issue where you could not select your Oracle 11g client/home for connection.
In your list, your Default home = 11g client as I would expect your 11g client is first in the System Path variable.

Can you please send in the support bundle file, Under Menu Help->Submit feedback, Click ‘Save to File’ button to save SupportBundle.dta file to a location, then please attach that file to your reply post.

We have received a similar cases where there are duplicate entries of the Oracle 11g client in the System variable Path, or there is an empty system variable ORACLE_HOME.
Could you please also check it out on your system to see if it might be the case, if so please try to delete the duplicate oracle home directory in the system variable ‘Path’ or remove the empty ORACLE_HOME.

We will try to get back to you with more updates once we get the Support bundle file from you.

Thanks and regards,
Bruce
system.jpeg


#6

Hello Bruce thanks and sorry that I didn’t get back sooner.

Here is the information that u requested.

Even though in the support bundle there is a path the one that appears in te my computer in the system variables starts like this:

C:\product\11.1.0\db_1\bin;C:\warehouse\product\10.2.0\db_1\bin;C:\OracleBI\server\Bin;C:\OracleBI\web\bin;C:\OracleBI\web\catalogmanager;C:\OracleBI\SQLAnywhere;C:\Program Files\Java\jdk1.6.0_12\bin;C:\orant6i\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Common Files\Roxio Shared\DLLShared;C:\Program Files\Common Files\Roxio Shared\DLLShared;C:\Program Files\Common Files\Roxio Shared\9.0\DLLShared;C:\orant6i\jdk\bin;C:\Program Files\QuickTime\QTSystem
Image_01.jpeg


#7

Hello Bruce thanks and sorry that I didn’t get back sooner.

Here is the information that u requested.

Even though in the support bundle there is a path the one that appears in te my computer in the system variables starts like this:

C:\product\11.1.0\db_1\bin;C:\warehouse\product\10.2.0\db_1\bin;C:\OracleBI\server\Bin;C:\OracleBI\web\bin;C:\OracleBI\web\catalogmanager;C:\OracleBI\SQLAnywhere;C:\Program Files\Java\jdk1.6.0_12\bin;C:\orant6i\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Common Files\Roxio Shared\DLLShared;C:\Program Files\Common Files\Roxio Shared\DLLShared;C:\Program Files\Common Files\Roxio Shared\9.0\DLLShared;C:\orant6i\jdk\bin;C:\Program Files\QuickTime\QTSystem
SupportBundle.dta (6.22 KB)


#8

Hi Estuardo,

No problem at all. Thank you for sending us the info.

The issue here is SQL Nav 6.x somehow could not detect your 11g client to get the path of the oci.dll and tnsname.ora.

We will get back to you later with more updates…

Thanks and regards,
Bruce


#9

Hi Estuardo,

We would appreciate if you could send us additional home information. To do that, please open the Logon dialog again, click on the ellipses button next to home selection combo, and in the window that appears click the Clipboard button to copy the home info to clipboard. Paste it to the next message that you send to us.

Thank you,
Roman


#10

Hi Roman, here is the info that u requested.

CYA
home_path.sql (1.52 KB)


#11

Hi

I got the following message after I installed client 11g and then opening SQL Nav 6.2

“Access violation at address 774A962D in module ‘ntdll.dll’. Write of address 04194A55”

After checking path, etc I discover that the problem was that the Oracle Net configuration assistant didn’t created the TNSNAMES.ora file.
After I hand-created it SQLNav stop giving me the error.

Hope it helps

Filipe

Message was edited by: Fsilva


#12

This problem also happens with the last 6.3 beta (1828 build) and creating the TNSNames “by hand” fix it.

The error message should explain that or SQLNav should create an empty file


#13

Hi Filipe,

Thank you for getting back to us.

We had added some changes a while ago to handle the error when there is no tnsname.ora, where you can create the entry using the tnsnames editor from the login in screen. It does not work as expected yet with light/instant client with system environment variables tns_admin. We will do more work in this area for you in the next release.

Could you please confirm and let us know you are using 11g light/instant client?

Thanks and regards,
Bruce


#14

Hi

It was not the instant client. It was the normal 11g, 32 bit client (but without creating the tnsnames.ora (connection wizard))


#15

I just want to note That I experienced this issue too and found a solution / fix. I kept getting the “Access violation at address in module ‘ntdll.dll’. Write of address 04194A55” error. After coming across this thread I attempted to use the tsnames editor in sql navigator, but it kept reporting that it could not be open. I went into my oracle directory /network/ADMIN/ and noticed that there was no tsnames.ora (our organization doesn’t use it (sqlnet.ora & ldap.ora instead)) so I grabbed the sample tsnames.ora and placed it in that directory. I started sql navigator back up and it didn’t report the ntdll.dll error and worked just fine. (Note I’m not sure what this tsnames.ora default file does, so I have no clue if it created any unforeseen issues)

I am running Windows 7 64bit, Oracle 11g client 32-bit, SQL Navigator 6.3

I Hope this helps,

Farrin A. Reid