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

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 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

oracle - Oracle / »ù´¡ºÍ¹ÜÀí

oracleÊý¾Ý¿âÓÐÄÄЩ¶ÔÏó
ÕâÎʵÃÌ«ÁýͳÁË,ÓÑÇé°ï¶¥.

ÕâÊÇÒ»¸ö´óÎÊÌ⣬ºÜ´óµÄÎÊÌâ¡£


°ï¶¥......
------------------------------------------------------------------------------ 
Blog£º http://b ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