ORACLE: After installing 11gr2, check "Basic initialization parameters".

 

The following conclusions can be drawn:

• Most basic parameters need to be set
• Parameters related to the OS path need to be set
• Basic memory, process, and cursor parameters need to be set
• If you set parameters in spfile, you can obtain them from {isspecified = false} of [V $ spparameter ].
• Are basic parameters required? And can be modified? It does not matter. There are two different perspectives.

 

Appendix: Basic parameters

 

	Name	Type	Isbasic	Isses _ Modifiable	Issys _ Modifiable	Description
1	Compatible	String	True			Database will be Completely compatible with this software version
2	Control_files	String	True			Control File Names List
3	Db_block_size	Integer	True			Size of Database Block in bytes
4	Db_domain	String	True			Directory part Global Database Name stored with create database
5	Db_name	String	True			Database Name Specified in create database
6	Db_recovery_file_dest	String	True		Immediate	Default Database Recovery File Location
7	Db_recovery_file_dest_size	Big integer	True		Immediate	Database recovery Files size limit
8	Nls_language	String	True	True		NLS language name
9	Nls_territory	String	True	True		NLS territory name
10	Open_cursors	Integer	True		Immediate	Max # cursors per Session
11	Processes	Integer	True			User processes
12	Remote_login_passwordfile	String	True			Password File Usage Parameter
13	Sga_target	Big integer	True		Immediate	Target size of SGA
14	Undo_tablespace	String	True		Immediate	Use/switch undo Tablespace
15	Cluster_database	Boolean	True			If true startup in Cluster database mode
16	Db_create_file_dest	String	True	True	Immediate	Default Database Location
17	Db_create_online_log_dest_1	String	True	True	Immediate	Online Log/controlfile destination #1
18	Db_create_online_log_dest_2	String	True	True	Immediate	Online Log/controlfile destination #2
19	Db_unique_name	String	True			Database unique name
20	Instance_number	Integer	True			Instance number
21	Ldap_directory_sysauth	String	True			Oid usage Parameter
22	Log_archive_dest_1	String	True	True	Immediate	Archival destination #1 text string
23	Log_archive_dest_2	String	True	True	Immediate	Archival destination #2 text string
24	Log_archive_dest_state_1	String	True	True	Immediate	Archival destination #1 State text string
25	Log_archive_dest_state_2	String	True	True	Immediate	Archival destination #2 state text string
26	Pga_aggregate_target	Big integer	True		Immediate	Target size for Aggregate PGA memory consumed by the instance
27	Remote_listener	String	True		Immediate	Remote listener
28	Sessions	Integer	True			User and System Sessions
29	Shared_servers	Integer	True		Immediate	Number of shared Servers to start up
30	star_transformation_enabled	string	true	true	immediate	enable the use of Star transformation