山上有风

客户的应用程序在插入记录时遇到ora-03106错误。alert文件没有错误信息。

1. 查oracle错误信息
Cause: The communication path between Oracle and the user task has stopped. This is an internal error message not usually issued.
Action: Contact Oracle Support Services.
2. 要alert文件
没有相应错误记录
3. 查google

Troubleshooting
===============
Two-task common errors are generally RDBMS related issues, but could be caused by a problem with SQL*Net, or an application (i.e. Pro*C).

RDBMS – Troubleshooting two-task common errors
==============================================
1. Check for NLS incompatibilities between the client and server. This is a very popular cause of the ORA-03106 error.
2. Check the alert log and RDBMS trace files for any pertinent information / errors that coincide with receiving the ORA-03106 error.
3. Try to get a testcase and reproduce the problem in-house.
4. If a testcase is not possible, ask for SQL*Net trace files, SQL traces, and try setting event 3106 to obtain the error stack.
5. In extreme circumstances, this could indicate that a shared memory segment used by Oracle is corrupted. You will have to shut down the database, possibly using the abort option. Make sure all semaphores have been released by using the IPCS command on Unix. Oracle uses semaphores to control concurrency between all of the background processes (pmon, smon, drwr, lgwr, and oracle shadow processes). Semaphores are also used to control Two-Task communication between the user process and the shadow process.
6. Try and narrow down the code that may be causing it. For example it might have started to happen after increasing the number of parameters in a PL/SQL block or when using certain values for bind variables, etc.
7. If we still do not make headway, file a bug under RDBMS, but we still may need some or all of the above information as indicated above

4. 让客户查客户端的NLS_LANG(服务器是GBK)
客户端zhs16cgb231280.
让客户端把客户端的修改维gbk测试。不再报错。

5. 其它

可能的进一步思路。
可以考虑客户端重启， 服务器上监控到新的oracle进程，然后trace 该进程，获得其执行的sql.
到服务器上用sqlplus连接执行测试。

http://edelivery.oracle.com/EPD/Search/get_form

来自chinaunix：
Oracle Unbreakable Linux最终发布了，看来正是万众瞩目。可以从Oracle公司的官方主页上看到该项目的相关说明，该发行版就是来源于redhat企业级Linux，把其中的Red Hat的商标移除掉，然后加上一些bug的修补。虽然Oracle公司的Linux发行版计划被称为是一项支持项目，支持Oracle的Linux平台用户，而不是为了发行Linux发行版。因为来源于RHEL，所以该发行版完全兼容RHEL。目前该版本提供免费下载，另外假如有公司需要额外的支持服务，可以另外选择付费服务，由Oracle提供。

Oracle声明：
Oracle Press Release

Contact(s):

Letty Ledbetter
Oracle
+1.650.506.8071
letty.ledbetter@oracle.com

Bob Wynne
Oracle
+1.650.506.5834
bob.wynne@oracle.com
Oracle Announces The Same Enterprise Class Support For Linux As For Its Database
Dell, Intel, HP, IBM, Accenture, AMD, BP, EMC, BMC, and NetApp Join Unbreakable Linux Program
REDWOOD SHORES, Calif., 25-OCT-2006 Today Oracle announced that it would provide the same enterprise class support for Linux as it provides for its database, middleware and applications products. Oracle starts with Red Hat Linux, removes Red Hat trademarks, and then adds Linux bug fixes.

Currently, Red Hat only provides bug fixes for the latest version of its software. This often requires customers to upgrade to a new version of Linux software to get a bug fixed. Oracle’s new Unbreakable Linux program will provide bug fixes to future, current, and back releases of Linux. In other words, Oracle will provide the same level of enterprise support for Linux as is available for other operating systems.

Oracle is offering its Unbreakable Linux program for substantially less than Red Hat currently charges for its best support. “We believe that better support and lower support prices will speed the adoption of Linux, and we are working closely with our partners to make that happen,” said Oracle CEO Larry Ellison. “Intel is a development partner. Dell and HP are resellers and support partners. Many others are signed up to help us move Linux up to mission critical status in the data center.”

