ITPub博客

首页 > 数据库 > Oracle > Oracle Linux 6.7 静默认安装Oracle 11g

Oracle Linux 6.7 静默认安装Oracle 11g

原创 Oracle 作者:eric0435 时间:2022-09-20 09:25:30 0 删除 编辑

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

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>


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26015009/viewspace-2915360/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
系统架构师 Oracle ACE

注册时间:2011-10-12

  • 博文量
    704
  • 访问量
    6459932