F
Troubleshooting

This appendix describes how to troubleshoot problems with Oracle8 Enterprise Edition.

Specific topics discussed are:

Database Connection Issues

This table lists and provides answers to common Oracle8 database connection issues:

If You Receive This Error... Ensure Your...

TNS-12203 TNS: unable to connect to destination

OracleServiceSID and OracleTNSListener80¹ services are started. See section , "Managing Oracle Services" in Chapter 10, "Administering a Database" and Chapter 10 "Troubleshooting Net8" in Net8 Administrator's Guide.

ORA-12547 TNS: lost contact

OracleServiceSID, OracleStartSID, and OracleTNSListener801 services are started. You receive this error if you attempt to use any of the Oracle8 Utilities, such as Server Manager. See section , "Managing Oracle Services" in Chapter 10, "Administering a Database" for instructions.
Note: This error is analogous to the following Oracle7 error:
ORA-09352: Windows 32-bit Two-Task driver unable to spawn new ORACLE task

ORA-28575: unable to open RPC connection to external procedure agent ORA-06512: at "APPLICATIONS.OSEXEC", line 0 ORA-06512: at "APPLICATIONS.TEST", line 4 ORA-06512: at line 2
TNSNAMES.ORA and LISTENER.ORA files have been correctly configured to use external procedures. See "Configuring External Procedure Calls" in Chapter 8 of Net8 Getting Started for Windows NT and Windows 95/98.

¹ Ensure that OracleHOME_NAMETNSListener is started if you are using an Oracle8 database that has a home name.

If You Receive This Error...	Ensure Your...
`TNS-12203 TNS: unable to connect to destination`	OracleServiceSID and OracleTNSListener80¹ services are started. See section , "Managing Oracle Services" in Chapter 10, "Administering a Database" and Chapter 10 "Troubleshooting Net8" in Net8 Administrator's Guide.
`ORA-12547 TNS: lost contact`	OracleServiceSID, OracleStartSID, and OracleTNSListener801 services are started. You receive this error if you attempt to use any of the Oracle8 Utilities, such as Server Manager. See section , "Managing Oracle Services" in Chapter 10, "Administering a Database" for instructions. Note: This error is analogous to the following Oracle7 error: `ORA-09352: Windows 32-bit Two-Task driver unable to spawn new ORACLE task`
O`RA-28575: unable to open RPC connection to external procedure agent ORA-06512: at "APPLICATIONS.OSEXEC", line 0 ORA-06512: at "APPLICATIONS.TEST", line 4 ORA-06512: at line 2`	TNSNAMES.ORA and LISTENER.ORA files have been correctly configured to use external procedures. See "Configuring External Procedure Calls" in Chapter 8 of Net8 Getting Started for Windows NT and Windows 95/98.

Oracle8 Performance Monitor Issues

See "Oracle8 Performance Monitor Troubleshooting Information" in Chapter 12, "Monitoring a Database", for information on Oracle8 Performance Monitor troubleshooting issues.

Migration Issues

This section includes the following topics:

Migration Error ORA-54 with Batch Migration Scripts

If you are migrating from Oracle7 to Oracle8 Enterprise Edition with your own customized batch migration script, and the system seems to be taking unusually long to complete the migration, you may be experiencing an ORA-54 error. Follow these steps to complete migration:

Start Server Manager at the MS-DOS command prompt:

C:\> SVRMGR30

Connect to the Oracle8 database using your user name:

SVRMGR> CONNECT INTERNAL/PASSWORD

Start up the database by entering one of the following commands:

Command Description

SVRMGR> STARTUP

Uses the default INITSID.ORA file located in your ORACLE_HOME\DATABASE directory to start the Oracle8 database.

SVRMGR> STARTUP PFILE=PATH\FILENAME

Uses an initialization file other than the default to start your database. PATH\FILENAME specifies an initialization parameter file other than the default, INITSID.ORA. The following example starts the database using a file named INIT2.ORA.

SVRMGR> STARTUP PFILE=%ORACLE_HOME%\RDBMS80\INIT2.ORA

Run the following scripts in order using Server Manager:

