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

ÇóÖú£¡ÈçºÎ´ò¿ªoracle 10g - Oracle / »ù´¡ºÍ¹ÜÀí

а²×°Á˸öoracle£¬µÚÒ»´ÎÓñȽÏÃÔ㣬¸ù±¾²»ÖªµÀÔõô´ò¿ª£¬´ò¿ªoracle SQL*PlusÊäÈ밲װʱµÄÓû§ÃûºÍÃÜÂë²»¶Ô£¬ÊäÈëÍøÉϲéµÄÓû§Ãû£ºSYSTEM ÃÜÂ룺MANAGER Ö÷»ú×Ö·û´®£ºTCP-LOOPBACK Ò²²»¶Ô£¬ÓÐûÓÐÄÇλÈÊÐÖÖªµÀ¡£Â鷳˵ϰ¡¡£¡£
ÏÈÔÚ·þÎñÆô¶¯ÏîÀïÃæÆô¶¯¡°OracleServiceORCL¡±
ÔÚÊäÈëÓû§¸úÃÜÂë:

²»¼ÇµÃÃÜÂëÕâÑù
"¿ªÊ¼---ÔËÐÐ--¡®ÊäÈ룺cmd¡¯--È»ºóÊäÈë sqlplus /nolog"

C:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚ¶þ 5ÔÂ 11 13:19:23 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect / as sysdba
ÒÑÁ¬½Ó¡£
SQL> alter user system identified by sys --°ÑÃÜÂë¸ÄΪsys 
  2 /

Óû§ÒѸü¸Ä¡£

È»ºóÔڵǽoracle SQL*Plus ÊäÈëÓû§¸úÃÜÂë




ÔÚ°²×°µÄʱºòÓÐÒ»¸öÑ¡ÔñÓû§ºÍÉèÖÃÃÜÂëµÄµØ·½¡£ÄÇÀï¿ÉÒÔ×Ô¼ºÉèÖÃÃÜÂëÈç¹ûûÓÐÉèÖõϰ¾ÍÊÇĬÈϵÄÃÜÂë
system/manager,Èç¹ûÄãÁ¬½Ó²»½øÈ¥¿ÉÄÜÊÇÄã¼àÌýÆ÷û¿ª»òÕßÊÇÊý¾Ý¿â·þÎñû¿ª£¬ÓÒ¼üÎҵĵçÄÔ-¹ÜÀí-·þÎñºÍÓ¦ÓóÌÐò-·þÎñ OracleOraDb10g_home1TNSListener¼àÌýÆ÷±ØÐëÒª¿ª

ÒýÓÃ

ÏÈÔÚ·þÎñÆô¶¯ÏîÀïÃæÆô¶¯¡°OracleServiceORCL¡±
ÔÚÊäÈëÓû§¸úÃÜÂë:

²»¼ÇµÃÃÜÂëÕâÑù
"¿ªÊ¼---ÔËÐÐ--¡®ÊäÈ룺cmd¡¯--È»ºóÊäÈë sqlplus /nolog"

C:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production o¡­¡­

 ÁíÍÆ¼öÄãÈ¥ ²¥²¼¿Í¡£
{{-


Ïà¹ØÎÊ´ð£º

oracle 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

oracleµÄ°²×°ºÍʹÓúÃÄѰ¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......

Ò»Ìõ SQL - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÐÕâÑùÒ»ÌõSQL
 Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a
 
ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃæ¶¼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