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¿ÉÒÔ·þÎñ¶à¸ö¿Í»§¶Ë½ø³Ì)
¸üÏêϸµÄ¹Ù
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î
http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö
ÒýÓÃ
vStream := TMemorySt ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......
¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......