Ò»¸öoracle SIDÅäÖÃÎÊÌâµÄ´¦Àí
ORA-24324: δ³õʼ»¯·þÎñ¾ä±ú
ORA-01041: ÄÚ²¿´íÎó, hostdef À©Õ¹Ãû²»´æÔÚ
¿´ÁËÒÔÏÂÎÄÕ£¬ÔòÐ޸쬵«Ð޸ĺóÎÞ·¨Æô¶¯listener£¬ÓÚÊÇÏëµ½ÔÚnet assistanceÖÐÐ޸ģ¬Íê³É£º
ÅäÖÃΪÒÔϲÅÄÜÕýÈ·Æô¶¯listener£º
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = G:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = G:\oracle\product\10.2.0\db_1)
(SID_NAME = orcl)
)
)
2ÔÂ3ÈÕ
SID config
ÕýÎÄ
oracle ÖÐstartup mountÎÞ·¨Æô¶¯·þÎñ(2009-08-26 23:08:11)
±êÇ©£ºÔÓ̸
½ñÌìÔÚʹÓÃoracleµÄrmanÃüÁîʱ£¬·¢ÏÖoracle ÖÐstartup mountÎÞ·¨Æô¶¯·þÎñ£¬ÔÚÍøÉÏÕÒÁ˰ëÌ죬ÕÒµ½ÁËÒ»¸ö·½·¨£¬»¹Ã»ÓÐÊÔÊÔ£¬ÏÈ·¢ÔÚÕâÀï¡£
²é¿´( 7 ) / ÆÀÂÛ( 1 ) / ÆÀ·Ö( 0 / 0 )
Êý¾Ý¿âshutdownºóstartupÆô¶¯Ê±±¨´íora£12514£ºTNS:¼àÌý³ÌÐòµ±Ç°ÎÞ·¨Ê¶±ðÁ¬½ÓÃèÊö·ûÖÐÇëÇóµÄ·þÎñ¡£
ÔÒò£º
·þÎñÆ÷¶ËµÄÕìÌýÆ÷ÖÐÒѾûÓÐÁËÄãÒªÁ¬½ÓµÄÀý³ÌÁË£¬ËùÒÔÄã¿Ï¶¨Á¬²»Éϰ¡¡£
½â¾ö°ì·¨£º
1.
ÔÚ·þÎñÆ÷¶ËµÄÕìÌýÆ÷ÖмÓÈ뾲̬ע²áʵÀý¾ÍÐУ¬ÔÚF:\oracle\product\10.2.0\db_1\NETWORK\ADMIN£¨¿ÉÄÜÄãµÄÅÌ·û»á²»Ò»Ñù£©ÖÐÕÒµ½listenser.oraÎļþ£¬´ò¿ª£¬ÔÚSID_LIST_LISTENERÖмÓÈëÒ»¸öSID_DESC,ÈçÏ£ºÆäÖÐhjgisΪʵÀýÃû¡£
#listener.ora Network Configuration File: F:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = hjgis)
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = hujian)(PORT = 1521))
)
)
2.
ÖØÐ¼ÓÔØÕìÌý¡£ÔÚ·þÎñÆ÷¶Ë£¬ÔÚ²Ù×÷ÃüÁîÌáʾ·ûÏ£º
C:\>lsnrctl
LSNRCTL
Ïà¹ØÎĵµ£º
·½°¸Ò»£º
ÐÂ×°ÁËϵͳºó£¬·¢ÏÖÔÚµ÷ÊÔ³ÌÐòʱTOMCATÌáʾ8080¶Ë¿ÚÒѱ»Õ¼Óã¬ÓÚÊÇÔËÐÐNETSTAT -ANO²é¿´¶Ë¿ÚʹÓÃÇé¿ö£¬·¢ÏÖ8080¶Ë¿Ú±»ORACLEµÄ¼àÌýÆ÷¸øÕ¼ÓÃÁË£¬ÓÚÊǽáºÏÉÏÍø²éµ½·½·¨£¬½«ORACLE XDBµÄHTTP·þÎñ¶Ë¿Ú¸Ä³É8081£¬ÎÊÌâ½â¾ö¡£
×ܽáһϿɽâ¾öµÄ·½ ......
trunc()º¯ÊýÓÐÁ½ÖÖÓ÷¨ 1£ººóÃæ¸úÈÕÆÚ 2£º ºóÃæ¸úÊý×Ö
A£º SELECT a.times,to_date(a.times,'yyyymmdd'),trunc(to_date(a.times,'yyyymmdd'),'month') from dmf_loan_limit a
ÏÔʾµÄ½á¹ûΪ£º
1 20080131 2008-1-31 2008-1-1
2 20080131 &nb ......
decode()º¯數ʹÓü¼ÇÉ
·Èí¼þ»·¾³£º
1¡¢Windows NT4.0+ORACLE 8.0.4
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORANT
·º¬Òå½âÊÍ£º
decode(Ìõ¼þ,Öµ1,·ÒëÖµ1,Öµ2,·ÒëÖµ2,...Öµn,·ÒëÖµn,ȱʡֵ)
¸Ãº¯ÊýµÄº¬ÒåÈçÏ£º
IF Ìõ¼þ=Öµ1 THEN
¡¡¡¡¡¡¡¡RETURN(·ÒëÖµ1)
ELSIF Ìõ¼þ=Öµ2 THEN
¡¡¡¡¡¡¡¡RETURN(·ÒëÖµ2)
......
Èç¹ûÊý¾ÝÎļþË𻵣¬»áÓöµ½1157 ºÍ 1110µÄ´íÎó¡£ÕâʱºòÐèÒª½éÖʻָ´Êý¾Ý¿â¡£
»Ö¸´Êý¾Ý¿âÐèÒªÓÐÏàÓ¦µÄ±¸·ÝºÍ±¸·ÝÒÔÀ´²úÉúµÄËùÓеĹ鵵ÈÕÖ¾ÎļþºÍÁª»úÈÕÖ¾Îļþ¡£
Èç¹ûÔÚmountµ½openµÄʱºò·¢ÏÖÆÕͨµÄÊý¾ÝÎļþË𻵣¬Êý¾Ý¿â»áÍ£ÁôÔÚmount״̬Ï£¬Õâʱºò¿ÉÒÔÖ´ÐÐalter database datafile x offline drop ºÍalter database open à ......
ÎÒÓõÄÊÇCentos5.4 DVD¹âÅ̰²×°µÄlinux²Ù×÷ϵͳ£¬°²×°linuxµÄʱºòÑ¡ÉÏ¿ª·¢¹¤¾ß£¬Xmanager,ÓëÊý¾Ý¿âÏà¹ØµÄ°ü¡£
²Ù×÷ϵͳ°²×°Íê³ÉÖ®ºóÐèÒª½øÐÐһϵÁеÄÅäÖòÅÄܰ²×°oracle10g£¬ÏÂÃæ°ÑÖ÷Òª²½Öè¼Ç¼ÏÂÀ´¡£
1.°²×°Íê²Ù×÷ϵͳ֮ºó»¹ÊÇÓÐЩ°üûÓа²×°£¬È»¶ø°²×°oracle10gµÄʱºòÐèÒªÓõ½£¬Ã»Óа²×°µÄ°üÓÐ:
libXp-1.0.0-8.i386.rp ......