Solved

Oracle 8i PE 8.1.5: RWBLD60 / UIW60.DLL Invalid Page Fault

Posted on 2001-07-17
3
2,221 Views
Last Modified: 2008-04-23
I've just finished setting up Oracle Developer 6.0 and Oracle 8i Personal Edition 8.1.5 under Windows 98. The Forms Builder check (to confirm I can connect to the database) went fine but when I tried checking the Report Builder by starting with "Build a new report manually" the program crashed, with the error:

RWBLD60 caused an invalid page fault in module UIW60.DLL at 0177:5ee83099.


Also, the setup instructions say the protocol in Tnsnames.ora is TPC but the file has TCP. I've left it as TCP; is this OK?

Thanks for any and all help!
0
Comment
Question by:lhutton
3 Comments
 
LVL 1

Accepted Solution

by:
lamija earned 75 total points
ID: 6291280
Developer Installation Issues
 
Cannot connect from Developer 6.0 to Oracle8i
     Personal Edition on Windows 98 (in a standalone  
     environment)
         The following will need to be done to establish a connection from  
         Developer 6.0 to Oracle 8i Personal Edition.

Install Oracle8i. Default Oracle_Home is as follows: (oracle/ora81)
If you are do not have a Domain name or are unsure of - use default selections (REMEMBER: your sid for step 3)
 
Install Developer 6.0 into a seperate Oracle_Home from the 8i database. Default Oracle_Home: ORAWIN95
 
Create a Net8 service name using the Net8 Easy config utility
(start -> programs -> Oracle ->network administration -> net8 easy config)
Enter the following information:

Select "create"
Name the service name - any name can be used.
Select TCP/IP as the protocol adapter
Enter your PC name as your host (as found in your TCP/IP properties of the control panel)
Select the second radio button to change your database instance to equal the SID created during your 8i installation or leave the default as ORCL.
Bypass the test and remaining screens by clicking next.
 
Go to the following location (using Windows Explorer): (Oracle/Ora81/network/admin/)  
(where Oracle/Ora81 is the name of your 8i Oracle_Home)
rename the sqlnet.ora file to: sqlnet.old
copy the tnsnames.ora file to the following location: (ORAWIN95/net80/admin) (where ORAWIN95 is the name of your Developer Oracle_Home)
 
Reboot
 
Start your listener:
At the DOS prompt type: LSNRCTL START
 
Start your database:  
(Start -> Oracle - OraHome81 -> Database Administration -> Start Database)
Start Developer and make a connection using:
username: system  
password: manager
database: <enter the service name created in step #3>

Top of page
 
 

  Cannot connect from Developer 6.0 to Oracle8i
     (any  edition) on Windows NT (in a standalone  
    environment)
        The following will need to be done to establish a connection from  
        Developer 6.0 to Oracle 8i.
Install Oracle8i. Default Oracle_Home is as follows: (oracle/ora81) If you are unsure of Domain name - use default selections (REMEMBER: your sid for step 3)
 
Install Developer 6.0 into a seperate Oracle_Home from the 8i database. Default Oracle_Home: ORANT
 
Create a Net8 alias using the Net8 Easy config utility (start -> programs -> Oracle ->network administration -> net8 easy config) Enter the following information:
Select "create"
Name the service name - any name can be used.
Select TCP/IP as the protocol adapter
Enter your PC name as your host
Select the second radio button to change your database instance to equal the SID created during your 8i installation or leave the default as ORCL.
Bypass the test and remaining screens by clicking next.
 
Go to the following location (using Windows Explorer): (Oracle/Ora81/network/admin/) (where Oracle/Ora81 is the name of your 8i Oracle_Home)
rename the sqlnet.ora file to: sqlnet.old
copy the tnsnames.ora file to the following location: (ORANT/net80/admin) (where ORANT is the name of your Developer Oracle_Home)
 
Reboot.
If your services are set to automatic then both your database and your listener service will automatically start upon bootup:

OracleService<SID>
OracleOraHome81TNSListener
 

 
 

Start Developer and make a connection using:
username: system  
password: manager
database: <the alias you created in step 3 above>
 

Top of page

  Developer 6.0 and Personal Oracle 8.0.3 or 8.0.4 standalone

Developer 6.0 is not compatible with Personal Oracle versions:  8.0.3 or 8.0.4 in a standalone environment.
For standalone compatiblity Developer 6.0 can be installed on the same machine as:

Oracle 8.0.5 (for Windowsw NT only) in the same Oracle_Home
Oracle8i (any edition) for Windows 98 or NT in seperate Oracle_Home directories
Developer 6.0 is compatible with all versions of Oracle databases 7.3.4 and higher in a client/server environment.
Top of page


  Developer 2.x & Personal Oracle 8.0.3 or 8.0.4 standalone

