Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 job²»ÔËÐÐ ½â¾ö·½°¸

1) Instance in RESTRICTED SESSIONS mode?
¡¡¡¡Check if the instance is in restricted sessions mode:
¡¡¡¡select instance_name,logins from v$instance;
¡¡¡¡If logins=RESTRICTED, then:
¡¡¡¡alter system disable restricted session;
¡¡¡¡^-- Checked!
¡¡¡¡2) JOB_QUEUE_PROCESSES=0
¡¡¡¡Make sure th ......

¡¾×ª¡¿oracleÖÐhintÓ÷¨

hints 這個東ʹÓõĺõÄ話ºÜºÃÓá£ÔÚ½øÐÐsqlÖ´Ðйý³ÌÖУ¬ÓÉÓÚÓÐʱºòϵͳ×Ô¶¯ÓÅ»¯µÄ·½Ê½²¢²»ÊÇ×îÓŵġ£ÐèÒªÎÒÃÇÊÖ¹¤Ìí¼ÓhintÀ´Ìá¸ß²éѯЧÂÊ¡£ÔÚSQLÓï¾äÓÅ»¯¹ý³ÌÖУ¬ÎÒÃǾ­³£»áÓõ½hint,ÏÖ×ܽáÒ»ÏÂÔÚSQLÓÅ»¯¹ý³ÌÖг£¼ûOracle HINTµÄÓ÷¨£º
1. /*+ALL_ROWS*/±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñ ......

OracleÊý¾Ý¿âµÄÓÅ»¯Éè¼Æ

[ÕªÒª]Ö÷Òª´Ó´óÐÍÊý¾Ý¿âORACLE»·¾³Ëĸö²»Í¬¼¶±ðµÄµ÷Õû·ÖÎöÈëÊÖ£¬·ÖÎöORACLEµÄϵͳ½á¹¹ºÍ¹¤×÷»úÀí£¬´Ó²»Í¬·½Ãæ½ÏÈ«ÃæµØ×ܽáORACLEÊý¾Ý¿âµÄÓÅ»¯µ÷Õû·½°¸¡£
[¹Ø¼ü´Ê]ORACLEÊý¾Ý¿â¡¢»·¾³µ÷Õû¡¢ÓÅ»¯Éè¼Æ¡¢·½°¸
ÖÐͼ·ÖÀàºÅ£ºTP3 ÎÄÏ×±êʶÂ룺A ÎÄÕ±àºÅ£º1671£­7597(2008)0720043£­01
¡¡¡¡
¡¡¡¡ORACLEÊý¾Ý¿âÖÐÊý¾Ý´æÈ¡ÐÔÄ ......

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 ......

28.4.2 ¿ª»ú×Ô¶¯Æô¶¯OracleÊý¾Ý¿â·þÎñ

28.4.2  ¿ª»ú×Ô¶¯Æô¶¯OracleÊý¾Ý¿â·þÎñ
OracleÌṩÁË3¸öÎļþ£¬ÓÃÓÚÅäÖÃOracleÊý¾Ý¿â·þÎñµÄ×Ô¶¯Æô¶¯£¬ËüÃÇ·Ö±ðÊÇ/etc/oratab¡¢$ORACLE_HOME/bin/dbstartÒÔ¼°$ORACLE_HOME/bin/dbshut¡£¹ØÓÚÕâ3¸öÎļþµÄ˵Ã÷ÈçÏÂËùʾ¡£
q      /etc/oratab£ºÔÚ¸ÃÎļþÖÐÖ¸¶¨ÐèÒª×Ô¶¯Æô¶¯ºÍ¹Ø±ÕµÄÊý¾Ý¿â¡£
q&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