Linux procÁ¬½ÓoracleÊý¾Ý¿â
¹¤×÷ÐèÒª£¬×î½üÔÚѧϰLinuxÏÂprocÁ¬½ÓoracleÊý¾Ý¿âµÄ¶«Î÷£¬ÏÂÔØÁËÒ»·ÝÎĵµÕýÔÚ¿´£¬µ«ÊÇÌ«Âý£¬Ë¸øÒ»¸öLinuxÏÂprocÁ¬½ÓoracleÊý¾Ý¿âµÄÒ»¸ö¼òµ¥·¶Àý£¬ÒªÇóÄÜÔËÐУ¬°üÀ¨»·¾³µÄÉèÖ㬷¶ÀýÖаüº¬¶Ôij¸ö±íµÄÒ»¸ö¼òµ¥²Ù×÷£¬ÈçÔöɾ¸Ä£¬Ð»Ð»£¡
ÄãÊÇÐèÒªÒ»¸ö.pcÎļþµÄÀý×Óô£¿
¶ÔµÄ£¡»¹ÓоÍÊÇ»·¾³µÄÉèÖà ¡£
´Ó×Ô¼º´úÂëÀï½ØÈ¡³öÀ´µÄ£¬ºÃÏñÓÐЩ¶«Î÷ûÓÐɾµô£¬ÎÒÊÖͷûÓл·¾³ÁË£¬ËùÒÔûÓвâÊÔ£¬´ó¸ÅÒâ˼ÊÇÕâÑùµÄ
Õâ´úÂëÎÒ¿´µÄÔÆÀïÎíÀÖ÷º¯ÊýºÃÏñûÓУ¬Äã¸øµÄÖ»ÊÇÁ½¸öº¯Êý£¬ÄǸöÁ¬½ÓÊý¾Ý¿âµÄº¯Êý·µ»ØÓï¾äдµÄÓеãÎÊÌâ°É£¡
Ïà¹ØÎÊ´ð£º
дÁ˸ö²âÊÔ³ÌÐòÈçÏÂ
struct hostent *hp;
char AlarmDevIP[20];
int x2;
hp = gethostbyname("www.google.com");
if (hp)
{
......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......