ora-12154问题怎么解决

ora-12154问题怎么解决

你的配置有问题。检查listener.ora和tnsnames.ora配置：示例如下：listener.oraSID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = PLSExtProc)(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)(PROGRAM = extproc))(SID_DESC =(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)(SID_NAME = orcl(修改为实例名))))LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1(修改为主机IP地址或主机名))(PORT = 1521))))tnsnames.oramyORCL=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1(修改为主机IP地址或主机名))(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl（修改为实例名）)))配置好后tnsping myORCL 看通不通。登陆格式为 sqlplus username/password@myORCL myORCL为tnsnames.ora中配置的名称，名称可以随便取，不一定要与实例名一样，不是实例名,注意区别。 开启监听服务：lsnrctl start