44问答网
所有问题
当前搜索:
oracle的sid_name在哪里
监听程序在 connect data
中
未获得 service
name
ORA-12154: TNS: 无 ...
答:
连接字符串有问题:"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST={0})(PORT={1})))(CONNECT_DATA=(SERVER={2})(SERVICE_
NAME
={3})));User Id={4};Password={5};"格式如上,替换{0} 这种为你自己的配置 ...
oracle
启动监听报错TNS-01150:The address of the specified listener...
答:
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (
SID_NAME
= PLSExtProc)(
ORACLE
_HOME = /u01/app/
oracle
)(PROGRAM = extproc)(ENVS="EXTPROC_DLLS=/u01/app/oracle/lib/libst_shapelib.so"))(SID_DESC = (SID_NAME = dywdb)(ORACLE_HOME= /u01/app/oracle)))仔细看上面的, 最后多...
启动
oracle
服务的几种方式
答:
2)在窗口中输入:NET START
Oracle
Service
Name
通过Oracle Administration Assistant for WindowsNT启动
oracle
服务 1)选择开始 〉程序 〉Oracle - HOME_
NAME
> Configuration and Migration Tools > Oracle Administration Assistant for Windows NT. 2)找到并右键单击oracle
sid
3)选择启动 关闭oracle服务...
如何查看
ORACLE
数据库服务器名
答:
服务器名称就相当于计算机名称:Linux:host
name
Windows:右键-》我的电脑 我想你要查看的是数据库实例名称吧:方法一:select instance_name from v$instance;方法二:select name from v$database;
在
Oracle中
如何实现自增字段
答:
CURRVAL总是返回当前sequence的值,但是在第一次NEXTVAL初始化之后才能使用CURRVAL,否则会出错。2、触发器(trigger)create or replace triggertrigger_
name
before insert on your_
sid
.tablenamefor each rowbegindeclarei number;cursor cur is select max(id) from your_sid.tablename;BEGINopen cur;...
PL/SQL Developer连接
oracle
问题
答:
你的操作系统是Win7 32位还是64位的?如果是64位的话,稍微麻烦点
string ConnectionString = "Data Source=Mes1;User ID=system;Password...
答:
SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyHost)(PORT=MyPort))(CONNECT_DATA=(SERVICE_
NAME
=My
OracleSID
)));uid=myUsername;pwd=myPassword;使用上面的连接字符串可能会导致Visual Studio报告错误,如果您在使用中出现了这些问题,请使用下面的这种连接方式。Data Source=(DESCRIPTION=(ADDRESS...
ORA-12154:TNS:could not resolve the connect identifier specified...
答:
Generated by
Oracle
configuration tools.LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = prm1)(PORT = 1521)))SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ora11g)(
ORACLE
_HOME = /
oracle
/app/product/11g/db)(
SID_NAME
= ora1...
oracle
11g ora:12505 Listener refused the connection求大神帮忙...
答:
监听文件配置错误,提示里面有不知道
的 SID
描述,建议可以手工修改。建议是:netca 命令删除配置,然后选择重新 监听配置.或者修改你现有的监听文件 listener.ora 如下, 注意修改如下参数为你的实际情况 (1) GLOBAL_DBNAME = cqcq (2)
SID_NAME
= cqcq)(3)
ORACLE
_HOME listener.ora Network ...
dataguard 可以在linux不同版本实现吗
答:
# Generated by
Oracle
configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (
SID_NAME
= PLSExtProc) (
ORACLE
_HOME = /u01/product/10.2.0/db_1) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = WILLSON) (ORACLE_HOME = /u01/product/10.2.0/db_1) ))LISTENER = (DESCRIPTION...
棣栭〉
<涓婁竴椤
13
14
15
16
18
19
20
21
22
涓嬩竴椤
灏鹃〉
17
其他人还搜