oracle10.2安装在win2003server上,一直能正常使用,以前也能备份正常。
在备份前oracle四个主要服务都已经启动成功。
使用lsnrctl status 查看都提示正常。备份语句:exp jxh3/jxh@easdb owner=jxh3 file=E:\ncdatabak\jxh3data.dmp log=E:\ncdatabak\jxh3.log full=y
执行后提示:
Export: Release 10.2.0.1.0 - Production on Mon Mar 5 20:22:12 2012Copyright (c) 1982, 2005, Oracle Corporation. All rights reserved.EXP-00056: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve service name
EXP-00000: Export terminated unsuccessfully
查看网上相关提示错误信息均不知如何解决,以下是一些相关文件,请各位帮看一下何原因???# tnsnames.ora Network Configuration File: d:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.EASDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ibmserver2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = easdb)
)
)====================================================================# listener.ora Network Configuration File: d:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ibmserver2)(PORT = 1521))=====================================================================
#sqlnet.ora
# 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)============================================================
在备份前oracle四个主要服务都已经启动成功。
使用lsnrctl status 查看都提示正常。备份语句:exp jxh3/jxh@easdb owner=jxh3 file=E:\ncdatabak\jxh3data.dmp log=E:\ncdatabak\jxh3.log full=y
执行后提示:
Export: Release 10.2.0.1.0 - Production on Mon Mar 5 20:22:12 2012Copyright (c) 1982, 2005, Oracle Corporation. All rights reserved.EXP-00056: ORACLE error 12154 encountered
ORA-12154: TNS:could not resolve service name
EXP-00000: Export terminated unsuccessfully
查看网上相关提示错误信息均不知如何解决,以下是一些相关文件,请各位帮看一下何原因???# tnsnames.ora Network Configuration File: d:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.EASDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ibmserver2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = easdb)
)
)====================================================================# listener.ora Network Configuration File: d:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ibmserver2)(PORT = 1521))=====================================================================
#sqlnet.ora
# 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)============================================================
解决方案 »
- 现在求助 ORA-01461: can bind a LONG value only for insert into a LONG column
- ORACLE 时间修约的问题 急!!!
- 在sqlplusw中随便乱写select * from **** 返回结果:2 无论select什么结果都是2..... 即使不存的表也是
- long raw 字段中数据的大小
- 各位大神,60分求助.安装oracle时,为什么主机名不能为汉字,有解决办法吗?谢谢!
- linux 下 oracle安装运行后登陆问题
- Net easy config 配置问题错误
- 异常处理问题
- 怎么把blob格式的图片转换成long raw格式的?
- 求助 oracle 主键冲突的检测效的问题
- oracle主键自增问题
- csdn的大侠们,帮忙看看,在线等~
SQL> show parameter service2.检查环境变量ORACLE_HOME和TNS_ADMIN是否指向正确的目录(如果又安装了新的ORACLE软件,这些环境变量会发生改变)。
主机名未修改过,查主机名确实就是:ibmserver2
我在d:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
中修改HOST = ibmserver2 为HOST = ibmserver2 的IP备份还是出现同样问题。