3358 www.Sina.com/f :appmaozbproduct11.2.0db home _1 networkadmin listener.ora
2. 1. 找到listener.ora监听文件,具体位置:
在lisener.ora文件中添加下方加粗部分:
# listener.oranetworkconfigurationfile : f :appmaozbproduct11.2.0db home _1network admi
# generatedbyoracleconfigurationtools。
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=CLRExtProc )
(Oracle _ home=f :appmaozbproduct11.2.0db home _1)
(PROGRAM=extproc )
(envs=' ext proc _ dlls=only : f :appmaozbproduct11.2.0db home _1 bin oraclr 11.dll )
) )
=================================================================================
(SID_DESC =
(GLOBAL_DBNAME = NC633)
(ORACLE_HOME =F:appmaozbproduct11.2.0dbhome_1)
(SID_NAME = NC633)
) )
监听器=
(DESCRIPTION_LIST=
(DESCRIPTION=
(address=(protocol=IPC ) (KEY=EXTPROC1521 ) )
(address=(protocol=TCP ) (HOST=localhost ) (PORT=1521 ) )
) )
) )
ADR _ base _ listener=f :appmaozb
)
=================================================================================
2.相同目录下tnsnames.ora文件内容如下,参考使用。
# tnsnames.oranetworkconfigurationfile : f :appmaozbproduct11.2.0db home _1network admi
# generatedbyoracleconfigurationtools。
ORACLR_CONNECTION_DATA=
(DESCRIPTION=
(ADDRESS_LIST=
(address=(protocol=IPC ) (KEY=EXTPROC1521 ) )
) )
(CONNECT_DATA=
(SID=CLRExtProc )
(PRESENTATION=RO )
) )
) )
(DESCRIPTION=
(ADDRESS_LIST=
(address=(protocol=TCP ) (HOST=localhost ) (PORT=1521 ) )
) )
(CONNECT_DATA=
(服务器=dedicated )
(SERVICE_NAME=nc633 )
) )
) )
) )
=================================================================================
=================================================================================
1 )首先停止拦截,然后停止实例。
2 )先立实例,后拦截。