oracle12c安装

1:安装oracle所需软件包 
Oracle 12c所需的rpm包如下:
 
[root@ser6-51 mongodb]# yum install binutils compat-libcap1 compat-libstdc+±33 gcc gcc-c++ glibc glibc-devel ksh libgcc libstdc++ libstdc+±devel libaio libaio-devel libXext libXtst libX11 libXau libxcb libXi make sysstat -y

验证 Oracle 所需要的系统依赖程序包是否完整。
 
 
[root@ser6-51 mongodb]#  rpm -qa binutils compat-libcap1 compat-libstdc+±33 gcc gcc-c++ glibc glibc-devel ksh libgcc libstdc++ libstdc+±devel libaio libaio-devel libXext libXtst libX11 libXau libxcb libXi make sysstat

libgcc-4.4.7-11.el6.x86_64
libstdc+±4.4.7-11.el6.x86_64
gcc-c+±4.4.7-11.el6.x86_64
glibc-2.12-1.149.el6_6.9.x86_64
libX11-1.6.0-2.2.el6.x86_64
glibc-devel-2.12-1.149.el6_6.9.x86_64
compat-libstdc+±33-3.2.3-69.el6.x86_64
make-3.81-20.el6.x86_64
libaio-0.3.107-10.el6.x86_64
libXau-1.0.6-4.el6.x86_64
libstdc+±devel-4.4.7-11.el6.x86_64
libXext-1.3.2-2.1.el6.x86_64
libXtst-1.2.2-2.1.el6.x86_64
compat-libcap1-1.10-1.x86_64
ksh-20120801-21.el6_6.3.x86_64
binutils-2.20.51.0.2-5.42.el6.x86_64
gcc-4.4.7-11.el6.x86_64
libxcb-1.9.1-2.el6.x86_64
libXi-1.7.2-2.2.el6.x86_64
sysstat-9.0.4-27.el6.x86_64
libaio-devel-0.3.107-10.el6.x86_64

2:对OS进行配置

2.1 创建相关用户和用户组
groupadd oinstall
groupadd oper
groupadd dba
useradd -g oinstall -G dba,oper oracle
 
2.2 修改oracle用户的密码
passwd oracle
 
2.3 修改系统参数
vi /etc/sysctl.conf

添加:
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
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

运行sysctl -p应用以上参数
/sbin/sysctl -p
 
2.4 修改用户Limits
vi /etc/sysctl.conf
新增如下内容:
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle stack nproc 10240
oracle stack nproc 10240
 
2.5 创建相关目录

mkdir -p /u01/app/oracle/product/12c/db_1
mkdir -p /u01/app/oracle/oradata
mkdir -p /u01/app/oracle/flash_recovery_area
mkdir -p /u01/app/oracle/archlog
chown -R oracle:oinstall /u01
2.6 配置环境变量
su oracle
vi .bash_profile
添加:

Oracle Settings

COLUMNS=132; export COLUMNS

LINES=47; export LINES

EDITOR=vi; export EDITOR

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/12c/db_1; export ORACLE_HOME

ORACLE_SID=orcl; export ORACLE_SID

SHLIB_PATH=$LD_LIBRARY_PATH;export SHLIB_PATH

NLS_LANG=American_America.zhs16gbk;export NLS_LANG

ORA_NLS10=$ORACLE_HOME/nls/data;export ORA_NLS10

TNS_ADMIN=$ORACLE_HOME/network/admin;export TNS_ADMIN

ORACLE_TERM=xterm; export ORACLE_TERM

PATH=/usr/sbin:$PATH; export PATH

PATH= O R A C L E H O M E / b i n : ORACLE_HOME/bin: ORACLEHOME/bin:PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

CLASSPATH= O R A C L E H O M E / j r e : ORACLE_HOME/jre: ORACLEHOME/jre:ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

alias glance=/opt/perf/bin/glance:x

alias gohome=‘cd /u01/app/oracle/product/10.2.0’

alias cdb=‘cd /u01/app/oracle/admin/orcl/bdump’

alias cdu=‘cd /u01/app/oracle/admin/orcl/udump’

