Oracle-数据库报错-ORA-12514解决办法

如果orale数据库报ORA-12514无监听程序错误就要listener.ora和tnsnames.ora文件修改一下如果在本机上那么listener.ora将改为#listener.oraNetworkConfigurationFile:d:\oracle\product\10.2.0\db_1\network\admin\listener.ora#GeneratedbyOracleconfigurationtools.SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=PLSExtProc)(ORACLE_HOME=d:\oracle\product\10.2.0\db_1)(PROGRAM=extproc)))LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))(ADDRESS=(PROTOCOL=TCP)(HOST=CF.CaoFei)(PORT=1521))))tnsnames.ora将该为：#tnsnames.oraNetworkConfigurationFile:d:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora#GeneratedbyOracleconfigurationtools.ORCL=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=CF.CaoFei)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))EXTPROC_CONNECTION_DATA=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))(CONNECT_DATA=(SID=PLSExtProc)(PRESENTATION=RO)))如果是远程访问那么就要在本机的客户端将这两个文件中本机的主机名修改成远程数据库服务器的IP就行了