Pages: 11/48 First page Previous page 6 7 8 9 10 11 12 13 14 15 Next page Final page [ View by Articles | List ]

"There is no public key available for the following key IDs" 问题

[不指定 2009/06/08 23:53 | by askwan ]
OS: debian 4.0 etch
此问题比较普遍 故记录之 且供参考
一般都是在apt-get update 后出错：
W: There is no public key available for the following key IDs:
9AA38DCD55BE302B
W: You may want to run apt-get update to correct these problems

按照提示 运行apt-get  update这个指令 很遗憾 无论运行多少次 都无济于事

为演示这一过程 先下apt-key指令 import当前的keys
# apt-key update
gpg: key 2D230C5F: "Debian Archive Automatic Signing Key (2006) <ftpmaster@debian.org>" not changed
gpg: key 6070D3A1: "Debian Archive Automatic Signing Key (4.0/etch) <ftpmaster@debian.org>" not changed
gpg: key ADB11277: "Etch Stable Release Key <debian-release@lists.debian.org>" not changed
gpg: key BBE55AB3: "Debian-Volatile Archive Automatic Signing Key (4.0/etch)" not changed
gpg: Total number processed: 4
gpg:              unchanged: 4


当前系统有4个keys

增加上面列出的key
gpg --keyserver wwwkeys.eu.pgp.net --recv-keys  9AA38DCD55BE302B && apt-key add /root/.gnupg/pubring.gpg

再来看看系统中的trusted gpg keys信息
# apt-key list
/etc/apt/trusted.gpg
--------------------
pub   1024D/2D230C5F 2006-01-03 [expired: 2007-02-07]
uid                  Debian Archive Automatic Signing Key (2006)

pub   1024D/6070D3A1 2006-11-20 [expires: 2009-07-01]
uid                  Debian Archive Automatic Signing Key (4.0/etch)

pub   1024D/ADB11277 2006-09-17
uid                  Etch Stable Release Key

pub   1024D/BBE55AB3 2007-03-31 [expires: 2010-03-30]
uid                  Debian-Volatile Archive Automatic Signing Key (4.0/etch)
sub   2048g/36CA98F3 2007-03-31 [expires: 2010-03-30]

pub   4096R/55BE302B 2009-01-27 [expires: 2012-12-31]
uid                  Debian Archive Automatic Signing Key (5.0/lenny)

OK 5个 最后一行正是刚才加入的
再次apt-get update 就应该没有问题了

#apt-get update
Get:1 http://security.debian.org etch/updates Release.gpg [1032B]
Hit http://security.debian.org etch/updates Release
Ign http://security.debian.org etch/updates/main Packages/DiffIndex
Ign http://security.debian.org etch/updates/contrib Packages/DiffIndex
Ign http://security.debian.org etch/updates/main Sources/DiffIndex
Ign http://security.debian.org etch/updates/contrib Sources/DiffIndex
Hit http://security.debian.org etch/updates/main Packages
Hit http://security.debian.org etch/updates/contrib Packages
Hit http://security.debian.org etch/updates/main Sources
Hit http://security.debian.org etch/updates/contrib Sources
Fetched 1B in 2s (0B/s)  
Reading package lists... Done


还有一种情况就是 key过期的问题 那么这时候可以一个个先删除系统中的key
比如
apt-key list
apt-key del 55BE302B
apt-key del BBE55AB3
...
然后删除debian-archive-keyring包
dpkg –purge debian-archive-keyring
再次重新安装
apt-get install debian-archive-keyring
基本上都能解决这个问题

---------------END---------------
Tags: , ,
Oprating System | Comments(1) | Trackbacks(0) | Reads(1086)

imp导入数据到ORACLE遭遇ORA-12899错误

[不指定 2009/05/26 23:32 | by askwan ]
错如信息：
IMP-00019: row rejected due to ORACLE error 12899
IMP-00003: ORACLE error 12899 encountered
ORA-12899: value too large for column "JRGAZX"."DTLMB"."CC" (actual: 66, maximum: 50)

初步断定是字符集问题，中文在UTF-8里占3个字节，ZHS16GBK里占2个字节,而源dmp文件字符集是ZHS16GBK的库到出来的，现在要导入到目标字符集为UFT-8的库里。
Quotation
SQL>SHUTDOWN IMMEDIATE
SQL>STARTUP MOUNT
SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL>ALTER DATABASE OPEN

