配置和自动启动Oracle的数据库和监听.docxVIP

配置和自动启动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]$ lsnrctl LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 29-NOV-2013 21:56:57 Copyright (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