Oracle配置监听

1、修改listener.ora

cd $ORACLE_HOME
cd network/admin

vi listener.ora

　　修改为以下内容：

SID_LIST_LISTENER =
  (SID_LIST = 
     (SID_DESC = 
        (GLOBAL_DBNAME = orcl)
        (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
        (SID_NAME = orcl)
     )
  )

LISTENER =
   (DESCRIPTION = 
      (ADDRESS = 
         (PROTOCOL = TCP)
	 (HOST = 192.168.1.135) 
	 (PORT = 1521)
      )
    )
ADR_BASE_LISTENER = /u01/app/oracle

　2、修改tnsname.ora

orcl = 
(DESCRIPTION = 
(ADDRESS_LIST = 
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.135)(PORT = 1521))
)
(CONNECT_DATA = 
(SID = orcl)
)
)