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

Connecting Oracle with MS


This article shows how Oracle's Heterogeneous Services can be configured to allow a database to connect to a Microsoft Access database using standard databases links. The method described can be used to connect to MS-Access from about any platform - Unix/ Linux or Windows.
MS-Access 2003 and Oracle 10g Release 1 are used to illustrate the concepts. However, this procedure should work with Oracle 8i, 9i and 10g databases, as well as various versions of MS-Access.
Step 1: Prepare the MS-Access environment
If you do not have a MS-Access environment, start by installing the required software and create a test table.
Step 2: Define ODBC connectivity
Use the ODBC Administrator Utility to define a local System DSN that can be used to connect to the Access database (same machine). Ensure that the correct *.MDB database file is selected.

Step 3: Prepare the Oracle Environment
Install the Oracle Database Server software on the same machine where MS-Access is installed.
NOTE: It is not sufficient to only install Client Software, as we require an Oracle Net Listener and the Heterogeneous Services (ORACLE_HOME\hs directory) software to be installed as well.
Step 4: Configure and Start the Oracle Listener
Configure the Oracle Listener on the Windows machine. Here is a sample LISTENER.ORA entry that can be used. Change the HOST, PORT and ORACLE_HOME entries to match your setup. You may also use a different SID_NAME if required.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = my_windows_machine_name)(PORT = 1521))
)
)
)
SID_LIST_LISTENER=
(SID_LIST =
(SID_DESC =
(SID_NAME = hsodbc)
(ORACLE_HOME = c:\Oracle\Ora101)
(PROGRAM = hsodbc)
)
)
Stop and start the listener service or from the command line:
C:\> lsnrctl stop
C:\> lsnrctl start
Step 5: Configure Oracle HS:
Edit the ORACLE_HOME\hs\admin\inithsodbc.ora file and add your ODBC System


Ïà¹ØÎĵµ£º

Oracle ¿éÇå³ý(block cleanout)


½ñÌìÔÚÍøÉÏ¿´µ½Ò»Æª¹ØÓÚBLOCK CLEANOUT²»´íµÄÎÄÕ£¬ËäÈ»ÀïÃæµÄÓиö±ðµØ·½±È½ÏÄѶ®£¬¿É»¹ÊÇÏÈת¹ýÀ´£¬µÈÒԺ󶮵öàһЩÁË×Ô¼ºÒ²×ö×öʵÑé²Ù×÷²Ù×÷¡£
=========================================================
Oracle £¨block cleanout£©
CleanoutÓÐ2ÖÖ£¬Ò»ÖÖÊÇfast commit cleanout,ÁíÒ»ÖÖÊÇdelayed block cleanout. ......

Oracle±í¿Õ¼äÉè¼ÆÀíÄî

SQL ServerÊý¾Ý¿âÓëOracleÊý¾Ý¿âÖ®¼ä×î´óµÄÇø±ðÒªÊô±í¿Õ¼äÉè¼Æ¡£OracleÊý¾Ý¿â¿ª´´ÐÔµØÌá³öÁ˱í¿Õ¼äµÄÉè¼ÆÀíÄÕâΪOracleÊý¾Ý¿âµÄ¸ßÐÔÄÜ×ö³öÁ˲»¿ÉÄ¥ÃðµÄ¹±Ïס£¿ÉÒÔÕâô˵£¬OracleÖкܶàÓÅ»¯¶¼ÊÇ»ùÓÚ±í¿Õ¼äµÄÉè¼ÆÀíÄî¶øÊµÏֵġ£
¡¡¡¡µäÐÍÓ¦ÓÃÒ»£º¿ØÖÆÓû§ËùÕ¼Óõıí¿Õ¼äÅä¶î¡£
¡¡¡¡ÔÚһЩ´óÐ͵ÄÊý¾Ý¿âÓ¦ÓÃÖУ¬ÎÒÃÇÐèÒª¿Ø ......

ORACLE PL/SQL ´¥·¢Æ÷(trigger)ѧϰ±Ê¼Ç

1¡¢´¥·¢Æ÷µÄ¸ÅÄî
´¥·¢Æ÷Ò²ÊÇÒ»ÖÖ´øÃûµÄPL/SQL¿é¡£´¥·¢Æ÷ÀàËÆÓÚ¹ý³ÌºÍº¯Êý£¬ÒòΪËüÃǶ¼ÊÇÓµÓÐÉùÃ÷¡¢Ö´ÐкÍÒì³£´¦Àí¹ý³ÌµÄ´øÃûPL/SQL¿é¡£Óë°üÀàËÆ£¬´¥·¢Æ÷±ØÐë´æ´¢ÔÚÊý¾Ý¿âÖв¢ÇÒ²»Äܱ»¿é½øÐб¾µØ»¯ÉùÃ÷¡£
¶ÔÓÚ´¥·¢Æ÷¶øÑÔ£¬µ±´¥·¢Ê¼þ·¢ÉúµÄʱºò¾Í»áÏÔʽµØÖ´Ðиô¥·¢Æ÷£¬²¢ÇÒ´¥·¢Æ÷²»½ÓÊܲÎÊý¡£
 
´´½¨´¥·¢Æ÷µÄÓï·¨È ......

log4j ¼Ç¼ÈÕÖ¾·ÅÔÚoracleÖÐ

Ò»¸ödbÀà ÀàËÆÓÚjdbcµÄÇý¶¯ºÍÁ´½ÓÅäÖÃ
  package com.assi;
import org.apache.log4j.jdbc.JDBCAppender;
public class DB extends JDBCAppender {
     public DB(){
         this.setDriver("oracle.jdbc.driver.OracleDriver"); 
& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