Oracle Linux 6.7 静默认安装Oracle 11g
一. 软件版本
操作系统:Oracle Linux 6.7
数据库软件:Oracle Database Enterprise 11.2.4.0
二·安装环境准备
2.1修改IP地址
[root@sjjh ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth0 DEVICE=eth0 HWADDR=00:50:56:A3:94:C1 TYPE=Ethernet UUID=d2f38815-5bc0-4ce4-8bdb-bbd48992ebe6 ONBOOT=yes NM_CONTROLLED=yes BOOTPROTO=static IPADDR=10.10.10.101 NETMASK=255.255.255.0 GATEWAY=10.10.10.254
2.2关闭防火墙和SELinux
[root@sjjh ~]# service iptables stop iptables: Setting chains to policy ACCEPT: nat mangle filter [ OK ] iptables: Flushing firewall rules: [ OK ] iptables: Unloading modules: [ OK ] [root@sjjh ~]# chkconfig iptables off [root@sjjh ~]# chkconfig libvirtd off [root@sjjh ~]# chkconfig |grep libvirtd libvirtd 0:off 1:off 2:off 3:off 4:off 5:off 6:off
2.3 配置本地YUM
[root@sjjh udev]# cd /etc/yum.repos.d/ [root@sjjh yum.repos.d]# ls -lrt total 8 -rw-r--r--. 1 root root 4949 Sep 18 07:37 public-yum-ol6.repo [root@sjjh yum.repos.d]# mv public-yum-ol6.repo public-yum-ol6.repo.bak [root@sjjh yum.repos.d]# mkdir /mnt/vcdrom [root@sjjh yum.repos.d]# mount -o loop -t iso9660 /soft/Oracle_Linux_Release_6_Update_7_for_x86_64.iso /mnt/vcdrom [root@sjjh yum.repos.d]# echo "[base] > name=jy > baseurl=file:///mnt/vcdrom/ > gpgcheck=0 > enabled=1" > jy.repo [root@sjjh yum.repos.d]# cat jy.repo [base] name=jy baseurl=file:///mnt/cdrom/ gpgcheck=0 enabled=1 [root@sjjh yum.repos.d]# yum clean all Loaded plugins: aliases, changelog, kabi, presto, refresh-packagekit, security, tmprepo, ulninfo, verify, versionlock Loading support for kernel ABI Cleaning repos: base Cleaning up Everything 0 delta-package files removed, by presto
2.4创建用户和组
创建用户组
[root@sjjh yum.repos.d]# groupadd -g 54321 oinstall [root@sjjh yum.repos.d]# groupadd -g 54322 dba [root@sjjh yum.repos.d]# groupadd -g 54323 oper [root@sjjh yum.repos.d]# groupadd -g 54324 backupdba [root@sjjh yum.repos.d]# groupadd -g 54325 dgdba [root@sjjh yum.repos.d]# groupadd -g 54326 kmdba [root@sjjh yum.repos.d]# groupadd -g 54327 asmdba [root@sjjh yum.repos.d]# groupadd -g 54328 asmoper [root@sjjh yum.repos.d]# groupadd -g 54329 asmadmin [root@sjjh yum.repos.d]# groupadd -g 54330 racdba [root@sjjh yum.repos.d]# grep 543 /etc/group oinstall:x:54321: dba:x:54322:oracle oper:x:54323: backupdba:x:54324: dgdba:x:54325: kmdba:x:54326: asmdba:x:54327: asmoper:x:54328: asmadmin:x:54329: racdba:x:54330:
创建用户
[root@sjjh home]# useradd -u 54321 -g oinstall -G dba,asmadmin,asmdba,asmoper,backupdba,dgdba,kmdba,racdba,oper oracle [root@sjjh home]# passwd oracle Changing password for user oracle. New password: Retype new password: passwd: all authentication tokens updated successfully.
2.5创建相关目录
[root@sjjh home]# mkdir -p /u01/tmp [root@sjjh home]# mkdir -p /u01/app/oracle/product/11.2.0.4/db [root@sjjh home]# mkdir -p /u01/app/oraInventory [root@sjjh home]# mkdir -p /u01/app/oracle/oradata [root@sjjh home]# chown -R oracle:oinstall /u01 [root@sjjh home]# chmod -R 775 /u01
2.6安装软件包
[root@sjjh /]# yum install -y binutils compat-libcap1 compat-libstdc++-33 e2fsprogs e2fsprogs-libs elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-devel libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC ksh libX11 libXau libXi libXtst libxcb smartmontools unixODBC-devel net-tools compat-libstdc++-33* unzip vim* perl Loaded plugins: aliases, changelog, kabi, presto, refresh-packagekit, security, tmprepo, ulninfo, verify, versionlock Loading support for kernel ABI Setting up Install Process base | 3.7 kB 00:00 ... base/primary_db | 3.0 MB 00:00 ... Package binutils-2.20.51.0.2-5.43.el6.x86_64 already installed and latest version Package compat-libcap1-1.10-1.x86_64 already installed and latest version Package compat-libstdc++-33-3.2.3-69.el6.x86_64 already installed and latest version Package e2fsprogs-1.42.8-1.0.2.el6.x86_64 already installed and latest version Package e2fsprogs-libs-1.42.8-1.0.2.el6.x86_64 already installed and latest version Package elfutils-libelf-0.161-3.el6.x86_64 already installed and latest version Package elfutils-libelf-devel-0.161-3.el6.x86_64 already installed and latest version Package gcc-4.4.7-16.el6.x86_64 already installed and latest version Package gcc-c++-4.4.7-16.el6.x86_64 already installed and latest version Package glibc-2.12-1.166.el6.x86_64 already installed and latest version Package glibc-devel-2.12-1.166.el6.x86_64 already installed and latest version Package libaio-0.3.107-10.el6.x86_64 already installed and latest version Package libaio-devel-0.3.107-10.el6.x86_64 already installed and latest version Package libgcc-4.4.7-16.el6.x86_64 already installed and latest version Package libstdc++-4.4.7-16.el6.x86_64 already installed and latest version Package libstdc++-devel-4.4.7-16.el6.x86_64 already installed and latest version Package 1:make-3.81-20.el6.x86_64 already installed and latest version Package sysstat-9.0.4-27.el6.x86_64 already installed and latest version Package unixODBC-2.2.14-14.el6.x86_64 already installed and latest version Package ksh-20120801-28.el6.x86_64 already installed and latest version Package libX11-1.6.0-6.el6.x86_64 already installed and latest version Package libXau-1.0.6-4.el6.x86_64 already installed and latest version Package libXi-1.7.2-2.2.el6.x86_64 already installed and latest version Package libXtst-1.2.2-2.1.el6.x86_64 already installed and latest version Package libxcb-1.9.1-3.el6.x86_64 already installed and latest version Package 1:smartmontools-5.43-1.el6.x86_64 already installed and latest version Package unixODBC-devel-2.2.14-14.el6.x86_64 already installed and latest version Package net-tools-1.60-110.el6_2.x86_64 already installed and latest version Package compat-libstdc++-33-3.2.3-69.el6.x86_64 already installed and latest version Package unzip-6.0-2.el6_6.x86_64 already installed and latest version Package 2:vim-minimal-7.4.629-5.el6.x86_64 already installed and latest version Package 2:vim-filesystem-7.4.629-5.el6.x86_64 already installed and latest version Package 2:vim-common-7.4.629-5.el6.x86_64 already installed and latest version Package 2:vim-X11-7.4.629-5.el6.x86_64 already installed and latest version Package 2:vim-enhanced-7.4.629-5.el6.x86_64 already installed and latest version Package 4:perl-5.10.1-141.el6.x86_64 already installed and latest version Nothing to do
检查已经安装的软件包
[root@sjjh /]# rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' binutils compat-libcap1 compat-libstdc++-33 e2fsprogs e2fsprogs-libs elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-devel libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC ksh libX11 libXau libXi libXtst libxcb smartmontools unixODBC-devel net-tools unzip vim* perl
binutils-2.20.51.0.2-5.43.el6 (x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (x86_64)
e2fsprogs-1.42.8-1.0.2.el6 (x86_64)
e2fsprogs-libs-1.42.8-1.0.2.el6 (x86_64)
elfutils-libelf-0.161-3.el6 (x86_64)
elfutils-libelf-devel-0.161-3.el6 (x86_64)
gcc-4.4.7-16.el6 (x86_64)
gcc-c++-4.4.7-16.el6 (x86_64)
glibc-2.12-1.166.el6 (x86_64)
glibc-2.12-1.166.el6 (i686)
glibc-devel-2.12-1.166.el6 (x86_64)
libaio-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6 (x86_64)
libgcc-4.4.7-16.el6 (x86_64)
libgcc-4.4.7-16.el6 (i686)
libstdc++-4.4.7-16.el6 (x86_64)
libstdc++-devel-4.4.7-16.el6 (x86_64)
make-3.81-20.el6 (x86_64)
sysstat-9.0.4-27.el6 (x86_64)
unixODBC-2.2.14-14.el6 (x86_64)
ksh-20120801-28.el6 (x86_64)
libX11-1.6.0-6.el6 (x86_64)
libXau-1.0.6-4.el6 (x86_64)
libXi-1.7.2-2.2.el6 (x86_64)
libXtst-1.2.2-2.1.el6 (x86_64)
libxcb-1.9.1-3.el6 (x86_64)
smartmontools-5.43-1.el6 (x86_64)
unixODBC-devel-2.2.14-14.el6 (x86_64)
net-tools-1.60-110.el6_2 (x86_64)
unzip-6.0-2.el6_6 (x86_64)
package vim* is not installed
perl-5.10.1-141.el6 (x86_64)
2.7编辑hosts文件
[root@sjjh /]# vi /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 10.10.10.101 sjjh
2.8 修改系统内核参数
[root@sjjh /]# cat >> /etc/sysctl.conf < kernel.shmall = 4294967296 > kernel.sem = 250 32000 100 128 > kernel.shmmni = 4096 > kernel.shmmax = 429496729600 > net.ipv4.ip_local_port_range = 9000 65500 > net.core.rmem_default = 1048576 > net.core.rmem_max = 4194304 > net.core.wmem_default = 262144 > net.core.wmem_max = 1048576 > fs.file-max = 6815744 > fs.aio-max-nr = 1048576 > vm.swappiness = 0 > vm.dirty_background_ratio = 3 > vm.dirty_ratio = 20 > vm.dirty_expire_centisecs = 500 > vm.dirty_writeback_centisecs = 100 > vm.min_free_kbytes=524288 > net.ipv4.tcp_sack = 0 > net.ipv4.tcp_timestamps = 0 > net.ipv4.conf.default.rp_filter = 0 > net.ipv4.tcp_wmem = 262144 > net.ipv4.tcp_rmem = 4194304 > net.ipv4.ipfrag_high_thresh = 16777216 > net.ipv4.ipfrag_low_thresh = 15728640 > net.ipv4.ipfrag_time=60 > EOF [root@sjjh /]# sysctl -p net.ipv4.ip_forward = 0 net.ipv4.conf.default.rp_filter = 1 net.ipv4.conf.default.accept_source_route = 0 kernel.sysrq = 0 kernel.core_uses_pid = 1 net.ipv4.tcp_syncookies = 1 kernel.msgmnb = 65536 kernel.msgmax = 65536 kernel.shmall = 4294967296 fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500 kernel.shmall = 4294967296 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmmax = 429496729600 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 1048576 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 fs.file-max = 6815744 fs.aio-max-nr = 1048576 vm.swappiness = 0 vm.dirty_background_ratio = 3 vm.dirty_ratio = 20 vm.dirty_expire_centisecs = 500 vm.dirty_writeback_centisecs = 100 vm.min_free_kbytes = 524288 net.ipv4.tcp_sack = 0 net.ipv4.tcp_timestamps = 0 net.ipv4.conf.default.rp_filter = 0 net.ipv4.tcp_wmem = 262144 net.ipv4.tcp_rmem = 4194304 net.ipv4.ipfrag_high_thresh = 16777216 net.ipv4.ipfrag_low_thresh = 15728640 net.ipv4.ipfrag_time = 60
2.9 配置LIMITS限制参数
[root@sjjh /]# cat >> /etc/security/limits.conf < oracle soft nproc 16384 > oracle hard nproc 16384 > oracle soft nofile 65536 > oracle hard nofile 65536 > oracle soft memlock 26843545 > oracle hard memlock 26843545 > oracle soft stack 10240 > oracle hard stack 32768 > EOF
2.10配置PAM
[root@sjjh /]# echo "session required /lib64/security/pam_limits.so">>/etc/pam.d/login
2.11 配置系统环境变量
[root@sjjh /]# cat >> /etc/profile < if [ \$USER = "oracle" ]; then > if [ \$SHELL = "/bin/ksh" ]; then > ulimit -p 16384 > ulimit -n 65536 > else > ulimit -u 16384 -n 65536 > fi > fi > EOF
2.11 配置oracle用户环境变量
[oracle@sjjh ~]$ vi .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
TEMP=/u01/tmp
TMPDIR=/u01/tmp
export TEMP TMPDIR
export LD_ASSUME_KERNEL=3.8.13
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db
export ORACLE_SID=sjjh
export ORACLE_UNQNAME=sjjh
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export LD_LIBRARY_PATH
export PATH=$PATH:$ORACLE_HOME/bin
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
export CLASSPATH
umask=022
export PATH=$PATH:$ORACLE_HOME/rdbms/lib
[oracle@sjjh ~]$ source .bash_profile
[oracle@sjjh ~]$ echo $ORACLE_SID
sjjh
三·安装数据库软件
3.1解压安装包
[root@sjjh soft]# unzip p13390677_112040_Linux-x86-64_1of7.zip [root@sjjh soft]# unzip p13390677_112040_Linux-x86-64_2of7.zip
3.2编写响应文件
[oracle@sjjh ~]$ vi dbinstall.rsp oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 oracle.install.option=INSTALL_DB_SWONLY ORACLE_HOSTNAME=sjjh UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/app/oraInventory SELECTED_LANGUAGES=en ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db ORACLE_BASE=/u01/app/oracle oracle.install.db.InstallEdition=EE oracle.install.db.DBA_GROUP=dba oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 oracle.install.option=INSTALL_DB_SWONLY ORACLE_HOSTNAME=sjjh UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/app/oraInventory SELECTED_LANGUAGES=en ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/db ORACLE_BASE=/u01/app/oracle oracle.install.db.InstallEdition=EE oracle.install.db.EEOptionsSelection=false oracle.install.db.optionalComponents= oracle.install.db.DBA_GROUP=dba oracle.install.db.OPER_GROUP=oper oracle.install.db.CLUSTER_NODES= oracle.install.db.isRACOneInstall=false oracle.install.db.racOneServiceName= oracle.install.db.config.starterdb.type=GENERAL_PURPOSE oracle.install.db.config.starterdb.globalDBName= oracle.install.db.config.starterdb.SID= oracle.install.db.config.starterdb.characterSet= oracle.install.db.config.starterdb.memoryOption=false oracle.install.db.config.starterdb.memoryLimit= oracle.install.db.config.starterdb.installExampleSchemas=false oracle.install.db.config.starterdb.enableSecuritySettings=true oracle.install.db.config.starterdb.password.ALL= oracle.install.db.config.starterdb.password.SYS= oracle.install.db.config.starterdb.password.SYSTEM= oracle.install.db.config.starterdb.password.SYSMAN= oracle.install.db.config.starterdb.password.DBSNMP= oracle.install.db.config.starterdb.control=DB_CONTROL oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL= oracle.install.db.config.starterdb.automatedBackup.enable=false oracle.install.db.config.starterdb.automatedBackup.osuid= oracle.install.db.config.starterdb.automatedBackup.ospwd= oracle.install.db.config.starterdb.storageType= oracle.install.db.config.starterdb.fileSystemStorage.dataLocation= oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation= oracle.install.db.config.asm.diskGroup= oracle.install.db.config.asm.ASMSNMPPassword= MYORACLESUPPORT_USERNAME= MYORACLESUPPORT_PASSWORD= SECURITY_UPDATES_VIA_MYORACLESUPPORT=false DECLINE_SECURITY_UPDATES=true PROXY_HOST= PROXY_PORT= PROXY_USER= PROXY_PWD= PROXY_REALM= COLLECTOR_SUPPORTHUB_URL= oracle.installer.autoupdates.option=SKIP_UPDATES oracle.installer.autoupdates.downloadUpdatesLoc= AUTOUPDATES_MYORACLESUPPORT_USERNAME= AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
3.3执行安装
[oracle@sjjh database]$ ./runInstaller -silent -force -noconfig -ignorePrereq -responseFile /home/oracle/dbinstall.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 1731157 MB Passed
Checking swap space: must be greater than 150 MB. Actual 16383 MB Passed
Preparing to launch Oracle Universal Installer from /u01/tmp/OraInstall2022-09-18_10-03-38AM. Please wait ...[oracle@sjjh database]$ You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2022-09-18_10-03-38AM.log
[oracle@sjjh database]$ ./runInstaller -silent -force -noconfig -ignorePrereq -responseFile /home/oracle/dbinstall.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 1731157 MB Passed
Checking swap space: must be greater than 150 MB. Actual 16383 MB Passed
Preparing to launch Oracle Universal Installer from /u01/tmp/OraInstall2022-09-18_10-03-38AM. Please wait ...[oracle@sjjh database]$ You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2022-09-18_10-03-38AM.log
The installation of Oracle Database 11g was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2022-09-18_10-03-38AM.log' for more details.
As a root user, execute the following script(s):
1. /u01/app/oraInventory/orainstRoot.sh
2. /u01/app/oracle/product/11.2.0.4/db/root.sh
Successfully Setup Software.
3.4执行root.sh脚本
[root@sjjh /]# /u01/app/oraInventory/orainstRoot.sh Changing permissions of /u01/app/oraInventory. Adding read,write permissions for group. Removing read,write,execute permissions for world. Changing groupname of /u01/app/oraInventory to oinstall. The execution of the script is complete. [root@sjjh /]# /u01/app/oracle/product/11.2.0.4/db/root.sh Check /u01/app/oracle/product/11.2.0.4/db/install/root_sjjh_2022-09-18_10-11-40.log for the output of root script
四·创建数据库
4.1 配置监听
[oracle@sjjh ~]$ vi netca.rsp
[GENERAL]
RESPONSEFILE_VERSION="11.2"
CREATE_TYPE="CUSTOM"
[oracle.net.ca]
INSTALLED_COMPONENTS={"server","net8","javavm"}
INSTALL_TYPE=""typical""
LISTENER_NUMBER=1
LISTENER_NAMES={"LISTENER"}
LISTENER_PROTOCOLS={"TCP;1521"}
LISTENER_START=""LISTENER""
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
NSN_NUMBER=1
NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
NSN_SERVICE={"PLSExtProc"}
NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}
[oracle@sjjh ~]$ netca -silent -responsefile /home/oracle/netca.rsp
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /home/oracle/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Oracle Net Listener Startup:
Running Listener Control:
/u01/app/oracle/product/11.2.0.4/db/bin/lsnrctl start LISTENER
Listener Control complete.
Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
[oracle@sjjh ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 18-SEP-2022 10:14:34
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 18-SEP-2022 10:14:19
Uptime 0 days 0 hr. 0 min. 15 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0.4/db/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/sjjh/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sjjh)(PORT=1521)))
The listener supports no services
The command completed successfully
4.2创建配置数据库的响应文件
[oracle@sjjh ~]$ vi dbca.rsp [GENERAL] RESPONSEFILE_VERSION = "11.2.0" OPERATION_TYPE = "createDatabase" [CREATEDATABASE] GDBNAME = "sjjh" SID = "sjjh" DB_UNIQUE_NAME = "sjjhp" TEMPLATENAME = "General_Purpose.dbc" characterSet = "ZHS16GBK" nationalCharacterSet = "AL16UTF16" sysPassword="xxzx7817600" systemPassword="xxzx7817600" storageType = "FS" datafileDestination=/u01/app/oracle/oradata recoveryAreaDestination=/u01/app/oracle/flash_recovery_area totalMemory=2048 sampleSchema=TRUE
4.3 创建数据库
[oracle@sjjh ~]$ dbca -silent -createDatabase -responseFile /home/oracle/dbca.rsp Copying database files 1% complete 3% complete 11% complete 18% complete 26% complete 37% complete Creating and starting Oracle instance 40% complete 45% complete 50% complete 55% complete 56% complete 57% complete 60% complete 62% complete Completing Database Creation 66% complete 70% complete 73% complete 85% complete 96% complete 100% complete Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/sjjh/sjjh.log" for further details. [oracle@sjjh ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 18-SEP-2022 10:52:25 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production Start Date 18-SEP-2022 10:14:19 Uptime 0 days 0 hr. 38 min. 6 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/11.2.0.4/db/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/sjjh/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sjjh)(PORT=1521))) Services Summary... Service "sjjh" has 1 instance(s). Instance "sjjh", status READY, has 1 handler(s) for this service... Service "sjjhXDB" has 1 instance(s). Instance "sjjh", status READY, has 1 handler(s) for this service... The command completed successfully [oracle@sjjh ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Sun Sep 18 10:53:07 2022 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> show parameter unique NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_unique_name string sjjh SQL>