Oracle Oracle7 Server 7.3, Getting Started Manual

Page 1: ...Oracle7 Server Getting Started for Windows NT Release 7 3 Part No A42396 1 The Relational Database Management System ...

Page 2: ... 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 Oracle Parkway Redwood City CA 94065 If this software documentation is delivered to a U S Govern...

Page 3: ...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 codes national language support ...

Page 4: ...pter 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 Usin...

Page 5: ...indows 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 av...

Page 6: ...acle7 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 Database Tools 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 Troubleshoot...

Page 7: ...te 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 variable C 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 backslas...

Page 8: ...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 ...

Page 9: ...11 Chapter 2 Installing Oracle7 Server for Windows NT 2 1 A Note on Directories 2 2 System Requirements Server 2 2 Oracle7 Server for Windows NT Hardware 2 2 Advanced Replication Option Hardware 2 2 Software 2 3 Windows on Win32 WOW 2 4 Before You Install 2 5 First Time Installation 2 5 Re installation of Oracle7 Server for Windows NT 2 5 Co existence of Oracle7 Server for Windows NT and Oracle7 W...

Page 10: ...4 Prepare for the Migration 2 24 Install the Oracle7 Server 2 26 Move Database Files 2 27 Chapter 3 Using Oracle7 Server for Windows NT 3 1 Overview of Database Administration Tasks 3 2 What is an Instance 3 2 The Starter Database 3 2 Oracle Services 3 5 Instance Manager 3 6 Creating an Instance and Database with Instance Manager 3 6 Changing Passwords 3 8 Advanced Parameters 3 9 Starting a Databa...

Page 11: ...4 Getting the Most out of Integration with Windows NT 4 1 Oracle7 and the Windows NT Performance Monitor 4 2 Performance Monitor Objects 4 3 Event Viewer 4 5 Database Security 4 5 Starting Services Automatically 4 7 Using Windows NT OS Authentication 4 7 NT GROUPS and ROLES 4 8 Chapter 5 Database Administration 5 1 Backup Manager 5 2 Hot Database File Backup 5 2 Backing Up Active Files 5 2 Restori...

Page 12: ...6 Using Oracle Documentation A 13 Appendix B Oracle7 Server Directory Structures B 1 Windows NT Directory Structure B 2 Windows Windows 95 Directory Structure B 4 Oracle WebServer Installation Types B 5 Appendix C Initialization Parameter Files C 1 What Is an Initialization Parameter File C 2 Location of Initialization Parameter Files C 2 Editing Initialization Parameter Files C 2 The Sample Initi...

Page 13: ... OSD 4499 E 16 Miscellaneous Errors OSD 4500 to OSD 4599 E 17 Codes 6100 6199 SQL Net TCP IP Errors E 19 Codes 6220 6400 SQL Net Named Pipes Errors E 25 Codes 6401 6430 NETCMN Errors E 28 Appendix F National Language Support F 1 NLS_LANG F 2 Territory and Character Set Defaults F 2 Selecting Alternate Territories and Character Sets F 4 NLS Initialization Parameters F 4 NLS_LANGUAGE and NLS_TERRITO...

Page 14: ...xiv Oracle7 Server Getting Started for Windows NT ...

Page 15: ...roducing Oracle7 Server for Windows NT his chapter introduces you to Oracle7 Server for Windows NT It includes special terms Oracle7 Server for Windows NT overview Oracle7 Server for Windows NT integration with Windows NT Oracle7 Server for Windows NT product contents ...

Page 16: ...ed 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...

Page 17: ... 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 ...

Page 18: ...ormation 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 o...

Page 19: ... 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 onl...

Page 20: ...t 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 b...

Page 21: ...dows 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 Wi...

Page 22: ...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 ins...

Page 23: ...etwork 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 for more information about using...

Page 24: ...umentation 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 Network Manager Use Network Manager to create configuration files for Oracle networking products For more information on Netwo...

Page 25: ...er network environments For complex network environments or for more detailed control of your network use Network Manager to configure your network Network Manager 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 graph...

Page 26: ... 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 to databases anywhere else on the network by short mnemonic names Additional Information A complete description of this product and its ...

Page 27: ...ou 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...

Page 28: ...ware 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 RAM 32 MB recommended Available disk space 65 MB of free hard disk space 100MB if you want to install all of the online docum...

Page 29: ...stalled 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 Wind...

