1.先检查Oracle实例是否启动:
启动实例:
net start oracleserviceorcl
2.然后启动监听:
lsnrctl start
成功启动后,查看监听了几个实例:
lsnrctl status
如果oracle提示ERROR - ORA-12541: TNS:无监听程序。
查看\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora文件,用记事本打开,显示oracle值:
ORACLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =数据库IP地址)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle)
)
)