ROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db)(PORT = 1521)) #将HOST改为db
)
)
[oracle@localhost admin]$ vim tnsnames.ora
# tnsnames.ora Network Configuration File: /opt/ora11/product/11.2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
GNNT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db)(PORT = 1521)) #将HOST改为db
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = gnnt)
)
)
SQL>!lsnrctl status #最后一行显示The command completed successfully,代表监听成功
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 18-NOV-2015 17:28:52
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 18-NOV-2015 12:41:04
Uptime 0 days 4 hr. 47 min. 47 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/ora11/product/11.2/network/admin/listener.ora
Listener Log File /opt/ora11/diag/tnslsnr/db/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "gnnt" has 2 instance(s).
Instance "gnnt", status UNKNOWN, has 1 handler(s) for this service...
Instance "gnnt", status READY, has 1 handler(s) for this service...
Service "gnntXDB" has 1 instance(s).
Instance "gnnt", status READY, has 1 handler(s) for this service...
The command completed successfully
?
?
第四步:添加自动删除日志文件脚本
[root@db ~]#su - oracle
[oracle@db]$cp /media/linux/deletearchivelogs.sh /media/linux/rman_cmd /home/oracle #/media/linux/代表U盘中的目录，粘贴的位置为/home/oracle
[oracle@db]$chmod +x /home/oracle/deletearchivelogs.sh
#给deletearchivelogs.sh文件添加可执行权限
[oracle@db]$ ll /home/oracle
总用量 8
-rwxr-xr-x 1 root root 439 11月 18 16:44 deletearchivelogs.sh
-rwxr-xr-x 1 root root 118 11月 18 16:44 rman_cmd
[oracle@db]$vim /home/oracle/deletearchivelogs.sh #修改IP地址为本地IP地址
/sbin/ip add show dev bond0 | grep -iq '172.16.2.20'
[oracle@db ~]#crontab -e
#添加自动删除日志脚本，如果出现计划任务无法保存时，则说明时间不同步，只需同步时间即可
0 5 * * * /home/oracle/deletearchivelogs.sh > /dev/null 2>&1
[root@db home]# crontab -l #查看计划执行任务
0 5 * * * /home/oracle/deletearchivelogs.sh > /dev/null 2>&1
?
?
?
[root@db ~]# su - oracle ? ? ? ? ? ? ? ? ? ? ? #切换到oracle用户
[oracle@db ~]$ sqlplus / ?as sysdba ? ? ? ? ? ? ? #进入oracle
数据库
SQL > shutdown ?immediate； ? ? ? ? ? ? ? ? ? ?#关闭数据库
Database closed.
Database dismounted.
ORACLE instance shut down.
?
补充：
?
1、使用history查看之前所使用过的命令。
?
2、如果发现数据库每隔一段时间就会重启，这时候只需要关掉bmc-watchdog服务器
[root@localhost ~]#chkconfig ?bmc-watcgdog off