欢迎光临本站--------万志华的网络家园。本网站文章内容仅代表我个人观点,不针对任何单位和个人,文章中如有不对之处,欢迎批评指正。文章均系个人原创,转载麻烦请注明出处,Enjoy!
"There is no public key available for the following key IDs" 问题
[
2009/06/08 23:53 | by askwan ]
2009/06/08 23:53 | by askwan ]
OS: debian 4.0 etch
此问题比较普遍 故记录之 且供参考
一般都是在apt-get update 后出错:
按照提示 运行apt-get update这个指令 很遗憾 无论运行多少次 都无济于事
为演示这一过程 先下apt-key指令 import当前的keys
# apt-key update
当前系统有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
还有一种情况就是 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---------------
此问题比较普遍 故记录之 且供参考
一般都是在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
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
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
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---------------
imp导入数据到ORACLE遭遇ORA-12899错误
[
2009/05/26 23:32 | by askwan ]
2009/05/26 23:32 | by askwan ]
错如信息:
初步断定是字符集问题,中文在UTF-8里占3个字节,ZHS16GBK里占2个字节,而源dmp文件字符集是ZHS16GBK的库到出来的,现在要导入到目标字符集为UFT-8的库里。
再次用imp导入,就没有问题了。
---------END-----------
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)
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的库里。
引用
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>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指令不对字符集超集进行检查: ALTER DATABASE CHARACTER SET ZHS16GBK
*ERROR at line 1:
ORA-12712: new character set must be a superset of old character set
引用
SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK
SQL>SHUTDOWN IMMEDIATE
SQL>STARTUP
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
引用
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.
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.
遭遇 ORA-01102: cannot mount database in EXCLUSIVE mode
[
2009/05/18 16:38 | by askwan ]
2009/05/18 16:38 | by askwan ]
刚刚装好的库,简单测试没有问题后,放下,不到半个钟头,再次连接上去,发现数据库已经不可用了……
机器并没有重启,oracle莫名其妙的到了不可用状态!我开始以为是谁关闭了,下开启指令
这下遭遇ORA-01102: cannot mount database in EXCLUSIVE mode 错误了
Search On Google,then get the problem's anwser
大意是 “Oracle被异常关闭时,有资源没有被释放……”
马上查$ORACLE_HOME/dbs,发现一lk【SID】 文件,果然呆在这里
杀掉先:
再查,发现已经没有资源占用
ok!
再次启动Oracle
----------------------END----------------------------
引用
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
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莫名其妙的到了不可用状态!我开始以为是谁关闭了,下开启指令
引用
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
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】 文件,果然呆在这里
引用
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)
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)
杀掉先:
引用
staging:dbs# fuser -k lkCAPITALV
再查,发现已经没有资源占用
引用
staging:dbs# fuser -u lkCAPITALV
ok!
再次启动Oracle
引用
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
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----------------------------
测试速度还可以的apt源
[
2009/05/13 00:06 | by askwan ]
2009/05/13 00:06 | by askwan ]
这是一篇隐藏日志。您需要以合适的身份登入后才能查看。
Linux最强渗透检测发行版BackTrack 4
[
2009/04/29 10:14 | by askwan ]
2009/04/29 10:14 | by askwan ]
Backtrack

看到系统界面里 用中文繁体写就的 “龙” 字,倍觉亲切吧 呵呵
喜欢研究安全技术的linux fans不容错过!
最新发行版已经到 BackTrack 4 beta release
1DVD 854 MB 同时又集成众多老的安全工具和最近最新的安全工具

其同时也是无线网络破解集成工具箱!非常适合蹭网族,呵呵
最近拿来蹭办公楼附近的无线资源,甚觉强悍!
发此文,以推荐linux安全爱好者
最新版下载地址:
http://backtrack.unixheads.org/bt4-beta.iso
vmware镜像:
http://backtrack.unixheads.org/bt4-beta-vm-6.5.1.rar
看到系统界面里 用中文繁体写就的 “龙” 字,倍觉亲切吧 呵呵
喜欢研究安全技术的linux fans不容错过!
最新发行版已经到 BackTrack 4 beta release
1DVD 854 MB 同时又集成众多老的安全工具和最近最新的安全工具
其同时也是无线网络破解集成工具箱!非常适合蹭网族,呵呵
最近拿来蹭办公楼附近的无线资源,甚觉强悍!
发此文,以推荐linux安全爱好者
最新版下载地址:
http://backtrack.unixheads.org/bt4-beta.iso
vmware镜像:
http://backtrack.unixheads.org/bt4-beta-vm-6.5.1.rar




