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

In the absence of a graphical interface, installing Oracle database software and creating a database can only be done on the command line.

This article assumes that the prerequisites for installation are already configured.

Silently install the database software

1. Prepare the parameter file

This parameter file is used to install the software, which is configured with the version, language, ORACLE_HOME and other information to be installed.

The template of this file is db_install.rsp in the database/response directory. The parameters in the file can be used in http://docs.oracle.com/cd/E11882_01/em.112/e12255/oui3_response_files.htm#OUICG183.

# the modification record is as follows: oracle.install.option=INSTALL_DB_SWONLY # install software only UNIX_GROUP_NAME=oinstall # installed operating system user group INVENTORY_LOCATION=/u01/app/oraInventory/ # Inventory directory path SELECTED_LANGUAGES=en # installation language ORACLE_HOME=/u01/app/oracle/product/11.2.0/db # Oracle Home path ORACLE_BASE=/u01/app/oracle/ # Oracle Base path oracle.install.db.InstallEdition=EE # database version The operating system user group oracle.install.db.OPER_GROUP=oinstall # DBA group to which this EE Enterprise oracle.install.db.DBA_GROUP=dba # OPER group belongs must be set to true Otherwise, other information needs to be modified # create an Inventory directory [oracle@rhel6 11.2.0.4_database] $cd / u01/app/ [oracle@rhel6 app] $lsoracle [oracle@rhel6 app] $mkdir oraInventory

2. Silent installation

[oracle@rhel6 11.2.0.4_database] $. / runInstaller-silent-force-responseFile / opt/soft/11g/11.2.0.4_database/response/install.rsp Starting Oracle Universal Installer...Checking Temp space: must be greater than 120 MB. Actual 34496 MB PassedChecking swap space: must be greater than 150 MB. Actual 2047 MB PassedPreparing to launch Oracle Universal Installer from / tmp/OraInstall2016-12-210005-02-49PM. Please wait... [oracle@rhel6 11.2.0.4_database] $[WARNING] [INS-13014] Target environment do not meet some optional requirements. CAUSE: Some of the optional prerequisites are not met. See logs for details. / tmp/OraInstall2016-12-211505-02-49PM/installActions2016-12-211505-02-49PM.log ACTION: Identify the list of failed prerequisite checks from the log: / tmp/OraInstall2016-12-211505-02-49PM/installActions2016-12-211505-02-49PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.You can find the log of this install session at: / u01/app/oraInventory/logs/installActions2016-12-210005-02-49PM.log# log file: / u01/app/oraInventory/logs/installActions2016-12-211605-02-49PM.log [oracle@rhel6 11.2.0.4_database] $The installation of Oracle Database 11g was successful.Please check'/ u01/app/oraInventory/logs / silentInstall2016-12-210005-02-49PM.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/db/root.shSuccessfully Setup Software.

3. Use root to execute scripts

[root@rhel6 response] # / u01/app/oraInventory/orainstRoot.shChanging 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@rhel6 response] # / u01/app/oracle/product/11.2.0/db/root.shCheck / u01/app/oracle/product/11.2.0/db/install/root_rhel6_2016-12-21A 17-12-23.log for the output of root script [root@rhel6 response] # cat / u01/app/oracle/product/11.2.0/db/ Install/root_rhel6_2016-12-21 October 17-12-23.logPerforming root user operation for Oracle 11g The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= / u01/app/oracle/product/11.2.0/db Copying dbhome to / usr/local/bin. Copying oraenv to / usr/local/bin... Copying coraenv to / usr/local/bin... Creating / etc/oratab file...Entries will be added to the / etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root script.Now product-specific root actions will be performed.Finished product-specific root actions.Finished product-specific root actions.# Test sqlplus [oracle@rhel6 11.2.0.4_database] $sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Wed Dec 21 17:16:19 2016Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL >

4. Build the database by hand

Official document: http://docs.oracle.com/cd/E11882_01/server.112/e25494/create.htm#CIAEJDBE

4.1 configure environment variables

Export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbexport ORACLE_SID=mydbexport PATH=$PATH:$ORACLE_HOME/bin# creates a data file storage directory [oracle@rhel6 oracle] $cd $ORACLE_ base [oracle @ rhel6 oracle] $mkdir-p oradata/mydb

4.2 create pfile by hand

# only the necessary parameters are written here, and the parameters [oracle@rhel6 ~] $cat mydb.oradb_name=mydbcontrol_files=/u01/app/oracle/oradata/mydb/control01.ctl,/u01/app/oracle/oradata/mydb/control02.ctl should be written according to the actual situation in production.

