2023年8月1日发(作者：)
Linuxora-12514多实例,ORA-12514问题解决版本：11.2.0.1.0 - 64bit本机安装Oracle后链接测试发现以下情况：sqlplus scott/tiger 正常登陆sqlplus scott/tiger@orcl 登陆失败，提⽰ORA-12514错误，应该是⽆法识别服务名ORCL为此查阅资料，找到以下解决⽅案：-------------------------------------------------------------------找到oracle安装⽬录下listener⽂件：原⽂件如下：SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = CLRExtProc)(ORACLE_HOME = d:appAdministratorproduct11.2.0dbhome_1)(PROGRAM = extproc)(ENVS = "EXTPROC_DLLS=ONLY:d:appAdministratorproduct11.2.0dbhome_")))LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))(ADDRESS = (PROTOCOL = TCP)(HOST = idylan)(PORT = 1521))))ADR_BASE_LISTENER = d:appAdministrator修改后如下：SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = CLRExtProc)(ORACLE_HOME = d:appAdministratorproduct11.2.0dbhome_1)(PROGRAM = extproc)(ENVS = "EXTPROC_DLLS=ONLY:d:appAdministratorproduct11.2.0dbhome_"))(SID_DESC =(GLOBAL_DBNAME = ORCL)(ORACLE_HOME = d:appAdministratorproduct11.2.0dbhome_1)(SID_NAME = ORCL)))LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))(ADDRESS = (PROTOCOL = TCP)(HOST = idylan)(PORT = 1521))))ADR_BASE_LISTENER = d:appAdministrator保存，后sqlplus scott/tiger@orcl 可正常登陆。--------------------------dylan presents.相关阅读：
2023年8月1日发(作者：)
Linuxora-12514多实例,ORA-12514问题解决版本：11.2.0.1.0 - 64bit本机安装Oracle后链接测试发现以下情况：sqlplus scott/tiger 正常登陆sqlplus scott/tiger@orcl 登陆失败，提⽰ORA-12514错误，应该是⽆法识别服务名ORCL为此查阅资料，找到以下解决⽅案：-------------------------------------------------------------------找到oracle安装⽬录下listener⽂件：原⽂件如下：SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = CLRExtProc)(ORACLE_HOME = d:appAdministratorproduct11.2.0dbhome_1)(PROGRAM = extproc)(ENVS = "EXTPROC_DLLS=ONLY:d:appAdministratorproduct11.2.0dbhome_")))LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))(ADDRESS = (PROTOCOL = TCP)(HOST = idylan)(PORT = 1521))))ADR_BASE_LISTENER = d:appAdministrator修改后如下：SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = CLRExtProc)(ORACLE_HOME = d:appAdministratorproduct11.2.0dbhome_1)(PROGRAM = extproc)(ENVS = "EXTPROC_DLLS=ONLY:d:appAdministratorproduct11.2.0dbhome_"))(SID_DESC =(GLOBAL_DBNAME = ORCL)(ORACLE_HOME = d:appAdministratorproduct11.2.0dbhome_1)(SID_NAME = ORCL)))LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))(ADDRESS = (PROTOCOL = TCP)(HOST = idylan)(PORT = 1521))))ADR_BASE_LISTENER = d:appAdministrator保存，后sqlplus scott/tiger@orcl 可正常登陆。--------------------------dylan presents.相关阅读：
发布评论