oracle ÅäÖø߼¶¸´ÖÆ»·¾³Óöµ½µÄÎÊÌâ
1¡¢ÔÚ±¾»ú69ÉÏ´´½¨Êý¾Ý¿âorcl £¬global_name=orcl£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to orcl.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊý¾Ý¿âÃûΪorcl.us.oracle.com
2¡¢ÔÚÐé»ú188ÉÏ´´½¨Êý¾Ý¿âviotest£¬global_name=viotest£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to viotest.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊý¾Ý¿âÃûΪviotest.us.oracle.com
3¡¢¶¨Òå»úÆ÷A£º188 »úÆ÷B£º69
4¡¢°´ÕÕ²Ù×÷²½ÖèÍê³Éºó£¬ÔÚ»úÆ÷AÉϲåÈëÊý¾Ýʱ±¨´í
ora-04067:ûÓÐÖ´ÐУ¬stored procedure "wcms.Test$pr"²»´æÔÚ
ora-01085:ÑÓ³Ùrpcµ½“wcms.test$rp.rep_insert"֮ǰµÄ´íÎó
ora-02063:½ô½Ó×Å2 lines(Ô´ÓÚorcl)
5¡¢ÔÚ»úÆ÷AÉϲ鿴dba_repcatlog
select * from dba_repcatlog ·¢ÏÖ±íÖÐÓмǼ£¬ÇÒ״̬ΪreadyºÍawait_callback,ÆäÖУº
ready:±íʾÇëÇó×¼±¸±»Ö´ÐÐ
await_callback:Ö»³öÏÖÔÚÖ÷Ì嶨ÒåÕ¾µãÉÏ£¬±íʾÕýÔڵȴýÆäËûµÄÖ÷Õ¾µãÖ´ÐÐÇëÇó²¢ÇÒ·µ»Ø½á¹û
6¡¢ÔÚ»úÆ÷BÉϲ鿴dba_repcatlog·¢ÏÖBÖмǼµÄ×°Ìá°¸¾ùΪready£¬²¢ÇÒÓëAÖÐawait_callbackµÄ¼Ç¼һһ¶ÔÓ¦¡£
È»ºóÈç¹û³¤Ê±¼ä´¦ÓÚready״̬£¬Ôò¿ÉÒÔÊÖ¶¯Ö´ÐÐdbms_repcat.do_deferred_repcat_admin´æ´¢¹ý³ÌÀ´Ö´ÐÐÇëÇó£¬ÓÚÊÇÔÚ»úÆ÷BÉÏÖ´ÐÐexecute dbms_repcat.do_deferred_repcat_admin(gname=>'mygroup')£¬È»ºódba_repcatlogÖÐÎ޼ǼÁË£¬ÖØÐÂÔÚAÉÏÖ´ÐвåÈëÓï¾ä£¬³É¹¦¡£
ºóÀ´¾¹ý·ÖÎö£¬·¢ÏÖdbms_repcat.do_deferred_repcat_admin('"MYGROUP"', FALSE);µÄjobµÄ¼ä¸ôʱ¼äÊÇ10·ÖÖÓ£¬¾ÍÊÇÔÚÅäÖÃÍêºóÐèÒª¸ôÊ®·ÖÖӲŻáÖ´ÐÐdo_deferred_repcat_admin£¬Ò²¾ÍÊÇ˵Èç¹ûÔÚÊ®·ÖÖÓºóÔÚAÖÐÖ´ÐвåÈëÓï¾äÓ¦¸Ã²»»á³ö´í¡£
ÔÚAÉϲåÈëÊý¾Ý£¬ÔÚBÉϲéѯ½á¹ûÕýÈ·£¬µ«ÊÇÔÚBÉϲåÈëÊý¾Ý£¬È´³ö´í¡£±¨£º
ORA-23326: ûÓÐÒÖÖÆ¶ÔÏó×é "PUBLIC"."MYGROUP"
ÍøÉϲé×ÊÁÏ£¬ÄÚÈÝÈçÏ£º
ÅäÖÃÍêºó£¬×´Ì¬Îª QUIESCEDµÄ½áµã±ØÐë±äΪNORMAL²ÅÄÜDML¡£·ñÔòÖ»ÄÜˢжø²»Äܸü¸Ä£¬Èç¹û·¢²¼DMLÔò»áÊÕµ½£º
14:51:04 ">repadmin@rt>insert into test_user.account values (11);
insert into test_user.account values (11)
ORA-23326: ûÓÐÒÖÖÆ¶ÔÏó×é "PUBLIC"."REP"
ÔÚ»úÆ÷BÉϲéѯ¸´ÖÆ×éµÄ״̬
select gname,master,status from dba_repgroup;
GNAME &nbs
Ïà¹ØÎĵµ£º
ACCESSÊý¾Ý¿â
1:CodeSmithÑ¡ÖÐÁ´½ÓÀàÐÍÊÇ£ºADOXSchema
2:ÎÞÃÜÂëµÄAccessÁ´½ÓΪ£º
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\hh\db.mdb;
3:ÓÐÃÜÂëµÄAccessÁ´½Ó£º
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\hh\db.mdb;
Jet OLEDB:Database Password=1111
SqlÊý¾Ý¿â
server=192.1.1.14;User ID=test; ......
¸ü¸Äoracle Listener ÅäÖãºD:\Oracle\moon\product\11.1.0\db_1\NETWORK\ADMIN Ŀ¼֮Ï£ºListener.oraÎļþ½øÐÐÅäÖãº
# listener.ora Network Configuration File: d:\Oracle\moon\product\11.1.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SI ......
Ê×ÏÈÄãÒªÓÐtomcat,»¹ÒªÓÐoracle jdbcµÄjarµµµÈ»·¾³.
µÚÒ»²½: дJSP
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@(des ......
ÏîÄ¿ÖÐÓÐÉæ¼°´æ´¢¹ý³Ì¶Ô×Ö·û´®µÄ´¦Àí£¬ËùÒԾͽ«ÔÚÍøÉϲéÕÒµ½µÄ×ÊÁÏ»ã×Ü£¬×öÒ»¸öÐÅϢƴ½ÓʽµÄ×ܽᡣ
ÒÔÏÂÐÅÏ¢¾ùÀ´×Ô»¥ÁªÍø£¬Ìù³öÀ´Ò»Ôò×Ô¼º±£´æÒÔ´ýÒÔºóʹÓã¬Ò»Ôò¹©´ó¼Ò·ÖÏí¡£
×Ö·ûº¯Êý——·µ»Ø×Ö·ûÖµ
ÕâЩº¯ÊýÈ«¶¼½ÓÊÕµÄÊÇ×Ö·û×åÀàÐ͵IJÎÊý(CHR³ýÍâ)²¢ÇÒ·µ»Ø×Ö·ûÖµ.
³ýÁËÌØ±ð˵Ã÷µÄÖ®Íâ,ÕâЩº¯Êý´ó²¿·Ö·µ» ......
ÔÚOracle¹ØÓÚʱ¼äÊôÐԵĽ¨±í
Example:
create table courses(
cid varchar(20) not null primary key,
cname varchar(20) not null,
ctype integer,
ctime date DEFAULT SYSDATE,
cscore float not null
)
insert into courses values('ss01','.NET',0,TO_DATE('2009-8-28','yyyy-mm-dd'),94)
insert into course ......