Create an oracle11G Database

After the server is created, create a database and run dbca to start the creation interface. The content is similar to the previous one. If you are familiar with the Oracle structure, we recommend that you customize all the options by yourself. This database is not intended to use asm for the moment, so you don't need to worry about related options. In the last step, I did not directly create a database, but only generated the database creation script. After the Wizard is completed, find these scripts and check for any adjustments. After the script is manually executed, the database is created to check whether the installation log has an exception. In fact, the script is basically generic, as long as it is the same database version, you can directly use it after modification, instead of using dbca as a wizard every time.

If you want to use automatic memory management, you can set the memory_target value. After the database is started, you can view the file system tmpfs and find it is used. In addition, tmpfs (/dev/shm) the minimum value cannot be less than 300 M, and the value of memory_target cannot be greater than the value of tmpfs in the file system, otherwise the ORA-00845: MEMORY_TARGET not supported on this system will be reported at startup, the memory_target and lock_sga parameters may not be shared due to the characteristics of tmpfs.

If you want to use large memory (adjust shm, see the server Installation section, where 700m is just an example, huh, huh), you need to set USE_INDIRECT_DATA_BUFFERS to true. This parameter is explained as follows:

USE_INDIRECT_DATA_BUFFERS controls how the system global area (SGA) uses memory. it enables or disables the use of the extended buffer cache mechanic for 32-bit platforms that can support more than 4 GB of physical memory. on platforms that do not support this much physical memory, this parameter is ignored.

Feel relative to AIX, HP-UX system, linux support for oracle has been not very intelligent, version 5 in the end what changes, still need to be found in the future. I want to know more about linux cainiao.