Oracle A423961 User Manual Page 97
- Page / 202
- Table of contents
- BOOKMARKS
Rated. / 5. Based on customer reviews
C H A P T E R
5
T
5 – 1Database Administration
Database
Administration
his chapter explains how to perform the following routine database
tasks using the Oracle7 Utilities for Windows NT:
• backup manager
• hot database file backup
• recovery manager
• refreshing table snapshots
• using trace and alert files
• logging error messages
• advanced replication option
• SQL language conventions
SQL language conventions specific to Windows NT are discussed at the
end of this chapter.
- Release 7.3 1
- Audience 4
- How this Guide Is Organized 4
- Using the Documentation 5
- Monospace text 7
- Reader Comments 8
- Contents 9
- xiContents 11
- xiiiContents 13
- Introducing Oracle7 15
- Server for Windows NT 15
- Special Terms 16
- Feature Highlights 17
- Windows NT Services 20
- Security Features 20
- Server—Windows NT 22
- Oracle7 Server for Windows NT 22
- Oracle7 Utilities 22
- SQL*Plus 23
- Secure Network Services 23
- Required Support Files 23
- Client Software 23
- Oracle Networking Software 25
- SQL*Net Version 2 25
- Network Manager 25
- Installing Oracle7 27
- System Requirements—Server 28
- Software 29
- Windows on Win32 (WOW) 30
- Windows NT 30
- Before You Install 31
- Installation Types—Windows NT 32
- Programmer/2000 33
- Selective 34
- Windows NT Installations 35
- Using Oracle Installer 35
- Oracle7 Client 42
- Oracle Documentation 43
- Client System Requirements 44
- Hardware Requirements 44
- Software Requirements 44
- Configuring SQL*Net 48
- Overview 50
- Prepare for the Migration 50
- Install the Oracle7 Server 52
- Move Database Files 53
- SVRMGR> shutdown 57
- SVRMGR> startup 57
- Using Oracle7 Server 59
- What is an Instance? 60
- The Starter Database 60
- TMP1ORCL.ORA 62
- Oracle Services 63
- Instance Manager 64
- Changing Passwords 66
- Advanced Parameters 67
- Starting a Database 68
- C:\>SVRMGR73 69
- Delete an Instance 70
- Running Multiple Instances 70
- Using Server Manager 70
- Creating an Instance 71
- Starting an Instance 71
- Creating a New Database 72
- Run Server Mgr & 73
- C:\>SVRMGR73 [MODE=LINE] 74
- SQL Ref 75
- SET ORACLE_SID=ABC 76
- SVRMGR>@[path]filename 76
- Utilities 77
- Creating Database Objects 78
- Setting Resource Costs 78
- Using Export and Import 79
- Using SQL*Loader 80
- SQL*Loader Processing Options 80
- Control File Conventions 81
- Using the MONITOR Command 81
- –STARTUP 83
- –SHUTDOWN 83
- ORADIM Log 84
- Getting the Most out of 85
- Integration with 85
- Performance Monitor Objects 87
- Memory Allocation Objects 87
- Tuning I/O 88
- Tuning Contention 88
- Additional Tuning Contentions 88
- Event Viewer 89
- Database Security 89
- Database Password Encryption 90
- Creating Password Files 91
- NT GROUPS and ROLES 92
- OS_ROLES must be set to TRUE 93
- ORA_%SID%_ROLENAME[_[D][A]] 93
- • CONNECT / as sysdba 94
- • CONNECT / as sysoper 94
- • CONNECT INTERNAL 94
- Database 97
- Administration 97
- Backup Manager 98
- Hot Database File Backup 98
- Restoring Active Files 99
- Recovery Manager 100
- Using Trace and Alert Files 101
- Logging Error Messages 101
- Refreshing Table Snapshots 102
- Advanced Replication Option 103
- Master Site Parameters 105
- Setup Procedures 105
- Other Notes 106
- SQL*Language Conventions 107
- Documentation 109
- Documentation Catalog 110
- A – 3Documentation Roadmap 111
- Documentation Sets 113
- Installation Documentation 113
- Oracle7 Release Notes 113
- Oracle7 Tuning 115
- Oracle7 Server SQL Reference 115
- A – 9Documentation Roadmap 117
- Understanding SQL*Net 119
- Using Oracle Documentation 121
- Oracle7 Server 123
- Directory Structures 123
- Initialization Parameter 129
- Initialization Parameters 132
- Configuration 135
- Parameters and the 135
- Windows NT Registry 135
- C:\>REGEDT32 136
- General Parameters 137
- Networking Parameters 141
- NMP_SPAWN_INCREMENT 142
- Messages and Codes 145
- Installer Error Messages 146
- E – 3Messages and Codes 147
- E – 5Messages and Codes 149
- E – 7Messages and Codes 151
- E – 9Messages and Codes 153
- E – 11Messages and Codes 155
- E – 13Messages and Codes 157
- E – 15Messages and Codes 159
- E – 17Messages and Codes 161
- E – 19Messages and Codes 163
- E – 21Messages and Codes 165
- SQLNET ORASRV_WAIT = 166
- ORA_SRVTnn_[SID].OUT 166
- E – 23Messages and Codes 167
- E – 25Messages and Codes 169
- E – 27Messages and Codes 171
- E – 29Messages and Codes 173
- E – 31Messages and Codes 175
- National Language 177
- NLS_LANG 178
- Language Territory Charset 179
- Using ALTER SESSION 180
- Parameter Lists 181
- Territories 182
- Single–byte Character Sets 183
- Multi Byte Character Sets 184
- Language 185
- Language File 185
- Abbreviation 185
- Language Language File 185
- Index – 1 187
- Index – 3 189
- Index – 5 191
- Index – 7 193
- Index – 9 195
- Index – 11 197
- Index – 13 199
- Reader’s Comment Form 201
Related products and manuals for Computers Oracle A423961
Computers Oracle A54857-03 User Manual
(80 pages)
(80 pages)
© 2020, manymanuals.com. All rights reserved. | 0.069 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals