Shulou(Shulou.com)06/01 Report--

Experimental environment:

Operating system: Redhat 6.464 bit

Database: Oracle 12c R2

First, prepare before installation

1. Create users and groups

[root@wjq~] # groupadd-g1000 oinstall

/ / oinstall group: is the inventory catalog group (Oracle Inventory group), which is used to manage inventory directories (Inventory)

[root@wjq~] # groupadd-g1001 dba / / dba group: for database management

[root@wjq~] # useradd-U600-g oinstall-G dba oracle

[root@wjq~] # passwdoracle

Changingpassword for user oracle.

Newpassword:

BADPASSWORD: it is based ona dictionary word

BADPASSWORD: is too simple

Retypenew password:

Passwd:all authentication tokens updated successfully.

2. Create a directory

[root@wjq~] # mkdir-p/u01/app/oracle/product/12.2.0/dbhome_1

[root@wjq~] # chown-Roracle:oinstall / U01

[root@wjq~] # chmod-R 775/u01/app/oracle

3. View physical memory, swap space, and file system size

[root@wjq~] # free-m

Total used free shared buffers cached

Mem: 3016 358 2657 0 19 158

-/ + buffers/cache: 180 2835

Swap: 3023 0 3023

[root@wjq] # df-h

Filesystem Size Used Avail Use% Mounted on

/ dev/mapper/vg_wjq-lv_root

26G 2.8G 22G 12% /

Tmpfs 1.5G 72K 1.5G 1% / dev/shm

/ dev/sda1 485m 38m 423m 9% / boot

/ dev/mapper/vg_wjq-lv_home

4.0G 137m 3.7G 4% / home

/ dev/mapper/vg_wjq-lv_u01

66G 180m 62G 1% / U01

4. View the operating system architecture

[root@wjq~] # cat/proc/version

Linuxversion 2.6.32-358.el6.x86_64 (mockbuild@x86-022.build.eng.bos.redhat.com) (gccversion 4.4.7 20120313 (Red Hat 4.4.7-3) (GCC)) # 1 SMP Tue Jan 29 11:47:41 EST2013

[root@wjq] # lsb_release-a

LSBVersion:: base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch

DistributorID: RedHatEnterpriseServer

Description: Red Hat Enterprise Linux Server release 6.4 (Santiago)

Release: 6.4

Codename: Santiago

[root@wjq~] # uname-r

2.6.32-358.el6.x86_64

5. Install the software package

Binutils-2.20.51.0.2-5.11.el6 (x86 / 64)

Compat-libcap1-1.10-1 (x86x64)

Compat-libstdc++-33-3.2.3-69.el6 (x86x64)

Compat-libstdc++-33-3.2.3-69.el6.i686

Gcc-4.4.4-13.el6 (x86 / 64)

Gcc-c++-4.4.4-13.el6 (x86 / 64)

Glibc-2.12-1.7.el6 (i686)

Glibc-2.12-1.7.el6 (x86 / 64)

Glibc-devel-2.12-1.7.el6 (x86 / 64)

Glibc-devel-2.12-1.7.el6.i686

Ksh

Libgcc-4.4.4-13.el6 (i686)

Libgcc-4.4.4-13.el6 (x86 / 64)

Libstdc++-4.4.4-13.el6 (x86 / 64)

Libstdc++-4.4.4-13.el6.i686

Libstdc++-devel-4.4.4-13.el6 (x86 / 64)

Libstdc++-devel-4.4.4-13.el6.i686

Libaio-0.3.107-10.el6 (x86 / 64)

Libaio-0.3.107-10.el6.i686

Libaio-devel-0.3.107-10.el6 (x86 / 64)

Libaio-devel-0.3.107-10.el6.i686

LibXext-1.1 (x86 / 64)

LibXext-1.1 (i686)

LibXtst-1.0.99.2 (x86 / 64)

LibXtst-1.0.99.2 (i686)

LibX11-1.3 (x86 / 64)

LibX11-1.3 (i686)

LibXau-1.0.5 (x86 / 64)

LibXau-1.0.5 (i686)

