Oracle A423961 Manuale Utente Scaricare il pdf (Pagina 77)

☞

Admin.

Guide

Utilities

3 – 19Using Oracle7 Server for Windows NT

You should also run any other SQL scripts at this time. All SQL

scripts for Oracle7 Server for Windows NT are stored in

\ORANT\RDBMS

\ADMIN.

Attention: See Advanced Replication Option if you will be

creating a database for Advanced Replication at this time.

Additional Information:

1 2 ... 72 73 74 75 76 77 78 79 80 81 82 ... 201 202

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

Commenti su questo manuale

Nessun commento

Oracle A423961 Manuale Utente Pagina 77

Commenti su questo manuale

Prodotti e manuali riguardandi Computer Oracle A423961