oracle - TNS,can not handle the service name when two different version installed together -


In our server, we publish an asp.net application, which uses oracle11g as database.

We just set the connection string in web.config, it works.

However anyone is required to install oracle8 in the same server since they are in other client applications.

But later, our web applcation can not work, we get an error:

Ora-12154 TNS service name does not handle

Then the path I found has changed the environment "C: / App / Oracle 81 / bin" has been added in the first place.

Any ideas for both work?

You can check that Drivers are being used in the net ... Microsoft's dislike Oracle Provider or Oracle's own provider or some type of ODBC provider who is sitting on top of many different types of possible drivers in a DSN should be removed separately.

But it seems that Oracle 8 installation did not use any of the fir on the Oracle 11 installation Awareness steal which "path" is not environmental variables would be my guess registry. In the ascending order of inconvenience and effectiveness, you can try:

1) Run the Oracle 11 installer and see if it knows about Oracle 8 home. (It's not likely that it's 8.0). Set it as the default or top of the list; Go out; Then go back and set Oracle 11 as the default / top list

2) To connect to your Oracle 8 database, configure TNC entries in your Oracle 8 home. Live by the fact that you are using a very old client.

3) Uninstall and restore Oracle 11, to take it back to priority.

Comments

Popular posts from this blog

mysql - BLOB/TEXT column 'value' used in key specification without a key length -

c# - Using Vici cool Storage with monodroid -

python - referencing a variable in another function? -