Index   Search   Add FAQ   Ask Question  

Oracle for Novell Netware FAQ

$Date: 29-Jul-1997 $
$Revision: 1.1 $
$Author: Frank Naudé $

Topics

  • How is Oracle implemented on NetWare?
  • How much memory do I need to run Oracle on NetWare?
  • Danger! The following will corrupt your Oracle Files
  • What NLMs should be loaded to run Oracle?
  • How does one start Oracle from the server?
  • Can I redirect input/output with Oracle's NLMs?
  • What NLMs can be used when administrating my database?
  • What console commands can be used when administrating my database?
  • Where can I get more info about Netware?

  • Back to Oracle FAQ Index

    How is Oracle implemented on NetWare?

    The Oracle Server for Novell NetWare is implemented as a series of NLMs (NetWare Loadable Modules) that comprise the ORACLE RDBMS, supporting utilities, and connectivity software allowing Windows, DOS, OS/2, and UNIX clients to connect to the database via SPX/IPX or TCP/IP.

    Novell Netware was primarily designed as a file and print server. In order to run a database on it one must install much more memory than would typically be required to run a file and print server. Configurations in the order of 128 Meg memory is not uncommon.

  • Back to top of file

  • How much memory do I need to run Oracle on NetWare?

    Oracle can run with a minimum of 20 Mb of free RAM. An additional 10 Mb of free RAM is required if you want to install the Symmetric Replication Option.

    If you have performance problems, just keep adding more memory to the server. Amounts in the order of 128 Mb and higher are not uncommon.

    To determine how much free memory is available on your NetWare server:

  • Back to top of file

  • Danger! The following will corrupt your Oracle Files

    Versions 4.1 and 4.11 of Netware automatically create volumes with Block Suballocation and Compression turned On. Either of these features will corrupt Oracle files - DON'T USE THEM!

    You can check to see if these parameters are set by doing a VOLUMES command at the server console prompt. SA or CP under the flags column indicates that SubAllocation or ComPression have been set. To fix this you should:

    Copying the files over will not work as it will just copy over corrupted data.

  • Back to top of file

  • What NLMs should be loaded to run Oracle?

    The NLMs that needs to be loaded to run Oracle is stored in the SYS:SYSTEM\ORALOAD.NCF file. After running this netware control file, you can LOAD SQLDBA MODE=LINE, connect internal, and startup your Oracle database.

    This NLMs can be unloaded by running the SYS:SYSTEM\ORAUNLD.NCF netware control file, but remember to shutdown your database first.

  • Back to top of file

  • How does one start Oracle from the server?

    Starting with versions 7.2 and later, when starting the database from the server side you MUST use an ipc-loopback connection to make a two-task connection.

    Ex. Using SQL*DBA or SVRMGR:

      SET INSTANCE S:sid_name
      CONNECT INTERNAL/password@server_name-IPC
      STARTUP PFILE=oracle_home\DATABASE\INITsid_name.ORA
    
  • Back to top of file

  • Can I redirect input/output with Oracle's NLMs?

    STDERR can be redirected with (CLIB_OPT)/Efilepath. Eg:

    STDOUT can be redirected with (CLIB_OPT)/>filepath. Eg:

    STDIN can be redirected with (CLIB_OPT)/<filepath. Eg:

  • Back to top of file

  • What NLMs can be used when administrating my database?

    To load one of these NLMs, type LOAD nlm_name from the ":" console prompt.

    SVRMGR.NLM Oracle's Server Manager utility. With SRVMGR you can create, start, stop and manage your database.
    SQLLOAD.NLM Oracle's SQL*Loader data loading utility.
    SQLPLUS.NLM Oracle's SQL*Plus utility.
    IMP.NLM Oracle's data import utility.
    EXP.NLM Oracle's data export utility.
    EDIT.NLM This utility is used to edit files residing on the server. To run, type the following at your console prompt: LOAD EDIT Volume_Name:Directory_Path\File_Name
    MONITOR.NLM Monitor can provide a wealth of information about your server. Type the following command at your console prompt: LOAD MONITOR /P
    CONLOG.NLM Echoes all console activity to a text file called CONSOLE.LOG located in the SYS:\ETC directory. CONLOG.NLM is extremely useful in troubleshooting console error messages.

  • Back to top of file

  • What console commands can be used when administrating my database?

    Console commands are part of the SERVER.EXE and do not require a "LOAD" statement preceding them. The following commands can be typed in at the ":" prompt:

    MODULES Display the names, dates, versions, and descriptions of any NLM, LAN, or DSK drivers running on your server.
    CONFIG Show the server name, IPX internal network number, node address, hardware settings, and other information regarding your network cards.
    PROTOCOL Show information about what protocols have been properly registered on the server.
    VOLUMES Display all mounted NetWare volumes, their respective namespaces, and whether compression and/or disk suballocation is enabled.
    MEMORY Show how much memory NetWare registers.
    VERSION Show the revision of NetWare you are using and the number of users it will support.
    DISPLAY SERVERS Show all entities that are broadcasting themselves across the network. These entities may be Oracle listeners, fax servers, print servers, etc..
    SET Show a menu of choices represents a category of configuration parameters. There parameters are "set" in either the STARTUP.NCF, AUTOEXEC.NCF, or both.
    PATCHES If patches have been applied, you will see the individual patch NLMs listed with a description of the problem it fixes. If you receive error "???Unknown command???", then no patches have been applied.
    TIME Display the server's current date and time.

  • Back to top of file

  • Where can I get more info about Netware?

  • Back to top of file

  • General: Home | Index | Preamble | Glossary | OraCorp | Papers | Fun | News | Events | Y2000 | Books | Links | Forums
    Products: SQL | Plus | Loader | PL/SQL | PreComp | OPO | OMO | OO4OLE | DBA | PQO | PSO | OCO | Net | ODBC | WebServer | Des2k | Dev2k
    Systems: MVS | Unix | Windows | WindowsNT | NetWare | VMS