Toad World® Forums

Fail to connect oracle 9i database


#1

Hi ,

I have bough licence Oracle toad v10.6. I fail to connect using toad v10.6. I have not problem if using version toad 9. Does toad v10.6 compatible with oracle 9i database. Tks.

Regard
William


#2

Morning William,

I have bough licence Oracle toad v10.6. I fail to connect
using toad v10.6. I have not problem if using version toad
9. Does toad v10.6 compatible with oracle 9i database. Tks.
What errors are you getting?

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk


#3

Message from: william

Hi,

I getting fail to open connection when try to direct connect without go through
tnsnames.ora file My oracle clietn is 10g . Tks

Regard
William


Historical Messages

Author: voong tze liang
Date: Mon Oct 25 07:38:49 PDT 2010
Hi,

I getting fail to open connection when try to direct connect without go through
tnsnames.ora file My oracle clietn is 10g . Tks

Regard
William
__

Author: Norman Dunbar
Date: Mon Oct 25 01:24:11 PDT 2010
Morning William, >> I have bough licence Oracle toad v10.6. I fail to connect >>
using toad v10.6. I have not problem if using version toad >> 9. Does toad v10.6
compatible with oracle 9i database. Tks. What errors are you getting? Cheers,
Norm. [TeamT] Information in this message may be confidential and may be legally
privileged. If you have received this message by mistake, please notify the
sender immediately, delete it and do not copy it to anyone else. We have checked
this email and its attachments for viruses. But you should still check any
attachment before opening it. We may have to make this message and any reply to
it public if asked to under the Freedom of Information Act, Data Protection Act
or for litigation. Email messages and attachments sent to or from any
Environment Agency address may also be accessed by someone other than the sender
or recipient, for business purposes. If we have sent you information and you
wish to use it please read our terms and conditions which you can get by calling
us on 08708 506 506. Find out more about the Environment Agency at
www.environment-agency.gov.uk
__

Author: voong tze liang
Date: Fri Oct 22 07:55:59 PDT 2010
Hi ,

I have bough licence Oracle toad v10.6. I fail to connect using toad v10.6. I
have not problem if using version toad 9. Does toad v10.6 compatible with oracle
9i database. Tks.

Regard
William
__



#4

Hi William,

I getting fail to open connection when try to direct connect
without go through tnsnames.ora file My oracle client is 10g . Tks

Ok, if your 9i set up is using Oracle Names for resolution, then you
will have to create a 10g tnsnames.ora file because the 10g client
cannot use Oracle Names.

The quickest way to do this is to connect to the namesctl utility and
run the "dump_tnsnames " command. When done, the filename you
specify will be suitable to use as a tnsnames.ora file.

Copy it to the 10g home\network\admin folder and you should be good to
go.

If you are not using the Oracle Names system, then your 10g client needs
to have a tnsnames.ora file (and probably sqlnet.ora as well) that are
the same as the ones in the 9i client.

There are two ways to achieve this:

  • Copy the files from 9i\network\admin to 10g\network\admin; or

  • In the registry, add a TNS_ADMIN entry to the 10g Oracle Home, and
    point it at the location of the 9i\network\admin.

The first option is easiest, but you then have to make sure you make
changes in both the 9i client and the 10g client files.

The second option means that you only ever edit the 9i files and the 10g
client will pick them up as soon as you are done.

To do this:

Run regedit and navigate to HKLM/software/Oracle.

Note that there are a number of “HOMEn” entries listed on the LHS.

For each of the HOMEn entries, click it. The RHS will show you the
settings. Look for the ORACLE_HOME setting in each one and stop when you
find the location of the 10g client.

Now, in the RHS, right click and choose NEW form the context menu.

Select “STRING VALUE” from the list that appears.

Type TNS_ADMIN as the name of the string value, to replace the default
of “New Value #1”. Press ENTER.

Double-click the TNS_ADMIN entry in the RHS.

In the dialogue (EDIT STRING) that appears, type in the full path to
your Oracle 9i_home\network\admin folder and click OK.

Exit from regedit.

If you now attempt to connect to a database that 9i client can find but
10g client cannot, you should be able to connect to it using 10g now.

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk


