sqlplusÁ¬½ÓoracleÊý¾Ý¿âÔÀí£¿
sqlplusÁ¬½ÓOracleÊý¾Ý¿âµÄÕû¸öÁ÷³Ì£¬
ÀýÈç sqlplus /nolog
conn system/oracle£¨ÃÜÂ룩
Õâ¸öÁ¬½ÓOracleµÄÕû¸ö»úÖÆÊÇʲô£¨×¢ÖØÓÚÁ¬½ÓµÄÔÀíÉÏ£©
Èç¹ûÓÐ˶®»òÓÐÏà¹ØÄÚÈݸøÓèÌáʾµÄ»°£¬±¾È˽«Öطָм¤£¡
sqlplus ¾ÍÒ»¹¤¾ß£¬ËüÄÜÁ¬½Óµ½Êý¾Ý¿â²¢½øÐÐÏàÓ¦µÄ²Ù×÷¡£¼ÈÈ»Êǹ¤¾ß£¬ÎÒÃÇÖªµÀÔõôÓúÃËü¾Í¿ÉÒÔÁË£¬Ã»±ØҪȥÑо¿ËüµÄÔÀí¡£µ±È»Èç¹ûÊÇ×öÕâ¿é¹¤¾ßÑо¿µÄ³ýÍâ.
ÄѲ»³ÉÂ¥Ö÷ҲҪдһ¸öÕâÀàÐ͵Ť¾ß?
http://download.oracle.com/docs/cd/B19306_01/network.102/b14212/architecture.htm#i1040997
這個連½Ó¿ÉÄÜÓÐ幫Öú
SQL code:
ÀýÈç sqlplus /nolog
conn system/oracle£¨ÃÜÂ룩
ÄǾÍÄÃÄãÕâ¸öÀý×ÓÀ´Ëµ°É
sqlplus /nolog Äã¿ÉÒÔÀí½âΪ¾ÍÊÇÔÚ²Ù×÷ϵͳÉÏÔËÐÐÁËSQLPLUSÕâ¸öÓ¦ÓóÌÐò ÒòΪ´Ëʱ²¢Ã»ÓÐÁ¬½Óµ½Êý¾Ý¿â
conn system/oracle Õâ¾ä»°¾ÍÊÇÖ´ÐÐÁ¬½ÓÁË
ORACLEµÄÁ¬½Ó·ÖÁ½ÖÖ·½Ê½ SHARED SERVER ºÍDEDICATED SERVER
Èç¹ûÊÇSHARED SERVER ·½Ê½Ï ÄÇô¿Í»§¶Ë·¢ÆðÒ»¸öÁ¬½ÓÇëÇó ·þÎñÆ÷¶ËµÄLISTENER»á¼àÌýµ½Á¬½ÓÇëÇó ½ÓÏÂÀ´°ÑÓû§Á¬½Óת½Óµ½Ò»¸ö½ÐDISPATCHERÉÏÈ¥ Ö®ºó¿Í»§¶Ë½ø³ÌºÍSERVER PROCESSµÄ½»»¥¾Íͨ¹ýÕâ¸öDISPATCHERÀ´½øÐÐ
Èç¹ûÊÇDEDICATED SERVER·½Ê½ ÄÇôµ±¿Í»§¶Ë·¢ÆðÒ»¸öÁ¬½ÓÇëÇóʱ ·þÎñÆ÷¶ËµÄLISTENER»áÅÉÉú³öÒ»¸öרÓнø³ÌÓë¿Í»§¶Ë½øÐнøÐн»»¥(´Ë´¦Ö®ËùÒÔ˵רÓÐÊǺÍÇ°Ò»ÖÖģʽSHARED SERVER ¶Ô±È¶øÑÔ ¡£ÒòΪһ¸öDISPATCHER¿ÉÒÔ·þÎñ¶à¸ö¿Í»§¶Ë½ø³Ì)
¸üÏêϸµÄ¹Ù
Ïà¹ØÎÊ´ð£º
1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?
2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......
ÎÒдµÄÒ»¸öJob
declare
job1 integer;
begin
dbms_job.submit(job1,
'Sale_FinanceUseFee(4,null,null,null);',
TRUNC(SYSDATE)+1.103, ......
´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£ ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......
ÐÖµÜ Í¼¹ÒÁË¡£
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......