Page 30: ...ows NT WOW Subsystem 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 Attention You can always achieve loopback by using SQL Net V2 along with the Oracle N...

Page 31: ...s 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 In...

Page 32: ...ers seven types of Windows NT installations listed below Networking Products Install your choice of Oracle Intelligent Agent Oracle Names Server SQL Net Client SQL Net Protocol Adapters Named Pipes SPX TCP IP SQL Net Server Oracle Documentation Install Oracle Documentation Oracle7 Client Install your choice of Application User SQL Plus SQL Net Client SQL Net Protocol Adapters Oracle Call Interface...

Page 33: ...choice of Oracle7 Server Oracle7 Server Options Oracle WebServer Oracle7 Utilities Oracle7 Performance Utility Oracle Call Interface Oracle Intelligent Agent Oracle Enterprise Manager SQL Plus SQL Net Server SQL Net Protocol Adapters Named Pipes SPX TCP IP Oracle Installer Programmer 2000 Install your choice of Pro C Oracle Call Interface SQL Plus Install SQL Plus ...

Page 34: ...dministration 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 SQL Net Client SQL Net Protocol Adapters Named Pipes SPX TCP IP SQL ...

Page 35: ...er for Windows for installing Windows products on the Windows on Win 32 subsystem of Windows NT or on client workstations running Windows Oracle Installer for Windows95 for Windows 95 systems Attention Get help during installation by choosing Using Oracle 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...

Page 36: ... 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 drive Warning If you have already installed 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...

Page 37: ... 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 produ...

Page 38: ...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 a Select Networking Products in the Software Asset Manager to install and configure SQL Net V2 3 b Click the Install button The SQL Net V2 3 Products dialog box appears c Choose the networking product s you want to install If you choose S...

Page 39: ...ager to install the products included in this package b 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 d Click OK to begin the installat...

Page 40: ...hose 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 g 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 h Select Yes to accept the settings otherwise s...

Page 41: ...cts included in this package b Click the Install button The Programmer 2000 dialog box appears giving you the choice of installing Pro C and or Oracle Call Interface c 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 informat...

Page 42: ...stalled 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 f Click OK to dismiss the notification The Software Asset Manager window reappears g Exit Oracle Installer by clicking the Exit button and confirm your exit when prompted Installation Types Windows Windows 95 Clients Thi...

Page 43: ...le Call Interface Oracle Network Manager Windows only Oracle Installer Oracle Documentation Install Oracle Documentation Oracle Installer Selective 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 ...

Page 44: ...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 Software Requirements Client installations require the following software Microsoft...

Page 45: ...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 Bu...

Page 46: ...acle7 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 is the designator of your local hard drive Oracle recommen...

Page 47: ...he Install button The Oracle Documentation dialog box appears c Choose CD ROM or Hard Drive installation d 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 e Click OK to dismiss the notification The Software Asset Manager window reappears f Exit Oracle Installer by clicking on the Ex...

Page 48: ... release 2 3 networking software connection is automatically configured with each 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 file on the server This Listener ID A listener configuration file on the server This file defines information used by the listener to Ser...

Page 49: ...s 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...

Page 50: ...Server for Windows NT This section describes procedures for migrating your earlier Oracle7 Server version s to Release 7 3 Overview Use this procedure for migrating earlier Oracle7 Server versions to Release 7 3 It includes the following tasks and example preparing for migration installing the Oracle7 Server for Windows NT moving database files Prepare for the Migration Before migrating to Release...

Page 51: ...l migrate log SVRMGR select member from v logfile SVRMGR select name from v datafile SVRMGR select value from v parameter where name control_files 2 Shut down your Oracle7 database At the SVRMGR prompt enter the following SVRMGR connect internal SVRMGR shutdown SVRMGR exit 3 Shut down and delete Oracle services Shutdown and delete Oracle services belonging to the earlier database version using ora...

Page 52: ...l 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 and options 2 Add an ORACLE_SID key to the NT registry a Creat...

Page 53: ... automatically created a From the command line enter oradim73 new sid sidname intpwd pwd maxusers users This creates the following OracleService sidname service OracleNMPListener sidname service only if SQL Net V1 Named Pipes i e nmplsnr exe protocol is installed password file pwd sidname ora in ORACLE_HOME DATABASE b From the command line enter oradim73 startup sid sidname usrpwd pwd starttype sr...

