oracle¸ü¸ÄÊý¾Ý¿âÃû
author:skate
time:2009/10/23
ÕâÁ½ÌìÒ»ÅóÓÑÎÊÈçºÎ¸ü¸ÄÊý¾Ý¿âÃû£¬ÓÚÊÇ×ö¸ö²âÊÔ£¬¼òµ¥¼Ç¼Ï£¬ÒÔ±ã˵Ã÷ÎÊÌâ
ÈçºÎÐÞ¸ÄÊý¾Ý¿âÃû£¨db_name)¼°ÊµÀýÃû(Instance_name or Service_name)
NidÊÇOracle´Ó9iR2¿ªÊ¼ÌṩµÄ¹¤¾ß£¬¿ÉÒÔÓÃÀ´¸ü¸ÄÊý¾Ý¿âÃû³Æ£¬¶øÎÞÐèͨ¹ý֮ǰÖؽ¨¿ØÖÆÎļþµÈ·±Ëö·½Ê½¡£
nidÊÇ×Ô´øµÄ¹¤¾ß£¬ÔÚoracle_home/binĿ¼ÖÐ.ÒÔÏ·½·¨¼ÙÉèµÇ½µ½Êý¾Ý¿â±¾»ú×ö¡£
Ä¿µÄ£ºÔÚ±¾ÀýÖУ¬¼ÙÉèÔÀ´µÄÊý¾Ý¿âÃûΪorcl,Òª¸Ä³Édborcl,ÔʵÀýÃû(service_name,instance_name)orcl,Òª¸Ä³Édborcl.
²½Öè¸ÅÊö£º
1.¼ì²éµ±Ç°µÄ²ÎÊýÇé¿ö
2.shutdownÊý¾Ý¿â£¬È»ºómountÊý¾Ý¿â
3.ÔËÐÐnidÃüÁî
4.¸ü¸Ä²ÎÊýÎļþpfile.ora(db_name,instance_name)
5.¼ì²â¸ü¸ÄÇé¿ö
6.Èç¹ûÊÇwindowsƽ̨£¬ÒªÐ޸ķþÎñ
7.Ð޸ļàÌý·þÎñ
C:\Documents and Settings\Administrator>sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚËÄ 10ÔÂ 22 11:56:33 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Á¬½Óµ½:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
1. ²é¿´¸ü¸ÄÇ°µÄÏàÓ¦Ãû³Æ
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name &
Ïà¹ØÎĵµ£º
Oracle ÈýÖÖ¼¯ºÏÊý¾ÝÀàÐ͵ıȽÏ:
PL/SQLÖÐûÓÐÊý×éµÄ¸ÅÄËûµÄ¼¯ºÏÊý¾ÝÀàÐͺÍÊý×éÊÇÏàËƵġ£ÔÚ7.3ÒÔÇ°µÄ°æ±¾ÖÐÖ»ÓÐÒ»ÖÖ¼¯ºÏ£¬³ÆΪPL/SQL±í£¬ÔÚÕâÖ®ºóÓÖÓÐÁ½ÖÖ¼¯ºÏÊý¾ÝÀàÐÍ:ǶÌ×±íºÍvarray¡£ÆäÖÐvarray¼¯ºÏÖеÄÔªËØÊÇÓÐÊýÁ¿ÏÞÖƵģ¬index_by±íºÍǶÌ×±íÊÇûÓÐÕâ¸öÏÞÖƵġ£index-by±íÊÇÏ¡ÊèµÄ£¬Ò²¾ÍÊÇ˵ϱê¿ÉÒÔ²»Á¬Ðø ......
Ô´´ÓÚ2007Äê04ÔÂ12ÈÕ£¬2009Äê10ÔÂ15ÈÕǨÒÆÖÁ´Ë¡£
windows xp£¬Êý¾Ý¿âoracle 10.2.0¡£1
ûÓб¸·Ý£¬»ù±¾ÉÏÊÇĬÈÏ°²×°£¬ºÃÏñ»¹²»Êǹ鵵ģʽ
Ö¢×´£ºsqlplusÖ»ÓÐsysdbaÓû§ÄܽøÈ¥£¬ÆäËûÓû§½øÈ¥Ò»¸Å±¨£ºora-01033£ºoracleÕýÔÚ³õʼ»¯»ò¹Ø±Õ
¶øÇÒsysdbaÓû§½øÈ¥Ö®ºóÄÜÖ´ÐÐselect sysdate from dual£¬µ«ÊÇÖ´ÐÐselect use ......
Ò»¡£ÓÐÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾ÎļþµÄ±¸·Ý1.·þÎñÆ÷ÖØ×°Á˲Ù×÷ϵͳ£¬oracleÒ²ÖØ×°ÁË¡£Èç¹ûÖØ×°µÄoracleºÍÒÔÇ°Ë𻵵ÄÊý¾Ý¿âÊÇһģһÑùµÄ½á¹¹£¬ÄÇô´ËʱµÄ»Ö¸´ÊDZȽϼòµ¥µÄ¡£
1£©É¾³ýµôн¨Êý¾Ý¿âµÄËùÓÐÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾Îļþ¡£CopyÔÊý¾Ý¿âµÄÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾Îļþµ½¶ÔӦĿ¼Ï¡£
  ......
±¾Îijö×Ô¡¶Íø¹ÜÔ±ÊÀ½ç¡·20002ÄêµÚ8ÆÚ“¹ÊÕÏÕï¶Ï”À¸Ä¿
Ó²¼þ»·¾³£º SUN250·þÎñÆ÷£¬1G CPU , 512M Ram , 18G SCSIÓ²ÅÌ
ϵͳ»·¾³£º SUN Solaris 2.7
·þÎñ»·¾³£º Oracle 8.1.6
ÖÜÎåÎÒ·¢ÏÖOracleÊý¾Ý¿âÔÚÖ´ÐгÌÐòʱµÄÏìÓ¦ÌرðÂý£¬Õû¸öÊý¾Ý¿â·þÎñËùÔÚµÄSUN Solaris 2.7ϵͳҲÊÇÕâÑù£¬ÎÞÂÛÔËÐÐʲô³ÌÐò¶¼±ÈÍù³£ÂýÁ˺ ......
ORACLEÊý¾Ý¿âÓÐÁ½À౸·Ý·½·¨¡£µÚÒ»ÀàΪÎïÀí±¸·Ý£¬¸Ã·½·¨ÊµÏÖÊý¾Ý¿âµÄÍêÕû»Ö¸´£¬µ«Êý¾Ý¿â±ØÐëÔËÐÐÔڹ鵲ģʽÏ£¨ÒµÎñÊý¾Ý¿âÔڷǹ鵲ģʽÏÂÔËÐУ©£¬ÇÒÐèÒª¼«´óµÄÍⲿ´æ´¢É豸£¬ÀýÈç´Å´ø¿â£»µÚ¶þÀ౸·Ý·½Ê½ÎªÂß¼±¸·Ý£¬ÒµÎñÊý¾Ý¿â²ÉÓôËÖÖ·½Ê½£¬´Ë·½·¨²»ÐèÒªÊý¾Ý¿âÔËÐÐÔڹ鵲ģʽÏ£¬²»µ«±¸·Ý¼òµ¥£¬¶øÇÒ¿ÉÒÔ²»ÐèÒªÍⲿ´æ ......