Create a SQL*Net alias:  
Start the SQL Net Easy Configuration (NOT the Net8 Easy config) (Start -> Programs -> Oracle for Windows NT (95) -> SQL Net Easy Configuration).  
Select Add Database Alias.  
Name the alias. Any name can be used.  
Select TCP/IP as the protocol adapter.  
Enter 127.0.0.1 as the hostname
Select the default database instance ORCL (unless connection is to a database that you have created, in which case this database instance name should be entered.).
Configure the Listener:
Download the following text file: listener.ora
Replace the sample listener file with the file downloaded from this page to the following location: orawin95\net80\admin (on Windows NT orawin95 is orant)
Reboot your PC
Start the Listener:
Go to a DOS prompt  
Type: LSNRCTL80  
At the LSNRCTL80 prompt type: start
Start the Database:  
Use one of the methods shown in step II (if using Server Manager the startup command will need to be issued after the connect).
With Oracle8 Personal Edition start the database using the icon within the Personal Oracle program group: Start -> Programs -> Personal Oracle8 for NT/95 -> Start Database.
Start Developer:  
This will vary with the Developer version being used. A login screen will pop up when any of the utilities within a tool need a database connection.  
 

For the default database enter:  

Username: system  
Password: manager  
Database: (enter the alias created within step I-3)
Top of page
  Developer 2.x & Oracle8i Personal Edition on Win98
The following will need to be done to establish a connection from Developer 2.1 or 2.0 to Oracle8i on Windows 98 or NT.
Install Oracle8i. Default Oracle_Home is as follows: (oracle/ora81)
Install Developer into a separate Oracle_Home from the 8i database. Default Oracle_Home:  
Windows NT: ORANT
Windows 98: ORAWIN95
Create a SQL*Net alias using the SQL*Net Easy config utility
(start -> programs -> Oracle for Windows NT -> SQL*Net Easy Config)
Enter the following information:
Select "Create"
Name the alias - any name can be used.
Select TCP/IP as the protocol adapter
Enter your PC host name as your host
Select the second radio button to change your database instance to equal the SID created during your 8i installation or leave the default as ORCL.
Bypass the test and remaining screens by clicking next
Reboot your PC
If your services are set to automatic then both your database and you listener service will automatically start upon bootup:
OracleService<yourSIDname>
OracleOraHome81TNSListener
Start Oracle Developer:
(close the data block wizard)
Start forms builder (start -> programs -> Developer/2000 -> Forms Builder)
file -> connect
At the login screen type the following:
username: system
password: manager
database: (enter the alias you created with the SQL*Net Easy Config)
Top of page
   Troubleshooting a Developer 6.0 Oracle8i connection
If you have followed all of the directions in the above connection procedure and are still not able to make a connection from Developer 6.0 to your Oracle8i database, please make sure of the following:
Make sure your listener file has the following entry:
 

(SID_DESC =
      (GLOBAL_DBNAME = Oracle)
      (ORACLE_HOME = c:\Oracle\Ora81)
      (SID_NAME = Orcl)
   )

This entry should be listed to the bottom of the listener.ora.  You can find the listener.ora at the following location: (oracle\ora81\network\admin)

A complete listener.ora will look as follows:

# C:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:c:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle Net8 Assistant

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST =host)(PORT = 1521))
      )
    )
    (DESCRIPTION =
      (PROTOCOL_STACK =
        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )
      (ADDRESS = (PROTOCOL = TCP)(HOST = host)(PORT = 2481))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = c:\Oracle\Ora81)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = Oracle)
      (ORACLE_HOME = c:\Oracle\Ora81)
      (SID_NAME = Orcl)
   )
  )
 

The tnsnames.ora that resolves this connection is found  in the following directory: \orawin95\net80\admin
(where orawin95 is the name of your Developer Oracle_Home). Make sure:
 
The host = the same host name listed in the above listener.ora file
(CONNECT_DATA =  (SID = orcl) If you have SERVICE_NAME listed instead of SID you will need to change this parameter manually.
Only ONE copy of the tnsnames.ora and a directory named sample should be in this directory.  If you have mutilple tnsnames files or a sqlnet.ora file you will need to delete these files.

Here is a sample tnsnames.ora entry:

CONNECT =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = host)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = orcl)
    )
  )

Although you may have multiple entries within your tnsnames.ora, only one entry is needed.  The above example will allow a user to connect from Developer to 8i with the following login:

username: system
password: manager
database: connect
 

The database and the listener must be started before making a valid connection.  If you are running Windows 98 you will need to restart both after rebooting your system.  If you are running Windows NT you can set these services to start automatically.

Lamija
0
 

Author Comment

by:lhutton
ID: 6291543
I'll accept this answer to close the question, but all that needed doing was to place a copy of UIW60.DLL in Windows\System and it worked fine. I've left the protocol as TCP.

Thanks all the same!
0
 

Expert Comment

by:bakead
ID: 21425133
Just copying the uiw60.dll to c:\windows\system
solves the same problem in Windows XP SP2 with Oracle 9i
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now