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

ÔÚ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

±§Ç¸£¬Ð´µÄ¿ìÁËЩ¡£¡£¡£



ÒýÓÃ
SQL code1¡¢×°ÍêÁ˾ÍÒѾ­ÓÐÊý¾Ý¿âÁË¡£2¡¢ÓÃlinuxµÄoracleÓû§µÇ½µ½Í¼ÐνçÃæÏµÍ³3¡¢´ò¿ªÒ»¸öÖÕ¶Ë4¡¢ÔÚÖÕ¶ËÀïÃæÇÃÏÂÃæµÄÃüÁîÆô¶¯Êý¾Ý¿â1)sqlplus/as sysdba2)startup5¡¢ÔÙ¿ªÒ»¸öÖÕ¶Ë£¬ÇÃÈëÈçÏÂÃüÁîÆô¶¯¼àÌýºÍoem1)Æô¶¯¼àÌý
      lsnrctl start2)Æô¶¯oem·þÎñ
      emctl start
    ×¢Òâoem·þÎñÆô¶¯ºó»áÓÐÒ»¸öÍøÖ·?-

ÇÃÈësqlplus / as sysdba Ëü˵ÊÇÎÞЧÃüÁî°¡

ÒýÓÃ
**********
¸üÕýһϣº
**********
  2)Æô¶¯oem·þÎñ
    emctl start dbconsole


Ïà¹ØÎÊ´ð£º

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

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

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

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

oracleÊý¾Ý²éѯÎÊÌâ

ÓÐ500ÍòÌõͨ»°¼Ç¼
  ±àºÅ ºÅÂë ±»½ÐºÅÂë ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä ͨ»°Ê±³¤
  1 10010 20020 12:00 12:01 ......

linuxÏÂCÓïÑÔ¿ª·¢oracleµÄÎÊÌâ¡£

Á½¸öÎļþ1.PC£¬1.inc
1.PCÓвÙ×÷oracleÊý¾Ý¿âµÄ ,1.incÒ²ÓвÙ×÷oracleÊý¾Ý¿â 
ÔÚÆäËûÊý¾ÝÖÐÈçinformix ÖÐ$include 1.inc¾Í¿ÉÒÔʹÓÃÁË
ÔÚORACLEÊý¾Ý¿âÖØ $include 1.inc²»¿ÉÓà EXEC SQL include 1.incÒ²²»¿É ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