你如果在本机安装并登录,服务品名不要输入。(数据库会默认的)
查看:listener.ora(去掉多余的条目,并且改PROTOCOL 为TCP)
# LISTENER.ORA Network Configuration File: D:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yang)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Oracle\Ora81)
(PROGRAM = extproc)
)
)
查看:listener.ora(去掉多余的条目,并且改PROTOCOL 为TCP)
# LISTENER.ORA Network Configuration File: D:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = yang)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Oracle\Ora81)
(PROGRAM = extproc)
)
)
properly in the registry.
If you are using terminal services client to login to
a remote server, You will get this error. You can't
terminal service client to use server level utilities
like svrmgrl, rman etc... Please do this on the
server.Hope this helps
我的oracle,是在本机安装的,主要用来学习之用
楼上所说的TNS服务在哪里启动?
LSNRCTL>START
可是问题依旧
又会出现ORA-12514:TNS:监听进程不能解析在连接描述符中给出的SERVICE_Name
Ohal_com是我在装Oracle时提示命名的。并且也用这个进行了 本地网络服务名配置
可是测试不成功,出现的错误提示跟上面所写的一样
真是伤脑筋
???
在命令行可以这样启动oradim -startup -sid 实例名。
如果上述服务启动了,还是有协议适配器错的话,看看注册表里有没有设置oracle_sid,它的位置与oracle_home、oracle_base等在一起,如果设置了,看看是不是与要用的实例名一致。