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

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¿ÉÒÔ·þÎñ¶à¸ö¿Í»§¶Ë½ø³Ì)

¸üÏêϸµÄ¹Ù


Ïà¹ØÎÊ´ð£º

OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......

½èˮԴÈËÆø£¡oracle jobÎÊÌ⣡ÔÚÏßµÈ

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103, ......

visual c#ÎÞ·¨Á¬½Óoracle£¿£¿£¿

´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺

δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£ ......

¹òÇó lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
¸½Í¼Æ¬ ......

ssh oracle Á¬½Ó


Ðֵܠ ͼ¹ÒÁË¡£

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