Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

linuxÏ´´½¨oracleÓû§±í¿Õ¼ä

 ¾ÍÊÇÔÚÒÑÓеÄÊý¾Ý¿âʵÀýÉÏ´´½¨Ò»¸öеÄÕʺţ¬·ÃÎÊһЩеıí
 ²Ù×÷²½ÖèÈçÏ£º
 1¡¢µÇ¼linux£¬ÒÔoracleÓû§µÇ¼£¨Èç¹ûÊÇrootÓû§µÇ¼µÄ£¬µÇ¼ºóÓà su - oracleÃüÁîÇл»³ÉoracleÓû§£©
 2¡¢ÒÔsysdba·½Ê½À´´ò¿ªsqlplus£¬ÃüÁîÈçÏ£º sqlplus "/as sysdba"
 3¡¢²é¿´ÎÒÃdz£¹æ½«Óû§±í¿Õ¼ä·ÅÖÃλÖãºÖ´ÐÐÈçÏÂsql£º
select name from v$datafile;
 ÉϱߵÄsqlÒ»°ã¾Í½«ÄãµÄÓû§±í¿Õ¼äÎļþλÖòé³öÀ´ÁË¡£
 4¡¢´´½¨Óû§±í¿Õ¼ä£º
CREATE TABLESPACE NOTIFYDB DATAFILE '/oracle/oradata/test/notifydb.dbf' SIZE 200M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
5¡¢´´½¨Óû§£¬Ö¸¶¨ÃÜÂëºÍÉϱߴ´½¨µÄÓû§±í¿Õ¼ä
CREATE USER hc_notify IDENTIFIED BY hc_password DEFAULT TABLESPACE NOTIFYDB;
6¡¢¸³ÓèȨÏÞ
grant connect,resource to hc_notify;
grant unlimited tablespace to hc_notify;
grant create database link to hc_notify;
grant select any sequence,create materialized view to hc_notify;
¾­¹ýÒÔÉϲÙ×÷£¬ÎÒÃǾͿÉÒÔʹÓÃhc_notify/hc_passwordµÇ¼ָ¶¨µÄʵÀý£¬´´½¨ÎÒÃÇ×Ô¼ºµÄ±íÁË
 


Ïà¹ØÎĵµ£º

½â¾öOracle 9iºÍTomcat¶Ë¿Ú³åÍ»

·½°¸Ò»£º
ÐÂ×°ÁËϵͳºó£¬·¢ÏÖÔÚµ÷ÊÔ³ÌÐòʱTOMCATÌáʾ8080¶Ë¿ÚÒѱ»Õ¼Óã¬ÓÚÊÇÔËÐÐNETSTAT -ANO²é¿´¶Ë¿ÚʹÓÃÇé¿ö£¬·¢ÏÖ8080¶Ë¿Ú±»ORACLEµÄ¼àÌýÆ÷¸øÕ¼ÓÃÁË£¬ÓÚÊǽáºÏÉÏÍø²éµ½·½·¨£¬½«ORACLE XDBµÄHTTP·þÎñ¶Ë¿Ú¸Ä³É8081£¬ÎÊÌâ½â¾ö¡£
×ܽáһϿɽâ¾öµÄ·½·¨£º
Ò»¡¢¸ü¸ÄTOMCATµÄĬÈ϶˿Ú
Ïà¹ØÎļþ£º"TOMCAT ROOT"\conf\server ......

oracle´æ´¢¹ý³Ì

create or replace procedure inserttestdata
(
   v_count        in   number,
   v_startuserid  in   varchar2,
   v_returnval    out  number )
as
   v_opertime    ......

J2EEÓ¦ÓÃÖÐÓëOracleÊý¾Ý¿âµÄÁ¬½Ó

ÔÚJ2EEÓ¦ÓóÌÐò¿ª·¢ÖУ¬Ó¦ÓóÌÐòÓëÊý¾Ý¿âÁ¬½ÓµÄ½¨Á¢ÊÇÎÒÃǾ­³£Óöµ½µÄÎÊÌâÖ®Ò»¡£ÔÚÕâÀïÎÒÖ÷Ҫ̸̸ÔÚ±¾µØÓ¦ÓóÌÐòÖÐͨ¹ýOCI·½Ê½¡¢thin·½Ê½ºÍJdbcOdbcÇÅ·½Ê½Á¬½ÓOracleÊý¾Ý¿â£¬ÔÚiPlanet Application Server 6.5ºÍSun Java System Application Server 7ÖжÔOracleÊý¾Ý¿âÁ¬½Ó³ØµÄÅäÖÃÒÔ¼°Ó¦ÓÃÖÐÈçºÎ´ÓÁ¬½Ó³ØÖлñµÃÁ¬½Ó
Ò»¡¢±¾µ ......

LinuxÃüÁlsmod ÏÔʾÒÑÔØÈëϵͳµÄÄ£¿é

lsmod(list modules)
 
¹¦ÄÜ˵Ã÷£ºÏÔʾÒÑÔØÈëϵͳµÄÄ£¿é¡£
Óï¡¡¡¡·¨£ºlsmod
²¹³ä˵Ã÷£ºÖ´ÐÐlsmodÖ¸Á»áÁгöËùÓÐÒÑÔØÈëϵͳµÄÄ£¿é¡£Linux²Ù×÷ϵͳµÄºËÐľßÓÐÄ£¿é»¯µÄÌØÐÔ£¬Ó¦´ËÔÚ±àÒëºËÐÄʱ£¬ÎñÐë°ÑÈ«²¿µÄ¹¦Äܶ¼·ÅÈëºËÐÄ¡£Äú¿ÉÒÔ½«ÕâЩ¹¦ÄܱàÒë³ÉÒ»¸ö¸öµ¥¶ÀµÄÄ£¿é£¬´ýÐèҪʱÔÙ·Ö±ðÔØÈë¡£
·¶Àý£º
[root@lin ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