–里面的内容可以根据实际情况进行改动,如可以改动ORACLE_SID.
修改完用:source .bash_profile生效。
 
2.7修改/etc/hosts 
[oracle@ser6-51 ~]   c a t   / e t c / h o s t s 127.0.0.1       l o c a l h o s t   l o c a l h o s t . l o c a l d o m a i n   l o c a l h o s t 4   l o c a l h o s t 4. l o c a l d o m a i n 4 : : 1                   l o c a l h o s t   l o c a l h o s t . l o c a l d o m a i n   l o c a l h o s t 6   l o c a l h o s t 6. l o c a l d o m a i n 6   [ o r a c l e @ s e r 6 − 51     ]  cat /etc/hosts 127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1         localhost localhost.localdomain localhost6 localhost6.localdomain6   [oracle@ser6-51 ~]  cat /etc/hosts127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4::1         localhost localhost.localdomain localhost6 localhost6.localdomain6 [oracle@ser651  ] hostname
ser6-51
 
 
把127.0.0.1那一行改为:127.0.0.1   ser6-51
 
2.8修改操作系统发行版本
由于 oracle 还没有推出支持 CentOS 的安装包,所以需要修改发行版本,以便通过 oracle 的安装检查。
vi /etc/redhat-release 
把CentOS release 6.5 (Final) 注释掉,前面加上一行redhat-4,当oracle安装完成后,再修改回来。
如:
redhat-4
#CentOS release 6.5 (Final)
2.9 关闭SELINUX

vi /etc/selinux/config
将SELINUX那一行改成:
SELINUX=disabled
3:安装

3.1 解压安装包
[root@ser6-51 download]# ls -ltr
-rw-r–r-- 1 root root 1014530602 Jul  6 15:07 linuxamd64_12102_database_2of2.zip
-rw-r–r-- 1 root root 1673544724 Jul  6 15:12 linuxamd64_12102_database_1of2.zip
 
[root@ser6-51 download]# unzip linuxamd64_12102_database_1of2.zip 
[root@ser6-51 download]# unzip linuxamd64_12102_database_2of2.zip 
 
[root@ser6-51 download]# ls -ltr
drwxr-xr-x 7 root root       4096 Jul  7  2014 database
-rw-r–r-- 1 root root 1014530602 Jul  6 15:07 linuxamd64_12102_database_2of2.zip
-rw-r–r-- 1 root root 1673544724 Jul  6 15:12 linuxamd64_12102_database_1of2.zip
 
3.2 安装oracle软件

3.2.1 新建静默安装的应答文件
su - oracle
 
vi 12102db_install.rsp
添加:

######################################################################

Copyright© Oracle Corporation 1998,2013. All rights reserved.

Specify values for the variables listed below to customize

your installation.

Each variable is associated with a comment. The comment

can help to populate the variables with the appropriate

values.

IMPORTANT NOTE: This file contains plain text passwords and

should be secured to have read permission only by oracle user

or db administrator who owns this installation.

######################################################################

#-------------------------------------------------------------------------------

Do not change the following system generated value.

#-------------------------------------------------------------------------------

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.1.0

#-------------------------------------------------------------------------------

Specify the installation option.

It can be one of the following:

- INSTALL_DB_SWONLY

- INSTALL_DB_AND_CONFIG

- UPGRADE_DB

#------------------------------------------------------------------------------

oracle.install.option=INSTALL_DB_SWONLY

#-------------------------------------------------------------------------------

Specify the hostname of the system as set during the install. It can be used

to force the installation to use an alternative hostname rather than using the

first hostname found on the system. (e.g., for systems with multiple hostnames

and network interfaces)

#-------------------------------------------------------------------------------

ORACLE_HOSTNAME=ser6-51

#-------------------------------------------------------------------------------

Specify the Unix group to be set for the inventory directory.

#-------------------------------------------------------------------------------

UNIX_GROUP_NAME=oinstall

#-------------------------------------------------------------------------------

Specify the location which holds the inventory files.

This is an optional parameter if installing on

Windows based Operating System.

#-------------------------------------------------------------------------------

INVENTORY_LOCATION=/u01/app/oraInventory

#-------------------------------------------------------------------------------

Specify the languages in which the components will be installed.

