Oracleѧϰ±Ê¼Ç
×î½ü¿ÕÏÐʱ¼ä½Ï¶à£¬¿ªÊ¼Ñ§Ï°OracleÊý¾Ý¿â֪ʶ¡£ÏÂÎÄÊǶÔOracleÊý¾Ý¿âÏà¹Ø¸ÅÄîµÄһЩ±Ê¼Ç¡£
³õѧOracle£¬Àí½âOracleʵÀý¡¢OracleÊý¾Ý¿âºÍOracle·þÎñÆ÷µÈÃû´ÊÊõÓïÊǺÜÖØÒªµÄ¡£
ÊõÓï½âÊÍ:
OracleʵÀý/OracleÊý¾Ý¿â
Ò»°ãOracleÊý¾Ý¿â(Oracle Database)¿ÉÒÔ·ÖΪÁ½²¿·Ö¡£
ʵÀý(Instance)
ʵÀýÊÇÒ»¸ö·Ç¹Ì¶¨µÄ¡¢»ùÓÚÄÚ´æµÄ»ù±¾½ø³ÌºÍÄÚ´æ½á¹¹¡£µ±·þÎñÆ÷¹Ø±Õºó£¬ÊµÀýÒ²¾Í²»´æÔÚÁË¡£ÊµÀýÊÇÒ»¸öÂß¼ÉϵĸÅÄî¡£
Êý¾Ý¿â(Database)
Êý¾Ý¿âÖ¸µÄÊǹ̶¨µÄ¡¢»ùÓÚ´ÅÅ̵ÄÊý¾ÝÎļþ¡¢¿ØÖÆÎļþ¡¢ÈÕÖ¾Îļþ¡¢²ÎÊýÎļþºÍ¹éµµÈÕÖ¾ÎļþµÈ¡£Çë¼Çס´Ë´¦ËùÌáÎļþ£¬ÕâЩÎļþ¶¼ÐèÒªºÃºÃµÄѧϰÁ˽⡣
Ò»°ãÇé¿öÏ£¬OracleÊý¾Ý¿â¶¼ÊÇÒ»¸öÊý¾Ý¿â°üº¬Ò»¸öʵÀý
Ïà¹ØÎĵµ£º
½ñÌìÔÚnet managerÅäÖñ¾µØ·þÎñʱ³öÏÖÕâÑùµÄÎÊÌâ
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
ÔÚgoogleÉÏËÑË÷µÃµ½Èô¸É´ð°¸£¬×ÜÊDz»¶Ô£¬ºóÀ´ÔÚͬʵİïÖúϽâ¾öÁËÎÊÌ⣬ÏÖÔÚ×ܽáһϸú´ó¼Ò·ÖÏí¡£
1¡¢Ñ¡Öб¾µØ——·þÎñÃüÃû£¬ÔÚ±à¼Öд´½¨
2¡¢ÊäÈënet·þÎñÃû£¬×¢ÒâÕâÊÇ ......
ÔÚOracle8i»òÒÔÉÏ°æ±¾ÖУ¬¿ÉÒÔ´´½¨ÒÔÏÂÁ½ÖÖÁÙʱ±í£º
1¡£»á»°ÌØÓеÄÁÙʱ±í
CREATE GLOBAL TEMPORARY <TABLE_NAME> (<column specification>)
ON COMMIT PRESERVE ROWS£»
2¡£ÊÂÎñÌØÓеÄÁÙʱ±í
CREATE GL ......
°²×°×¼±¸£º
ÏÂÔØÎļþ
l Oracle Database 10g Release 2(10.2.0.1) Software
½âѹÎļþ
½âѹÎļþÃüÁ
unzip 10201_database_linux32.zip
½âѹºóµÄÎļþ¼Ð¿ÉÄÜ“database”»ò“db/Disk1”
HostsÎļþ
ÔÚ/etc/hosts ÎļþÖаüº¬Ò»¸öÍêÕûºÏ· ......
NVL(Expr1,Expr2)Èç¹ûExpr1ΪNULL£¬·µ»ØExpr2µÄÖµ£¬·ñÔò·µ»ØExpr1µÄÖµ
NVL2(Expr1,Expr2,Expr3)Èç¹ûExpr1ΪNULL£¬·µ»ØExpr2µÄÖµ£¬·ñÔò·µ»ØExpr3µÄÖµ
NULLIF(Expr1,Expr2)Èç¹ûExpr1ºÍExpr2µÄÖµÏàµÈ£¬·µ»ØNULL£¬·ñÔò·µ»ØExpr1µÄÖµ ......
×°Á˸öOracle 10g£¬È´·¢ÏÖÕÒ²»µ½ÆóÒµ¹ÜÀíÆ÷ÁË¡£ÔÀ´10gÓÖÉý¼¶Á˹ÜÀí¹¤¾ß£¬²»ÔÙ²ÉÓÃ8i, 9iµÄÄÇЩJava¹¤¾ßÁË£¬¶øÊÇÓëʱ¾ã½øµØ¸ÄÓÃÁËWeb·½Ê½¡£°´ÕÕÍøÉϵķ½·¨£ºhttp://»úÆ÷µÄIPµØÖ·:5500/em£¬»¹ÊÇûÓÐÁ¬ÉÏ¡£ÄѵÀ¶Ë¿ÚºÅ²»¶ÔÂð£¿
²é¿´Oracle 10g°²×°Ä¿Â¼installϵÄreadmeÎļþ£º
ÏÔʾ£º
Êý¾Ý ......