Home

Oracle A423961 Server User Manual

1. The practical limit as to the number of Master Sites an environment may have is 10 The SNPO to SNP9 process each handle one destination master at a time If you use the advanced replication option and intend to set up a large number of replicated objects monitor the following data dictionary tables e SOURCE e IDL_UB1 e IDL_UB2 e I SOURCE1 e ARGUMENT e IARGUMENT1 e IDL_SB4 e IDL_CHAR e TRIGGER If necessary increase the storage parameters to accommodate the storage requirements of large numbers of replicated objects 5 10 Oracle7 Server Getting Started for Windows NT SQL Language Conventions ROWID Datatype The Oracle7 Server SQL Reference describes all aspects of Oracle s implementation of the SQL language Certain features of SQL have operating system specific variations The ROWID datatype provides a hexadecimal address of each row ina database table The format of the ROWID datatype is block row file where block row and file are hexadecimal addresses that indicate the data block row and database file of the queried row The hexadecimal lengths for block row and file are eight four and four respectively These lengths do not vary with Oracle7 Server for Windows NT Additional Information See Oracle7 Server SQL Reference for A more information on the ROWID datatype SQL Ref Database Administration 5 11 5 12 Oracle7 Server Getting Started for Windows NT Documentatio
2. 6400 SQL Net Named Pipes Errors E 25 Codes 6401 6430 NETCMN Errors 000004 E 28 Appendix F National Language Support ccc ccc ccc eee eee F 1 NLS LANG so e tie t EEE E ade EN TA EAE F 2 Territory and Character Set Defaults F 2 Selecting Alternate Territories and Character Sets F 4 NLS Initialization Parameters 0 00 000000 e ee F 4 NLS_LANGUAGE and NLS_TERRITORY F 4 Using ALTER SESSION 0000 e eee eee eee F 4 INES SORT oireena his SNL SG SEK ete ced Sab F 5 Parameter Lasts 2 oc5 s cteeoscerene deeds oS eee eds Sig eS Aare F 5 LAN SUAS CSS cateteri eepe eho nat ae Seat nde ose F 5 Eogain o O E gie We E EE Lies F 6 Single byte Character Sets nnnsuan nuaran F 7 Multi Byte Character Sets 0 000000 F 8 Installing Additional Languages 60 000s sees F 8 Index Contents xiii xiv Oracle7 Server Getting Started for Windows NT CHAPTER Introducing Oracle7 Server for Windows NT T his chapter introduces you to Oracle7 Server for Windows NT It includes e special terms e Oracle7 Server for Windows NT overview e Oracle7 Server for Windows NT integration with Windows NT e Oracle7 Server for Windows NT product contents Introducing Oracle7 Server for Windows NT 1 1 Special Terms 1 2 Note the following special terms when using this Guide Client Instance Listener
3. 2 8 Install your choice of Oracle Call Interface Oracle Documentation Oracle Enterprise Manager Oracle Installer Oracle Pro C Oracle WebServer Oracle7 Database Administration Tools Oracle7 Performance Utility Oracle7 Server Oracle7 Server Options Oracle7 Advanced Replication Option Oracle7 Distributed Option Oracle7 Parallel Query Option Oracle7 Spatial Data Option Oracle7 Spatial Data Utilities Oracle7 Utilities Required Support Files SQL Net Oracle Intelligent Agent Oracle Names Server SOL Net Client SQL Net Protocol Adapters Named Pipes SPX TCP IP SOL Net Server SQL Plus Oracle7 Server Getting Started for Windows NT Options Windows NT Server This release of Oracle7 Server for Windows NT offers the following options e Distributed Option e Parallel Query Option e Spatial Data Option e Advanced Replication Option Additional Information For more information on these E options see Introducing Oracle7 Server for Windows NT in this Guide Using Oracle Installer These versions of Oracle Installer are available on your product CD e Oracle Installer for Windows NT for installing Windows NT products e Oracle Installer for Windows for installing Windows products on the Windows on Win 32 subsystem of Windows NT or on client workstations running Windows e Oracle Installer for Windows95 for Windows 95 systems Attention Get help during installation by choosing Using cS O
4. If the file is too large to fit on one diskette OCOPY prompts you to insert new diskettes as needed OCOPY catalogs the parts of the file automatically so that it can be reconstructed at a later time Note Always use a fresh diskette for each OCOPY procedure do not use OCOPY to back up a file onto a diskette that contains part or all of another file backed up using OCOPY To restore files backed up with OCOPY without the B option use the Windows NT COPY command to restore the files to the desired directory To restore a file that has been backed up to multiple diskettes using OCOPY with the B option insert the diskette containing the first part of the backed up file into the disk drive and use the following syntax ocoPYnn R a restore_dir where R specifies the restore option a specifies the drive containing the diskette with the backed up file and restore_dir specifies the directory on the server where the file being restored should be placed The restored file will have the same name as the original file that was backed up Database Administration 5 3 Backing Up RAW Files Logical RAW Files Physical RAW Files Restoring RAW Files This section describes how to back up Logical RAW files and Physical RAW files To back up Logical RAW files use the following syntax C gt OCOPYnn C new_file C gt 0COPYnn B C a where c represents the raw drive which holds a single RAW database file If you
5. Using Oracle Documentation After installation you can view and print the online documentation by double clicking the Adobe Acrobat icon in your Oracle Program Group Documentation Roadmap A 13 A 14 Oracle7 Server Getting Started for Windows NT APPENDIX Oracle7 Server Directory Structures O racle Installer creates top level directories on your hard disk For Windows NT the default home directory is ORANT The default Oracle home directory for Windows is named ORAWIN for Windows 95 it is ORAWINYS This section describes the directory structures created by the installation procedures appearing earlier in this guide These topics are covered e Oracle for Windows NT e Oracle for Windows Windows 95 e Oracle WebServer Installation Types Note The following graphics directory structures represent typical directory structures that result from installing Oracle products for Windows NT Windows Windows 95 you may have purchased licensed Your directory structures may vary Oracle7 Server Directory Structures B 1 Windows NT Directory Structure B 2 Oracle Installer places all Oracle products for Windows NT into subdirectories of ORANT The actual directory names vary according to the different products you install The letters nn designate the version number of the product installed For example if you have installed Version 7 0 or 7 1 7 2 of the Oracle7 Server for Windows NT an RDBMS70 or 7 1 7 2 subd
6. LEXICAL_ERROR Cause An error has been detected in the installation scripts Action Call Oracle Customer Support LOCKING_VIOLATION Cause A portion of the file specified in the full message has been locked by another process Action Release or terminate the other process or wait for it to complete OS_ERROR Cause There is an unexpected operating system error Action Runa utility program to locate any problems with the source or destination media the media could be the CD ROM drive a network drive or a floppy drive PERMISSION_DENIED Cause The network has denied permission to perform the selected action Action Check with the network administrator make sure you have Supervisor privileges and can perform the selected action Messages and Codes E 3 READ_ERROR Cause Action A problem has been detected on the source or destination media while executing an I O operation 1 If in a network environment verify that you have read permission for the networked file 2 Run a utility program to locate any problems with the source or destination media the media could be the CD ROM drive a network drive or a floppy drive RECALIBRATION_FAILURE Cause Action A hardware problem has been detected on the hard drive to which you are installing Run a utility program to diagnose the hard drive SHARING_VIOLATION Cause Action The file specified in the full message has been locked by another process Th
7. There was an unexpected return from the Windows NT system service CreateFile Check the operating system error code and consult the Windows NT documentation unable to attach to SGA SGA does not exist The System Global Area SGA does not exist Start up an Oracle instance unable to map shared memory SGA into the address space There was an unexpected return from the Windows NT system service MapViewOfFileEx Check the operating system error code and consult the Windows NT documentation shared memory SGA mapped to wrong address There was an unexpected return from the Windows NT system service MapViewOfFileEx Check the operating system error code and consult the Windows NT documentation unable to allocate memory with VirtualAlloc The program is out of memory Shutdown all unnecessary processes install more memory in the machine unable to deallocate memory with VirtualFree This is an internal error not normally expected to occur Contact Oracle Customer Support unable to protect memory with VirtualProtect This is an internal error not normally expected to occur Contact Oracle Customer Support Messages and Codes E 13 E 14 OSD 04200 Cause Action OSD 04201 Cause Action OSD 04202 Cause Action OSD 04203 Cause Action OSD 04204 Cause Action OSD 04205 Cause Action OSD 04207 Cause Action Process Errors OSD 4200 to OSD 4299 unable to
8. gt IMP73 options See Oracle7 Server Utilities for complete usage instructions and command line options available for Export and Import BUFFER and RECORDLENGTH Defaults Using SQL Loader When running the Export and Import utilities from the Oracle7 Server for Windows NT note that the default values for certain parameters are operating system specific Specifically the BUFFER parameter defaults to a value of 4K under Windows NT and the RECORDLENGTH parameter defaults to 2K SQL Loader enables you to load data from delimited ASCII text files and fixed length record files SQL Loader Release 7 3 includes a direct path option that bypasses the Oracle redo log and data verification features thereby decreasing loading time Use the direct path option only with data files known to be error free To start SQL Loader type C gt SQLLDR73 options SQL Loader Processing Options Windows NT supports the following processing options e VAR load variable length records Specify the OSD VAR lt recsizehint gt in the control file for this option to take effect The maximum size is 64K bytes e FIXn fixed record format in which each record is exactly n bytes long If the record is terminated by a newline character the newline character must be the nth byte wn stream record format in which each record is terminated by a newline character The maximum record size is 48K bytes Additional Inf
9. E8ROMANS8 E8ROMANS8 YUG7ASCII z2 2 23 2 2 2 3 zZ z2 2 Z z2 z2 zsz zZgzg ggg National Language Support F 7 Multi Byte Character Sets AL24UTFFSS JA165JIS KO16DBCS ZHT16DBT JA16DBCS JA16TSTSET KO16KSC5601 ZHT32EUC JA16EBCDIC930 JA16TSTSET2 ZHS16CGB231280 ZHT32SOPS JA16EUC JA16VMS ZHT16BIG5 ZHT32TRIS Installing Additional Languages If you wish to install an additional language for your Oracle7 Server for Windows NT for example to specify different National Language Support for different instances you must install the language files for that language directly to your Oracle7 Server for Windows NT directories If you installed Oracle7 Server for Windows NT from CD ROM you can install additional languages by directly copying the complete set of language files for that language from the CD ROM to ORANT RDBMSnn Copy the following files from the NT_X86 V7 UTIL NT_X86 V7 RSE and NT_X86 V7 RDBMS subdirectories on the CD ROM to the ORANT subdirectories indicated in the following table In the filenames x represents the abbreviation for the desired message language The language file abbreviations are listed in the Language File Abbreviations table Copy these files Into this directory ORAx MSB ORANT RDBMSnn DBAx MSB EXPx MSB IMPx MSB OPWx MSB SOSDx MSB ULx MSB LCDx S UIx MSB ORANT DBS ORANT PLSQLnn S S SB S ORANT PROnn F 8 Oracle7 Server
10. NETCMN message receive failure The SQL Net driver failed to receive a complete message from the communication channel Resubmit the connect string Contact the DBA if the error message persists Messages and Codes E 29 E 30 ORA 06413 Cause Action ORA 06414 Cause Action ORA 06415 Cause Action ORA 06416 Cause Action ORA 06419 Cause Action ORA 06420 Cause Action NETCMN connection not open The SQL Net driver was unable to open a connection with a remote node Check node or wait for available connection to open then re submit the connect string NETCMN disconnect failure The SQL Net driver was unable to close a connection Check the node or wait for an available connection to close and then re submit the connect string NETCMN incompatible versions The version of SQL Net driver loaded differs from SQL Net listener process opened Check the installation of SQL Net on both Windows and Windows NT Upgrade the software to the same version on both sides of the network NETCMN error on test An error occurred while testing the I O status of the network connection Contact your Oracle Customer Support representative NETCMN server cannot start oracle The Server was unable to start an Oracle process Make sure permissions on the remote Oracle program are correctly set Contact your system administrator NETCMN SID lookup failure Oracle7 Server for Windows NT failed
11. ORA 09264 ORA 09265 ORA 09266 ORA 09270 ORA 09271 ORA 09272 ORA 09273 ORA 09274 ORA 09280 ORA 09281 ORA 09282 ORA 09283 ORA 09290 ORA 09291 ORA 09292 ORA 09293 ORA 09300 ORA 09301 ORA 09310 sptpa error flagging process spwat error temporarily suspending process spawn error starting an oracle process szalloc error allocating memory for security szlon error verifying user name remote OS login is not allowed szrfc error verifying role name szrfc insufficient role name buffer space sllfcf error closing file sllfop error opening file sllfrb error reading records sllfsk error skipping records sksaalo error allocating memory for archival sksachk invalid device specification for LOG_ARCHIVE_DEST sksabIn unable to build file name sksasmo unable to send message to console osncon unable to connect DPMI not available osncon local kernel only supported in standard mode sclgt error freeing latch Messages and Codes E 7 ORA 09311 ORA 09312 ORA 09313 ORA 09314 ORA 09315 ORA 09316 ORA 09317 ORA 09318 ORA 09319 ORA 09320 ORA 09321 ORA 09322 ORA 09330 ORA 09331 ORA 09332 ORA 09333 ORA 09334 ORA 09335 ORA 09340 slsleep error temporarily suspending process slspool error spooling file to printer slsprom error prompting user sltln error translating logical name sql2tt two task error translating ORACLE_EXECUTABLE
12. Windows NT and other Oracle products Operating System Windows NT Default Legal Values supported languages territories and character sets This NLS_LANG parameter includes three components language territory and character set This parameter specifies the language in which the messages is displayed the format that the date is displayed and the character set displayed The default value causes all messages to be displayed in English Additional Information See Oracle7 Server Administrator s Le Guide for additional information about the NLS_LANG Admin parameter and its components Guide Configuration Parameters and the Windows NT Registry D 3 ORACLE_GROUP_NAME ORACLE_HOME ORACLE_PRIORITY Operating System Windows NT Default Oracle for Windows NT Legal Values any ASCII string This parameter specifies the name of the group containing icons of the Oracle products installed The parameter is added to your Windows NT Registry when you first install Oracle products even if the Installer does not create a program group for the Oracle products you have installed e g if you have installed only SOL Net software Operating System Windows NT Default ORANT Legal Values any valid directory on any drive This parameter specifies the Oracle home directory in which Oracle products are installed It is added to your Windows NT registry when you first install Oracle products This directory is the top directo
13. and the Oracle7 Utilities also use this directory to locate message and resource files Although it has no default the Oracle7 Server for Windows NT installation process sets the parameter as ORACLE HOME RDBMSnn where nn indicates the version of Oracle7 Server for Windows NT being used D 6 Oracle7 Server Getting Started for Windows NT Networking Parameters LOCAL NMP_MAX_CLIENTS The following parameter applies to the SQL Net V1 for Windows NT products used on your Oracle7 Server for Windows NT machine Note None of the configuration parameters stored in the NT Registry are associated with SQL Net V2 Operating System Windows NT Default 2 Legal Values any valid SQL Net driver prefix including database string parame ters This parameter specifies the SQL Net driver and complete connect string to use when no communications driver is specified upon loading an Oracle tool The parameter enables the DBA to define a default network connection When a user logs on without specifying any network parameters Oracle7 uses the LOCAL connection The default 2 connects the user to the instance designated by the ORACLE_SID parameter on the local machine If multiple instances are running on the local machine follow the colon with the SID e g 2 ORCL connects the user to the ORCL instance on the local machine Note You can reset this parameter on the command line at any time Operating System Windows NT SQL Ne
14. multiple processes can work together simultaneously to process a single SQL statement By dividing the work necessary to process a statement among multiple server processes the Oracle Server can process the statement more quickly than if only a single server process processed it Additional Information For more information on the Parallel Query Option see Oracle7 Server Tuning Enterprise Manager system management tools that combine a single point of control management console intelligent agents and common services in an integrated comprehensive systems management platform Additional Information For more information on Enterprise Manager see Oracle Enterprise Manager Concepts Guide and other Enterprise Manager documents included in your package WebServer 1 0 bundled as part of Oracle7 Server for Windows NT Oracle WebServer 1 0 enables you to bring data stored on your Oracle7 Server to the World Wide Web Additional Information For more information on the WebServer 1 0 see Oracle WebServer User s Guide Advanced Replication Option separately licensable feature Advanced Replication Option enables users to maintain and manipulate multiple copies of data at different sites in a distributed environment Additional Information There are many configuration and usage possibilities with Advanced Replication For more information about Advanced Replication in this Guide Oracle7 Server Distributed Systems Volume II
15. ssssassssas ssena 5 7 Installation Requirements nauna nan uaran nrnna 5 7 WI Parad ine ernen cee ccna EE shan ae each nee E A hae 5 7 Contents xi Appendix A Appendix B Appendix C Appendix D Using Advanced Replication Option 5 5 8 System Requirements for the Advanced Replication Option 5 8 Oracle Tablespace Requirements 00000005 5 8 Initialization Parameters for Advanced Replication 5 9 Setup Procedures arena a p tits See ce AY 5 9 Other Notes screens sien edie wick E E E wok din 5 10 SQL Language Conventions 6666s 5 11 ROWID Datatype 0 eee eee 5 11 Documentation Roadmap ccc cc cece eeees A 1 Documentation Catalog 6 cece nee A 2 ROA MAP lois eao e a a ENO ab e a a era E A 4 Documentation Sets uuas nassu cece eee A 5 Installation Documentation 0 0 000008 A 5 Oracle7 for Windows NT Administration Documentation A 5 Oracle Product Documentation s sasra rerna A 6 Using Oracle Documentation 0 0000 0008 A 13 Oracle7 Server Directory Structures ccc cece B 1 Windows NT Directory Structure 6066 e eee ee B 2 Windows Windows 95 Directory Structure B 4 Oracle WebServer Installation Types 0000005 B 5 Initialization Parameter Files 00 cece eens C 1 What Is an Initialization Parameter File C 2 L
16. szrpc unable to verify password for role szprv insufficient privileges slkhst error hosting out to operating system slgtd unable to obtain the current date and time sztfc unable to obtain the list of valid OS roles slzdtb unable to convert zoned decimal to binary slpdtb unable to convert packed decimal to binary session terminated internally by Oracle or by an Oracle DBA scgcan unable to process lk_sync_cancel return code scgcc unable to process Ik_close return code scggc unable to process Ik_open_convert return code scggc unable to process lk_convert return code scgcm unable to process return code in completion procedure specified ORACLE_SID is either invalid or too long Oracle7 Server Getting Started for Windows NT ORA 09341 ORA 09350 ORA 09351 ORA 09352 ORA 09353 ORA 09354 scumnt unable to mount database Windows NT two task driver unable to allocate context area Windows NT two task driver unable to allocate shared memory Windows NT two task driver unable to spawn new Oracle task Windows NT two task driver unable to open event semaphore Windows NT two task driver Oracle task unexpectedly died Codes 4000 4999 Windows NT Specific Oracle Messages The messages in this section are Oracle operating system dependent OSD messages that issue in response to an error condition in Windows NT Each message in this section triggers an Oracle database message listed in the preceding section
17. user s logon string Check the logon string and then correct the syntax error NETCMN reset protocol error The SQL Net driver detected an error while trying to reset the connection from a break state Resubmit the connect string Oracle7 Server Getting Started for Windows NT ORA 06406 Cause Action ORA 06407 Cause Action ORA 06408 Cause Action ORA 06409 Cause Action ORA 06410 Cause Action ORA 06411 Cause Action ORA 06412 Cause Action NETCMN error sending break message The SQL Net driver could not correctly handle an incoming out of band message Resubmit the connect string NETCMN unable to set up break handling environment The SQL Net driver could not set up out of band break handler Resubmit the connect string NETCMN incorrect message format A message from a partner contains a bad header Contact your Oracle Customer Support representative NETCMN message send failure SQL Net driver failed to send a message across the communication channel Resubmit the connect string NETCMN message receive failure SQL Net driver failed to receive a message across the communication channel Resubmit the connect string Contact the DBA if the error message persists NETCMN message send failure The SQL Net driver failed to send a complete message across the communication channel Resubmit the connect string Contact the DBA if the error message persists
18. 11 1 16 Software requirements client 2 18 SORT_AREA_SIZE parameter C 5 SORT_READ_FAC parameter C 5 SORT_SPACEMAP_SIZE parameter C 5 SOURCES data dictionary table 5 10 Spatial Data Option 2 9 spawn error starting an oracle process E 7 spdcr error creating detached background process E 6 spdde error terminating detached background process E 6 Special terms 1 2 specified ORACLE_SID is either invalid or too long E 8 spini error initializing process E 6 sptpa error flagging process E 7 spwat error temporarily suspending process SPX 2 3 SPX Adapter 1 9 SQL Structured Query Language 1 2 SOL commands standard 1 8 SQL conventions ROWID datatype 5 11 SQL language conventions 5 11 SQL DBA CONNECT INTERNAL command 1 6 SQL Loader utility 3 22 control files 3 23 definition of 1 8 examples 3 23 SQOL Net 1 9 2 3 defined 1 2 1 11 definition of 1 9 driver D 7 Versions 1 and 2 x 1 11 1 13 SQL Net listener service 1 6 SQL Net release 2 2 networking software LISTENER ORA file 2 22 Index 11 required configuration files 2 22 TNSNAMES ORA file 2 22 SQL Net version 2 2 networking software configuration of 2 22 SOL Plus 1 9 definition of 1 9 installation 2 7 SOL Plus Product installation 2 15 sql2tt two task error translating ORACLE_EXECUTABLE
19. 2 5 Networking Products 2 6 Oracle7 Client 2 6 2 16 Oracle7 Server 2 7 2 14 Oracle7 Server Clients 2 13 preparing for 2 5 Prorgrammer 2000 2 15 re installing 2 5 SQL Plus Product 2 15 Selective 2 8 2 17 SQL Plus 2 7 Windows NT 2 9 2 15 Windows Windows 95 clients 2 16 2 19 installation Oracle7 Client for Windows Windows95 2 20 Programmer 2000 2 7 Instance creating with Instance Manager 3 6 defined 1 2 definition 3 2 deleting 3 12 starting 3 13 Instance Manager 1 8 advanced parameters 3 9 command line 3 24 command line version 3 6 dialog box 3 6 GUI version 3 6 Instance Manager GUI version 1 5 Instance Manager Command Line commands 3 24 instance name 1 6 Instance Startup Mode automatic 3 7 manual 3 7 Instance Database shutting down 3 11 INTERNAL logging in as 1 7 internal buffer overflow E 17 Internal Password dialog box 2 14 invalid file header E 10 invalid logical block size E 9 invalid pid E 14 invalid priority specified in CONFIG parameter ORACLE_PRIORITY E 14 invalid record type and or load options E 16 invalid SGA SGA not initialized E 12 INVALID_FILE_NAME E 3 L LAN Manager Enhanced 2 18 Language changing with SQL DBA F 4 installing additional F 8 selecting during installation 2 11 2 19 LEXICAL_ERROR E
20. 3 the following two steps ensure database security e verify that the database connection is secure e assign SYSOPER or SYSDBA privileges to users to whom you want to grant privileged access to the database This procedure enables administrators to track who logs on as SYSOPER and SYSDBA Rather than logging on as INTERNAL users log on with their user ID plus the SYSOPER or SYSDBA privileges Additional Information See Oracle7 Server Reference for more eB information about database security Server Reference Oracle7 Server for Windows NT Memory Structures When you start a database Oracle7 Server for Windows NT automatically starts a single instance by creating background threads and memory structures unique to the Windows NT environment Each instance of the Oracle7 Server for Windows NT has its own separate Oracle system process and Oracle database service When you make a local or remote connection to an instance Oracle starts one new thread in the process dedicated to the new connection Oracle7 Server for Windows NT Integration with Windows NT The tight integration of Oracle7 Server for Windows NT with the Windows NT operating system gives you unprecedented opportunity to monitor and manipulate your server Information on Oracle7 Server for Windows NT and Performance Monitor Event Viewer OS Authentication and Groups and Roles is presented later in this guide Oracle7 Server for Windows NT Product Contents
21. 3 51 OR e Microsoft Windows NT Server Version 3 51 e CD ROM device driver e appropriate network transport protocol software Named Pipes the necessary Named Pipes software is installed as part of the Windows NT Complete New Installation TCP IP Microsoft TCP IP for Windows NT is not automatically installed during Windows NT installation See your Windows NT documentation for installation information SPX NWLink Microsoft s implementation of the IPX SPX protocol is available as part of Windows NT but is not automatically installed during Windows NT installation See your Windows NT documentation for installation information Note The preceding list describes only the requirements for the Oracle7 Server for Windows NT software which includes the Oracle RDBMS Oracle7 utilities and SOL Net server software Note Client machines connected to the Oracle7 Server for Windows NT must use the client component of the same version of SOL Net installed on the server Installing Oracle7 Server for Windows NT 2 3 Windows on Win32 WOW Most products running on Windows NT machines including Oracle7 Server for Windows NT and the SQL Net Listener are 32 bit Windows NT applications However you can also use the Windows NT subsystem Windows on Win32 WOW to use 16 bit Oracle Windows products Windows on Win32 is installed automatically when you install the Windows NT operating system Windows NT WOW Su
22. Action OSD 04214 Cause Action OSD 04215 Cause Action OpenProcess failure unable to open process handle There was an unexpected return from the Windows NT system service OpenProcess Check the operating system error code and consult the Windows NT documentation Incorrect or unknown background image name given to spdcr There was an unexpected background name given to spdcr Contact Oracle Customer Support Timeout waiting for thread semaphore An Oracle7 thread died holding the semaphore Restart Oracle7 instance Thread information not found An Oracle7 thread died without deleting its information Restart Oracle7 instance Maximum number of Oracle threads reached The maximum number of Oracle7 threads for the instance is reached Wait until some connections exit before trying again Oracle thread unable to DuplicateHandle This is an internal error not normally expected to occur Contact Oracle Customer Support Oracle thread unable to CreateEvent This is an internal error not normally expected to occur Contact Oracle Customer Support Bad function code supplied to ssthreadop This is an internal error not normally expected to occur Contact Oracle Customer Support Messages and Codes E 15 OSD 04216 Cause Action OSD 04217 Cause Action Unable to find file handle for that thread This is an internal error not normally expected to occur Contact Oracle Customer S
23. By changing the value of these parameters you can specify for example the amount of memory the database uses whether filled online redo logs will be archived and which control files currently exist for the database Additional Information A general description of the Initialization parameters reside in initialization parameter files To allow parameter values to be unique to a particular database each database normally has its own initialization parameter file Location of Initialization Parameter Files The computer that starts the instance must have access to the appropriate initialization parameter files Oracle7 uses the initialization parameter files located in ORANT DATABASE unless you specify a file with the PFILE option at startup Editing Initialization Parameter Files To customize Oracle7 Server for Windows NT databases functions you may need to edit the initialization parameter files Use any ASCII text editor to modify the file The Sample Initialization Parameter File C 2 The initialization parameter file INITORCL ORA used by the initial database that you can install with Oracle7 Server for Windows NT is installed in ORANT DATABASE You can use this file as a model for creating a new Oracle7 Server for Windows NT database Oracle7 Server Getting Started for Windows NT The annotated sample initialization parameter file contains alternative values for the initialization parameters These values and the
24. E 8 SQLNET parameter D 10 Start Oracle Services tool 3 5 3 6 Starter database 3 2 files 3 4 installing 2 14 modifying 3 2 tablespace structure 3 3 user accounts 3 4 starter database 3 2 Starter Database Summary dialog box 2 14 Starting an instance D 5 STARTUP statement 3 18 Statement CREATE DATABASE 3 17 3 18 STARTUP 3 18 stdin not responding E 17 STORAGE clause 3 20 Stored procedures 1 8 SVRMGR gt CONNECT username password 3 11 SVRMGR gt STARTUP PFILE path filename 3 11 SVRMGR gt STARTUP PFILE C ORANT RDBMS73 INIT2 ORA 3 11 SVRMGR gt path filename 3 18 SVRMGR gt CONNECT INTERNAL PASSWORD 3 18 SVRMGR gt STARTUP NOMOUNT PFILE path filename 3 18 SYSIORCL ORA 3 4 database file 3 16 SYSDBA 1 7 privileges granting 4 7 Index 12 Oracle7 Server Getting Started for Windows NT SYSOPER 1 7 privileges granting 4 7 System Global Areas SGAs C 3 System requirements client 2 18 Oracle7 Server hardware 2 2 Replication Option hardware 2 2 security 2 2 Server 2 2 software 2 3 SYSTEM tablespace 3 19 szalloc error allocating memory for security E 7 szlon error verifying user name E 7 szprv insufficient privileges E 8 szrfc error verifying role name E 7 szrfc insufficient role name buffer space E 7 szrfc unable to obtain the l
25. Getting Started for Windows NT Language File Language Language File Language Abbreviation Abbreviation AMERICAN US TALIAN I ARABIC AR APANESE JA BRAZILIAN PORTUGUESE PTB OREAN KO BULGARIAN BG LATIN AMERICAN SPANISH ESA CANADIAN FRENCH FRC LITHUANIAN LT CATALAN E MEXICAN SPANISH ESM CROATIAN HR NORWEGIAN N CZECH cs POLISH PL DANISH DK PORTUGUESE PT DUTCH NL ROMANIAN RO EGYPTIAN EG RUSSIAN RU ENGLISH US SIMPLIFIED CHINESE ZHS ESTONIAN ET SLOVAK SK FINNISH SF SLOVENIAN SL FRENCH SPANISH E GERMAN SWEDISH S GERMAN DIN THAI TH GREEK EL TRADITIONAL CHINESE ZHT HEBREW IW TURKISH TR HUNGARIAN HU UKRAINIAN UK ICELANDIC IS National Language Support F 9 For example the following list is the complete set of American language files ORAUS MSB PCMUS MSB DBAUS MSB PLSUS MSB EXPUS MSB PXUS MSB IMPUS MSB OPWUS MSB SOSDUS MSB SQLUS MSB ULUS MSB UIUS MSB LCDUS MSB F 10 Oracle7 Server Getting Started for Windows NT Index Symbols REMOTE_OS_AUTHENT variable not set to TRUE E 18 DELETE ORADIM73 command 3 25 EDIT ORADIM73 command 3 24 NEW ORADIM73 command 3 24 SHUTDOWN ORADIM73 command 3 25 STARTUP ORADIM73 command 3 25 help ORADIM73 command 3 25 BIN B 4 DATABASE in ORANT B 3 DBS in ORANT B 3 in ORAWIN B 4 HKEY_LOCAL_ MACHINE SOFTW ARE ORACLE D 2 NETWORK in ORANT B 3 in ORAWIN B 4 NETWORK ADMIN B 3 B 4 NETWORK L
26. If you choose Database Administrator the Database Administrator dialog box appears if you choose Application User the Application User dialog box appears Choose the products you want to install Click OK to begin the installation The SQL Net Protocol Adapters dialog box appears Choose the SQL Net Protocol Adapters you want to install then click OK An Oracle dialog box appears displaying the progress of the installation When the installation is complete a notification dialog box appears prompting you to read the Release Notes for the latest information Click OK to dismiss the notification The Software Asset Manager window reappears Exit Oracle Installer by clicking on the Exit button and confirm your exit when prompted Installing Oracle7 Server for WindowsNT 2 13 2 14 If you choose Oracle7 Server a Select Oracle7 Server in the Software Asset Manager to install the products included in this package Click the Install button The Oracle7 Server dialog box appears displaying the products that will be installed You can de select products from this list Click OK to begin the installation The Oracle7 Server for Windows NT Options dialog box appears Select the options for which you are licensed then click OK The Install Starter Database dialog box appears asking if you want to install the starter database in the ORANT DATABASE directory Choose Yes unless you want to create a new database of your
27. Instance To delete an instance A Warning Deleting an instance also deletes the database 1 Select the instance you wish to delete in the Instance Manager dialog box 2 Choose the Delete button 3 Choose Yes to confirm the deletion Running Multiple Instances To run multiple instances you must ensure that you have already created each instance and started the services for each instance using the Instance Manager use the Instance Manager to create and delete instances You then run multiple instances by starting each of the instances using either Server Manager or Database Manager Server Manager is used to start up the database only Start Services using the Services applet in the Windows NT Control Panel if the services are not already started Using Server Manager 3 12 For each instance you wish to run 1 Begin at the command prompt and set a value for the ORACLE_SID configuration parameter by typing C gt SET ORACLE _ SID sid where sid is the name of the instance 2 Start Server Manager and start up the instance by typing C gt SVRMGRnn SVRMGR gt CONN ECT INT ERNAL PASSWORD SVRMGR gt STARTUP Note In the first line nn is the version of Server Manager you are using for example SVRMGR73 Note After you type the connect internal statement you re prompted to type the password of the internal account this is the same password you entered
28. Manager Attention For information on the GUI version 32 bit ZS Instance Manager see the following section For information on the command line version of Instance Manager see the appendix Using the Instance Manager from the Command Line in this Guide On occasion for example if you want to re install the server software you must stop the Oracle Services To do this open the Windows NT Control Panel select Services and choose Stop Using Oracle7 Server for Windows NT 3 5 Instance Manager Instance Manager is a graphical tool used to create and modify instances This section describes how to create and modify Oracle instances using Instance Manager Creating an Instance and Database with Instance Manager 3 6 Creating Oracle instances includes creating an Oracle service s and a database Follow these steps AN Warning When you create an instance using Instance Manager a new database is automatically created If you want to create an instance without creating a new database use the command line version of Instance Manager ORADIM73 EXE Attention For information on the GUI version 32 bit ZS Instance Manager see the following section For information on the command line version of Instance Manager see the appendix Using the Instance Manager from the Command Line in this Guide 1 Double click the Oracle Instance Manager icon in the Oracle7 Server for Windows NT Program Group Instance Manager start
29. ORA 06111 Cause Action ORA 06112 Cause Action ORA 06113 Cause Action ORA 06114 Cause Action ORA 06115 Cause Action ORA 06116 Cause An I O error occurred while attempting a network read operation Contact your Oracle Customer Support representative NETTCP message send failure An I O error occurred while attempting a network write operation Contact your Oracle Customer Support representative NETTCP disconnect failure An error occurred while attempting to close a socket Contact your Oracle Customer Support representative NETTCP invalid buffer size The buffer size specified in the login string exceeds 4096 Specify the correct buffer size 4096 or less in length NETTCP Too many connections The number of concurrently open connections has exceeded the maximum Close a connection by exiting an application with an open connection that is no longer needed NETTCP SID lookup failure The database SID specified in the login connect string was not recognized from the remote host s SQL Net TCP IP server Add the appropriate SID entry to the parameter file on the remote host then restart the SOL Net TCP IP server NETTCP unable to create ORACLE logicals The host s SQL Net TCP IP server was unable to create the necessary logicals required by the Oracle7 Server for Windows NT process See the SQL Net TCP IP server log file for more information Contact your system
30. Oracle7 Server Oracle7 database Oracle7 RDBMS Oracle Protocol Adapter Oracle tool SQL SQL Net Oracle Database Tools Oracle7 Server Getting Started for Windows NT A system that runs an Oracle supported application and connects to the shared database s on an Oracle7 Server The combination of processes that begins each time a database is started An executable program that enables an Oracle7 Server to accept connections from client workstations A host system that runs a multiuser Oracle7 Relational Database Management System RDBMS and maintains at least one database that can be shared by remote clients The term Oracle7 Server refers to the RDBMS that is using SQL Net and is capable of serving Oracle clients The software used to create and maintain the database system as well as the actual data stored in the database The Oracle Relational Database Management System Oracle7 Server for Windows NT is an Oracle RDBMS The software component of the Oracle Transparent Network Substrate TNS architecture that translates TNS function calls into requests to the underlying network protocol Any Oracle application tool such as SQL Plus an Oracle end user tool such as Oracle Forms or a third party software program that interfaces with an Oracle7 Server Structured Query Language the internationally accepted standard for defining and manipulating relational databases The Oracle client server co
31. PL SQL and the distributed database option must also be installed catproc sql and catalog sql1 must already have been run if you are not using the starter database advanced replication option cannot be used with releases prior to release 7 1 6 All sites must upgrade to Version 7 1 6 or later to use the advanced replication option SHARED POOL SIZE must be at least 1OMB this requirement may be greater depending on your replication needs If you receive an error increase the SHARED POOL SIZE SQL Net V2 Consult the SQL Net documentation on how to set up V2 You should monitor the installation of the replication scripts and increase the amount of rollback segment resources as necessary If you are migrating from a previous version of Oracle7 Server for Windows NT and want to use the advanced replication option you must first complete the migration see Migrating from Earlier Oracle7 Versions in this Guide After migrating you can choose the advanced Database Administration 5 7 replication option during Release 7 3 installation see Installation in this Guide Using Advanced Replication Option Caution The Advanced Replication Option is an advanced feature Please consult your Oracle7 Server Distributed Systems Volume II Replicated Data documentation for concepts and details before proceeding Consult with Oracle Consulting if necessary System Requirements for the Advanced Replication Option In addition to the hardwa
32. RECORDLENGTH parameter of EXP utility 3 16 of IMP utility 3 19 Recovery Manager 5 4 Refreshing table snapshots 5 6 Relative Thread Priority D 5 Remote connection to an instance 1 7 Remote database access 1 5 remote OS login is not allowed E 7 REMOTE parameter D 9 REMOTE_LOGIN_PASSWORDFILE parameter C 5 REMOTE_LOGIN_PASSWORDFILE EXCLUS IVE 4 5 REMOTE_LOGIN_PASSWORDFILE NONE 4 6 Index 9 REMOTE_LOGIN_PASSWORDFILE SHARE D 4 6 Removing Options 2 23 Removing product components 2 23 Resource costs 3 20 setting 3 20 Restoring active files 5 3 Restoring RAW files 5 4 role CONNECT 3 4 DBA 3 4 RESOURCE 3 4 ROLLBACK _SEGMENTS initialization parameter 3 19 Row header 3 20 ROWID datatype 5 11 S scgcan unable to process lk_sync_cancel return code E 8 scgcc unable to process Ik_close return code scgcm unable to process return code in completion procedure E 8 scggc unable to process Ik_convert return code E 8 scggc unable to process lk_open_convert return code E 8 sclgt error freeing latch E 7 scumnt unable to mount database E 9 sdnfy bad value s for parameter s E 6 Secure Network Services 1 9 Security features 1 5 1 6 Selective installation 2 8 2 17 Selective Install client 2 21 Selective Install server 2 16 Server Oracle7 1 2 Windows NT 1
33. Snapshot Refresh threads which can periodically refresh snapshots Several Snapshot initialization parameters control refresh threads including e SNAPSHOT_REFRESH_PROCESSES e SNAPSHOT_REFRESH_INTERVAL e SNAPSHOT_REFRESH_KEEP_CONNECTIONS Additional Information The Oracle7 Server SQL Reference lists LE these initialization parameters their default values and the SQLRef range of acceptable values as well as providing explanations of these parameters Note Snapshot Refresh threads are only available with the Distributed Option of Oracle7 Server for Windows NT Oracle7 Server Getting Started for Windows NT Advanced Replication Option This section includes details not contained in the source documents for the Advanced Replication Option Oracle Advanced Replication Installation Requirements Upgrading Additional Information There are many configuration and usage possibilities with Advanced Replication For more information about Advanced Replication see Oracle7 Server Distributed Systems Volume II Replicated Data Oracle7 Server Concepts Oracle7 Server Administrator s Guide and other appropriate documentation Certain requirements must be met during the installation process for the Advanced Replication Option to function properly These installation requirements are advanced replication option must be installed at all sites participating in replication both master and updatable snapshot sites
34. Tools Security Features improved security features for remote database access See Security Features in this chapter for more information on database security Multiple Version Installation Oracle7 Server for Windows NT can run along with earlier releases of Oracle7 Server for Windows NT See Installation in this Guide for more information Oracle Names Support a tool that allows you to save in a centralized database full network locations in the form of easy to remember aliases Additional Information For detailed information on the new features of Oracle7 Server not specific to Windows NT see Oracle7 Server Migration Introducing Oracle7 Server for Windows NT 1 5 Features Specific to Windows NT Windows NT Services Security Features This Guide describes a number of features unique to Oracle7 Server for Windows NT This chapter describes those features briefly more detailed discussions appear later in this Guide A service is an executable process installed in the Windows NT Registry database and administered by Windows NT The Windows NT Registry automatically tracks and records security information for each service you create Once you create and start a service on your Oracle7 Server for Windows NT machine the service can run even while no user is logged on Windows NT Services and Workstation Security Since Oracle7 Server for Windows NT runs each instance as a service the instance can also run with no user
35. Windows NT Click OK The SQL Net Protocol Adapters dialog box appears Choose the SQL Net Protocol Adapters you want to install then click OK An Oracle dialog box appears displaying the progress of the installation After the product s are installed you will be prompted to read the Release Notes for the latest information Click OK to dismiss the notification The Software Asset Manager window reappears Exit Oracle Installer by clicking on the Exit button and confirm your exit when prompted If you choose Programmer 2000 a Select Programmer 2000 in the Software Asset Manager to install the products included in this package Click the Install button The Programmer 2000 dialog box appears giving you the choice of installing Pro C and or Oracle Call Interface Choose the product s you want to install then click OK An Oracle dialog box appears displaying the progress of the installation After the product s are installed you will be prompted to read the Release Notes for the latest information Click OK to dismiss the notification The Software Asset Manager window reappears Exit Oracle Installer by clicking the Exit button and confirm your exit when prompted If you choose SQL Plus a Select SQL Plus in the Software Asset Manager to install the product included in this package Click the Install button The product is installed A dialog box appears reminding you to read the Release Notes Cl
36. a version of the Oracle database shut down any instances and stop any Oracle services currently running before you attempt to install the new database software 2 Install Oracle7 Server for Windows NT Products a To start Oracle Installer for Windows NT run Oracle Installer executable ORAINST You can run ORAINST for Windows NT one of the two ways described below From the Program Manager From the Windows NT Program Manager select Run from the File menu Enter the path and executable file name for example G NT_X86 INSTALL ORAINST EXE Click Enter From the File Manager From the Windows NT Program Manager choose the File Manager icon Select the drive to which the CD ROM is connected Choose the NT_X86 icon 2 10 Oracle7 Server Getting Started for Windows NT Choose the INSTALL directory icon Choose the ORAINST EXE file icon If you are using Oracle Installer for the first time it prompts you to select a language b Select a language or choose OK to accept the default language When you select a language Oracle Installer sets the NLS_LANG configuration parameter National Language Support NLS can be changed after installation by changing the values for the NLS_LANG configuration parameter and by using Oracle Installer to install the message files for the additional language See Migrating from Earlier Releases and National Language Support for details on installin
37. annotations are preceded by comment signs which prevent them from being processed To activate a particular parameter remove the preceding sign When you no longer want to use a particular parameter edit the initialization parameter file to add a comment sign For example several initialization parameters are specified with three different values to create small medium or large System Global Areas SGAs respectively By default the parameter that would create a small SGA is active as in db_block_buffers 200 SMALL db block buffers 550 MEDIUM db_block_buffers 3200 LARGE If you wish to create a medium sized SGA instead comment out the small parameter definition and activate the medium In the previous example you would change file to read db_block_buffers 200 SMALL db_block_buffers 550 MEDIUM db_block_buffers 3200 LARGE Parameters to Modify when Creating a New Database Check the initialization parameters described in this section carefully at the time you create a new database they cannot be modified after you have created the database See Chapter 3 of this Guide for details on creating a new database including the part of the procedure when you modify these parameters DB_NAME Specifies the name of the database to be created The database name is a string of eight characters or less You cannot change the name of a database CHARACTER_SET Specifies the datab
38. by specifying the following parameters NI EW SID lt sid gt INTPWD lt internal_pwd gt MAXUSERS lt number gt STARTMODE lt auto manual gt PFILE lt filename gt e SID is mandatory sid is the system identifier SID The remaining parameters are optional e For internal_pwd specify the password for the INTERNAL account e For number specify the number of users in the password file The default is 5 Attention Creating an instance using ORADIM73 in command iS line mode only creates the password file and related service The database is NOT created that is database files are not created Edit a database instance by specifying the following parameters EDIT SID lt sid gt NEWSID lt newsid gt INTPWD lt internal_pwd gt STARTMODE lt auto manual gt PFILE lt filename gt e SID is mandatory sid is the system identifier SID The remaining parameters are optional e For newsid specify the new SID for the instance enter only if changing an existing instance name e For internal_pwd specify the password for the INTERNAL account this is necessary only if the password file was not created earlier Oracle7 Server Getting Started for Windows NT STARTUP SHUTDOWN DELETE help To start an instance specify the following parameters STARTUP SID lt sid gt PFILE lt filename gt USRPWD lt user_pwd gt S
39. command line mode Starting a Database Using Server Manager To start the database using Server Manager follow these steps 1 Start Server Manager by typing at the command prompt C gt SVRMGR73 2 Connect to the database using your username SVRMGR gt CONNECT username password When you use Server Manager in line mode if you do not include a password in your CONNECT statement and a password has been set Server Manager prompts you to enter one When you use Server Manager in screen mode if you do not include a password in your CONNECT statement and a password has been set Server Manager displays an error message To enter your password without typing it on the command line choose Connect from the Session menu 3 Start up the database by typing the following SVRMGR gt STARTUP PFILE path filename where path filename specifies an initialization parameter file other than the default INITsid ORA This example starts the database using a file named INIT2 ORA SVRMGR gt STARTUP PFILE C ORANT RDBMS73 INIT2 ORA After completing these steps you can make local connections to Oracle7 Server Shutting Down an Instance Database In Release 7 3 you can startup and shutdown a database using Server Manager Database Manager or ORADIM73 command line mode Instance Manager does not provide that functionality except while creating deleting an instance Using Oracle7 Server for Windows NT 3 11 Delete an
40. environment variable to equal the SID For example SET ORACLE_SID ABC If you will use this instance often you can set the ORACLE_SID key to equal the SID in the Windows NT Registry To do this start the Registry s editor choose Software and Oracle Start Server Manager from the command line and connect to the database as follows SVRMGR gt CONNECT INTERNAL PASSWORD Attention If you receive the errors DBA 00314 or ORA 09352 iS the Oracle SID environment variable is not set to the instance s SID See Step 2 above Start an Oracle7 instance without mounting a database If the initialization parameter file you are using is not named INITsid ORA or is not located in the ORANT DATABASE directory of the computer executing Server Manager use the PFILE option with the STARTUP statement SVRMGR gt STARTUP NOMOUNT PFILE path filename If you created a SQL script file earlier execute the CREATE DATABASE statement stored in that script file by typing SVRMGR gt path filename where filename is the name of the file containing the SQL statement If you did not create a SQL script for the CREATE DATABASE statement enter the statement directly at the SVRMGR prompt Oracle7 Server for Windows NT automatically creates the redo log file s and database file s that you specify in the CREATE DATABASE statement It also creates the control files listed in the CONTROL FILES initialization parameter
41. error obtaining process id E 6 sksaalo error allocating memory for archival E 7 sksabln unable to build file name E 7 sksachk invalid device specification for LOG_ARCHIVE_DEST E 7 sksasmo unable to send message to console E 7 SleepEx failure unable to Sleep E 12 slgfn error fabricating file name E 6 slgtd unable to obtain the current date and time E 8 slkhst error hosting out to operating system E 8 sllfcf error closing file E 7 sllfop error opening file E 7 sllfrb error reading records E 7 sllfsk error skipping records E 7 slpdtb unable to convert packed decimal to binary E 8 slsleep error temporarily suspending process E 8 slspool error spooling file to printer E 8 slsprom error prompting user E 8 sltIn error translating logical name E 8 slzdtb unable to convert zoned decimal to binary E 8 smestk error switching stacks E 6 SMON D 4 smpalo error allocating PGA memory E 6 smprset error setting memory protections E 6 smsalo error allocating SGA memory E 6 smscre error creating SGA E 6 smsdes error destroying the SGA E 6 smsget error attaching to SGA E 6 SNAPSHOT_REFRESH_INTER VAL initialization parameter 5 6 SNAPSHOT_REFRESH_KEEP_CONNECTIO NS initialization parameter 5 6 SNAPSHOT_REFRESH_PROCESSES initialization parameter 5 6 SNPO D 4 SNP9 D 4 Software networking 1
42. file associated with this connection request Check the log file for the operating system specific error code Contact your Oracle Customer Support representative NETTCP setup failure The host s SQL Net TCP IP server was unable to set up the appropriate environment to service this connection request Check the log file for the operating system specific error code Contact your Oracle Customer Support representative Messages and Codes E 21 ORA 06123 Cause Action ORA 06124 Cause Action ORA 06125 Cause Action ORA 06126 Cause Action ORA 06127 Cause Action E 22 NETTCP cannot set KEEPALIVE The host s SOL Net TCP IP server was unable to set the socket KEEPALIVE option Check the log file for the operating system specific error code Contact your Oracle Customer Support representative NETTCP timeout waiting for ORASRV The Oracle7 Server for Windows NT process was started but failed to respond after a period of time n seconds This failure can occur on heavily loaded systems Increase the value of n the default is 30 by adding the following entry in the initialization parameter file SQLNET ORASRV_WAIT number NETTCP ORASRV exited unexpectedly The Oracle7 Server for Windows NT process was started but exited unexpectedly Two possible causes 1 There were insufficient quotas to run ORASRV on the Oracle7 Server for Windows NT 2 Oracle7 is no
43. for loading data from existing data files into your Oracle7 Server for Windows NT database Export writes data from the Oracle7 Server for Windows NT to an operating system file Use Export for data archiving and moving data to other Oracle databases See Chapter 4 of this Guide and Oracle7 Server Utilities for instructions Import reads data from export files into Oracle7 Server for Windows NT 1 8 Oracle7 Server Getting Started for Windows NT SOL Net SOL Net is the network interface that enables client workstations to communicate with the Oracle7 Server for Windows NT The SQL Net suite of products for Oracle7 Server for Windows NT include the following SQL Net V2 3 e TCP IP Adapter V2 3 e Named Pipes Adapter V2 3 e SPX Adapter V2 3 e Oracle Names V1 1 use with SQL Net V2 SQL Plus SQL Plus for Windows NT is a command language interface enabling you to use the SQL and PL SQL database languages in the Windows NT environment Secure Network Services Secure Network Services enable you to protect your database from unauthorized access Required Support Files The Oracle7 Server for Windows NT and the client utilities require various support files The necessary files are installed automatically based on the components you choose to install Additional Information See PL SQL User s Guide and Reference B for more information about using the features of PL SQL PL SQL User s Guide Additional Information F
44. host s SQL Net TCP IP server did not have READ EXECUTE permissions for the SID mapping file associated with this connection request Change the protection on the SID mapping file NETTCP connection rejected server is stopping The host s SQL Net TCP IP server rejected this connection request because the server is in the process of stopping Restart SOL Net TCP IP server NETTCP error during connection handshake A network I O failure occurred while communicating with the host s SQL Net TCP IP server Check the log file for the operating system specific error code Contact your Oracle Customer Support representative NETTCP error during connection handshake A network I O failure occurred while communicating with the host s SQL Net TCP IP server Check the log file for the operating system specific error code Contact your Oracle Customer Support representative NETTCP error during connection handshake A network I O failure occurred while communicating with the host s SQL Net TCP IP server Check the log file for the operating system specific error code Contact your Oracle Customer Support representative NETTCP no such user A Proxy login connect attempt failed because the client username is not defined on the host Contact your network administrator Oracle7 Server Getting Started for Windows NT ORA 06141 Cause Action ORA 06142 Cause Action ORA 06143 Cause Action
45. incorrect An attempt was made to connect as internal with an invalid password Verify that the password is correct and try again no password given An attempt was made to connect as internal without a password Enter a valid password when connecting as internal no password found Oracle was unable to locate and retrieve the password for internal Verify that Oracle is installed and configured correctly operating system roles are not supported An attempt was made to use an operating system role Only use roles that were created IDENTIFIED BY password as opposed to IDENTIFIED EXTERNALLY unable to get date and time from the operating system There was an unexpected return from GetLocalTime call Verify that the system time is correct on the computer unable to translate the USERNAME configuration variable on server The USERNAME configuration parameter variable on the host is not properly set Verify the USERNAME variable is set REMOTE_OS_AUTHENT variable not set to TRUE For remote operating system logins to function the 7REMOTE_OS_AUTHENT parameter must be set to TRUE Shut down and start up the instance with REMOTE_OS_AUTHENT TRUE in the initialization parameter file Oracle7 Server Getting Started for Windows NT OSD 04514 Cause Action ORA 06102 Cause Action ORA 06105 Cause Action ORA 06106 Cause Action ORA 06107 Cause
46. large or too small Specify the correct file size or delete the existing file unable to read line from file This error is caused by an operating system error or by damaged media Check the operating system error code if available and consult the Windows NT documentation If no operating system error code is presented verify that the media is not damaged unable to close file The media has been damaged Recover the file if necessary and verify that Windows NT is functioning correctly asynchronous I O request returned an error There was an unexpected return from the Windows NT system service Check the operating system error code and consult the Windows NT documentation error queuing an asynchronous I O request There was an unexpected return from the Windows NT system service Check the operating system error code and consult the Windows NT documentation Messages and Codes E 11 E 12 OSD 04017 Cause Action OSD 04018 Cause Action OSD 04019 Cause Action OSD 04020 Cause Action OSD 04023 Cause Action OSD 04100 Cause Action OSD 04101 Cause Action unable to open the specified RAW device An invalid path or filename was specified or the device is full Make sure the file exists and or device is not full verify that the operating system is functioning correctly unable to access the specified directory or device An invalid path name was specified Make sure the directory o
47. logged on to the server machine This feature allows you to maintain workstation security while running Oracle7 Server for Windows NT A database administrator can start a particular instance of the database and log off the machine Windows NT Services Naming Conventions For each instance created Oracle defines an Oracle service the Windows NT service related to the database executable This Oracle database service is named OracleServicesid where sid is the instance name The instance name is the same as the value of the ORACLE_SID configuration parameter and can be any alphanumeric combination of 1 to 4 characters In addition for each network listener defined during network installation Oracle creates a SQL Net listener service another Windows NT service related to the network listener This service is named OracleTNSListenerid where id is the name or abbreviated ID associated with the network listener Additional Information Use the SQL Net Easy Configuration E Utility to configure simpler networks Use Network Manager to Network configure more complex networks Oracle Network Manager for Manager Windows Installation and User s Guide includes information on configuring more complex networks Oracle7 Server for Windows NT provides extra security features Earlier releases allowed remote database access with the Server Manager 1 6 Oracle7 Server Getting Started for Windows NT CONNECT INTERNAL command With Release 7
48. of Instance Manager to start the database Please note that the command file contains the password to the INTERNAL account If you change the INTERNAL password later be sure to change the password in the command file also 9 Choose OK to complete instance creation Note After creating the instance database a dialog box appears giving you the option to run two scripts catalog sql to create the Oracle7 Server for Windows NT data dictionary Using Oracle7 Server for Windows NT 3 7 views and catproc sql if you will be using PL SQL If you choose Yes Instance Manager spawns Server Manager and runs these scripts in the background i gt Attention For information on the GUI version 32 bit Instance Manager see the following section For information on the command line version of Instance Manager see the appendix Using the Instance Manager from the Command Line in this Guide Changing Passwords You can use Instance Manager to change Instance passwords Follow these steps to change passwords 1 Select in the Instance Manager main window the instance for which you want to change the password 3 8 Oracle7 Server Getting Started for Windows NT Advanced Parameters From the New Instance dialog box choose Advanced The Advanced Parameters dialog box appears d orant database log1 ORCL ora size 2 32 d orant database sysORCL ora size 10M Instance Manager enables you to cust
49. the symmetric replication facility and deferred transactions Information in this manual applies to users of the Distributed Option only Information on the symmetric replication facility applies to users of the Advanced Replication Option only Oracle7 Parallel Server Concepts and Administration Describes parallel processing and parallel database technologies and how to use them to make the most of their capabilities This manual prepares administrators to successfully implement parallel processing by providing a thorough presentation of the concepts and procedures involved Programmer s Guide to the Oracle7 Server Call Interface Provides a sound basis for developing applications using the OCI It includes e the structure of an OCI application e conversion of data between the server and variables in your OCI application e reference sections that describe OCI calls in detail e sample programs that illustrate the features of the OCI Programmer s Guide to the Oracle Precompilers Comprehensive user s guide and on the job reference to the Oracle Pro COBOL and Pro FORTRAN Precompilers It shows you step by step how to develop applications that use the powerful database language SQL to access and manipulate Oracle data It explores a full range of topics from underlying concepts to advanced programming techniques and uses clear hands on examples to teach you all you need to know Documentation Roadmap A 9 Progra
50. they must be preceded by an underscore For example a database instance of ORCL would have the following names if the role was identified by USERS e ORA_ORCL_USERS e ORA_ORCL_USERS_D e ORA_ORCL_USERS_A e ORA_ORCL_USERS_DA In the following example the Groups user are e ORA_ORCL_VIEWUSERS created using CREATE ROLE e ORA_ORCL_UPDATEUSERS_A created using CREATE ROLE e ORA_ORCL_CONNECT_DA predefined ROLE active even if OS ROLES is false Getting the Most out of Integration with Windows NT 4 9 4 10 e ORA_ORCL_RESOURCE_D predefined ROLE active even if OS ROLES is false In this example when a database user connects to the Oracle7 Server using an automatic authenticated account whose user id is also included in the above NT Groups ORA_ORCL_CONNECT_DA and ORA_ORCL_RESOURCE_D are the default roles ORA_ORCL_UPDATEUSERS_A and ORA_ORCL_VIEWUSERS are available for use by the user through the SET ROLE command Additionally users can grant ORA_ORCL_UPDATEUSER_A and ORA_ORCL_CONNECT_DA to other roles Note All privileges for these roles are active when the user connects When using operating system roles all roles are granted and managed through the operating system You cannot use both operating system roles and Oracle roles at the same time When OS_ROLES is set to TRUE in the INITsid ORA file it is important to understand how roles and the privileges granted to these roles are obtained by Oracle users
51. to and from database files The Oracle7 Server utilities are available for many different operating systems and hardware platforms the utilities operate in essentially the same way for all platforms This section describes only those functions of the Oracle7 Utilities that apply to the Windows NT operating system these utilities are the Windows NT 32 bit versions For general information on the Oracle7 utilities refer to Oracle7 Server Utilities Note The Oracle7 utilities for Windows NT use the same messages and codes as the Oracle utilities on other platforms For further information on Oracle utility error messages refer to the Oracle7 Server Messages Note Import Export and SQL Loader are also available in a 16 bit GUI based version included with the Windows database tool set Using Export and Import Export Export and Import utilities can run as operating system command line tools in Windows NT Their 16 bit counterparts can run when you choose their respective icons from the Windows Program Manager or Windows 95 Explorer Use the Export utility to export your database tables and other objects to disk when archiving them or prior to migrating data between hardware platforms To start Export type Using Oracle7 Server for Windows NT 3 21 Import C gt EXP73 options Use the Import utility to import database tables and other objects that you exported using the Export utility To start Import type C
52. to databases anywhere else on the network by short mnemonic names Additional Information A complete description of this aa product and its configuration appears in the Oracle Names Names Administrator s Guide 1 12 Oracle7 Server Getting Started for Windows NT CHAPTER Installing Oracle7 Server for Windows NT T his chapter covers the following installation topics is system requirements server Windows on Win32 WOW before you install co existence of Oracle7 Server for Windows NT and Oracle7 Workgroup Server installation types using Oracle Installer server client installations Windows client installations configuring SQL Net separately installing Oracle7 Options removing Oracle7 products migrating from earlier releases Attention The instructions in this chapter cover installation of Oracle7 Server for Windows NT from a CD ROM only Installing Oracle7 Server for Windows NT 2 1 A Note on Directories This Guide assumes that all directory names are the default names created during the Oracle7 Server for Windows NT installation process For example the Oracle home directory for Windows NT products is assumed to be ORANT If your system is set up using different directory names substitute these names for the default names found in this Guide System Requirements Server Attention To install Oracle7 Server for Windows NT you is must log on to the server machine as a member of the 8 Windows NT Ad
53. usernames The data dictionary SYSTEM tablespace contains tables and views commonly used by many Oracle tools and sample programs 3 2 Oracle7 Server Getting Started for Windows NT Note The starter database is installed to operate in NOARCHIVELOG mode If you wish to archive redo log files see Setting the Archivelog Mode and Recovering the Database later in this Guide Additional Information You can protect your database from a B disk drive malfunction by keeping on separate physical drives Admin multiple control files for each database and setting the Guide CONTROL FILES initialization parameter to list each control file See Oracle7 Server Administrator s Guide for information on setting this initialization parameter value Starter Database The four tablespaces in the Oracle7 Server for Windows NT starter Tablespace Structure database hold various types of data as follows SYSTEM tablespace contents of the data dictionary including definitions of tables views and stored procedures needed by the RDBMS Information in this area is maintained automatically Your application data goes in the USER_DATA tablespace USER_DATA empty when the server is initially installed As tablespace you create tables and enter data into them you fill this space with your data When you add users to the system using the User Manager tool described later in this chapter the default tablespace of the users is automatically set to USER_
54. variable C gt represents the Windows NT command prompt of the current hard disk drive Your prompt may differ and may at times reflect the subdirectory in which you are working A backslash before a directory name indicates that the directory is a subdirectory SID system identifier represents the unique name of an Oracle instance The SID you assign to a particular instance becomes the value of the ORACLE _SID initialization parameter for the associated database Special icons are provided to alert you to particular information in this Guide i gt Attention Calls your attention to important information and suggestions Preface vii Reader Comments Additional Information Highlights text referring you to other louce parts of the other Oracle documentation A Warning Highlights text that warns you of actions that could be particularly damaging or fatal to your operations We value and appreciate your comments as an Oracle user and reader of our manuals As we write revise and evaluate our documentation your opinions are the most important input we receive At the back of this Guide is a Reader s Comment Form We encourage you to use it to tell us what you like and dislike about this or other Oracle manuals If the form is missing or if you would like to contact us write us at the following address Desktop Documentation Manager Workgroup Solutions Division Oracle Corporation 500 Oracle Parkway
55. was encountered in sending data Check all LAN connections and cables If any connections are loose secure them and retry Otherwise reboot the machine and reload the SQL Net Named Pipes driver If the error persists contact your DBA NETNMP Error resetting connection The system encountered an error when resetting the connection Check all LAN connections and cables If any connections are loose secure them and retry Otherwise reboot the machine and reload the SQL Net Named Pipes driver If the error persists contact your DBA NETNMP Unable to open named pipe Your workstation is not logged on to a valid account or you do not have appropriate privileges to create a pipe Log onto a valid account do not use the default guest account Alternatively ask your DBA assign appropriate privileges for creating a pipe to your account NETNMP Windows NT failed to create or access shared memory Unable to open shared memory segment containing the connection status of Oracle Server Ensure that Oracle Server has been properly started so that the shared memory segment is available NETNMP SQL Net handshake error An error occurred during the SQL Net handshake Ensure pipe has been created successfully Check SQL Net versions on your Server machine and reinstall matching versions if different NETNMP Unable to put pipe into listening mode Named pipe was not properly created Restart Oracle7 Server for Windows NT and attempt th
56. whose IDs are not defined externally For example if an authenticated connection exists between a client s workstation and a Windows NT machine running Oracle7 and the user connects over SOL Net V2 with the Oracle username scott tiger the roles applied to the Oracle username SCOTT consist of all roles defined for the Windows NT user NTUSER All roles available under an authenticated connection are determined by the Windows NT user id and the groups available to the user Administration group e CONNECT as sysdba e CONNECT as sysoper e CONNECT INTERNAL Database administrators who use CONNECT INTERNAL from a client workstation may belong to the ORA_OPER ORA_DBA ORA_ SID _DBA or ORA_ SID_OPER groups The SYSDBA and SYSOPER roles are mapped s follows SYSDBA gt ORA_ SID _DBA ORA_DBA SYSOPER gt ORA_ SID _OPER ORA_OPER For example If an authenticated connection exists between a client workstation and a Windows NT machine running Oracle7 with the authenticated Oracle7 Server Getting Started for Windows NT username being NTUSER2 then the following takes place when the user issues the command SVRMGR gt connect as sysdba Oracle will search for the username NTUSER2 in group ORA_ORCL_DBA If found the user will be given DBA privileges If not found Oracle will check the global group ORA_DBA Getting the Most out of Integration with Windows NT 4 11 4 12 Oracle7 Server Getting Started for Windows NT CHA
57. 2 6 Oracle7 Client 0 0 00 ccc ete ene nent 2 6 Contents ix Chapter 3 Oracle Serven mars okt ora 8 Woes E N a ore E E E 2 7 Programmer 2000 623 046 seth wien oo bee eed eee oes 2 7 SOL PIS 3 tit ah tea ok etd T E Romar 2 7 Selective narri ea ee PP AE E 2 8 Options Windows NT Server suasasasrnrnssuo 2 9 Using Oracle Installer 0 06 2 9 Windows NT Installations 0 0 00 cece eee eee 2 9 Installation Types Windows Windows 95 Clients 2 16 Oracle Cent sse srec erais pee eee ee eae se eeu ai 2 16 Oracle Documentation 0 6606 c cece ees 2 17 DElECH VC as ye tare crete ea dame et MRR A od 2 17 Client System Requirements 6 6600 c ee eaee 2 18 Configuring SQL Net 6 eee eee 2 22 IE A PAA EE I REEE Tat Rac E ER ps 2 22 Separately Installing Oracle7 Options 2 23 Removing Oracle7 Products Options 000 0005 2 23 Migrating from Earlier Releases 0 000 c eee eee 2 24 OVERVIEW cic chika yea ke a e BEE deed beeen a a E EE on ede ee 2 24 Prepare for the Migration 006 cece 2 24 Install the Oracle7 Server 0 cece eee eee eee 2 26 Move Database Files 00 ccc nn ee 2 27 Using Oracle7 Server for Windows NT 0006 3 1 Overview of Database Administration Tasks 3 2 What is an Instance cece eee eee 3 2 The Starter Database 0 o cece eee 3 2 Oracl
58. 3 LGWR D 4 Licensing of Oracle7 Server 2 23 Listener service defined 1 2 Listener process maximum number allowed D 7 spawning additional processes D 8 Listener threads maximum number allowed D 7 maximum number created D 8 minimum number D 8 number prespawned D 8 LISTENER ORA file contents of 2 22 local area network LAN 1 3 Local connection to an instance 1 7 LOCAL parameter D 7 LOCKING_VIOLATION E 3 LOG_ARCHIVE BUFFERS parameter C 4 LOG_ARCHIVE_BUFFER_SIZE parameter C 4 LOG_ARCHIVE_DEST parameter C 4 LOG_ARCHIVE_FORMAT parameter C 4 LOG_CHECKPOINT_INTER VAL parameter C 4 LOG_FILES parameter C 4 LOG_SMALL_ENTRY_MAX_SIZE parameter C 4 Index 5 LOG1ORCL ORA 3 4 3 16 LOG2ORCL ORA 3 4 3 16 LOGFILE parameter 3 10 5 5 Logging error messages 5 5 logical block size mismatch E 9 Loopback 2 4 M malloc failure unable to allocate memory E 12 MANAGER password 3 4 MAXDATAFILES parameter 3 10 Maximum number of Oracle threads reached E 15 MAXINSTANCES parameter 3 10 MAXLOGFILES parameter 3 10 MAXLOGHISTORY parameter 3 10 MAXLOGMEMBERS parameter 3 10 Memory structures 1 7 Messages E 1 E 35 Installer E 2 E 4 NETCMN E 28 E 32 Oracle7 Server utility 3 21 SQL Net V1 Named Pipes E 25 E 28 SQL Net V1 TCP IP E 19 E 26 Windows NT Database E
59. 5 E 12 Windows NT specific E 9 E 18 Microsoft Visual Basic 1 10 Microsoft Windows NT Server Version 3 51 2 3 Microsoft Windows NT Workstation Version 3 51 2 3 Migration 2 24 overview 2 24 preparing for 2 24 migration from previous versions 2 12 Monitoring of database with Server Manager 3 23 MTS_MAX SERVERS parameter C 4 MTS_MAX_DISPATCHERS parameter C 4 MTS_SERVERS parameter C 4 Multi processor machines 2 2 Index 6 Oracle7 Server Getting Started for Windows NT Multiple Instances 3 12 Multiple instances running 3 13 Multiple version installation 1 5 N Named Pipes 2 3 Named Pipes Adapter 1 9 National Language Support NLS 2 11 F 1 F 8 Native datatypes 3 23 NETCMN cannot allocate context area E 28 NETCMN connection not open E 30 NETCMN disconnect failure E 30 NETCMN error detected in the read in data E 31 NETCMN error in receiving data E 31 NETCMN error in sending data E 31 NETCMN error on test E 30 NETCMN error receiving break message E 28 NETCMN error sending break message E 29 NETCMN incompatible versions E 30 NETCMN incorrect message format E 29 NETCMN invalid driver designator E 28 NETCMN invalid login string E 28 NETCMN message receive failure E 29 NETCMN message send failure E 29 NETCMN reset protocol error E 28 NETCMN server cannot start oracl
60. 6 Oracle 7 Server installing 2 26 Oracle Book definition of 1 10 Oracle Database Tools 1 5 Oracle documentation 2 6 2 13 2 17 2 21 Oracle Home location 2 11 Oracle Installer using 2 9 2 11 Oracle MultiProtocol Interchange 1 11 Oracle Names 1 5 1 9 1 12 Oracle Objects for OLE 1 5 definition of 1 10 Oracle protocol adapter defined 1 2 Oracle service 1 6 Oracle thread unable to CreateEvent E 15 Oracle thread unable to DuplicateHandle E 15 Oracle tool defined 1 2 ORACLE_GROUP parameter D 4 ORACLE_HOME parameter D 4 ORACLE_PRIORITY D 4 ORACLE _ SID 1 6 ORACLE_PRIORITY parameter D 4 ORACLE _SID parameter D 5 Oracle7 client installation 2 6 2 16 Oracle7 database defined 1 2 Oracle7 RDBMS 1 11 defined 1 2 Oracle7 Server defined 1 2 feature highlights 1 3 installation 2 7 2 14 licensing 2 23 Oracle7 Server for Windows NT coexistence with Workgroup Server 2 5 defined 1 3 Program Group 3 6 running with previous versions 2 5 Oracle7 Server utilities 3 21 3 28 Export 3 15 3 21 Import 3 19 3 21 messages and codes 3 21 SQL Loader 3 22 Oracle7 Server Clients installation 2 13 Oracle7 utilities 2 3 OracleServiceORCL 3 5 OracleStartORCL 3 5 OracleTNSListener 3 5 OracleTNSListenerid 1 6 ORADIM creating an instance 3 13 ORADI
61. 7 3 instance without creating a new database using the command line version of Instance Manager If you need more information on using the command line version of Instance Manager see Using Instance Manager for the Command Line A Warning If you use the GUI version of the Instance Manager a new database is automatically created a From the command line enter oradim73 new sid lt sidname gt intpwd lt pwd gt maxusers lt users gt This creates the following OracleService lt sidname gt service OracleNMPListener lt sidname gt service only if SQL Net V1 Named Pipes i e nmp1lsnr exe protocol is installed password file pwd lt sidname gt ora in ORACLE_HOME DATABASE b From the command line enter oradim73 startup sid lt sidname gt usrpwd lt pwd gt starttype Srvc Note This will start the services only Move Database Files 1 Move files Move all 7 0 7 1 7 2 database files to the Release 7 3 directory Note If you have your own database file structure go to the Merge and Edit the Initialization Files step a Move ALL current control data and log files from the SORACLE_HOME rdbms70 or 71 to the SORACLE_HOME database directory Installing Oracle7 Server for WindowsNT 2 27 Using the above example and if the current control file is in directory c orant rdbms71 Move To e orant rdbms71 ctllorcl ora c orant database ctllabcd ora b Move all o
62. 8 Server Manager 1 10 3 12 definition of 1 8 for database monitoring 3 23 Index 10 Oracle7 Server Getting Started for Windows NT starting 3 11 using 3 12 Server Software Export 1 8 Oracle7 Server for Windows NT 1 8 PL SQL 1 8 Required Support Files 1 9 SQL DBA 1 8 SQL Loader 1 8 SQL Net 1 9 Server Utilities 1 3 Service defined 3 2 Services defined 1 6 session terminated internally by Oracle or by an Oracle DBA E 8 SET ORACLE_SID ABC 3 18 SET PARAMETER_NAME PARAMETER_VA LUE D 2 SetFilePointer failure unable to read from file E 10 sfecf error creating file E 5 sfcopy error copying file E 5 sfdone I O error detected E 6 sfifi error identifying file E 5 sfofi error opening file E 5 sfotf error opening temporary file E 5 sfqio error detected in I O completion routine E 6 sfqio error reading or writing to disk E 5 sfrfb error reading from file E 5 sfsfs failed to resize file E 6 sfsmap unable to map SGA E 6 sfsrd error reading from file E 5 sftcls error closing file E 5 sftget error reading from file E 5 sftopn error opening file E 5 sfwfb error writing to file E 5 sfwfbmt error writing to file E 6 shared memory SGA mapped to wrong address E 13 SHARED_POOL_SIZE parameter C 5 SHARING_VIOLATION E 4 SHUTDOWN command 3 16 SID 3 2 3 7 sigpidu
63. 8NAFITHA711 R8NAFITHA711T R8NAFITHA721 R8SNAFITHA721T R8SAKHR706 R8SAKHR707 R8SAKHR707T R8SXBASIC N DN8PC863 CH7DEC CL8BS2000 CL8EBCDIC1025 CL8EBCDIC1025X CL8ISO8859P5 CL8MACCYRILLIC CL8MACCYRILLICS CL8MSWIN1251 D7DEC D7SIEMENS9780X D8BS2000 D SEBCDIC273 DK7SIEMENS9780X DK8BS2000 DK8EBCDIC277 E7DEC E7SIEMENS9780X E8BS2000 E E E E E E E E E E E E E E E E E E E8EBCDIC870 E8ISO8859P2 E8MACCE E8MACCES E8MACCROATIAN E8MACCROATIANS E8MSWIN1250 E8PC852 EC8EUROPA3 L8DEC L8EBCDIC875 L8GCOS7 L8ISO8859P7 L8MACGREEK L8MACGREEKS L8MSWIN1253 L8PC437S L8PC737 ET8MSWIN923 F7DEC F7SIEMENS9780X F8BS2000 F8EBCDIC297 HU8ABMOD HU8CWI2 I7DEC I7SIEMENS9780X I8EBCDIC280 IS8MACICELANDIC IS8MACICELANDICS IS8PC861 IW7I1S960 IW8EBCDIC1086 IW8EBCDIC424 W8ISO8859P8 W8MSWIN1255 W8PC1507 LA8PASSPORT LT8MSWIN921 LT8PC772 LT8PC774 N7SIEMENS9780X N8PC865 NDK7DEC NES8ISO8859P10 NEE8ISO8859P4 NL7DEC RU8BESTA RU8PC855 RU8PC866 S7DEC S7SIEMENS9780X S8EBCDIC278 SE8ISO8859P3 SF7ASCII SF7DEC TH8MACTHAI TH8MACTHAIS THS8TISASCII TH8TISEBCDIC TR7DEC TR8DEC TR8ISO8859P9 TR8MACTURKISH TR8MACTURKISHS TR8PC857 US7ASCII US7ASCII US8BS2000 US8ICL US8PC437 WE8BS2000 WES8BS2000L5 WES8DEC WE8DG DIC284 DIC285 DIC37 BCDIC37C BCDIC500 BCDIC500C BCDIC871 GCOS7 HP ICL SO8859P1 SO8859P9 SOICLUK E8MACROMANS8 E8MACROMANS8S E8NCR4970 E8NEXTSTEP E8PC850 E8PC860
64. Action ORA 06108 Cause Action ORA 06109 The NT Group name is too long for internal buffer The NT Group name is too long Use a shorter NT group name Codes 6100 6199 SOL Net TCP IP Errors The messages in this section apply only if you are using SQL Net V1 For messages relating to use of SQL Net V2 see Oracle Network Products Messages Manual NETTCP cannot allocate context area The dynamic memory available for the connection context area is insufficient Contact your Oracle Customer Support representative NETTCP remote host is unknown The host name specified in the login connect string is unknown Verify the spelling of the host name Make sure the name exists in the TCP IP HOST file and try again NETTCP socket creation failure The process open file quota was probably exceeded Contact your Oracle Customer Support representative NETTCP ORACLE network server not found The entry for Oracle7 Server for Windows NT in the SERVICES file is missing Add orasrv to the TCP IP SERVICES file NETTCP connect to host failed The attempt to connect to a remote host has failed The SQL Net TCP IP server on the remote host is not up or the host itself is not up Check the latter possibility by targeting it with Telnet Start the SQL Net TCP IP server process on the remote host NETTCP message receive failure Messages and Codes E 19 E 20 Cause Action ORA 06110 Cause Action
65. After entering the CREATE DATABASE statement you should run the SQL script CATALOG SQL to create the Oracle7 Server for Windows NT data dictionary views and the script CATPROC SQL if you will be using PL SQL Oracle7 Server Getting Started for Windows NT You should also run any other SQL scripts at this time All SQL scripts for Oracle7 Server for Windows NT are stored in ORANT RDBMSnn ADMIN ISF Attention See Advanced Replication Option if you will be creating a database for Advanced Replication at this time Additional Information Oracle Admin Guide Oracle Utilities Using Oracle7 Server for Windows NT 3 19 Creating Database Objects Once you have created new database files as described in Chapter 3 of this Guide you can create new database objects including e tables e clusters e indexes e views e roles Additional Information See Oracle7 Server Administrator s B Guide for guidelines on creating database objects In particular Admin see the section that provides equations for estimating the space Guide requirements for clusters nonclustered tables and indexes Windows NT uses the same fixed header transaction header and row header constants described in that chapter When creating database objects such as tables clusters and indexes specify a STORAGE clause to define the way in which the object size increases over time Additional Information The individual parameters of the Le STORAGE
66. BLOCK_READ_ COUNT parameter C 4 DB_FILE_SIMULTANEOUS WRITES parameter C 4 DB_FILES parameter C 4 DB_NAME C 3 DBA Authorization Password 3 7 DBA 00314 3 5 3 18 DBA_AUTHORIZATION 4 5 DBLINK_ENCRYPT_LOGIN 4 6 DBWR D 4 Default language 2 11 Directories 2 2 ORANT B 1 ORANT DATABASE B 3 B 4 ORANT DBS B 3 ORANT NETWORK B 3 B 4 ORANT NETWORK ADMIN B 3 B 4 ORANT NETWORK LOG B 3 B 4 ORANT NETWORK TRACE B 3 B 4 ORANT ORAINST B 3 ORANT OWSI1O B 3 ORANT PLSQLnn B 3 ORANT RDBMSnn B 3 ORANT RDBMSnn ADMIN B 3 ORANT RDBMSnn LOADER B 3 ORANT RDBMSnn OCL B 3 ORANT RDBMSnn TRACE B 3 ORAWIN B 1 B 4 ORAWIN BIN B 4 ORAWIN DBS B 4 ORAWIN NETWORK B 4 ORAWIN ORAINST B 4 ORAWIN RDBMSnn B 4 ORAWIN O5 B 1 Directory Oracle home 2 2 Oracle7 Server database files 2 2 Disk space required 2 5 Index 3 DISK_FULL E 2 Distributed Option 1 3 2 9 DISTRIBUTED_TRANSACTIONS parameter C 4 Documentation online A 2 documentation Oracle 2 6 2 13 2 17 2 21 DOS 2 9 DosKillProcess failure unable to kill process E 14 DosSetPriority failure unable to set process priority E 14 DRIVE_LOCKED E 2 E Enterprise Manager 1 10 A 12 Error messages logging 5 5 E 2 error queuing an asynchronous I O request E 11 Even
67. Box 659107 Redwood Shores CA 94065 viii Oracle7 Server Getting Started for Windows NT Contents Chapter 1 Introducing Oracle7 Server for Windows NT 6 1 1 Special TOrms ip iiai asp atic Lar hoe ee Made EEE WHS Bole iene 12 Oracle7 Server for Windows NT Overview 005 1 3 Feature Highlights 0 cee cece ees 1 3 Features Specific to Windows NT 00000055 1 6 Oracle7 Server for Windows NT Product Contents 1 7 Server Windows NT 0 0 cece eee tenes 1 8 Client Software 2 0 0 0 ccc cece enn ene 1 9 Oracle Networking Software 666 c cece 1 11 Chapter 2 Installing Oracle7 Server for Windows NT 006 2 1 A Note on Directories 0 00 0 000 eens 2 2 System Requirements Server 6 6 e cece 2 2 Oracle7 Server for Windows NT Hardware 2 2 Advanced Replication Option Hardware 2 2 Software uunai Ie ates anda Das bape Mec oa te RA abet Mea ved ate 2 3 Windows on Win32 WOW 0 eee eee eee eee 2 4 Before You Install saissetiae a a e 2 5 First Time Installation on 0 ccc cee teens 2 5 Re installation of Oracle7 Server for Windows NT 2 5 Co existence of Oracle7 Server for Windows NT and Oracle7 Workgroup Server 0 2 5 Installation Types Windows NT 60 000 e eee eee 2 6 Networking Products 00 00 c cece nee e es 2 6 Oracle Documentation 0 0 ccc cece een ee
68. CE Logging Error Messages You can keep a log of the error messages you receive from the Oracle7 Utilities by redirecting them to a file You can record the contents of normal utility messages by using the LOGFILE parameter discussed in the Oracle7 Server Utilities You can separately record the error message portion by using standard Windows NT file redirection For example Database Administration 5 5 you might use the following syntax to redirect the output from the EXP73 utility C gt EXP73 username password PARFILE filename 1 gt FILE1 LOG 2 gt FILE2 ERR In this command line FILE1 LOG receives the standard output from EXP while FILE2 ERR receives the standard error Refreshing Table Snapshots 5 6 Oracle7 Server for Windows NT allows you to create copies of a remote database table These copies referred to as table snapshots can reside on multiple nodes of a distributed database Snapshots allow users to query remote tables on a local Oracle7 Server thereby reducing network traffic The information in a table snapshot is periodically updated or refreshed to reflect the most recent information in the original table from which it was created Additional Information See Managing Table Snapshots in za Oracle7 Server Administrator s Guide for information on creating Admin and managing table snapshots Guide Oracle7 Server for Windows NT also creates one or more background threads called
69. Click the Install button The Oracle7 Client Option dialog box appears displaying the types of user you may install If you choose Database Administrator the Database Administrator dialog box appears if you choose Application User the Application User dialog box appears c Choose the products you want to install Oracle7 Server Getting Started for Windows NT 2 Click OK to begin the installation The SQL Net Protocol Adapters dialog box appears Choose the SQL Net Protocol Adapters you want to install then click OK An Oracle dialog box appears displaying the progress of the installation When the installation is complete a notification dialog box appears prompting you to read the Release Notes for the latest information Click OK to dismiss the notification The Software Asset Manager window reappears Exit Oracle Installer by clicking on the Exit button and confirm your exit when prompted If you choose Oracle Documentation a Select Oracle Documentation in the Software Asset Manager to install Oracle Documentation Click the Install button The Oracle Documentation dialog box appears Choose CD ROM or Hard Drive installation Click OK Oracle Installer installs the selected products After the product s are installed you will be prompted to read the Release Notes for the latest information Click OK to dismiss the notification The Software Asset Manager window reappears Exit Oracle Installer by cli
70. DATA TEMPORARY_DATA used for rolling back transactions that fail to tablespace complete normally You may need to expand this tablespace if you have long running or high data volume transactions Using Oracle7 Server for Windows NT 3 3 Starter Database Files The starter database contains the following database files SYS1ORCL ORA database files of the SYSTEM USER_DATA USR1IORCL ORA TEMPORARY_DATA and ROLLBACK_DATA RBS1ORCL ORA tablespaces TMP10RCL ORA INITORCL ORA LOGIORCL ORA redo log files for the database LOG2ORCL ORA CTLIORCL ORA the database control file containing the database name the names and locations of the data files and redo log files and the time stamp of database creation This file is required to start and run a database system Server Alert Files An alert file contains important information about error messages and exceptions that can arise during database operation The alert file is the first place you should check if something goes wrong with the database and the cause is not immediately obvious Information is appended to the file each time the database is started For example if automatic archiving of redo logs halts because no disk space is available Oracle7 Server for Windows NT automatically places a message in the alert file The Oracle7 Server for Windows NT alert file is named sidALRT LOG and is located in the ORANT RDBMS73 TRACE directory User Accounts Three user accou
71. FILE EXCLUSIVE Oracle7 looks in the Windows NT Registry for the value of the ORA_sid_PWFILE parameter If not found it looks in the Registry for the value of the ORA_PWFILE parameter which points to a file containing the INTERNAL password as well as user names passwords and privileges Based on the value of the parameter Getting the Most out of Integration with Windows NT 4 5 found the user is granted or denied privileged access to the database e REMOTE_LOGIN_PASSWORDFILE SHARED The SHARED value of this parameter affords backward compatibility with earlier releases of Oracle7 Oracle7 looks for the same files as it does when the value is EXCLUSIVE but only the INTERNAL account is available for privileged access Users will not be able to log in with SYSOPER or SYSDBA privileges even if those privileges are granted in the password file e REMOTE_LOGIN_PASSWORDFILE NONE If the value of this parameter is NONE either one of the first two security conditions above is true or no users are granted access to the database Additional Information See Initialization Parameter Files in this Guide for details on Windows NT initialization parameters Database Password Encryption 4 6 With this release of Oracle7 Server for Windows NT you can require that the password used to verify a remote connection that is a connection over SQL Net always be encrypted You do this in two steps e Set the DBLINK_ENCRYPT_LOGIN initialization p
72. File I O Errors OSD 4000 to OSD 4099 OSD 04000 Cause Action OSD 04001 Cause Action OSD 04002 Cause Action logical block size mismatch The database block size specified in the initialization parameter file does not match the block size of the actual database files Use matching logical block sizes invalid logical block size The logical block size is not a multiple of 512 bytes or it is too large Change the value of DB_BLOCK_SIZE in the initialization parameter file unable to open file The specified path or filename is invalid or the destination device is full This error can also be caused by insufficient Windows NT file handles Make sure that the path and file exist and that the device has free space If this fails increase the number of Windows NT file handles Messages and Codes E 9 E 10 OSD 04003 Cause Action OSD 04004 Cause Action OSD 04005 Cause Action OSD 04006 Cause Action OSD 04007 Cause Action OSD 04008 Cause Action OSD 04009 Cause Action unable to read file header block The media has been damaged Recover the file if necessary and verify that Windows NT is functioning correctly invalid file header The file is corrupted Recover the file SetFilePointer failure unable to read from file There was an unexpected return from the Windows NT system service SetFilePointer Check the operating system error code and co
73. IBLOCK_READ_COUNT 4 DB_FILE_SIMULTANEOUS_WRITES 4 512 8192 254 cannot exceed DB_BLOCK_BUFFERS 0 TRANSACTIONS DISTRIBUTED_TRANSACTIONS 25 TRANSACTIONS LOG_ARCHIVE_BUFFER_SIZE 127 LOG_ARCHIVE_BUFFERS 4 LOG_ARCHIVE_DEST RDBMSnn 1 127 1 8 Any valid directory LOG_ARCHIVE_FORMAT ARC S T A valid filename format LOG_CHECKPOINT_INTERVAL 8000 LOG_FILES 255 LOG_SMALL_ENTRY_MAX_SIZE 800 MTS_MAX_DISPATCHERS unused 2 Unlimited 2 255 0 Unlimited unused MTS_MAX_SERVERS unused unused MTS_SERVERS unused unused NLS_LANGUAGE AMERICAN Any valid language Language dependent NLS_SORT Language dependent NLS_TERRITORY AMERICA C 4 Oracle7 Server Getting Started for Windows NT Any valid territory Parameter Name Default Value Range of Values OPEN_CURSORS 1 Unlimited OS_AUTHENT_PREFIX any character string REMOTE_LOGIN_PASSWORDFILE shared shared exclusive none SHARED_POOL_SIZE 6 500 000 300K Unlimited SORT_AREA_ SIZE 65536 0 limited Un 0 Un TEMPORARY_TABLE_LOCKS SESSIONS limited TRANSACTIONS_PER_ROLLBACK_SEGMENT 30 1 255 USER_DUMP_DEST RDBMSnn TRACE Any valid directory These are the default values for the Replication Database e global_name true e job_queue_processes 2 e job_queue_interval 10 e snapshot_refresh_processes 2 e shared_pool_size 10 000 000 Initialization Parameter Fi
74. L Plus Specifically it covers setup installation the SQL Plus for Windows menu interface and SQL Plus in the Microsoft Windows environment Oracle Server Manager for Windows User s Guide Explains how to install Oracle Server Manager for Windows Server Manager is Oracle s graphical database administration tool Oracle Network Products for Windows NT 95 Installation and User s Guide Operating system specific information about the architecture maintenance administration and installation of Oracle Network Products for Windows NT Pro C for Windows NT Installation and User s Guide Operating system specific information about the installation use and administration of Pro C and OCI for Windows NT Oracle Product Documentation Oracle product documentation consists of generic information fully describing a particular Oracle product for any hardware or operating system You received the product documentation for each product you licensed The Oracle7 Server documentation set is important for installing and administering your Oracle7 Server Following are descriptions of the Oracle7 Server documentation set Oracle7 Server Concepts Describes the features of Oracle7 Server a relational database management system RDBMS It is designed to help you understand how Oracle functions It lays a conceptual foundation for much of the practical information contained in other Oracle7 Server documentation Information in this m
75. M Log 3 26 ORADIM73 EXE B 2 ORAINST running 2 10 2 19 ORANT DATABASE directory 2 14 OS Authentication 4 7 OS_AUTHENT_PREFIX 4 7 OS_AUTHENT_PREFIX parameter C 5 OS_ERROR E 3 osncon local kernel only supported in standard mode E 7 osncon unable to connect DPMI not available E 7 P Packages 1 8 Parallel Query Option 2 9 Parameter CONTROL _ FILES 3 16 Password CHANGE_ON_INSTALL 3 4 changing 3 8 password MANAGER 3 4 Password files creating 4 7 password for internal is incorrect E 18 Pentium processor 2 2 Performance Monitor 1 5 PERMISSION_DENIED E 3 PFILE option of STARTUP statement 3 18 PL SQL features 1 8 PLSQL20 parameter D 6 PMON D 4 process 1 7 PROCESSES parameter C 5 Product components removing 2 23 Product contents 1 1 1 4 1 7 1 10 client software 1 7 1 10 networking software 1 8 1 11 server software 1 7 1 10 Product options for Windows B 4 Programmer 2000 installation 2 7 2 15 Protocol adapter Oracle 1 2 PWDsid ORA 4 7 R RAW files backing up 5 2 5 4 restoring 5 2 5 4 RBS1IORCL ORA 3 4 3 16 RDBMS 1 3 1 8 2 3 Oracle7 1 2 Oracle7 Server for Windows NT version 1 3 RDBMSnn parameter D 6 READ_ERROR E 4 ReadFile failure unable to read from file E 10 RECALIBRATION_FAILURE E 4 RECO D 4 record size too large E 16
76. O8859P EE8ISO8859P2 WESISO8859P SO8859P6 SO8859P SO8859P SO8859P6 SO8859P SO8859P SO8859P SO8859P SO8859P EL8ISO8859P7 IW8ISO8859P8 EE8ISO8859P2 EE8ISO8859P2 CL8ISO8859P5 6CGB231280 EE8ISO8859P2 WESISO8859P1 WES SO8859P1 THS8TISASCII ZHT32EUC WES SO8859P9 CL8ISO8859P5 F 3 Selecting Alternate Territories and Character Sets Although the languages have default territories and character sets associated with them any language territory and character set values can be mixed and included in a single NLS_LANG parameter Any NLS_LANG values however must correspond to a fully installed language Refer to the section Installing Additional Languages in this appendix for installation information Additional Information See Oracle7 Server Administrator s hs Guide for additional information about the NLS_LANG Admin parameter and its components Guide NLS Initialization Parameters National Language Support can also be set by database instance using several parameters in the initialization parameter file The NLS initialization parameters set NLS information specific to a database session or instance NLS_LANGUAGE and NLS_TERRITORY Any of the language and territory components listed in the previous table can be used as values for the NLS_LANGUAGE and NLS_TERRITORY parameters respectively Also any of the territory values in the section Parameter Lists in this
77. OG B 3 B 4 NETWORK TRACE B 3 B 4 NLSRTLnn in ORANT B 3 B 4 ORAINST B 4 in ORANT B 3 ORANT DATABASE 3 18 4 7 ORANT RDBMS73 LOADER 3 23 ORANT RDBMSnn ADMIN 3 19 OWS10 in ORANT B 3 PLSQLnn in ORANT B 3 PLUSnn B 4 PROnn in ORANT B 3 B 4 RDBMSnn B 4 in ORANT B 3 RDBMSnn ADMIN B 3 RDBMSnn LOADER B 3 RDBMSnn OCI B 3 RDBMSnn TRACE B 3 SVRMGRnn B 4 A Active files backing up 5 2 restoring 5 2 5 3 Administrators group 2 9 Advanced Replication Option 1 4 2 9 5 7 installation requirements 5 7 upgrading 5 7 Alert files 3 4 5 5 5 7 Aliases server D 10 APIs application programmatic interfaces 1 11 applications VBA enabled 1 10 ARCH D 4 ARCHIVELOG mode 5 2 ARGUMENTS data dictionary table 5 10 asynchronous I O request returned an error E 11 Authorization Password DBA 3 7 Index 1 B BACKGROUND_DUMP_DEST initialization parameter 5 5 C 4 Backing up a database 5 2 active files 5 2 RAW files 5 4 Backup Manager 5 2 Bad function code supplied to ssthreadop E 15 block row file 5 11 BUFFER parameter of EXP utility 3 16 of IMP utility 3 19 C C gt EXP73 options 3 22 C gt IMP73 options 3 22 C gt SET ORACLE_SID sid 3 12 C gt SQLLDR73 options 3 22 C gt EXP73 options 3 15 C gt IMP73 opt
78. ORA 06144 Cause Action Cause Action NETTCP no privilege for user A proxy login connect attempt failed because the SQL Net TCP IP server had insufficient privileges to access the proxy account Change the account protection change the server privileges or both NETTCP error getting user information A proxy login connect attempt failed because the SQL Net TCP IP server was unable to access the proxy account Check the log file for the operating system specific error code Contact your Oracle Customer Support representative NETTCP maximum connections exceeded The connect failed because the number of concurrent connections has exceeded the maximum supported by the host s SQL Net TCP IP server Wait for a short period and retry the operation NETTCP SID database is unavailable The database administrator on the host has taken the database to which you are requesting access offline Messages and Codes E 25 E 26 ORA 06220 Cause Action ORA 06221 Cause Action ORA 06222 Cause Action ORA 06223 Cause Action ORA 06224 Cause Action ORA 06225 Cause Action NETNMP Server not specified in command line A hostname is not specified in the DOS command line after p Specify the hostname after the network prefix and retry or set the LOCAL parameter in your configuration parameter file NETNMP Named pipe busy Either the database to which you are trying to conne
79. ORA 09201 sfcopy error copying file ORA 09202 sfifi error identifying file ORA 09203 sfofi error opening file ORA 09204 sfotf error opening temporary file ORA 09205 sfqio error reading or writing to disk ORA 09206 sfrfb error reading from file ORA 09207 sfsrd error reading from file ORA 09208 sftcls error closing file ORA 09209 sftget error reading from file ORA 09210 sftopn error opening file ORA 09211 sfwfb error writing to file Messages and Codes ORA 09212 ORA 09213 ORA 09214 ORA 09215 ORA 09216 ORA 09217 ORA 09218 ORA 09240 ORA 09241 ORA 09242 ORA 09243 ORA 09244 ORA 09245 ORA 09246 ORA 09247 ORA 09260 ORA 09261 ORA 09262 ORA 09263 sfwfbmt error writing to file slgfn error fabricating file name sfdone I O error detected sfqio error detected in I O completion routine sdnfy bad value s for parameter s sfsfs failed to resize file sfrfs failed to refresh file size smpalo error allocating PGA memory smsalo error allocating SGA memory smscre error creating SGA smsget error attaching to SGA smprset error setting memory protections smcstk error switching stacks sfsmap unable to map SGA smsdes error destroying the SGA sigpidu error obtaining process id spdcr error creating detached background process spdde error terminating detached background process spini error initializing process Oracle7 Server Getting Started for Windows NT
80. Oracle7 Server Getting Started for Windows NT Release 7 3 Part No A42396 1 ORACLE The Relational Database Management System Oracle7 Server Getting Started for Windows NT Release 7 3 Part No A42396 1 Copyright 1996 Oracle Corporation All rights reserved Printed in the U S A Primary Author Joseph Garcia Contributors Mark MacDonald Uma Murthy Liff Thomas Milton Wan Vivekandha Raja Prem Kumar Dave Colello Linlong Jiang Tina Marc This software was not developed for use in any nuclear aviation mass transit medical or other inherently dangerous applications It is the customer s responsibility to take all appropriate measures to ensure the safe use of such applications if the programs are used for such purposes This software documentation contains proprietary information of Oracle Corporation it is provided under a license agreement containing restrictions on use and disclosure and is also protected by copyright law Reverse engineering of the software is prohibited If this software documentation is delivered to a U S Government Agency of the Department of Defense then it is delivered with Restricted Rights and the following legend is applicable Restricted Rights Legend Use duplication or disclosure by the Government is subject to restrictions as set forth in subparagraph c 1 ii of DFARS 252 227 7013 Rights in Technical Data and Computer Software October 1988 Oracle Corporation 500 Ora
81. Oracle7 Server for Windows NT includes three types of software e server software applications and utilities used on the server side to run administer and maintain database operations e client software applications and utilities used on the client side to access databases and make use of database functions Introducing Oracle7 Server for Windows NT 1 7 Server Windows NT e networking software software used to provide connectivity among database clients and servers Server software includes the RDBMS utilities and products that enable you to connect to clients Here are the major server product components included in this package Oracle7 Server for Windows NT PL SQL Oracle7 Utilities Release 7 3 multi user Oracle7 Server for Windows NT the basis of Oracle7 Server for Windows NT software PL SQL the procedural language extension to SQL PL SQL supports the following features e database triggers e database alerts e stored procedures and packages Oracle7 Server for Windows NT includes a suite of server based utilities five of which are detailed below These are 32 bit Windows NT utilities for database administration Server Manager aids database administration functions Server Manager recognizes not only standard SQL commands but additional commands pertaining to DBA activities Instance Manager enables you to create modify start and stop instances databases SQL Loader provides utilities
82. PTER Database Administration T his chapter explains how to perform the following routine database tasks using the Oracle7 Utilities for Windows NT backup manager hot database file backup recovery manager refreshing table snapshots using trace and alert files logging error messages advanced replication option SQL language conventions SQL language conventions specific to Windows NT are discussed at the end of this chapter Database Administration 5 1 Backup Manager Backup Manager is one of the Windows NT based database management tools included with Oracle7 Server for Windows NT Use it to back up your Oracle7 database The Backup Manager runs in two modes depending upon the status of the database and the Support Recovery option located on the Configure Initialization Parameters dialog box of Database Manager The Backup Manager when opened appears in one of two ways depending upon the status of the database e running in ARCHIVELOG mode the database is running and the Support Recovery option is on the database is in ARCHIVELOG mode e running in NOARCHIVELOG mode or not running the database is running and the Support Recovery option is off the database is in NOARCHIVELOG mode During the Backup process you may be prompted to enter your database password If so type your database password and choose OK Hot Database File Backup This section discusses e backing up active files e restoring act
83. Replicated Data Oracle7 Server Concepts Oracle7 Server Administrator s Guide and other appropriate documentation Oracle7 Server Getting Started for Windows NT Oracle Migration Instance Manager GUI version a GUI version of Instance Manager is included in this release All of the functionality of the command line version of Instance Manager has been incorporated into a powerful easy to use GUI tool Performance Monitor Oracle7 Server for Windows NT uses the Windows NT Performance Monitor to monitor Oracle7 activity Using Performance Monitor administrators can monitor the performance of local and remote databases Event Viewer Oracle7 Server for Windows NT uses the Windows NT Event Viewer to log Oracle7 events The Event Viewer notifies you of errors and alert conditions that exist on the database This list can be viewed online saved to a file or printed Easy Configure Utility Oracle7 Server for Windows NT includes this utility for easily configuring simpler networks You can configure your network environment by answering questions on a few dialog boxes Oracle Objects for OLE object linking and embedding OLE application programming interface for use with Microsoft Visual Basic and VBA enabled applications Oracle Database Tools Oracle has enhanced its database tools to help you administer your database more easily and efficiently than ever Extensive integrated online Help is included with the Database
84. T RDBMSnn TRACE directory Oracle7 Server for Windows NT creates a different trace file for each background thread The name of the trace file contains the name of the background thread followed by the extension TRC Some sample trace file syntax is sidDBWR TRC and sidSMON TRC where sid represents the name of the instance the value of the ORACLE_SID configuration parameter Trace files are also created for user threads if the USER_DUMP_DEST parameter is set in the initialization parameter file The trace files for the user threads have the form ORAxxxxx TRC where xxxxx is a 5 digit number indicating the Windows NT thread ID The alert file contains important information about error messages and exceptions during database operations Each Oracle7 Server for Windows NT instance has one alert file information is appended to the file each time you start the instance All threads are able to write to the alert file For example when automatic archiving of redo logs is halted because no disk space is available a message is placed in the alert file The alert file is the first place you should check if something goes wrong with the database and the cause is not immediately obvious The alert file is named sidALRT LOG and is found in the directory specified by the BACKGROUND_DUMP_DEST parameter in the initialization parameter file If the BACKGROUND_DUMP_DEST parameter is not set the sidALRT LOG file is generated in ORANT RDBMSnn TRA
85. TARTTYPE lt SRVC INST gt e For sid specify the system identifier SID e For user_pwd specify the password for the user account specified Not needed if the user has connected as INTERNAL and either the DBA_AUTHORIZATION or DBA_sid_AUTHORIZATION parameter is set to BYPASS e For STARTTYPE specify SRVC for services INST for instance or both To stop an instance specify the following parameters SHUTDOWN SID lt sid gt USRPWD lt user_pwd gt SHUTTYPE lt SRVC INST gt SHUTMODE lt a i n gt where a is abort mode i is immediate mode and n is normal mode To delete any number of instances specify the following DELETE SID sida sidb sidc gt DELETE SRVC lt srvca srvcb srvcc gt To display a listing of Instance Manager commands specify one of the following queries h help Using Oracle7 Server for Windows NT 3 25 ORADIM Log When you use ORADIM73 in command line mode Instance Manager opens a log file ORADIM73 LOG in ORACLE_ HOME RDBMS73 All operations both successful and failed are logged in this file You must check this file to verify the success of an operation 3 26 Oracle7 Server Getting Started for Windows NT CHAPTER Getting the Most out of Integration with Windows NT T his chapter describes ways in which the tight integration between Oracle7 Server for Windows NT and the Windows NT operat
86. The control file is now in the directory VORACLE HOME DATABASE Example Using the above example Change this To this CONTROL_FILES CONTROL_FILES SRDBMS70 ct1l ora SORACLE_HOME DATABASE ctllabcd ora CONTROL_FILES CONTROL_FILES SRDBMS71_CONTROL ctll ora SRDBMS73_CONTROL ctll ora SRDBMS71_ARCHIVE ctll ora SRDBMS73_ARCHIVE ctll ora Note By default SRDBMS71_CONTROL SORACLE_HOME RDBMS71 SRDBMS71_ARCHIVE SORACLE_HOME RDBMS71 ARCHIVE SRDBMS73_CONTROL SORACLE_HOME DATABASE SRDBMS73_ARCHIVE SORACLE_HOME DATABASE ARCHIVE Note If you have your own database file structure edit the control files parameter to point to your control files c Change any occurrence of Yordbms70 Yordbms71 or rdbms72 in the initialization file to srdbms73 3 Alter the database to reflect new names Alter the database to reflect the new directory and filenames then exit Server Manager Start the Oracle 7 0 7 1 7 2 database using Server Manager Release 7 3 a Run SVRMGR73 exe in line mode b When prompted for a password enter the password you used to create Oracle services Then enter the following Installing Oracle7 Server for WindowsNT 2 29 SVRMGR gt connect internal lt password for the instance gt SVRMGR gt startup exclusive mount Note If you have your own database file structure go to Step 4 you have neither moved nor renamed your files c Enter the alt
87. USER XYZFRANK INDENTIFIED EXTERNALLY Subsequently if you are accessing a shared resource from a Windows NT or Windows 95 station and you connect to Oracle you need not enter your Oracle username For example after you enter SVRMGR you can enter CONNECT lt destination gt at the SVRMGR prompt Oracle searches the directory tables for an automatic login username corresponding to the NT username of FRANK verifies it and allows you to connect as XYZFRANK Because the Oracle Username is the whole name XYZFRANK all objects created by XYZFRANK that is tables views indexes etc are prefixed by this name For another user to reference the table SHARK owned by XYZFRANK the user would enter SVRMGR gt Select from XYZFRANK SHARK Note Automatic authorization accounts are supported for all protocols under SQL Net V2 The user must be already authenticated on the NT workstation server running the ORACLE database An authenticated connection is established between the client s workstation and the NT workstation server when a shared resource is accessed and the correct username password are supplied You can set OS_AUTHENT_PREFIX to the null string a set of double quotes with no string included This eliminates the need for any prefix to the NT usernames Note No INITsid ORA changes are necessary to enable automatic login NT GROUPS and ROLES 4 8 Oracle7 Server for Windows NT allows database roles to be gr
88. Windows NT 2 5 Installation Types Windows NT The ways in which Oracle7 Server for Windows NT installation for Windows NT server and clients can be performed are described in the following sections This release of Oracle7 Server for Windows NT offers seven types of Windows NT installations listed below Networking Products Install your choice of e Oracle Intelligent Agent e Oracle Names Server e SQL Net Client e SQL Net Protocol Adapters Named Pipes SPX TCP IP e SQL Net Server Oracle Documentation Install e Oracle Documentation Oracle7 Client Install your choice of e Application User SQL Plus SOL Net Client SQL Net Protocol Adapters Oracle Call Interface Oracle Installer e Database Administrator Oracle7 Utilities SQL Plus SOL Net Client 2 6 Oracle7 Server Getting Started for Windows NT Oracle7 Server SQL Net Protocol Adapters Oracle Call Interface Oracle Enterprise Manager Oracle Installer Install your choice of Programmer 2000 Oracle7 Server Oracle7 Server Options Oracle WebServer Oracle7 Utilities Oracle7 Performance Utility Oracle Call Interface Oracle Intelligent Agent Oracle Enterprise Manager SQL Plus SOL Net Server SQL Net Protocol Adapters Named Pipes SPX TCP IP Oracle Installer Install your choice of SOL Plus Pro C Oracle Call Interface Install SQL Plus Installing Oracle7 Server for Windows NT 2 7 Selective
89. acle7 Server for Windows NT process Check the log file for the operating system specific error code Contact your Oracle Customer Support representative NETTCP host access denied The host s SQL Net TCP IP server rejected this connection request because the client node does not have sufficient access privileges To grant access add the appropriate entry to the host s Valid Node Table VNT NETTCP user access denied The host s SQL Net TCP IP server rejected this connection request because the client username does not have sufficient access privileges Privileges are determined by the contents of the Username Mapping Table UMT a subset of the host s configuration parameters To grant access add the appropriate entry to the host s UMT NETTCP access denied wrong password The host SQL Net TCP IP server rejected this connection request because the client password did not match the host password To grant access make sure the passwords are the same NETTCP file not found The host s SQL Net TCP IP server could not find the SID mapping file associated with this connection request Verify the spelling and existence of the SID mapping file Messages and Codes E 24 ORA 06134 Cause Action ORA 06135 Cause Action ORA 06136 Cause Action ORA 06137 Cause Action ORA 06138 Cause Action ORA 06140 Cause Action NETTCP file access privilege violation The
90. administrator NETTCP unable to create ORASRV process The host s SOL Net TCP IP server was unable to create the Oracle7 Server for Windows NT process Oracle7 Server Getting Started for Windows NT Action ORA 06117 Cause Action ORA 06118 Cause Action ORA 06119 Cause Action ORA 06120 Cause Action ORA 06121 Cause Action ORA 06122 Cause Action See the SQL Net TCP IP server log file for more information Contact your system administrator NETTCP unable to create ORASRV quota exceeded The host s SOL Net TCP IP server was unable to create the Oracle7 Server for Windows NT process because of quota depletion Increase the quota allocations to the SQL Net TCP IP server process NETTCP unable to complete handshake with ORASRV The Oracle7 Server for Windows NT process was started but failed to complete its initialization Contact your Oracle Customer Support representative NETTCP spurious client request The host s SQL Net TCP IP server was unable to recognize the connection request See the SQL Net TCP IP server log file for more information Contact your Oracle Customer Support representative NETTCP network driver not loaded The TCP IP network driver is not loaded Verify that the TCP IP driver loads correctly NETTCP access failure The host s SQL Net TCP IP server was unable to test the accessibility of the SID mapping file specified in the configuration
91. ames user passwords and user privileges in the password file using Server Manager AN Warning Do not move or copy password files on your own do so only with the Instance Manager If you do the Instance Manager may not be able to find a password in order to start an instance Starting Services Automatically You can start Oracle7 Server for Windows NT automatically on restart by setting the OracleStartORCL service to automatic in the Services control panel Using Windows NT OS Authentication When enrolling ORACLE users you may optionally use the NT username as the basis for ORACLE usernames Users enrolled in this way can connect to ORACLE7 Server faster and more conveniently When using the NT username for authentication the database administrator sets the OS_AUTHENT_PREFIX parameter in the INITsid ORA file If this parameter is not set the default value is OPS The syntax for granting automatic logins when using the default value of OS_AUTHENT_PREFIX is as follows SVRMGR gt create user TO OPSSUSERID IDENTIFIED EXTERNALLY where USERID is the user s NT username Additional Information For more information on operating R system authentication see Oracle7 Server Administrator s Guide Getting the Most out of Integration with Windows NT 4 7 For example to enroll a user whose NT username is FRANK when the OS_AUTHENT_PREFIX id set to XYZ enter SVRMGR gt CREATE
92. andard error messages Installer Error Messages DISK_FULL Cause Action DRIVE_LOCKED Cause Action FILE_CORRUPTED Cause Action This section lists potential error messages that can occur while using the Oracle Installer Most of the Installer error messages are accompanied with corrective information right on the screen therefore they are not listed in this appendix This appendix lists potential error messages in alphabetical order and provides the probable cause and corrective action There is not enough disk space on the destination volume to copy the selected program Create space on the destination volume The device specified in the full error message is in use or locked by another Terminate or release the other process or wait for it to complete The file or directory specified in the full error message is damaged or not readable Try to repair or replace the file or repair the directory specified E 2 Oracle7 Server Getting Started for Windows NT FILE_NOT_FOUND Cause It was not possible to locate a file on the source or destination media Action Runa utility program to locate any problems with the source or destination media the media could be the CD ROM drive a network drive or a floppy drive INVALID_FILE_NAME Cause The file or directory name or volume label specified in the full message is syntactically incorrect Action Respecify the file directory or volume using correct syntax
93. anted to users directly by Windows NT When database users are enrolled using the automatic authenticated accounts Windows NT groups can be used to grant these users database roles NT groups are created by using the Windows NT USER MANAGER utility Additional Information For more information on managing le roles see Oracle7 Server Administrator s Guide Oracle7 Server Getting Started for Windows NT One INITsid ORA parameter must be properly set before Windows NT groups can be used to grant a database role OS_ROLES must be set to TRUE The default setting for this parameter is FALSE Unless set to TRUE Windows NT groups cannot be used to grant a database role 1 Set the INITsid ORA parameter OS_ROLES to be TRUE 2 Start or restart the database instance 3 Create and add users using the Windows NT USER MANAGER Include the ORA_ SID _ROLENAME format as described ORA_ SID _ROLENAME _ D A where SID indicates the database instance ROLENAME identifies the role assigned to database users during the session D indicates the role as the default role A indicates the role includes the ADMIN OPTION This option allows the user to grant the role to other roles only Roles cannot be granted to users if the operating system is used to manage roles Note Oracle will convert the group name to UPPERCASE Note Both the D and A characters are optional If either the D or A characters are specified
94. anual applies to the Oracle7 Server running on all operating systems It provides information about the base Oracle Server A 6 Oracle7 Server Getting Started for Windows NT and the following special options Distributed Advanced Replication Parallel Query WebServer Spatial Data and Parallel Server options Oracle7 Server Administrator s Guide Oracle7 Tuning Describes how to manage the Oracle7 Server Information in this Guide applies to the Oracle7 Server running on all operating systems It provides information about the base Oracle Server and the following special options Distributed Advanced Replication and Parallel Server options The Oracle7 Server is a highly tunable Relational Database Management System RDBMS You can enhance database performance by adjusting database applications the database itself and the operating system Proper tuning of Oracle provides the best possible database performance for your specific application and hardware configuration It contains the following information e the path for the Oracle7 Server documentation e a step by step process for tuning the Oracle7 Server e a description of diagnostic tools useful in tuning Oracle7 e installation recommendations for optimal performance e alist of all parts of the tuning process that vary depending on what operating system runs Oracle Oracle7 Server Application Developer s Guide Describes all features of the Oracle7 Server a relational
95. appendix also includes information about several initialization parameters that provide NLS support This appendix also describes the procedure for installing support for additional languages Additional Information For additional information on the B NLS_LANG parameter and NLS initialization parameters see Admin Oracle7 Server Administrator s Guide Guide National Language Support F 1 NLS_LANG When you install Oracle7 Server for Windows NT you select a language for database messages The Oracle Installer supplies a value for the NLS_LANG parameter to specify the language selected The NLS_LANG parameter uses the following format NLS_LANG LANGUAGE_TERRITORY CHARACTER_SET where language specifies the language and its conventions for displaying messages and day and month names territory specifies the territory and its conventions for calculating week and day numbers and character_set controls the character set used for displaying messages The default language at installation is American English If you accept the default language the following value is supplied for the NLS_LANG parameter AMERICAN_AMERICA WE8ISO8859P1 Attention To reset the NLS_LANG parameter to different ZT values for language territory or character set you must install the complete set of language files for that component in the ORANT RDBMSnn directory Refer to the section Installing Additional Langua
96. appendix can be used for the NLS_TERRITORY parameter Using ALTER SESSION If you wish to set the language for a single Server Manager session define NLS_LANGUAGE and NLS_TERRITORY with the command SRVMGR gt ALTER SESSION SET NLS_LANGUAGE LANGUAGE NLS_TERRITORY TERRITORY where language and territory correspond to values in the next section Parameter Lists This changes the language only until you start a new Server Manager session For more information on National Language Support see Oracle7 Server Administrator s Guide F 4 Oracle7 Server Getting Started for Windows NT NLS_SORT The value for the NLS_SORT initialization parameter is dependent on the language selected for the database instance See Oracle7 Server Administrator s Guide contains information about all of the available NLS initialization parameters Parameter Lists Languages The following lists include all parameters for the supported languages territories and character sets for Oracle7 Server for Windows NT Use these values independently within the NLS_LANG configuration parameter or use the language parameter to set the default values for territory and character set Additionally the language and territory values listed can be used in the initialization parameters NLS_LANGUAGE and NLS_TERRITORY Refer to the previous sections NLS_LANG and NLS Initialization Parameters for information o
97. arameter on the server to TRUE e Set the ORA_ENCRYPT_LOGIN environment variable on the client machine to TRUE Once these parameters are set whenever you attempt a remote login Oracle encrypts the password before sending it to the remote database If the connection fails the failure is noted in the audit log Oracle then checks the appropriate parameter values If either is set to FALSE Oracle attempts the connection again using an unencrypted version of the password If the connection is successful the success is noted in the audit log and the connection proceeds I gt Attention Releases of the Oracle7 Server prior to 7 1 did not support encrypted passwords Therefore if you know you are connecting to earlier versions of an Oracle7 Server for Windows NT you must set the initialization parameter DBLINK_ENCRYPT_LOGIN to FALSE for the connection to succeed Oracle7 Server Getting Started for Windows NT Creating Password Files You create password files with the Instance Manager as part of the process of creating an instance The two essential elements of a password file you specify with the Instance Manager are e the password for the INTERNAL account for that instance e the maximum number of users to whom you wish to grant SYSOPER or SYSDBA privileges The Instance Manager creates in ORANT DATABASE a password file with the name PWDsid ORA where sid is the system identifier SID Later you can add or delete user n
98. ase NLS character set to use This parameter can be set only when you create the database CONTROL_FILES Designates the names and locations of all control files to be created and maintained By default Oracle7 Server for Windows NT installs a single Initialization Parameter Files C 3 control file for the initial database CTL1ORCL ORA in ORANT DATABASE If you created your database with the CREATE DATABASE command Oracle7 Server for Windows NT creates the control file CTL1sid ORA where sid is the SID of that database At least two identical control files each located on a separate storage device should be used The size of Oracle7 Server for Windows NT control files vary according to the complexity of your database structure The maximum size of an Oracle7 Server for Windows NT control file is 2500 database blocks Admin Guide Initialization Parameters Additional Information See Oracle7 Server Administrator s Guide for more information on initialization parameters Oracle7 Server Administrator s Guide includes descriptions of all initialization parameters and instructions for setting and displaying their values Parameter Name Default Value Range of Values BACKGROUND_DUMP_DEST RDBMSnn TRACE Any valid directory COMMIT_POINT_STRENGTH 1 0 255 Any valid path and filename CONTROL_FILES ORACLE_HOME DATABASE CTL1 ORACLE_SID ORA DB_BLOCK_SIZE 2048 DB_FILES 32 DB_FILE_MULT
99. ase tools you can install Chapter4 Getting the Most out of Integration with Windows NT Instructions for using the Windows NT operating system integration features iv Oracle7 Server Getting Started for Windows NT Chapter5 Database Maintenance Instructions for performing ongoing database maintenance tasks using graphical and command line procedures Appendix A Documentation Roadmap Details the documentation included in your package and how you can use it most effectively Appendix B_ Directory Structures Directory structures for Windows NT and Windows Windows95 Additionally information about the types of possible Oracle WebServer installations is included Appendix C Initialization Parameter Files Describes Oracle7 Server for Windows NT initialization parameters how to edit them and Windows NT specific defaults and ranges for them Appendix D Configuration Parameters and the NT Registry Describes the use of the Windows NT Registry for various Oracle products Additionally it lists the defaults and ranges for configuration parameters Appendix E Messages and Codes Lists the error messages and codes specific to installing and using Oracle7 Server for Windows NT and supported network protocols Appendix F National Language Support Explains the NLS_LANG configuration parameter and its components and lists the available options Using the Documentation For New Users This Guide contains installation and operati
100. ation files for Oracle networking products For more information on Network Manager see Oracle Network Manager for Windows Installation and User s Guide and Oracle Network Manager Administrator s Guide Complete advanced database administration tasks from client workstations using Server Manager Oracle Enterprise Manager is Oracle Corporation s newest generation of system management tools Enterprise Manager combines a single point of control management console intelligent agents and common services in an integrated comprehensive systems management platform 1 10 Oracle7 Server Getting Started for Windows NT Oracle Networking Software SOL Net Version 2 Network Manager Net k j i ace Manager User s Guide and Oracle Network Manager Administrator s Guide SOL Net is the Oracle network interface that enables front end application software on client workstations to e access data e modify data e share data and e store data on Oracle7 database servers SQL Net uses communication protocols and application programming interfaces APIs supported by a wide range of networks providing distributed database capabilities for the Oracle7 RDBMS This release of Oracle7 Server for Windows NT includes SOQL Net Version 2 only The specific networking components you install with your Oracle7 Server for Windows NT depend upon the version s of SQL Net you are using on your network Use the new Easy Configure featur
101. begin another thread The program has run out of system resources Shutdown all unnecessary processes install more memory in the machine no pid structure supplied to spdcr This is an internal error not normally expected to occur Contact Oracle Customer Support DosSetPriority failure unable to set process priority There was an unexpected return from the Windows NT system service DosSetPriority Check the operating system error code and consult the Windows NT documentation DosKillProcess failure unable to kill process There was an unexpected return from the Windows NT system service DosKillProcess Check the operating system error code and consult the Windows NT documentation invalid pid Process id not recognized by system process previously terminated Verify that process ID is correct and that process is active CreateProcess failure unable to spawn process There was an unexpected return from the Windows NT system service CreateProcess Check the operating system error code and consult the Windows NT documentation invalid priority specified in CONFIG parameter ORACLE_PRIORITY The priority specified is invalid or out of range Specify a valid setting for ORACLE_PRIORITY Oracle7 Server Getting Started for Windows NT OSD 04208 Cause Action OSD 04209 Cause Action OSD 04210 Cause Action OSD 04211 Cause Action OSD 04212 Cause Action OSD 04213 Cause
102. bsystem SQL Net SQL Net Oracle and and Oracle7 ai Network Network RDBMS Windows E gt Protocol lt lt gt Protocol lt gt for for for Windows NT Windows Windows NT 2 4 The interaction between Oracle products for Windows running on WOW and your local Oracle7 database for Windows NT is called loopback You must install the same version of SQL Net along with the appropriate protocol adapter software for both Windows NT and Windows in order for loopback to occur i gt Attention You can always achieve loopback by using SQL Net V2 along with the Oracle Named Pipes Protocol Adapter or the Oracle TCP IP Protocol Adapter for Windows NT and Windows Remember that you need a network card if you use SQL Net V2 with the TCP IP protocol adapter ISF Attention If you are using your Windows NT machine as a client you can install SQL Net V2 Client for Windows NT plus the appropriate Windows NT protocol adapter Named Pipes TCP IP or SPX Oracle7 Server Getting Started for Windows NT Before You Install First Time Installation Re installation of Oracle Before you install Oracle7 Server for Windows NT software on your Windows NT server perform the following tasks appropriate to your installation For the first time installation of Oracle7 Server for Windows NT on a server containing no previous version of an Oracle Server verify that the volume on wh
103. cified in REMOTE but specifies no connect string the connect string specified in REMOTE is used For example a user might connect to a database with Server Manager using SOL Net Named Pipes as follows Configuration Parameters and the Windows NT Registry D 9 SQLNET SVRMGR gt CONNECT username password p The connect string includes only the network prefix p which matches the network prefix specified in the above REMOTE parameter Therefore Server Manager automatically uses the REMOTE parameter to complete the connection to the HOUSTON database This configuration parameter enables the DBA to define a network connection for which the SQL Net user need not specify connection parameters Note You can reset this parameter on the command line at any time Operating System Windows NT Default None Legal Values The word DBNAME followed by an alias and any valid connect string This parameter allows you to set a unique alias for each server on your network or distributed network By setting multiple aliases you can refer to connect strings by simple names or mnemonic conventions when using any of the Oracle utilities You do not have to remember the complete connect string for each one The syntax for the SQLNET parameter is alias connect_string For example if you create a Registry key value SQLNET DBNAME FINANCE for the connect string P MKTG_SRV2_NY FIN1 you can access the database from within SQL Plus by t
104. cking on the Exit button and confirm your exit when prompted If you choose Selective a Choose Selective Product Install in the Software Asset Manager You can view the products in this package by double clicking on the product s displaying a plus sign to their left Click the Install button The Selective Product Install dialog box appears Select the products you want to install Click the OK button Answer questions and make choices in the dialog boxes that appear When the installation is complete a notification dialog box appears Installing Oracle7 Server for WindowsNT 2 21 Note The questions dialog boxes that appear will vary depending upon the product choices you make f Click OK to dismiss the notification The Software Asset Manager reappears g Click Exit to exit Oracle Installer Configuring SOL Net Some of the installation packages allow you to selectively install and automatically configure SQL Net release 2 3 server networking software To configure these products use the Easy Configuration Utility that is automatically installed with your SQL Net V2 3 products Note For complex networks use Network Manager for configuration ome Configuration see Oracle Network Products User s Guide for the appropriate operating system E Additional Information For information on using Easy A single SQL Net release 2 3 networking software connection is automatically configured with each
105. clause have the same defaults and minimum values SQL as those described in the Oracle7 Server SQL Reference Setting Resource Costs 3 20 Oracle7 Server for Windows NT allows you to limit users access to database resources and database objects For example you can set limits for a user s file input output I O regardless of which database objects the user accesses Set a resource cost for the logical reads of the user s session to set I O limits Define resource costs through user profiles A profile is a collection of valid database resources and costs for a given user With Oracle7 Server for Windows NT you can create user profiles to define the following resource costs e logical reads for individual sessions or SQL statements e number of sessions that a user may create e idle time and elapsed time for each user session Oracle7 Server Getting Started for Windows NT e CPU time used by each user s session on the server machine Additional Information See Oracle7 Server Administrator s ke Guide for details on setting resource costs Admin Guide Using the Oracle7 Server Utilities The Oracle7 Server utilities enable you to move data to and from an Oracle database and administer database related functions For example SQL Loader lets you load data from ASCII text files and other file formats into an Oracle7 Server for Windows NT database The Import and Export utilities let you move existing Oracle data
106. cle Parkway Redwood City CA 94065 If this software documentation is delivered to a U S Government Agency not within the Department of Defense then it is delivered with Restricted Rights as defined in FAR 52 227 14 Rights in Data General including Alternate IIT June 1987 The information in this document is subject to change without notice If you find any problems in the documentation please report them to us in writing Oracle Corporation does not warrant that this document is error free Oracle SQL Loader SQL Net and SQL Plus are registered trademarks of Oracle Corporation Oracle7 Oracle7 Workgroup Server Oracle Names Oracle Network Manager Oracle Objects and Oracle MultiProtocol Interchange are trademarks of Oracle Corporation All other products or company names are used for identification purposes only and may be trademarks of their respective owners Preface T his User s Guide is your primary source of introductory installation and configuration information for Oracle7 Server for Windows NT Included in this Guide introduction to Oracle7 Server for Windows NT installation instructions Oracle WebServer 1 0 Oracle Spatial Data Option using Oracle7 Server for Windows NT getting the most out of Integration with Windows NT database maintenance documentation roadmap directory structures initialization parameter files configuration file parameters and the Windows NT Registry messages and code
107. ct does not exist or all available Named Pipes instances are in use 1 Check your connect string 2 Close any unused connections and retry the operation NETNMP Error allocating memory The system is unable to allocate memory block Resubmit the entry If the error persists contact your DBA NETNMP Error receiving data from pipe Oracle encountered an error when receiving data from the pipe Check all LAN connections and cables If any connections are loose secure them and retry Otherwise reboot your machine and reload the SOQL Net Named Pipes driver If the error persists contact your DBA NETNMP Error sending data to pipe The system encountered an error sending data to the pipe Check all LAN connections and cables If any connections are loose secure them and retry Otherwise reboot the machine and reload the SQL Net Named Pipes driver If the error persists contact your DBA NETNMP Invalid packet type The system received erroneous data Check all LAN connections and cables If any connections are loose secure them and retry Otherwise reboot the machine and reload the SQL Net Named Pipes driver If the error persists contact your DBA Oracle7 Server Getting Started for Windows NT ORA 06226 Cause Action ORA 06227 Cause Action ORA 06228 Cause Action ORA 06229 Cause Action ORA 06230 Cause Action ORA 06231 Cause Action NETNMP Send byte count error An error
108. d E 21 NETTCP no privilege for user E 25 NETTCP no such user E 24 NETTCP ORACLE network server not found E 19 NETTCP ORASRV exited unexpectedly E 22 NETTCP ORASRV unable to open network connection E 22 NETTCP remote host is unknown E 19 NETTCP setup failure E 21 NETTCP SID database is unavailable E 25 NETTCP SID lookup failure E 20 NETTCP socket creation failure E 19 NETTCP spurious client request E 21 NETTCP timeout waiting for ORASRV E 22 NETTCP Too many connections E 20 NETTCP unable to change username E 22 NETTCP unable to complete handshake with ORASRYV E 21 NETTCP unable to create mailbox E 23 NETTCP unable to create ORACLE logicals E 20 NETTCP unable to create ORASRV process E 20 NETTCP unable to create ORASRV quota exceeded E 21 NETTCP unable to start ORASRV images not installed E 25 NETTCP unable to transfer socket ownership to ORASRYV E 23 NETTCP user access denied E 23 NetWare volume 2 5 network interface card NIC 2 2 2 3 Network Manager 1 10 definition of 1 11 network transport protocol software 2 3 Networking parameters D 7 Networking Products installation 2 6 Networking Products Install 2 12 Networking software 1 11 1 16 NLS initialization parameters F 4 NLS_LANGUAGE F 4 NLS_TERRITORY F 4 NLS Support F 1 F 8 NLS_LANG confi
109. database management system RDBMS This Guide is provided so that you can understand how to develop applications for Oracle7 Information in this Guide applies to the Oracle7 Server running on all operating systems Oracle7 Server SQL Reference Complete description of the Structured Query Language SQL used to manage information in an Oracle7 database This manual notes any features that require the Distributed Option Parallel Server Option Parallel Query Option or PL SQL to be installed Also noted are parts of Oracle7 SQL that are only used with the Trusted Oracle7 Server Documentation Roadmap A 7 Oracle7 Server Reference Provides reference information about Oracle7 Server release 7 3 including e initialization parameters e data dictionary views e National Language Support NLS e National Language Support Utilities e database limits e Structured Query Language SQL scripts Oracle7 Server Utilities Describes the basic concepts of and how to use the Export Import SQL Loader and Server Manager Oracle7 Server utilities for data transfer maintenance and database administration Oracle7 Server Messages Provides complementary information about messages generated by the Oracle7 Server and its parts Except for operating system specific messages all messages in this manual are common to all Oracle products that interface with Oracle7 Server Oracle7 Server Migration Aides database administrators and s
110. do not de install 7 1 doing so will disrupt your Release 7 3 install a Run orainst exe in line mode b From the products list select 7 0 7 1 7 2 Server Required Support Files Utilities c Choose Remove Install the Oracle7 Server 1 Install the Oracle7 Server for Windows NT Install the Oracle7 Server for Windows NT During installation you will have the choice of installing the starter database If you do not need another Release 7 3 database in addition to the one that you are upgrading from 7 0 7 1 7 2 you do not need to install the starter database Additional Information See Installation for installation steps Le and options 2 Add an ORACLE_SID key to the NT registry a Create a SID for the to be migrated database instance For example choose ABCD as the SID Note If you have chosen to install the starter database during Release 7 3 installation Do not use ORCL as the SID the starter Release 7 3 database has ORCL as the default SID Change the ORACLE_SID from ORCL to ABCD Note SID is limited to four alphanumeric characters or less b Run regedt32 exe in line mode c Go to HKEY_LOCAL_ MACHINE SOFTWARE ORACLE 2 26 Oracle7 Server Getting Started for Windows NT d Create the ORACLE_SID value with data type REG_EXPAND_SZ and the SID you chose earlier in the string field e Close the Registry 3 Create and start Oracle Release 7 3 services Create and start an Oracle Release
111. dows NT installation It shows you how to modify the starter database or create a new database of your own Note Database creation is an advanced function Oracle recommends that you use the starter database and modify it to suit your needs An Oracle instance is a logical term that refers to an Oracle service and a database server Oracle services are similar to Windows NT services In order to connect to and use an Oracle server an Oracle service must be created and associated with the Oracle database Each Oracle instance must have a unique SID With Oracle7 Server for Windows NT you can run multiple Oracle instances simultaneously on one machine During the installation a default instance is installed This instance is identified by the sid ORCL This Guide refers to the database of this default instance as the starter database You can expand the starter database if necessary to better suit your needs The installation process creates an Oracle service and a listener service for the default instance Both services are created as automatic Windows NT services This means that they start automatically when the machine powers up To use the starter database start the database with Server Manager or Database Manager The starter database ORACLE is the core of the Oracle7 Server for Windows NT database system The starter database contains e four tablespaces e four database files e two log files e a preloaded data dictionary e
112. e E 30 NETCMN SID lookup failure E 30 NETCMN unable to set up break handling environment E 29 NETNMP Error allocating memory E 26 NETNMP Error receiving data from pipe E 26 NETNMP Error resetting connection E 27 NETNMP Error sending data to pipe E 26 NETNMP Invalid packet type E 26 NETNMP Named pipe busy E 26 NETNMP Send byte count error E 27 NETNMP Server not specified in command line E 26 NETNMP SQL Net handshake error E 27 NETNMP Unable to create a pipe instance E 28 NETNMP Unable to open named pipe E 27 NETNMP Unable to put pipe into listening mode E 27 NETNMP Windows NT failed to create or access shared memory E 27 NETTCP access denied wrong password E 23 NETTCP access failure E 21 NETTCP cannot allocate context area E 19 NETTCP cannot set KEEPALIVE E 22 NETTCP connect to host failed E 19 NETTCP connection rejected server is stopping E 24 NETTCP disconnect failure E 20 NETTCP error during connection handshake E 24 NETTCP error getting user information E 25 NETTCP file access privilege violation E 24 NETTCP file not found E 23 NETTCP host access denied E 23 NETTCP invalid buffer size E 20 NETTCP maximum connections exceeded E 25 NETTCP message receive failure E 19 NETTCP message send failure E 20 NETTCP network driver not loade
113. e Commands 3 24 NEW ea bare eee Gat ieee Mat TE EEE 3 24 EDIP nean a eee eee ee eee Jar ee eae re rere 3 24 STARTUP ai iia eee ee eaa eee reer eines eae 3 25 SHUTDOWN wciieet chad tonii di pererwad NEEE E EE 3 25 DELETE aes iit iienaa irik E E EE 3 25 F helpi eree a a eaa a a aa ew Ee ae Sida 3 25 ORADIM Log Mri eeii kt bebe bn bint Pate eii 3 26 Getting the Most out of Integration with Windows NT 4 1 Oracle7 and the Windows NT Performance Monitor 4 2 Performance Monitor Objects rasanne 4 3 Event Viewer a 064s Gi ee eels OY O EEEE Sng eta aera 4 5 Database Security 6 66 4 5 Starting Services Automatically 6 6 66 c eee 4 7 Using Windows NT OS Authentication 0 4 7 NT GROUPS and ROLES 0 cece eee eee 4 8 Database Administration 6 cece cece eee eeee 5 1 Backup Manager 066 aieeao a r E eee eens 5 2 Hot Database File Backup 66666 cece cece 5 2 Backing Up Active Files 0 0 rnrn 5 2 Restoring Active Files 0 0 cece eens 5 3 Backing Up RAW Files 0 0 0 c ccc eee 5 4 Restoring RAW Files 0 c cece eee eee 5 4 Recovery Manager 6 6 cece eee eens 5 4 Using Trace and Alert Files 6 6 66 c cece eee eee 5 5 Logging Error Messages 6 00 c cece cece es 5 5 Refreshing Table Snapshots uasnanannn ranan nnana 5 6 Advanced Replication Option
114. e Guide A 4 Oracle7 Server Getting Started for Windows NT Understanding SQL Net Oracle7 Server Utilities Oracle Server Manager User s Guide Create Applications Pro C for Windows NT 95 Installation and User s Guide Oracle7 Server Applications Developer s Guide Programmer s Guide to the Oracle Pro C Precompiler Pro COBOL Supplement to the Oracle Precompilers Programmer s Guide to the Oracle Precompilers Programmer s Guide to the Oracle7 Server Call Interface SQL Plus User s Guide and Reference Documentation Sets Your Oracle documentation is divided into the following sets e Installation Guides e RDBMS e Networking e Programmer 2000 Note Oracle product documentation is provided in electronic Adobe Acrobat format only except for this Guide and Oracle Network Products for Windows NT 95 Installation and User s Guide which are also provided as hard copy documents You can order hard copy books of Oracle product documentation by contacting Documentation Sales at 800 252 0303 Following is a brief explanation of the Oracle documentation set Installation Documentation Oracle7 Release Notes Documentation Roadmap A 5 SQL Plus for Windows NT 95 Installation and User s Guide Operating system specific information about the installation use and administration of SQL Plus for Windows NT SQL Plus for Windows Installation and User s Guide Information to help you get started with SQ
115. e Services Aetoli eee nodal SRO i Sia aah Sai cae ol 3 5 Instance Manager 66 ccc cece eee ees 3 6 Creating an Instance and Database with Instance Mania get eases seh siegtiace dealer IEE Pas thine a 3 6 Changing Passwords 00 00 c cece eens 3 8 Advanced Parameters 0 3 9 Starting a Database 2 6 eens 3 10 Starting a Database Using Instance Manager 3 11 Starting a Database Using Server Manager 3 11 Shutting Down an Instance Database 3 11 Delete an Instance 60 errs bedhe dhorn SE ee e hEPE d wed 3 12 Running Multiple Instances a nanan nananana 3 12 Using Server Manager 2 0 0 cece cece 3 12 Creating an Instance 2 6 nee 3 13 Starting an Instance 2 eens 3 13 Running Multiple Instances 0 00 06 6 eee 3 13 x Oracle7 Server Getting Started for Windows NT Chapter 4 Chapter 5 Creating a New Database 0 c cee cee 3 14 Preparing to Create a New Database 3 15 Starting an Instance and Creating the Database 3 18 Creating Database Objects 0 0 06 6 6 6 3 20 Setting Resource Costs 1 0 0 0 0 00 c ccc eee ees 3 20 Using the Oracle7 Server Utilities 00 3 21 Using Export and Import 6 60066 c cece 3 21 Using SQL Loader r ter bid UE ie Madde wea Oe oes 3 22 SQL Loader Processing Options 0 000000 3 22 Instance Manager Command Lin
116. e connection again Messages and Codes E 27 E 28 ORA 06232 Cause Action ORA 06401 Cause Action ORA 06402 Cause Action ORA 06403 Cause Action ORA 06404 Cause Action ORA 06405 Cause Action NETNMP Unable to create a pipe instance Named pipe could not be properly opened Ensure that Named Pipes software is installed properly in Windows NT and that the Server machine is successfully started Codes 6401 6430 NETCMN Errors This section lists and explains the error codes you might receive when using SQL Net The error message descriptions in this section list possible causes for the errors and suggest corrective actions The messages in this section apply only if you are using SOL Net V1 For messages relating to use of SQL Net V2 see Oracle Network Products Messages Manual NETCMN invalid driver designator The specified driver is unknown Check the last entry and resubmit the connect string using the designated name for the SOL Net driver NETCMN error receiving break message The SQL Net driver detected that its server has unexpectedly exited Check the network operating system and resubmit the connect string NETCMN cannot allocate context area The SQL Net driver could not allocate heap space for the context area Resubmit the connect string Contact your DBA NETCMN invalid login string The SQL Net driver detected a syntax error in the database ID portion of the
117. e for Windows NT User s Guide Pro C C for Windows NT User s Guide You can read the documentation online and print out portions you need For details on installing Oracle online documentation see Installing Oracle7 Server for Windows NT in Oracle7 Server Getting Started for Windows NT Documentation Roadmap A 3 eamcasyr o 000300 Oracle Network Products for Windows NT 95 User s Guide SQL Plus for Windows NT 95 User s Guide Oracle7 Server Concepts Understanding SQL Net Oracle7 Server Administrator s Guide Oracle7 Tuning Oracle7 Server SQL Reference Oracle7 Server Reference Oracle Server Manager User s Guide PL SQL User s Guide Reference Oracle7 Server Distributed Systems V1 Distributed Data Oracle7 Server Distributed Systems V2 Replicated Data Network Products Messages Manual Oracle Network Manager Administrator s Guide Start Here Oracle7 Server for Windows NT Getting Started Install Configure amp Use Oracle7 Server and NT Client Oracle7 Server for Windows NT Getting Started Oracle Names Administrator s Guide Install amp Use Windows or OS 2 Client Oracle Network Products for Windows User s Guide Oracle Network Products for OS 2 User s Guide SQL Plus for Windows Installation and User s Guide SQL Plus for OS 2 Installation and User s Guide Additional Networking Information Oracle SNMP Support Reference Guide Secure Network Services Referenc
118. e to quickly configure simpler network environments For complex network environments or for more detailed control of your network use Network Manager to configure your network SQL Net V2 and the other TNS based networking products MultiProtocol Interchange and Oracle Names require a number of configuration files with precise syntax These configuration files must be created using Oracle Network Manager a graphical user interface tool for creating configuration files quickly and accurately Additional Information For more information on Network pS Manager see Oracle Network Manager for Windows Installation and SQL Net V2 supports the Oracle MultiProtocol Interchange providing a bridge between transport protocols The MultiProtocol Interchange is not currently supported under Windows NT If your network includes machines running another operating system s the MultiProtocol Interchange could run on these machines In such a Introducing Oracle7 Server for Windows NT 1 11 case a server could connect to a client running a protocol different from those available on the server SQL Net V2 also supports Oracle Names which establishes a centrally located database of short aliases representing the full network locations of all databases on the network Appropriately configured users can access this database at every node on the network over any network protocol supported by SQL Net Oracle Names enables such users to access or refer
119. e7 Server Administrator s Guide for more information Delete all the database files including data files redo log files and control files from the starter database e SYSIORCL ORA e USRIORCL ORA e RBSIORCL ORA e TMP1ORCL ORA e INITORCL ORA e LOGIORCL ORA e LOG2ORCL ORA e CTLIORCL ORA If you are replacing the starter database go to Step 8 now If you have created a new instance copy the sample initialization parameter file INITsid ORA to anew file named INITsid ORA where sid is the new instance name Using any text editor modify the new INITsid ORA file so that all references to the CONTROL_FILES parameter reflect the new SID For example if the new instance s SID is ABC replace CTLIORCL ORA in the INITABC ORA with CTLIABC ORA Oracle7 Server Getting Started for Windows NT I gt Attention The CONTROL_FILES parameter in the INITsid ORA file must specify the complete path s of control file s including drive designators For example CONTROL_FILES D MY_ORACLE_HOME DATABASE CTL1ABC ORA OR CONTROL_FILES RDBMS73 DATABASE CTL1ABC ORA A Warning RDBMS73 is instantiated by Oracle to a directory with the drive designator stated above If a drive letter s is not provided Oracle will not start properly Attention See Initialization File Parameters in this Guide for I important additional information on modifying Windows NT specific initialization para
120. e7PerformanceData Close REG_EXPAN CloseOracle7PerformanceData Collect REG_EXPAN CollectOracle7PerformanceData Hostname REG_EXPAN 2 ORCL Username REG_EXPAN System Password REG_EXPAN Manager Only the last 3 items Hostname Username Password in the above table can be modified They can point to any Oracle database local or remote You must have read access to any tables from which you want to get data Note One SID per machine can be monitored using Performance Monitor at a time 4 2 Oracle7 Server Getting Started for Windows NT omk Performance Monitor see your operating system documentation F Additional Information For more information on the omk of Windows NT Performance Monitor results and what you can do about your database performance see Oracle7 Server Tuning and your operating system documentation Additional Information For more information on the meaning Performance Monitor Objects Performance Monitor objects are detailed below Memory Allocation Objects Object Oracle7 Library Cache The Library Cache object contains one counter the reloads pins percentage counter This value is not time derived The reloads pins is the percent of SQL statements PL SQL blocks and object definitions which required re parsing This percentage should be near ZERO If the percentage is greater than 1 then you should reduce the library cache misses See Reducing Library Cache Misses in Orac
121. er listener threads are generated than required by NUP_SPAWN_INCREMENT if fewer are required A delay of length NUP_SPAWN_DELAY occurs between the generation of each batch of listener threads Note Setting this parameter to zero causes the parameter to take its default value D 8 Oracle7 Server Getting Started for Windows NT NMP_SPAWN_DELAY TK2_TIO REMOTE Operating System Windows NT SQL Net Version 1 1 of SQL Net Named Pipes Default 0 milliseconds ms Legal Values 1 to any positive integer ms NMP_SPAWN_DELAY is the length of time that the server waits between creating batches of listener threads Note Setting this parameter to zero causes the parameter to take its default value Operating System Windows NT Default VIDEO Legal Values Legal Values This parameter sets the screen driver terminal input output that Toolkit II based interfaces use to write to the screen The final letter m in an available value name indicates monochrome mode Operating System Windows NT SOL Net 4 Version 1 1 of SQL Net Named Pipes and SOL Net TCP IP Default None Legal Values Any valid SQL Net connect string This parameter enables you to define a default remote network connection For example a valid entry for REMOTE is p houston where p is the network prefix for SQL Net Named Pipes and houston is the database name If a user logs on and specifies a connection with an explicit driver prefix matching the one spe
122. er_value is the value you choose A value you set in the AUTOEXEC BAT file is inherited by every command prompt you launch from within Windows NT Note Values set in AUTOEXEC BAT do not take effect until you start up a new Windows NT command prompt Any Oracle software you run subsequently recognizes values set in AUTOEXEC BAT and does not search for corresponding values in the Windows NT Registry At the Command Prompt The syntax for setting any configuration parameter at the command prompt is C gt SET parameter_name parameter_valu Oracle7 Server Getting Started for Windows NT where parameter_name is the name of the parameter and parameter_value is the value you choose Note A value set at the command prompt is valid for only that particular instance of the command prompt Any Oracle software you run during that instance recognizes the values set at the command prompt and does not search for corresponding values in the Windows NT Registry or in AUTOEXEC BAT Configuration Parameter Descriptions General Parameters NLS_LANG This section describes individual configuration parameters affecting the operation of the Oracle7 Server for Windows NT and SQL Net for Windows NT software Individual Oracle tools may use additional configuration parameters refer to the documentation for the tool you are using for more information on those parameters The following parameters define characteristics of Oracle7 Server for
123. ered database statement at the Server Manager prompt to change the full pathnames of the data and log files Following are 7 0 and 7 1 examples for migrating the default SID Your statement should match your actual files 7 0 7 1 SVRMGR gt alter database rename file SVRMGR gt alter database rename file SVRMGR gt C ORANT RDBMS70 dbs1 ora SVRMGR gt C ORANT RDBMS71 loglorcl ora SVRMGR gt C ORANT RDBMS70 logl ora SVRMGR gt C ORANT RDBMS71 ARCHIVE loglorcl ora SVRMGR gt C ORANT RDBMS70 log2 ora to SVRMGR gt C ORANT RDBMS71 log2orcl ora SVRMGR gt C ORANT DATABASE dbslorcl ora SVRMGR gt C ORANT RDBMS71 ARCHIVE log2orcl ora SVRMGR gt C ORANT DATABASE loglorcl ora SVRMGR gt C ORANT RDBMS71 sysorcl ora SVRMGR gt C ORANT DATABASE log2orcl ora SVRMGR gt C ORANT RDBMS71 userorcl ora SVRMGR gt C ORANT RDBMS71 rbsorcl ora SVRMGR gt C ORANT RDBMS71 temporcl ora to SVRMGR gt C ORANT DATABASE loglorcl ora SVRMGR gt C ORANT DATABASE ARCHIVE loglorcl ora SVRMGR gt C ORANT DATABASE log2orcl ora SVRMGR gt C ORANT DATABASE ARCHIVE log2orcl ora SVRMGR gt C ORANT DATABASE sysorcl ora SVRMGR gt C ORANT DATABASE userorcl ora SVRMGR gt C ORANT DATABASE rbsorcl ora SVRMGR gt C ORANT DATABASE temporcl ora Note If your Oracle home direc
124. f the archive files from ORACLE_HOME rdbms71 ARCHIV to ORACLE_HOME DATABAS The original list of files are E ARCHIV GI GI 7 0 7 1 7 2 srdbms70 ctll ora 2 rdbms71 ctllorcl ora Soracle_home database ctllorcl ora srdpms70 dbsl ora rdbms71 sysorcl ora Soracle_home database sysorcl ora srdbms70 logl ora rdbms71 userorcl ora Soracle_home database userorcl ora srdbms70 log2 ora 2 rdbms71 rbsorcl ora Soracle_home database rbsorcl ora srdbms71 temporcl ora Soracle_home database temporcl ora rdbms71 loglorcl ora Soracle_home database loglorcl ora rdbms71 log2orcl ora Soracle_home database log2orcl ora rdbms71 archive ctllorcl ora 0oracle_home database archive ctllorcl ora Srdbms71 archive logorcll ora oracle_home database archive logorcll ora Srdbms71 archive logorcl2 ora oracle_home database archive logorcl2 ora Note This information is in the spool file you created earlier c If you have expanded the database move the additional database files as well Note You can combine the steps above into one operation with the move command For example move 2 28 Oracle7 Server Getting Started for Windows NT Into DATABASE INITsid ORA b Edit the CONTROL_FILES parameter in the Release 7 3 initialization file for the instance that is ORACLE_HOME DATABASE INITsid ORA to reflect the changes to the filename Note
125. files for the instance To get a list of these files for the instance a Run Server Manager in line mode b Enter the following at the Server Manager prompt SVRMGR gt connect system lt account password for the instance gt SVRMGR gt spool migrate log SVRMGR gt select member from vSlogfile SVRMGR gt select name from vSdatafile SVRMGR gt select value from vSparameter where name control_files 2 Shut down your Oracle7 database At the SVRMGR prompt enter the following svavcr gt connect internal SVRMGR gt shutdown SVRMGR gt exit 3 Shut down and delete Oracle services Shutdown and delete Oracle services belonging to the earlier database version using orasrv exe for Version 7 0 oradim71 exe for Version 7 1 oradim72 exe for Version 7 2 Example oradim71 delete srvc lt Oracle Service Name gt Note This stops and deletes the service 4 Backup the 7 0 7 1 7 2 database For more information on backing up your database see your database documentation 5 De install the 7 0 7 1 7 2 server RSFs and Utilities Installing Oracle7 Server for WindowsNT 2 25 Use orainst exe to de install 7 0 7 1 7 2 Server Required Support Files and Utilities Refer to the documentation that shipped with your 7 0 7 1 7 2 database for more information about de installation Warning Do not remove the 7 0 7 1 7 2 database files when prompted Warning After installing Release 7 3
126. g additional languages You can also set NLS for an individual instance using several parameters in the initialization parameter file NLS Language Support in this Guide contains information about installing additional languages Note The default language English is installed with every Oracle7 Server for Windows NT in addition to any other language you select c Specify a company name and Oracle Home location then choose OK The Software Asset Manager window appears Notice that the Software Asset Manager dialog box contains the following buttons Exit Closes the Software Asset Manager and exits Oracle Installer Options Allows you to do the following request for confirmations before removing or installing products receive detailed messages and prompts during various phases of Oracle Install er s function record the actions being performed by the Oracle Installer in a log file View Log Allows you to view the Event Log The Event Log displays installation and con figuration events in the Description Level you choose Summary Brief and De tail You can store and retrieve logs and save them to files By default log files are stored in 3ORACLE_HOME ORAINST ORAINST LOG Ifa log file from a previous logging exists it is renamed to ORAINST OLG If you want to keep more than two log files LOG and OLG you must rename the OLG file so that it is not overwritten Restore Icons All
127. ges later in this appendix for installation information Territory and Character Set Defaults The following table lists the default territories and character sets for each of the languages supported by Oracle7 Server for Windows NT F 2 Oracle7 Server Getting Started for Windows NT Language Territory Ch arset AMERICAN ARABIC BRAZILIAN PORTUGUESE BULGARIAN CANADIAN FRENCH CATALAN CROATIAN CZECH DANISH DUTCH EGYPTIAN ENGLISH ESTONIAN FINNISH FRENCH GERMAN GERMAN DIN GREEK HEBREW HUNGARIAN ICELANDIC ITALIAN JAPANESE KOREAN LATIN AMERICAN SPANISH LITHUANIAN MEXICAN SPANISH NORWEGIAN POLISH PORTUGUESE ROMANIAN RUSSIAN SIMPLIFIED CHINESE SLOVAK SPANISH SWEDISH THAI TRADITIONAL CHINESE TURKISH UKRAINIAN AMERICA UNITED ARAB EMIRATES BRAZIL BULGARIA CANADA CATALONIA CROATIA CZECH REPUBLIC DENMARK THE NETHERLANDS EGYPT UNITED KINGDOM ESTONIA FINLAND FRANCE GERMANY GERMANY GREECE SRAEL HUNGARY CELAND TALY APAN OREA AMERICA LITHUANIA MEXICO NORWAY POLAND PORTUGAL ROMANIA CIS CHINA CZECHOSLOVAKIA SPAIN SWEDEN THAILAND TAIWAN TURKEY UKRAINE National Language Support US7ASCII ARSI WE8ISO8859P CL8ISO8859P5 WES8ISO8859P WES8ISO8859P EE8ISO8859P2 EE8ISO8859P2 WES WES ARSI WES WESISO8859P WES WES WES WES ZHS WESISO8859P WESISO8859P A16EUC KO16KSC5601 WESISO8859P EE8ISO8859P4 WESISO8859P WESIS
128. guration parameter 2 20 introduction F 2 territory amp character set defaults F 2 NLS_LANG parameter D 3 F 1 F 8 alternate character sets F 4 alternate territories F 4 default values F 2 format F 2 Index 7 NLS_LANGUAGE parameter C 4 NLS_SORT parameter C 4 F 5 NLS_TERRITORY parameter C 4 NMP_FREE_ CLIENTS parameter D 8 NMP_MAX_CLIENTS parameter D 7 NMP_MIN_CLIENTS parameter D 8 NMP_SPAWN_DELAY parameter D 9 no password found E 18 no password given E 18 no pid structure supplied to spder E 14 NOARCHIVELOG mode 5 2 NOARCHIVELOG parameter 3 10 Nonclustered tables 3 20 O OCOPY utility 5 2 OCOPYnn R a restore_dir 5 3 Online Documentation definition of 1 10 Online documentation A 2 OPEN_CURSORS parameter C 5 OpenProcess failure unable to open process handle E 15 operating system roles are not supported 8 Operating systems DOS 2 9 Windows NT 2 9 OPS 4 7 tion Parallel Query 2 9 Spatial Data 2 9 WebServer 1 4 option specified file already exists E 11 Options Advanced Replication 1 4 2 9 Distributed 1 3 2 9 removing 2 23 server 2 9 ORA 09352 3 5 3 18 ORA_ENCRYPT_LOGIN 4 6 ORA_SQLDBA_MODE parameter D 5 Index 8 Oracle7 Server Getting Started for Windows NT NMP_SPAWN_INCREMENT parameter D 8 ORA_SQLDBA_TERM parameter D
129. he Oracle7 RDBMS instance on the host machine The value of this parameter is system identifier SID for the database ORA_sid_PWFILE Operating System Windows NT Default none Legal Values any legal filename This parameter specifies the name of the password file containing the password for the database designated by the system identifier sid ORA_SVRMGR_MODE Operating System Windows NT Default SCREEN Legal Values LINE SCREEN Configuration Parameters and the Windows NT Registry D 5 ORA_SVRMGR_TERM PLSQLnn RDBMSnn This parameter specifies the mode in which Server Manager starts from the command line Operating System Windows NT Default none Legal Values any valid terminal name such as BIOS BIOSM This parameter specifies the default terminal mapping to use in Server Manager Note The suffix M indicates monochrome Operating System Windows NT Default none Legal Values any valid path This parameter specifies the directory in which Oracle7 Server for Windows NT looks for PL SQL message files Although it has no default the Oracle7 Server for Windows NT installation process sets the parameter as ORACLE HOME PLSQLnn where nn indicates the version of PL SQL being used Operating System Windows NT Default none Legal Values any valid path This parameter defines the directory in which the Oracle7 Server for Windows NT database files are located Oracle7 Server for Windows NT
130. hrough a two task driver Oracle7 Server Directory Structures B 5 B 6 Oracle7 Server Getting Started for Windows NT Initialization Parameter Files APPENDIX O racle7 Server for Windows NT uses initialization parameters to determine various features of the database every time an instance is started This appendix e describes initialization parameter files e specifies the parameters you need to set at the time you create a database e lists default values and valid ranges for parameters that have special characteristics under Windows NT Additional Information For a complete list and descriptions of all initialization parameters see Oracle7 Server Administrator s Guide Initialization Parameter Files C 1 What Is an Initialization Parameter File An initialization parameter file is an ASCII text file containing a list of parameters Every instance has a corresponding initialization parameter file and ORACLE_SID parameter The initialization parameter filenames take the form INIT sid ORA where sid is the name of the instance For example the initialization parameter file for the initial database is named INITORCL ORA because the initial database SID is ORCL A single instance might also have several initialization parameter files each having some differences to affect system performance and so forth ome initialization parameter file can be found in the Oracle7 Server Admin Administrator s Guide Guide
131. ich you plan to install the Oracle7 Server for Windows NT exists and has enough disk space see System Requirements in this Chapter Choose a volume with a dedicated disk drive if possible 7 Server for Windows NT If you are re installing Oracle7 Server for Windows NT over a previous release of Oracle7 Server shut down the database and back up all database files Note Oracle7 Server for Windows NT cannot run simultaneously with previous releases Ensure that earlier versions are not running before you install or run Oracle7 Server for Windows NT Oracle Installer detects previous Oracle7 Server installations Oracle Installer attempts to use the same volumes company name and language when installing Oracle7 Server for Windows NT You can accept the default information provided by Oracle Installer or provide new information Note You will receive an error message during installation if your Windows NT server previously contained Oracle products and the volume containing those products no longer exists To complete the installation delete the ORACLE_HOME line from the Windows NT Registry and rerun Oracle Installer Additional Information For information on migrating data see Migrating from Earlier Releases later in this chapter Co existence of Oracle7 Server for Windows NT and Oracle7 Workgroup Server Oracle7 Server for Windows NT and Oracle7 Workgroup Server for Windows NT cannot co exist Installing Oracle7 Server for
132. ick OK to dismiss the notification The Software Asset Manager window reappears Exit Oracle Installer by clicking on the Exit button and confirm your exit when prompted Installing Oracle7 Server for WindowsNT 2 15 If you choose Selective a Choose Selective Product Install in the Software Asset Manager You can view the products in this package by double clicking on the product s displaying a plus sign to their left Click the Install button The Selective Product Install dialog box appears Select the products you want to install Click the OK button Answer questions and make choices in the dialog boxes that appear An Oracle dialog box appears displaying the progress of the installation After the product s are installed you will be prompted to read the Release Notes for the latest information Note The questions dialog boxes that appear will vary depending upon the product choices you make Click OK to dismiss the notification The Software Asset Manager window reappears Exit Oracle Installer by clicking the Exit button and confirm your exit when prompted Installation Types Windows Windows 95 Clients Oracle7 Client This section describes Oracle7 Client Oracle Documentation and Selective installation procedures for clients This release of Oracle7 Server for Windows NT offers three types of Windows Windows 95 client installations listed below Install your choice of e Application Use
133. ier in this chapter Oracle Installer starts 2 Double click on Selective Product Install in the Products available on field in the Software Asset Manager window The items in Selective Product Install appear 3 Double click on Oracle7 Server Options The items in Oracle7 Server for Windows NT Options appear 4 Choose the option s you want to install 5 Click the Install button An Option License dialog box for each selected option appears asking if you are licensed for the selected options 6 Click Yes if you are licensed If you are not licensed contact Oracle to purchase a license The installation process begins After installation is complete the Software Asset Manager reappears 7 Exit Oracle Installer by clicking the Exit button and confirm your exit when prompted Removing Oracle7 Products Options To de install Oracle7 products or Options run Oracle Installer for Windows NT 1 Select from the Installed Products window the product s you want to remove Installing Oracle7 Server for WindowsNT 2 23 2 Choose Remove Oracle Installer warns you of any product dependencies that might cause problems if particular products are removed and prompts you to confirm the de installation Migrating from Earlier Releases Overview This section contains instructions for migrating databases created using earlier versions of Oracle7 Server for Windows NT If you currently have data stored in one of the fo
134. ing system This topics are covered in this chapter e Oracle7 and the Windows NT Performance Monitor e Oracle7 Event Viewer e database security e starting services automatically e using Windows NT OS authentication Getting the Most out of Integration with Windows NT 4 1 Oracle7 and the Windows NT Performance Monitor Oracle7 Server for Windows NT takes advantage of the Windows NT Performance Monitor to help you keep track of and measure the performance of your database The following descriptions include Oracle specific information about Performance Monitor e If no data or Oracle objects appear either the database is down or an invalid host string or password has been entered If the database is down exit Performance Monitor start the database and restart Performance Monitor e See operf 1log located in ORANT DBS for information on the status of the Oracle Performance Monitor All Oracle specific items that can be monitored through Performance Monitor begin with Oracle7 Additional Information For more information on the A Windows NT Performance Monitor see your operating system documentation The following information is located in the Windows NT Registry After running regedt32 the information is located in HKEY_LOCAL_MACHINE SYSTEM CURRENT_CONTROL_SET SERVICES ORACLE7 PERFORMANCE Value Name Perf_File_Name REG_EXPAN SORACLE_HOME DBS PERF ORA Library REG_EXPAN operfdll dll Open REG_EXPAN OpenOracl
135. ions 3 19 C gt OCOPYnn B C a 5 4 C gt OCOPYnn B open_file a 5 3 C gt OCOPYnn R a c 5 4 C gt OCOPYnn C new_file 5 4 C gt OCOPYnn new_file c 5 4 C gt OCOPYnn old_file new_file 5 2 C gt REGEDT32 D 2 C gt SET parameter_name parameter_value D 2 C gt SVRMGR73 MODE LINE 3 16 C ORANT 2 12 C ORAWIN 2 20 C ORAWINS5 2 20 catalog sql 3 7 CATALOG SOQL script 3 18 CATPROC SQL script 3 18 catproc sql 3 8 CD ROM and online documentation A 2 Index 2 Oracle7 Server Getting Started for Windows NT device driver 2 3 CD ROM drive 2 2 2 3 CHANGE_ON_INSTALL password 3 4 CHARACTER SET parameter 3 10 CHARACTER SET C 3 CKPT D 4 CLASS high DEF time_critical D 5 Client defined 1 2 Client Software Online Documentation 1 10 Oracle Objects for OLE 1 10 SQL Plus 1 9 Client software Windows based 1 9 Clusters 3 20 Command CREATE DATABASE C 4 SHUTDOWN 3 16 command Server Manager CONNECT INTERNAL 1 7 COMMIT_POINT_STRENGTH parameter C 4 Communication protocols 1 11 Compaq 2 2 Configuration of SQL Net release 2 2 products 2 22 Configuration Parameters descriptions D 3 Configuration parameters B 1 B 8 D 1 D 8 defined D 2 editing D 2 editing at the command prompt D 2 editing in AUTOEXEC BAT D 2 general D 3 D 6 editing in the Windows NT regist
136. irectory under ORANT already exists If you now install Release 7 3 the Oracle Installer adds an RDBMS73 subdirectory The subdirectories of ORANT contain the files listed below For all versions of Oracle7 Server for Windows NT subsequent to 7 0 all DLL and EXE files and configuration variables have their version numbers appended This convention allows you to maintain multiple releases of these items for backward compatibility For example the Instance Manager executable for version 7 1 is ORADIM71 EXE the executable for Release 7 3 is ORADIM73 EXE Oracle7 Server Getting Started for Windows NT Directory Structure ORANT BIN EI DATABASE L ARCHIVE E DBS EI NETWORK EI ADMIN EI CFG EI ERROR LOG EI TRACE fo NLSRTLnn L DATA E ORAINST E ows10 EI ADMBIN EI ADMDOC EI ADMIN BIN E3 DEMO E DOC E IMG EI LOG E PLSQLnn fo PROnn E RDBMSnn EI ADMIN EI LOADER 0c EI TRACE Directory Name DATABASE RDBMS nn ADMIN RDBMSnn LOADER RDBMS nn TRACE RDBMSnn OCI DATABASE DBS NETWORK NETWORK ADMIN NETWORK LOG NETWORK TRACE NLSRTLnn ORAINST Ows10 PLSQLnn PROnn RDBMSnn Directory Contents executable DLL icon and library files such as the Oracle7 RDBMS Server Manager SQL Net and Utilities Oracle7 RDBMS database password and initialization files Oracle7 RDBMS SQL scripts Use SQL scripts to create data dictionary tables view
137. is error is similar to the LOCKING_VIOLATION message which relates to a portion of a file Release or terminate the other process or wait until it completes TOO_MANY_OPEN_FILES Cause Action WRITE_ERROR Cause Action Too many files are open on Windows NT Close some of the open files A problem has been detected on the destination media while executing an I O operation 1 If you are in a network environment and installing onto the network verify that you have permission to write to a network directory 2 Run a utility program to locate any problems with the source or destination media the media could be the CD ROM drive a network drive or a floppy drive E 4 Oracle7 Server Getting Started for Windows NT WRITE_PROTECTED Cause The file or directory specified in the full message in which Oracle software is to be installed is write protected Action Remove the write protection from the specified file or directory Codes 9200 9499 Oracle Database Messages The messages in this section are Oracle messages issued by the database Each one is triggered by an Oracle operating system dependent OSD message specific to Windows NT specifying the error condition signal The OSD messages appear in the next section When you receive one of these messages look up the accompanying OSD message number in the following section for an explanation of the error ORA 09200 sfccf error creating file
138. ist of valid OS roles E 8 szrpc unable to verify password for role E 8 T Table snapshots refreshing 5 6 Tables 3 20 TRANSACTIONS_PER_ROLLBACK_SEGME NT parameter C 5 translations nested too deep E 17 Transport protocol and the MultiProtocol Interchange 1 11 multiple 1 12 TRIGGERS data dictionary table 5 10 truncated read E 10 truncated write E 10 TRWR D 4 U unable to access the specified directory or device E 12 unable to acquire internal semaphore for process E 16 unable to allocate memory with VirtualAlloc E 13 unable to attach to SGA SGA does not exist E 13 unable to begin another thread E 14 unable to close file E 11 unable to deallocate memory with VirtualFree E 13 Unable to find file handle for that thread E 16 unable to get date and time from the operating system E 18 unable to map shared memory SGA into the address space E 13 unable to open file E 9 unable to open the specified RAW device E 12 unable to open create file for shared memory object E 13 unable to protect memory with VirtualProtect E 13 unable to read complete record from data file E 16 unable to read file header block E 10 unable to read line from file E 11 unable to set eof file marker E 12 unable to set file pointer E 12 unable to spawn process via system E 17 unable to translate the USERNAME configurati
139. ive files e backing up RAW files e restoring RAW files Additional Information See Oracle7 Server Administrator s R Guide for a detailed discussion of backing up the database Admin Guide Backing Up Active Files Use OCOPY two ways The first way is to copy the open file to another name and location on a hard disk where an archive utility can back it up The syntax for using OCOPY in this way is C gt OCOPYnn old_file new_file 5 2 Oracle7 Server Getting Started for Windows NT Restoring Active Files where nn indicates the version of OCOPY Release 7 3 or later old_file specifies the name and location of the open file you want to back up and new_file specifies the name and location for the backup copy Note OCOPY also accepts two other optional command line options a and size_1 size_n These command line options should not be used to make backups of database files OCOPY can also back up large open files directly to multiple diskettes Use OCOPY with the B option to split large files over multiple diskettes OCOPY also reconstructs the parts of a file that have been split over multiple diskettes if the backup copy must be restored to the hard disk The syntax for using OCOPY with the B option is C gt OCOPYnn B open_file a where open_file specifies the path and filename of the open file you want to back up and a specifies the diskette drive containing the diskette on which the backup copy should be saved
140. k the file for errors Note cat rep may take an hour or more to run 7 0 15 to 7 3 7 1 3 to 7 3 7 2 2 to 7 3 SVRMGR gt RDBMS73 ADMIN catproc SVRMGR gt RDBMS73 ADMIN catproc SVRMGR gt RDBMS73 ADMIN catproc SVRMGR gt RDBMS73 ADMIN catrep SVRMGR gt RDBMS73 ADMIN catrep SVRMGR gt RDBMS73 ADMIN catrep b Rerun utlxplan sql in any schema in which you want to use EXPLAIN PLAN Shut down and restart the database Your Oracle database is now migrated to Release 7 3 Shutdown and restart by entering the following commands at the Server Manager prompt SVRMGR gt shutdown SVRMGR gt startup Installing Oracle7 Server for WindowsNT 2 31 2 32 Oracle7 Server Getting Started for Windows NT CHAPTER Using Oracle7 Server for Windows NT T his chapter describes how to set up and use the Oracle7 Server for Windows NT Among the topics discussed in this chapter are overview of database administration tasks Oracle services Instance Manager starting a database Instance Manager command line commands creating an instance starting an instance running multiple instances creating a new database creating database objects setting resource costs using the Oracle7 Server Utilities Using Oracle7 Server for Windows NT Overview of Database Administration Tasks What is an Instance The Starter Database This section introduces you to the starter database installed during the Oracle7 Server for Win
141. le7 Server Tuning Object Oracle7 Data Dictionary Cache The Data Dictionary Cache object contains one counter the get misses gets percentage counter This value is not time derived For frequently accessed dictionary caches the value of this counter should be less than 10 15 If the ratio continues to increase above this threshold while your application is running increase the amount of memory available to the data dictionary cache See Reducing Data Dictionary Cache Misses in Oracle7 Server Tuning Object Oracle7 Buffer Cache The Buffer Cache object contains one counter the phyreads gets percentage counter This value is not time derived If the Miss counter is high higher than 30 40 increase the number of buffers in the cache to improve performance See Reducing Buffer Cache Misses in Oracle7 Server Tuning Getting the Most out of Integration with Windows NT 4 3 Tuning I O Tuning Contention Note The percentage is calculated as a Miss ratio Reducing Buffer Cache Misses expresses the calculation as a High ratio Object Oracle7 Data Files The Data Files object contains two counters per data file instance the phyrds sec and phywrts sec counters These values are time derived See Reducing Disk Contention in Oracle7 Server Tuning Object Oracle7 Dynamic Space Management The Dynamic Space Management object contains one counter the recursive calls per second counter If Oracle7 makes excess recu
142. les C 5 C 6 Oracle7 Server Getting Started for Windows NT APPENDIX Configuration Parameters and the Windows NT Registry T he Windows NT Registry stores the Oracle configuration parameters This appendix describes only the configuration parameters applying to your Oracle7 Server for Windows NT and SQL Net listener service Configuration Parameters and the Windows NT Registry D 1 About Configuration Parameters Oracle software uses configuration parameters to locate files and specify runtime parameters common to all Oracle products When an Oracle program or application requires a translation for a particular configuration variable the Oracle7 Server for Windows NT consults the associated parameter Editing Configuration Parameters D 2 You can set configuration parameters on your Windows NT Server machine three ways In the Windows NT Registry Oracle configuration parameters are stored in HKEY_LOCAL_MACHINE SOFTWARE ORACLE You can modify the values stored in this key by running the registry editor program REGEDT32 included with your Windows NT software To access the Oracle configuration parameters in the Windows NT Registry type the following C gt REGEDT32 In the AUTOEXEC BAT file The syntax for setting any configuration parameter in your AUTOEXEC BAT file is SET PARAMETER_NAME PARAMETER_VALUE where parameter_name is the name of the parameter and paramet
143. llowing e Oracle7 Server for Windows NT database Versions 7 0 7 1 or 7 2 OR e Oracle7 Workgroup Server for Windows NT Versions 7 0 7 1 or 7 2 you must migrate your database to make it work with Oracle7 Server for Windows NT This section describes procedures for migrating your earlier Oracle7 Server version s to Release 7 3 Use this procedure for migrating earlier Oracle7 Server versions to Release 7 3 It includes the following tasks and example e preparing for migration e installing the Oracle7 Server for Windows NT e moving database files Prepare for the Migration Before migrating to Release 7 3 make sure you have at least 8MB of free space in the system tablespace You can verify the amount of free space in the SYSTEM tablespace using this SOL statement select sum A blocks B value from sys dba_free_space A sys VSparameter B where A tablespace_name SYSTEM and B value db_block_size If 8MB of free space is not available in the SYSTEM tablespace you can enlarge the SYSTEM tablespace by adding a datafile of the appropriate 2 24 Oracle7 Server Getting Started for Windows NT size for example the following SQL statement adds an 8MB file to the SYSTEM tablespace alter tablespace SYSTEM add datafile lt directory for the file gt lt filename gt size 8M 1 List files for the instance For each instance you want to migrate make a list of the control data and log
144. mation about the Oracle7 RDBMS in general see Oracle7 Server Concepts and other documentation included in your package Feature Highlights This release of Oracle7 Server for Windows NT includes the following features Distributed Option separately licensable feature Distributed Option is a system for distributing data in your database s across multiple machines Additionally the processing of your data can be distributed among multiple machines Additional Information For more information about the A Distributed Option see Oracle7 Server Distributed Systems Distributed Option Introducing Oracle7 Server for Windows NT 1 3 Oracle SDO Oracle Oracle7 Server Tuning Oracle Oracle Enterprise Manager e Oracle WebServer z User s Guide Oracle Advanced Replication 1 4 Volume I Distributed Data Oracle7 Server Concepts Oracle7 Server Administrator s Guide and other appropriate documentation included online with your product Spatial Data Option separately licensable feature The Spatial Data Option enables you to store spatial data within the relational database model Additional Information For more information on the Spatial Data Option see Spatial Data Option Application Developer s Guide Spatial Data Option Reference and Administrator s Guide and Spatial Data Option Overview Parallel Query Option separately licensable feature With the parallel query option
145. meters See also Oracle7 Server Administrator s Guide 8 Optional Use a text editor to create a SQL script containing the CREATE DATABASE statement A SQL script is a file containing SQL commands just as you would type them in Server Manager Using a SQL script makes it easier to edit and verify the SQL statement required for creating a new database Use the following syntax for the CREATE DATABASE statement CREATE DATABASE database_name CONTROLFILE REUSE LOGFILE filespec filespec AXLOGFILES integer AXLOGMEMBERS integer DATAFILE filespec filespec AXDATAFILES integer ARCHIVELOG NOARCHIVELOG EXCLUSIVE CHARACTER SET name ISF Attention If you assigned a value to the DB_NAME initialization parameter in the INITsid ORA file be sure you use the same value for the database_name parameter in the CREATE DATABASE statement The CREATE DATABASE parameters are described in Chapter 3 Additional Information The remaining parameters in the cut CREATE DATABASE statement are described in Oracle7 Server SQL Ref SQL Reference Using Oracle7 Server for Windows NT 3 17 Starting an Instance and Creating the Database 3 18 Follow these steps to create a new database 1 Start the instance with the Instance Manager or follow the instructions in the Oracle Service section earlier in this chapter Set the Oracle SID
146. ministrators Group To install and run Oracle7 Server for Windows NT you must have the required hardware and software Oracle7 Server for Windows NT Hardware Oracle7 Server for Windows NT requires an IBM Compaq or 100 compatible PC based on an 80486 or higher or Pentium processor Multiprocessor machines are also supported The following components must be part of the system e RAM 32 MB recommended e Available disk space 65 MB of free hard disk space 100MB if you want to install all of the online documentation onto your hard drive e a compatible network interface card NIC for networked operation e a connected CD ROM drive functioning as a logical drive Advanced Replication Option Hardware Oracle7 Server for Windows NT with the Advanced Replication Option requires an IBM Compaq or 100 compatible PC based on an 80486 or higher or Pentium processor Multiprocessor machines are also supported The following components must be part of the system e RAM a minimum of 32 MB 2 2 Oracle7 Server Getting Started for Windows NT e Available disk space 90 MB of free hard disk space 125 MB if you want to install all of the online documentation onto your hard drive e a compatible network interface card NIC for networked operation e a connected CD ROM drive functioning as a logical drive Software Oracle7 Server for Windows NT requires the following software e Microsoft Windows NT Workstation Version
147. mmer s Guide to the Oracle Pro C Precompiler Comprehensive user s guide and on the job reference to the Oracle Pro C C Precompiler release 2 1 It shows you how to use the database language SQL and Oracle s procedural extension PL SQL in conjunction with Pro C to manipulate data in an Oracle7 database It explores a full range of topics from underlying concepts to advanced programming techniques and uses hands on examples to teach you all you need to know Pro COBOL Supplement to the Oracle Precompilers Release 1 7 Shows you how to write COBOL programs that use the powerful database language SQL to access and manipulate Oracle data It provides easy to follow examples instructions and programming tips as well as several full length programs to enhance your understanding and demonstrate the usefulness of embedded SQL Oracle Network Products Messages Manual A 10 Provides information required to understand and use the problem resolution facilities of the following Oracle network products e SQL Net version 2 0 and later e MultiProtocol Interchange e Oracle Protocol Adapters e Oracle Network Manager e Oracle Names e Secure Network Services e Oracle Native Naming Adapters In particular this Guide e provides an overview of messages error logs and trace facilities e describes how to use the error logs and trace facilities e describes how to configure the client server Interchange listener and Names server comp
148. mmunication software that offers transparent operation to Oracle tools or databases over any type of network protocol and operating system Oracle Database Tools are a suite of powerful easy to use graphical database management tools Server Utilities that help you complete database tasks efficiently Oracle Database Tools include Database Manager User Manager Object Manager Session Manager Database Expander Import Export and SQL Loader Oracle7 Server Utilities are included in the server software of your Oracle7 Server for Windows NT package Oracle7 Server Utilities include Backup Manager Recovery Manager Server Manager Import Export and SQL Loader all Windows NT versions Additional Information For information on using the graphical database tools see the integrated online Help included with the Database Tools Oracle7 Server for Windows NT Overview Oracle7 Server for Windows NT is a full function Release 7 3 Oracle Relational Database Management System RDBMS Oracle7 Server for Windows NT runs on a personal computer PC that is part of a local area network LAN The server machine must be running Windows NT Version 3 51 This customized Windows NT version of the Oracle RDBMS operates in essentially the same manner as the Oracle RDBMS on other platforms Note This Guide describes only the features of the Oracle7 Server for Windows NT software that apply to the Windows NT operating system For infor
149. more detailed error information Note The Windows NT Event Viewer displays the same information contained in ALERT LOG omel Windows NT Event Viewer see your operating system documentation R Additional Information For more information on using the Database Security When a user on the Windows NT server machine on which the database is running attempts to connect to a database as INTERNAL Oracle7 Server for Windows NT verifies if the database can be accessed without a password The database can be accessed without a password if at least one of the following conditions is true e the Windows NT Registry key for the environment variable DBA_AUTHORIZATION is set to BYPASS e the Windows NT Registry key for the environment variable DBA_sid_AUTHORIZATION is set to BYPASS where sid is the SID of the current instance Additional Information See Configuration Parameters and the NT Registry in this Guide for details on configuration parameters and the Windows NT Registry If either of the above conditions is true the database connection is considered secure that is accessible and Oracle7 Server for Windows NT allows the user to connect to the database without a password If neither of these conditions is true or if the user is not on the same machine as the Oracle7 Server for Windows NT Oracle7 determines the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter and proceeds as follows e REMOTE_LOGIN_PASSWORD
150. n Roadmap APPENDIX T his appendix describes the documentation set included in your package It covers the following topics e documentation catalog e using the documentation e roadmap e documentation sets Note Documentation may be included in your package detailing products that you did not buy license Documentation Roadmap A 1 Documentation Catalog A 2 The following table lists the online documentation included with your Oracle7 Server for Windows NT package The documentation is in Adobe Acrobat format You can install the Adobe Acrobat files onto your hard drive or leave them on the CD ROM At the end of server installation you will be prompted to install Adobe Acrobat using the Adobe installer included Product Name Product Documentation Oracle7 Server for Windows NT Oracle7 Server Getting Started for Windows NT Oracle7 Server for Windows NT Getting Started Oracle7 Server Concepts Oracle7 Server Administrator s Guide Oracle7 Server Applications Developer s Guide Oracle7 Server SQL Reference Oracle7 Server Reference Oracle7 Server Utilities Oracle7 Server Messages Oracle7 Server Migration PL SQL User s Guide and Reference Oracle7 Server Distributed Systems Volume I Distributed Data Oracle7 Server Distributed Systems Volume II Replicated Data Programmer s Guide to the Oracle Call Interface Oracle7 Parallel Server Concepts and Administration Oracle7 Server SQL Reference Oracle7 Ser
151. n the usage of the following parameters AMERICAN ARABIC BRAZILIAN PORTUGUESE BULGARIAN CANADIAN FRENCH CATALAN CROATIAN CZECH DANISH DUTCH EGYPTIAN ENGLISH ESTONIAN FINNISH FRENCH GERMAN GERMAN DIN GREEK HEBREW HUNGARIAN CELANDIC TALIAN APANESE OREAN LATIN AMERICAN SPANISH LITHUANIAN MEXICAN SPANISH NORWEGIAN POLISH PORTUGUESE ROMANIAN RUSSIAN SIMPLIFIED CHINESE SLOVAK SPANISH SWEDISH THAI TRADITIONAL CHINESE TURKISH UKRAINIAN National Language Support F 5 Territories F 6 Oracle7 Server Getting Started for Windows NT ALGERIA AMERICA AUSTRIA BAHRAIN BRAZIL BULGARIA CANADA CATALONIA CHINA CIS CROATIA CZECH REPUBLIC CZECHOSLOVAKIA DENMARK DJIBOUTI EGYPT ESTONIA FINLAND FRANCE GERMANY GREECE HONG KONG HUNGARY ICELAND IRAQ ISRAEL ITALY JAPAN JORDAN KOREA KUWAIT LEBANON LIBYA LITHUANIA MAURITANIA MEXICO MOROCCO NORWAY OMAN POLAND PORTUGAL QATAR ROMANIA SAUDI ARABIA SLOVAKIA SLOVENIA SOMALIA SPAIN SUDAN SWEDEN SWITZERLAND SYRIA THAILAND TAIWAN THE NETHERLANDS TUNISIA TURKEY UKRAINE UNITED ARAB EMIRATES UNITED KINGDOM YEMEN Single byte Character Sets R7AMEER R7ASMO449PLUS R7SEDCOT R8ADOS710 R8ADOS710T R8ADOS720 R8ADOS720T R8APTEC715 R8APTEC715T R8SARABICMAC R8SARABICMACS R8ASMO708PLUS R7ASMO449PLUS R8ASMO8X R8EBCDICX R8SHPARABIC8T R8ISO8859P6 R8SMSWIN1256 R8SMUSSAD768 R8SMUSSAD768T R
152. nded Value SNAPSHOT_REFRESH_ PROCESSES 2 SNAPSHOT_REFRESH_INTERVAL 60 seconds SNAPSHOT_REFRESH_KEEP CONNECTIONS FALSE Setup Procedures After setting up the INITsid ORA file with the initialization parameters for Advanced Replication run SVRMGR23 Connect as INTERNAL password and start the database Once the database has started execute the script CATREP SQL The script can be found in the Y ORACLE _HOME RDBMS73 ADMIN directory It will take approximately one hour to run A good idea is to spool to a log file first before running CATREP Database Administration 5 9 Other Notes To confirm that CATREP ran correctly run a query on ALL_OBJECTS where STATUS INVALID ie SELECT FROM ALL_OBJECTS WHERE STATUS INVALID If you find that any of the package bodies ran incorrectly rerun them manually Here is the syntax for running them manually ALTER PACKAGE lt package name gt COMPILE BODY If CATREP SQL has run successfully a number of replication tables are made in the SYSTEM subdirectory The database is now set up for Advanced Replication Refer to the Oracle7 Server Distributed Systems Volume II Replicated Data documentation for details on setting up a Master Definition Site Master Sites Updatable Snapshot Sites and Conflict Resolution i gt Attention Execute the following statement on the master site when setting up updatable snapshot sites GRANT EXECUTE ON DBMSOBJGWRAPPER TO PUBLIC
153. ng information specific to the Oracle7 Server for Windows NT environment It includes frequent references to the location in other Oracle7 Server documents of additional sources of information on topics discussed in this Guide Oracle7 Server Concepts describes the essential concepts behind an Oracle database server Users new to Oracle products should refer to this document before installing Oracle7 Server for Windows NT Preface v Installation Database Administration Server Utilities Database Tools Troubleshooting Release Notes See Installing Oracle7 Server for Windows NT of this Guide and the accompanying Release Notes to answer questions regarding Oracle7 Server for Windows NT installation This Guide contains information about database administration on Windows NT systems Oracle7 Server Administrator s Guide contains information on Oracle7 Server database administration not specific to Windows NT Oracle7 Server Utilities contains detailed generic information on the utilities included with your Oracle7 Server for Windows NT package and their use See the chapters on setting up and operating Oracle7 Server for Windows NT of this Guide for Windows NT specific 32 bit information on these utilities Detailed information on the GUI based database tools is included as online Help These tools can be used from a Windows platform or through Windows on a Win32 WOW subsystem Oracle7 Server Messages contains a c
154. nsult the Windows NT documentation ReadFile failure unable to read from file There was an unexpected return from the Windows NT system service Read File Check the operating system error code and consult the Windows NT documentation truncated read The system encountered an unexpected end of file which is due to damaged media Verify that the file is not damaged WriteFile failure unable to write to file There was an unexpected return from the Windows NT system service WriteFile Check the operating system error code and consult the Windows NT documentation truncated write The destination device is full or the media is damaged Verify that the device has free space and the file is not damaged Oracle7 Server Getting Started for Windows NT OSD 04010 Cause Action OSD 04011 Cause Action OSD 04012 Cause Action OSD 04013 Cause Action OSD 04014 Cause Action OSD 04015 Cause Action OSD 04016 Cause Action option specified file already exists The file that you attempted to create already exists Delete the existing file or use the REUSE option in the SQL statement GetFileInformationByHandle failure unable to obtain file info There was an unexpected return from the Windows NT system service GetFileInformationByHandle Check the operating system error code and consult the Windows NT documentation file size mismatch The file to be reused is either too
155. nts are automatically created for the starter database SYS and SYSTEM administrator usernames with CONNECT RESOURCE and DBA roles for the database The password for the SYS username is CHANGE_ON_INSTALL The SYSTEM password is MANAGER username with CONNECT and RESOURCE roles for the database The SCOTT username has the password TIGER 3 4 Oracle7 Server Getting Started for Windows NT Oracle Services When you start or reboot the server machine Oracle services are started Depending on the networking protocol used these services are e OracleServiceORCL e OracleTNSListener lt id gt e OracleStartORCL If any of these services does not start correctly and you attempt to use any of the Oracle Database Tools the following message appears DBA 00314 unable to attach to default host ORA 09352 Windows 32 bit Two Task driver unable to spawn new ORACLE task Start the services following these steps 1 Open the Windows NT Control Panel 2 Choose Services 3 Find OracleServiceORCL in the list and verify that its status is Started If OracleServiceORCL is not started select it and choose Start 4 Find OracleTNSListenerORCL and verify that its status is Started Note You must complete steps 3 and 4 in order Note To start Oracle services whenever the server starts choose the Startup button and choose Manual Startup Type If you cannot find these service names in the list use Instance
156. ocation of Initialization Parameter Files C 2 Editing Initialization Parameter Files C 2 The Sample Initialization Parameter File C 2 Parameters to Modify when Creating a New Database C 3 Initialization Parameters 0 00 cee eee eee C 4 Configuration Parameters and the Windows NT Registry D 1 About Configuration Parameters 0000 e eee eee D 2 Editing Configuration Parameters sasse e ee eee D 2 Configuration Parameter Descriptions 44 D 3 General Parameters 06c0 cei bie ee ek Wee dei D 3 Networking Parameters 0 cece eee eee eee D 7 xii Oracle7 Server Getting Started for Windows NT Appendix E Messages and Codes ccc cece cece e cece eee eeees E 1 Logging Error Messages 60 c cece cece eee eens E 2 Installer Error Messages 0 00 6 66 E 2 Codes 9200 9499 Oracle Database Messages E 5 Codes 4000 4999 Windows NT Specific Oracle Messages E 9 File I O Errors OSD 4000 to OSD 4099 E 9 Memory Errors OSD 4100 to OSD 4199 E 12 Process Errors OSD 4200 to OSD 4299 0 E 14 Loader Errors OSD 4300 to OSD 4399 E 16 Semaphore Errors OSD 4400 to OSD 4499 E 16 Miscellaneous Errors OSD 4500 to OSD 4599 E 17 Codes 6100 6199 SOL Net TCP IP Errors E 19 Codes 6220
157. oducts that you install Directory Structure Directory Name Directory Contents executable DLL and batch files for the Oracle Windows tools and m ORAWIN the SQL Net networking software E BIN NETWORK various configuration files associated with SQL Net and the Oracle 6 NETWORK protocol adapters The NETWORK directory also contains the three E H LS R T Lnn subdirectories described below a oO RAI H ST ETWORK ADMIN ora configuration files used by SQL Net V2 3 for Windows NT DBS Oracle Toolkit II message files and other utility files A PLUSnn ETWORK LOG log files placed here by default 7 PROnn CoO RDBMSnn E S RMGRon ee ORAINST files used by Oracle Installer ETWORK TRACE trace files placed here by default loadable NLS files PLUSnn SQL Plus files PROnn Oracle7 RDBMS database password and initialization files RDBMSnn error message files relating to the Oracle7 Server SVRMGRnn Oracle Server Manager files B 4 Oracle7 Server Getting Started for Windows NT Oracle WebServer Installation Types Oracle WebServer 1 0 can be installed in one of two ways e Oracle WebServer 1 0 and Oracle7 database on a single machine e Oracle WebServer 1 0 and Oracle7 database on separate machines Single Machine Installation In a single machine installation Oracle WebServer and the Oracle7 database reside on the same machine Communications between the Oracle Web Agent and the Oracle7 Database Server are t
158. of these packages Configuration consists of creating and copying the information described below into two files File Description File Contents LISTENER ORA A listener configuration Listener ID file on the server This file defines information used by the listener to Database SID connect to a server Hostname for TCP IP TNSNAMES ORA A client configuration file Database alias on the server This file Database SID allows a server to Service_name connect to additional servers Additional Information See Understanding SQL Net for le complete descriptions of LISTENER ORA TNSNAMES ORA and the contents of each file See also Oracle Network Products User s Guide for your client s for more information about your networking products 2 22 Oracle7 Server Getting Started for Windows NT Additional SQL Net release 2 3 connections must be manually configured with the Oracle Network Manager See Oracle Network Manager Administrator s Guide for information Note Oracle7 Server for Windows NT licensing lets you use one release of SQL Net and one protocol adapter Use of more than one protocol and release of SQL Net is available at an added cost Separately Installing Oracle7 Options You may choose to install Oracle7 Options separately from other installation tasks or you may need to install these options after obtaining licenses for them In these cases follow these steps 1 Start Oracle Installer as noted earl
159. omize creation of new databases Note Remember that creating new databases is an advanced task The following table explains the parameters in the Advanced Parameters dialog box Using Oracle7 Server for Windows NT 3 9 Parameter Description LOGFILE filespec Specify the redo log filenames to be created and maintained If you omit this parameter Oracle7 creates two log files the minimum LOG1sid ORA and LOG2 sid ORA The default size of each log file is 50K there is no maximum size MAXLOGFILES integer Maximum number of redo log files the database will create 2 MAXLOGFILES are created by default The default value is 32 the range is 2 to 255 log files MAXLOGMEMBERS integer Maximum number of copies for a redo log file group Set this parameter if you plan to use multiplexed redo log files as discussed in the Oracle7 Server Administrator s Guide The default value is 2 the range is 2 to 5 log file copies MAXLOGHISTORY integer This parameter is not used with Oracle7 Server for Windows NT DATAFILE filespec Specify one or more database files to be created and maintained The default database files DBS1sid ORA of 6MB are stored in ORANT DATABASE filespec filespec defines the name size and location of redo log files and database files using the syntax d path filename SIZE integer K M where d path filename specifies the complete drive path and filename for the file Always enclose the path and filename in
160. omplete listing of Oracle7 Server error messages and codes For Oracle7 Server messages and codes specific to Windows NT operation see Messages and Codes in this Guide Release Notes contain information not available at the time the documentation was created See Release Notes for information about specific features and procedures vi Oracle7 Server Getting Started for Windows NT Conventions Used in this Guide Note these typographical conventions when reading this Guide Monospace text Punctuation UPPERCASE lowercase mono lowercase italics C gt DIRECTORY SID Type text exactly as shown Text typed for a command statement is not case sensitive unless noted otherwise Brackets enclose optional items or indicate a function key Do not enter the brackets A vertical bar represents an or option between several options You must enter only one of the options Do not enter the vertical bar Punctuation other than brackets and vertical bars must be entered in commands exactly as shown Uppercase characters within the text represent command names SQL reserved words and keywords and filenames Lowercase characters within command lines represent variables You should substitute an appropriate value for the variable In examples lowercase characters represent sample values for the variables Lowercase italics in the text represent variables You should substitute an appropriate value for the
161. on variable on server E 18 User accounts of starter database 3 4 SCOTT 3 4 SYS 3 4 SYSTEM 3 4 USER_DUMP_DEST initialization parameter 5 5 C 5 USRIORCL ORA 3 4 3 16 Utilities Oracle7 2 3 Oracle7 Server 3 21 3 28 Oracle7 Server Export 3 21 Oracle7 Server Import 3 21 Oracle7 Server SQL Loader 3 22 server based 1 8 V Visual Basic Microsoft 1 10 Volume creating 2 5 WwW WaitForSingleObject failure unable to obtain semaphore E 17 WebServer Option 1 4 Oracle home directory 2 2 for Windows B 1 B 4 for Windows 95 B 1 for Windows NT B 1 Windows NT 2 9 Windows NT COPY command 5 3 Windows NT Registry 1 6 2 5 D 1 Windows NT two task driver unable to allocate context area E 9 Windows NT two task driver unable to allocate shared memory E 9 Windows NT two task driver unable to open event semaphore E 9 Index 13 Windows NT two task driver unable to spawn Windows Windows 95 clients installation new Oracle task E 9 2 16 2 18 Windows NT two task driver Oracle task WRITE_ERROR E 4 unexpectedly died E 9 WRITE_PROTECTED E 5 Windows on Win32 WOW 2 4 WriteFile failure unable to write to file Windows products B 4 E 10 Index 14 Oracle7 Server Getting Started for Windows NT Reader s Comment Form Name of Document Oracle7 Server Getting Started for Windows NT Part No A42396 1 Oracle Corp
162. onents to invoke the trace facility lists all the Oracle network product error messages and their probable causes and provides the actions recommended to correct them Oracle7 Server Getting Started for Windows NT Understanding SQL Net Provides the information you need to understand and use SQL Net Release 2 3 This guide describes or provides e an overview of SOL Net e a detailed description of the SQL Net Release 2 3 architecture e what to consider when upgrading from earlier versions e how to use the network listener e how to use a SQL Net version 2 client e important concepts about using externally identified logins e a description of SQL Net related features of the Oracle7 Server Oracle Network Manager Administrator s Guide Provides information about how to use Oracle Network Manager Oracle Network Manager is a tool that configures and administers all Oracle network products based on the transparent network substrate TNS including e SQL Net e Oracle MultiProtocol Interchange e Oracle Names e Secure Network Services e Oracle Native Naming Adapters e Oracle SNMP Support Follow the instructions in this Guide as you use Oracle Network Manager to create the definition of your network and the configuration files that the network components require Oracle SNMP Support Reference Guide Covers the Oracle SNMP Support feature and the public and private MIBs that support its use with certain products This info
163. or more information on Oracle7 B Server utilities see Oracle7 Server Utilities Server Utilities Client Software This section describes the major client software components included in this package The Oracle7 Server for Windows NT package contains a variety of Oracle7 Server for Windows NT products for clients Among the products included are Introducing Oracle7 Server for Windows NT 1 9 Database Tools Oracle Objects for OLE Adobe Acrobat Runtime Network Manager Server Manager Enterprise Manager The database tools appear as icons in the Program Manager Explorer for Windows 95 These tools allow you to perform basic database functions from your client machine See the online Help for more information Oracle Objects for OLE is an object linking and embedding OLE application programming interface for use with Microsoft Visual Basic and VBA enabled applications Installation of the Oracle7 Server for Windows NT software includes a runtime version of Adobe Acrobat Adobe Acrobat enables you to view search and print any of the included documentation Use Adobe Acrobat to read and search through Oracle documentation All RDBMS networking and programming documentation you receive in your Oracle7 Server for Windows NT package is in Adobe Acrobat format See the documentation catalog in this chapter for additional information on available titles and on using the online documents Use Network Manager to create configur
164. oration welcomes your comments and suggestions on the quality and usefulness of this publication Your input is an important part of the information used for revision e Did you find any errors e Is the information clearly presented e Do you need more information If so where e Are the examples correct Do you need more examples e What features did you like most about this manual If you find any errors or have any other suggestions for improvement please indicate the topic chapter and page number below Please send your comments to Desktop Documentation Manager Workgroup Solutions Division Oracle Corporation 500 Oracle Parkway Box 659107 Redwood Shores CA 94065 If you would like a reply please give your name address and telephone number below Thank you for helping us improve our documentation
165. ork protocols and operating systems These references are examples of possible configurations and are not representative of all configurations Use this guide in conjunction with an Oracle operating system specific manual that includes notes on installation and operating system specific information such as configuration file locations and protocol support on that platform Oracle7 Spatial Data Option Application Developer s Guide Describes how to efficiently and simply store access and manage different types of data in a single database and how to improve performance for very large spatial databases holding gigabytes of spatial data Other Oracle Spatial Data documents included with your documentation set are Oracle7 Spatial Data Option Reference and Administrator s Guide Oracle7 Spatial Data Option Overview Oracle Enterprise Manager Concepts Guide A 12 Describes Oracle Enterprise Manager Oracle Corporation s newest generation of system management tools Enterprise Manager combines a single point of control management console intelligent agents and common services in an integrated comprehensive systems management Oracle7 Server Getting Started for Windows NT platform Other documentation about Oracle Enterprise Manager includes Oracle Enterprise Manager Performance Monitoring User s Guide Oracle Enterprise Manager for Windows NT Installation Release Notes and Oracle Enterprise Manager Application Developer s Guide
166. ormation For a complete list of options and R instructions on using SQL Loader see the Oracle7 Server 3 22 Oracle7 Server Getting Started for Windows NT Utilities The directory ORANT RDBMS73 LOADER contains a number of examples on the use of SQL Loader Control File Conventions When preparing a SQL Loader control file you must follow certain syntax and notational conventions For general information on the use and syntax of control files refer to Oracle7 Server Utilities Native Datatypes When specifying datatypes in the SQL Loader control file note that the default size of native datatypes are specific to Windows NT You cannot override these defaults in the control file Native Datatype Default Field Length INTEGER 4 SMALLINT 2 FLOAT 4 DOUBLE 8 Using the MONITOR Command In addition to performing database administration tasks outside the scope of the client Database Tools you can use Server Manager to monitor the performance of the Oracle7 Server for Windows NT using the MONITOR command To use Server Manager MONITOR screens run Server Manager in screen mode and pick one of the selections from the MONITOR menu For further information refer to Oracle7 Server Utilities Using Oracle7 Server for Windows NT 3 23 Instance Manager Command Line Commands NEW EDIT 3 24 This section describes the ORADIM73 commands and parameters Note that each command is preceded by a dash Create an instance
167. own Oracle recommends you use the starter database The Starter Database Install Options dialog box appears giving you the choice of Standard or Replication Choose Replication if you chose the Advanced Replication Option Otherwise accept Standard then click OK The Internal Password dialog box appears asking you to enter and verify a password for the starter database Enter and verify your password then choose OK The Starter Database Summary dialog box appears displaying the language and character set used for the starter database Select Yes to accept the settings otherwise select No to choose another language character set for the starter database The Oracle WebServer Settings dialog box appears with default Host Name and Port Number settings Note You must manually enter the Host Name and Port Number of your computer For Oracle7 Server for Windows NT the Host Name is hostname domainname Verify this information and Port Number with your system administrator The Host Name may be different than the machine name This Host Name must map to your IP address Choose OK to accept the settings or change them and click OK The Oracle WebServer Security Settings dialog box appears Enter or accept the username and password then confirm the password Oracle7 Server Getting Started for Windows NT Click OK The Oracle WebServer Post Installation dialog box appears displaying the URL you must open to use Oracle7 Server for
168. ows you to restore Oracle product icons that have been accidently deleted Help Accesses the online Help system Installing Oracle7 Server for Windows NT 2 11 2 12 When you run Oracle Installer from the Oracle7 Server for Windows NT CD Oracle Installer prompts you to enter the company name If you install Oracle Installer on your computer s hard drive you will not receive this prompt during subsequent uses The default location of Oracle Home is C ORANT where C is the designator of your local hard drive Oracle recommends that you use this default setting Note During installation Oracle Installer detects previous versions of Oracle7 Server software on your server When a previous version is detected a dialog box appears displaying migration information Choosing OK in this dialog box installs Oracle7 Server for Windows NT software in addition to the old version Choosing Cancel quits the installation so that you can migrate your database as outlined in the steps in Migrating from Earlier Releases After migration you can restart the installation 3 Installation Options If you choose Networking Products a Select Networking Products in the Software Asset Manager to install and configure SQL Net V2 3 Click the Install button The SQL Net V2 3 Products dialog box appears Choose the networking product s you want to install If you choose SQL Net Protocol Adapters the SQL Net Protocol Adapters dialog b
169. ox appears Select the protocol adapters you want to install Click OK The Adapter dialog box appears giving you the choice of installing SOL Net Client and or SQL Net Server Make your selection then click OK Oracle Installer installs the selected products After the product s are installed you will be prompted to read the Release Notes for the latest information Click OK to dismiss the notification The Software Asset Manager window reappears Exit Oracle Installer by clicking on the Exit button and confirm your exit when prompted Oracle7 Server Getting Started for Windows NT If you choose Oracle Documentation a Select Oracle Documentation in the Software Asset Manager to install Oracle Documentation Click the Install button The Oracle Documentation dialog box appears Choose CD ROM or Hard Drive installation Click OK Oracle Installer installs the selected products After the product s are installed you will be prompted to read the Release Notes for the latest information Click OK to dismiss the notification The Software Asset Manager window reappears Exit Oracle Installer by clicking on the Exit button and confirm your exit when prompted If you choose Oracle7 Client a Select Oracle7 Client in the Software Asset Manager to install the products included in this package Click the Install button The Oracle7 Client Option dialog box appears displaying the types of user you may install
170. r SQL Plus SQL Net Oracle Call Interface Oracle Objects for OLE Oracle7 ODBC Driver 2 16 Oracle7 Server Getting Started for Windows NT Oracle Documentation Oracle Installer Database Administrator Oracle7 Utilities Database Administration Tools SQL Plus SQL Net Oracle Objects for OLE Oracle7 ODBC Driver Oracle Call Interface Oracle Network Manager Windows only Oracle Installer Install Selective Oracle Documentation Oracle Installer Install your choice of Database Administration Tools Oracle Call Interface Oracle Documentation Oracle Objects for OLE Oracle7 ODBC Driver Oracle7 Utilities SQL Net SQL Plus Oracle Network Manager Windows only Oracle Client Software Agent Windows only Installing Oracle7 Server for WindowsNT 2 17 Client System Requirements Hardware Requirements Software Requirements The following sections specify the hardware and software requirements for installing the client software components of the Oracle7 Server for Windows NT from your client workstation You may need to install additional hardware and software depending on your network A IBM Compaq or 100 compatible with an 80386 processor or higher at least 8 MB of memory hard disk space for the client software and related files Note Installing all of the items including online documentation requires 85MB of free hard disk space a connec
171. r device exists and is accessible unable to set file pointer This error is caused by an operating system error or by damaged media Check the operating system error code if available and consult the Windows NT documentation If no operating system error code is presented verify that the media is not damaged unable to set eof file marker This error is caused by an operating system error or by damaged media Check the operating system error code if available and consult the Windows NT documentation If no operating system error code is presented verify that the media is not damaged SleepEx failure unable to Sleep There was an unexpected return from the Windows NT system service Check the operating system error code and consult the Windows NT documentation Memory Errors OSD 4100 to OSD 4199 malloc failure unable to allocate memory The program is out of memory Shutdown all unnecessary processes or install more memory in the machine invalid SGA SGA not initialized The System Global Area SGA has been allocated but not initialized Wait until the STARTUP has completed before attempting to connect Oracle7 Server Getting Started for Windows NT OSD 04102 Cause Action OSD 04103 Cause Action OSD 04104 Cause Action OSD 04105 Cause Action OSD 04106 Cause Action OSD 04107 Cause Action OSD 04108 Cause Action unable to open create file for shared memory object
172. racle Installer from the Help menu Windows NT Installations If you have both DOS and Windows NT installed on your Windows NT server machine start your machine and select Windows NT from the OS Loader option Log on to your Windows NT Server machine as a member of the Administrators group Attention If you previously installed another Oracle I amp S Windows NT product such as an earlier version of Oracle7 Server Oracle Installer should already be set up in the Windows NT Program Manager Installing Oracle7 Server for Windows NT 2 9 However you should complete Step 2 below to ensure that you use the current release of Oracle Installer to install your Oracle7 Server for Windows NT 1 Set Up the CD ROM Drive a Verify that your CD ROM drive is properly installed You can use any CD ROM drive that can be attached to the Windows NT server either locally or as a shared resource as a logical drive to install the Oracle7 Server for Windows NT software If the connected CD ROM drive cannot copy files to your hard disk refer to your CD ROM documentation b Load the Oracle7 Server for Windows NT CD ROM Insert the Oracle7 Server for Windows NT CD ROM into your CD ROM drive Verify that the drive is mapped to the logical drive you selected and that you can access files on the CD ROM The installation steps below assume that the CD ROM is mapped to the G gt drive AN Warning If you have already installed
173. re and software requirements found in Installation the following are highly recommended e a minimum of 32 MB memory e 90 MB of free hard disk space essentially double the normal recommended requirements Oracle Tablespace Requirements These are the recommended tablespace requirements for the Advanced Replication Option e System Tablespace at least 20 MB of free space is required for replication packages Replication triggers and procedures are stored here Rollback Segments at least two Rollback Initial Extent 50 K Rollback Next Extent 50 K Rollback Tablespace at least 5 MB of free space e Temporary Tablespace at least 10 MB free space User Tablespace user specific 5 8 Oracle7 Server Getting Started for Windows NT Initialization Parameters for Advanced Replication The following initialization parameters must be set or added to the INITsid ORA file recommended values are included Master Site Parameters Parameter Name Recommended Value COMPATIBLE 7 3 2 SHARED_POOL_SIZE at least 10 MB DISTRIBUTED_LOCK_TIMEOUT 300 seconds DISTRIBUTED_TRANSACTIONS 5 GLOBAL_NAMES TRUE OPEN_LINKS 4 PROCESSES add 9 to current value JOB_QUEUE_PROCESSES 2 depends on number of n way sites JOB_QUEUE_INTERVAL 10 seconds JOB_QUEUE_KEEP_ CONNECTIONS FALSE Note A practical limit of 10 Master Sites can be set up Snapshot Site Parameters add these parameters for snapshot sites Parameter Name Recomme
174. rmation is provided to assist you in developing SNMP based management applications for these products Secure Network Services Administrator s Guide Provides generic information on Secure Network Services and how to configure it into your existing SOL Net network Because this guide is Documentation Roadmap A 11 meant to be used in conjunction with Oracle platform specific documentation you will also need to refer to the port specific guide for your particular platform for information on how to install and configure Secure Network Services SQL Plus User s Guide and Reference Introduces the SQL Plus program and its uses It also provides a detailed description of each SQL Plus command Oracle Server Manager User s Guide Describes how to use Oracle Server Manager Oracle s database administration tool This guide describes Server Manager s graphical component and line mode component Information in this guide applies to Server Manager running on all platforms Platform specific differences are noted in platform specific documentation Other Oracle Server Manager documents included with your documentation set are Oracle Server Manager for Windows User s Guide Oracle Server Manager for Windows Installation Guide Oracle Server Manager Release 2 3 2 Addendum and SQL DBA to Oracle Server Manager Migration Guide Oracle Names Administrator s Guide Contains examples and figures that refer to specific machine types netw
175. rn from the Windows NT system service WaitForSingleObject Check the operating system error code and consult the Windows NT documentation Miscellaneous Errors OSD 4500 to OSD 4599 illegal option specified This is an internal error not normally expected to occur Contact Oracle Customer Support internal buffer overflow This is an internal error not normally expected to occur Contact Oracle Customer Support translations nested too deep The program encountered too many intermediate translations while attempting to translate a configuration variable Simplify the values of configuration parameters to include fewer intermediate translations text contains no translatable elements The program cannot recognize variables in the text to be translated Check and if necessary correct the text to be translated stdin not responding The system is unable to receive input from the standard input stream Verify that the process has access to an input device unable to spawn process via system The system is out of memory or the executable is invalid Shutdown unnecessary processes install more memory in machine Verify the name of the executable Messages and Codes E 17 E 18 OSD 04507 Cause Action OSD 04508 Cause Action OSD 04509 Cause Action OSD 04510 Cause Action OSD 04511 Cause Action OSD 04512 Cause Action OSD 04513 Cause Action password for internal is
176. rsive calls while your application is running it may be necessary to determine the cause of excess recursive calls See Detecting Dynamic Extension in Oracle7 Server Tuning Object Oracle7 Redo Log Buffer The Redo Log Buffer object contains one counter the redo log space request counter The value of this counter should be near 0 If this value increments consistently processes have had to wait for space in the buffer In this case it may be necessary to increase the size of the redo log buffer See Space in the Redo Log Buffer in Oracle7 Server Tuning Additional Tuning Contentions Object Oracle7 Tuning Sorts The Tuning Sorts object contains two counters the sorts in memory sec and the sorts on disk sec counters If a significant number of sorts require disk I O to temporary segments your application s performance may benefit from increasing the size of the sort area See Increasing Sort Area Size in Oracle7 Server Tuning Object Oracle7 Free List The Free Lists object contains one counter the freelist waits requests percentage counter If this value is greater than 1 add more free list to reduce contention See Identifying Free List Contention in Oracle7 Server Tuning 4 4 Oracle7 Server Getting Started for Windows NT Event Viewer The Windows NT Event Viewer displays warnings and errors about the Oracle7 database As with other events displayed in the Event Viewer you can double click on them to display
177. ry D 2 ORACLE_GROUP D 4 SQL Net D 7 D 12 CONTROL FILES C 3 parameter 3 16 CONTROL FILES initialization parameter 3 18 CONTROL FILES parameter C 4 CREATE DATABASE command C 4 parameter 3 17 statement 3 17 3 18 CREATE DATABASE command 3 17 CreateProcess failure unable to spawn process E 14 CTLIORCL ORA 3 4 3 16 in ORANT DATABASE C 4 Customer name specifying during installation 2 11 2 20 D Data dictionary table ARGUMENTS 5 10 I_ARGUMENT1 5 10 I_SOURCE1 5 10 IDL_CHAR 5 10 IDL_SB4 5 10 IDL_UB1 5 10 IDL_UB2 5 10 SOURCES 5 10 TRIGGERS 5 10 Database creating a new 3 14 3 18 Oracle7 1 2 password encryption 4 6 preparing to create a new 3 15 security 4 5 starter 3 2 starting 3 10 starting with Instance Manager 3 11 starting with SQL DBA 3 11 unauthorized access to 1 9 database creating a new 3 2 Database administration tasks overview 3 2 Database alerts 1 8 Database files 3 16 moving 2 27 Database language PL SQL 1 9 SQL 1 9 Database monitoring with Server Manager 3 23 Database objects creating 3 20 Database Tools 1 2 Start Oracle Services 3 5 3 6 Terminate Oracle Services 3 5 3 6 Database tools Windows based 1 10 Database triggers 1 8 DATAFILE parameter 3 10 DB_BLOCK_SIZE parameter C 4 DB_FILE_MULTI
178. ry in the Oracle directory hierarchy Operating System Windows NT Default CLASS normal DEF normal Legal Values See the following table This parameter determines the Windows NT scheduling priorities of the threads within the Oracle process The format is namel priorityl name2 priority2 The name CLASS sets the priority class of the Oracle process Threads can be assigned priority either collectively or individually The collective name USER designates non background shadow threads the collective name DEF designates any thread type not handled specifically Valid individual background thread names are DBWR LGWR PMON SMON ARCH RECO CKPT TRWR and SNPO through SNP9 I gt Attention Oracle Corporation recommends that the Oracle process CLASS be set at high priority and that the default thread priority setting DEF be set at time_critical The syntax of the recommended ORACLE_PRIORITY setting is therefore D 4 Oracle7 Server Getting Started for Windows NT CLASS high DEF time_critical Setting the Oracle process and the threads within it to other priorities may result in performance degradation Relative Thread Process Priority Class Priority idle normal high time_critical 15 15 15 highest 6 9 15 above_normal 5 8 14 4 ORACLE_SID Operating System Windows NT Default none Legal Values any combination of up to 4 alpha numeric characters This parameter specifies the name of t
179. s national language support Preface iii Audience This Guide is necessary for anyone installing configuring or administering Oracle7 Server for Windows NT Prerequisites This Guide assumes that you e are familiar with the concepts presented in the generic documentation for Oracle7 Server for Windows NT See Documentation Roadmap for information about documentation e have installed and tested Windows NT and configured it for your PC and network hardware e are familiar with Windows NT and your network transport protocol Additional Information If you are not familiar with Oracle products and terminology see Oracle7 Server Concepts Oracle7 Concepts How this Guide Is Organized Chapter 1 Introducing Oracle7 Server for Windows NT Describes the basic features of Oracle7 Server for Windows NT It also describes new features of this release and the contents of your Oracle7 Server for Windows NT package Chapter 2 Installing Oracle7 Server for Windows NT Instructions for installing and configuring Oracle7 Server for Windows NT and for migrating from earlier releases Chapter 3 Using Oracle7 Server for Windows NT Instructions for performing the tasks necessary to set up and run the Oracle7 Server for Windows NT Additional Information For information on using the graphical database tools see the integrated online Help included with the Database Tools It contains important information about the datab
180. s and other views used by Oracle software sample files for SQL Loader informational trace and alert files generated by the Oracle7 RDBMS sample files that show OCI Oracle Call Interface usage Oracle7 RDBMS database password and initialization files Oracle Toolkit II message files and other utility files created when you install SQL Net V2 3 for Windows NT NETWORK also contains the three subdirectories described below ora configuration files used by SQL Net V2 3 for Windows NT log files placed here by default trace files placed here by default See Oracle Network Products for Windows NT 95 User s Guide for additional information on the NETWORK directory and its subdirectories loadable NLS files files used by the Oracle Installer executables scripts and HTML files for Oracle Web Agent and Oracle Web licenses message files SOL scripts and demonstration files for PL SQL Oracle7 RDBMS database password and initialization files Oracle7 RDBMS message resource and readme files RDBMSnn also contains the four subdirectories described below Oracle7 Server Directory Structures B 3 Windows Windows 95 Directory Structure You install Windows products on your Windows NT server machine using Oracle Installer for Windows Oracle Installer places all Oracle for Windows products into subdirectories of ORAWIN ORAWIN95 for Windows 95 The actual directory names vary depending on the different pr
181. s and the Instance Manager dialog box appears Instance Manager Startup ORCL Services Started Automatic Instance Stopped Manual SID1 Services Started Automatic Instance Stopped Manual SID2 Services Started Automatic Instance Stopped Manual 2 Click the New button in the Instance Manager dialog box Oracle7 Server Getting Started for Windows NT The New Instance dialog box appears emee ee S Instance Corda DBA Authencratcm P r Inctence Startup Mode C Auhematio S Mosel Mortnue Renter of DEAM perador E ka Parameter taitolizaiion Fiore En Ltt 3 Type a SID up to four characters remember that each SID must be unique Type the DBA Authorization Password Confirm the DBA Authorization Password Type the Maximum Number of DBA Operators os OV Oi hS Choose whether to start the Services and or Instance after creation These selections are for specifying starting the Services and or Instance immediately after creation By default both are selected 8 Choose Automatic or Manual Instance Startup Mode Selecting Automatic will start the database automatically when the machine is booted Setting Startup Mode to Automatic will cause the following e anew service is created OracleStart lt sid gt This service points to the executable STRTDB73 EXE e acommand file STRT lt sid gt CMD is created in ORACLE_ HOME DATABASE This file contains the command line version
182. single quotation marks The SIZE parameter operates as described in the Oracle7 Server SQL Reference MAXDATAFILES integer Specify the maximum number of data files that the database can create 1 MAXDATAFILE is created by default The default value is 32 the range is 1 to 254 files MAXINSTANCES integer This parameter is not relevant with Oracle7 Server for Windows NT NOARCHIVELOG To avoid logging the commands used to create your database you should create the database in NOARCHIVELOG mode the default If you plan to operate the database in ARCHIVELOG mode see the section Enabling Auto matic Archiving in Chapter 4 for instructions on changing this setting CHARACTER SET name The character set Oracle7 Server for Windows NT uses to store data The de fault is WE8ISO8859P1 Additional Information For more detailed information see Oracle soLRet Oracle Server SQL Reference Starting a Database Before starting the database make sure that a database instance has been created and that the services have been started See the section Creating an Instance with Instance Manager earlier in this chapter Then use the Database Instance Manager or Server Manager to start the database 3 10 Oracle7 Server Getting Started for Windows NT Starting a Database Using Instance Manager Databases can be started using Instance Manager by selecting the Services and Instance checkboxes in Startup After Creation or from ORADIM73
183. t Version 1 1 of SOL Net Named Pipes Default 10 Legal Values 1 to maximum number of sessions allowed by the requester NMP_MAX_CLIENTS sets the maximum number of shadow and listener threads allowed on the server Note Setting this parameter to zero causes the parameter to take its default value Configuration Parameters and the Windows NT Registry D 7 NMP_MIN_CLIENTS NMP_FREE_CLIENTS NMP_SPAWN_INCREMENT Operating System Windows NT SQL Net SQL Net Default 5 Legal Values 1 to NMP_MAX_CLIENTS NMP_MIN_CLIENTS is the number of listener threads that will be pre spawned by the server at startup Note Setting this parameter to zero causes the parameter to take its default value Operating System Windows NT SQL Net Version 1 1 of SQL Net Named Pipes Default 5 Legal Values 1 to NMP_MAX_CLIENTS NMP_FREE_ CLIENTS is the minimum number of listener threads that will be maintained by the server at any one time Note Setting this parameter to zero causes the parameter to take its default value Operating System Windows NT SQL Net Version 1 1 of SQL Net Named Pipes Default 5 Legal Values 1 to NMP_MAX_CLIENTS NMP_SPAWN_INCREMENT is the maximum number of listener threads created at one time when listener thread creation is necessary When the number of listener threads falls below the value of NMP_FREE_CLIENTS new listener threads are generated in batches with maximum size of NMVP_SPAWN_INCREMENT Few
184. t Viewer 1 5 EXP utility 3 15 EXP73 utility 5 6 Export utility 3 21 definition of 1 8 NT parameter defaults 3 22 F file size mismatch E 11 FILE_CORRUPTED E 2 FILE_NOT_FOUND E 3 filespec 3 10 Fixed header 3 20 G GetFileInformationByHandle failure unable to obtain file info E 11 Index 4 Oracle7 Server Getting Started for Windows NT H Hardware requirements client 2 18 Headers fixed 3 20 row 3 20 transaction 3 20 I I_ARGUMENT1 data dictionary table 5 10 I_SOURCE1 data dictionary table 5 10 IBM 2 2 IDL_CHAR data dictionary table 5 10 IDL_SB4 data dictionary table 5 10 IDL_UB1 data dictionary table 5 10 IDL_UB2 data dictionary table 5 10 illegal option specified E 17 IMP utility 3 19 Import utility 3 21 definition of 1 8 NT parameter defaults 3 22 Incorrect or unknown background image name given to spdcr E 15 Indexes 3 20 Initialization parameter files defined C 2 editing C 2 INITsid ORA C 2 location C 2 location of C 2 sample C 2 Initialization parameters C 1 C 4 C 6 activating C 3 modified when creating a new database C 3 INITORCL ORA 3 4 3 16 INITsid ORA 3 16 INITsid ORA file C 2 Install client selective 2 21 Networking Products 2 12 server selective 2 16 Installation first time
185. t installed See the ORASRV output file for more information The ORASRV output file resides in the ORA_SQLNET directory and has a name in the following form ORA_SRVTInn_ SID OUT If the ORASRV output file does not indicate the appropriate action contact your Oracle Customer Support representative NETTCP ORASRV unable to open network connection The Oracle7 Server for Windows NT process was started but was unable to open the socket that TCPSRV passed to it Contact your Oracle Customer Support representative NETTCP unable to change username The host s SQL Net TCP IP server could not establish a Proxy login connection because the client username is unknown to the host operating system Create new user account on the host and retry the connection Oracle7 Server Getting Started for Windows NT ORA 06128 Cause Action ORA 06129 Cause Action ORA 06130 Cause Action ORA 06131 Cause Action ORA 06132 Cause Action ORA 06133 Cause Action NETTCP unable to create mailbox The host s SOL Net TCP IP server was unable to create a mailbox needed for IPC communication with the Oracle7 Server for Windows NT process See the SQL Net TCP IP server log file for more information Contact your Oracle Customer Support representative NETTCP unable to transfer socket ownership to ORASRV The host s SOL Net TCP IP server was unable to transfer the network communication handle to the Or
186. tarted Running Multiple Instances For each instance you wish to run from the command line type C gt ORADIM73 STARTUP SID sid STARTTYPE SRVC INST USRPWD lt password gt PFILE lt filename gt Using Oracle7 Server for Windows NT 3 13 where sid is the system identifier SID of the database SRVC INST indicates that both the services and the instance are to be started if applicable Creating a New Database After you complete an Oracle7 Server installation of Oracle7 Server for Windows NT you install a starter database If you chose Selective Install and did not install a starter database you must create your own database The steps below are divided into two sections e preparing to create a new database e creating a new database The following flow chart diagrams the decision process for the types of tools and protocols you use if you decide to create a custom database one specialized for your needs 3 14 Oracle7 Server Getting Started for Windows NT Do you want to replace the starter database es Use EXP to export data Use the Instance Shut down Manager to create the instance y an instance v Delete data base files v Create edit gt SQL scripts y Start the instance vy Run Server Mgr amp the SQL scripts y Use IMP to import data If you have installed Oracle7 Server for Windows NT without the starter database or if you are creating an additional database yo
187. ted CD ROM drive functioning as a logical drive if you are completing the installation from a client workstation a network interface card NIC and accompanying software The NIC must be supported by Microsoft for use with LAN Manager Enhanced or Windows for Workgroups Warning Before installing software for the Oracle7 Server for Windows NT and for client workstations be sure you have completely installed your networking software and verified that it is functioning properly Client installations require the following software Microsoft Windows Version 3 1 or higher running in Enhanced Mode Microsoft Windows for Workgroups 3 11 or Microsoft Windows 95 appropriate network transport protocol software 1 Set Up the CD ROM Drive a Verify that your CD ROM drive is properly installed You can use any CD ROM drive that can be attached to the Windows NT server either locally or as a shared resource as a logical drive to install the Oracle7 Server for Windows NT software If the connected CD ROM drive cannot copy files to your hard disk refer to your CD ROM documentation b Load the Oracle7 Server for Windows NT CD ROM 2 18 Oracle7 Server Getting Started for Windows NT Insert the Oracle7 Server for Windows NT CD ROM into your CD ROM drive Verify that the drive is mapped to the logical drive you selected and that you can access files on the CD ROM The following installation steps assume that the CD ROM is mapped to
188. ter and using Oracle Installer to install the message files for the additional language See National Language Support in this Guide for details on installing additional languages You can also set NLS for an individual instance using several parameters in the initialization parameter file National Language Support in this Guide contains information about installing additional languages Note The default language English is installed with every Oracle7 Server for Windows NT in addition to any other language you select c Specify a company name and Oracle Home location then choose OK When you run Oracle Installer from the Oracle7 Server for Windows NT CD it prompts you to enter the company name If you install Oracle Installer on your computer s hard drive you will not receive this prompt in subsequent installations Type in the company name and Oracle Home location then choose OK The default location of Oracle Home is C ORAWIN C ORAWIN95 for Windows 95 where C gt is the designator of your local hard drive Oracle recommends that you use this default setting The Installation Options dialog box appears giving you the choice of Application User Database Administrator Developer and Selective Install d Select one of the installations then choose OK Installation Types If you choose Oracle7 Client a Select Oracle7 Client in the Software Asset Manager to install the products included in this package b
189. the G gt drive Install Oracle7 Server for Windows NT Client Products a To start Oracle Installer for Windows run Oracle Installer executable ORAINST You can run ORAINST for Windows in one of the following ways From the Program Manager From the Windows Program Manager do the following select Run from the File menu enter the path and executable file name for example G WINDOWS INSTALL ORAINST EXE click Enter From the File Manager From the Windows Program Manager do the following choose the File Manager icon select the drive to which the CD ROM is connected choose the WINDOWS directory icon and the INSTALL directory icon double click the ORAINST EXE file icon From the Windows 95 Start Button From the Windows 95 Start button do the following select Start select Run The Run dialog box appears enter the path and executable file name or browse to find it for example G WINDOWS INSTALL ORAINST EXE click Enter If you are using Oracle Installer for the first time you must select a language at the language prompt b Select a language and choose OK to accept the default language Installing Oracle7 Server for WindowsNT 2 19 2 20 When you select the language Oracle Installer sets the NLS_LANG configuration parameter National Language Support NLS can be changed after installation by changing the values for the NLS_LANG configuration parame
190. to recognize the database SID specified in the login connect string Verify that the instance is running If it is verify that the services for the instance are present and running If they are not create the services and restart the machine Oracle7 Server Getting Started for Windows NT ORA 06421 Cause Action ORA 06422 Cause Action ORA 06423 Cause Action NETCMN error detected in the read in data An error occurred in the recomputation of checksum or CRC There is a possible hardware failure in the communication nodes Contact your system administrator NETCMN error in sending data SOL Net was unable to transmit data to Oracle7 Server for Windows NT Attempt to reconnect to the Server Contact your system administrator NETCMN error in receiving data SOL Net was unable to receive data from the Server Attempt to reconnect to the Server Contact your system administrator Messages and Codes E 31 E 32 Oracle7 Server Getting Started for Windows NT APPENDIX National Language Support The Oracle7 Server for Windows NT provides National Language Support NLS that allows users to interact with the database in their selected language When you installed Oracle7 Server for Windows NT you selected a language and the Installer recorded that language in the NLS_LANG configuration parameter This appendix explains the NLS_LANG parameter and its components and lists the available options This
191. tory is not c orant replace it with the actual directory name Note If you have expanded the database include the additional database files in the above statement 4 Run SQL scripts to migrate the database Run SQL scripts to migrate the database a Enter the following commands at the Server Manager prompt 2 30 Oracle7 Server Getting Started for Windows NT 7 0 15 to 7 3 7 1 3 to 7 3 7 2 2 to 7 3 SVRMGR gt alter database open SVRMGR gt alter database open SVRMGR gt alter database open SVRMGR gt RDBMS73 ADMIN cat70101 SVRMGR gt RDBMS73 ADMIN cat70102 SVRMGR gt RDBMS73 ADMIN cat7103 SVRMGR gt RDBMS73 ADMIN cat7201 sql SVRMGR gt RDBMS73 ADMIN cat7201 sql SVRMGR gt RDBMS73 ADMIN cat7203 sql SVRMGR gt RDBMS73 ADMIN cat7301 SVRMGR gt RDBMS73 ADMIN cat7301 SVRMGR gt RDBMS73 ADMIN cat7301 SVRMGR gt RDBMS73 ADMIN cat7302 sql SVRMGR gt RDBMS73 ADMIN cat7302 sql SVRMGR gt RDBMS73 ADMIN cat7302 sql SVRMGR gt RDBMS73 ADMIN catalog SVRMGR gt RDBMS73 ADMIN catalog Note The statements in the table below are for special purposes catproc sql is for PL SQL functionality catrep sq is for the Advanced Replication Option Run catrep only if you have the Advanced Replication Option and want to use it Refer to Appendix A for a detailed discussion of Advanced Replication before proceeding Note Ensure that you spool all of the output from the sql scripts to a file Then chec
192. u must create a separate Oracle instance See Creating an Instance with Instance Manager in this chapter for more details Note To replace the starter database or if you have already created an instance follow the steps below Preparing to Create a New Database Follow the steps below to create a new database 1 Use the EXP utility to export any data from the current database that you wish to migrate to the new database To start EXP type C gt EXP73 options Using Oracle7 Server for Windows NT 3 15 3 16 Oracle7 Utilities Value of 4K and the RECORDLENGTH parameter defaults to Oracle Additional Information When you run the EXP utility from Windows NT workstations the BUFFER parameter defaults to a 2K See Oracle7 Server Utilities for more information about EXP Start Server Manager from the console and connect with your user name and password C gt SVRMGR73 MODE LINE Shut down your Oracle7 Server for Windows NT using Database Manager or the Server Manager SHUTDOWN command Additional Information For more information on using eB Database Manager or any of the Database Tools see the online Help included with your product 4 Make backup copies of all the database redo log and control files if the database contains important information I gt Attention See the sections Setting the Archivelog Mode and Recovering the Database and Backing Up the Database in this chapter and Oracl
193. upport Unable to retrieve system user name for current user This is an internal error not normally expected to occur Contact Oracle Customer Support Loader Errors OSD 4300 to OSD 4399 OSD 04300 Cause Action OSD 04301 Cause Action OSD 04302 Cause Action unable to read complete record from data file The data file ended in the middle of a record This error occurs when loading files with a fixed record length Verify that the data file is of the correct length and contains complete records record size too large The specified record size is too large to load Reduce record size and reload the data invalid record type and or load options The control file s Windows NT file processing options string contains an invalid option or keyword Set the Windows NT file processing options string to an acceptable value Semaphore Errors OSD 4400 to OSD 4499 OSD 04400 Cause Action E 16 unable to acquire internal semaphore for process Oracle7 Server for Windows NT has exceeded the maximum number of connections Delete any unused connections and try again Oracle7 Server Getting Started for Windows NT OSD 04401 Cause Action OSD 04500 Cause Action OSD 04501 Cause Action OSD 04502 Cause Action OSD 04503 Cause Action OSD 04505 Cause Action OSD 04506 Cause Action WaitForSingleObject failure unable to obtain semaphore There was an unexpected retu
194. use a different drive as your raw drive substitute it for c To back up Physical RAW files use the following syntax C gt 0COPYnn physicaldriveN new_file C gt 0COPYnn B physicaldriveN a where N is the number s representing each of the physical drives in the system To restore RAW files use the following syntax C gt OCOPYnn new_file c C gt 0COPYnn R a c where c represents the raw drive which holds a single RAW database file If you use a different drive as your raw drive substitute it for c OCOPY prompts you to insert diskettes as needed Recovery Manager Use Recovery Manager to recover your Oracle7 database after a failure During the Recovery process you are prompted to enter your database password If so enter your database password and select OK Additional Information For more information about recovery LE see Oracle7 Server Administrator s Guide Admin Guide 5 4 Oracle7 Server Getting Started for Windows NT Using Trace and Alert Files Oracle7 Server for Windows NT background threads use trace files to record occurrences and exceptions of database operations as well as errors Background thread trace files are created regardless of whether the BACKGROUND_DUMP_DEST parameter is set in the initialization parameter file If BACKGROUND_DUMP_DEST is set the trace files are stored in that directory If the parameter is not set the trace files are stored in the ORAN
195. ver Tuning Oracle Server Manager User s Guide Oracle Server Manager for Windows User s Guide Oracle Server Manager for Windows Installation Guide Oracle Server Manager Release 2 3 2 Addendum SQL DBA to Oracle Server Manager Migration Guide Oracle7 Spatial Data Option Application Developer s Guide Oracle7 Spatial Data Option Reference amp Administrator s Guide Oracle7 Spatial Data Option Overview Oracle Enterprise Manager Performance Monitoring User s Guide Product Name Product Documentation Oracle Enterprise Manager Administrator s Guide Oracle Enterprise Manager for Windows NT Installation Release Notes Oracle Enterprise Manager Concepts Guide Oracle Enterprise Manager Application Developer s Guide SQL Plus SQL Plus User s Guide and Reference SQL Plus Quick Reference SQL Plus for Windows Installation Guide SQL Plus for Windows NT 95 User s Guide SQL Net Understanding SQL Net Oracle Network Products Messages Manual Oracle SNMP Support Reference Guide Oracle Network Manager Administrator s Guide Oracle Names Administrator s Guide Secure Network Services Administrator s Guide Oracle Network Products Troubleshooting Guide Oracle Network Products for Windows NT 95 User s Guide Multi Protocol Interchange Programmer 2000 Programmer s Guide to the Oracle Call Interface Programmer s Guide to the Oracle Pro C C Precompiler Programmer s Guide to the Oracle Precompilers Oracle Call Interfac
196. while creating the instance Oracle7 Server Getting Started for Windows NT Creating an Instance The Instance Manager command line tool is run with the ORADIM73 EXE executable To use this tool from the command line type ORADIM73 followed by appropriate commands and arguments listed below Note If you enter ORADIM73 or ORADIM73 EXE at the command line followed by a return that is without any commands you start the graphical tool Likewise if you type ORADIM73 followed by an invalid command you start the graphical tool If you type ORADIM73 followed by a combination of valid and invalid commands the Instance Manager processes as many valid commands as possible and remain at the command line To get a complete listing of ORADIM73 commands enter a question mark after the executable name C gt ORADIM73 To use ORADIM73 to create an instance called sid enter the following C gt ORADIM73 NEW SID sid INTPWD lt password gt STARTMODE PFILE These two commands are mandatory create an instance NEW and the system identifier of the instance SID sid Starting an Instance To start an instance using ORADIM73 EXE directly from the command line enter the following C gt ORADIM73 STARTUP SID sid STARTTYPE SRVC INST USRPWD lt password gt PFILE lt filename gt where sid is the system identifier SID of the database INST indicates that the instance should be s
197. yping SQL gt CONNECT username password FINANCE D 10 Oracle7 Server Getting Started for Windows NT APPENDIX l Messages and Codes T his appendix lists error messages and codes that are specific to installation and operation of Oracle7 Server for Windows NT The error message descriptions in this appendix list possible causes for the errors and suggest corrective actions The information in this appendix does not duplicate information in Oracle7 Server Messages This appendix is divided into the sections listed below e logging error messages e Oracle Installer Messages e Oracle Database Messages e Windows NT Specific Oracle Messages e SQL Net TCP IP Messages e SQL Net Named Pipes Messages e NETCMN Messages Messages and Codes E 1 Logging Error Messages You can keep a log of the error messages you receive from the Oracle7 Server for Windows NT utilities by redirecting the messages to a file You can record the contents of normal utility messages by using the LOGFILE parameter discussed in the Oracle7 Server Utilities You can separately record the error message portion by using standard Windows NT file redirection For example you might use the following syntax to redirect the output from the Export utility C gt EXP username password PARFILE filename 1 gt FILE1 LOG 2 gt FILE2 ERR In this command line FILE1 LOG receives the standard output from Export while FILE2 ERR receives the st
198. ystem programmers in the planning and implementation of migrating databases from Version 6 to Version 7 and in upgrading and downgrading among Oracle 7 releases It is designed to guide you through each step of the process and explains the tools and features involved with each step PL SQL User s Guide and Reference PL SQL is Oracle Corporation s procedural language extension to SQL the standard data access language for relational databases PL SQL offers modern software engineering features such as data encapsulation information hiding overloading and exception handling and so brings state of the art programming to the Oracle Server and Toolset Oracle7 Server Distributed Systems Volume I Distributed Data Describes the concepts necessary for implementing Oracle7 Server Release 7 3 with the Distributed Option and its related tools utilities A 8 Oracle7 Server Getting Started for Windows NT and applications in a distributed environment This manual is intended to help you understand the concepts of distributed systems and to aid you in database and network administration in a distributed system Oracle7 Server Distributed Systems Volume II Replicated Data Describes the Oracle7 Server features available to support advanced distributed applications Information in this manual applies to the Oracle7 Server running on all operating systems The topics discussed in this manual include read only snapshots updatable snapshots

Oracle A423961 Server User Manual

Contents

Download Pdf Manuals

Related Search

Related Contents