Command	Description
`SVRMGR> STARTUP`	Uses the default INITSID.ORA file located in your ORACLE_HOME\DATABASE directory to start the Oracle8 database.
`SVRMGR> STARTUP PFILE=`PATH\FILENAME	Uses an initialization file other than the default to start your database. PATH\FILENAME specifies an initialization parameter file other than the default, INITSID.ORA. The following example starts the database using a file named INIT2.ORA.
	`SVRMGR> STARTUP PFILE=%ORACLE_HOME%\RDBMS80\INIT2.ORA`

CAT8000.SQL
CAT8004.SQL
CAT8005.SQL

Exit Server Manager:

SVRMGR> EXIT

Rollback Segments Error During Migration

You must add additional space in order to extend rollback segments if you receive the following errors when using either Oracle Data Migration Assistant or the Migration Utility (MIG80) to migrate your database to release 8.0.5:

ORA-00604: error occurred at recursive SQL level 1
ORA-01562: failed to extend rollback segment number 5
ORA-01650: unable to extend rollback segment RB4 by 50 in tablespace ROLLBACK_DATA

To add space to the rollback segments:

Restore the pre-migrated database from backup media.
Enter the following command at the Server Manager prompt to add space to the rollback segments:

SVRMGR> ALTER TABLESPACE ROLLBACK_DATA ADD DATAFILE `ORACLE_
HOME\RDBMS71\MIG.ORA' SIZE 20 M;

The data file size you specify depends upon the size of the database you want to migrate. See Oracle8 Administrator's Guide, Oracle8 SQL Reference, and Oracle8 Error Messages for more information.

Restart the migration process by using Oracle Data Migration Assistant or the Migration Utility (MIG80).

System Tablespace Extend Error

You must add additional space to the SYSTEM tablespace if you receive the following errors:

ORA-00604: error occurred at recursive SQL level 1
ORA-01653 (01654) unable to extend table SYS by 20 in tablespace SYSTEM

To add space to the SYSTEM tablespace:

Restore the pre-migrated database from backup media.
Enter the following command at the Server Manager prompt to add a data file to the SYSTEM tablespace:

SVRMGR> ALTER TABLESPACE SYSTEM ADD DATAFILE `ORACLE_
HOME\DATABASE\SYSSMIG.ORA' SIZE 20 M;

Restart the migration process by using Oracle Data Migration Assistant or the Migration Utility (MIG80).

OCIW32.DLL Error Message

Re-install Required Support Files release 8.0.5 if:

programs indicate that they cannot load OCIW32.DLL
applications have difficulties connecting to a database even though Net8 seems to be configured properly

These problems occur if after installing release 8.0 products, you subsequently install a product that installs Required Support Files release 7.3.2 or release 7.2. Oracle Web Server release 2.1 is an example of such a product.

To re-install Required Support Files release 8.0.5:

Run Oracle Installer from the CD-ROM.
Answer questions about language and Oracle home directory location.
Select the Custom Installation option.

The Software Asset Manager window appears.

Select Required Support Files version 8.0.5 in the left-hand window.
Click Install.

A window appears showing the progress of the installation. After installation is complete, a message appears confirming the installation.

Click Exit to exit Oracle Installer.

Oracle Data Migration Assistant

If you migrate an Oracle7 database that has a different database character set from the NLS_LANG environment variable, the text in the log file is written in English.

When trying to start your database with Server Manager after migrating from a 7.1.3.3.6 database, ensure that you use the PFILE option to identify the correct INITSID.ORA file. For example:

SVRMGR> STARTUP PFILE=C:\ORANT\RDBMS71\INITSID.ORA

where SID is the system identifier (SID) for the database you want to start.

Operating System Permission Issues

The permission problem (OS 5 or 3) is typically caused by inadequate configuration of the NTFS permissions. By default, the Oracle8 database service runs using the SYSTEM account instead of a named Windows NT user such as Administrator. In File Manager or Windows NT Explorer, you must grant Full Control on the ORACLE_HOME directory and all of its subdirectories to the SYSTEM user. The SYSTEM user has the full name The operating system and has an icon of a computer chip. For this and other Windows NT problems, consult your Windows NT documentation or contact your Windows NT System Administrator.

After correcting the problem, you must delete any files created as a result of partial completion of the CREATE DATABASE command. The files to delete are the:

