欢迎光临本站--------万志华的网络家园。本网站文章内容仅代表我个人观点，不针对任何单位和个人，文章中如有不对之处，欢迎批评指正。文章均系个人原创，转载麻烦请注明出处，Enjoy！
分页： 1/23 第一页 1 2 3 4 5 6 7 8 9 10 下页 最后页 [ 显示模式： 摘要 | 列表 ]

"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 | 评论(1) | 引用(0) | 阅读(111)

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的库里。
引用
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指令不对字符集超集进行检查：
引用
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
引用
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 | 评论(0) | 引用(0) | 阅读(182)

生命

[不指定 2009/05/24 19:59 | by askwan ]
      
       "人的生命跟朝露没有什么两样，看起来不乏美丽，甚至有的时候是如此的凄美壮观，但是只要阳光一照射，一眨眼的工夫它就蒸发消逝在这个空间而变得无影无踪了，生命短暂，值得珍惜。在拥有的每一分每一秒，都要提醒自己不要虚度。珍惜生命中的所有，不断前进，不枉度此生。" 佛曰。
    生命只在一呼一吸之间！
    “露水有一瞬，浮游有一昼夜，花草有一季，凡人有几十年。生命只在一呼一吸……”！
    点击在新窗口中浏览此图片
  
     愿我劳碌一生的父亲在天堂里得到安息！永远安息！
    点击在新窗口中浏览此图片
Tags:
My Diary | 评论(0) | 引用(0) | 阅读(117)

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

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

引用
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莫名其妙的到了不可用状态！我开始以为是谁关闭了，下开启指令
引用
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】 文件，果然呆在这里
引用
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)


杀掉先：
引用
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

----------------------END----------------------------
Tags: ,
DataBase | 评论(0) | 引用(0) | 阅读(174)

测试速度还可以的apt源

[不指定 2009/05/13 00:06 | by askwan ]
这是一篇隐藏日志。您需要以合适的身份登入后才能查看。
Oprating System | 评论(0) | 引用(0) | 阅读(16)

为父亲祈祷！

[不指定 2009/05/07 13:40 | by askwan ]
点击在新窗口中浏览此图片
My Diary | 评论(0) | 引用(0) | 阅读(200)

Linux最强渗透检测发行版BackTrack 4

[不指定 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
Tags: , , , ,
Security | 评论(0) | 引用(0) | 阅读(326)
分页： 1/23 第一页 1 2 3 4 5 6 7 8 9 10 下页 最后页 [ 显示模式： 摘要 | 列表 ]