Page 54: ... ora oracle_home database userorcl ora rdbms70 log2 ora rdbms71 rbsorcl ora oracle_home database rbsorcl ora rdbms71 temporcl ora oracle_home database temporcl ora rdbms71 log1orcl ora oracle_home database log1orcl ora rdbms71 log2orcl ora oracle_home database log2orcl ora rdbms71 archive ctl1orcl ora oracle_home database archive ctl1orcl ora rdbms71 archive logorcl1 ora oracle_home database archi...

Page 55: ...BMS73_ARCHIVE ctl1 ora Note By default RDBMS71_CONTROL ORACLE_HOME RDBMS71 RDBMS71_ARCHIVE ORACLE_HOME RDBMS71 ARCHIVE RDBMS73_CONTROL ORACLE_HOME DATABASE RDBMS73_ARCHIVE ORACLE_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 rdbms70 rdbms71 or rdbms72 in the initialization file to r...

Page 56: ...og2orcl ora SVRMGR C ORANT DATABASE dbs1orcl ora SVRMGR C ORANT RDBMS71 ARCHIVE log2orcl ora SVRMGR C ORANT DATABASE log1orcl ora SVRMGR C ORANT RDBMS71 sysorcl ora SVRMGR C ORANT DATABASE log2orcl ora SVRMGR C ORANT RDBMS71 userorcl ora SVRMGR C ORANT RDBMS71 rbsorcl ora SVRMGR C ORANT RDBMS71 temporcl ora to SVRMGR C ORANT DATABASE log1orcl ora SVRMGR C ORANT DATABASE ARCHIVE log1orcl ora SVRMGR...

Page 57: ...or PL SQL functionality catrep sql 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 check the file for errors Note catrep may take an hour or more to run 7 0 15 t...

Page 58: ...2 32 Oracle7 Server Getting Started for Windows NT ...

Page 59: ...dows 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 ...

Page 60: ...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 ...

Page 61: ...ablespaces in the Oracle7 Server for Windows NT starter 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 tablespace empty when the server is initially ins...

Page 62: ...at 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 ...

Page 63: ... 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 Ma...

Page 64: ...nager 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 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 i...

Page 65: ...rt the database automatically when the machine is booted Setting Startup Mode to Automatic will cause the following a new service is created OracleStart sid This service points to the executable STRTDB73 EXE a command file STRT sid CMD is created in ORACLE_HOME DATABASE This file contains the command line version of Instance Manager to start the database Please note that the command file contains ...

Page 66: ...n 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 ...

Page 67: ... dialog box choose Advanced The Advanced Parameters dialog box appears Instance Manager enables you to customize 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 ...

Page 68: ...ename 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 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 ...

Page 69: ...rver 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 STARTUP PFILE path filename where path filename specifies an initialization parameter file ...

Page 70: ...r 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 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 SET ORACLE_SID sid where sid is the name ...

Page 71: ... and remain at the command line To get a complete listing of ORADIM73 commands enter a question mark after the executable name C ORADIM73 To use ORADIM73 to create an instance called sid enter the following C ORADIM73 NEW SID sid INTPWD password 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...

Page 72: ... 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 preparing to create a new database creating a new database The following flow chart diagrams the decision process for the types of tools and protocols you use if you decide...

Page 73: ...for Windows NT without the starter database or if you are creating an additional database you 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...

Page 74: ... control files if the database contains important information Attention See the sections Setting the Archivelog Mode and Recovering the Database and Backing Up the Database in this chapter and Oracle7 Server Administrator s Guide for more information 5 Delete all the database files including data files redo log files and control files from the starter database SYS1ORCL ORA USR1ORCL ORA RBS1ORCL OR...

Page 75: ...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 MAXLOGFILES i...

Page 76: ...unting 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 STARTUP NOMOUNT PFILE path filename 5 If you created a SQL script file earlier execute the CREATE DATABASE statement stored in that script file by typing SVRMGR...

Page 77: ...hould also run any other SQL scripts at this time All SQL scripts for Oracle7 Server for Windows NT are stored in ORANT RDBMSnn ADMIN Attention See Advanced Replication Option if you will be creating a database for Advanced Replication at this time Additional Information ...

Page 78: ... in which the object size increases over time Additional Information The individual parameters of the STORAGE clause have the same defaults and minimum values as those described in the Oracle7 Server SQL Reference Setting Resource Costs 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 ou...

Page 79: ...ibes 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 mess...