Data files: SYS1SID.ORA, USR1SID.ORA, RBS1SID.ORA, TMP1SID.ORA
Redo log files: LOG1SID.ORA, LOG2SID.ORA, LOG3SID.ORA, LOG4SID.ORA
Control files: CTL1SID.ORA and CTL2SID.ORA

Then, run the BUILD_DB.SQL script again in Server Manager.

DOS Compatibility Mode on Windows 95 or Windows 98 Computers

If a Windows 95 or Windows 98 computer is in DOS COMPATIBILITY MODE, then it is unable to read the long file name of TRACESVR80 (and directory so named) from the CD-ROM. You can determine if a computer is running in compatible mode by right-clicking on MY COMPUTER, choosing PROPERTIES, and then selecting the PERFORMANCE tab. This will open a window that tells you which drives, if any, are running in compatible mode, or if your computer is running a complete 32-bit FILE System.

DOS compatible mode may be enabled by the operating system for several reasons:

A boot sector virus exists on the computer
A realmode device driver exists in the CONFIG.SYS and Windows NT has no protectmode driver that can take over for it
Too many INT 13 hooks exist
An old VxD exists for a controller in the SYSTEM.INI file that has no counterpart in Windows 95.

A list of all ProtectMode drivers, and some bad ones, exists on a Windows 95 computer in a file called IOS.INI. If a computer is running in compatible mode, then a log file should be created called IOS.LOG. This will list the devices that are running in compat/realmode and the reason why.

Additionally, if the Windows 95 or Windows 98 computer is on a LAN and can connect to a Windows NT computer (or a Windows 95 or Windows 98 computer whose CD-ROM drivers can deal with the long file name), place the CD-ROM in the Windows NT computer's CD-ROM drive and install the software on the Windows 95 or Windows 98 computer over the network.

Replication Manager and Snapshot Replication Sites

When using Replication Manager to configure a snapshot replication site, this error message may appear when trying to create a snapshot group:

ORA-23346: primary key is undefined for table or snapshot schema.table.

If this error does occur, remove the replication object, delete the snapshot group just created, and re-create the snapshot group. On the Snapshot Group Wizard - Individual Snapshot Settings dialog box, clear the check box for Minimum Communication. This error is logged as bug number 601075.

Oracle Web Publishing Assistant

Due to French government regulations on encryption, you cannot set your system default locale to French (Standard) in the Regional Settings Control Panel of Windows NT.

Oracle Assistants

This section includes known problems, restrictions, and workarounds to the Oracle Assistants:

The Help button of some Assistants is sometimes enabled even though online help is not available.
Oracle Net8 Assistant, Oracle Net8 Easy Config, and Oracle INTYPE File Assistant require monitors displaying at least 256 colors.
Oracle Assistants have an online help facility that includes the feature to search for a text string in the help text. This feature is activated by the Search button. When you click the Search button, a dialog box appears. You can then enter a text string such as a word or phrase into a text box and press the Find button to search for the string in the help text.
Currently, the Find feature cannot find a Japanese text string of more than one character. That is, if you enter one Japanese character to search, the search feature will work normally; it will find the character, provided it exists in the help text. If you enter more than one Japanese character, or one Japanese character mixed with other characters such as English characters, the search facility will fail to find the string even if it does exist in the help text. Searching for English and other European languages text strings does not have this limitation.

Oracle Database Assistant

The Oracle Database Assistant in this release is certified against an Oracle8 database only. Version 7 databases are not supported.
During installation, if you choose to install the starter database or use the Oracle Database Assistant, a dialog box appears asking if you want to view the documentation. If you choose Yes, a browser appears over the Assistant. To see the Assistant, dismiss the browser.
In order to enable the Image Demo for an existing instance (in the Modify route of the assistant), the SCOTT/TIGER account must have been created in that instance and CONNECT and RESOURCE roles must have been granted; the Oracle Database Assistant assumes the account is already created.

Oracle8 ConText Cartridge Workbench

Registering CTXV236.OCX on Windows 95 Clients

When executing Start > Programs > ConText Cartridge Workbench > Viewer Example on a Windows 95 client, you can receive an error message stating that registration of CTXV236.OCX failed. If you receive this error message: