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

ÎÞ·¨Æô¶¯ Oracle ¼àÌýÆ÷ - Oracle / »ù´¡ºÍ¹ÜÀí

ÔÚ Linux ϰ²×° Oracle ºó£¬Ò»ÇÐÔËÐÐÕý³£¡£
¿ÉÊǵڶþÌìÖØÆô Linux ºó£¬ Oracle µÄ¼àÌýÆ÷Ôõô¶¼Æð²»À´¡£´íÎóÐÅÏ¢ÊÇ£º

TNS-12537: TNS:connection closed
TNS-12560: TNSrotocol adapter error
  TNS-00507: Connection closed
  Linux Error: 29: Illegal seek

ÔÚÍøÉÏÕÒ²»µ½½â¾ö·½·¨¡£
listener.ora ÖеÄÅäÖÃÊÇ£º
########################################
LISTENER =
  (DESCRIPTION_LIST =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
  )
  )

ADR_BASE_LISTENER = /home/oracle_11/app
###########################################

/etc/hosts µÄÐÅÏ¢ÊÇ£º
###########################################
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
###########################################
ÄãûÓÐhostnameô£¿

½«localhost»»³ÉÊý¾Ý¿â·þÎñÆ÷µÄipµØÖ·ÊÔÊÔ¿´°É£¡

ÒýÓÃ

½«localhost»»³ÉÊý¾Ý¿â·þÎñÆ÷µÄipµØÖ·ÊÔÊÔ¿´°É£¡


¸Ä¹ý~~²»Ðа¡~~~

ÒýÓÃ

ÄãûÓÐhostnameô£¿


ʲôÒâ˼

ͻȻ¼äÕâÑùµÄÂð£¿ÓиĹýʲô¶«Î÷Âð£¿

ÒýÓÃ

ͻȻ¼äÕâÑùµÄÂð£¿ÓиĹýʲô¶«Î÷Âð£¿


ÊǵÄ~~~È


Ïà¹ØÎÊ´ð£º

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

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

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

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

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

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

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

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

¸ß·ÖÇó½âOracleÊý¾Ý¿âµÄÁéÒìʼþ - Oracle / ¿ª·¢

½ñÌìÓöµ½Ò»¸öºÜ¹îÒìµÄÎÊÌâ¡£ÎÒÔÚÒ»ÕűíÖÐÐÂÔöÁËÒ»¸ö×ֶΡ£È»ºóÓÃÈçϽű¾¸üÐÂÕâ¸ö×ֶεÄÖµ£º
SQL code:

update ibp_fund_information_tab set yield = 7.4520 where fund_code = '040003' and info_date = ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