Page 80: ...CII 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 SQLLDR73 options SQL Loader Processing Options Windows NT supports the following processing options VAR loa...

Page 81: ...le 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 Ora...

Page 82: ...y the number of users in the password file The default is 5 Attention Creating an instance using ORADIM73 in command line mode only creates the password file and related service The database is NOT created that is database files are not created EDIT Edit a database instance by specifying the following parameters EDIT SID sid NEWSID newsid INTPWD internal_pwd STARTMODE auto manual PFILE filename SI...

Page 83: ...BA_AUTHORIZATION or DBA_sid_AUTHORIZATION parameter is set to BYPASS For STARTTYPE specify SRVC for services INST for instance or both SHUTDOWN To stop an instance specify the following parameters SHUTDOWN SID sid USRPWD user_pwd SHUTTYPE SRVC INST SHUTMODE a i n where a is abort mode i is immediate mode and n is normal mode DELETE To delete any number of instances specify the following DELETE SID...

Page 84: ...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 ...

Page 85: ...T his chapter describes ways in which the tight integration between Oracle7 Server for Windows NT and the Windows NT operating system This topics are covered in this chapter Oracle7 and the Windows NT Performance Monitor Oracle7 Event Viewer database security starting services automatically using Windows NT OS authentication ...

Page 86: ... Additional Information For more information on the 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 Data Type Value Perf_File_Name REG_EXPAND_SZ ORACLE_HOME DBS PERF ORA Libr...

Page 87: ...e 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 Oracle7 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...

Page 88: ...uffer 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...

Page 89: ...ION is set to BYPASS 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 secu...

Page 90: ...cle7 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 Set the DBLINK_ENCRYPT_LOGIN initialization parameter on the server to TRUE 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...

Page 91: ...ay 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...

Page 92: ...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 ORACLE7 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 Y...

Page 93: ...tabase 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 ar...

Page 94: ...mportant to understand how roles and the privileges granted to these roles are obtained by Oracle users 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 SQL Net V2 with the Oracle username scott tiger the roles applied to the Oracle username SCOTT consist of all ...

Page 95: ...ing NTUSER2 then the following takes place when the user issues the command SVRMGR 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 ...

Page 96: ...4 12 Oracle7 Server Getting Started for Windows NT ...

Page 97: ...tabase 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 ...

Page 98: ...ption is on the database is in ARCHIVELOG mode 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 backing up active files restoring a...

Page 99: ... on which the backup copy should be saved 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 u...

Page 100: ...file C OCOPYnn B physicaldriveN a where N is the number s representing each of the physical drives in the system Restoring RAW Files To restore RAW files use the following syntax C OCOPYnn new_file c C OCOPYnn 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 need...

Page 101: ...re 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 l...

Page 102: ...odically 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 Oracle7 Server Administrator s Guide for information on creating and managing table snapshots Oracle7 Server for Windows NT also creates one or more background threads called Snapshot Refresh threads which can periodically refre...

Page 103: ...datable snapshot sites PL SQL and the distributed database option must also be installed catproc sql and catalog sql 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 10MB this re...

Page 104: ...on to the hardware and software requirements found in Installation the following are highly recommended a minimum of 32 MB memory 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 System Tablespace at least 20 MB of free space is required for repli...

Page 105: ...nds 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 Recommended 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 ...

Page 106: ...umentation for details on setting up a Master Definition Site Master Sites Updatable Snapshot Sites and Conflict Resolution Attention Execute the following statement on the master site when setting up updatable snapshot sites GRANT EXECUTE ON DBMSOBJGWRAPPER TO PUBLIC Other Notes The practical limit as to the number of Master Sites an environment may have is 10 The SNP0 to SNP9 process each handle...

Page 107: ...es a hexadecimal address of each row in a 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...

Page 108: ...5 12 Oracle7 Server Getting Started for Windows NT ...

Page 109: ...is appendix describes the documentation set included in your package It covers the following topics documentation catalog using the documentation roadmap documentation sets Note Documentation may be included in your package detailing products that you did not buy license ...

Page 110: ...QL 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 Ora...

Page 111: ...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 ...

Page 112: ...er 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 Understanding SQL Net Oracle Network Manager Administrator s Guide Oracle SNMP Support Reference Guide Secure Network Services Reference Guide SQL Plus...

Page 113: ... 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 Relea...

Page 114: ...s 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 e...