SQL> ALTER DATABASE CHARACTER SET ZHS16GBK ;
ALTER DATABASE CHARACTER SET ZHS16GBK
*ERROR at line 1:
ORA-12712: new character set must be a superset of old character set
报字符集不兼容，此时下INTERNAL_USE指令不对字符集超集进行检查：
Quotation
SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK
SQL>SHUTDOWN IMMEDIATE
SQL>STARTUP


再次用imp导入，就没有问题了。
oracle@server$ imp jrgazx/jrgazx file=/opt/jrgazx1/jrgazx1.dmp  fromuser=jrgazx TABLES=CWFXZB,CXQK,DQBGYYPLSJB,DQTZSM,DSYP,DTLMB
Quotation
Import: Release 10.2.0.1.0 - Production on Wed May 27 01:22:54 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses ZHS16GBK character set (possible charset conversion)
export client uses ZHS16GBK character set (possible charset conversion)
. importing JRGAZX's objects into JRGAZX
. importing JRGAZX's objects into JRGAZX
. . importing table                       "CWFXZB"      57197 rows imported
. . importing table                         "CXQK"       8471 rows imported
. . importing table                  "DQBGYYPLSJB"      30593 rows imported
. . importing table                       "DQTZSM"      11173 rows imported
. . importing table                         "DSYP"       4906 rows imported
. . importing table                        "DTLMB"     390372 rows imported
Import terminated successfully without warnings.
---------END-----------
Tags: , , , ,
DataBase | Comments(0) | Trackbacks(0) | Reads(2131)

遭遇 ORA-01102: cannot mount database in EXCLUSIVE mode

[不指定 2009/05/18 16:38 | by askwan ]
刚刚装好的库，简单测试没有问题后，放下，不到半个钟头，再次连接上去，发现数据库已经不可用了……

Quotation
oracle@staging:~$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Mon May 18 16:13:29 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn  / as sysdba
Connected to an idle instance.

SQL> select * from scott.emp;
select * from scott.emp
*
ERROR at line 1:
ORA-01034: ORACLE not available


机器并没有重启，oracle莫名其妙的到了不可用状态！我开始以为是谁关闭了，下开启指令
Quotation
SQL> startup
ORACLE instance started.

Total System Global Area 1224736768 bytes
Fixed Size                  2020384 bytes
Variable Size             318770144 bytes
Database Buffers          889192448 bytes
Redo Buffers               14753792 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode


这下遭遇ORA-01102: cannot mount database in EXCLUSIVE mode 错误了
Search On Google，then get the problem's anwser
大意是 “Oracle被异常关闭时，有资源没有被释放……”

检查警告日志，也证实了这一点，系统异常

马上查$ORACLE_HOME/dbs,发现一lk【SID】 文件，果然呆在这里
Quotation
staging:dbs# fuser -u lkCAPITALV
lkCAPITALV:            368(oracle)   370(oracle)   372(oracle)   374(oracle)   376(oracle)   378(oracle)   380(oracle)   382(oracle)   384(oracle)   386(oracle)   388(oracle)   397(oracle)  1472(oracle)  1557(oracle)  8852(oracle)


杀掉先：
Quotation
staging:dbs# fuser -k lkCAPITALV


再查，发现已经没有资源占用
Quotation
staging:dbs# fuser -u lkCAPITALV  

ok！
再次启动Oracle
Quotation
oracle@staging:~$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Mon May 18 16:24:05 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 1224736768 bytes
Fixed Size                  2020384 bytes
Variable Size             318770144 bytes
Database Buffers          889192448 bytes
Redo Buffers               14753792 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

----------------------END----------------------------
Tags: ,
DataBase | Comments(0) | Trackbacks(0) | Reads(2818)

测试速度还可以的apt源

[不指定 2009/05/13 00:06 | by askwan ]
You don't have the permission to view this entry.
Oprating System | Comments(0) | Trackbacks(0) | Reads(19)
Pages: 11/48 First page Previous page 6 7 8 9 10 11 12 13 14 15 Next page Final page [ View by Articles | List ]