DOSÏÂÈçºÎÁ¬½ÓÔ¶³ÌµÄOracle - Oracle / »ù´¡ºÍ¹ÜÀí
ÇëÎÊ£ºÎÒÔÚDOS´°¿ÚÏÂÈçºÎ½øÈë±ðÈË»úÆ÷ÉϵÄOracle°¡£¿ ¼ÙÈ磺¶Ô·½µÄIP£º192.168.1.88 Êý¾Ý¿âÃûΪ£ºorcl Óû§ÃûºÍÃÜÂ룺scott/tiger ÎÒÊÔÁËһϣºsqlplus scott/tiger@192.168.1.88:orcl, ûÓà ע£ºÎÒÓÃä¯ÀÀÆ÷£¨isqlplus)ÊÇ¿ÉÒÔ·ÃÎʵÄ
sqlplus scott/tiger@orcl ÕâÑù¾Í¿ÉÒÔÁË sqlplus scott/tiger@192.168.1.88:1521/orcl,ÒýÓà sqlplus scott/tiger@orcl ÕâÑù¾Í¿ÉÒÔÁË ËüÔõô֪µÀÄãÓõÄÊÇÄĄ̈»úÆ÷°¡£¿ 1LµÄ·½·¨¿ÉÒÔ 1§µÄ·½·¨¿ÉÒÔ£¡ ÅäÖÃtnsnames.oraÒýÓà ÒýÓà 2 Â¥ java3344520 µÄ»Ø¸´: sqlplus scott/tiger@orcl ÕâÑù¾Í¿ÉÒÔÁË ËüÔõô֪µÀÄãÓõÄÊÇÄĄ̈»úÆ÷°¡£¿ ÔÚtnsnames.oraÀïÅäÖÃÔ¶³ÌÊý¾Ý¿âÁ¬½ÓÐÅÏ¢ÒýÓà ÄãÒªÔÚ%ORACLE_HOME%\network\admin\tnsnames.oraÖÐÅäÖÃÒ»¸öÁ¬½Ó´®,Ôö¼ÓÒ»¸öÁ¬½Ó´® 192.168.1.88 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.88) (PORT = 1521) ) ¡¡ up 1£¬2Â¥µÄÓ¦¸Ã¶¼¿ÉÒÔ
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿ ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ.. ÒýÓà ¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql declare TYPE test_rec IS record( code varchar(10), name varchar(30) ); v_book test_rec; ......
oracleÊý¾Ý¿âÓÐÄÄЩ¶ÔÏó ÕâÎʵÃÌ«ÁýͳÁË,ÓÑÇé°ï¶¥. ÕâÊÇÒ»¸ö´óÎÊÌ⣬ºÜ´óµÄÎÊÌâ¡£ °ï¶¥...... ------------------------------------------------------------------------------ Blog£º http://b ......