0169-0171

Previous Table of Contents Next

Page 169

Import (NWIMPORT)
SQL*Loader (NWLOADER)

Although the functions of the screen-mode utilities and the line-mode utilities are basically the same, the screen-mode utilities are menu-driven , and they provide online help and directory browsing in the native NetWare server environment.

Oracle Manager for NetWare enables you to perform these tasks :

• Administer the current database instance.
• Alter a tablespace to be offline or online.
• Configure Oracle7 Server.
• Create a new database instance.

The Export utility for NetWare in screen mode enables you to perform the following tasks:

• Select the Export mode.
• Browse and select a user or tables from a list of available objects to export.
• Enable or disable the export of grant, row, constraint, and index options.
• Set other parameters, such as record length, buffer size , and commit after each array.
• Generate log files.

Oracle7 Enterprise Backup Utility

The Oracle7 Enterprise Backup utility enables database administrators to effectively back up, restore, and recover Oracle7 databases. The utility can back up Oracle data files, control files, parameter files, online redo logs, and archived logs (when Archive Log mode is turned on). The Enterprise Backup utility architecture consists of two main components : target databases and the backup catalog database. Target databases are the Oracle7 databases you want to back up. The backup catalog database is an Oracle7 database to store the backup catalog, but it is a separate database and is not in any of the target databases.

NOTE

The backup catalog database should be a dedicated database only for storing the backup catalog. You should install the backup catalog database on a machine separate from all target databases. You also need to back up the backup catalog database as you would back up other important databases.

Page 170

TIP

When you try to create a backup catalog database, you might receive one of the following errors:

 PL/SQL is not installed on the database PL/SQL is not relinked with the Oracle executables 

If you see one of these messages, you need to make sure that the PL/SQL option is installed properly and linked into the Oracle kernel. Then you need to run the catproc.sql script as the internal or SYS user.

Before you can back up a new target database, you must use the Enterprise Backup utility to register the identification and configuration information of the target database. The utility saves the identification and configuration information in a backup catalog. The backup catalog is a set of tables in the backup catalog database. The backup catalog also contains the backup and restore history for each target database.

TIP

When you try to register a target database, you might receive one of the following error messages:

 OBK-5618:Unable to connect to Target Database with SID <sidname> OBK-504:SQL error ORA-12505:TNS:listener could not resolve SID given in the connect description 

If you see one of these messages, you need to make sure that the listener.ora and tnsnames.ora files are configured correctly and that the listener is started with the correct services.

After you register a target database, the Enterprise Backup utility automatically discovers the data files, control files, archived logs, and tablespaces in the target database. The utility uses this identification information to perform future backups and restores of the target database.

During the backup of a target database, if the Enterprise Backup utility finds any differences between the configuration of the target database and the backup catalog, it updates the backup catalog. During a restore, the utility performs data block address and number checking to ensure the consistency of the data files. If the Checksum option is enabled during backup, the utility also calculates and compares the checksum on each file.

In Oracle8, Enterprise Backup Manager is replaced by Recovery Manager (RMAN), which is integrated directly into Oracle8 Server.

Page 171

Oracle Trace

Oracle Trace is a new feature in Oracle7 Server 7.3. It is available in most of the UNIX platforms, but it is not included with Oracle7 Server for NT 7.3. Oracle Trace collects performance data for transaction processing and database applications. It gathers and reports event-based data only.

CAUTION

Oracle Trace is enabled by default on most of the UNIX platforms. If you experience one of the following symptoms after installing or upgrading to Oracle7 Server 7.3, you may need to disable Oracle Trace:

• The process.dat file in $ORACLE_HOME/otrace/admin is growing quickly. Its size is increasing.
• Sessions hang when connecting to the database, or it takes a long time to connect to the database.
• Database response is very slow.
• Sessions core dumps from SVRMGRL or SQLPLUS.
• Oracle generates a lot of zero-length trace files.
• You receive this message:

   ORA-7307 or ORA-7337 unable to attach sga 

• You receive this message:

   TNS-12164 Protocol errors 

To disable Oracle Trace, you can follow these steps:

1. Shut down all 7.3 databases.
2. Remove the process.dat and regid.dat files by issuing the following commands at the UNIX prompt:

    $ cd $ORACLE_HOME/otrace/admin $ rm process.dat $ rm regid.dat 

3. Set the environment variable EPC_DISABLED to TRUE for each client. In the C-Shell for UNIX, for example, issue the following command at the operating system prompt:

    $ setenv EPC_DISABLED TRUE 

SQL*Plus for NetWare

Finally, SQL*Plus, a SQL-based language interface and end-user reporting tool, is available for NetWare. SQL*Plus for NetWare is included with Oracle7 Server 7.2 and later for NetWare. You can start SQL*Plus for NetWare by entering the following command at the server console prompt:

 :LOAD SQLPLUS 

Previous Table of Contents Next