linux redhat/oracle_linux rpm µÄ°ü¹ÜÀíÔõôÕâÑù£¿
±¾È˺ÜÏëѧµã¶«Î÷£¡´ÓÊÂunix ϵÄά»¤¿ìÁ½ÄêÁË£¡
¼¸Ììǰ±»rpm ¸ãµÄ¼¸Ìì˯²»ºÃ¾õ£¡
ΪÁË×ö²âÊÔºÍʵÑ飬ѧµ½µãÕæ±¾Ê£¡
ÔÚ×Ô¼ºµÄ±Ê¼Ç±¾ÉÏÏÂÔØÁËoracle10g oracle11g redhat,oracle_linux
¿ªÊ¼°´ÕÕǰÈ˵ľÑ鿪ʼ´î½¨»·¾³
ĬÈÏ·½Ê½°²×°ÁËoracle_linux update 3
°´ÕÕǰÈË˵·¨
¼ì²é»·¾³
Ìáʾ compat-libstdc++-33
unixODBC
glibc-common
make °üûÓа²×°£¡
µ¥¸ö °ü rpm -qa |grep unixODBC
ÓоÍÊÇ·¢ÏÖ²»ÁË glibc-commom
ÔÚͼÐνçÃæ°ü¹ÜÀíÀïÄÜ¿´µ½ÕâЩ¶¼×°ÁË£¡
Ð¶ÔØ glibc-commom ºÃ¶àrpm ¶¼ÒªÐ¶ÔØ£¡
×îºóµ¥¸ö¼ì²é¶¼ÓУ¬¾ÍÊDz»Äܼ¯Ìå¼ì²éͨ¹ý£¡
°´ÕÕ˵Ã÷ °²×°È»¶øÍ¼ÐνçÃæµÄ°²×°Ã»ÓÐÁË£¡ÔËÐкó×Ô¶¯¹Ø±Õ£¡Ã»ÓÐÏÂÎÄ£¡
²é¿´ËùÓеÄ×ÊÁÏ·½·¨¶¼Ò»Ñù£¡È»¶ø½á¹ûÈ´²»Í¬£¡
ÔÚvm ware server conlse 1.13 °æÉÏʵÑéµÄ£¡ÓôÃÆÑ½£¡rpm ÎÒÒª¿ÞÁË£¡
ΪÁËoracle ÎÒ²ÅÑ¡ÔñËùνµÄ³§¼Òϵͳ£¡
555£¡
°¥ ÔÚlinuxϰ²×°oracleȷʵ·Ñ¾¢
ÆäʵÎÒÏëÌýÄã½²½²ÔÚunixÏÂÓÃÄÄЩ°ü¹ÜÀí¹¤¾ß¼°¾Ñé ¹þ¹þ
ÓоÍÊÇ·¢ÏÖ²»ÁË glibc-commom
¸ã²»¶®Õâ¾ä»°µÄÒâ˼
·´ÕýÊÇȱʲôÄã¾Íװʲô ËäÈ»¶àÒ²²»Òª·³ ×îºó¿Ï¶¨»á¸ã¶¨µÄ
´íÁË
rpm -qa |grep glibc-commom
ûÓаü
rpm -e glibc-commom
°üûÓа²×°
rpm -ivh
glibc-commom*
Ìáʾ:glibc-commom ÒѾ°²×°¹ýÁË£¡
ÓÐЩʱºòÎÊÌ⻹²»Ò»Ñù
ĬÈϰ²×°ºógcc ÎÊÌâ×î¶à£¡ÌáʾµÄÒÀÄͰü¶¼×°ÁË£¡×îºó glibc not found È«¾Ö±äÁ¿£¡
ºÃ²»ÈÝÒ×¶¼ÓÐÁË£¡
unixODBC*
ÕûÌå¼ìÑé »¹ÊÇȱÉÙ°ü£¡
µ¥¸ö²é²»ÉÙ£¡<
Ïà¹ØÎÊ´ð£º
дÁ˸ö²âÊÔ³ÌÐòÈçÏÂ
struct hostent *hp;
char AlarmDevIP[20];
int x2;
hp = gethostbyname("www.google.com");
if (hp)
{
......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
ÏÖÔÚÐèÒªÔÚÒ»¸öǶÈëʽϵͳÖÐʵÏÖʱ¼äº¯Êý£¬±àÒëÆ÷δÌṩtime¿âº¯Êý£¬ÇëÎÊ´ó¼ÒÈçºÎÓÃcÓïÑÔʵÏÖʱ¼äº¯Êý°¡£¿
ÄêÔÂÈÕʱ·ÖÃë µ½ ÕûÊýÃ루´Ó1970Ä꿪ʼ£© Ö®¼äµÄÏà¹Ø×ª»»°¡
ÀàËÆmktime ºÍlocaltimeµÄ¹¦ÄÜ£¬Ð»Ð»
mktime ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......