home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Network Support Encyclopedia 96-1
/
novell-nsepro-1996-1-cd2.iso
/
download
/
netware
/
n7016.exe
/
N7016.TXT
next >
Wrap
Text File
|
1994-12-22
|
11KB
|
297 lines
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=<logfile>'.
(Note that even though SQLLOAD.NLM will create a logfile without the
'LOG=<logfile>' 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 <username>" sends a null password. If
password is not null, use "CONNECT <username>/<password>" 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<language>.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.
-----------------------------------------------------------------