Libxcb-1.5 (x86 / 64)

Libxcb-1.5 (i686)

LibXi-1.3 (x86 / 64)

LibXi-1.3 (i686)

Make-3.81-19.el6

Sysstat-9.0.4-11.el6 (x86 / 64)

6. Disable SELinux and firewall

[root@wjqsofrware] # vim/etc/selinux/config

# Thisfile controls the state of SELinux on the system.

# SELINUX= can take one of these three values:

# enforcing-SELinux security policy isenforced.

# permissive-SELinux prints warningsinstead of enforcing.

# disabled-No SELinux policy is loaded.

SELINUX=disabled

# SELINUXTYPE= can take one of these two values:

# targeted-Targeted processes areprotected

# mls-Multi Level Security protection.

SELINUXTYPE=targeted

Incorrect configuration of SELinux will affect the network

(1) enforcing--- SELinux security policy is enforced. Represents to log warnings and prevent suspicious behavior

(2) permissive-SELinux prints warnings instead of representative only records security warnings but does not prevent suspicious behavior

(3) disabled-SELinux is fully disabled.SELinux is disabled

SELINUXTYPE Settin

(1) targeted represents the use of SELinux protection only for prefabricated network services and access requests

(2) strict represents that all network services and access requests go through SELinux.

View the security policy of the current system

[root@wjq~] # sestatus

SELinuxstatus: disabled

[root@wjq~] # getenforce

Disabled

[root@wjqsofrware] # service iptables stop

Iptables:Flushing firewall rules: [OK]

Iptables:Setting chains to policy ACCEPT: filter [OK]

Iptables:Unloading modules: [OK]

[root@wjqsofrware] # chkconfigiptables off

7. Unpack the installation package and set the environment variables

[root@wjqsofrware] # unziplinuxx64_12201_database.zip

[oracle@wjq~] $vim.bash_profile

ExportORACLE_BASE=/u01/app/oracle

ExportORACLE_HOME=$ORACLE_BASE/product/12.2.0/dbhome_1

ExportORACLE_SID=seiang

ExportORACLE_OWNER=oracle

ExportORACLE_TERM=vt100

ExportPATH=$PATH:$ORACLE_HOME/bin:$HOME/bin

ExportPATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH

ExportBASE_PATH=/usr/sbin:$PATH; exportBASE_PATH

ExportPATH=$ORACLE_HOME/bin:$BASE_PATH

ExportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib

ExportORACLE_HOSTNAME=wjq.comsys.com

ExportDB_UNIQUE_NAME=prod

ExportCVUQDISK_GRP=oinstall

Umask022

[oracle@wjq~] $source.bash_profile

8. Set kernel parameters

[root@wjqsofrware] # vim/etc/sysctl.conf

Fs.aio-max-nr= 1048576

Fs.file-max= 6815744

Kernel.shmall= 2097152

Kernel.shmmax= 1349242060

Kernel.shmmni= 4096

Kernel.sem= 250 32000 100 128

Net.ipv4.ip_local_port_range= 9000 65500

Net.core.rmem_default=262144

Net.core.rmem_max=4194304

Net.core.wmem_default=262144

Net.core.wmem_max=1048586

[root@wjqsofrware] # sysctl-a / / Let the kernel parameter file take effect immediately

Shmmax= physical memory * 80%'80% in bytes

Kernel.shmmax: represents the maximum value of a single shared memory segment, in bytes. This value is usually half of physical memory, but it doesn't matter if it is larger. Here, it is set to 4GB, that is, "4294967295max 1024max 1024q4G".

Kernel.shmmin: represents the minimum value of a single shared memory segment. The default is 1byte.

Kernel.shmall: represents the total number of page pages available across the system. On a 32-bit system, one page equals 4kB, or 4096 bytes. The calculation formula is: shmmax/PAGE_SIZE

Kernel.shmmni: represents the maximum number of system-wide memory segments, typically 4096.

Ip_local_port_range: indicates the range of ports. A port in the specified range is used when the listener helps the client process and the server process establish a connection.

