1.链接
（
1.sqlplus /nolog
2.conn sys/sys@172.16.17.36/orcl as sysdba
）
2.sid 数据库名称 ----如：orcl
1.监听程序中的修改
D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) )
(SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1) (SID_NAME = ORCL) )
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-C69919CK6C6)(PORT = 1521)) ) )
ADR_BASE_LISTENER = D:\app\Administrator
2.服务开启
2.注册表
转载于:https://www.cnblogs.com/leolzi/p/9492124.html
