在上篇博客
[oracle12c linux安装教程
],安装后还需要对数据库进行其他设置。
1 、监听配置
1.1 listener.ora 配置
oracle用户下
cd $ORACLE_HOME/network/admin
vim listener.ora
添加如下内容
SID_LIST_LISTENER=
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /home/oracle/app/oracle/product/12.2.0/dbhome_1)
(SID_NAME = orcl)
)
(SID_DESC =
(GLOBAL_DBNAME = orclpdb)
(ORACLE_HOME = /home/oracle/app/oracle/product/12.2.0/dbhome_1)
(SID_NAME = orcl)
)
)
1.2 tnsnames.ora配置
同样也是 $ORACLE_HOME/network/admin 目录下修改 tnsnames.ora文件,
添加入内容:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
ORCLPDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclpdb)
)
)
1.3 重启监听
lsnrctl stop
lsnrctl start
lsnrctl status
重启使用 lsnrctl reload 也开业
看到是有一个unknown,unknown是动态监听可以不用管。
使用tnsping 检测是否正常ping上新配置的监听
tnsping orclpdb
正常ping通。
1.4 远程连接测试
找到本地TNS_ADMIN 配置路径
修改 tnsnames.ora。
添加如下内容
ORCLPDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.66)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclpdb)
)
)
本地打开dos命令窗口,使用sqlplus 可以正常连接orclpdb
conn sys/密码@192.168.8.66:1521/orclpdb as sysdba
2、设置数据库开机自启动
2.1 dbstart配置
oracle 用户 下
cd $ORACLE_HOME/bin
vim dbstart
将 ORACLE_HOME_LISTNER=$1改为
ORACLE_HOME_LISTNER=$ORACLE_HOME
2.2 oratab配置
切换到root用户,
vim /etc/oratab
添加如下内容
orcl:/home/oracle/app/oracle/product/12.2.0/dbhome_1:Y
2.3 rc.local配置
cd /etc/rc.d
vim rc.local
添加如下内容
su oracle -lc /home/oracle/app/oracle/product/12.2.0/dbhome_1/bin/dbstart
su oracle -lc "/home/oracle/app/oracle/product/12.2.0/dbhome_1/bin/lsnrctl start"
第二个命令需要引号, 中命令有空格。
授予执行权限
chmod 755 rc.local
2.4 验证是否启动能否执行
手动执行
./rc.local
看到能启动成功
2.5 重启验证是否自启动
重启后,
sqlplus /nolog
conn /as sysdba
select global_name from global_name;