Kernel.sem: indicates the set semaphore, and the contents of these four parameters are fixed.

Net.core.rmem_default: the default value (in bytes) that represents the size of the receive socket buffer.

Net.core.rmem_max: represents the maximum size of the receive socket buffer in bytes

Net.core.wmem_default: the default value (in bytes) that represents the buffer size of the send socket.

Net.core.wmem_max: represents the maximum size of the send socket buffer in bytes.

9. Modify the resource control file

[root@wjqsofrware] # vim/etc/security/limits.conf

Oracle soft nproc 2047

Oracle hard nproc 16384

Oracle soft nofile 1024

Oracle hard nofile 65536

Resource limits are restrictions for a single process, not overall settings for the entire system

Once the limits.conf is modified, it will take effect immediately. However, if the user is already logged in to the system, the restrictions on that user will not take effect until the next time the user logs back in. If you want the restrictions on the user to take effect, you can only let the user log out and log back in.

/ etc/security/limits.conf

Core-limits the size of kernel files

Date-the largest size of big data

Fsize-maximum file size

Memlock-maximum locked memory address space

Nofile-maximum number of files opened

Rss-maximum persistent setting size

Stack-maximum stack size

Cpu-maximum CPU time in minutes

Noproc-maximum number of processes

As-address space restriction

Maxlogins-maximum number of logins allowed by this user

Nofile-the maximum number of files opened, which cannot be equal to / proc/sys/fs/file-max. If it is equal to file-max and the number of open file handles reaches file-max, users will not be able to log in to the operating system.

Second, install Oracle software

1. The location of the corresponding document template

[root@wjqsofrware] # find/-name * .rsp

/ u01/sofrware/database/response/netca.rsp

/ u01/sofrware/database/response/db_install.rsp

/ u01/sofrware/database/response/dbca.rsp

2. browse the contents of the response file and edit the response file

[root@wjqresponse] # ll

Total64

Drwxr-xr-x2 root root 4096 Jul 5 16:32 backup.rsp

-rwxrwxr-x1 root root 25502 Jan 5 14:00 dbca.rsp

-rw-rw-r--1 root root 22924 Jan 26 21:44 db_install.rsp

-rwxrwxr-x1 root root 6209 Jun 20 2016 netca.rsp

Browse the contents of the response file

[oracle@wjqdatabase] $sed-n'/ ^ [^ #] / p 'response/db_install.rsp

Oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.2.0

Oracle.install.option=

UNIX_GROUP_NAME=

INVENTORY_LOCATION=

ORACLE_HOME=

ORACLE_BASE=

Oracle.install.db.InstallEdition=

Oracle.install.db.OSDBA_GROUP=

Oracle.install.db.OSOPER_GROUP=

Oracle.install.db.OSBACKUPDBA_GROUP=

Oracle.install.db.OSDGDBA_GROUP=

Oracle.install.db.OSKMDBA_GROUP=

Oracle.install.db.OSRACDBA_GROUP=

Oracle.install.db.rac.configurationType=

Oracle.install.db.CLUSTER_NODES=

Oracle.install.db.isRACOneInstall=false

Oracle.install.db.racOneServiceName=

Oracle.install.db.rac.serverpoolName=

Oracle.install.db.rac.serverpoolCardinality=

Oracle.install.db.config.starterdb.type=

Oracle.install.db.config.starterdb.globalDBName=

Oracle.install.db.config.starterdb.SID=

Oracle.install.db.ConfigureAsContainerDB=

Oracle.install.db.config.PDBName=

Oracle.install.db.config.starterdb.characterSet=

Oracle.install.db.config.starterdb.memoryOption=

Oracle.install.db.config.starterdb.memoryLimit=

Oracle.install.db.config.starterdb.installExampleSchemas=

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.DBSNMP=

Oracle.install.db.config.starterdb.password.PDBADMIN=

Oracle.install.db.config.starterdb.managementOption=

Oracle.install.db.config.starterdb.omsHost=

Oracle.install.db.config.starterdb.omsPort=

Oracle.install.db.config.starterdb.emAdminUser=