en : English ja : Japanese

fr : French ko : Korean

ar : Arabic es : Latin American Spanish

bn : Bengali lv : Latvian

pt_BR: Brazilian Portuguese lt : Lithuanian

bg : Bulgarian ms : Malay

fr_CA: Canadian French es_MX: Mexican Spanish

ca : Catalan no : Norwegian

hr : Croatian pl : Polish

cs : Czech pt : Portuguese

da : Danish ro : Romanian

nl : Dutch ru : Russian

ar_EG: Egyptian zh_CN: Simplified Chinese

en_GB: English (Great Britain) sk : Slovak

et : Estonian sl : Slovenian

fi : Finnish es_ES: Spanish

de : German sv : Swedish

el : Greek th : Thai

iw : Hebrew zh_TW: Traditional Chinese

hu : Hungarian tr : Turkish

is : Icelandic uk : Ukrainian

in : Indonesian vi : Vietnamese

it : Italian

all_langs : All languages

Specify value as the following to select any of the languages.

Example : SELECTED_LANGUAGES=en,fr,ja

Specify value as the following to select all the languages.

Example : SELECTED_LANGUAGES=all_langs

#-------------------------------------------------------------------------------

SELECTED_LANGUAGES=en

#-------------------------------------------------------------------------------

Specify the complete path of the Oracle Home.

#-------------------------------------------------------------------------------

ORACLE_HOME=/u01/app/oracle/product/12c/db_1

#-------------------------------------------------------------------------------

Specify the complete path of the Oracle Base.

#-------------------------------------------------------------------------------

ORACLE_BASE=/u01/app/oracle

#-------------------------------------------------------------------------------

Specify the installation edition of the component.

The value should contain only one of these choices.

- EE : Enterprise Edition

- SE : Standard Edition

- SEONE : Standard Edition One

- PE : Personal Edition (WINDOWS ONLY)

#-------------------------------------------------------------------------------

oracle.install.db.InstallEdition=EE

#################################################################################

PRIVILEGED OPERATING SYSTEM GROUPS

------------------------------------------

Provide values for the OS groups to which OSDBA and OSOPER privileges

needs to be granted. If the install is being performed as a member of the

group “dba”, then that will be used unless specified otherwise below.

The value to be specified for OSDBA and OSOPER group is only for UNIX based

Operating System.

###############################################################################

#------------------------------------------------------------------------------

The DBA_GROUP is the OS group which is to be granted OSDBA privileges.

#-------------------------------------------------------------------------------

oracle.install.db.DBA_GROUP=dba

#------------------------------------------------------------------------------

The OPER_GROUP is the OS group which is to be granted OSOPER privileges.

The value to be specified for OSOPER group is optional.

#------------------------------------------------------------------------------

oracle.install.db.OPER_GROUP=oper

#------------------------------------------------------------------------------

The BACKUPDBA_GROUP is the OS group which is to be granted OSBACKUPDBA privileges.

#------------------------------------------------------------------------------

oracle.install.db.BACKUPDBA_GROUP=dba

#------------------------------------------------------------------------------

The DGDBA_GROUP is the OS group which is to be granted OSDGDBA privileges.

#------------------------------------------------------------------------------

oracle.install.db.DGDBA_GROUP=dba

#------------------------------------------------------------------------------

The KMDBA_GROUP is the OS group which is to be granted OSKMDBA privileges.

#------------------------------------------------------------------------------

oracle.install.db.KMDBA_GROUP=dba

################################################################################

Database Configuration Options

################################################################################

#-------------------------------------------------------------------------------

Specify the type of database to create.

It can be one of the following:

- GENERAL_PURPOSE/TRANSACTION_PROCESSING

- DATA_WAREHOUSE

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.type=

#-------------------------------------------------------------------------------

Specify the Starter Database Global Database Name.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.globalDBName=

#-------------------------------------------------------------------------------

Specify the Starter Database SID.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.SID=

#-------------------------------------------------------------------------------

Specify whether the database should be configured as a Container database.

#-------------------------------------------------------------------------------

oracle.install.db.ConfigureAsContainerDB=

#-------------------------------------------------------------------------------

