Connect Developer 6i with Oracle 9i database

I want to connect developer 6i with oracle 9i database what can I do ?
aminmohsalihAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

aminmohsalihAuthor Commented:
Oracle 9i Relese 2
0
Helena Markováprogrammer-analystCommented:
Can you connect to the Oracle 9i database from SQL*Plus ?
0
schwertnerCommented:
Yes it is possible. The only problem is the NLS character set of 9i. If it is AL32UTF8 then you have to patch Forms with patch after #10.
Install Developer in different Oracle Home if you have other Oracle installations on your computer.


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.
 

You can use the "Oracle Net assistant" 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.

After that go to "control panel" and run "services".
Look at your Oracle_Home_TNSlistener80 process. Stop it! Start it again!
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

aminmohsalihAuthor Commented:
I used patch #14 for forms and I config. the tnsnames.ora well but when I try to connect the following message
Oracle SQL*Plus : pluss80w.exe application error
" The Instruction of "0x67614f04" referenced memory at  "0x00000160"  the memory counld not be written


Remark
When I use SQL*Plus of Oracle Client I connected successfuly!
0
Helena Markováprogrammer-analystCommented:
It is strange - plus80w.exe is SQL*Plus and you write "When I use SQL*Plus of Oracle Client I connected successfuly!" .
0
aminmohsalihAuthor Commented:
when I use SQL*Plus of developer the past message occure but when I use SQL*Plus of Oracle Client I connected successfuly!! ?
0
Helena Markováprogrammer-analystCommented:
Maybe you have to reinstall Oracle Forms6i.
0
aminmohsalihAuthor Commented:
I do this many times
0
Helena Markováprogrammer-analystCommented:
I cannot understand why during connection (Ctrl+J in Forms6i) it uses SQL*Plus !
0
Helena Markováprogrammer-analystCommented:
Maybe it is  a bug 2769225 (though your SQL*Plus works):
DR. WATSON OR CORE DUMP WHEN CONNECT TO UTF8 9.2 DB WITH 6I TOOLS

Problem description:
Developer 6i tools and SQL*Plus will not connect to a 9.2.x database that has an NLS_LANG of UTF8.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.