Oracle DBA manually creates a database through command line

1. When creating an Oracle database, we use dbca in most cases, which is simple, convenient, and automated;
2. Today, we will try to create a database manually using the command line method.
3. Oracle software version: 10gR2
4. Operating system version: win xp sp3
5. Destination data sid: t02
7. (1) create a dump and a folder for parameter files:
8. D: \ oracle \ product \ 10.2.0 \ admin \ t02
9. D: \ oracle \ product \ 10.2.0 \ admin \ t02 \ adump
10. D: \ oracle \ product \ 10.2.0 \ admin \ t02 \ bdump
11. D: \ oracle \ product \ 10.2.0 \ admin \ t02 \ cdump
12. D: \ oracle \ product \ 10.2.0 \ admin \ t02 \ dpdump
13. D: \ oracle \ product \ 10.2.0 \ admin \ t02 \ pfile
14. D: \ oracle \ product \ 10.2.0 \ admin \ t02 \ udump
16. (2) create a folder for datafile:
17. D: \ oracle \ product \ 10.2.0 \ oradata \ t02
19. (3) create a parameter file. You can copy the file from another database before modifying the file. Note the following:
20. D: \ oracle \ product \ 10.2.0 \ db_1 \Database\ Initt02.ora
22. ######################################## ######################################
23. # Copyright (c) 1991,200 1, 2002ByOracle Corporation
24. ######################################## ######################################
26. ######################################## ###
27. # NLS
28. ######################################## ###
29. Nls_language ="AMERICAN"
30. Nls_territory ="AMERICA"
32. ######################################## ###
33. # SGA Memory
34. ######################################## ###
35. Sga_target = 290455552
37. ######################################## ###
38. # Job Queues
39. ######################################## ###
40. Job_queue_processes = 10
42. ######################################## ###
43. # Shared Server
44. ######################################## ###
45. Dispatchers ="(PROTOCOL = TCP) (SERVICE = t02XDB )"
47. ######################################## ###
48. # Miscellaneous
49. ######################################## ###
50. Compatible = 10.2.0.1.0
52. ######################################## ###
53. # SecurityAndAuditing
54. ######################################## ###
55. Audit_file_dest = D: \ oracle \ product \ 10.2.0/admin/t02/adump
56. Remote_login_passwordfile = EXCLUSIVE
58. ######################################## ###
59. # Sort, Hash Joins, Bitmap Indexes
60. ######################################## ###
61. Pga_aggregate_target = 96468992
63. ######################################## ###
64. #DatabaseIdentification
65. ######################################## ###
66. Db_domain =""
67. Db_name = t02
69. ######################################## ###
70. # File Configuration
71. ######################################## ###
72. Control_files = ("D: \ oracle \ product \ 10.2.0/oradata/t02/\ control01.ctl","D: \ oracle \ product \ 10.2.0/oradata/t02/\ control02.ctl","D: \ oracle \ product \ 10.2.0/oradata/t02/\ control03.ctl")
73. Db_recovery_file_dest = D: \ oracle \ product \ 10.2.0/flash_recovery_area
74. Db_recovery_file_dest_size = 2147483648
76. ######################################## ###
77. # CursorsAndLibrary Cache
78. ######################################## ###
79. Open_cursors = 300
81. ######################################## ###
82. # System Managed UndoAnd RollbackSegments
83. ######################################## ###
84. Undo_management = AUTO
85. Undo_tablespace = UNDOTBS1
87. ######################################## ###
88. # DiagnosticsAnd Statistics
89. ######################################## ###
90. Background_dump_dest = D: \ oracle \ product \ 10.2.0/admin/t02/bdump
91. Core_dump_dest = D: \ oracle \ product \ 10.2.0/admin/t02/cdump
92. User_dump_dest = D: \ oracle \ product \ 10.2.0/admin/t02/udump
94. ######################################## ###
95. # ProcessesAndSessions
96. ######################################## ###
97. Processes = 150
99. ######################################## ###
100. # CacheAndI/O
101. ######################################## ###
102. DB _ block_size = 8192
103. Db_file_multiblock_read_count = 16
106. (4) create a password file:
107. Orapwd file = D: \ oracle \ product \ 10.2.0 \ db_1 \Database\ Pwdt02.oraPassword= Oracle entries = 2
109. (5) Create an instance (a service will be registered in windows ):
110. Oradim-new-sid t02
112. (6) to start the database to the nomount status, you must first set oracle_sid:
113. SetOracle_sid = t02
114. Sqlplus/AsSysdba
115. Startup nomount
117. (7) Create a database:
118. SelectStatusFromV $ instance;
119. Ed
120. Enter the following creation script content, save the content, enter the forward slash (/), and press enter to execute:
121. Create DatabaseT02
122. Datafile'D: \ oracle \ product \ 10.2.0 \ oradata \ t02 \ system01.dbf' Size100 M reuse autoextendOn Next10 M maxsize unlimited
123. Extent managementLocal
124. Sysaux datafile'D: \ oracle \ product \ 10.2.0 \ oradata \ t02 \ sysaux01.dbf'
125. Size100 M reuse autoextendOn Next10 M maxsize unlimited
126. Default TemporaryTablespaceTemp
127. Tempfile'D: \ oracle \ product \ 10.2.0 \ oradata \ t02 \ temp01.dbf' Size100 M reuse autoextendOn Next10 M maxsize unlimited
128. Undo tablespace"UNDOTBS1" -- Note that the undo tablespace corresponds to the parameter file.
129. Datafile'D: \ oracle \ product \ 10.2.0 \ oradata \ t02 \ undotbs01.dbf' Size100 M reuse autoextendOn Next10 M maxsize unlimited
130. DefaultTablespace users
131. Datafile'D: \ oracle \ product \ 10.2.0 \ oradata \ t02 \ users01.dbf' Size100 M reuse autoextendOn Next10 M maxsize unlimited
132. Logfile
133. Group1 ('D: \ oracle \ product \ 10.2.0 \ oradata \ t02 \ redo01.log')Size10 M,
134. Group2 ('D: \ oracle \ product \ 10.2.0 \ oradata \ t02 \ redo02.log')Size10 M,
135. Group3 ('D: \ oracle \ product \ 10.2.0 \ oradata \ t02 \ redo03.log')Size10 M
136. Character SetAl32utf8
137. National Character SetAl16utf16
138. UserSys identifiedByOracle
139. UserSystem identifiedByOracle
140. /
142. Now the database can be opened, but basic data dictionaries (such as dba_objects and dba_tablespaces) and
143. Basic built-in programs (such as dbms_output and dbms_session). Next we will create these objects.
145. (8) create a data dictionary:
146. @ D: \ oracle \ product \ 10.2.0 \ db_1 \ RDBMS \ ADMIN \ catalog. SQL;
148. (9) create a built-in program:
149. @ D: \ oracle \ product \ 10.2.0 \ db_1 \ RDBMS \ ADMIN \ catproc. SQL;
151. (10) Create scottSchema(Scott needs to use the users tablespace ):
152. @ D: \ oracle \ product \ 10.2.0 \ db_1 \ RDBMS \ ADMIN \ scott. SQL;
154. (11) Compile the productUserProfile (which must be executed by the system user ):
155. Conn system/oracle
156. @ D: \ oracle \ product \ 10.2.0 \ db_1 \ sqlplus \ admin \ pupbld. SQL;
158. (12) configure the listener:
159. D: \ oracle \ product \ 10.2.0 \ db_1 \ NETWORK \ ADMIN
161. Listener. ora
162. After the preceding steps, the system automatically adds a port (1522) to the existing listener, as shown below:
163. (In fact, only one port of 1521 can be connected to two databases at the same time.
164. This 1521 record exists because the local database t01 exists before the test Library (t02) is created)
165. LISTENER =
166. (DESCRIPTION_LIST =
167. (DESCRIPTION =
168. (ADDRESS = (PROTOCOL = IPC )(KEY= EXTPROC1 ))
169. (ADDRESS = (PROTOCOL = TCP) (HOST = PC1255-20110528) (PORT = 1521 ))
170. (ADDRESS = (PROTOCOL = TCP) (HOST = PC1255-20110528) (PORT = 1522 ))
171. )
172. )
174. Tnsnames. ora
175. If we want to use tns for connection, we also need to add the following configuration in tnsnames. ora:
176. (If NO 1522 rows are generated in the previous step, you only need to change 1522 to 1521 here)
177. T02 =
178. (DESCRIPTION =
179. (ADDRESS = (PROTOCOL = TCP) (HOST = PC1255-20110528) (PORT = 1522 ))
180. (CONNECT_DATA =
181. (SERVER = DEDICATED)
182. (SERVICE_NAME = t02)
183. )
184. )
186. (13) Verify with scott:
187. Sqlplus scott/tiger @ t02
188. Select*FromDept;
190. (14) Create an Enterprise Manager (EM ):
191. Emca-config dbcontrol db-reposCreate
194. T0nsha (liaodunxiaATGmail DOT com)
195. 20110714 @ Shanghai