4.3 launch the instance to NOMOUNT status

[oracle@rhel6] $sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Wed Dec 21 17:26:31 2016Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to an idle instance.SQL > startup nomount pfile=/home/oracle/mydb.ora;ORACLE instance started.Total System Global Area 217157632 bytesFixed Size 2251816 bytesVariable Size 159384536 bytesDatabase Buffers 50331648 bytesRedo Buffers 5189632 bytes

4.4 create spfile and restart to NOMOUNT state

SQL > create spfile from pfile='/home/oracle/mydb.ora';File created.SQL > shutdown immediate;ORA-01507: database not mountedORACLE instance shut down.SQL > startup nomount;ORACLE instance started.Total System Global Area 217157632 bytesFixed Size 2251816 bytesVariable Size 159384536 bytesDatabase Buffers 50331648 bytesRedo Buffers 5189632 bytes

4.4 execute the CREATE DATABASE statement to create the database

SQL > CREATE DATABASE mydb 2 USER SYS IDENTIFIED BY oracle 3 USER SYSTEM IDENTIFIED BY oracle 4 LOGFILE GROUP 1 ('/ u01 BLOCKSIZE BLOCKSIZE SIZE redo01.log') SIZE 100m oradata 512,5 GROUP 2 ('/ u01 BLOCKSIZE BLOCKSIZE) 6 GROUP 3 ('/ u01 DATAFILE DATAFILE') SIZE 100m BLOCKSIZE 512 7 MAXLOGFILES 5 8 MAXLOGMEMBERS 5 9 MAXLOGHISTORY 1 10 MAXDATAFILES 100 11 NATIONAL CHARACTER SET AL16UTF16 13 EXTENT MANAGEMENT LOCAL 14 DATAFILE'/ u01 REUSE REUSE 01.dbf' oradata 15 SYSAUX DATAFILE'/ u01 REUSE TABLESPACE users 17 DATAFILE'/ u01 apprenticeship oradataUS01.dbf' 18 SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED 19 DEFAULT TEMPORARY TABLESPACE tempts1 20 TEMPFILE'/ u01 REUSE AUTOEXTEND ON MAXSIZE UNLIMITED REUSE AUTOEXTEND ON MAXSIZE UNLIMITED REUSE mydbametemp01.dbf' 21 oracle20m REUSE 22 oracle23 orada'/ u01 appacleUniplicoradatals01.dbtbs01.dbf' 24 Database created.

4.5 execute the create data dictionary script

Conn / as sysdba@?/rdbms/admin/catalog.sql@?/rdbms/admin/catproc.sql@?/rdbms/admin/utlrp.sqlconn system/oracle@?/sqlplus/admin/pupbld.sql

5. Create a monitor and start it

[oracle@rhel6 mydb] $cd $ORACLE_HOME/network/ admin [oracle @ rhel6 admin] $lssamples shrept.lst [oracle@rhel6 admin] $vi listener.ora [oracle@rhel6 admin] $cat listener.ora LISTENER= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=tcp) (HOST=rhel6) (PORT=1521)) (ADDRESS= (PROTOCOL=ipc) (KEY=extproc) [oracle@rhel6 admin] $lsnrctl startLSNRCTL for Linux: Version 11.2.0.4.0-Production on 21-DEC-2016 17:41:13Copyright (c) 1991, 2013, Oracle. All rights reserved.Starting / u01/app/oracle/product/11.2.0/db/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 11.2.0.4.0-ProductionSystem parameter file is / u01/app/oracle/product/11.2.0/db/network/admin/listener.oraLog messages written to / u01/app/oracle/diag/tnslsnr/rhel6/listener/alert/log.xmlListening on: (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=rhel6) (PORT=1521)) Listening on: ( DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=extproc)) Connecting to (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=rhel6) (PORT=1521)) STATUS of the LISTENER----Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.4.0-ProductionStart Date 21-DEC-2016 17:41:15Uptime 0 days 0 hr. 0 min. 2 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File / u01/app/oracle/product/11.2.0/db/network/admin/listener.oraListener Log File / u01/app/oracle/diag/tnslsnr/rhel6/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=rhel6) (PORT=1521) (DESCRIPTION= (ADDRESS= (PROTOCOL=ipc) (KEY=extproc) The listener supports no servicesThe command completed successfully

6. Testing

C:\ Users\ victor > sqlplus system/oracle@192.168.56.3/mydbSQL*Plus: Release 12.1.0.1.0 Production on Wednesday December 21 17:51:05 2016Copyright (c) 1982, 2013, Oracle. All rights reserved. Connect to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL > select open_mode from vested database boot open model read WRITE

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.