oracle錯誤及解決方式集(轉)

oracle錯誤及解決方式集(轉)[@more@]1)啟動hp-unix下oracle時出現如下所示:
Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved
Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.2.0 - 64bit Production
SVRMGR> Password:
Password:
ORA-01031: insufficient privileges
SVRMGR> ORA-01031: insufficient privileges
SVRMGR>
Server Manager complete.
Database "ora" warm started.
#
顯示許可權不夠;用root去啟動oracle當然是不行的;

2)col 用法
col子命令中有兩個引數：truncated 和 wrapped，col定義的顯示行的寬度，truncated就是如果行超過顯示寬度就截斷，wrapped就是換行！

/*=========================================================================*/
/* 建立同義詞並使用 */
/*=========================================================================*/
我們先看如下的一系列執行：
SQL> create or replace view v_bmw_pay_online_new as
2 select *
3 from taobao.bmw_pay_online_new@lnk_db215;

SQL> create or replace procedure sp_v_test is
2 v_id number;
3 begin
4 select id into v_id from v_bmw_pay_online_new where id=1;
5 end;
6 /
Procedure created
SQL> create or replace synonym s_bmw_pay_online_new
2 for taobao.bmw_pay_online_new@lnk_db215;
Synonym created
SQL> create or replace procedure sp_s_test is
2 v_id number;
3 begin
4 select id into v_id from s_bmw_pay_online_new where id=1;
5 end;
6 /
Warning: Procedure created with compilation errors
SQL> show error
Errors for PROCEDURE TAOBAO.SP_S_TEST:
LINE/COL ERROR
-------- ------------------------------------------------------------------------------------
4/29 PL/SQL: ORA-00600: 內部錯誤程式碼，引數: [17069], [0x57E77854], [], [], [], [], [], []
4/4 PL/SQL: SQL Statement ignored

可以看到，在同樣一個遠端物件上面，我可以透過建立檢視，然後在該檢視上建立儲存過程，是沒有任何問題的，
但是如果我對該遠端操作做一個同義詞，再在同義詞上建立儲存過程，則報出了Ora-00600。跟蹤也無果，
看產生的日誌檔案也不能看出來什麼，上metalink，搜尋"ora-00600 17069"，發現查出現的東西一大堆，
大致是library cache錯誤，但是到底怎麼會產生這個錯誤呢，online聯絡上一個oracle線上技術支援，聊了一會兒，
問題是解決了，但是他就是不承認是bug，呵呵。
以下是聊天的總結：
ORA-00600 [17069] reorted on compiling a procedure.
Invalid lock in library cache.
Unable to pin the object and hence the Error.
"Failed to pin a library cache object after 50 attempts"
Clearing the shared memory will help to get rid of inconsistant information
in memory which is causing the error.
The inconsistency was suspected to be in the remote site. But flushing the
shared pool in remote location didnt help.Tried recreation of the procedure
after dropping and recreating the synonym in the local database. But the
same failed.Flushed the shared pool in local database abd successfully
created the procedure.
alter system flush share_pool;
/*=========================================================================*/
/* 建立同義詞並使用 */
/*=========================================================================*/
create synonym synonym_name for table_name@db_link;
select * from table_name;
/*=========================================================================*/
/* 建立DB-LINK連線並使用 */
/*=========================================================================*/
create public database link db_link
connect to user identified by pwd
using 'connect string';
select * from dual@db_link;
/*=========================================================================*/
/* 插入時間串 */
/*=========================================================================*/
insert into test(IMPORT_DATE) values
(to_date('2002-10-20 15:30:00','yyyy-mm-dd hh24:mi:ss'));
insert into test(testtime) values(sysdate);
取得時候可以to_char(sysdate，'yyyy-mm-dd hh24:mi:ss')
/*=========================================================================*/
/* 更改表時記錄其變化的TRIGGER */
/*=========================================================================*/
CREATE OR REPLACE TRIGGER T_APBT_CONTRACT_ALL_AIUDR
after insert or update or delete on APBT_CONTRACT_ALL
for each row
/*無論一條語句改變了多少條記錄,ORACLE對於每條記錄觸發一次觸發器*/
/*before和after的區別:事件發生前還是事件發生後*/
begin
if inserting then
insert into A_APBT_CONTRACT_ALL(ID,CONTRACT_SERIAL_NUM,flag)
values (Seq_APBT_ARMS.NEXTVAL,:new.CONTRACT_SERIAL_NUM,1);/* :new*/
elsif updating then
insert into A_APBT_CONTRACT_ALL(ID,CONTRACT_SERIAL_NUM,flag)
values (Seq_APBT_ARMS.NEXTVAL,:old.CONTRACT_SERIAL_NUM,2);
/*此句存在問題*/
elsif deleting then
insert into A_APBT_CONTRACT_ALL(ID,CONTRACT_SERIAL_NUM,flag)
values (Seq_APBT_ARMS.NEXTVAL,:old.CONTRACT_SERIAL_NUM,3);
end if;
end;
/
/*=========================================================================*/
/* 你能夠建立被如下語句所觸發: */
/*=========================================================================*/
DML語句( DELETE,INSERT,UPDATE)
DDL語句( CREATE,ALTER,DROP)
資料庫操作( SERVERERROR, LOGON, LOGOFF, STARTUP, SHUTDOWN)
/*=========================================================================*/
/* 建立sequence序列: */
/*=========================================================================*/
DROP SEQUENCE ARMS.SEQ_APBT_ARMS;
CREATE SEQUENCE ARMS.SEQ_APBT_ARMS
START WITH 30
MAXVALUE 999999999999999999999999999
MINVALUE 1
NOCYCLE
CACHE 20
NOORDER;