Oracle7 ServerGetting Startedfor Windows NTRelease 7.3Part No. A42396–1The Relational Database Management System
x Oracle7 Server Getting Started for Windows NT Oracle7 Server 2 – 7. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Progr
Admin.Guide5 – 4 Oracle7 Server Getting Started for Windows NT Backing Up RAW FilesThis section describes how to back up Logical RAW files and Physica
5 – 5Database AdministrationUsing Trace and Alert FilesOracle7 Server for Windows NT background threads use trace files torecord occurrences and excep
Admin.GuideSQL Ref.5 – 6 Oracle7 Server Getting Started for Windows NT you might use the following syntax to redirect the output from theEXP73 utility
AdvancedReplication5 – 7Database AdministrationAdvanced Replication OptionThis section includes details not contained in the source documents forthe A
5 – 8 Oracle7 Server Getting Started for Windows NT replication option during Release 7.3 installation (see Installation in thisGuide).Using Advanced
5 – 9Database AdministrationInitialization Parameters for Advanced ReplicationThe following initialization parameters must be set or added to theINITs
☞5 – 10 Oracle7 Server Getting Started for Windows NT To confirm that CATREP ran correctly, run a query on ALL_OBJECTSwhere STATUS = ’INVALID’. (ie: S
SQL Ref.5 – 11Database AdministrationSQL*Language ConventionsThe Oracle7 Server SQL Reference describes all aspects of Oracle’simplementation of the S
5 – 12 Oracle7 Server Getting Started for Windows NT
A P P E N D I XATA – 1Documentation RoadmapDocumentationRoadmaphis appendix describes the documentation set included in your package.It covers the fol
xiContentsCreating a New Database 3 – 14. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Preparing to Create a New Database 3 – 15. .
A – 2 Oracle7 Server Getting Started for Windows NT Documentation CatalogThe following table lists the online documentation included with yourOracle7
A – 3Documentation RoadmapProduct Name Product DocumentationOracle Enterprise Manager Administrator’s GuideOracle Enterprise Manager for Windows NT In
A – 4 Oracle7 Server Getting Started for Windows NT RoadmapSQLLanguageApplDevConceptsUtilitiesMigrateAdminOracle7 Server for Windows NTGetting Started
A – 5Documentation RoadmapDocumentation SetsYour Oracle documentation is divided into the following sets:• Installation Guides• RDBMS• Networking• Pro
A – 6 Oracle7 Server Getting Started for Windows NT SQL*Plus for Windows NT/95 Installation and User’s GuideOperating system-specific information abou
A – 7Documentation Roadmapand the following special options: Distributed, Advanced Replication,Parallel Query, WebServer, Spatial Data, and Parallel S
A – 8 Oracle7 Server Getting Started for Windows NT Oracle7 Server ReferenceProvides reference information about Oracle7 Server release 7.3,including:
A – 9Documentation Roadmapand applications in a distributed environment. This manual is intendedto help you understand the concepts of distributed sys
A – 10 Oracle7 Server Getting Started for Windows NT Programmer’s Guide to the Oracle Pro*C PrecompilerComprehensive user’s guide and on–the–job refer
A – 11Documentation RoadmapUnderstanding SQL*NetProvides the information you need to understand and use SQL*NetRelease 2.3. This guide describes or pr
xii Oracle7 Server Getting Started for Windows NT Using Advanced Replication Option 5 – 8. . . . . . . . . . . . . . . . . . . System Requirements fo
A – 12 Oracle7 Server Getting Started for Windows NT meant to be used in conjunction with Oracle platform–specificdocumentation, you will also need to
A – 13Documentation Roadmapplatform. Other documentation about Oracle Enterprise Managerincludes: Oracle Enterprise Manager Performance Monitoring Use
A – 14 Oracle7 Server Getting Started for Windows NT
A P P E N D I XBOB – 1Oracle7 Server Directory StructuresOracle7 ServerDirectory Structuresracle Installer creates top–level directories on your hard
B – 2 Oracle7 Server Getting Started for Windows NT Windows NT Directory StructureOracle Installer places all Oracle products for Windows NT intosubdi
B – 3Oracle7 Server Directory StructuresDirectory Structure Directory Name Directory Contents\BIN executable, DLL, icon, and library files, such as th
B – 4 Oracle7 Server Getting Started for Windows NT Windows/ Windows 95 Directory StructureYou install Windows products on your Windows NT server mach
B – 5Oracle7 Server Directory StructuresOracle WebServer Installation TypesOracle WebServer 1.0 can be installed in one of two ways:• Oracle WebServer
B – 6 Oracle7 Server Getting Started for Windows NT
A P P E N D I XCOAdmin.GuideC – 1Initialization Parameter FilesInitialization ParameterFilesracle7 Server for Windows NT uses initialization parameter
xiiiContentsAppendix E Messages and Codes E – 1. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Logging Error Messages E – 2.
Admin.GuideC – 2 Oracle7 Server Getting Started for Windows NT What Is an Initialization Parameter File?An initialization parameter file is an ASCII t
C – 3Initialization Parameter FilesThe annotated, sample initialization parameter file contains alternativevalues for the initialization parameters. T
Admin.GuideC – 4 Oracle7 Server Getting Started for Windows NT control file for the initial database, CTL1ORCL.ORA, in\ORANT\DATABASE.If you created y
C – 5Initialization Parameter FilesRange of ValuesDefault ValueParameter NameOPEN_CURSORS 50 1 – UnlimitedOS_AUTHENT_PREFIX OPS$ any character stringP
C – 6 Oracle7 Server Getting Started for Windows NT
A P P E N D I XDTD – 1Configuration Parameters and the Windows NT RegistryConfigurationParameters and theWindows NT Registryhe Windows NT Registry sto
D – 2 Oracle7 Server Getting Started for Windows NT About Configuration ParametersOracle software uses configuration parameters to locate files and sp
Admin.GuideD – 3Configuration Parameters and the Windows NT Registrywhere parameter_name is the name of the parameter and parameter_valueis the value
☞D – 4 Oracle7 Server Getting Started for Windows NT ORACLE_GROUP_NAMEOperating System: Windows NTDefault: Oracle for Windows NTLegal Values: any ASCI
D – 5Configuration Parameters and the Windows NT RegistryCLASS:high;DEF:time_criticalSetting the Oracle process and the threads within it to otherprio
xiv Oracle7 Server Getting Started for Windows NT
D – 6 Oracle7 Server Getting Started for Windows NT This parameter specifies the mode in which Server Manager starts fromthe command line.ORA_SVRMGR_T
D – 7Configuration Parameters and the Windows NT RegistryNetworking ParametersThe following parameter applies to the SQL*Net V1 for Windows NTproducts
D – 8 Oracle7 Server Getting Started for Windows NT NMP_MIN_CLIENTSOperating System: Windows NTSQL*Net: SQL*Net:Default: 5Legal Values: 1 to NMP_MAX_C
D – 9Configuration Parameters and the Windows NT RegistryNMP_SPAWN_DELAYOperating System: Windows NTVersion 1.1 of SQL*Net Named Pipes0 milliseconds (
D – 10 Oracle7 Server Getting Started for Windows NT SVRMGR>CONNECT username/password@p:The connect string includes only the network prefix (p:), w
A P P E N D I XETE – 1Messages and CodesMessages and Codeshis appendix lists error messages and codes that are specific toinstallation and operation o
CauseActionCauseActionCauseActionE – 2 Oracle7 Server Getting Started for Windows NT Logging Error MessagesYou can keep a log of the error messages yo
CauseActionCauseActionCauseActionCauseActionCauseActionCauseActionE – 3Messages and CodesFILE_NOT_FOUNDIt was not possible to locate a file on the sou
CauseActionCauseActionCauseActionCauseActionCauseActionE – 4 Oracle7 Server Getting Started for Windows NT READ_ERRORA problem has been detected on th
CauseActionE – 5Messages and CodesWRITE_PROTECTEDThe file or directory specified in the full message—in which Oracle software isto be installed—is wr
C H A P T E R1T1 – 1Introducing Oracle7 Server for Windows NTIntroducing Oracle7Server for Windows NThis chapter introduces you to Oracle7 Server for
E – 6 Oracle7 Server Getting Started for Windows NT ORA–09212 sfwfbmt: error writing to fileORA–09213 slgfn: error fabricating file nameORA–09214 sfdo
E – 7Messages and CodesORA–09264 sptpa: error flagging processORA–09265 spwat: error temporarily suspending processORA–09266 spawn: error starting an
E – 8 Oracle7 Server Getting Started for Windows NT ORA–09311 slsleep: error temporarily suspending processORA–09312 slspool: error spooling file to p
CauseActionCauseActionCauseActionE – 9Messages and CodesORA–09341 scumnt: unable to mount databaseORA–09350 Windows NT two–task driver unable to alloc
CauseActionCauseActionCauseActionCauseActionCauseActionCauseActionCauseActionE – 10 Oracle7 Server Getting Started for Windows NT OSD–04003 unable to
CauseActionCauseActionCauseActionCauseActionCauseActionCauseActionCauseActionE – 11Messages and CodesOSD–04010 option specified, file already existsTh
CauseActionCauseActionCauseActionCauseActionCauseActionCauseActionCauseActionE – 12 Oracle7 Server Getting Started for Windows NT OSD–04017 unable to
CauseActionCauseActionCauseActionCauseActionCauseActionCauseActionCauseActionE – 13Messages and CodesOSD–04102 unable to open/create file for shared m
CauseActionCauseActionCauseActionCauseActionCauseActionCauseActionCauseActionE – 14 Oracle7 Server Getting Started for Windows NT Process Errors: OSD–
CauseActionCauseActionCauseActionCauseActionCauseActionCauseActionCauseActionCauseActionE – 15Messages and CodesOSD–04208 OpenProcess() failure, unabl
1 – 2 Oracle7 Server Getting Started for Windows NT Special TermsNote the following special terms when using this Guide:A system that runs an Oracle–s
CauseActionCauseActionCauseActionCauseActionCauseActionCauseActionE – 16 Oracle7 Server Getting Started for Windows NT OSD–04216 Unable to find file h
CauseActionCauseActionCauseActionCauseActionCauseActionCauseActionCauseActionE – 17Messages and CodesOSD–04401 WaitForSingleObject() failure, unable t
CauseActionCauseActionCauseActionCauseActionCauseActionCauseActionCauseActionE – 18 Oracle7 Server Getting Started for Windows NT OSD–04507 password f
CauseActionCauseActionCauseActionCauseActionCauseActionCauseActionE – 19Messages and CodesOSD–04514 The NT Group name is too long for internal bufferT
CauseActionCauseActionCauseActionCauseActionCauseActionCauseActionCauseActionCauseE – 20 Oracle7 Server Getting Started for Windows NT An I/O error oc
ActionCauseActionCauseActionCauseActionCauseActionCauseActionCauseActionE – 21Messages and CodesSee the SQL*Net TCP/IP server log file for more inform
CauseActionCauseActionCauseActionCauseActionCauseActionE – 22 Oracle7 Server Getting Started for Windows NT ORA–06123: NETTCP: cannot set KEEPALIVETh
CauseActionCauseActionCauseActionCauseActionCauseActionCauseActionE – 23Messages and CodesORA–06128: NETTCP: unable to create mailboxThe host’s SQL*N
CauseActionCauseActionCauseActionCauseActionCauseActionCauseActionE – 24 Oracle7 Server Getting Started for Windows NT ORA–06134: NETTCP: file access
CauseActionCauseActionCauseActionCauseActionCauseActionE – 25Messages and CodesORA–06141: NETTCP: no privilege for userA proxy login connect attempt
DistributedOption1 – 3Introducing Oracle7 Server for Windows NTthat help you complete database tasks efficiently.Oracle Database Tools include: Databa
CauseActionCauseActionCauseActionCauseActionCauseActionCauseActionE – 26 Oracle7 Server Getting Started for Windows NT ORA–06220: NETNMP: Server not
CauseActionCauseActionCauseActionCauseActionCauseActionCauseActionE – 27Messages and CodesORA–06226: NETNMP: Send byte count errorAn error was encoun
CauseActionCauseActionCauseActionCauseActionCauseActionCauseActionE – 28 Oracle7 Server Getting Started for Windows NT ORA–06232: NETNMP: Unable to c
CauseActionCauseActionCauseActionCauseActionCauseActionCauseActionCauseActionE – 29Messages and CodesORA–06406: NETCMN: error sending break messageTh
CauseActionCauseActionCauseActionCauseActionCauseActionCauseActionE – 30 Oracle7 Server Getting Started for Windows NT ORA–06413: NETCMN: connection
CauseActionCauseActionCauseActionE – 31Messages and CodesORA–06421: NETCMN: error detected in the read–in dataAn error occurred in the recomputation
E – 32 Oracle7 Server Getting Started for Windows NT
A P P E N D I XFAdmin.GuideF – 1National Language SupportNational LanguageSupportThe Oracle7 Server for Windows NT provides National LanguageSupport (
☞F – 2 Oracle7 Server Getting Started for Windows NT NLS_LANGWhen you install Oracle7 Server for Windows NT, you select a languagefor database message
F – 3National Language SupportLanguage Territory CharsetAMERICAN AMERICA US7ASCIIARABIC UNITED ARAB EMIRATES AR8ISO8859P6BRAZILIAN PORTUGUESE BRAZIL W
SDOOracle7 ServerTuningOracle EnterpriseManagerWebServerUser’s GuideAdvancedReplication1 – 4 Oracle7 Server Getting Started for Windows NT Volume I: D
Admin.GuideF – 4 Oracle7 Server Getting Started for Windows NT Selecting Alternate Territories and Character SetsAlthough the languages have default t
F – 5National Language SupportNLS_SORTThe value for the NLS_SORT initialization parameter is dependent onthe language selected for the database instan
F – 6 Oracle7 Server Getting Started for Windows NT TerritoriesALGERIA HONG KONG ROMANIAAMERICA HUNGARY SAUDI ARABIAAUSTRIA ICELAND SLOVAKIABAHRAIN IR
F – 7National Language SupportSingle–byte Character SetsAR7AMEER D8EBCDIC273 IW8ISO8859P8 WE8EBCDIC284AR7ASMO449PLUS DK7SIEMENS9780X IW8MSWIN1255 WE8E
F – 8 Oracle7 Server Getting Started for Windows NT Multi Byte Character SetsAL24UTFFSS JA16SJIS KO16DBCS ZHT16DBTJA16DBCS JA16TSTSET KO16KSC5601 ZHT3
F – 9National Language SupportLanguageLanguage FileAbbreviationLanguage Language FileAbbreviationAMERICAN US ITALIAN IARABIC AR JAPANESE JABRAZILIAN P
F – 10 Oracle7 Server Getting Started for Windows NT For example, the following list is the complete set of American languagefiles:ORAUS.MSB PCMUS.MSB
Index – 1IndexSymbols’REMOTE_OS_AUTHENT’ variable not set toTRUE, E – 18–DELETE, ORADIM73 command, 3 – 25–EDIT, ORADIM73 command, 3 – 24–NEW, ORADIM7
Index – 2 Oracle7 Server Getting Started for Windows NT BBACKGROUND_DUMP_DEST initializationparameter, 5 – 5, C – 4Backing upa database, 5 – 2active
Index – 3statement, 3 – 17, 3 – 18CREATE DATABASE command, 3 – 17CreateProcess() failure, unable to spawnprocess, E – 14CTL1ORCL.ORA, 3 – 4, 3 – 16in
Migration1 – 5Introducing Oracle7 Server for Windows NT•Instance Manager (GUI version)—a GUI version of InstanceManager is included in this release. A
Index – 4 Oracle7 Server Getting Started for Windows NT DISK_FULL, E – 2Distributed Option, 1 – 3, 2 – 9DISTRIBUTED_TRANSACTIONS parameter,C – 4Docum
Index – 5Installclient, selective, 2 – 21Networking Products, 2 – 12server, selective, 2 – 16Installationfirst time, 2 – 5Networking Products, 2 – 6O
Index – 6 Oracle7 Server Getting Started for Windows NT LOG1ORCL.ORA, 3 – 4, 3 – 16LOG2ORCL.ORA, 3 – 4, 3 – 16LOGFILE parameter, 3 – 10, 5 – 5Logging
Index – 7NETNMP: Send byte count error, E – 27NETNMP: Server not specified in commandline, E – 26NETNMP: SQL*Net handshake error, E – 27NETNMP: U
Index – 8 Oracle7 Server Getting Started for Windows NT NLS_LANGUAGE parameter, C – 4NLS_SORT parameter, C – 4, F – 5NLS_TERRITORY parameter, C – 4NM
Index – 9Oracle7 Server–Clients, installation, 2 – 13Oracle7 utilities, 2 – 3OracleServiceORCL, 3 – 5OracleStartORCL, 3 – 5OracleTNSListener, 3 – 5Or
Index – 10 Oracle7 Server Getting Started for Windows NT REMOTE_LOGIN_PASSWORDFILE=SHARED, 4 – 6Removing, Options, 2 – 23Removing product components,
Index – 11SHARING_VIOLATION, E – 4SHUTDOWN, command, 3 – 16SID, 3 – 2, 3 – 7sigpidu: error obtaining process id, E – 6sksaalo: error allocating memor
Index – 12 Oracle7 Server Getting Started for Windows NT required configuration files, 2 – 22TNSNAMES.ORA file, 2 – 22SQL*Net version 2.2 networking
Index – 13TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter, C – 5translations nested too deep, E – 17Transport protocoland the MultiProtocol Interchange,
Oracle7 Server Getting Started for Windows NT , Release 7.3Part No. A42396–1Copyright 1996 Oracle CorporationAll rights reserved. Printed in the U
NetworkManager1 – 6 Oracle7 Server Getting Started for Windows NT Features Specific to Windows NTThis Guide describes a number of features unique to O
Index – 14 Oracle7 Server Getting Started for Windows NT Windows NT two–task driver unable to spawnnew Oracle task, E – 9Windows NT two–task driver:
Reader’s Comment FormName of Document: Oracle7 Server Getting Started for Windows NT Part No. A42396–1Oracle Corporation welcomes your comments and s
ServerReference1 – 7Introducing Oracle7 Server for Windows NTCONNECT INTERNAL command. With Release 7.3, the following twosteps ensure database securi
1 – 8 Oracle7 Server Getting Started for Windows NT •networking software—software used to provide connectivityamong database clients and serversServer
PL/SQLUser’s GuideServerUtilities1 – 9Introducing Oracle7 Server for Windows NTSQL*NetSQL*Net is the network interface that enables client workstation
1 – 10 Oracle7 Server Getting Started for Windows NT Database ToolsThe database tools appear as icons in the Program Manager (Explorerfor Windows 95).
NetworkManager1 – 11Introducing Oracle7 Server for Windows NTOracle Networking SoftwareSQL*Net is the Oracle network interface that enables front–enda
OracleNames1 – 12 Oracle7 Server Getting Started for Windows NT case, a server could connect to a client running a protocol different fromthose availa
C H A P T E R2T☞2 – 1Installing Oracle7 Server for Windows NTInstalling Oracle7Server for Windows NThis chapter covers the following installation topi
☞2 – 2 Oracle7 Server Getting Started for Windows NT A Note on DirectoriesThis Guide assumes that all directory names are the default namescreated dur
2 – 3Installing Oracle7 Server for Windows NT• Available disk space—90 MB of free hard disk space (125 MB ifyou want to install all of the online docu
T iiiPrefacePrefacehis User’s Guide is your primary source of introductory,installation, and configuration information for Oracle7 Server forWindows N
☞☞2 – 4 Oracle7 Server Getting Started for Windows NT Windows on Win32 (WOW)Most products running on Windows NT machines (including Oracle7Server for
2 – 5Installing Oracle7 Server for Windows NTBefore You InstallBefore you install Oracle7 Server for Windows NT software on yourWindows NT server, per
2 – 6 Oracle7 Server Getting Started for Windows NT Installation Types—Windows NTThe ways in which Oracle7 Server for Windows NT installation forWindo
2 – 7Installing Oracle7 Server for Windows NT– SQL*Net Protocol Adapters– Oracle Call Interface– Oracle Enterprise Manager– Oracle InstallerOracle7 Se
2 – 8 Oracle7 Server Getting Started for Windows NT SelectiveInstall your choice of:• Oracle Call Interface• Oracle Documentation• Oracle Enterprise M
☞☞2 – 9Installing Oracle7 Server for Windows NTOptions—Windows NT ServerThis release of Oracle7 Server for Windows NT offers the followingoptions:• Di
2 – 10 Oracle7 Server Getting Started for Windows NT However, you should complete Step 2 below to ensure that youuse the current release of Oracle Ins
2 – 11Installing Oracle7 Server for Windows NT– Choose the INSTALL directory icon.– Choose the ORAINST.EXE file icon.If you are using Oracle Installer
2 – 12 Oracle7 Server Getting Started for Windows NT When you run Oracle Installer from the Oracle7 Server forWindows NT CD, Oracle Installer prompts
2 – 13Installing Oracle7 Server for Windows NTIf you choose Oracle Documentation:a. Select Oracle Documentation in the Software Asset Manager toinstal
Oracle7Concepts iv Oracle7 Server Getting Started for Windows NT AudienceThis Guide is necessary for anyone installing, configuring, oradministering O
2 – 14 Oracle7 Server Getting Started for Windows NT If you choose Oracle7 Server:a. Select Oracle7 Server in the Software Asset Manager to installthe
2 – 15Installing Oracle7 Server for Windows NTk. Click OK. The Oracle WebServer Post–Installation dialog boxappears displaying the URL you must open t
2 – 16 Oracle7 Server Getting Started for Windows NT If you choose Selective:a. Choose {Selective Product Install} in the Software AssetManager. You c
2 – 17Installing Oracle7 Server for Windows NT– Oracle Installer• Database Administrator– Oracle7 Utilities– Database Administration Tools– SQL*Plus–
2 – 18 Oracle7 Server Getting Started for Windows NT Client System RequirementsThe following sections specify the hardware and software requirementsfo
2 – 19Installing Oracle7 Server for Windows NTInsert the Oracle7 Server for Windows NT CD–ROM into yourCD–ROM drive. Verify that the drive is mapped t
2 – 20 Oracle7 Server Getting Started for Windows NT When you select the language, Oracle Installer sets the NLS_LANGconfiguration parameter. National
2 – 21Installing Oracle7 Server for Windows NTd. Click OK to begin the installation. The SQL*Net ProtocolAdapters dialog box appears.e. Choose the SQL
2 – 22 Oracle7 Server Getting Started for Windows NT Note: The questions/dialog boxes that appear will varydepending upon the product choices you mak
2 – 23Installing Oracle7 Server for Windows NTAdditional SQL*Net release 2.3 connections must be manuallyconfigured with the Oracle Network Manager. S
vPrefaceChapter 5 Database MaintenanceInstructions for performing ongoing database maintenance tasks usinggraphical and command–line procedures.Appen
2 – 24 Oracle7 Server Getting Started for Windows NT 2. Choose Remove.Oracle Installer warns you of any product dependencies that mightcause problems
2 – 25Installing Oracle7 Server for Windows NTsize (for example, the following SQL statement adds an 8MB file to theSYSTEM tablespace:alter tablespace
2 – 26 Oracle7 Server Getting Started for Windows NT Use orainst.exe to de–install 7.0/7.1/7.2 Server, RequiredSupport Files and Utilities.Refer to th
2 – 27Installing Oracle7 Server for Windows NTd. Create the ORACLE_SID value with data typeREG_EXPAND_SZ and the SID you chose earlier in the stringfi
2 – 28 Oracle7 Server Getting Started for Windows NT Using the above example (and if the current control file is indirectory c:\orant\rdbms71):Move To
2 – 29Installing Oracle7 Server for Windows NTInto:\DATABASE\INITsid.ORAb. Edit the CONTROL_FILES parameter in the Release 7.3initialization file for
2 – 30 Oracle7 Server Getting Started for Windows NT SVRMGR> connect internal/<password for the instance>SVRMGR> startup exclusive mountNo
2 – 31Installing Oracle7 Server for Windows NT7.0.15 to 7.3 7.1.3 to 7.3 7.2.2 to 7.3SVRMGR> alter database open; SVRMGR> alter database open; S
2 – 32 Oracle7 Server Getting Started for Windows NT
C H A P T E R3T3 – 1Using Oracle7 Server for Windows NTUsing Oracle7 Serverfor Windows NThis chapter describes how to set up and use the Oracle7 Serve
vi Oracle7 Server Getting Started for Windows NT InstallationSee Installing Oracle7 Server for Windows NT of this Guide and theaccompanying Release N
3 – 2 Oracle7 Server Getting Started for Windows NT Overview of Database Administration TasksThis section introduces you to the starter database insta
Admin.GuideStarter DatabaseTablespace Structure3 – 3Using Oracle7 Server for Windows NTNote: The starter database is installed to operate inNOARCHIVE
Starter Database FilesServer Alert FilesUser Accounts3 – 4 Oracle7 Server Getting Started for Windows NT The starter database contains the following d
☞3 – 5Using Oracle7 Server for Windows NTOracle ServicesWhen you start or reboot the server machine, Oracle services are started.Depending on the netw
☞3 – 6 Oracle7 Server Getting Started for Windows NT Instance ManagerInstance Manager is a graphical tool used to create and modifyinstances. This sec
3 – 7Using Oracle7 Server for Windows NTThe New Instance dialog box appears.3. Type a SID (up to four characters; remember that each SID must beunique
☞3 – 8 Oracle7 Server Getting Started for Windows NT views) and catproc.sql (if you will be using PL/SQL). Ifyou choose Yes, Instance Manager spawns S
3 – 9Using Oracle7 Server for Windows NTAdvanced ParametersFrom the New Instance dialog box, choose Advanced. The AdvancedParameters dialog box appear
SQL Ref.3 – 10 Oracle7 Server Getting Started for Windows NT Parameter DescriptionLOGFILE filespec Specify the redo log filenames to be created and m
3 – 11Using Oracle7 Server for Windows NTStarting a Database Using Instance ManagerDatabases can be started using Instance Manager (by selecting theSe
☞ viiPrefaceConventions Used in this GuideNote these typographical conventions when reading this Guide:Type text exactly as shown. Text typed for acom
3 – 12 Oracle7 Server Getting Started for Windows NT Delete an InstanceTo delete an instance:Warning: Deleting an instance also deletes the database
3 – 13Using Oracle7 Server for Windows NTCreating an InstanceThe Instance Manager command line tool is run with theORADIM73.EXE executable. To use thi
3 – 14 Oracle7 Server Getting Started for Windows NT where sid is the system identifier (SID) of the database, SRVC,INSTindicates that both the servic
3 – 15Using Oracle7 Server for Windows NTNoYesDo you want to replacethe starter database?Use the Instance Manager to create an instanceUse EXP toexpor
Oracle7 Utilities☞3 – 16 Oracle7 Server Getting Started for Windows NT Additional Information: When you run the EXP utility fromWindows NT workstatio
☞☞☞SQL Ref.3 – 17Using Oracle7 Server for Windows NTAttention: The CONTROL_FILES parameter in theINITsid.ORA file must specify the complete path(s)
☞3 – 18 Oracle7 Server Getting Started for Windows NT Starting an Instance and Creating the DatabaseFollow these steps to create a new database:1. Sta
☞Admin.GuideUtilities3 – 19Using Oracle7 Server for Windows NTYou should also run any other SQL scripts at this time. All SQLscripts for Oracle7 Serve
Admin.GuideSQL3 – 20 Oracle7 Server Getting Started for Windows NT Creating Database ObjectsOnce you have created new database files, as described in
Admin.Guide3 – 21Using Oracle7 Server for Windows NT•CPU time used by each user’s session on the server machineAdditional Information: See Oracle7 Se
viii Oracle7 Server Getting Started for Windows NT Additional Information: Highlights text referring you to otherparts of the other Oracle documenta
3 – 22 Oracle7 Server Getting Started for Windows NT C:\> EXP73 [options]ImportUse the Import utility to import database tables and other objects t
3 – 23Using Oracle7 Server for Windows NTUtilities. The directory \ORANT\RDBMS73\LOADER containsa number of examples on the use of SQL*Loader.Control
☞3 – 24 Oracle7 Server Getting Started for Windows NT Instance Manager Command Line CommandsThis section describes the ORADIM73 commands and parameter
3 – 25Using Oracle7 Server for Windows NT–STARTUPTo start an instance, specify the following parameters:–STARTUP –SID <sid>–PFILE <filename&g
3 – 26 Oracle7 Server Getting Started for Windows NT ORADIM LogWhen you use ORADIM73 in command line mode, Instance Manageropens a log file (ORADIM73.
C H A P T E R4T4 – 1Getting the Most out of Integration with Windows NTGetting the Most out ofIntegration withWindows NThis chapter describes ways in
4 – 2 Oracle7 Server Getting Started for Windows NT Oracle7 and the Windows NT Performance MonitorOracle7 Server for Windows NT takes advantage of the
4 – 3Getting the Most out of Integration with Windows NTAdditional Information: For more information on thePerformance Monitor, see your operating s
4 – 4 Oracle7 Server Getting Started for Windows NT Note: The percentage is calculated as a Miss ratio: ReducingBuffer Cache Misses expresses the cal
4 – 5Getting the Most out of Integration with Windows NTEvent ViewerThe Windows NT Event Viewer displays warnings and errors about theOracle7 database
ixContentsContentsChapter 1 Introducing Oracle7 Server for Windows NT 1 – 1. . . . . . . . . . . . . . Special Terms 1 – 2. . . . . . . . . . . . . .
☞4 – 6 Oracle7 Server Getting Started for Windows NT found, the user is granted or denied privileged access to thedatabase• REMOTE_LOGIN_PASSWORDFILE=
4 – 7Getting the Most out of Integration with Windows NTCreating Password FilesYou create password files with the Instance Manager, as part of theproc
4 – 8 Oracle7 Server Getting Started for Windows NT For example, to enroll a user whose NT username is FRANK, when theOS_AUTHENT_PREFIX id set to XYZ,
4 – 9Getting the Most out of Integration with Windows NTOne INITsid.ORA parameter must be properly set before Windows NTgroups can be used to grant a
4 – 10 Oracle7 Server Getting Started for Windows NT •ORA_ORCL_RESOURCE_D(predefined ROLE; active even if OS ROLES is false)In this example, when a da
4 – 11Getting the Most out of Integration with Windows NTusername being NTUSER2), then the following takes place when theuser issues the command SVRMG
4 – 12 Oracle7 Server Getting Started for Windows NT
C H A P T E R5T5 – 1Database AdministrationDatabaseAdministrationhis chapter explains how to perform the following routine databasetasks using the Ora
Admin.Guide5 – 2 Oracle7 Server Getting Started for Windows NT Backup ManagerBackup Manager is one of the Windows NT–based databasemanagement tools in
5 – 3Database Administrationwhere nn indicates the version of OCOPY Release 7.3 or later, old_filespecifies the name and location of the open file you
Kommentare zu diesen Handbüchern