Page 115: ...t contains the following information the path for the Oracle7 Server documentation a step by step process for tuning the Oracle7 Server a description of diagnostic tools useful in tuning Oracle7 installation recommendations for optimal performance a list of all parts of the tuning process that vary depending on what operating system runs Oracle Oracle7 Server Application Developer s Guide Describe...

Page 116: ...ts that interface with Oracle7 Server Oracle7 Server Migration Aides database administrators and system 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 ...

Page 117: ...allel 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 includ...

Page 118: ...y 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 Provides information required to understand and use the problem resolution facilities of the following Oracle network products SQL Net version 2 0 and later MultiProtocol Interchange Oracl...

Page 119: ...and administers all Oracle network products based on the transparent network substrate TNS including SQL Net Oracle MultiProtocol Interchange Oracle Names Secure Network Services Oracle Native Naming Adapters 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 re...

Page 120: ...Migration Guide Oracle Names Administrator s Guide Contains examples and figures that refer to specific machine types network 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 s...

Page 121: ...rformance Monitoring User s Guide Oracle Enterprise Manager for Windows NT Installation Release Notes and Oracle Enterprise Manager Application Developer s Guide 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 ...

Page 122: ...A 14 Oracle7 Server Getting Started for Windows NT ...

Page 123: ...s 95 it is ORAWIN95 This section describes the directory structures created by the installation procedures appearing earlier in this guide These topics are covered Oracle for Windows NT Oracle for Windows Windows 95 Oracle WebServer Installation Types Note The following graphics directory structures represent typical directory structures that result from installing Oracle products for Windows NT W...

Page 124: ...er for Windows NT an RDBMS70 or 7 1 7 2 subdirectory 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...

Page 125: ...t II message files and other utility files NETWORK created when you install SQL Net V2 3 for Windows NT NETWORK also contains the three subdirectories described below NETWORK ADMIN ora configuration files used by SQL Net V2 3 for Windows NT NETWORK LOG log files placed here by default NETWORK TRACE trace files placed here by default See Oracle Network Products for Windows NT 95 User s Guide for ad...

Page 126: ...ows tools and the SQL Net networking software DBS Oracle Toolkit II message files and other utility files NETWORK various configuration files associated with SQL Net and the Oracle protocol adapters The NETWORK directory also contains the three subdirectories described below NETWORK ADMIN ora configuration files used by SQL Net V2 3 for Windows NT NETWORK LOG log files placed here by default NETWO...

Page 127: ...ver 1 0 and Oracle7 database on a single machine 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 through a two task driver ...

Page 128: ...B 6 Oracle7 Server Getting Started for Windows NT ...

Page 129: ...e every time an instance is started This appendix describes initialization parameter files specifies the parameters you need to set at the time you create a database 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 Gu...

Page 130: ... database uses whether filled online redo logs will be archived and which control files currently exist for the database 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 mu...

Page 131: ...ment 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 ...

Page 132: ...iptions 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 CONTROL_FILES ORACLE_HOME DATABASE CTL1 ORACLE_SID ORA Any valid path and filename DB_BLOCK_SIZE 2048 512 8192 DB_FILES 32 254 cannot exceed DB_BLOCK_BUFFERS DB_FILE_MULTIB...

Page 133: ...OOL_SIZE 6 500 000 300K Unlimited SORT_AREA_SIZE 65536 0 Unlimited SORT_READ_FAC 20 0 Unlimited SORT_SPACEMAP_SIZE 512 0 Unlimited TEMPORARY_TABLE_LOCKS SESSIONS 0 Unlimited TRANSACTIONS_PER_ROLLBACK_SEGMENT 30 1 255 USER_DUMP_DEST RDBMSnn TRACE Any valid directory These are the default values for the Replication Database global_name true job_queue_processes 2 job_queue_interval 10 snapshot_refres...

Page 134: ...C 6 Oracle7 Server Getting Started for Windows NT ...

Page 135: ... NT Registry Configuration Parameters and the Windows NT Registry 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 ...

Page 136: ...EGEDT32 included with your Windows NT software To access the Oracle configuration parameters in the Windows NT Registry type the following C 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 parameter_value is the value you choose A value you set ...

Page 137: ...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 General Parameters The following parameters define characteristics of Oracle7 Server for Windows NT and other Oracle products NLS_LANG Operating System Windows NT Default Legal Values supported languages territories and characte...

