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
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
Æô¶¯Êý¾Ý¿âÃüÁî·ÖΪÈý¸ö½×¶Î£º
startup nomount
alter database mount
alter database open
±¾Óû§¶ÁÈ¡ÆäËûÓû§¶ÔÏóµÄȨÏÞ:
¡¡¡¡select * from user_tab_privs;
±¾Óû§ËùÓµÓеÄϵͳȨÏÞ:
¡¡¡¡select * from user_sys_privs;
---------------------------------------------------------
ORACLEÖÐÊ ......
28.2.4 °²×°Oracle 11g
Oracle 11gÌṩÁËͼÐλ¯µÄ°²×°½çÃæ£¬Óû§¿Éͨ¹ýÒÆ¶¯ºÍµ¥»÷Êó±êÍê³É°²×°¹ý³Ì¡£¾ßÌå°²×°²½ÖèÈçÏÂËùʾ¡£
£¨1£©½âѹOracle 11g°²×°°üÎļþ¡£
unzip linux_11gR1_database_1013.zip
Îļþ½«»á±»½âѹµ½linux_11gR1_database_1013Ŀ¼Ï£¬ÈçÏÂËùʾ¡£
# ls
doc inst ......
[ÕªÒª]Ö÷Òª´Ó´óÐÍÊý¾Ý¿âORACLE»·¾³Ëĸö²»Í¬¼¶±ðµÄµ÷Õû·ÖÎöÈëÊÖ£¬·ÖÎöORACLEµÄϵͳ½á¹¹ºÍ¹¤×÷»úÀí£¬´Ó²»Í¬·½Ãæ½ÏÈ«ÃæµØ×ܽáORACLEÊý¾Ý¿âµÄÓÅ»¯µ÷Õû·½°¸¡£
[¹Ø¼ü´Ê]ORACLEÊý¾Ý¿â¡¢»·¾³µ÷Õû¡¢ÓÅ»¯Éè¼Æ¡¢·½°¸
ÖÐͼ·ÖÀàºÅ£ºTP3 ÎÄÏ×±êʶÂ룺A ÎÄÕ±àºÅ£º1671£7597(2008)0720043£01
¡¡¡¡
¡¡¡¡ORACLEÊý¾Ý¿âÖÐÊý¾Ý´æÈ¡ÐÔÄ ......