Re: Personal Oracle 8 and Developer2000 on Windows 98

Benito Tacuyog wrote in message ...
>I got Personal Oracle 8 (8.0.3.0.0) and Developer2000 Enterprise Ed
>(8.0.5.0.0) installed in my computer. Forms Builder doesn't connect to the
>database eventhough the Personal Oracle 8 database had already been mounted
>and started running.
>
>I had been trying to figure out what's the problem here. I'll appreciate
any
>advice.
>
>Ben
>benito_at_idirect.ca
>

I am able to connect FORMS 5 with Personal Oracle 8.04:

Here are a few tips on configuration.
1.Developer uses SQL*Net , NOT Net80. So, make sure that sql*net 2.3.4 is installed. The bequeath protocol allows SQL*Plus 8 to connect locally by bypassing the listener process. However, Dev. needs the listener to connect locally
2. Make sure that you have %oracle_home\network\admin directory 3. You MUST start the listener after the database is started 4 Use the SQL*NET Easy config utility to create a new service. In my case, I simply deleted the exisiting 'ORCL' service and created a new one. when creating a new service, do not specify Bequeath as the protocol. Select TCP/IP instead. Also, you will need to provide the TCP/IP host name which is the computer name where oracle is installed.

1. Start Personal Oracle Database
2. Then, I go to Dos prompt and type lsnrctl80.exe
3. Then, I type START listener should be up and running! In my case, I have the following files tnsnames.ora,sqlnet.ora & listener.ora in C:\orawin95\network\admin Also, in the registery, there be an entry like net20=C:\orawin95\network

Once done, you should be able to connect from Sql*plus 3.3 as well as Developer by specifying user name, password, AND the service name. You cannot leave the connect string blank

good luck
wozi_at_dhc.net Received on Mon Sep 13 1999 - 04:00:26 CEST