Re: Oracle forms 6i and Oracle 8i

From: kotsos <fakidomitis_at_yahoo.gr>
Date: Sun, 2 Nov 2003 22:19:12 +0200
Message-ID: <newscache$14rqnh$0i6$1_at_ithaca.tee.gr>

Content-Type: text/plain;
charset="iso-8859-7"
Content-Transfer-Encoding: quoted-printable

Yep!!! It worked just fine!!!!

Thank you both for your help!!!

Kostas

=CF "Daniel Morgan" <damorgan_at_x.washington.edu> =DD=E3=F1=E1=F8=E5 =
=F3=F4=EF =EC=DE=ED=F5=EC=E1 news:1067793956.993198_at_yasure... Smiley wrote:

"kotsos" <fakidomitis_at_yahoo.gr> wrote in message = news:newscache$amrpnh$j5o$1_at_ithaca.tee.gr... Hi ,

I'm quite new to the world of Oracle. The problem I have is that:

I have installed oracle 8i on windows 2000 and everything works fine. = Then,
I installed oracle forms 6i but the problem is that when i try to run = sql+
from 6i Oracle error 12203. Trying to connect through sql+ from 8i is = ok.

I have uninstalled everything (incl registry etc.) and I installed first oracle forms 6i and then 8i. The same problem persists.

To give you some more hints:
1. Oracle forms creates a menu called Oracle for Windows nt. Since I = have
Windows 2000, is that the problem?
2. When I try to run ORacle Net8 Asistant within Oracle Forms 6i, a = message
appears for less than a second ( i don't know what's in it) and then = nothing
happens.
3. All services are up and running, except Oracle Client Cache 80, which insists not to run (even manually)!

Any ideas?

=20
Just create a new key called TNS_ADMIN in your Oracle Dev 6i home (if = you installed Forms 6i first
then this will be HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE). This new key should refer to your tnsnames.ora in the Oracle 8i home. If = you installed 8i in
D:\Oradb8i, your TNS_ADMIN should read: D:\Oradb8i\network\admin

Hth,

Ron
If that doesn't solve the problem ... then go to = http://tahiti.oracle.com and search for "Multiple Homes".

--=20
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
------=_NextPart_000_000B_01C3A18F.57C242D0 Content-Type: text/html;
charset="iso-8859-7"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =

charset=3Diso-8859-7">

<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY text=3D#000000 bgColor=3D#ffffff>
<DIV><FONT size=3D2>Yep!!! It worked just fine!!!!</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Thank you both for your help!!!</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Kostas</FONT></DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20

style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; = BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV>=CF "Daniel Morgan" <<A=20
=

href=3D"mailto:damorgan_at_x.washington.edu">damorgan_at_x.washington.edu</A>&g=

t;=20

=DD=E3=F1=E1=F8=E5 =F3=F4=EF =EC=DE=ED=F5=EC=E1 <A=20
=

href=3D"news:1067793956.993198_at_yasure">news:1067793956.993198_at_yasure</A>.= ..</DIV>Smiley=20
  wrote:<BR>
  <BLOCKQUOTE cite=3Dmidbo2vlt$q0g$1_at_news.hccnet.nl type=3D"cite"><PRE = wrap=3D"">"kotsos" <A class=3Dmoz-txt-link-rfc2396E = href=3D"mailto:fakidomitis_at_yahoo.gr>"><fakidomitis_at_yahoo.gr></A> = wrote in message <A class=3Dmoz-txt-link-freetext = href=3D"news:newscache$amrpnh$j5o$1_at_ithaca.tee.gr">news:newscache$amrpnh$= j5o$1_at_ithaca.tee.gr</A>...
  </PRE>
    <BLOCKQUOTE type=3D"cite"><PRE wrap=3D"">Hi ,

I'm quite new to the world of Oracle. The problem I have is that:

I have uninstalled everything (incl registry etc.) and I installed first oracle forms 6i and then 8i. The same problem persists.

Any ideas?

</PRE></BLOCKQUOTE><PRE wrap=3D""> Just create a new key called TNS_ADMIN in your Oracle Dev 6i home (if = you installed Forms 6i first
then this will be HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE). This new key should refer to your tnsnames.ora in the Oracle 8i home. If = you installed 8i in
D:\Oradb8i, your TNS_ADMIN should read: D:\Oradb8i\network\admin

Hth,

Ron
</PRE></BLOCKQUOTE>If that doesn't solve the problem ... then go to <A =

  class=3Dmoz-txt-link-freetext=20
  href=3D"http://tahiti.oracle.com">http://tahiti.oracle.com</A> and = search for=20
  "Multiple Homes".<BR><PRE class=3Dmoz-signature cols=3D"72">--=20 Daniel Morgan
<A class=3Dmoz-txt-link-freetext =
href=3D"http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.a= sp">http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp</= A>
<A class=3Dmoz-txt-link-freetext =
href=3D"http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.a= sp">http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp</= A>
<A class=3Dmoz-txt-link-abbreviated =
href=3D"mailto:damorgan_at_x.washington.edu">damorgan_at_x.washington.edu</A> (replace 'x' with a 'u' to reply)</PRE></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_000B_01C3A18F.57C242D0-- Received on Sun Nov 02 2003 - 21:19:12 CET

This message: [ Message body ]
Next message: mergercast: "Re: Oracle Portal Dynamic pages submitting data to stored procedure"
Previous message: Daniel Morgan: "Re: Third party utility for encryption and full text search"
Maybe in reply to: kotsos: "Oracle forms 6i and Oracle 8i"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message