初学web用到oracle,一直在用,没出现什么问题,今天数据库该启动的都启动后,打开pl/sql,报ORA-01034:ORACLE不可用。
用cmd打开,输入sqlplus/nolog之后再输入conn system/orcl回车后出现ERROR:ORA-12560:TNS:协议适配器错误
我主机名称:2012-0619-1812
我listener.ora里面内容是:
# listener.ora Network Configuration File: G:\app\Administrator\product\11.1.0\db_2\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = myoracle)
(SID_NAME = myoracle)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 2012-0619-1812)(PORT = 1521))
)我tnsnames.ora文件里内容为:
# tnsnames.ora Network Configuration File: G:\app\Administrator\product\11.1.0\db_2\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.MYORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 2012-0619-1812)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = myoracle)
)
)
我sqlnet.org文件内容是:
# sqlnet.ora Network Configuration File: G:\app\Administrator\product\11.1.0\db_2\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)我网络适配器没什么错误怎么还报这种错呢,改怎么解决才能打开数据库
用cmd打开,输入sqlplus/nolog之后再输入conn system/orcl回车后出现ERROR:ORA-12560:TNS:协议适配器错误
我主机名称:2012-0619-1812
我listener.ora里面内容是:
# listener.ora Network Configuration File: G:\app\Administrator\product\11.1.0\db_2\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = myoracle)
(SID_NAME = myoracle)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 2012-0619-1812)(PORT = 1521))
)我tnsnames.ora文件里内容为:
# tnsnames.ora Network Configuration File: G:\app\Administrator\product\11.1.0\db_2\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.MYORACLE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 2012-0619-1812)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = myoracle)
)
)
我sqlnet.org文件内容是:
# sqlnet.ora Network Configuration File: G:\app\Administrator\product\11.1.0\db_2\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)我网络适配器没什么错误怎么还报这种错呢,改怎么解决才能打开数据库
解决方案 »
- 着急,oracle表空间增加数据文件的问题?
- 求救!!dblink 问题,请帮帮我
- Oracle存储过程问题:创建临时表(带一个输入参数)出错。
- 为什么oracle 10G以后数据库文件不能够装在同一目录下?
- 如何直接将excle中的数据导入oracle中,怎样导出到excle中?
- ORACLE9里有 Quest SQL Navigator吗??
- 对于几十万条记录的表,如何解决效率问题
- oracle 问题,在线等。
- 请教高手:实现一个从3300万记录中汇总排序查询,需把sort_area_size设置为多大合适?能否超过shared_pool_size?这有什么规定?(急!!
- 如何提高查询速度
- 问一个sql排序问题,有空的进来看看
- 求助!informix 与 oracle 日期差异
如果都起来了,
启动cmd后,先执行
set ORACLE_SID=myoracle
然后再启动SQLPLUS.
只有这两个原因。。