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 $ORACLE_HOME/bin/dbstart£º¶ÁÈ¡oratabÎļþÖеÄÄÚÈÝ£¬Æô¶¯ÏàÓ¦µÄÊý¾Ý¿â²¢Æô¶¯ÍøÂç¼àÌý³ÌÐò¡£
q $ORACLE_HOME/bin/dbshut£º¶ÁÈ¡oratabÎļþÖеÄÄÚÈÝ£¬¹Ø±ÕÏàÓ¦µÄÊý¾Ý¿â²¢¹Ø±ÕÍøÂç¼àÌý³ÌÐò¡£
¾ßÌåÅäÖò½ÖèÈçÏÂËùÊö¡£
£¨1£©±à¼oratabÎļþ¡£¸ÃÎļþ±£´æÁËϵͳÖÐËùÓÐÒÑ´´½¨µÄÊý¾Ý¿âµÄÐÅÏ¢£¬Ã¿¸öÊý¾Ý¿â¶ÔÓ¦Ò»ÐмǼ£¬ÒÔ#ºÅ¿ªÍ·µÄÊÇ×¢ÊÍÐС£ÀýÈçorclÊý¾Ý¿âµÄ¶ÔÓ¦¼Ç¼ÈçÏÂËùʾ¡£
orcl:/u01/app/oracle/product/11.1.0/db_1:N
Èç¹ûÒªÉèÖÃorclÊý¾Ý¿âÔÚ¿ª»úʱ×Ô¶¯Æô¶¯£¬°Ñ¸Ã¼Ç¼×îºóµÄN¸ÄΪY£¬¸ü¸ÄºóµÄ½á¹ûÈçÏÂËùʾ¡£
orcl:/u01/app/oracle/product/11.1.0/db_1:Y
£¨2£©ÔÚ/etc/init.dĿ¼Ï´´½¨Îļþoracle£¬¼ÓÈëÈçÏÂÄÚÈÝ£º
#!/bin/sh
# chkconfig: 345 90 10
# description: Oracle auto start-stop script.
#
ORA_HOME=/u01/app/oracle/product/11.1.0/db_1
# ʹÓÃORA_HOME±äÁ¿ÉèÖÃOracleÖ÷Ŀ¼µÄλÖÃ
ORA_OWNER=oracle # ʹÓÃORA_OWNER±äÁ¿ÉèÖÃOracleÓû§
# Èç¹ûdbstart½Å±¾Îļþ²»´æÔÚ£¬Ôò·µ»Ø´íÎóÐÅÏ¢
if [ ! -f $ORA_HOME/bin/dbstart ]
then
echo "Oracle startup: cannot start"# Êä³öOracleÎÞ·¨Æô¶¯µÄ´íÎó
exit
fi
case "$1" in
'start') # Èç¹û²ÎÊýΪstart
# Ö´ÐÐdbstart½Å±¾Æô¶¯OracleÊý¾Ý¿â
su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORA_HOME"
;;
'stop') &n
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
Æô¶¯Êý¾Ý¿âÃüÁî·ÖΪÈý¸ö½×¶Î£º
startup nomount
alter database mount
alter database open
±¾Óû§¶ÁÈ¡ÆäËûÓû§¶ÔÏóµÄȨÏÞ:
¡¡¡¡select * from user_tab_privs;
±¾Óû§ËùÓµÓеÄϵͳȨÏÞ:
¡¡¡¡select * from user_sys_privs;
---------------------------------------------------------
ORACLEÖÐÊ ......
µÚ28Õ Oracle·þÎñÆ÷ÅäÖú͹ÜÀí
ÌáÆðÊý¾Ý¿â£¬µÚÒ»¸öÏëÆðµÄ¹«Ë¾Ò»°ã¶¼»áÊÇOracle¡£Oracle¹«Ë¾ÓÚ1977Äê³ÉÁ¢£¬×¨×¢ÓÚÊý¾Ý¿â²úÆ·µÄ¿ª·¢£¬ÔÚÊý¾Ý¿âÁìÓòÒ»Ö±¶¼´¦ÓÚÁìÏȵØÎ»£¬Æä²úÆ·¸²¸ÇÁË´ó¡¢ÖС¢Ð¡ÐÍ»úµÈÊýÊ®ÖÖ»úÐÍ£¬ÊÇĿǰÊÀ½çÉÏʹÓÃ×î¹ã·ºµÄ¹ØÏµÊý¾Ý¿âϵͳ֮һ¡£±¾½ÚÒÔÆä×îеÄÊý¾Ý¿â²úÆ·Oracle 11gΪÀý£¬½éÉÜÈçºÎÔÚRed ......