“Oracle’s Unbreakable Linux program is available to all Linux users for as low as $99 per system per year,” said Oracle President Charles Phillips. “You do not have to be a user of Oracle software to qualify. This is all about broadening the success of Linux. To get Oracle support for Red Hat Linux all you have to do is point your Red Hat server to the Oracle network. The switch takes less than a minute.”

“We think it’s important not to fragment the market,” said Oracle’s Chief Corporate Architect Edward Screven. “We will maintain compatibility with Red Hat Linux. Every time Red Hat distributes a new version we will resynchronize with their code. All we add are bug fixes, which are immediately available to Red Hat and the rest of the community. We have years of Linux engineering experience. Several Oracle employees are Linux mainline maintainers.”

DELL
“As a customer with first hand experience of Oracle’s outstanding support organization, Dell will use Oracle to support Linux operating systems internally,” said Michael Dell, Chairman of the Board, Dell. “Oracle’s new Linux support program will help us drive standards deeper into the enterprise. Today we’re announcing that Dell customers can choose Oracle’s Unbreakable Linux program to support Linux environments running on Dell PowerEdge servers.”

Intel
“Having worked with Oracle for many years in the enterprise computing space, we believe that the Oracle Unbreakable Linux program will bring tremendous value to our mutual Linux customers,” said Paul Otellini, President and CEO, Intel Corporation. “Our work with Oracle on this program will be an important extension to our longstanding enterprise computing relationship.”

HP
“HP and Oracle’s collaboration and testing of Linux with integrated stacks of hardware, software, storage, and networking has helped create numerous best practices across the industry. HP welcomes the addition of Oracle’s Unbreakable Linux program to the portfolio,” said Mark Hurd, Chairman and Chief Executive Officer, HP.

IBM
“Oracle’s support for Red Hat Linux will encourage broader adoption of Linux in the enterprise,” said Bill Zeitler, Senior Vice President & Group Executive, IBM Systems and Technology Group. “IBM shares Oracle’s goal of making Linux a reliable, highly standard, cost effective platform for mission critical applications backed by world class support.”

Accenture
“Linux is important to us, and to our customers,” said Don Rippert, Chief Technology Officer, Accenture. “We applaud Oracle’s efforts to bring enterprise-quality support to Linux with the Oracle Unbreakable Linux program announcement. Together with Oracle, we at Accenture look forward to making the Linux experience even better for our customers.”

AMD
“Oracle’s Unbreakable Linux program will greatly expand the servicing options available to our AMD Linux customers,” said Hector Ruiz, Chairman and Chief Executive Officer of Advanced Micro Devices. “We are excited by the program’s potential to further enhance the success of AMD Linux servers in the enterprise.”

Bearing Point
“It is critical that our customers have true enterprise-quality support for their Linux deployments. Oracle’s Unbreakable Linux program support delivers the level of confidence our customers need to run Linux in their data centers,” said Harry You, CEO, Bearing Point.

EMC
“The combined power of EMC and Oracle solutions bring superior reliability, scalability, high availability, and now, enhanced enterprise supportability to Linux users. We are confident that joint Linux solutions from EMC and Oracle will deliver enterprise scale and quality while lowering the cost of infrastructure for our customers,” said Joe Tucci, Chairman, CEO, President, EMC.

BMC
“As Oracle’s only systems management ISV at the highest level in Oracle’s Partner Program, BMC Software is excited to see Oracle’s deepening commitment to Linux,” said Bob Beauchamp, BMC Software President and CEO. “Business Service Management from BMC Software with the Oracle Unbreakable Linux program meets customer demand for lower cost and higher quality support for their infrastructure.”

NetApp
“The world’s largest enterprises must have the flexibility to quickly and continually adapt to today’s rapidly changing business requirements, without incurring risk,” said Dan Warmenhoven, CEO of Network Appliance. “The Oracle Unbreakable Linux program is designed to drive the key benefits of Linux – including flexibility, reliability, and simplicity – directly into the data center. The longstanding relationship between NetApp and Oracle has enabled us to continuously deliver superior enterprise solutions to enable business agility and improve reliability – all tenets of the NetApp brand.”

