# Copyright (c) 1993-1999 Microsoft Corp. # # This is a sample HOSTS file used by Microsoft TCP/IP for Windows. # # This file contains the mappings of IP addresses to host names. Each # entry should be kept on an individual line. The IP address should # be placed in the first column followed by the corresponding host name. # The IP address and the host name should be separated by at least one # space. # # Additionally, comments (such as these) may be inserted on individual # lines or following the machine name denoted by a '#' symbol. # # For example: # # 102.54.94.97 rhino.acme.com # source server # 38.25.63.10 x.acme.com # x client host127.0.0.1 localhost 这里面没有USER-CF7323440B对应的ip啊
检查LISTENER.ORA文件中的HOST地址是否是IP而不是本机机器名,修改IP为当前IP或者修改成机器名;
重启数据库
sqlplus /nolog
conn /as sysdba
startup
把所有提示贴出来
ORA-12560: TNS:protocol adapter error
修改 HOST = 机器名
保存,重启数据库
# Generated by Oracle configuration tools.LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = USER-CF7323440B)(PORT = 1521))
)
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\ora90)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORA)
(ORACLE_HOME = d:\oracle\ora90)
(SID_NAME = ORA)
)
)
现在的HOST就是机器的主机名
# TNSNAMES.ORA Network Configuration File: d:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = USER-CF7323440B)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)ORA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = USER-CF7323440B)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORA)
)
)大家帮改下
把USER-CF7323440B对应的ip改为现在IP
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host127.0.0.1 localhost
这里面没有USER-CF7323440B对应的ip啊
检查LISTENER.ORA文件中的HOST地址是否是IP而不是本机机器名,修改IP为当前IP或者修改成机器名;
重启数据库
其实机器名还是会变成IP地址来运行的!
如果服务器在本机把连接改成新ip,或者根本不用改,要具体看你怎么配的.
如果服务器在别的机器上,可能是新宿舍和原来服务器之间的端口被封了.
把报错信息贴出来看看吧.
sys可以登录,system也可以吧?换IP为原来的也不行吗?
登录成功,不能做任何操作的话,看看错误提示,在摆渡里搜搜这样的错误是什么原因。
实在不行,重装oracle了