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

>

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

::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

> 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

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

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

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>

Oracle Linux 6.7 靜預設安裝Oracle 11g

相關文章