ORA-12514: Message 12514 not found;product=RDBMS80;facility=ORA
You cannot connect to the server instance from any tool.Tnsnames.ora seems to be incorrect. Solution Description: ===================== Look at the connect string in the tnsnames.ora file that OEM 2.0.4 is using. The "CONNECT_DATA" parameter uses "SERVICE_NAME" not "SID". You need to change the SERVICE_NAME to SID. Solution Explanation: =====================
The tnsnames.ora is using the SERVICE_NAME instead of SID. This is an 815 sqlnet parameter and the OEM 2.0.4 is based off of Oracle 8.0.4. The 8.0.4 uses SID in tnsnames.
You cannot connect to the server instance from any tool.Tnsnames.ora seems to be incorrect.
Solution Description:
=====================
Look at the connect string in the tnsnames.ora file that OEM 2.0.4 is using.
The "CONNECT_DATA" parameter uses "SERVICE_NAME" not "SID". You need to change the SERVICE_NAME to SID.
Solution Explanation:
=====================
The tnsnames.ora is using the SERVICE_NAME instead of SID. This is an
815 sqlnet parameter and the OEM 2.0.4 is based off of Oracle 8.0.4.
The 8.0.4 uses SID in tnsnames.
# Generated by Oracle configuration tools.EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
NET8配置全过程:
1.在'新的网络服务名'里随便填一个名字
2.一直点"下一步"
3."主机名"填你的服务器名字或它的ip地址
4."服务名"填 你要联的数据库名.域名
5.测试一下,出现成功信息就行了
在tnsnames.ora文件里加上
MYCON=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 服务器主机名)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = 服务器上的数据库服务名)
)
)然后用SQL*PLUS连接,第三项选MYCON
例如:
v1 = --客户端连接数据库的连接字符串
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(Host = 140.100.101.1) --服务器IP
(Port = 1521)
)
(CONNECT_DATA = (SID = orcl) --服务器SID
)
)
把它考过去,改一下。就可了
# LISTENER.ORA Network Configuration File: E:\Oracle\iSuites\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xiaopan)(PORT = 1580))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xiaopan)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xiaopan)(PORT = 2481))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\Oracle\iSuites)
(PROGRAM = extproc)
)
)
可还是原来的错呀
配置好后
打开sql*plus,在主机字符串中输入刚配置好的连接字符串名就可以了
ERROR:ORA-12154: TNS: 无法处理服务名
这个错误呀
测试未成功。您提供的一些信息可能不正确。
请按 "后退" 来检查提供的网络服务名的信息,或按"更改登录"来更改用户名。
如果创建了数据库就应该通过Net8 assistent来配置你的服务器名.还有用intenal/oracle这个用户名和密码登录试试.