Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

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

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

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

JavaÖ®¸¸À뿪Oracle£¬±¯Í´°¡£¡£¡ - Java / ·Ç¼¼ÊõÇø

¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......

oracle³õѧÕßÄãÇë½Ì - Oracle / »ù´¡ºÍ¹ÜÀí

--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê
create or replace package PK_test 
as 
type cur_test is ref cursor;
end PK_test;
--½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩!
create or replace ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