ÇóÖú£¡ÈçºÎ´ò¿ª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¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏ Errors in file /user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902: error in executing ODCIIndexStart() routine ORA-0 ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬ ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡ OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Â𣿠SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
--½¨Á¢Ò»¸ö°üÒÔ¶¨ÒåÒ»¸öÓαê create or replace package PK_test as type cur_test is ref cursor; end PK_test; --½¨Á¢Ò»¸ö¹ý³Ì,ͨ¹ýÊäÈëJOBID£¬·µ»ØÒ»¸ö±í¼Ç¼£¨Óα꣩! create or replace ......