Re: Personal Oracle 8 & D/2000 ( more questions ... )

1. Do I need to shut the database down, shut down the listener (or both) after amending the SQL*Net configuration?
2. Can anyone give me a definitive answer as to whether Forms 4.5 will actually talk to Personal Oracle 8.0.3, both running on the same standalone Win95 PC - and if so, which networking tool (Net8 or SQL*Net) is used and with which protocol (TCP, Bequeath ...)
3. And at the risk of totally screwing up, what effect is Win98 likely to have on this issue - as a keen "early adopter", I'd just like to see what Win98 can do for me (especially in terms of increasing my apparent disk space) but I am leery about installing that in case it compounds my current issue yet further ....

TIA Jeremy Russell

jrinusa_at_gte.net (Jeremy Russell) wrote:

>That makes as much sense as all the other "solutions" I have tried - I
>believe that I have a "valid TCP stack" .... I can run MS-DOS and then
>successfully "ping localhost".
>
>However ....
>
>I can start the database instance running and then attempt to run
>SQL*Forms. I have create a SQL*Net entry aliased as "JRORCL", using
>protocol = TCP/IP, host name = localhost, database instance = ORCL.
>
>I can then successfully start a "lsnrctl80" session - successfully
>means that all the messages in the MS-DOS window seem sensible.
>
>When I run Forms 4.5 Designer, and try to connect using SYSTEM,
>MANAGER and database JRORCL, I get this message:
>
>ORA-12203: TNS:unable to connect to destination.
>
>Can you possibly mail me examples of your "tnsnames.ora", "sqlnet.ora"
>and any other files you think I would need to configure the
>connection, as well as details of which directory these should reside
>in? Or tell me what else you think is causing this to occur???
>
>Thanks
>
>JR
>
>
>
>Darren Eccles <d.g.e_at_btinternet.com> wrote:
>
>>Jeremy Russell wrote:
>>
>>> I'm trying to make D/2000 ( Forms 4.5.8.1.2 ) connect to a Personal
>>> Oracle 8.0.3 database, both running on the same Win95 PC. I have used
>>> SQL*Net Easy Config to try to set up the necessary service entries in
>>> ORACLEHOME/network/admin/tnsnames.ora.
>>>
>>> I've tried to use both TCP & SPX protocols - when I run the Forms
>>> Designer and choose File, Connect - entering SYSTEM/MANAGER and
>>> leaving the database name blank results in this message:
>>>
>>> ORA-03121: no interface driver connected, function not performed
>>>
>>> SQL*Plus 8 works just fine - no database connection string needs to be
>>> entered, just a user name and password. SQL*Plus 3 does not connect
>>> to the running database at all - although I don't think that's
>>> important, except for that this is used to create some of the sample
>>> data for working with D2000.
>>
>>I've also worked on win95, Ora 8 and SQL*Plus 8.0. On a standalone machine
>>you connect to the local (Ora8.0) database by default from SQL*Plus8.0.
>>However, to connect using D2000 (Forms 4.5 version) you will need to start
>>the Listener program. You will also need a valid TCP/IP stack set up (eg
>>using TCP/IP address 127.0.01 as a dummy) and a valid entry in the
>>tnsnames.ora file (you can achieve this using SQL*Net 2.0 easy config). I
>>found it possible to connect in this way. However, if you want to do any
>>OO stuff or use the new datatypes (eg LOBs) in Forms 4.5 for example, you
>>will find that it's not possible.
>>
>>> I was advised that I needed to create a "tnsnames" entry that
>>> specified the "Bequeath" drivers - when I try to modify my current
>>> entry to select this driver, I get a message specifying that the
>>> Bequeath driver is not installed.
>>>
>>
>>Bequeath does not work with Oracle8 at present so forget it.
>>
>>Hope this helps
>>
>>> I have looked on the PO8 installation CD and there is no appropriate
>>> driver - I have found the following drivers and installed these on my
>>> hard disk:
>>>
>>> Oracle SPX Protocol Adaptor V2.3.3.0.0A
>>> Oracle SPX Protocol Adaptor V8.0.3.0.1
>>> Oracle TCP/IP Protocol Adaptor V2.3.3.0.0A
>>> Oracle TCP/IP Protocol Adaptor V8.0.3.0.1
>>> Oracle Named Pipes Protocol Adaptor V2.3.3.0.0A
>>> Oracle Named Pipes Protocol Adaptor V8.0.3.0.1
>>>
>>> Can anyone give me more information on where I can get these drivers
>>> and /or suggest why I cannot connect from Forms 4.5 to my database?
>>>
>>> Thanks in advance ...
>>>
>>> Jeremy Russell
>>
>>
>>
>
Received on Mon Jun 29 1998 - 08:38:29 CDT