Re: Oracle 8, Forms 4.5 and Forms 5 connection problems

Patrick Flahan wrote:

> Try this.
> Patrick Flahan
>
> Installing Personal Oracle 8.0x:
>
> When you install PO8 you have to install 'Oracle Networking Products
> 2.3.4.0.2'. This option includes 'SQL*Net 2.3.4.0.2' and the 'Oracle
> Protocol Adapters' (Named Pipes, SPX & TCP/IP). At the end you should have
> installed SQL*Net 8.0.x & 2.3.4.0.2 and Oracle Protocol Adapters 8.0.x &
> 2.3.4.0.0.
>
> Installing Developer 2.1:
>
> SQL*Net is still installed and therefore it will not be installed when you
> p.e. install FORMS 5 (the SQL*Net-version on the Developer-CD is an older
> version). You shouldn't install SQL*Net yourself!!
>
> Now you should be able to connect from Developer 2.1 (FORMS 5, REPORTS 3,
> SQL*Plus 3.3) to the Oracle 8-database
>
> Pro <martin_at_lyndale.freeserve.co.uk> wrote in message
> news:7bjglo$m72$1_at_news6.svr.pol.co.uk...
> >Heeeeeelp,
> >
> >I have Win98 and have installed PO8.0.4 which worked fine. I then installed
> >Forms 4.5.9.7. Now any attempt to start the database I get the following
> >
> >---------------------------------------------------------------------------
> -
> >------------------
> >Error Starting Program
> > The ORA804.DLL is linked to missing export NLSRTL33.DLL:lxnrpc
> >
> >Followed by
> >
> >OSTART80.EXE A device attached to the system is not functioning
> >---------------------------------------------------------------------------
> -
> >------------------
> >
> >Never had this problem with PO7.3.3. I am also aware of problems connecting
> >to 8.0.4 from Forms 5, any help on this subject would also be appreciated.
> >
> >TIA
> >
> >Pro
> >
> >

  In Oracle8 the SqlNet version is Net8, therefore, you should configure your environment variable TNS_ADMIN to point to $ORACLE_HOME/net80/admin , then configure the tnsnames.ora in $oraclehome/net80/admin/tnsnames.ora appropriately. You should also check all of the *.ora files located in your $TNS_NAMES environment variable for Unix and make certain that you have these configured correctly. You have both Net80 and SqlNet 2.3, and you must instruct your system to use the desired version of SqlNet via TNS_ADMIN eith in Unix or NT os.
Yakub Received on Fri Mar 05 1999 - 04:03:59 CET