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

Oracle Æô¶¯µÄÎÊÌâ

oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html

Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..

cmd
sqlplus /nolog
connection /as sysdba
select instance_name,host_name,thread#,status from v$instance
Àý³Ì±êʾ£¬Ö÷»úÃû£¬±êʾÖØ×éÏ̺߳Š£¬±êʾÀý³Ì״̬
ÖØÐÂ×°ÔØ
startup force


Êý¾Ý¿âºÍ¼àÌý¶¼ÖØÆôÒ»ÏÂ


Ïà¹ØÎÊ´ð£º

PHP Á¬½ÓOracle ³ö´í

<?php
  getenv("ORACLE_HOME");
  $conn=ocilogon("test","test","test_db");
  if($conn)  
  echo success;  
&nb ......

Çë½Ì¹ØÓÚoracleµÄ×Ô¶¨Ò庯ÊýµÄÎÊÌâ

create or replace function GetWorkBeginTime()
  return date is
  myDate    date;
begin
  myDate := trunc(sysdate-1)+8/24;
  return myDate;
end;

......

ÓÐʲôÊéÊǽ²¹ØÓÚOracleµÄЧÂʵÄ

´ó¼ÒÍƼöÒ»ÏÂ
Oracle Database 10g Performance Tuning Tips & Techniques
ÎÒÂòµÄ£¬¸Õ¿ªÊ¼¿´

Database Performance Tuning Guide and Reference

oracle¹«Ë¾×Ô¼ºµÄdocument£¬Ã¿¸ö´ó°æ±¾¶¼ÓÐ×Ô¼ºÒ»Ì ......

¹ØÓÚORACLE×Ö·û¼¯

ÏÂÃæÕâ¶Î»°:
¿Í»§ÖÕ¶Ë×Ö·û¼¯£¬nls_lang»·¾³±äÁ¿×Ö·û¼¯£¬Êý¾Ý¿âʹÓõÄ×Ö·û¼¯¡£ÆäÖУ¬¿Í»§Öն˸÷ÖÖ¸÷Ñù£¬±ÈÈçwindowsÏÂcmd£¬unix/linuxÏÂterminal/console,ÉõÖÁÈçtoadµÈ¹¤¾ßÒ²¿ÉÒÔÀí½âΪһ¸öÖնˡ£ÎÒÃÇʹÓÃwindows ......

OracleתÒå·ûºÅ

CREATE OR REPLACE PROCEDURE proc_ct_11(
  quhao in varchar
)
IS
  CURSOR ct_filter
  IS
      SELECT        br_number, br_company ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