SID given in connect descriptor could not be resolved! [oracle@server2 oracle]$ sqlplus /nolog SQL*Plus: Release 9.2.0.4.0 - Production on Fri Aug 12 11:24:17 2005 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL>; connect / as sysdba SQL>; startup ORA-01081: cannot start already-running ORACLE - shut it down first SQL>; exit Disconnected from Oracle9i Enterprise Edition...
by yuandanyi - Oracle - 2005-08-12 13:41:40 阅读(755) 回复(2)
在程序中访问数据库,该程序和oracle数据库在同一台主机(服务器)上,但是,运行程序时,报错:ORA-12154: TNS:could not resolve the connect identifier specified oracle数据库服务器端: # listener.ora Network Configuration File: /opt/app/oracle/product/10.2.0/db_1/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = loca...
环境redhat 5.0 安装了oracle 10g,安装完成后,sqlplus /nolog ,出现sql 〉,用conn sys/sys@orc 1 as sysdba ,则会出现ORA-12154: TNS:could not resolve the connect identifier specified,请问是什么原因,应该如何解决,急!希望大家帮帮忙!
系统是RHEL 4,sqlplus登录则会出现ORA-12154: TNS:could not resolve the connect identifier specified错误提示 tnsnames.ora,sqlnet.ora内容如下,新手,请大家帮忙 # tnsnames.ora Network Configuration File: /md/app/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. EXERCISE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xqh)(PORT = 1521)) ...
when i install phpBB,it complain: phpBB : Critical Error could not connect to the database but i can use ./mysql -uroot -p123456 to connetc my mysql in command line... do i need some configuration modified in php.ini or somthing else? thanks!
我用secure CRT登陆到指定的LINUX 9I服务器上
进行PROC 编程,当我程序:
[code]
#include
我在windows下可以连,没有问题!而在linux下本机连的时间出现错误 ORA-12154: TNS:could not resolve service name 再RHORA*ORA-/opt/oracle/product/9.2.0/network/admin>tnsping ora TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 16-NOV-2006 11:10:56 Copyright (c) 1997 Oracle Corporation. All rights reserved. Used parameter files: Used TNSNAMES adapter to resolve the alias )connect_DATA ...
我在服务器A的数据库创建一个连接到服务器B的数据库。 create database link B connect to "user" identified by "password" using 'B' 创建成功之后,在服务器A上的数据库查询服务器B上数据库的表 select * from table@B 提示ORA-12154: TNS:could not resolve service name 我已经在服务器A上配置tnsnames.ora文件,所以用sqlplus登陆服务器B上的数据库是成功的。但如果是在登陆了服务器A上的数据库,再从这个数据库查询服务器...
我在linux下成功安装好oracle8。1。7,建了一个数据库叫TEST,用system/manager可以进入oracle数据库,可是重启后再oemapp dbastudio进入就出现标题那样的提示错误,同时我输入dbstart的时候也出现这样的错误:ORA-12162:TNS:service name is incorrectly specified,应该也是指我的tnsnames.ora文件有问题, 我检查过我的$ORACLE_HOME/network/admin/tnsnames.ora文件 我的service_name是TEST,应该没有写错,我现在把我的tnsna...
我在redhat7。3上安装oracle8i,可是我运行sqlplus system/manager@sandy的时候,它却提示上面那样的错误 请问我该怎么办???