Create a database in Oracle 11gR2 on CentOS

Oracle 11gR2 on CentOS to create a database 1. tmpfs configuration tmpfs is half of the memory by default. If only Oracle is installed on CentOS for database server usage, you want to set Oracle AMM to use 80% ~ 90% of memory, must be set to large tmpfs. In this example, the VM memory is 896 mb. Change the/etc/fstab setting file and set the tmpfs size to MB www.2cto.com [root @ localhost ~]. # Vim/etc/fstab # Created by anaconda on Tue Oct 2 00:56:54 2012 # Accessible filesystems, by reference, are maintained under '/dev/disk' # See man pages fstab (5), findfs (8), mount (8) and/or blkid (8) for more info #/dev/mapper/VolGroup-lv_root/ext4 defaults 1 1 UUID = c82b7a71-352a-448d-ab80-4b38ecfc119d/boot ext4 defaults 1 2/dev/mapper/VolGroup-lv_swap swap defaults 0 0 tmpfs/dev/ Shm tmpfs defaults, size = 896 M 0 0 devpts/dev/pts devpts gid = 5, mode = 620 0 0 sysfs/sys sysfs defaults 0 0 0 proc/proc defaults 0 0 www.2cto.com re-mount and view the changed result [root @ localhost ~] # Mount-o remount, size = 896 M/dev/shm [root @ localhost ~] # Df-mFilesystem 1M-blocks Used Available Use % Mounted on/dev/mapper/VolGroup-lv_root 17552 10352 6310 63%/tmpfs 896 1 896 1%/dev/shm/dev/sda1 485 51 409 12%/ boot/dev/sr0 3542 3542 0 100%/media/CentOS_6.3_Final note: it is found that even if the configuration of the/etc/fstab file is changed, tmpfs is restored to half of the memory after restart (the Bug CentOS 6 is found online ), so we need to go to/etc/rc. manually add the remount command www.2cto.com to the local file [root @ localhost ~] # Vim/etc/rc. local #! /Bin/sh # This script will be executed * after * all the other init scripts. # You can put your own initialization stuff in here if you don't # want to do the full Sys V style init stuff. touch/var/lock/subsys/localmount-o remount, size = 896 M/dev/shm 2. configure the Oracle listener www.2cto.com [1] to log on to the system as an oracle user. startx starts the graphic interface [2] Open a terminal on the desktop and execute the netca Command [oracle @ localhost ~] $ Netca: The following window appears. "Next" [3] Select "Next" [4] enter the name of listener, then "Next" [5] default TCP, then "Next" [7] Select "No ", then "Next" 3. create a database [1] run the following command in the terminal window on the CentOS desktop:
[Oracle @ localhost ~] $ Netca: In the following window, click Next [3] and select General Purpose or Transaction Processing [5] Enterprise Manager to configure the storage type [7, retain the default file system [9] whether to create a display table. Here, select Character Set settings: use Unicode. default Language: Select Simplified ChineseDefault Territory: select China [12] Click Finish [13] After the database is created, click Exit to Exit