ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor
这个错误怎么解决阿?我本地连接pl/sql不行哦。
配置文件如下:请大侠帮忙看一下:tnsnames.ora文件:# TNSNAMES.ORA Network Configuration File: E:\oracle9i\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.ORAPOP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORAPOP)
)
)
-----------------------------------------------------------------------------sqlnet.ora文件:# SQLNET.ORA Network Configuration File: E:\oracle9i\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES,HOSTNAME,ONAMES)------------------------------------------------------------------------------
listener.ora文件# LISTENER.ORA Network Configuration File: E:\oracle9i\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
descriptor
这个错误怎么解决阿?我本地连接pl/sql不行哦。
配置文件如下:请大侠帮忙看一下:tnsnames.ora文件:# TNSNAMES.ORA Network Configuration File: E:\oracle9i\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.ORAPOP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORAPOP)
)
)
-----------------------------------------------------------------------------sqlnet.ora文件:# SQLNET.ORA Network Configuration File: E:\oracle9i\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES,HOSTNAME,ONAMES)------------------------------------------------------------------------------
listener.ora文件# LISTENER.ORA Network Configuration File: E:\oracle9i\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
These programs locks some ports and this could be the cause.
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Ora10g)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = test)
(ORACLE_HOME = D:\Ora10g)
)
)Add the entry
(SID_DESC =
(SID_NAME = test)
(ORACLE_HOME = D:\Ora10g)
)
with regard to the particular Oracle Home and SID Name.Restart the listener:
c:>lsnrctl stop
c:>lsnctl start
ORA-27101: shared memory realm does not exist 这个错误有点怪,以前可以用的,由于把用户的DBA权限去掉了,重启电脑 后来就报这种错误解决方案:ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist在CMD中输入以下内容,1,c:> ;sqlplus /nolog2,Sql> connect jjt【用户名】/jjt【密码】@orapop【实例名】 as sysdba
3,SQL> startup 以上内容执行后可以链接上,但是重启了电脑后,又会出现统一的问题。。