#5

Hi,

I getting fail to open connection when try to direct connect without go through tnsnames.ora file My oracle clietn is 10g . Tks

Regard
William


#6

Message from: william

Hi,

Actually i have try as you mention by doing tnsnames.ora on 10g client. but i
still not able to connect as per error message. I am sure that my tnsnames.ora
on oracle home 10g is correct. I use normal sqlplus from my pc to the 9i
database server is not problem. I am using winxp 64 bit.

ORA-12154- TNS could not resolve the connect identified specified.


Historical Messages

Author: voong tze liang
Date: Mon Oct 25 21:02:35 PDT 2010
Hi,

Actually i have try as you mention by doing tnsnames.ora on 10g client. but i
still not able to connect as per error message. I am sure that my tnsnames.ora
on oracle home 10g is correct. I use normal sqlplus from my pc to the 9i
database server is not problem. I am using winxp 64 bit.

ORA-12154- TNS could not resolve the connect identified specified.
__

Author: voong tze liang
Date: Mon Oct 25 07:38:49 PDT 2010
Hi,

I getting fail to open connection when try to direct connect without go through
tnsnames.ora file My oracle clietn is 10g . Tks

Regard
William
__

Author: Norman Dunbar
Date: Mon Oct 25 07:38:49 PDT 2010
Hi William, >> I getting fail to open connection when try to direct connect >>
without go through tnsnames.ora file My oracle client is 10g . Tks Ok, if your
9i set up is using Oracle Names for resolution, then you will have to create a
10g tnsnames.ora file because the 10g client cannot use Oracle Names. The
quickest way to do this is to connect to the namesctl utility and run the
"dump_tnsnames " command. When done, the filename you specify will be suitable
to use as a tnsnames.ora file. Copy it to the 10g home\network\admin folder and
you should be good to go. If you are not using the Oracle Names system, then
your 10g client needs to have a tnsnames.ora file (and probably sqlnet.ora as
well) that are the same as the ones in the 9i client. There are two ways to
achieve this: * Copy the files from 9i\network\admin to 10g\network\admin; or *
In the registry, add a TNS_ADMIN entry to the 10g Oracle Home, and point it at
the location of the 9i\network\admin. The first option is easiest, but you then
have to make sure you make changes in both the 9i client and the 10g client
files. The second option means that you only ever edit the 9i files and the 10g
client will pick them up as soon as you are done. To do this: Run regedit and
navigate to HKLM/software/Oracle. Note that there are a number of “HOMEn”
entries listed on the LHS. For each of the HOMEn entries, click it. The RHS will
show you the settings. Look for the ORACLE_HOME setting in each one and stop
when you find the location of the 10g client. Now, in the RHS, right click and
choose NEW form the context menu. Select “STRING VALUE” from the list that
appears. Type TNS_ADMIN as the name of the string value, to replace the default
of “New Value #1”. Press ENTER. Double-click the TNS_ADMIN entry in the RHS. In
the dialogue (EDIT STRING) that appears, type in the full path to your Oracle
9i_home\network\admin folder and click OK. Exit from regedit. If you now attempt
to connect to a database that 9i client can find but 10g client cannot, you
should be able to connect to it using 10g now. Cheers, Norm. [TeamT] Information
in this message may be confidential and may be legally privileged. If you have
received this message by mistake, please notify the sender immediately, delete
it and do not copy it to anyone else. We have checked this email and its
attachments for viruses. But you should still check any attachment before
opening it. We may have to make this message and any reply to it public if asked
to under the Freedom of Information Act, Data Protection Act or for litigation.
Email messages and attachments sent to or from any Environment Agency address
may also be accessed by someone other than the sender or recipient, for business
purposes. If we have sent you information and you wish to use it please read our
terms and conditions which you can get by calling us on 08708 506 506. Find out
more about the Environment Agency at www.environment-agency.gov.uk
__

