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

oracle»·¾³±äÁ¿ÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒ¿ÉÒÔÔËÐÐsqlplus£¬µ«ÎÒÔÚshell½Å±¾ÀïдÉÏexport ORACLE_HOME=/oracle/products/10.2/dbÕâ¾ä£¬ÔÚÖ´ÐÐÕâ¸ösh½Å±¾¾Í±¨´íÁË£º
Error 6 initializing SQL*Plus
Message file sql<lang.1>msb not found
SP2-0750:You may need to set ORACLE_HOME to your Oracle software directory
ÎÒ×Ô¼ºµÄ.bash_profileÀïдµÄÊÇexport ORACLE_HOME=/oracle/products/10.2/db£¬
ÎÒ¿´/home/oracleÀïµÄ.bash_profileÎļþдµÄexport ORACLE_HOME=/oracle/products/us11/10db,ºÍÎÒ»·¾³±äÁ¿ÀïÉèÖõIJ»Ò»Ñù£¬ÎÒÒ²Ð޸IJ»ÁËÕâ¸öÎļþ£¬¾Í°Ñ×Ô¼ºÓû§ÏµÄ.bash_profileÀïµÄORACLE_HOME¸Ä³É=/oracle/products/us11/10dbÕâ¸ö£¬µ«Ö´ÐÐsh½Å±¾»¹ÊDZ¨ÄǸö´íÎó£¬Çó¸ßÊÖ½â¾ö£¡
¸ÄÁË.bash_profileÖ®ºó£¬µÃsourceһϡ£»òÕßÔٵǼһϲÅÓÐЧ¡£


ÕÒ²»µ½Îļþ£¬µ±Ç°ÊÇʲôÓû§£¬ÓÐûȨÏÞ£¿
Message file sql<lang.1>msb not found

ÒýÓÃ
ÕÒ²»µ½Îļþ£¬µ±Ç°ÊÇʲôÓû§£¬ÓÐûȨÏÞ£¿
Message file sql<lang.1>msb not found

ÎÒ¿´Ä¿Â¼ÏÂÓÐÕâ¸öÎļþ£¬Óû§ÊÇroot´´½¨µÄ

¶¥ÆðÀ´£¬°ïæ½â¾öһϰ¡£¬ÊDz»ÊÇÁ½¸öORACLE_HOME²»Ò»Öµ¼Öµİ¡£¿

ÒýÓÃ

¶¥ÆðÀ´£¬°ïæ½â¾öһϰ¡£¬ÊDz»ÊÇÁ½¸öORACLE_HOME²»Ò»Öµ¼Öµİ¡£¿


ÏÔÈ»°¡

ÒýÓÃ
ÒýÓà 4 Â¥ xiaolengbingtian µÄ»Ø¸´:

¶¥ÆðÀ´£¬°ïæ½â¾öһϰ¡£¬ÊDz»ÊÇÁ½¸öORACLE_HOME²»Ò»Öµ¼Öµİ¡£¿


ÏÔÈ»°¡

µ«ÎÒÕâ¸öÓû§Ã»°ì·¨¸Ä/home/oracleĿ¼ÏµÄ.bash_profileÎļþ°¡£¬ÎÒÖ»ÄܸÄ×Ô¼ºÄ¿Â¼ÏµÄ.bash_prof


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle ´æ´¢¹ý³ÌÖÐÓ¦ÓÃÊÂÎñµÄÎÊÌâ - Oracle / ¿ª·¢

SQL code:

CREATE OR REPLACE PROCEDURE usp_refreshTopN IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