Oracle A423961 manuals

Oracle A423961 User Manual (202 pages)

Brand: Oracle | Category: Computers | Size: 1.23 MB |

English

Table of contents

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

More products and manuals for Computers Oracle

Models	Document Type
A54857-03	User Manual Oracle A54857-03 User Manual, 80 pages

Oracle devices