Author: voong tze liang
Date: Mon Oct 25 07:38:49 PDT 2010
Message from: william Hi, I getting fail to open connection when try to direct
connect without go through tnsnames.ora file My oracle clietn is 10g . Tks
Regard William _______________________________________ Historical Messages
Author: voong tze liang Date: Mon Oct 25 07:38:49 PDT 2010 Hi, I getting fail to
open connection when try to direct connect without go through tnsnames.ora file
My oracle clietn is 10g . Tks Regard William __ Author: Norman Dunbar Date: Mon
Oct 25 01:24:11 PDT 2010 Morning William, >> I have bough licence Oracle toad
v10.6. I fail to connect >> using toad v10.6. I have not problem if using
version toad >> 9. Does toad v10.6 compatible with oracle 9i database. Tks. What
errors are you getting? Cheers, Norm. [TeamT] Information in this message may be
confidential and may be legally privileged. If you have received this message by
mistake, please notify the sender immediately, delete it and do not copy it to
anyone else. We have checked this email and its attachments for viruses. But you
should still check any attachment before opening it. We may have to make this
message and any reply to it public if asked to under the Freedom of Information
Act, Data Protection Act or for litigation. Email messages and attachments sent
to or from any Environment Agency address may also be accessed by someone other
than the sender or recipient, for business purposes. If we have sent you
information and you wish to use it please read our terms and conditions which
you can get by calling us on 08708 506 506. Find out more about the Environment
Agency at www.environment-agency.gov.uk __ Author: voong tze liang Date: Fri Oct
22 07:55:59 PDT 2010 Hi , I have bough licence Oracle toad v10.6. I fail to
connect using toad v10.6. I have not problem if using version toad 9. Does toad
v10.6 compatible with oracle 9i database. Tks. Regard William __


__

Author: Norman Dunbar
Date: Mon Oct 25 01:24:11 PDT 2010
Morning William, >> I have bough licence Oracle toad v10.6. I fail to connect >>
using toad v10.6. I have not problem if using version toad >> 9. Does toad v10.6
compatible with oracle 9i database. Tks. What errors are you getting? Cheers,
Norm. [TeamT] Information in this message may be confidential and may be legally
privileged. If you have received this message by mistake, please notify the
sender immediately, delete it and do not copy it to anyone else. We have checked
this email and its attachments for viruses. But you should still check any
attachment before opening it. We may have to make this message and any reply to
it public if asked to under the Freedom of Information Act, Data Protection Act
or for litigation. Email messages and attachments sent to or from any
Environment Agency address may also be accessed by someone other than the sender
or recipient, for business purposes. If we have sent you information and you
wish to use it please read our terms and conditions which you can get by calling
us on 08708 506 506. Find out more about the Environment Agency at
www.environment-agency.gov.uk
__

Author: voong tze liang
Date: Fri Oct 22 07:55:59 PDT 2010
Hi ,

I have bough licence Oracle toad v10.6. I fail to connect using toad v10.6. I
have not problem if using version toad 9. Does toad v10.6 compatible with oracle
9i database. Tks.

Regard
William
__



#7

Hi,

Actually i have try as you mention by doing tnsnames.ora on 10g client. but i still not able to connect as per error message. I am sure that my tnsnames.ora on oracle home 10g is correct. I use normal sqlplus from my pc to the 9i database server is not problem. I am using winxp 64 bit.

ORA-12154- TNS could not resolve the connect identified specified.


#8

Morning William,

ORA-12154- TNS could not resolve the connect identified specified.
This error means that Oracle cannot take the database alias you supply
and convert it to a host/port/sid_or_servioce where the database lives.

I suspect that your sqlnet.ora is not quite correct, possibly.

Try the following with the 10g client. (cd \bin):

tnsping

You should get the same error. Then try:

tnsping .world

You might get a result this time. If so, you need to amend the
sqlnet.ora file to add an entry:

NAMES.DEFAULT_DOMAIN=world

You may need to check that your entry in tnsnames.ora under the 10g
client is identical to the one in tnsnames.ora under the 9i client. Can
you please show me the corresponding entry form the 9i and 10g client
from the respective tnsnames.ora files? If desired, you can XXXXXX out
the host & port - for security purposes. Thanks.

Also, please post the sqlnet.ora file from both the 9i and 10g client.

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk