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

ÐÞ¸Äoracle¼àÌý¶Ë¿Ú

1. ÐÞ¸Ä listener.ora ºÍtnsnames.ora ÕâÁ½¸öÎļþ:ADDRESS = (PROTOCOL = TCP)
(HOST = xxxx)(PORT = еĶ˿Ú))
3¡¢ ÐÞ¸Ä $ORACLE_HOME\hostname_sid\sysman\configϵÄemoms.propertiesÎÄ
¼þ:oracle.sysman.eml.mntr.emdRepPort=еĶ˿Ú
oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION\=
(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=xxx)(PORT\=еĶ˿Ú)))
(CONNECT_DATA\=(SERVICE_NAME\=xxx)))
4. ×îºó£¬»¹ÒªÐÞ¸Ä $ORACLE_HOME\hostname_sid\sysman\emdϵÄ
targets.xml:<Property NAME="Port" VALUE="еĶ˿Ú"/> 
sysman²»ÊÇoracleÓû§£¬Òò´Ë²»ÄÜÓÃalter user ×Ó¾äÐÞ¸ÄÃÜÂë¡£
Ð޸ķ½·¨ÊÇÒÔoemËùÊôÓû§µÇ½£¬È»ºóÔËÐиÃÓû§ÏµĴ洢¹ý³Ì£º
smp_maintenance.RESET_SYSMAN ¸Ã¹ý³Ì½«sysmanµÄÃÜÂëÖØÖÃΪoem_temp.
ÀýÈ磬Èç¹û´æ·ÅoemµÄÓû§ÊÇoem,ÃÜÂëÒ²ÊÇoem
ÔÚsqlplus ÖÐÖ´ÐУº
SQL> conn oem/oem;
SQL>exec smp_maintenance.RESET_SYSMAN;
Ô­ÒòÊÇÕâÑùµÄ: EM ÓÐ×Ô¼ºµÄÅäÖÃÎļþemoms.properties,
Äã´ò¿ªºó¾Í»á·¢ÏÖÕâЩ:
oracle.sysman.eml.mntr.emdRepPwdEncrypted=TRUE
oracle.sysman.eml.mntr.emdRepPwd=xxxx,xxxx,xxxx,xxxx
Õâ˵Ã÷OMSÆô¶¯µÄʱºòÒѾ­¶ÔSYSMANÓû§µÄÃÜÂë½øÐÐÁË
¼ÓÃÜ´¦Àí£¬ÄãÖ»ÔÚSQLPLUSÖÐÐ޸ģ¬EMÊÇÎÞ·¨ÖªµÀµÄ£¬
ÒòΪËü²»È¥¶ÁÊý¾Ý×ֵ䣬¶øÊǶÁ×Ô¼ºµÄÅäÖÃÎļþ
ÁíÍâ,ÔÚ$ORACLE_HOME/<hostname_sid>/sysman/emd Ŀ¼
Ï»¹ÓÐÒ»¸öÎļþtargets.xml,Õâ¸öÎļþÒ²ÒªÐ޸ġ£
¾ßÌåµÄÐ޸ķ½Ê½¿ÉÒԲο¼ÎÒµÄblog.
http://blog.itpub.net/493 (ºÃ¾Ãû¸üÐÂÁË£¬ºÇºÇ)
»òÕ߲ο¼EMµÄ¹Ù·½Îĵµ“ Advance Configuration "
Îĵµ±àºÅÊÇB12013-01.
¾ßÌåÕ½ÚÊÇ: µÚÁùÕµÚËĽÚ
"Changing the SYSMAN Password"


Ïà¹ØÎĵµ£º

ÔÚOracleÏ¿ª·¢Java³ÌÐòµÄ¾­µäÎÊÌâ½â´ð

 
ÎÊÌâÒ»£ºÈç±£¼ÓÔØJDBCÇý¶¯³ÌÐò£º
 
Õý³£ÎÒÃǼÓÔØÇý¶¯³ÌÐòÓÐÈý¸ö;¾¶£º
 