Specify the Pluggable Database name for the pluggable database in Container Database.

#-------------------------------------------------------------------------------

oracle.install.db.config.PDBName=

#-------------------------------------------------------------------------------

Specify the Starter Database character set.

One of the following

AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2,

EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257,

BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6,

AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8,

IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE,

KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950,

ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.characterSet=

#------------------------------------------------------------------------------

This variable should be set to true if Automatic Memory Management

in Database is desired.

If Automatic Memory Management is not desired, and memory allocation

is to be done manually, then set it to false.

#------------------------------------------------------------------------------

oracle.install.db.config.starterdb.memoryOption=

#-------------------------------------------------------------------------------

Specify the total memory allocation for the database. Value(in MB) should be

at least 256 MB, and should not exceed the total physical memory available

on the system.

Example: oracle.install.db.config.starterdb.memoryLimit=512

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.memoryLimit=

#################################################################################

Passwords can be supplied for the following four schemas in the

starter database:

SYS

SYSTEM

DBSNMP (used by Enterprise Manager)

Same password can be used for all accounts (not recommended)

or different passwords for each account can be provided (recommended)

#################################################################################

#------------------------------------------------------------------------------

This variable holds the password that is to be used for all schemas in the

starter database.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.password.ALL=oracle

#-------------------------------------------------------------------------------

Specify the SYS password for the starter database.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.password.SYS=

#-------------------------------------------------------------------------------

Specify the SYSTEM password for the starter database.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.password.SYSTEM=

#-------------------------------------------------------------------------------

Specify the DBSNMP password for the starter database.

#-------------------------------------------------------------------------------

oracle.install.db.config.starterdb.password.DBSNMP=

#-------------------------------------------------------------------------------

Specify the PDBADMIN password required for creation of Pluggable Database in the Container Database.

#-------------------------------------------------------------------------------

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

#------------------------------------------------------------------------------

Specify whether user doesn’t want to configure Security Updates.

The value for this variable should be true if you don’t want to configure

Security Updates, false otherwise.

The value can be either true or false. If left blank it will be assumed

to be false.

Example : DECLINE_SECURITY_UPDATES=false

#------------------------------------------------------------------------------

DECLINE_SECURITY_UPDATES=true

#------------------------------------------------------------------------------

Specify the auto-updates option. It can be one of the following:

- MYORACLESUPPORT_DOWNLOAD

- OFFLINE_UPDATES

- SKIP_UPDATES

#------------------------------------------------------------------------------

oracle.installer.autoupdates.option=SKIP_UPDATES

3.2.2 静默安装软件
[root@ser6-51 install]# su - oracle
[oracle@ser6-51 ~]   c d   / d o w n l o a d / d a t a b a s e / [ o r a c l e @ s e r 6 − 51   d a t a b a s e ]  cd /download/database/ [oracle@ser6-51 database]  cd /download/database/[oracle@ser651 database] ./runInstaller  -silent -responseFile /home/oracle/12102db_install.rsp
 
  
/*
假如安装过程中报错了,已经在 O R A C L E H O M E 和 / u 01 / a p p / o r a I n v e n t o r y 下 生 成 了 很 多 文 件 目 录 。 想 再 次 安 装 的 话 , 需 要 先 删 除 这 些 文 件 : [ o r a c l e @ s e r 6 − 52   a p p ] ORACLE_HOME和/u01/app/oraInventory下生成了很多文件目录。想再次安装的话,需要先删除这些文件: [oracle@ser6-52 app] ORACLEHOME/u01/app/oraInventory[oracle@ser652 app] pwd
/u01/app
[oracle@ser6-52 app]   r m   − r f   / u 01 / a p p / o r a I n v e n t o r y   c d    rm -rf /u01/app/oraInventory   cd   rm rf /u01/app/oraInventory cd ORACLE_HOME/
rm  -rf *
*/
执行两个脚本:
[root@ser6-51 ~]# sh /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@ser6-51 ~]# sh /u01/app/oracle/product/12c/db_1/root.sh 
Check /u01/app/oracle/product/12c/db_1/install/root_ser6-51_2015-07-06_19-00-11.log for the output of root script
 
 
3.3 建库
 
 
3.3.1 建响应文件
v i /home/oracle/dbca.rsp
添加:

