最近重新安装数据库后一直报一个错误，ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

现在终于解决了，现在把经验记录如下：

首先查看tnsnames.ora和listener.ora文件是否有问题。路径如下：

(路径：D:\app\MYE\product\11.2.0\dbhome_1\NETWORK\ADMIN)每个人的路径可能不一样，具体看你安装ORACLE的路径。

把这两个文件中的内容修改成如下内容：

注：下面红色字体标注的要改成自己数据库的名字或者路径

tnsnames.ora中：

# tnsnames.ora Network Configuration File:

D:\app\MYE\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora

# Generated by Oracle configuration tools.

ORACLR_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC1521))

)

(CONNECT_DATA =

(SID = CLRExtProc)

(PRESENTATION = RO)

)

)

SYS =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))

)

(CONNECT_DATA =

(SID = sys)

(SERVER = DEDICATED)

)

)

LISTENER_SYS =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

listener.ora中内容如下：

# listener.ora Network Configuration File:

D:\app\MYE\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =