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

QTPÁ¬½Óoracle²¢²Ù×÷Êý¾Ý¿âµÄ·½·¨

QTPÁ¬½Óoracle²¢²Ù×÷Êý¾Ý¿âµÄ·½·¨ÕâÀïÒÔoracle  9iΪÀý×Ó£¬ÆäËûµÄÊý¾Ý¿âÁ¬½Ó·½·¨ÊÇÏàͨµÄ¡£
a.Ê×ÏÈÒªÔÚ±¾»ú½¨ÒéODBCÊý¾ÝÔ´£¬Õâ¸öÊôÓÚ»ù±¾²Ù×÷£¬ÕâÀï²»½²£¬Ìø¹ý£»
b.»ñÈ¡oracleµÄÁ¬½Ó´®µÄ·½·¨£¬ÔÚ±¾µØÐ½¨Ò»¸ö.txtÎļþ£¬ÐÞ¸ÄÀ©Õ¹ÃûÃû*.udl£¬Ë«»÷*.udlÎļþ£¬´ò¿ªÊý¾Ý¿âÁ´½ÓÊôÐÔ£¬¶¨Î»µ½“Ìṩ³ÌÐò”Ñ¡ÏÔ¿¨£¬Ñ¡ÖÐ oracleµÄÁ¬½Ó  oracle provider for OLE DB,µã»÷ÏÂÒ»²½£¬ÊäÈëÊý¾ÝÔ´£¬Êý¾Ý¿âÓû§ÃûÒÔ¼°ÃÜÂ룬µã»÷²âÊÔÁ¬½Ó£¬È»ºóÓÃUE»ò¼Çʱ¾´ò¿ª*.udlÎļþ£¬oracleµÄÁ¬½Ó´®ÒѾ­Éú³ÉÁË£¬ÀýÈç
Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=test;Data Source=192.168.13.19
ÒÔÉϾÍÊÇudlÎļþÉú³ÉµÄoracleÁ¬½Ó´®
ÏÖÔÚÎÒÃÇÐèÒªÊÖ¶¯Ìí¼ÓÒ»¸öoracleÁ¬½Ó´®µÄÃÜÂë×Ö¶ÎPassword£¬²åÈëµ½User IDºóÃæ£¬ÖмäÓ÷ֺŸô¿ª£»
¼´ Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=test;;Password=test;Data Source=192.168.13.19
c.ÔÚqtpÖÐÀ´Á¬½ÓÊý¾Ý¿â
Dim Cnn  '¶¨ÒåÒ»¸öÊý¾Ý¿âÁ¬½Ó´®
Set Cnn = CreateObject("ADODB.Connection")
Cnn.ConnectionString ="Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=test;Password=test;Data Source=192.168.13.19 "
Cnn.Open   '´ò¿ªÊý¾Ý¿âÁ¬½Ó
If Cnn.State = 0 Then      'ÅжÏÊý¾Ý¿âÁ¬½ÓÊÇ·ñ³É¹¦
     Reporter.ReportEvent micFail, "testing", "Á¬½ÓÊý¾Ý¿âʧ°Ü"
else
     Reporter.ReportEvent micPass, "testing",   "Á¬½ÓÊý¾Ý¿â³É¹¦"
End If
 
if Cnn.State<> 0  then
  
    Set Rs=CreateObject("ADODB.Recordset")    'Éú³É¼Ç¼¼¯¶ÔÏó
 strsql ="Select  *    from t_sys_user"   '´ÓÊý¾Ý¿âÖвéѯt_sys_userµÄËùÓмǼ
        Rs.Open strsql ,Cnn,1,3   'Ö´ÐÐsqlÓï¾ä£¬¼Ç¼¿ÉÒÔ×ÔÓÉÒÆ¶¯£¬µ¥Êý¼Ç¼´¦ÓÚÖ»¶Áģʽ
        ydl=Rs("USER_ID")         'È¡µÃ×Ö¶ÎΪUSER_IDµÄ¼Ç¼£¬Óα궨ÒåÔÚµÚÒ»ÐУ¬ËùÒÔÈ¡µÃµÄÊǸÃ×Ö¶ÎËùÔÚÐеĵÚÒ»ÐÐÊý¾Ý
 msgbox  ydl
    &nbs


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

oracle sqlplus Óëdos ÖÐÎÄÂÒÂë

1.SQL> select * from v$nls_parameters;
PARAMETER                           VALUE
----------------------------------- ------------------------------------
---------- ......

oracle exp imp ³õ̽

Êý¾Ýµ¼³ö£º
 1 ½«Êý¾Ý¿âTESTÍêÈ«µ¼³ö,Óû§Ãûsystem ÃÜÂëmanager µ¼³öµ½D:\daochu.dmpÖÐ
   exp system/manager@TEST file=d:\daochu.dmp full=y
 2 ½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ¼³ö
   exp system/manager@TEST file=d:\daochu.dmp owner=(system,sys)
 3 ½«Êý¾Ý¿âÖеıíin ......

28.5 OracleͼÐλ¯¹ÜÀí¹¤¾ß——OEM

28.5  OracleͼÐλ¯¹ÜÀí¹¤¾ß——OEM
OracleÆóÒµ¹ÜÀíÆ÷£¨Oracle Enterprise Manager£¬OEM£©ÊÇOracleÌṩµÄÒ»¸ö»ùÓÚWebµÄͼÐλ¯Êý¾Ý¿â¹ÜÀí¹¤¾ß¡£Í¨¹ýOEM£¬Óû§¿ÉÒÔÍê³É¼¸ºõËùÓеÄÔ­À´Ö»ÄÜͨ¹ýÃüÁîÐз½Ê½Íê³ÉµÄ¹¤×÷£¬°üÀ¨Êý¾Ý¿â¶ÔÏó¡¢Óû§È¨ÏÞ¡¢Êý¾ÝÎļþ¡¢¶¨Ê±ÈÎÎñµÄ¹ÜÀí£¬Êý¾Ý¿â²ÎÊýµÄÅäÖ㬱¸·ÝÓë»Ö¸´£¬ÐÔÄÜ ......

¡¶Í¿Ä¨Oracle£­Èý˼±Ê¼ÇÖ®Ò»²½Ò»²½Ñ§Oracle¡·³ö¯ÊÖ¼Ç

¡öÀÖÖª
  “Ë­ÊÇË­µÄË­”£¬ÕâÊÇΨÃÀÖÐ͸×ÅÓÄÔ¹µÄÒ»Ê׸裬µ«È´»áĪÃûµØµçµ½ÐÄÖеÄÀÛ¡£Ñ§Ï°Ì«ÀÛ£¬¹¤×÷Ì«ÀÛ£¬Éú»îÌ«ÀÛ£¬Á¬¸èÃûÌý×Ŷ¼ÄÇôÀÛ¡£
²ß»®µÄµÚÒ»±¾Êé¡¶´óÏó——Thinking in UML¡·£¬´ÓÔË×÷£¬µ½ÉÏÊУ¬µ½³©Ïú£¬µ½¾­µä£¬µ½¹úÄÚUMLµÚÒ»Ê飬һÄêÖ®ÄÚʵÏÖÁËÒ»¸ö¸öûÓÐÃιýµÄÃÎÏë¡£ÕýÈçÕâÊ׸èÖеÄÒ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