[GENERAL]

RESPONSEFILE_VERSION = “12.1.2.0”

OPERATION_TYPE = “createDatabase”

[CREATEDATABASE]

GDBNAME = “orcl”

SID = “orcl”

TEMPLATENAME = “New_Database.dbt”

SYSPASSWORD = “orcl”

SYSTEMPASSWORD = “orcl”

SYSMANPASSWORD = “orcl”

DBSNMPPASSWORD = “orcl”

DATAFILEDESTINATION ="/u01/app/oracle/oradata"

STORAGETYPE=FS

CHARACTERSET = “ZHS16GBK”

DATABASETYPE = “MULTIPURPOSE”

AUTOMATICMEMORYMANAGEMENT = “FALSE”

3.3.2 执行命令
dbca -silent -responseFile /home/oracle/dbca.rsp

Creating and starting Oracle instance

1% complete

4% complete

Creating database files

5% complete

9% complete

Creating data dictionary views

10% complete

13% complete

14% complete

15% complete

16% complete

17% complete

18% complete

21% complete

22% complete

23% complete

24% complete

Adding Oracle JVM

30% complete

37% complete

44% complete

46% complete

Adding Oracle Text

47% complete

48% complete

50% complete

51% complete

Adding Oracle Multimedia

52% complete

65% complete

Adding Oracle OLAP

66% complete

67% complete

68% complete

69% complete

Adding Oracle Spatial

70% complete

78% complete

Adding Oracle Application Express

83% complete

87% complete

Completing Database Creation

89% complete

90% complete

91% complete

95% complete

100% complete

[oracle@ser6-51 dbs]   e x p o r t   O R A C L E S I D = o r c l [ o r a c l e @ s e r 6 − 51   d b s ]  export ORACLE_SID=orcl [oracle@ser6-51 dbs]  export ORACLESID=orcl[oracle@ser651 dbs] sqlplus / as sysdba
 
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jul 8 09:29:16 2015
 
Copyright © 1982, 2014, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
 
SQL> select status from v$instance;
 
STATUS

OPEN
 
 
 
3.4配监听
 
3.4.1 建响应文件
vi 12102_netca.rsp
添加:

[GENERAL]

RESPONSEFILE_VERSION=“12.1”

CREATE_TYPE=“CUSTOM”

#-------------------------------------------------------------------------------

Name : SHOW_GUI

Datatype : Boolean

Description: This variable controls appearance/suppression of the NetCA GUI,

Pre-req : N/A

Default : TRUE

Note:

This must be set to false in order to run NetCA in silent mode.

This is a substitute of “/silent” flag in the NetCA command line.

The command line flag has precedence over the one in this response file.

This feature is present since 10.1.0.3.

#-------------------------------------------------------------------------------

#SHOW_GUI=false

#-------------------------------------------------------------------------------

Name : LOG_FILE

Datatype : String

Description: If present, NetCA will log output to this file in addition to the

standard out.

Pre-req : N/A

Default : NONE

Note:

This is a substitute of “/log” in the NetCA command line.

The command line argument has precedence over the one in this response file.

This feature is present since 10.1.0.3.

#-------------------------------------------------------------------------------

#LOG_FILE=""/oracle12cHome/network/tools/log/netca.log""

[oracle.net.ca]

#INSTALLED_COMPONENTS;StringList;list of installed components

The possible values for installed components are:

“net8”,“server”,“client”,“aso”, “cman”, “javavm”

INSTALLED_COMPONENTS={“server”,“net8”,“javavm”}

#INSTALL_TYPE;String;type of install

The possible values for install type are:

“typical”,“minimal” or “custom”

INSTALL_TYPE="“typical”"

#LISTENER_NUMBER;Number;Number of Listeners

A typical install sets one listener

LISTENER_NUMBER=1

#LISTENER_NAMES;StringList;list of listener names

The values for listener are:

“LISTENER”,“LISTENER1”,“LISTENER2”,“LISTENER3”, …

A typical install sets only “LISTENER”

LISTENER_NAMES=“LISTENER”

