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

oracleÃüÁîÆô¶¯

ÎÒ°´ÊéÉÏ˵µÄÆô¶¯Êý¾Ý¿â£º
ËùÓзþÎñ¶¼Í£Ö¹Ê±
£¨1£©´ò¿ª¼àÌý£ºlsnrctl start
£¨2£©£ºsqlplus /nolog
£¨3£©,connect system/password as sysdba /*ÕâÒ»²½¾Í²»ÐÐÁË£¬±¨ERROR:ORA-12560: TNS: ЭÒéÊÊÅäÆ÷´íÎó*/
£¨4£©startup
Ϊʲôµ½µÚÈý²½¾Í²»ÐÐÁËÄØ£¬ÄѵÀ˵ÊéÉÏ´íÁËô£¬ÉÏÍø²éÁËÒ»ÏÂÓÃnet start oracleservicesid¾ÍÄÜÆô¶¯·þÎñ£¬
Æô¶¯·þÎñºÍÆô¶¯Êý¾Ý¿âÊÇÒ»Ñùô£¿ÎªÊ²Ã´ÓÃshutdown immediate¡¢normal¡¢abortµÈÃüÁî¹Ø±ÕÊý¾Ý¿âºóoracleservicesid·þÎñÈ´»¹ÊÇÆô¶¯µÄ ÄØ£¿

»¹ÓиöÎÊÌ⣺ÊéÉÏ˵ÓÃStartup nomountÆô¶¯
ÔÙÓà alter  database  mount 
      alter  database  open
¾Í¿ÉÒÔÍêÈ«Æô¶¯£¬¿ÉÊÇÎÒÓÃStartup nomountÆô¶¯ºóÔÙÊäÈëalter  database  mount °´»Ø³µÔÚµÚ¶þÐÐÏÔʾһ¸ö2ÔÙ°´»Ø³µÓÖ³öÒ»¸ösql>ºÃÏñÒ»µãû·´Ó¦£¬ÕâÊÇÔõô»ØÊ£¿

1.²»Ò»Ñù£»
2.©·ÖºÅ.


1. ½¨ÒéÂ¥Ö÷¿´ÏÂÕâÆ¬ÎÄÕ£¬¶ÔORACLE µÄÆô¶¯Ó¦¸Ã¾ÍÇå³þÁË.

Éî¿ÌÀí½âOracleÊý¾Ý¿âµÄÆô¶¯ºÍ¹Ø±Õ
http://blog.csdn.net/tianlesoftware/archive/2009/10/20/4704877.aspx

2. Â¥Ö÷Â¥µôÁË¡®£»¡¯£¬ ·ÖºÅ±íʾ½áÊø..


ÒýÓÃ
Ϊʲôµ½µÚÈý²½¾Í²»ÐÐÁËÄØ£¬ÄѵÀ˵ÊéÉÏ´íÁËô£¬ÉÏÍø²éÁËÒ»ÏÂÓÃnet start oracleservicesid¾ÍÄÜÆô¶¯·þÎñ
Æô¶¯·þÎñºÍÆô¶¯Êý¾Ý¿âÊÇÒ»Ñùô£¿ÎªÊ²Ã´ÓÃshutdown immediate¡¢normal¡¢abortµÈÃüÁî¹Ø±ÕÊý¾Ý¿âoracleservicesid·þÎñÈ´»¹ÊÇÆô¶¯µÄ ÄØ£¿


ÔÚwindowÏ£¬Æô¶¯·þÎñ³É¹¦£¬²»´ú±íoracleʵÀýÒѾ­openÁË¡£µ«ÊÇÒªÆ


Ïà¹ØÎÊ´ð£º

linux + oracleÓÃXP·ÃÎʲ»ÁË

ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬

-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......

PHP Á¬½ÓOracle ³ö´í

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

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