I encountered a strange problem today with a 3 node cluster. Let's start with the facts first:
listener.ora SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = MYDATA) (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1) (SID_NAME = MYDATA) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PR...
instance of是Java的一个二元操作符,和==,>, 本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u2/65478/showart_1889984.html
我在solaris 装了oracle9.2.0 装完之后是可以用的,(建用户,建新表等),但当我重启这台机后,oracle就出现问题了: sh-2.05$ sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on Fri Sep 2 23:24:25 2005 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL>; conn /as sysdba connected to an idle instance. SQL>; startup ORACLE instance started. Total System Global Area 43164544 byt...
我在solaris 装了oracle9.2.0\r\n装完之后是可以用的,(建用户,建新表等),但当我重启这台机后,oracle就出现问题了:\r\n\r\nsh-2.05$ sqlplus /nolog\r\n\r\nSQL*Plus: Release 9.2.0.1.0 - Production on Fri Sep 2 23:24:25 2005\r\n\r\nCopyright (c) 1982, 2002, Oracle Corporation. All rights reserved.\r\n\r\nSQL>; conn /as sysdba\r\nconnected to an idle instance.\r\nSQL>; startup\r\nORACLE instance started.\r\n\...
下列文本: 1234|000|12345|123| 1234|124|12348|123| 如何变成: 1234|000 |12345|123| 1234|124 |12348|123| 用awk处理: awk 'BEGIN{FS=OFS="|"}$2=$2" "' 数据文件 ===================================================================================== $cat test.txt 222904|220004868|张仁|773|789|0|0.56|0| 222904|220004868|张仁|773|789|16|0.56|8.96| 222904|220004869|藏永军|1795|1918|0|0.56|0| ...
各位: 今天被问倒!! 实例和数据库的区别是什么? 我知道实例是instance,ORACLE中是SGA+BACKUPGROUP PROCESS;一个数据库只能属于一个实例,一个实例中可以有 多个数据库。 SQL中同样一个实例有自己的一套MASTER系统库, 但除此之外,还有什么区别吗,哪位指点一下,谢谢 albert