配置和自动启动Oracle的数据库和监听(lsnrctl)1.设置主机名称[root@myc ~]# cat /etc/sysconfig/networkNETWORKING=yesHOSTNAME=myc2.设置主机名称与IP地址的对应[root@myc ~]# cat /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 localhost localhost.localdomain localhost6 localhost6.localdomain6192.168.2.16 myc3.修改:/u01/app/oracle/network/admin/listener.ora[oracle@myc admin]$ cat listener.ora# listener.ora Network Configuration File: /u01/app/oracle/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = myc)(PORT = 1521))))ADR_BASE_LISTENER = /u01/app4.修改:/u01/app/oracle/network/admin/tnsnames.ora[oracle@myc admin]$ cat tnsnames.ora# tnsnames.ora Network Configuration File: /u01/app/oracle/network/admin/tnsnames.ora # Generated by Oracle configuration tools.ORCL =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = myc)))5.lsnrctl 的常用方法[oracle@myc admin]$ lsnrctlLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 29-NOV-2013 21:56:57Copyright (c) 1991, 2011, Oracle. All rights reserved.Welcome to LSNRCTL, type "help" for information.LSNRCTL> helpThe following operations are availableAn asterisk (*) denotes a modifier or extended command:start stop statusservices version reloadsave_config trace spawnchange_password quit exitset* show*lsnrctl start -- 启动监听lsnrctl stop -- 停止监听lsnrctl status -- 查看状态6.设置Oracle数据库和lsnrct自动启动方法(机器是RedHat6_64,Oracle11g)6.1.编辑: /etc/oratab[root@myc ~]# cat /etc/oratab# This file is used by ORACLE utilities. It is created by root.sh# and updated by either Database Configuration Assistant while creating# a database or ASM Configuration Assistant while creating ASM instance.# A colon, ':', is used as the field terminator. A new line terminates# the entry. Lines beginning with a pound sign, '#', are comments.## Entries are of the form:# $ORACLE_SID:$ORACLE_HOME:<N|Y>:## The first and second fields are the system identifier and home# directory of the database respectively. The third filed indicates# to the dbstart utility that the database should , "Y", or should not,# "N", be brought up at system boot time.## Multiple entries with the same $ORACLE_SID are not allowed.###orcl:/u01/app/oracle:Norcl:/u01/app/oracle:Y #这里把"N"改为"Y"6.2.修改/etc/rc.local[root@myc ~]# cat /etc/rc.local#!/bin/sh## This script will be executed *after* all the other init scripts.# You can put your own initialization stuff in here if you don't# want to do the full Sys V style init stuff.touch /var/lock/subsys/local# 添加下面两条su - oracle -c 'dbstart'su - oracle -c 'lsnrctl start'#如果有安装gateway在增加下面一条su – gtway –c ‘lsnrctl start’6.3.重新启动系统.Oracle数据库正常启动.监听也启动了.[oracle@myc ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 29 21:49:56 2013Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select status from v$instance;STATUS------------OPEN[oracle@myc ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.3.0 - Production on 29-NOV-2013 22:03:23 Copyright (c) 1991, 2011, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myc)(PORT=1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.3.0 - ProductionStart Date 29-NOV-2013 21:25:24Uptime 0 days 0 hr. 37 min. 59 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /u01/app/oracle/network/admin/listener.oraListener Log File /u01/app/diag/tnslsnr/myc/listener/alert/log.xmlListening Endpoints Summary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myc)(PORT=1521)))Services Summary...Service "orcl" has 1 instance(s).Instance "orcl", status READY, has 1 handler(s) for this service...Service "orclXDB" has 1 instance(s).Instance "orcl", status READY, has 1 handler(s) for this service...The command completed successfully其它问题:关闭linux防火墙:暂时关闭:service iptables stop永久性,需重启:chkconfig iptables off[root@myc ~]# chkconfig --list | grep iptablesiptables 0:off 1:off 2:on 3:on 4:on 5:on 6:off [root@myc ~]# chkconfig iptables off[root@myc ~]# chkconfig --list | grep iptablesiptables 0:off 1:off 2:off 3:off 4:off 5:off 6:off关闭selinux:1 永久方法–需要重启服务器修改/etc/selinux/config文件中设置SELINUX=disabled ，然后重启服务器。