修改监听文件listener.oraLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zhaoxl)(PORT = 1521))
)
)
)
修改HOST 的为你的主机名
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = zhaoxl)(PORT = 1521))
)
)
)
修改HOST 的为你的主机名
重新启动
startup nomount....,若出错贴出错误代码
create spfile from pfile
alter database open
修改为 : Orcl.XXX.com(按域名后缀添加)Host修改为:机器名listener.oraHost修改为:机器名重起机器;使用sysdba身份登陆
startup mount
create spfile from pfile
alter database open修改spfile,并通过其引导数据库启动