Solved

ora-12203 TNS unable to connect to destination

Posted on 2004-04-02
9
6,195 Views
Last Modified: 2013-12-11
i have installed 9i database and it is working well but the problem is in the form developer
it dose not connect to the database and gives me this error "TNS unable to connect to destination"
my processor is 'pentium 4' and my database is in the same computer and i am not using a network
please i need this help as soon as possible....thank you
0
Comment
Question by:amany_ahmed
  • 2
  • 2
  • 2
  • +1
9 Comments
 
LVL 4

Expert Comment

by:barthdev
ID: 10746210
Hi amany_ahmed,

Oracle uses a tnsnames.ora file which was probably written when you used the Net8 Configuration Assistant; by default it is stored in ORACLE_HOME\network\admin. That means that each ORACLE_HOME has it's own tnsnames.ora that it looks for.

You could copy the file from the ORACLE_HOME that's working to one that's not, but there are easier ways. I'm going to recommend that you set the TNS_ADMIN parameter in the registry.

Consider the following sample which has 9i database in HOME1 and form developer in HOME2.

Open 'regedit' and browse to the HOME1:

HKEY_LOCAL_MACHINE\Software\Oracle\HOME1
ORACLE_HOME = c:\oracle\ora91
[NEW KEY] TNS_ADMIN = c:\oracle\ora91\network\admin

HKEY_LOCAL_MACHINE\Software\Oracle\HOME2
ORACLE_HOME = c:\oracle\formsdev
[NEW KEY] TNS_ADMIN = c:\oracle\ora91\network\admin

This is your most likely difficulty. I'll be happy to give other suggestions or more detail if you ask.

Does that make sense?
0
 

Author Comment

by:amany_ahmed
ID: 10748774
Hi barthdev
 thank you for your help, but i have done what  you have told me but the error is still there .
it will be nice of you if you send me  any other suggestions.
0
 
LVL 4

Expert Comment

by:barthdev
ID: 10748961
Hm,

Start > Run > cmd
> cd c:\oracle\ora91\bin
(to your actual database home)
> tnsping <sid>
(your actual database sid)

What happens?

And what is your actual database home?

And how did you set your TNS_ADMIN?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 6

Expert Comment

by:musdu
ID: 10751292
Hi,

you can use tnsping program to test definition and connection.

on ms-doc command prompt, write;

tnsping databasename

regards.
0
 
LVL 47

Expert Comment

by:schwertner
ID: 10755250
Oracle Server <---> Developer 6i:
Oracle Developer6i and the Oracle8i database require separate Oracle home directories.
Even if you configure SQL*net (Net8) in the Oracle home that your database Oracle server uses, so that you can connect via SQL*Plus, that does not allow Developer2000 to connectsuccessfuly to the Oracle server.  You also need to configure SQL*Net (in tnsnames.ora file) in the
Oracle home for Developer2000.  You can do that either using the GUI tools, or to copy two files:
sqlnet.ora and tnsnames.ora from your 8i Oracle home to your Developer2000 Oracle home.  In your 8i
Oracle home these files are in: \Network\admin, but in your Developer2000 home they are in: \Net80\Admin. A safety measure is to save a copy of them first, before you make changes or copy other ones in. This is so because you have to keep a way for restoring the files if you make a mistake.
--------
This is a generic advise I collected for a year answering to this kind of questions.
About connection between Personal Oracle and Forms 6 look at
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:447620106871

You can use the "Oracle Net 8 assistant", "Oracle Net 8 Easy config" to see if you have the appropriate entry to the server in the local tnsnames.ora file (find it!). I mean that one in the Client or Forms&Reports home, not that one in the Oracle_Home.
Under local I mean the file tnsnames.ora  in your application, not at the Oracle Server - this is a common mistake.

You have to have there an entry like:

REKS816.RILA.us =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = bigbluenew.rila.us)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = REKS816)
     )
  )


Be aware that in old versions of Oracle instead of SERVICE_NAME you have to use SID. So (SERVICE_NAME = REKS816)will be (SID = REKS816)
     
It is a bad practice, but you can add such entry using simple text editor. But before that make a copy of tnsnames.ora in order to restore it if you do not succeed.
0
 

Author Comment

by:amany_ahmed
ID: 10769625
sorry for being late ,

i have tried the first soluation (tnsping) but my database use character set of(arabic) so it show me symbolic words which i cann't
understand .

the other soulation (changing in files) i tried it befor but it didn't work.

and by the way i checked up the file of the error detailes and it show me that  "there was
an error in protocol compatable"

and there is something else,
when i install the same versionof dev. on another pc which has  the same version of windows(2000) ,the developer connected to the database correctly, and the  other pc has no different hardware except the network card.

is this can make that difference ,cause really i want to know from where it comes that error.

thank you
0
 
LVL 47

Accepted Solution

by:
schwertner earned 500 total points
ID: 10772220
Look, the problem is clear.
If you use Arabic letters this means that you have created your DB using AL32UTF8.
BUT ... this character set is unknown in the world of 8i and your Forms belongs to this 8i world!!!

WORKAROUND: Download from Metalink the latest Forms patch (at least Patch 12) and apply it. You will have no problems. The same about Oracle 8,8i clients - they will not work against the 9i DB!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
CREATE TABLE syntax 4 45
Cannot open form error 6 49
query in Oracle forms Builder 2 27
Oracle DATE Column Space 11 45
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now