1.Class.forName(String)ÕâÏëµ±ÓÚclassLoaderÒ»¸öStringÖ¸¶¨µÄÀ࣬ÔÚ×°ÔØÊ±°Ñ¸ÃÇý¶¯³ÌÐòµÄ¾²Ì¬ÄÚÈݶ¼³õʼ»¯£¬ÆäʵÕâʱÇý¶¯³ÌÐòÀàµ÷ÓÃÁËDriverManager.registerDriver(driver)·½·¨¡£
 
2.ʹÓÃϵͳÊôÐÔ£ºSystem.getPro ......

MySQLÓëOracleÊý¾ÝÀàÐÍת»»


MySQL Data Type
Oracle Data Type
BIGINT
NUMBER(19, 0)
BIT
RAW
BLOB
BLOB, RAW
CHAR
CHAR
DATE
DATE
DATETIME
DATE
DECIMAL
FLOAT (24)
DOUBLE
FLOAT (24)
DOUBLE PRECISION
FLOAT (24)
ENUM
VARCHAR2
FLOAT
FLOAT
INT
NUMBER(10, 0)
INTEGER
NUMBER(10, 0)
LONGBLOB
BLOB, RAW
LONGTEX ......

MYSQLºÍORACLEµÄһЩ²Ù×÷Çø±ð

ÓкܶàÓ¦ÓÃÏîÄ¿, ¸ÕÆð²½µÄʱºòÓÃMYSQLÊý¾Ý¿â»ù±¾ÉÏÄÜʵÏÖ¸÷ÖÖ¹¦ÄÜÐèÇó£¬Ëæ×ÅÓ¦ÓÃÓû§µÄÔö¶à£¬Êý¾ÝÁ¿µÄÔö¼Ó£¬MYSQL½¥½¥µØ³öÏÖ²»¿°ÖظºµÄÇé¿ö£º
Á¬½ÓºÜÂýÉõÖÁå´»ú£¬ÓÚÊǾÍÓаÑÊý¾Ý´ÓMYSQLǨµ½ORACLEµÄÐèÇó£¬Ó¦ÓóÌÐòÒ²ÒªÏàÓ¦×öһЩÐ޸ġ£±¾ÈË×ܽá³öÒÔϼ¸µã×¢ÒâÊÂÏϣÍû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
1£® ×Ô¶¯Ôö³¤µÄÊý¾ÝÀàÐ ......

SQLServerºÍOracleµÄ³£Óú¯Êý¶Ô±È

SQLServerºÍOracleµÄ³£Óú¯Êý¶Ô±È
¡¡¡¡1.¾ø¶ÔÖµ
¡¡¡¡S:select abs(-1) value
¡¡¡¡O:select abs(-1) value from dual
¡¡¡¡2.È¡Õû(´ó)
¡¡¡¡S:select ceiling(-1.001) value
¡¡¡¡O:select ceil(-1.001) value from dual
¡¡¡¡3.È¡Õû£¨Ð¡£©
¡¡¡¡S:select floor(-1.001) value
¡¡¡¡O:select floor(-1.001) valu ......

¹ØÓÚoracleµ¼Èësqlserver´æÔÚµÄΨһË÷ÒýÎÊÌâ

ÎÒÔÚ°ÑoracleÊý¾Ýµ¼ÈësqlserverÖÐʱ£¬·¢ÏÖÔÚoracleÖÐ×ֶζ¨ÒåΪΨһË÷Òýʱ£¬²»Í¬¼Ç¼µÄ´Ë×Ö¶ÎÈç¹ûΪ¿Õ²»±»ÈÏΪÊÇÖØ¸´µÄ£¬µ«ÔÚsqlserverÖÐÈç¹û´Ë×Ö¶ÎΪΨһË÷Òý×ֶΣ¬²»ÔÊÐíÓÐ2¸öÒÔÉϵĿÕÖµ¡£ÓôÃÆ¡£ËùÒÔÖ»ºÃ½«sqlserverÖеÄΨһË÷Òý×Ö¶ÎÊÖ¹¤ÐÞ¸ÄΪ¼¸¸ö·Ç¿ÕµÄÖµ£¬µ«ÕâÑù³ÌÐò¿Ï¶¨Òª½øÐÐÐÞ¸ÄÁË¡£ÐèÒªÔÚ³ÌÐòÖÐΪ´Ë×Ö¶ÎÉèÖò»Öظ´ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