Page 138: ...oducts This directory is the top directory in the Oracle directory hierarchy ORACLE_PRIORITY 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 name1 priority1 name2 priority2 The name CLASS sets the priority class of the Oracle process...

Page 139: ...11 idle 1 1 1 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 the 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 th...

Page 140: ...ndows 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 RDBMSnn 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 ...

Page 141: ...A 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...

Page 142: ...Note Setting this parameter to zero causes the parameter to take its default value NMP_SPAWN_INCREMENT 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...

Page 143: ...n The final letter m in an available value name indicates monochrome mode REMOTE Operating System Windows NT SQL Net 4 Version 1 1 of SQL Net Named Pipes and SQL 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 Nam...

Page 144: ...ine at any time SQLNET 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 hav...

Page 145: ...ions 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 logging error messages Oracle Installer Messages Oracle Database Messages Windows NT Specific Oracle Messages SQL Net TCP IP Messages SQL Net Named Pipes Messages N...

Page 146: ...t while FILE2 ERR receives the standard error messages Installer Error Messages 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 ...

Page 147: ...me using correct syntax LEXICAL_ERROR An error has been detected in the installation scripts Call Oracle Customer Support LOCKING_VIOLATION A portion of the file specified in the full message has been locked by another process Release or terminate the other process or wait for it to complete OS_ERROR There is an unexpected operating system error Run a utility program to locate any problems with th...

Page 148: ... Run a utility program to diagnose the hard drive SHARING_VIOLATION The file specified in the full message has been locked by another process This 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 Too many files are open on Windows NT Close some of the open files WRITE_ERROR A...

Page 149: ...dition 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 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 s...

Page 150: ... size ORA 09240 smpalo error allocating PGA memory ORA 09241 smsalo error allocating SGA memory ORA 09242 smscre error creating SGA ORA 09243 smsget error attaching to SGA ORA 09244 smprset error setting memory protections ORA 09245 smcstk error switching stacks ORA 09246 sfsmap unable to map SGA ORA 09247 smsdes error destroying the SGA ORA 09260 sigpidu error obtaining process id ORA 09261 spdcr...

Page 151: ...c insufficient role name buffer space ORA 09280 sllfcf error closing file ORA 09281 sllfop error opening file ORA 09282 sllfrb error reading records ORA 09283 sllfsk error skipping records ORA 09290 sksaalo error allocating memory for archival ORA 09291 sksachk invalid device specification for LOG_ARCHIVE_DEST ORA 09292 sksabln unable to build file name ORA 09293 sksasmo unable to send message to ...

Page 152: ...gtd unable to obtain the current date and time ORA 09320 szrfc unable to obtain the list of valid OS roles ORA 09321 slzdtb unable to convert zoned decimal to binary ORA 09322 slpdtb unable to convert packed decimal to binary ORA 09330 session terminated internally by Oracle or by an Oracle DBA ORA 09331 scgcan unable to process lk_sync_cancel return code ORA 09332 scgcc unable to process lk_close...

Page 153: ...ows NT Each message in this section triggers an Oracle database message listed in the preceding section File I O Errors OSD 4000 to OSD 4099 OSD 04000 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 OSD 04001 invalid logical block size The logical block siz...

Page 154: ... and consult the Windows NT documentation OSD 04006 ReadFile failure unable to read from file There was an unexpected return from the Windows NT system service ReadFile Check the operating system error code and consult the Windows NT documentation OSD 04007 truncated read The system encountered an unexpected end of file which is due to damaged media Verify that the file is not damaged OSD 04008 Wr...

Page 155: ... delete the existing file OSD 04013 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 OSD 04014 unable to close file The media has been damaged Recover the file if necessary ...

Page 156: ...n If no operating system error code is presented verify that the media is not damaged OSD 04020 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 OSD 04023 SleepEx failure un...

Page 157: ...s NT system service MapViewOfFileEx Check the operating system error code and consult the Windows NT documentation OSD 04105 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 OSD 04106 unable to allocate memory with VirtualAlloc The program is out...

Page 158: ...the operating system error code and consult the Windows NT documentation OSD 04203 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 OSD 04204 invalid pid Process id not recognized by system process previously terminated Verify that process ID ...

Page 159: ...hread died holding the semaphore Restart Oracle7 instance OSD 04211 Thread information not found An Oracle7 thread died without deleting its information Restart Oracle7 instance OSD 04212 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 OSD 04213 Oracle thread unable to DuplicateHandle Th...

