Oracle 10gÖиúEMÓйصÄÎÊÌâ½â¾ö·½·¨
Oracle 10gÖеÄEM²ÉÓÃWebµÄÐÎʽÀ´¹ÜÀíÊý¾Ý¿â¼°Ïà¹Ø·þÎñ£¬µ«Ê¹Óùý³ÌÖлáÅöµ½Ò»Ð©¸úEMÓйصÄÎÊÌ⣬¸ù¾ÝͬÐеÄÌáʾ¼°±ÊÕßµÄʵ¼Ê¾Ñ飬½øÐÐÁËһЩ¹éÄÉ£¬Ï£Íû¶ÔÏà¹Ø°®ºÃÕßÓÐËù°ïÖú£º
£¨1£©Êý¾Ý¿â¿ØÖÆÌ¨Æô¶¯ºó£¬¿´µ½1£©Êý¾Ý¿âʵÀýÎÞÐÅÏ¢2£©¼àÌý³ÌÐòΪ״̬Ϊ²»¿ÉÓÃ3£©µ½ÊµÀýµÄ´úÀíÁ¬½Ó״̬Ϊ²»¿ÉÓá£
ÎÊÌâ·ÖÎö£º
´Ëʱ·þÎñ¸ÕÆô¶¯£¬»¹Ã»Óе½Î»
½â¾ö°ì·¨£º
¹ý»áÔÙˢС£´Ëʱ¿ÉÄܻῴµ½1£©Êý¾Ý¿âʵÀýÓÐÏà¹ØÐÅÏ¢2£©¼àÌý³ÌÐòÓÐÐÅÏ¢µ«×´Ì¬Îª¹Ø±Õ3£©µ½ÊµÀýµÄ´úÀíÁ¬½Ó״̬Ϊʧ°Ü£¬²¢ÌáʾORA-12541: TNS: ÎÞ¼àÌý³ÌÐò (DBD ERROR: OCIServerAttach)¡£ÔÒò¿ÉÄÜÊǼàÌý·þÎñûÆô¶¯¡£
£¨2£©Io Òì³£: The Network Adapter could not establish the connection
ÎÊÌâ·ÖÎö£º
ÔڸıäÁËip»ò¼ÆËã»úÃûµÄÇé¿öϳöÏÖ£¬Ò»°ãÊǼàÌý·þÎñÓÐÎÊÌâ¡£
½â¾ö°ì·¨£º
µÚÒ»²½¡¢ÓÃemca -config dbcontrol dbÃüÁî´ÓÐÂÅäÖÃÒ»ÏÂemµÄdatabase control£»
µÚ¶þ²½¡¢ÔÚieÖÐÊäÈëhttp://oracl_hostname:5500/em/£¨ÊÇ5500¶Ë¿Ú£¬¶ø²»ÊÇ1158¶Ë¿Ú£©¿´¿´ÊÇ·ñÔËÐÐÕý³££¬Èç²»Õý³££¬½Ó×Ű´ÎÊÌ⣨3£©µÄ½â¾ö·½·¨½øÐд¦Àí¡£
£¨3£©¶ÔÓÚ¶àÍø¿¨£¬»ò¸Ä±äipµÄÇé¿ö£¬¿ØÖÆÌ¨³öÏÖÈçÏÂÇé¿ö£º
1£©¼àÌý³ÌÐòTNS-12541: TNS: ÎÞ¼àÌý³ÌÐò
2£©µ½ÊµÀýµÄ´úÀíÁ¬½ÓORA-12541: TNS: ÎÞ¼àÌý³ÌÐò (DBD ERROR: OCIServerAttach)
½â¾ö°ì·¨£º
ÐÞ¸ÄNetwork Configuration File: £¥ORACLE_HOME£¥\network\admin\ϵÄtnsnames.oraºÍlistener.ora, °ÑÆäÖеÄHOST=ºóµÄÖ÷»úÃû»òip¸ÄΪµ±Ç°µÄÖ÷»úÃû»òip£¬²¢ÖØÐÂÆô¶¯¼àÌý·þÎñ¡£Ö®ºóˢпØÖÆÌ¨Ò³Ã棬»á¿´µ½¼àÌý³ÌÐòÒѾÆô¶¯£¬µ«¿ÉÄÜ»á³öÏÖÏÂÃæµÄÌáʾ“ORA-12505: TNS: ¼àÌý³ÌÐòµ±Ç°ÎÞ·¨Ê¶±ðÁ¬½ÓÃèÊö·ûÖÐËù¸ø³öµÄ SID (DBD ERROR: OCIServerAttach)”£¬Ã»¹ØÏµ£¬¶àˢм¸´Î¼´¿É¿´µ½µ½ÊµÀýµÄ´úÀíÁ¬½Ó³É¹¦µÄÐÅÏ¢¡£
£¨4£©java.lang.Exception: IOException in sending Request :: Connection refused: connect
ÎÊÌâ·ÖÎö£º
¿ØÖÆÌ¨ÉÏˢеÄʱºò³£¼û£¬ÔÒò²»Ï꣬ºÃÏñûÓÐʲôӰÏì¡£
½â¾ö°ì·¨£º
Àä´¦Àí£¨^_^£©¡£
£¨5£©Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=LHL)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))
ÎÊÌâ·ÖÎö£º
¿ÉÄÜÊÇÊý¾Ý¿âʵÀýûÓÐ
Ïà¹ØÎĵµ£º
SAPÓëORACLEµÄÇø±ð·ÖÎö¼°¶Ô±È[ת]
ĿǰÔÚERPÒµ½çÖдæÔÚÁ½¸ö¾Þãµ——SAP µÄ ECC ¼° ORACLE µÄ EBS £¬ÕâÁ½¸ö´óÐÍERP½â¾ö·½°¸¼¸ºõÕ¼¾ÝÁËÊÀ½çÉϸ÷¸ö²»Í¬ÐÐÒµµÄ´óÐÍÆóÒµµÄÐÅϢϵͳÊг¡£¬ËùÒÔÕÆÎÕÁ½Õ߯äÒ»µÄÈ˱ã¿É»ñµÃ´óÐ͹ÜÀíÐÅϢϵͳҵ½çÖеİë±Ú½É½¶ø²»¶¯£¬ÎÞÂÛÄãÊÇ´ÓÊÂSAP»òORACLE £¬Á˽âÁ½ÕßµÄÇø±ðÊǷdz£ÓбØÒª ......
Ŀ¼
Ò»¡¢¸ÅÊö
¶þ¡¢Ó²¼þƽ̨´î½¨
Èý¡¢Redhat As4 update2°²×°ÅäÖÃ
ËÄ¡¢Oracle 10g°²×°ÅäÖÃ
Îå¡¢Red Hat Cluster Suite°²×°ÅäÖÃ
Áù¡¢ÏµÍ³Çл»²âÊÔ
Æß¡¢³£ÓÃÃüÁî
Ò»¡¢¸ÅÊö
»ÆµºÊпª·¢Çø²ÆÕþ¾Ö±¾´Î²ÉÓÃÁ½Ì¨IBM X3850£8664·þÎñ
Æ÷¡¢
һ̨DS4300ÅÌÕ󣬯½Ì¨²ÉÓÃRedhat As4 update2 ½áºÏcluster suite£¬²¿ÊðOracle
......
ÊÕ²Ø×ÔijЩ¸ßÊÖµÄ×ܽᣬ²»¸Ò¶ÀÏí£¬ÓëÓÐÔµÀ´´ËÕß¹²Ïí¡£
-----------------------------------------------------------------------------------
Oracle×Ö·û¼¯ÎÊÌâ×ܽá
¾³£ÓÐͬÊÂ×ÉѯoracleÊý¾Ý¿â×Ö·û¼¯Ïà¹ØµÄÎÊÌ⣬ÈçÔÚ²»Í¬Êý¾Ý¿â×öÊý¾ÝÇ¨ÒÆ¡¢Í¬ÆäËüϵͳ½»»»Êý¾ÝµÈ£¬³£³£ÒòΪ×Ö·û¼¯²»Í¬¶øµ¼ÖÂÇ¨ÒÆÊ§°Ü»òÊý¾Ý¿âÄÚÊý¾Ý±ä³ ......
ORACLE º¯Êý¿ª·¢
1¡¢½¨Á¢º¯ÊýµÄÓï·¨£º
CREATE [OR REPLACE] FUNCTION º¯ÊýÃû
[ (arg1 [mode] datatype[,........])] --µ±Ö¸¶¨²ÎÊýÊý¾ÝÀàÐÍʱ£¬²»ÄÜÖ¸¶¨Æä³¤¶È¡£modeÖµ£ºIN¡¢OUT¡¢IN OUT£¬µ±mode δָ¶¨Ê±£¬±íʾΪIN
RETURN datatype ......
ÔµÆðÒ»¸ö±í¿Õ¼äÌ«´ó,ɾ³ýÊý¾ÝºóÓÉÓÚÎļþβ±»ÓÃ,ÎÞ·¨resize,´òËã°ÑËùÓбí¿Õ¼äÉϵĶÔÏómoveµ½Ò»¸öÁÙʱ´æ´¢µÄ±í¿Õ¼ä×öÕûÀí¡£
moveÒ»¸ö±íµ½ÁíÍâÒ»¸ö±í¿Õ¼äʱ,Ë÷Òý²»»á¸ú×ÅÒ»Æðmove£¬¶øÇÒ»áʧЧ¡££¨LOBÀàÐÍÀýÍ⣩±ímove£¬ÎÒÃÇ·ÖΪ£º
*ÆÕͨ±ímove
*·ÖÇø±ímove
*LONG,LOB´ó×Ö¶ÎÀàÐÍmoveÀ´½øÐвâÊÔºÍ˵Ã÷¡£
Ë÷ÒýµÄmove£¬ÎÒÃÇÍ ......