28.4.3 ¼ì²âOracleÊý¾Ý¿â״̬
28.4.3 ¼ì²âOracleÊý¾Ý¿â״̬
OracleÆô¶¯ºó£¬Îª¼ì²âOracle·þÎñµÄÔËÐÐÊÇ·ñÕý³££¬¿ÉÒÔÖ´ÐÐpsÃüÁî¼ì²éÏà¹ØµÄOracle·þÎñ½ø³Ì£¬Ò²¿ÉÒÔͨ¹ýOracleËùÌṩµÄÃüÁî½øÐмì²é¡£¾ßÌå½éÉÜÈçÏÂËùʾ¡£
£¨1£©Ö´ÐÐpsÃüÁî²é¿´Êý¾Ý¿â½ø³ÌÇé¿ö¡£
ps -ef | grep oracle
£¨2£©ÔÚsqlplusÖÐÖ´ÐÐÃüÁî²é¿´Êý¾Ý¿â״̬¡£
$ export ORACLE_SID=orcl //ÉèÖÃORACLE_SID»·¾³±äÁ¿
$ sqlplus /nolog //Ö´ÐÐsqlplusÃüÁî
SQL*Plus: Release 11.1.0.6.0 - Production on Wed Oct 29 16:27:36 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> conn sys@orcl as sysdba //Á¬½ÓÊý¾Ý¿â
Enter password:
Connected.
SQL> select open_mode from v$database; //Ö´ÐÐSQL²é¿´Êý¾Ý¿âµÄ´ò¿ª·½Ê½
OPEN_MODE
----------
READ WRITE //“READ WRITE”±íʾÊý¾Ý¿â״̬Õý³£
Èç¹ûÁ¬½ÓÊý¾Ý¿âʱ¿´µ½ÈçÏÂÌáʾ£¬ÄÇô±íʾÊý¾Ý¿â²¢Î´Æô¶¯¡£
SQL> conn sys as sysdba
Enter password:
Connected to an idle instance. //Êý¾Ý¿âδÆô¶¯
£¨3£©Ö´ÐÐlsnrctl statusÃüÁî²é¿´ÍøÂç¼àÌý³ÌÐòµÄ״̬£¬Õý³£Çé¿öÏÂÓ¦¸ÃÄܹ»¿´µ½ÈçÏÂÌáʾÐÅÏ¢¡£
$ lsnrctl status //²é¿´oracle¼àÌý³ÌÐòµÄ״̬
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 29-OCT-2008 16:35:11
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=demoserver)(PORT=
1521)))
STATUS of the LISTEN
Ïà¹ØÎĵµ£º
ÏÈ×°ÁËÊý¾Ý¿â£¬ÓÃnetµ÷ÊÔµÄʱºòûÓÐÎÊÌ⣬µ«ÊÇÉú³ÉÍøÕ¾ºó£¬ÔÚÁ¬½ÓÊý¾Ý¿âµÄʱºòÌáʾ˵¿Í»§¶ËµÄ°æ±¾Ì«µÍ£¨Òâ˼¾ÍÊÇÕâ¸ö£©£¬ºóÓÖ×°ÁËÒ»¸ö9iµÄ¿Í»§¶Ë£¬Ö®ºó¾Í°ÑÏà¹Ø·þÎñ¸Ä³ÉÊÖ¶¯£¬NÌìÖ®ºó·¢ÏÖÊý¾Ý¿â²»ÄÜÕý³£Æô¶¯¡£
Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracl ......
28.1 Oracle 11g¼ò½é
¾¹ýÁËÈýÄêµÄ×¼±¸£¬Oracle£¨¼×¹ÇÎÄ£©¹«Ë¾ÓÚ2007Äê7ÔÂ12ÈÕÔÚÈ«Çò·¶Î§ÄÚͬ²½ÍƳöÁËÆä×îа汾µÄÊý¾Ý¿â²úÆ·——Oracle 11g¡£ÐµÄOracleÊý¾Ý¿âÈÔÈ»ÒÔg×÷Ϊ°æ±¾ºó׺£¬ÒÔ´ú±íÕâÊÇÒ»¸ö°üº¬ÁËÍø¸ñ¼ÆËã¼¼ÊõµÄÊý¾Ý¿âÈí¼þ£¨Oracle×Ô10°æ±¾¿ªÊ¼ÒÔg×÷Ϊ°æ±¾ºó׺£¬¶øÔÚÕâ֮ǰÊÇʹÓÃi£¬ÈçOracle 8i¡¢ ......
28.2.1 ÈçºÎ»ñµÃOracle°²×°°ü
ËäÈ»OracleÊý¾Ý¿âÊÇÒ»Ì×ÉÌÒµÈí¼þ£¬µ«ÊÇÓû§¿Éͨ¹ýOracle¹Ù·½ÍøÕ¾http://www.oracle.comÃâ·ÑÏÂÔØOracleÊý¾Ý¿âµÄ°²×°°üÎļþ¡£µ«ÔÚÏÂÔØÇ°ÐèÒªÏÈ×¢²áÒ»¸öÓû§Õ˺ţ¬²¢ÇÒ²»ÄܰÑÏÂÔØµÃµ½µÄOracleÈí¼þÓÃÓÚÉÌÒµÓÃ;£¬Èçͼ28.1Ëùʾ¡£
ͼ28.1 ÏÂÔØOracle 11g
Ñ¡ÔñÏÂÔØ“Oracle Database 11 ......
[ÕªÒª]Ö÷Òª´Ó´óÐÍÊý¾Ý¿âORACLE»·¾³Ëĸö²»Í¬¼¶±ðµÄµ÷Õû·ÖÎöÈëÊÖ£¬·ÖÎöORACLEµÄϵͳ½á¹¹ºÍ¹¤×÷»úÀí£¬´Ó²»Í¬·½Ãæ½ÏÈ«ÃæµØ×ܽáORACLEÊý¾Ý¿âµÄÓÅ»¯µ÷Õû·½°¸¡£
[¹Ø¼ü´Ê]ORACLEÊý¾Ý¿â¡¢»·¾³µ÷Õû¡¢ÓÅ»¯Éè¼Æ¡¢·½°¸
ÖÐͼ·ÖÀàºÅ£ºTP3 ÎÄÏ×±êʶÂ룺A ÎÄÕ±àºÅ£º1671£7597(2008)0720043£01
¡¡¡¡
¡¡¡¡ORACLEÊý¾Ý¿âÖÐÊý¾Ý´æÈ¡ÐÔÄ ......
´´½¨ÁÙʱ±í¿Õ¼ä
´´½¨ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE 'C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
´´½¨Óû§±í¿Õ¼ä
´´½¨Óû§±í¿Õ¼ä
C ......