#LISTENER_PROTOCOLS;StringList;list of listener addresses (protocols and parameters separated by semicolons)

The possible values for listener protocols are:

“TCP;1521”,“TCPS;2484”,“NMP;ORAPIPE”,“IPC;IPCKEY”,“VI;1521”

A typical install sets only “TCP;1521”

LISTENER_PROTOCOLS=“TCP;1521”

#LISTENER_START;String;name of the listener to start, in double quotes

LISTENER_START="“LISTENER”"

#NAMING_METHODS;StringList;list of naming methods

The possible values for naming methods are:

LDAP, TNSNAMES, ONAMES, HOSTNAME, NOVELL, NIS, DCE

A typical install sets only: “TNSNAMES”,“ONAMES”,“HOSTNAMES”

or “LDAP”,“TNSNAMES”,“ONAMES”,“HOSTNAMES” for LDAP

NAMING_METHODS={“TNSNAMES”,“ONAMES”,“HOSTNAME”}

#NOVELL_NAMECONTEXT;String;Novell Directory Service name context, in double quotes

A typical install does not use this variable.

#NOVELL_NAMECONTEXT = ““NAMCONTEXT””

#SUN_METAMAP;String; SUN meta map, in double quotes

A typical install does not use this variable.

#SUN_METAMAP = ““MAP””

#DCE_CELLNAME;String;DCE cell name, in double quotes

A typical install does not use this variable.

#DCE_CELLNAME = ““CELL””

#NSN_NUMBER;Number;Number of NetService Names

A typical install sets one net service name

NSN_NUMBER=1

#NSN_NAMES;StringList;list of Net Service names

A typical install sets net service name to “EXTPROC_CONNECTION_DATA”

NSN_NAMES=“EXTPROC_CONNECTION_DATA”

#NSN_SERVICE;StringList;Oracle12c database’s service name

A typical install sets Oracle12c database’s service name to “PLSExtProc”

NSN_SERVICE=“PLSExtProc”

3.4.2 执行命令
[oracle@ser6-51 ~]$ netca -silent -responseFile /home/oracle/12102_netca.rsp
 
Parsing command line arguments:
    Parameter “silent” = true
    Parameter “responsefile” = /home/oracle/12102_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/12c/db_1/bin/lsnrctl start LISTENER
    Listener Control complete.
    Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
 
 
4:设置开机启动
4.1 修改dbstart文件
假如执行/u01/app/oracle/product/12c/db_1/bin/dbstart报错:
ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
Usage: /u01/app/oracle/oracle/product/10.2.0/db_1/bin/dbstart ORACLE_HOME
修改dbstart文件,将ORACLE_HOME_LISTNER= 1 修 改 为 O R A C L E H O M E L I S T N E R = 1 修改为ORACLE_HOME_LISTNER= 1ORACLEHOMELISTNER=ORACLE_HOME
 
4.2修改/etc/oratab
添加:
orcl:/u01/app/oracle/product/12c/db_1:Y
4.3修改/etc/rc.d/rc.local
添加一行:
su oracle -lc /u01/app/oracle/product/12c/db_1/bin/dbstart
–说明:/u01/app/oracle/product/12c/dbhome_1为oracle的安装目录,要根据实际情况进行修改。
 
reboot试验下看是否能开机自动启动。
 
5:开1521端口
如果防火墙开启了的话,要开1521端口,允许远程访问。
vi /etc/sysconfig/iptables
直接在配置文件里已有的-A INPUT那些命令下面
添加一行:
-A INPUT -m state --state NEW -m tcp -p tcp --dport 1521-j ACCEPT
重启防火墙
[root@ser6-52 mongodb]# /etc/init.d/iptables restart
iptables: Setting chains to policy ACCEPT: filter          [  OK  ]
iptables: Flushing firewall rules:                         [  OK  ]
iptables: Unloading modules:                               [  OK  ]
iptables: Applying firewall rules:                         [  OK  ]
 
6:后续配置
#把操作系统版本改回原来的配置
[root@pc ~]# vi /etc/redhat-release
Red Hat Enterprise Linux Server release 5.8 (Tikanga)
修改后:
#redhat-4
CentOS release 6.5 (Final)
 
对应步骤2.8。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值