Skip to Main Content
  • Questions

  • connecting developer 2000 to an oracle database

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, islam ahmed.

Asked: November 03, 2000 - 12:21 am UTC

Last updated: April 21, 2004 - 7:53 pm UTC

Version: developer R2.1 , and oracle 8.0.4

Viewed 1000+ times

You Asked

hello ,i'm asking if u can help me with the following subject i got developer 2000 and i failed to make it connecte to personal oracle 8.0.4 , can u help me ,i always get error message with number ora-03121

and Tom said...

If the d2k is installed in a different oracle home from the database or is a different release of the required support files ( i would need to know the version of forms like 5.0.xxx or 6.0.xxxx to tell you what RSF's it uses), you need to use SQLNet.

You need to configure the listener in the 8.0.4 oracle home and configure the tnsnames.ora file in the d2k oracle home in order to connect and use user/password@database when logging in.

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Connectivity between Developer 6i and Oracle 7 Personal Edition?

Jamil, April 21, 2004 - 2:17 am UTC

Hi Tom
Is it possible to have a connectivity between
Developer 6i and Oracle 7 Personal Edition?
If yes then please let me know in detail
beacuse ,I am not able to connect to the oracle through the form or report , and I am getting this message :
ORA-12203 TNS UNABLE TO CONNECT TO DESTINATION.
but it is working when I connect to SQL PLUS 3.3
and Oracle and the Developer installed in the same oracle home directory that is C:\ORAWIN95
the version of forms is
Forms [32 Bit] Version 6.0.8.11.3 (Production)
Oracle Toolkit Version 6.0.5.35.0 (Production)

Thanks
Jamil


Tom Kyte
April 21, 2004 - 7:53 pm UTC

what client does the 6i developer use. (really, i don't know, i don't have it installed).

if it is a 9i client, not going to happen.

if it is an 8i client, it might happen if you set up the listener on the 7.x database (sqlplus 3.3 would be the 7.3 sqlplus client and doesn't need the listner, 6i is definitely a different client release and needs the listner.

Connectivity between Developer 6i and Oracle 7 Personal Edition?

Jamil, April 21, 2004 - 6:59 am UTC

My Oracle Version is
Connected to:
Personal Oracle7 Release 7.3.2.1.1 - Production Release
With the distributed and replication options
PL/SQL Release 2.3.2.0.0 - Production

Best Regards

Jamil

more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.