开发学院数据库Oracle 连接数据库报错ORA-12514 阅读

连接数据库报错ORA-12514

 2008-09-19 12:55:42 来源:WEB开发网   
核心提示:连接时报错: [oracle@yangtk2~]$lsnrctlstatusLSNRCTLforLinux:Version11.1.0.6.0-Productionon01-SEP-200817:36:03Copyright(c)1991,2007,Oracle.Allrightsreserved.Connecting

连接时报错:  

   [oracle@yangtk2~]$lsnrctlstatus
  LSNRCTLforLinux:Version11.1.0.6.0-Productionon01-SEP-200817:36:03
  Copyright(c)1991,2007,Oracle.Allrightsreserved.
  Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
  STATUSoftheLISTENER
  ------------------------
  AliasLISTENER
  VersionTNSLSNRforLinux:Version11.1.0.6.0-Production
  StartDate01-SEP-200817:01:31
  Uptime0days0hr.34min.32sec
  TraceLeveloff
  SecurityON:LocalOSAuthentication
  SNMPOFF
  ListenerParameterFile/data/oracle/product/11.1/network/admin/listener.ora
  ListenerLogFile/data/oracle/diag/tnslsnr/yangtk2/listener/alert/log.xml
  ListeningEndpointsSummary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.25.1.104)(PORT=1521)))
  Thelistenersupportsnoservices
  Thecommandcompletedsuccessfully

检查listener.ora和tnsnames.ora都未发现异常:  

   [oracle@yangtk2admin]$morelistener.ora
  #listener.oraNetworkConfigurationFile:/data/oracle/product/11.1/network/admin/listener.ora
  #GeneratedbyOracleconfigurationtools.
  LISTENER=
  (DESCRIPTION_LIST=
  (DESCRIPTION=
  (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))
  (ADDRESS=(PROTOCOL=TCP)(HOST=192.25.1.104)(PORT=1521))
  )
  )
  [oracle@yangtk2admin]$moretnsnames.ora
  #tnsnames.oraNetworkConfigurationFile:/data/oracle/product/11.1/network/admin/tnsnames.ora
  #GeneratedbyOracleconfigurationtools.
  ORA11G_S=
  (DESCRIPTION=
  (ADDRESS=(PROTOCOL=TCP)(HOST=192.25.1.104)(PORT=1521))
  (CONNECT_DATA=
  (SERVER=DEDICATED)
  (SERVICE_NAME=ora11g_s.ytk-thinkpad)
  )
  )
  ORA11G_P=
  (DESCRIPTION=
  (ADDRESS=(PROTOCOL=TCP)(HOST=192.25.1.102)(PORT=1521))
  (CONNECT_DATA=
  (SERVER=DEDICATED)
  (SERVICE_NAME=ora11g_p.ytk-thinkpad)
  )
  )

1 2 3  下一页

Tags:连接 数据库 ORA

编辑录入:爽爽 [复制链接] [打 印]
[]
  • 好
  • 好的评价 如果觉得好,就请您
      0%(0)
  • 差
  • 差的评价 如果觉得差,就请您
      0%(0)
更多精彩
    赞助商链接

    热点阅读
      焦点图片
        最新推荐
          精彩阅读