Oracle.install.db.config.starterdb.emAdminPassword=

Oracle.install.db.config.starterdb.enableRecovery=

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=

DECLINE_SECURITY_UPDATES=

PROXY_HOST=

PROXY_PORT=

PROXY_USER=

PROXY_PWD=

COLLECTOR_SUPPORTHUB_URL=

Edit the Oracle database software response file db_install.rsp

[root@wjqresponse] # vimdb_install.rsp

Oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.2.0

Oracle.install.option=INSTALL_DB_SWONLY

UNIX_GROUP_NAME=oinstall

INVENTORY_LOCATION=/u01/app/oraInventory

ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1

ORACLE_BASE=/u01/app/oracle

Oracle.install.db.InstallEdition=EE

Oracle.install.db.OSDBA_GROUP=dba

Oracle.install.db.OSOPER_GROUP=dba

Oracle.install.db.OSBACKUPDBA_GROUP=dba

Oracle.install.db.OSDGDBA_GROUP=dba

Oracle.install.db.OSKMDBA_GROUP=dba

Oracle.install.db.OSRACDBA_GROUP=dba

Oracle.install.db.rac.configurationType=

Oracle.install.db.CLUSTER_NODES=

Oracle.install.db.isRACOneInstall=false

Oracle.install.db.racOneServiceName=

Oracle.install.db.rac.serverpoolName=

Oracle.install.db.rac.serverpoolCardinality=

Oracle.install.db.config.starterdb.type=

Oracle.install.db.config.starterdb.globalDBName=

Oracle.install.db.config.starterdb.SID=

Oracle.install.db.ConfigureAsContainerDB=

Oracle.install.db.config.PDBName=

Oracle.install.db.config.starterdb.characterSet=

Oracle.install.db.config.starterdb.memoryOption=

Oracle.install.db.config.starterdb.memoryLimit=

Oracle.install.db.config.starterdb.installExampleSchemas=

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.DBSNMP=

Oracle.install.db.config.starterdb.password.PDBADMIN=

Oracle.install.db.config.starterdb.managementOption=

Oracle.install.db.config.starterdb.omsHost=

Oracle.install.db.config.starterdb.omsPort=

Oracle.install.db.config.starterdb.emAdminUser=

Oracle.install.db.config.starterdb.emAdminPassword=

Oracle.install.db.config.starterdb.enableRecovery=

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=

COLLECTOR_SUPPORTHUB_URL=

3. Get help and start silent installation

Before silently installing the Oracle software, if there is no configuration / etc/hosts file, an error such as five (1) will occur.

[oracle@wjqdatabase] $. / runInstaller-help

[oracle@wjqdatabase] $. / runInstaller-silent-ignoreSysPrereqs-ignorePrereq-responseFile/u01/sofrware/database/response/db_install.rsp

StartingOracle Universal Installer...

CheckingTemp space: must be greater than 500 MB. Actual 18788 MB Passed

Checkingswap space: must be greater than 150 MB. Actual 3023 MB Passed

Preparingto launch Oracle Universal Installer from / tmp/OraInstall2017-07-06 02-07-35PM.Please wait... [oracle@wjq database] $You can find the log of this installsession at:

/ u01/app/oraInventory/logs/installActions2017-07-06 02-07-35PM.log

The installation of Oracle Database 12cwas successful.

Pleasecheck'/ u01/app/oraInventory/logs/silentInstall2017-07-06. 02-07-35 PM.log' formore details.

As a root user, execute the followingscript (s):

1. / u01/app/oraInventory/orainstRoot.sh

2. / u01/app/oracle/product/12.2.0/dbhome_1/root.sh

Successfully Setup Software.

-silent means silent installation

-noconfig indicates that only software is installed

-responseFile specifies the response file

4. Monitor the logs generated during the installation process

[root@wjqresponse] # tail-f / u01/app/oraInventory/logs/installActions2017-07-06-02-07-35PM.log

INFO:Using paramFile: / u01/sofrware/database/install/oraparam.ini

INFO:

INFO:

