ÔÚLinuxϰ²×°ÍêOracle10g£¬¸ÃÔõôÓ𡣿
ÔÚLinuxϰ²×°ÍêOracle10g£¬¸ÃÔõôÓ𡣿
ÎÒÏë´´½¨Ò»¸öÊý¾Ý¿â£¬ÔÚÔõô´´½¨°¡£¿
ÒÔ¼°ÎÒÏëÓÃͼÐλ¯¹¤¾ßÀ´²Ù×÷Oracle£¬¸ÃÔõô°ì£¿
SQL code:
1¡¢×°ÍêÁ˾ÍÒѾÓÐÊý¾Ý¿âÁË¡£
2¡¢ÓÃlinuxµÄoracleÓû§µÇ½µ½Í¼ÐνçÃæÏµÍ³
3¡¢´ò¿ªÒ»¸öÖÕ¶Ë
4¡¢ÔÚÖÕ¶ËÀïÃæÇÃÏÂÃæµÄÃüÁîÆô¶¯Êý¾Ý¿â
1)sqlplus / as sysdba
2)startup
5¡¢ÔÙ¿ªÒ»¸öÖÕ¶Ë£¬ÇÃÈëÈçÏÂÃüÁîÆô¶¯¼àÌýºÍoem
1)Æô¶¯¼àÌý
lsnrctl start
2)Æô¶¯oem·þÎñ
emctl start
×¢Òâoem·þÎñÆô¶¯ºó»áÓÐÒ»¸öÍøÖ·µÄÌáʾ£¬ÀûÓÃÕâ¸öÍøÖ·¾Í¿ÉÒÔͨ¹ýieÓÃͼÐνçÃæ²Ù×÷oracleÁË
˳Ðò²»Òª´íÁË£¬´íÁË»áÓÐÎÊÌâ¡£
**********
¸üÕýһϣº
**********
2)Æô¶¯oem·þÎñ
emctl start dbconsole
±§Ç¸£¬Ð´µÄ¿ìÁËЩ¡£¡£¡£
ÇÃÈësqlplus / as sysdba Ëü˵ÊÇÎÞЧÃüÁî°¡
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÓÐ500ÍòÌõͨ»°¼Ç¼
±àºÅ ºÅÂë ±»½ÐºÅÂë ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä ͨ»°Ê±³¤
1 10010 20020 12:00 12:01 ......
Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......