首先下载oracle安装包
oracle12c的下载地址:http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
下载这两个包,解压,
在linux下运行runInstaller文件,就会出现一个很亮眼的Oracle12c的启动界面
基本的操作和Oracle11g大同小异。
唯一一个界面的区别就是oracle12c的一个新特性:Create as Container Database
安装时会提醒执行两个.sh文件,等待完成即可。
最后配置环境变量,并使之生效
PATH=$PATH:$HOME/bin
export PATH
export ORACLE_HOME=/home/oracle/app/oracle/product/12.1.0/dbhome_1
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:$PATH
这里的ORACLE_SID是你的数据库名。
修改/home/oracleDatabase/app/product/12.1.0/dbhome_1/network/admin 目录下listener.ora和tnsnames.ora
listener.ora :
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.140)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = /home/oracleDatabase/app
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
#BEQUEATH CONFIG
(GLOBAL_DBNAME=orcl)
(SID_NAME=orcl)
(ORACLE_HOME=/home/oracleDatabase/app/product/12.1.0/dbhome_1)
#PRESPAWN CONFIG
(PRESPAWN_MAX=20)
(PRESPAWN_LIST=
(PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
)
)
)
tnsnames.ora:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.140)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
用 2.sqlplus/as sysdba
3.SQL>startup(启动oracle 数据库)
#lsnrctl start (启动oracle 数据库监听)