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

OracleµÄ³õʼ»¯²ÎÊýÎļþ

     oracleʵÀýÆô¶¯Ê±¶ÁÈ¡pfile²ÎÊýÎļþ£¬ÐÞ¸Äpfile³õʼ»¯²ÎÊýÎļþºó£¬±ØÐëÖØÐÂÆô¶¯ÊµÀý²ÅÄÜÉúЧ¡£ 
     pfile²ÎÊýÎļþÓëspfile²ÎÊýÎļþ¶¼ÊÇÓÃÀ´´æ·Å³õʼ»¯²ÎÊýµÄÎïÀíÎļþ£¬pfileÒÔÎı¾ÎļþµÄÐÎʽ´æ´¢£¬ÓŵãÊÇÒ×Óڲ鿴ÓëÐ޸ģ»spfileÒÔ¶þ½øÖƵÄÐÎʽ´æ´¢£¬ËäÈ»ÄÜʵÏÖÒÔʵÀý²ÎÊýµÄ¶¯Ì¬Ð޸쬵«²»ÄÜÖ±½ÓÐ޸ģ¬Ö±½ÓÐ޸ĻáËð»µspfile²ÎÊýÎļþ£¬´Ó¶øÒýÆðʵÀýÆô¶¯Ê§°Ü¡£
     pfileÎļþµÄĬÈÏÃû³ÆÎª init<SID>.ora
     spfileÎļþµÄĬÈÏÃû³ÆÎª  spfile<SID>.ora
     Á©ÎļþµÄλÖÃÔÚ  <$oracle_home>/product/10.2.1/db_1/dbs/
     ³õʼ»¯²ÎÊýÎļþµÄÓÅÏȼ¶Îª spfile<sid>.ora   ---->  spfile.ora ---->  init<SID>.ora
     ¿ÉÒÔʹÓà show parameter spfile ²é¿´µ±Ç°¿´ÕýÔÚʹÓõijõʼ»¯²ÎÊýÎļþÊÇÄĸö
spfileÓëpfileµÄ»¥Ïàͬ²½
create pfile from spfile  »ò
create pfile = <pfilename> from spfile = <spfilename>
create spfile from pfile »ò
create spfile = <spfilename> from pfile = <pfilename>
Ö»ÄÜÔÚÊý¾Ý¿â¹Ø±ÕµÄÇé¿öϽøÐÐcreate spfile²Ù×÷£¬ÇÒÎļþÃû²»ÄÜÓëÕýÔÚʹÓõÄÊý¾Ý¿âµÄspfileÏàͬ£¬·ñÔò»á´´½¨Ê§°Ü¡£


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

Oracleѧϰ±Ê¼Çժ¼2

    µ¥Ðк¯Êý   ·µ»ØÖµÖ»ÓÐÒ»¸ö
      
   ·Ö×麯Êý   ·µ»ØÖµÊǶàÌõ¼Ç¼
      group by
      sum
      avg         ......

Oracleѧϰ±Ê¼Çժ¼7

 ÓÃ;: <1>Ä£¿é»¯
<Àý×Ó> --¹«Ë¾µÄÔ±¹¤µÄ¹ÜÀí
         1.Ôö¼ÓÒ»¸öÔ±¹¤
         2.Ô±¹¤ÀëÖ°
Óô洢¹ý³ÌºÍº¯ÊýÀ´ÊµÏÖ
1.Ôö¼ÓÒ»¸öÔ±¹¤
create sequence seq1 start with 7935;
create or replace function insert ......

Oracle Job Óï·¨ºÍʱ¼ä¼ä¸ôµÄÉ趨

³õʼ»¯Ïà¹Ø²ÎÊýjob_queue_processes
alter system set job_queue_processes=39 scope=spfile;//×î´óÖµ²»Äܳ¬¹ý1000 ;job_queue_interval = 10 //µ÷¶È×÷ҵˢÐÂÆµÂÊÃëΪµ¥Î»
job_queue_process ±íʾoracleÄܹ»²¢·¢µÄjobµÄÊýÁ¿£¬¿ÉÒÔͨ¹ýÓï¾ä¡¡¡¡
show parameter job_queue_process;
À´²é¿´oracleÖÐjob_queue_processµÄÖµ¡ ......

OracleºÍTomcat¶Ë¿Ú³åÍ»

OracleºÍTomcat¶Ë¿Ú³åÍ»
Ô­Òò:
    Oracle 9i¿ªÊ¼£¬´´½¨Êý¾Ý¿âʱĬÈϰüº¬ÁËXDBÌØÐÔ¡£Ò»µ©Æô¶¯ÁËÊý¾Ý¿âºÍListener£¬Oracle XDBµÄhttp·þÎñ¾ÍÕ¼ÓÃ8080¶Ë¿Ú£¬¸ÕºÃºÍJBoss¡¢TomcatµÈĬÈ϶˿ڳåÍ»¡£
½â¾ö·½·¨
 1¡¢¸Ä¶¯tomcat¶Ë¿Ú£¬
´ò¿ªD:\Tomcat5\conf\server.xml£¬²éÕÒÈçÏÂÎı¾Î»Öãº
<!-- Def ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