INFO: CheckingTemp space: must be greater than 500 MB. Actual 18788 MB Passed

INFO:Checking swap space: must be greater than 150 MB. Actual 3023 MB Passed

INFO:

INFO:The commandline for unzip:

INFO:/u01/sofrware/database/install/unzip-qqqo.. / stage/Components/oracle.jdk/1.8.0.91.0/1/DataFiles/\ * .jar-d

/ tmp/OraInstall2017-07-06 02-07-35PM

INFO:Using the umask value '022' available from oraparam.ini

INFO:INFO: Oracle Universal Installer Version 12.2.0.1.4

INFO:

INFO:Execvp of the child jre: the cmdline is/tmp/OraInstall2017-07-06 02-07-35PM/jdk/jre/bin/java, and the arg

V is

INFO:/tmp/OraInstall2017-07-06 02-07-35PM/jdk/jre/bin/java

INFO:-Doracle.installer.library_loc=/tmp/OraInstall2017-07-06 02-07-35PM/oui/lib/linux64

INFO:-Doracle.installer.oui_loc=/tmp/OraInstall2017-07-06 02-07-35PM/oui

INFO:-Doracle.installer.bootstrap=TRUE

INFO:-Doracle.installer.startup_location=/u01/sofrware/database/install

INFO:-Doracle.installer.jre_loc=/tmp/OraInstall2017-07-06 02-07-35PM/jdk/jre

INFO:-Doracle.installer.nlsEnabled= "TRUE"

INFO:-Doracle.installer.prereqConfigLoc=

INFO:-Doracle.installer.unixVersion=2.6.32-358.el6.x86_64

.

.

INFO:Completed executing action at state

INFO:Waiting for completion of background operations

INFO:Completed background operations

INFO:Waiting for completion of background operations

INFO:Completed background operations

INFO:Moved to state

INFO:Waiting for completion of background operations

INFO:Completed background operations

INFO:Validating state

WARNING:Validation disabled for the state finish

INFO:Completed validating state

INFO:Terminating all background operations

INFO:Terminated all background operations

INFO:Successfully executed the flow in SILENT mode

INFO:Dispose the current Session instance

INFO:Dispose the install area control object

INFO:Update the state machine to STATE_CLEAN

INFO:Finding the most appropriate exit status for the current application

INFO:Exit Status is 0

INFO:Shutdown Oracle Database 12c Release 2 Installer

5. Installation process to run the corresponding script as root user

[root@wjq~] # / u01/app/oraInventory/orainstRoot.sh

Changingpermissions of / u01/app/oraInventory.

Addingread,write permissions for group.

Removingread,write,execute permissions for world.

Changinggroupname of / u01/app/oraInventory to oinstall.

Theexecution of the script is complete.

[root@wjq~] # / u01/app/oracle/product/12.2.0/dbhome_1/root.sh

Check/u01/app/oracle/product/12.2.0/dbhome_1/install/root_wjq.comsys.com_2017-07-06 14-23-00-707842960.logfor the output of root script

3. Configure listeners

1. Browse Oracle to listen to the response file netca.rsp

[oracle@wjqdatabase] $sed-n'/ ^ [^ #] / p 'response/netca.rsp

[GENERAL]

RESPONSEFILE_VERSION= "12.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"}

2. Edit the listener configuration response file netca.rsp

[oracle@wjqdatabase] $vimresponse/netca.rsp

[GENERAL]

RESPONSEFILE_VERSION= "12.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"}

3. Silently install the listener

[oracle@wjqdatabase] $$ORACLE_HOME/bin/netca-silent-responsefile / u01/sofrware/database/response/netca.rsp

Parsingcommand line arguments:

Parameter "silent" = true

Parameter "responsefile" = / u01/sofrware/database/response/netca.rsp

Doneparsing command line arguments.

OracleNet Services Configuration:

Profileconfiguration complete.

OracleNet Listener Startup:

Running Listener Control:

/ u01/app/oracle/product/12.2.0/dbhome_1/bin/lsnrctl start LISTENER

ListenerControl complete.

