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

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


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

oracle ±í¿Õ¼ä ±íȨÏÞ Óû§

Æô¶¯Êý¾Ý¿âÃüÁî·ÖΪÈý¸ö½×¶Î£º
startup nomount
alter database mount
alter database open
 
±¾Óû§¶ÁÈ¡ÆäËûÓû§¶ÔÏóµÄȨÏÞ:
¡¡¡¡select * from user_tab_privs;
±¾Óû§ËùÓµÓеÄϵͳȨÏÞ:
¡¡¡¡select * from user_sys_privs;
 ---------------------------------------------------------
ORACLEÖÐÊ ......

28.2.1 ÈçºÎ»ñµÃOracle°²×°°ü

28.2.1  ÈçºÎ»ñµÃOracle°²×°°ü
ËäÈ»OracleÊý¾Ý¿âÊÇÒ»Ì×ÉÌÒµÈí¼þ£¬µ«ÊÇÓû§¿Éͨ¹ýOracle¹Ù·½ÍøÕ¾http://www.oracle.comÃâ·ÑÏÂÔØOracleÊý¾Ý¿âµÄ°²×°°üÎļþ¡£µ«ÔÚÏÂÔØÇ°ÐèÒªÏÈ×¢²áÒ»¸öÓû§Õ˺ţ¬²¢ÇÒ²»ÄܰÑÏÂÔØµÃµ½µÄOracleÈí¼þÓÃÓÚÉÌÒµÓÃ;£¬Èçͼ28.1Ëùʾ¡£
ͼ28.1 ÏÂÔØOracle 11g
Ñ¡ÔñÏÂÔØ“Oracle Database 11 ......

oracle exp imp ³õ̽

Êý¾Ýµ¼³ö£º
 1 ½«Êý¾Ý¿âTESTÍêÈ«µ¼³ö,Óû§Ãûsystem ÃÜÂëmanager µ¼³öµ½D:\daochu.dmpÖÐ
   exp system/manager@TEST file=d:\daochu.dmp full=y
 2 ½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ¼³ö
   exp system/manager@TEST file=d:\daochu.dmp owner=(system,sys)
 3 ½«Êý¾Ý¿âÖеıíin ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