oracle×Ô¶¯±¸·Ý½Å±¾ÉèÖÃÎÊÌâ
#set Oracle User ORA_OWNER=oracle Õâ¾äÊÇÉèÖÃoracleÓû§ÃûÂ𣿠#set Node Name Node_Name=¡¯hostname¡¯Õâ¾äÊÇÉèÖÃÖ÷»úÃûÂ𣿠#set the Backup FileName¡¯s date RQ=¡¯date+%F-%H-%M¡¯ ÕâÊÇÔõô¶¨ÒåµÄʱ¼ä£¿RQÊǵ÷¶Èʱ¼äÉèÖÃÂ𣿠----------------------------------------- OraUser=¡±oracle¡± OraUserHome=¡±/home/oracle¡± User=¡±sys as sysdba¡± ÕâЩÊÇʲôÒâ˼£¿ Pass=¡±123213¡± Buffer=¡±10240¡± ----------------------------------------
UPÒýÓà ----------------------------------------- OraUser=¡±oracle¡± OraUserHome=¡±/home/oracle¡± User=¡±sys as sysdba¡± ÕâЩÊÇʲôÒâ˼£¿ --×÷Ϊ³¬¼¶¹ÜÀíÔ±Óû§À´½øÐвÙ×÷ Pass=¡±123213¡± Buffer=¡±10240¡± ---------------------------------------- OraUser=¡±oracle¡±ÕâÊÇSIDµÄÉèÖÃÂ𣿠OraUserHome=¡±/home/oracle¡±Õâ²»ÊÇ$ORACLE_HOMEµÄÒâ˼°É¡£ÕâÀïÉèÖõÄÊÇʲôĿ¼ User=¡±sys as sysdba¡± ÕâÊÇÒÔsysdbaÀ´µÇ½Âð£¿ÎªÊ²Ã´²»Ö±½Óд³ÉµÇ½Ãûsys Pass=¡±123213¡± Buffer=¡±10240¡± Õâ¸öÊÇÉèÖõÄʲô£¿ OraUserHome=¡±/home/oracle¡±Õâ¸ö¾ÍÊÇOR
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬ -A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ 2009-9-29 12:12:12 µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
ÎÒдµÄÒ»¸öJob declare job1 integer; begin dbms_job.submit(job1, 'Sale_FinanceUseFee(4,null,null,null);', TRUNC(SYSDATE)+1.103, ......
±ÈÈ磺 ÓÐÕűíΪËùÓдúÀíÉÌÿÈÕ·¢Õ¹µÄ²»Í¬Æ·ÅƵÄÊýÁ¿£¨2008Äê¼ä£© ´úÀíÉÌID Æ·ÅÆ ÈÕÆÚ ÈÕ·¢Õ¹Á¿ 1111 a 20080101 ......