ORACLE 10g手动配置监听
listener.ora的位置在 $ORACLE_HOME/network/admin/samples通过samples老listener.ora里的数据进行修改原始代码：LISTENER =#(ADDRESS_LIST=# (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))# (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))SID_LIST_LISTENER=# (SID_LIST=# (SID_DESC=# #BEQUEATH CONFIG# (GLOBAL_DBNAME=salesdb.mycompany)# (SID_NAME=sid1)# (ORACLE_HOME=/private/app/oracle/product/8.0.3)# #PRESPAWN CONFIG# (PRESPAWN_MAX=20)# (PRESPAWN_LIST=# (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))# )# )# )修改为：LISTENER =(ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.10.11)(PORT=1521)))SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (GLOBAL_DBNAME=shiyue) (ORACLE_HOME=/u01/app/oracle/product/10.2/db_1/) (SID_NAME=shiyue) ))在$ORACLE_HOME/network/admin目录下新建监听文件$vi listener.ora,把修改后的监听文件放进去保存退出后通过$lsnrctl start 来启动监听lsnrctl stop 关闭监听lsnrctl status查看监听状态
页:
[1]