ORACLE 9i-23ai

操作已加载到内存中的数据时所需要的工作区域，这块内存区对于每个服务器进程都是私有的，不允许其它进程或线程的访问，PGA 一般是通过C 语言在运行时调用malloc() 和memmap() 来分配的，运行时可以动态的扩大，在8i后甚至可以动态的收缩，…

SQL> shutdown immediate
ORA-00604: 递归 SQL 层 1 出现错误
ORA-00600: 内部错误代码，参数: [kspgsp1], [101], [642], [1], [optimizer_mode], [], [], []

[oracle@anbob agent10g]$ bin/emctl upload agent
Oracle Enterprise Manager 10g Release 10.2.0.1.0.
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
—————————————————————
EMD upload error: uploadXMLFiles skipped :: OMS version not checked yet..

前一篇提到AGENT的多种安装方式中，如果平台一致最容易的安装方法就是使用agentDownload.linux

grid control （网格）管理 多个数据库时可以大大提高DBA 的工作效率，当然也有人说会给系统带来一些影响比如引起BUG，从而望而却步，不过ORACLE的 不断的完善还是很让人期待

今天有网友说他的数据库服务今天又自动停了，以前也说过查看alert日志并没报错，stackpack也看不出什么问题，windows排错还是必较麻烦(黑盒)，所以建议升级到9208版试试 我刚好本机有9i201的环境，帮他测一把看升级有没有什么异常（不排除特殊环境） 网上下载了升级补丁p4547809_92080_WINNT，我的xp上装有9i和10g 下面看我的操作 set oracle_sid=anbob set oracle_home=D:\oracle\product\9.2.0\Db_2 set path=D:\oracle\product\9.2.0\Db_2\bin;%path% sqlplus “/ as sysdba” 另存为ora9.bat ，因为我是先装的9I后装的10G所以每次要配一下环境 SQL*Plus: Release 9.2.0.1.0 – Production on 星期二 12月 13 16:29:32 2011 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. 连接到: Oracle9i Enterprise Edition Release 9.2.0.1.0 – Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release … Read more

Oracle Enterprise Manager 10g Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.Oracle Management Server is not functioning because of the following reason:Connection to the repository failed. Verify that the repository connection information provided is correct.

一个在windows下解压的oracle10 for linux安装文件，传到rhel 5安装遭遇 database/install/.oui: Permission denied 权限问题

when you try to access a table over the database link,mybe you get this error

Doc ID 1089399.1: ”For RHEL6 Oracle will only provide ASMLib software and updates via Unbreakable Linux Network(ULN). Oracle will no longer provide ASMLib packages for Red Hat kernels.”

The FETCH statement never raises a NO_DATA_FOUND exception as it is anticipated that it will eventually hit this condition ,Because the processing of the BULK COLLECT INTO clause is similar to a FETCH loop

anbob@ORCL> alter table testspace move tablespace anbob;
alter table testspace move tablespace anbob
ERROR at line 1:
ORA-01652: unable to extend temp segment by 128 in tablespace ANBOB

SQL> select BUILD_DATE,dump(build_date) from jmjk_jilin_th_mhk.ehealth_arch_basicinfo where BUILD_DATe>sysdate
2 ;
ERROR:
ORA-01877: string is too long for internal buffer