Page 160: ...ded 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 OSD 04301 record size too large The specified record size is too large to load Reduce record size and reload the data OSD 04302 invalid record type and or load options The control file s Windows NT file processing options str...

Page 161: ...r Contact Oracle Customer Support OSD 04502 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 OSD 04503 text contains no translatable elements The program cannot recognize variables in the text to be translated Check...

Page 162: ...4510 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 OSD 04511 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 OSD 04512 unable to translate the USE...

Page 163: ...st 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 ORA 06106 NETTCP socket creation failure The process open file quota was probably exceeded Contact your Oracle Customer Support representative ORA 06107 NETTCP ORACLE network server not found The entry for Oracle7 Server f...

Page 164: ...ess in length ORA 06113 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 ORA 06114 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 ...

Page 165: ...e 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 ORA 06120 NETTCP network driver not loaded The TCP IP network driver is not loaded Verify that the TCP IP driver loads correctly ORA 06121 NETTCP access failure The host s SQL Net TCP IP server was unable to te...

Page 166: ...er 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 not 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_SRVTnn_ SID OUT If the ORASRV output file does not indicate...

Page 167: ...P 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 ORA 06131 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 conte...

Page 168: ... 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 ORA 06137 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 C...

Page 169: ...nnect 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 ORA 06143 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 ...

Page 170: ...e error persists contact your DBA ORA 06223 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 SQL Net Named Pipes driver If the error persists contact your DBA ORA 06224 NETNMP Error sending data to pipe The system en...

Page 171: ... 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 ORA 06229 NETNMP Windows NT failed to create or access shared memory Unable to open shared memory segment containing the ...

Page 172: ...rk Products Messages Manual ORA 06401 NETCMN invalid driver designator The specified driver is unknown Check the last entry and resubmit the connect string using the designated name for the SQL Net driver ORA 06402 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 ORA 06403 NET...

Page 173: ...representative ORA 06409 NETCMN message send failure SQL Net driver failed to send a message across the communication channel Resubmit the connect string ORA 06410 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 ORA 06411 NETCMN message send failure The SQL Net drive...

Page 174: ... 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 ORA 06416 NETCMN error on test An error occurred while testing the I O status of the network connection Contact your Oracle Customer Support representative ORA 06419 NETCMN server cannot start oracle The Server was unable to start an Oracle process ...

Page 175: ...ailure in the communication nodes Contact your system administrator ORA 06422 NETCMN error in sending data SQL Net was unable to transmit data to Oracle7 Server for Windows NT Attempt to reconnect to the Server Contact your system administrator ORA 06423 NETCMN error in receiving data SQL Net was unable to receive data from the Server Attempt to reconnect to the Server Contact your system administ...

Page 176: ...E 32 Oracle7 Server Getting Started for Windows NT ...

Page 177: ...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 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 additio...

Page 178: ...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 values for language territory or character set you must install the complete set of langua...

Page 179: ...RMANY WE8ISO8859P1 GERMAN DIN GERMANY WE8ISO8859P1 GREEK GREECE EL8ISO8859P7 HEBREW ISRAEL IW8ISO8859P8 HUNGARIAN HUNGARY EE8ISO8859P2 ICELANDIC ICELAND WE8ISO8859P1 ITALIAN ITALY WE8ISO8859P1 JAPANESE JAPAN JA16EUC KOREAN KOREA KO16KSC5601 LATIN AMERICAN SPANISH AMERICA WE8ISO8859P1 LITHUANIAN LITHUANIA NEE8ISO8859P4 MEXICAN SPANISH MEXICO WE8ISO8859P1 NORWEGIAN NORWAY WE8ISO8859P1 POLISH POLAND ...

Page 180: ...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 i...

Page 181: ...eter 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 on the usage of the following parameters Languages AMERICAN FRENCH NORWEGIAN ARABIC GERMAN POLISH BRAZILIAN PORTUGUES...

Page 182: ...A BULGARIA ITALY SPAIN CANADA JAPAN SUDAN CATALONIA JORDAN SWEDEN CHINA KOREA SWITZERLAND CIS KUWAIT SYRIA CROATIA LEBANON THAILAND CZECH REPUBLIC LIBYA TAIWAN CZECHOSLOVAKIA LITHUANIA THE NETHERLANDS DENMARK MAURITANIA TUNISIA DJIBOUTI MEXICO TURKEY EGYPT MOROCCO UKRAINE ESTONIA NORWAY UNITED ARAB EMIRATES FINLAND OMAN UNITED KINGDOM FRANCE POLAND YEMEN GERMANY PORTUGAL GREECE QATAR ...

