oracleÁ½ÖÖÓû§ÈÏÖ¤·½Ê½
ORACLEÊý¾Ý¿âͨ¹ýsqlnet.oraÎļþÖеIJÎÊýsqlnet.authentication_services,²ÎÊýÎļþÖеÄremote_login_passwordfileºÍ¿ÚÁîÎļþpwdsid.oraÈýÕßÐͬ×÷ÓÃʵÏÖÉí·ÝÈÏÖ¤.
Sqlnet.authentication_services=(NTS)|(NONE)
NTS:²Ù×÷ϵͳÈÏÖ¤·½Ê½,²»Ê¹ÓÿÚÁîÎļþ;
NONE:¿ÚÁîÎļþÈÏÖ¤·½Ê½
Remote_login_passwordfile=(NONE)|(EXCLUSIVE)|(SHARED)
NONE:²»Ê¹ÓÿÚÁîÎļþ,²Ù×÷ϵͳÈÏÖ¤;
EXCLUSIVE:¿ÚÁîÎļþÈÏÖ¤·½Ê½,µ«Ö»ÓÐÒ»¸öÊý¾Ý¿âʵÀý¿ÉÒÔʹÓôËÎļþ;
SHARED:¿ÚÁîÎļþÈÏÖ¤·½Ê½,¿ÉÒÔÓжà¸öÊý¾Ý¿âʵÀý¿ÉÒÔʹÓôËÎļþ,µ«´ËÉèÖÃÏÂÖ»ÓÐSYSÕʺÅÄܱ»Ê¶±ð,¼´Ê¹ÎļþÖдæÔÚÆäËûÓû§µÄÐÅÏ¢,Ò²²»ÔÊÐíËûÃÇÒÔSYSOPER/SYSDBAµÇ¼.
(1).sqlnet.authentication_services=(NTS)
ͬʱRemote_login_passwordfile=(NONE),´ËʱΪ²Ù×÷ϵͳÈÏÖ¤·½Ê½.
µ±ÒÔoracle_dba×éϵÄÓû§µÇ¼½øÈë±¾µØµÄ²Ù×÷ϵͳºó,½øÐÐÒÔϲÙ×÷:
sqlplus /nolog
SQL>conn /assysdba
¿ÉÒÔÒÔsysdbaÉí·ÝµÇ¼³É¹¦,½øÐÐÊý¾Ý¿â·½ÃæµÄ²Ù×÷.
µ±ÒÔÔ¶³Ì½øÐеǼʱ,Ö´ÐÐ:
sqlplus /nolog
SQL>conn /assysdba
Ôò»áÏÔʾ:
ERROR:ORA-01031:insufficient privileges
¼´²»ÔÊÐíÒÔsysdbaÉí·ÝÔ¶³ÌµÇ¼ϵͳ,ÕâÒ²ÊÇOSÈÏÖ¤ÕâËùÒÔ³ÆΪ±¾µØÈÏÖ¤·½Ê½µÄÔÒò.
(2).Sqlnet.authentication_services=(NONE),ͬʱ
Remote_login_passwordfile=(EXCLUSIVE)|(SHARED),ÅäºÏ¿ÚÁîÎļþPWDsid.ora,´ËʱΪ¿ÚÁîÎļþÈÏÖ¤·½Ê½:
µ±ÔÚ±¾µØÒÔoracle_dba×éϵÄÓû§µÇ¼½øÈëϵͳʱ,½øÐÐÒÔϲÙ×÷:
sqlplus /nolog
SQL>conn /assysdba
Ôò»áÏÔʾ:
ERROR:ORA-01031:insufficient privileges
ÔÚ±¾µØ»òÔ¶³Ì½øÐÐϱߵIJÙ×÷:
sqlplus /nolog
SQL>conn sys/ÃÜÂë@·þÎñÃûassysdba
¿ÉÒÔ½øÈëϵͳ,Ò²¾ÍÊÇ˵¿ÚÁîÎļþÈÏÖ¤·½Ê½ÔÊÐíÓû§´Ó±¾µØ»òÔ¶³ÌÒÔsysdbaÉí·ÝµÇ¼,µ«±ØÐëÌṩ¿ÚÁî×Ö.
(3).Sqlnet.authentication_services=(NTS),ͬʱ
Remote_login_passwordfile=(EXCLUSIVE)|(SHARED),ÅäºÏ¿ÚÁîÎļþPWDsid.ora,´ËʱΪ²Ù×÷ϵͳÈÏÖ¤ºÍ¿ÚÁîÎļþÈÏ֤ͬʱÆð×÷ÓÃ:
µ±ÔÚ±¾µØÒÔoracle_dba×éϵÄÓû§µÇ¼½øÈë²Ù×÷ϵͳºó,½øÐÐϱߵIJÙ×÷:
sqlplus /nolog
SQL>conn /assysdba
¿ÉÒÔ½øÈëϵͳ.¼´²Ù×÷ϵͳÈÏÖ¤·½Ê½µÇ¼³É¹¦.
µ±ÔÚÔ¶³ÌÖ´ÐÐ:
sqlplus /nolog
SQL>conn sys/ÃÜÂë@·þÎñÃûassysdba
ͬʱ¿ÉÕý³£µÇ¼µ½Êý¾Ý¿âϵͳ,¼´¿ÚÁîÎļþÈÏÖ¤·½Ê½µÇ¼³É¹¦.
¸½£º
ÒªÖªµÀÒÔϼ¸Öֵǽ·½Ê½²»ÊÇÒ»ÖÖ¸ÅÄî
sqlplus /nolog
1: conn /ass
Ïà¹ØÎĵµ£º
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
Ï൱ÓÚalias(±ðÃû),±ÈÈç°Ñuser1.table1ÔÚuser2Öн¨Ò»¸öͬÒå´Êtable1
create synonym table1 for user1.table1;
ÕâÑùµ±ÄãÔÚuser2Öвéselect * from table1ʱ¾ÍÏ൱ÓÚ²éselect * from user1.table1;
Óŵã×Ô¼º×ܽá°É¡£
ÀýÈ磺
ÔÚoracleÖжÔÓû§µÄ¹ÜÀíÊÇʹÓÃȨÏ޵ķ½Ê½À´¹ÜÀíµÄ£¬Ò²¾ÍÊÇ˵£¬Èç¹ûÎÒÃÇÏëʹÓÃÊý¾Ý¿â£¬ÎÒà ......
ÏÈ¿´ÏÂÃæµÄÀý×Ó:oracleÖÐÁ½¸öϵͳ±í.emp,dept.
example:
1:not exists(not in)
not exists:
ÕâÌõÓï¾ä·µ»Øselect * from scott.dept d where e.deptno=d.deptno and d.deptno=10Ìõ¼þÂú×ãµÄ½á¹û¼¯.Ò²¾ÍÊÇ˵,
·µ»ØµÄ½á¹û¼¯Öв»´æÔÚd.deptno=10½á¹û¼¯µÄ¼Ç¼,¼´emp±íÖÐûÓÐdept±íÖÐd.deptno=10µÄ¼Ç¼.
SQL& ......
1¡¢Êý¾Ý¿âµÄÂß¼½á¹¹ºÍÎïÀí½á¹¹£º
Oracle logically divides the database into a smaller units to manage ,store,and retreive
data efficently.
Tablespace\Blocks\Extents\segment\
ÓÐËÄÖÖsegment:
data segment¡¢Index segment¡¢Temporay segment¡¢Rollback Segment
temporary segment:
Ar ......