PO8, D2K and Windows 98

All,

I (and others) have recently had problems getting Personal Oracle 8.0.3 and Developer 2000 to work correctly under Windows 98. The problem with PO 8.0.3 was that the listener (LSNRCTL80.EXE) would crash when you tried to start it. The only workaround here is to install PO 8.0.4 - trust me, i've installed PO 8.0.4 last night and it works a charm. Oracle has certified PO 8.0.4 on Win 98.

The next problem was to get D2K to connect to oracle. The workaround (which I got from Oracle support) is listed here, and yes it also works. Although D2K (I am using v2.0) is not currently certified on Win 98. Apparently this won't be done until late October. Anyway, here's what Oracle support had to say. Hope it helps you all out:

 Personal Oracle8 is supported against Windows98 with the release of 8.0.4  version. Developer/2000 has not been supported against Windows98. They are  in the process of testing and hope to be done by late October.  Developer/2000 uses SQL*Net and Oracle8 uses Net8. Both components must be  installed and configured. However, when Developer is installed a new  version of SQL*Net is installed that is not compatible with Oracle8.  The directions below are to establish a connection between an Oracle 8.0.3  database and Developer/2000 version 2.0. If you do not have this version of  the database skip number 3 and continue with the configuration.  To set up a connection from Developer/2000 2.x to an Oracle8 database you  must follow the setup steps below:

1. Install Oracle8
2. Install Developer/2000 version 2.x
3. Re-install the Oracle Installer & SQL*Net 2.3.3.0.1
4. Re-install the Oracle installer from the Oracle8 distribution media (i.e. downloaded files or CD).
5. REMOVE SQL*Net 2.3.4.0.0 and the SQL*Net Adaptors 2.3.4.0.0
6. Install SQL*Net 2.3.3.0.1 and the SQL*Net TCP/IP Adaptor 2.3.3.0.1 from the Oracle8 distribution media. Please Note: You will need to make sure you have the TCP/IP protocol adaptor installed and configured with a valid IP address for your Operating system before continuing. If you are not connected to a network set your IP address to be obtained automatically. If you do not know how to configure TCP/IP please check with your network administrator or contact Microsoft for assistance.
7. Configure a SQL*Net ALIAS for your Oracle8 database
8. START - PROGRAMS - ORACLE FOR WINDOWS95(NT) - SQL*Net EASY Configuration.
9. ADD a database ALIAS.
10. Name the Database ALIAS anything you would like.
11. Select TCP/IP as your protocol Adaptor.
12. Enter 'localhost' for the TCP/IP Host name.
13. The database Instance will be the same as the database SID, which is ORCL if you are using the default database installed with Oracle8.
14. Start the listener.
15. go to a DOS command prompt.
16. type: lsnrctl80
17. at the lsnrct prompt type: start
18. Start up the database
19. START - PROGRAMS - Oracle8 for NT/95 - Start Database
20. Start up Developer
21. START - PROGRAMS - Developer 2000 r2.x - Forms Builder
22. Connecting to the database from Forms Builder
23. FILE - CONNECT
24. username - system
25. Password - manager
26. Connect String - (enter in the database ALIAS name that you created in step 4c)

Daniel

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 26 1998 - 02:48:05 CDT