Listener started successfully.

Listener configuration complete.

Oracle Net Services configurationsuccessful. The exit code is 0

4. Check the listening status and start the listener

[oracle@wjqdatabase] $lsnrctlstatus

LSNRCTLfor Linux: Version 12.2.0.1.0-Production on 06-JUL-2017 14:46:27

Copyright (c) 1991, 2016, Oracle. All rightsreserved.

Connectingto (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=wjq.comsys.com) (PORT=1521)

STATUSof the LISTENER

-

Alias LISTENER

Version TNSLSNR for Linux: Version12.2.0.1.0-Production

StartDate 06-JUL-2017 14:43:52

Uptime 0 days 0 hr. 2 min. 34 sec

TraceLevel off

Security ON: Local OS Authentication

SNMP OFF

ListenerParameter File / u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora

ListenerLog File / u01/app/oracle/diag/tnslsnr/wjq/listener/alert/log.xml

ListeningEndpoints Summary...

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=wjq.comsys.com) (PORT=1521))

(DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=EXTPROC1521)

Thelistener supports no services

Thecommand completed successfully

Fourth, create a database

1. Browse the Oracle database response file dbca.rsp

[oracle@wjqdatabase] $sed-n'/ ^ [^ #] / p 'response/dbca.rsp

ResponseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0

GdbName=

Sid=

DatabaseConfigType=

RACOneNodeServiceName=

PolicyManaged=

CreateServerPool=

ServerPoolName=

Cardinality=

Force=

PqPoolName=

PqCardinality=

CreateAsContainerDatabase=

NumberOfPDBs=

PdbName=

UseLocalUndoForPDBs=

PdbAdminPassword=

Nodelist=

TemplateName=

SysPassword=

SystemPassword=

OracleHomeUserPassword=

EmConfiguration=

EmExpressPort=5500

RunCVUChecks=

DbsnmpPassword=

OmsHost=

OmsPort=

EmUser=

EmPassword=

DvConfiguration=

DvUserName=

DvUserPassword=

DvAccountManagerName=

DvAccountManagerPassword=

OlsConfiguration=

DatafileJarLocation=

DatafileDestination=

RecoveryAreaDestination=

StorageType=

DiskGroupName=

AsmsnmpPassword=

RecoveryGroupName=

CharacterSet=

NationalCharacterSet=

RegisterWithDirService=

DirServiceUserName=

DirServicePassword=

WalletPassword=

Listeners=

VariablesFile=

Variables=

InitParams=

SampleSchema=

MemoryPercentage=

DatabaseType=

AutomaticMemoryManagement=

TotalMemory=

2. Edit the response file dbca.rsp

[oracle@wjqdatabase] $vim response/dbca.rsp responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0

GdbName=prod.comsys.com

Sid=seiang

DatabaseConfigType=

RACOneNodeServiceName=

PolicyManaged=

CreateServerPool=

ServerPoolName=

Cardinality=

Force=

PqPoolName=

PqCardinality=

CreateAsContainerDatabase=

NumberOfPDBs=

PdbName=

UseLocalUndoForPDBs=

PdbAdminPassword=

Nodelist=

TemplateName=General_Purpose.dbc

SysPassword=oracle

SystemPassword=oracle

OracleHomeUserPassword=oracle

EmConfiguration=

EmExpressPort=5500

RunCVUChecks=

DbsnmpPassword=

OmsHost=

OmsPort=

EmUser=

EmPassword=

DvConfiguration=

DvUserName=

DvUserPassword=

DvAccountManagerName=

DvAccountManagerPassword=

OlsConfiguration=

DatafileJarLocation=

DatafileDestination=

RecoveryAreaDestination=

StorageType=

DiskGroupName=

AsmsnmpPassword=

RecoveryGroupName=

CharacterSet=

NationalCharacterSet=

RegisterWithDirService=

DirServiceUserName=

DirServicePassword=

WalletPassword=

Listeners=

VariablesFile=

Variables=

InitParams=

SampleSchema=true

MemoryPercentage=

DatabaseType=

