NOVELL TECHNICAL INFORMATION DOCUMENT TITLE: OracleWare NetWare Edition 1.0 DOCUMENT ID: TID905002 DOCUMENT REVISION: A DATE: 28NOV94 ALERT STATUS: Yellow INFORMATION TYPE: Symptom Solution README FOR: N7016.EXE NOVELL PRODUCT and VERSION: OracleWare for NetWare 1.0 ABSTRACT: This file includes the OracleWare NetWare Edition 1.0 RDBMS Patch 7.0.16.6.5A. ----------------------------------------------------------------- DISCLAIMER THE ORIGIN OF THIS INFORMATION MAY BE INTERNAL OR EXTERNAL TO NOVELL. NOVELL MAKES EVERY EFFORT WITHIN ITS MEANS TO VERIFY THIS INFORMATION. HOWEVER, THE INFORMATION PROVIDED IN THIS DOCUMENT IS FOR YOUR INFORMATION ONLY. NOVELL MAKES NO EXPLICIT OR IMPLIED CLAIMS TO THE VALIDITY OF THIS INFORMATION. ----------------------------------------------------------------- SYMPTOM A problem has been discovered in Oracle7 that causes a potential security risk. In certain unlikely circumstances, a knowledgeable user may be able to gain unauthorized privileges in the database. SOLUTION Apply the OracleWare NetWare Edition 1.0 RDBMS Patch 7.0.16.6.5A Self-Extracting File Name: N7016.EXE Revision: A Files Included Size Date Time \ N7016.TXT (This File) PASSWD.TXT 850 11-03-94 5:08p NS701665.EXE 8033367 11-30-94 7:25a Installation Instructions: OracleWare for NetWare Patch Upgrading Oracle7 Server 7.0.15 to 7.0.16 1. Create a directory called NS701665 on your client workstation hard drive, copy NS701665.EXE to that directory, extract the patch files by running: NS701665 -d -spassword Please read the included text file PASSWD.TXT for instructions on how to locate the password from your OracleWare documentation. 2. Shutdown NORMAL your database using release 7.0.15 3. Backup your database 4. Use ORAUNLD to unload all Oracle7 NLMs at the server console 5. Change your current directory to NS701665, which contains the 7.0.16.6.5 patch files. 6. CD INSTALL 7. At the C:\NS701665\INSTALL> prompt, type ORAINNW to start the Installer: C:\NS701665\INSTALL> ORAINNW If the Installer detects a previous installation and a previous machine type for the machine you are installing from, the Installer automatically accepts the previous machine type. The Installer then prompts you to run SQLPME at the DOS prompt. Start SQLPME by typing: C:\NS701665\INSTALL> SQLPME Then, start the Installer by typing: C:\NS701665\INSTALL> ORAINNW 8. Continue the installation by answering the questions from the Installer. 9. When the Installer screen displays the Available Products, please select the following products to install: Oracle7 Server 7.0.16.6.5A Oracle7 Utilities 7.0.16.6.5 SQL*NET SPX 1.1.1.14A Note: During the installation, you will be asked if you want to install the SEED database. If you have an existing database, and you would like to keep it, you should answer NO to the question. If you answer YES, the installation will overwrite your existing database. 10. After installing the above products, exit the Installer and proceed with the Oracle7 Server installation at the file server console. To exit the Installer: a. Press [F4] to go to the File Menu. b. Press [F] to pull down the File Menu. c. Press [X] to exit and return to the DOS prompt. 11. Use ORALOAD to load the Oracle 7 NLMs: : ORALOAD 12. Startup your database using release 7.0.16, for example: : LOAD SQLDBA SQLDBA> CONNECT INTERNAL SQLDBA> STARTUP 13. Run CAT716.SQL, CATPROC.SQL, and CATEXP.SQL under the INTERNAL account, for example: SQLDBA> CONNECT INTERNAL SQLDBA> STARTUP SQLDBA> @SYS:ORANW\RDBMS70\ADMIN\CAT716 (Assume SYS:ORANW is your ORACLE_HOME) Your database is upgraded to release 7.0.16 NetWare specific changes ------------------------ - To allow these utilities to be run in unattended batch files, IMP.NLM, EXP.NLM, and SQLLOAD.NLM will now pause when exiting UNLESS a log file is being used via the command line argument 'LOG='. (Note that even though SQLLOAD.NLM will create a logfile without the 'LOG=' argument, it is the presence of the LOG argument which will determine whether the utility will pause when exiting.) - Additional CONFIG.ORA variables: NW_SGA_MAX_ALLOC - maximum size of memory chunks allocated for SGA in KB default: 256 KB NW_PGA_MAX_ALLOC - maximum size of memory chunks allocated for PGA in KB default: (2 * NW_SGA_MAX_ALLOC) = 512 KB NW_NUM_TO_SWITCH - this value controls how often Oracle7 yields control to the Operating System. The lower the value, the more often Oracle7 yields control. This value may be raised to increase performance if no other CPU intensive applications are running on the server. default: 0 - It is no longer required that the log_archive_dest parameter have a trailing slash. The parser will now correctly interpret a path without a trailing slash, as in: log_archive_dest=%RDBMS70%\logs - If you do use a trailing slash in this or any other INIT.ORA parameter, be sure to "protect" this slash from being interpreted as a "continue string on next line" character. For instance, log_archive_dest=%RDBMS70%\logs\ will cause problems, most likely an LCC error. The correct format is log_archive_dest=%RDBMS70%\logs\ # - The checking of the log_archive_dest string has been changed, such that the validity of the indicated directory will be checked when mounting the database or when enabling archiving. If the directory is unreachable or does not exist, the database will return "ORA-00254: error in archive control string 'control string'". - The OSOPER role can now be used. This works in the same manner as the OSDBA role (see the ORACLE7 Server for Netware Installation and User's Guide for information on this), except that the NetWare group name is ORACLE_OPER. This group will be created automatically when you install Oracle Server 7.0.16.4.2. (See the ORACLE7 Server Administrator's Guide for information on the OSOPER role). - If you choose to install the seed database, and you use a character set other than WE8ISO8859P1 or US7ASCII, the installer will not install the seed database, but will install the SEED_BLD.SQL script. To create the database, you must run this script from SQLDBA, with an internal connection. Known limitations (to be corrected in the next release) ------------------------------------------------------- - CONNECT from screen-mode SQLDBA under NetWare does not work correctly... "CONNECT" returns DBA-115, and "CONNECT " sends a null password. If password is not null, use "CONNECT /" or use the Connect option under the Session Menu (so the password is not echoed to the screen). - Choosing "Help System" from screen-mode SQLDBA with NLS_LANG in CONFIG.ORA set to a language other than English will get an error because the translated help files do not yet exist. - #170926: Control-C in screen mode of SQLDBA on NetWare will not halt current operation. - Unloading SQL*DBA while starting up or shutting down the database can have unpredictable results. Avoid unloading SQL*DBA during these times. NetWare specific bugs fixed in V7.0.15.5.0 ------------------------------------------ - #188008: CONNECT INTERNAL works on console even with DBA_AUTHORIZATION not set to BYPASS - #175740: ORA-600 [13004] on index creation (NW Bug #187790) - #170194: ORA-600 [16213] when running Applications Autoinstall NetWare specific bugs fixed in V7.0.15.5.1 ------------------------------------------ - #185458: A misleading message is display for errors during deinstall - #183785: No support for TR8PC857 character set - #183261: Setting DUMP_DEST parameters incorrectly doesn't give error - #175474: Archive errors are caused by trailing slashes at end of line - #174065: CONFIG.ORA cannot translate NLS_LANG strings > 31 characters NetWare specific bugs fixed in V7.0.15.5.2 ------------------------------------------ - #193433: LOG_ARCHIVE_DEST in parameter file not parsed correctly: ORA-9216 returned if absolute path is used. - #194212: BACKGROUND_DUMP_DEST and USER_DUMP_DEST in parameter file not parsed correctly: ORA-9216 returned if absolute path is used. - #195842: NetWare console gets "Read from non-present page" error when starting up or shutting down with NW_USEDFS=FALSE (CLIB I/O) NetWare specific bugs fixed in V7.0.16.4.0 ------------------------------------------ - #193135: Migrate can't open message file MIG.MSB when loading. - #190161: Data corruption after massive update when using free lists. - #190890: In SQL_DBA, screen mode, entering a non-numeric value in MIN_SESSION_ID causes server to abend - #197247: Arabic files are on CD but do not install. - #195847: Netware console gets "Write to a protected or non-present page" when using database link. - #191798: SQL*Loader direct path load did not work. - #205450: Cannot do fast refresh as non-system user over dblink. - #208683: Migrate message files and SQL scripts installed in wrong place. - #193135: Migrate can't find MIGUS.MSB. - #207645: Migrate can't find MIGRATE.BSQ. NetWare specific bugs fixed in V7.0.16.4.2 ------------------------------------------ - #208796: ORA-1477 and ORA-2063 when using DBLINK. - #209043: Archiver crashes when LOG_ARCHIVE_BUFFERS > 5. - #200034: Startup and Shutdown from DOS client fails due to privilege problems. - #216824: Implement OSOPER role. - #213696: [17066] during shutdown. - #211962: Not possible to select character set when installing seed database. NetWare specific bugs fixed in 7.0.16.6.4 ----------------------------------------- - #232333: Shutdown immediate problems. - #222686: Paths specified in seed database. ----------------------------------------------------------------- Any trademarks referenced in this document are the property of their respective owners. Consult your product manuals for complete trademark information. ----------------------------------------------------------------- ÿ