oracle账号创建与管理员权限ora 12514 tns监听程序当前无法识别

找到一个文本文件:

E:\oracle\NETWORK\ADMIN\listener.ora 还一个在同路径下的tnsnames.ora文件(这是我自己的安装路径)

打开listener.ora:

# listener.ora Network Configuration File: E:\oracle\NETWORK\ADMIN\listener.ora# Generated by Oracle configuration tools.SID_LISToracle账号_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = PLSExtProc)(ORACLE_HOME = E:\oracle)(PROGRAM = extproc))(SID_DESC =(GLOBAL_DBNAME = orcl)(ORACLE_HOME = E:\oracle)(SID_NAME = orcl)))LISTENER =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)))

标红的是我新加的,然后重启oracle服务就行了。
 

此条目发表在oracle metalink账号分类目录,贴了标签。将固定链接加入收藏夹。