Page 183: ...AN8S AR8HPARABIC8T EEC8EUROPA3 RU8PC866 WE8NCR4970 AR8ISO8859P6 EL8DEC S7DEC WE8NEXTSTEP AR8MSWIN1256 EL8EBCDIC875 S7SIEMENS9780X WE8PC850 AR8MUSSAD768 EL8GCOS7 S8EBCDIC278 WE8PC860 AR8MUSSAD768T EL8ISO8859P7 SE8ISO8859P3 WE8ROMAN8 AR8NAFITHA711 EL8MACGREEK SF7ASCII WE8ROMAN8 AR8NAFITHA711T EL8MACGREEKS SF7DEC YUG7ASCII AR8NAFITHA721 EL8MSWIN1253 TH8MACTHAI AR8NAFITHA721T EL8PC437S TH8MACTHAIS AR8...

Page 184: ...ctories 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 RSF and NT_X86 V7 RDBMS subdirectories on the CD ROM to the ORANT subdirectories indicated in the following table In the filenames ...

Page 185: ...ISH 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 F SPANISH E GERMAN D SWEDISH S GERMAN DIN D THAI TH GREEK EL TRADITIONAL CHINESE ZHT HEBREW IW TURKISH TR HUNGARIAN HU UKRAINIAN U...

Page 186: ... Started for Windows NT 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 ...

Page 187: ...NT 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 requireme...

Page 188: ...18 catproc sql 3 8 CD ROM and online documentation A 2 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...

Page 189: ...ase 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_MULTIBLOCK_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_AUTHORIZ...

Page 190: ...d header 3 20 G GetFileInformationByHandle failure unable to obtain file info E 11 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 o...

Page 191: ...nal 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 selecti...

Page 192: ... parameter C 4 MTS_SERVERS parameter C 4 Multi processor machines 2 2 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 ...

Page 193: ...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 handsha...

Page 194: ... 09352 3 5 3 18 ORA_ENCRYPT_LOGIN 4 6 ORA_SQLDBA_MODE parameter D 5 ORA_SQLDBA_TERM parameter D 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 Oracl...

Page 195: ...s 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 RBS1ORCL ORA 3 4 3 ...

Page 196: ... Manager 1 10 3 12 definition of 1 8 for database monitoring 3 23 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 PA...

Page 197: ...A E 6 smsdes error destroying the SGA E 6 smsget error attaching to SGA E 6 SNAPSHOT_REFRESH_INTERVAL initialization parameter 5 6 SNAPSHOT_REFRESH_KEEP_CONNECTIO NS initialization parameter 5 6 SNAPSHOT_REFRESH_PROCESSES initialization parameter 5 6 SNP0 D 4 SNP9 D 4 Software networking 1 11 1 16 Software requirements client 2 18 SORT_AREA_SIZE parameter C 5 SORT_READ_FAC parameter C 5 SORT_SPACE...

Page 198: ...rocedures 1 8 SVRMGR CONNECT username password 3 11 SVRMGR STARTUP PFILE path filename 3 11 SVRMGR STARTUP PFILE C ORANT RDBMS73 INIT2 ORA 3 11 SVRMGR path filename 3 18 SVRMGR CONNECT INTERNAL PASSWORD 3 18 SVRMGR STARTUP NOMOUNT PFILE path filename 3 18 SYS1ORCL ORA 3 4 database file 3 16 SYSDBA 1 7 privileges granting 4 7 SYSOPER 1 7 privileges granting 4 7 System Global Areas SGAs C 3 System r...

Page 199: ...th 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 configuration variable on server E 18 User accounts of starter database 3 4 SCOTT 3 4 SYS 3 4 SYSTEM 3 4 USER_DUM...

Page 200: ...ver unable to spawn new Oracle task E 9 Windows NT two task driver Oracle task unexpectedly died E 9 Windows on Win32 WOW 2 4 Windows products B 4 Windows Windows 95 clients installation 2 16 2 18 WRITE_ERROR E 4 WRITE_PROTECTED E 5 WriteFile failure unable to write to file E 10 ...

Page 201: ...d more information If so where Are the examples correct Do you need more examples 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 Redwoo...

Page 202: ......