17,377
社区成员
发帖
与我相关
我的任务
分享
# listener.ora Network Configuration File: D:\Tools--Instal\ORACLE\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Tools--Instal\ORACLE)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
# listener.ora Network Configuration File: D:\Tools--Instal\ORACLE\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Tools--Instal\ORACLE)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = D:\Tools--Instal\ORACLE)
(SID_NAME = ORCL)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
注意:里面的空格什么的也尽量都一样,我曾经把添加的那行的前面的空格去掉了,oracle的监听的服务就启动不了。
然后,再用cmd----sqlplus---sys as sysdba---pwd登录后,会提示:已连接到空闲例程。
现在的原因,就是5楼说的,数据库没有启动。
而,我用startup启动数据库时,会报错6楼的错误。
此时,依照上面的文章说的解决方法,在D:\Tools--Instal文件夹中添加了flash_recovery_area文件夹。然后再启动数据库就可以了。。。
总结:
1.修改linstener.ora文件。
2.启动oracle的相关服务。
3.startup数据库,如果再报错,可以查找安装文件夹下面是否还有flash_recovery_area文件夹。# listener.ora Network Configuration File: D:\Tools--Instal\ORACLE\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Tools--Instal\ORACLE)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D:\Tools--Instal\ORACLE)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)