Oracle Support
Oracle’s breadth and depth of technical expertise, advanced support technologies, and global reach includes 7,000 support staff in 17 global support centers, providing help to our customers in 27 languages, in any time zone. Oracle has recently been awarded the J.D. Power and Associates Global Technology Service and Support Certification for “an outstanding customer service experience.”

“With the scale of our support organization we can provide much better Linux support at a much lower price,” said Executive Vice President of Oracle Customer Services Juergen Rottler. “We have the expertise and infrastructure to improve substantially the quality of support for enterprise Linux customers.”

Enterprise Linux binaries will be available for free from Oracle. Enterprise Linux Network Support will be offered for $99.00 per system / per year. Enterprise Linux Basic support, which offers Network access plus 24×7 global coverage will be offered for $399 for a 2 CPU system per year and $999 for a system with unlimited CPU’s. Enterprise Linux Premier Support, which offers Basic support plus back port of fixes to earlier releases as well as Oracle Lifetime Support will be offered for $1,199 for a 2 CPU system per year and $1,999 for a system with unlimited CPU’s.

Oracle and Linux
Oracle has been a long-standing, key contributor to the Linux community. Oracle produced its first commercial Linux database in 1998. Since that time Oracle has worked steadily to improve the experience of all Linux users. Oracle’s Linux Engineering team is a trusted part of the Linux community, and has made major code contributions such as Oracle Cluster File System that is now part of Linux kernel 2.6.16. Oracle has been and will continue contributing Linux related innovations, modifications, documentation and fixes directly to the Linux community on a timely basis.

About Oracle
Oracle (NASDAQ: ORCL) is the world’s largest enterprise software company. For more information about Oracle, visit our Web site at http://www.oracle.com.

Trademarks
Oracle, JD Edwards, PeopleSoft, and Siebel are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

This announcement is provided to you solely for information purposes, is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. Many factors can materially affect Oracle’s product development plans and the nature and timing of future product releases. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle. This information may not be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates. Oracle specifically disclaims any liability with respect to this information.

# # #

What Is an MDDB?

A multidimensional database, or MDDB, is a specialized storage facility that allows data to be pulled from a data warehouse or other data sources for storage in a matrix-like format. The process of building an MDDB summarizes the raw data; the data stored in the MDDB is thus said to be presummarized. The MDDB enables users to quickly retrieve multiple levels of presummarized data through a multidimensional view. An MDDB is not a SAS data file; instead of the traditional structure used for SAS tables, an MDDB stores its data as an NWAY cube and zero or more subcubes.

参看

一直以为，这个第三方是针对甲方，乙方之外的。
今天看到一个说法：

一般来说，IT厂商为客户提供的服务可分为三种形式：IT厂商自身为用户提供服务 ，称之为第一方服务；通过广泛的渠道商为用户提供服务，称之为第二方服务；再有就 是将服务业务外包给独立的第三方服务商，我们称之为第三方服务。

这里出来了第一方服务，第二方服务， 感觉定义有些牵强。

又有：

第三方服务是指由独立提供的专业服务商，以第三方的角色为客户提供系列的专业性服务过程，该过程以合同的形式来界定供需二者之间的职责。

这种说法和我以前理解的比较接近。

我觉得还是这种理解比较合理。

周五(06-10-20)昆山通宵，周六上午返回，休息了下午。朋友约周日游玩崇明岛，友已很久没有见面，都忙。他买车已很久，这次蹭车出游。

路上友顺路办些事，到达轮渡时已然午时。

一小时后到达崇明。

陪友看房（其欲投资于此），已涨至5800/m2, 想起自己购买时不过5100，感慨。

然后驱车直奔湿地，路上到一酒家就餐，无他，但酸辣汤酸尔。

于下午3时到达湿地，有“xxx湿地欢迎你”为证。

车停至一门前，工作人员问：“侬哪能”？

始知车不能进。于是登记，得一通行证，问是否回来要交回，答曰可留作纪念。于是欣欣然进入湿地。
于是拍照，拍照，拍照。

于是见一白鹭状飞鸟，于泥泞中散步。

于是见水牛数头行进于泥泞。