AutomaticMemoryManagement=

TotalMemory=

3. Silently create a database

[oracle@wjqtemplates] $$ORACLE_HOME/bin/dbca-silent-createDatabase-responseFile / u01/sofrware/database/response/dbca.rsp

[WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oraclerecommended standards.

CAUSE:

A.Oracle recommends that the password entered should be at least 8 characters inlength, contain at least 1 uppercase character, 1 lower case character and 1digit [0-9].

B.Thepassword entered is a keyword that Oracle does not recommend to be used aspassword

ACTION: Specify a strong password. Ifrequired refer Oracle documentation for guidelines.

[WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oraclerecommended standards.

CAUSE:

A.Oracle recommends that the password entered should be at least 8 characters inlength, contain at least 1 uppercase character, 1 lower case character and 1digit [0-9].

B.Thepassword entered is a keyword that Oracle does not recommend to be used aspassword

ACTION: Specify a strong password. Ifrequired refer Oracle documentation for guidelines.

Copyingdatabase files

1%complete

2%complete

18% complete

33%complete

Creatingand starting Oracle instance

35%complete

40%complete

44%complete

49%complete

53%complete

54%complete

55%complete

58%complete

CompletingDatabase Creation

59%complete

60%complete

61%complete

64%complete

68%complete

69%complete

ExecutingPost Configuration Actions

100%complete

Look atthe log file "/ u01/app/oracle/cfgtoollogs/dbca/prod/prod.log" forfurther details.

3. Test whether the instance is registered successfully and whether it can log in to the database

[oracle@wjqdatabase] $lsnrctl status

LSNRCTLfor Linux: Version 12.2.0.1.0-Production on 07-JUL-2017 15:05:17

Copyright (c) 1991, 2016, Oracle. All rightsreserved.

Connectingto (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=wjq.comsys.com) (PORT=1521)

STATUSof the LISTENER

-

Alias LISTENER

Version TNSLSNR for Linux: Version12.2.0.1.0-Production

StartDate 06-JUL-2017 14:43:52

Uptime 1 days 0 hr. 21 min. 25 sec

TraceLevel off

Security ON: Local OS Authentication

SNMP OFF

ListenerParameter File / u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora

ListenerLog File / u01/app/oracle/diag/tnslsnr/wjq/listener/alert/log.xml

ListeningEndpoints Summary...

(DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=wjq.comsys.com) (PORT=1521))

(DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=EXTPROC1521)

ServicesSummary...

Service "prod.comsys.com" has 1 instance (s).

Instance "seiang", status READY,has 1 handler (s) for this service...

Service "seiangXDB.comsys.com" has 1 instance (s).

Instance "seiang", status READY,has 1 handler (s) for this service...

Thecommand completed successfully

[oracle@wjqdatabase] $sqlplus/ as sysdba

SQL*Plus:Release 12.2.0.1.0 Production on Fri Jul 7 15:06:40 2017

Copyright (c) 1982, 2016, Oracle. All rightsreserved.

Connectedto:

OracleDatabase 12c Enterprise Edition Release 12.2.0.1.0-64bit Production

SQL >

SQL > select status from v$instance

STATUS

-

OPEN

At this point, the static installation of Oracle12.2 is over. For the configuration of other complex parameters, please refer to the official Oracle documentation!

5. Mistakes encountered and solutions

1. Install Oracle software Times error: PRVF-0002: Could not retrieve local nodename.

View log information

[root@wjq~] # tail-f / tmp/OraInstall2017-07-06 / 01-49-38PM/installActions2017-07-06 / 01-49-38PM.log

INFO:Setting value for the property:configcmds in the bean:configcmdmappings

SEVERE: [FATAL] PRVF-0002: could not retrieve local node name.

Referassociated stacktrace#oracle.install.commons.util.exception.AbstractErrorAdvisor:37

INFO:Advice is ABORT

SEVERE:Unconditional Exit

INFO:Adding ExitStatus FAILURE to the exit status set

WARNING:A log of this session is currently saved as:/tmp/OraInstall2017-07-06-01-49-38PM/installActions2017-07-06-01-49-38PM.log.Oracle recommends that if you want to keep this log, you should move it fromthe temporary location.

INFO:Finding the most appropriate exit status for the current application

INFO:Exit Status is-1

INFO:Shutdown Oracle Database 12c Release 2 Installer

Guess that the corresponding ip of the hostname cannot be found.

Solution:

Modified / etc/hosts

[root@wjq~] # vim/etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4localhost4.localdomain4

:: 1 localhost localhost.localdomainlocalhost6 localhost6.localdomain6

10.1.1.45 wjq.comsys.com wjq

2. Install Oracle software Times error: Invalid My Oracle Supportcredentials. Specify the correct email address and password that you use to login to My Oracle Support.

View log information

[root@wjq] # tail-f/tmp/OraInstall2017-07-060001-57-21PM/installActions2017-07-060001-57-21PM.log

INFO: Waiting for completion of backgroundoperations

INFO: Completed background operations

INFO: Validating state

SEVERE: Invalid My Oracle Support credentials. Specify the correctemail address and password that you use to log in to My Oracle Support.

After 2 more incorrect attempts, the product will be registeredanonymously with the specified email address.

INFO: Adding ExitStatusVAR_VALIDATION_FAILURE to the exit status set

WARNING: A log of this session is currentlysaved as:/tmp/OraInstall2017-07-06: 01-57-21PM/installActions2017-07-06: 01-57-21PM.log.Oracle recommends that if you want to keep this log, you should move it fromthe temporary location.

INFO: Finding the most appropriate exitstatus for the current application

INFO: Exit Status is-2

INFO: Shutdown Oracle Database 12c Release2 Installer

The reason is:

There is a problem with the configuration of the parameters MYORACLESUPPORT_USERNAME and MYORACLESUPPORT_PASSWORD in the corresponding file db_install.rsp.

Solution:

These two parameters are not set.

3. Silently create database Times error: [DBT-10503] Invalid template file specified.

The reason for this error message is that there is an error in the parameter templateName configuration in the dbcs.rsp response file. The following is the template we chose when building the library, general purpose or Data warehouing or custom. This thing is under the path $ORACLE_HOME/assistants/dbca/templates

[oracle@wjq ~] $cd $ORACLE_HOME/assistants/dbca/templates

[oracle@wjq templates] $ll

Total 411616

-rw-r- 1 oracle oinstall 4697 Jan 26 15:38 Data_Warehouse.dbc

/ / template of data warehouse

-rw-r- 1 oracle oinstall 4577 Jan 26 15:38 General_Purpose.dbc

/ / Standard template

-rw-r- 1 oracle oinstall 10578 Jun 10 2016 New_Database.dbt

/ / Custom template

-rw-r- 1 oracle oinstall 121667584 Jan26 15:30 pdbseed.dfb

-rw-r- 1 oracle oinstall 6685 Jan 26 15:30 pdbseed.xml

-rw-r- 1 oracle oinstall 18726912 Jan 26 15:37 Seed_Database.ctl

/ / this is the control file of the recovered seed database

-rw-r- 1 oracle oinstall 281059328 Jan26 15:37 Seed_Database.dfb

/ / this is the backup slice of the seed database, and a database can be restored by adding the control file.

Solution:

Set the parameters in the dbca.rsp response file as follows: templateName=General_Purpose.dbc

4. Other errors

It is important to note that there can be no spaces on either side of the equal sign:

Oracle.install.option=INSTALL_DB_SWONLY

DECLINE_SECURITY_UPDATES should be set to true

INFO: Adding ExitStatus VAR_VALIDATION_FAILURE to the exit status set

Author: SEian.G (hard practice changes in 72, but it is difficult to laugh at 81)

◇ article is available at ITPUB: http://blog.itpub.net/31015730/

51CTO: synchronous updates on http://seiang.blog.51cto.com/

◇ article itpub address: http://blog.itpub.net/31015730/viewspace-2137909/

◇ article 51CTO address: http://seiang.blog.51cto.com/10819863/1946087

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.