Oracle 安装记录

?今天安装Oracle,出现个问题，在此做个笔记。

ora-12514 这个问题很常见。主要是IP的问题。

?

网上一搜，找到答案，需要加一段。

?

listener.ora

?

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.DOONE =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = doone)    )  )EXTPROC_CONNECTION_DATA =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))    )    (CONNECT_DATA =      (SID = PLSExtProc)      (PRESENTATION = RO)    )  )

?

?

?

这里主要的改动是将 计算机名改为了localhost

同时在listener.ora上加了一段
??? (SID_DESC =
????? (GLOBAL_DBNAME = doone)
????? (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)?
????? (SID_NAME = doone)
??? )

?

?

遇到过好几次，下次再碰到这个问题，应该不用再费力找了。