然有无边芦苇，风吹芦苇声声，一境。欲录之而不可得。

于是离开。友迷失归来路。几撞于一货车。

于五时抵码头，等。

于八时上船。

于十时到地铁。

于十时四十抵家。

颓然曰，金窝银窝不如自己狗窝。 况非狗窝乎！

昨夜与妻散步于小区，说起邻居因婆媳交恶而夫妻失和，仰头一轮弯月，感慨人生短暂，而因为各种琐事蹉跎岁月。 想起张若虚的《春江花月夜》中感慨天际久远，人生短暂。看到这小区楼房，十年后，二十年后可能不复存在，月亮若有知，能看到这历历的人事更迭，世事变化。那么短暂人生的些许苦恼，又算的了什么？

当时总既不起这句诗，有暇google之：

江畔何人初见月？

是谁和我一样，第一次有这样的感慨？

江月何年初照人？

江月是什么时候看到这芸芸众生？

输入的半角单引号，在显示时都变为全角了。
查数据库的数据，都还是半角的，备份导出的数据也是半角的。
分析是显示时进行了转换。

目前没有办法，贴出的脚本，需要修改后才能运行。

今天提交metalink时， 发现hp-ux的9000系列有 2个选择，以前没有见过：

HP 9000 Series HP-UX BLS (Secure)

HP 9000 Series HP-UX CMW (Secure)
google了一下：

questions:

what difference between the HP platforms?
a. HP 9000 HP-UX 11.0(32 bit)
b. HP 9000 Series HP-UX BLS(Secure)
c. HP 9000 Series HP-UX CMW(Secure)
d. HP IA64 HPUNIX
e. HP Tru64 UNIX
f. HP-UX Itanium
g. HP-UX PA-RISC(64-bit)

answer:
a) 32 bit OS revision 11.00 of HP-UX
b) B Level security revision of 11.00 of HP-UX
c) C Level security revision of 11.00 of HP-UX
d and f) 64 bit OS of HP-UX running IA64 hardware
e) pre-merger compaq version of Unix
g) 64 bit version of “a)”

一个同事msn登录不了，删除后重新安装时失败。

用7.5安装，提示下载最新版本，下载最新版本安装提示1061错误。

到google上查了一下，发现好多人遇到这个问题，查到这个解决方法：

http://www.bigblueball.com/forums/msn-messenger-support/17420-error-code-1601-1603-solutions.html

1601 Fix – courtesy of naRc

1. Click START, and then click RUN.
2. In the OPEN box, Type msiexec /unreg, and then click OK
3. When this process is complete, click START, and then click RUN.
4. In the OPEN box, type msiexec /regserver, and then click OK.
5. Now install MSN 6

我测试安装7.5,live messenger都可以。 

不知道还以为自己人品问题。（啊，msn都安装不上?!)

表数据200万，使用一个字段查询，该字段上有索引，客户说没有使用索引。

1.要表结构

create table STAT_SALE
(
  OIDD          NUMBER(20) not null,
  CODE          VARCHAR2(20) not null,
  SHOPCODE      VARCHAR2(20) not null,
  SHOPNAME      VARCHAR2(50) not null,
  GOODSCODE     VARCHAR2(20) not null,
  GOODSNAME     VARCHAR2(100),

…

create index U_STATSALE_GOODSCODE on STAT_SALE (GOODSCODE)  … 

2.要查询语句

select * from stat_sale a where a.goodscode=290957

聪明的你现在应该可以看出没有使用索引的原因了。

愚蠢的我没有发现。

3.执行

select count(*) from stat_sale;
select num_rows from user_tables where table_name = ‘STAT_SALE’;

2086984  和 null
分析是没有analyze的原因

3.analyze

analyze table STAT_SALE estimate statistics sample 5000 rows;
analyze index U_STATSALE_GOODSCODE compute statistics;
analyze table stat_sale estimate statistics sample 5000 rows for all columns;

4.再执行上述语句看执行计划

仍然没有使用索引 。

faint.

此时才发现，类型是varchar2，而=后面是数字，发生了类型转换，没有使用索引。

数字加上”后，使用了索引。