WindowsÏÂÃüÁîÐÐÆô¶¯Oracle 10g/Database Control
1.Æô¶¯TNS¼àÌý
C:\Documents and Settings\Administrator>lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 13-7ÔÂ -2008 12:0
3:55
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Æô¶¯tnslsnr: ÇëÉÔºò...
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
ϵͳ²ÎÊýÎļþΪE:\oracle\product\10.2.0\db_1\network\admin\listener.ora
дÈëE:\oracle\product\10.2.0\db_1\network\log\listener.logµÄÈÕÖ¾ÐÅÏ¢
¼àÌý: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
¼àÌý: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx)(PORT=1521)))
ÕýÔÚÁ¬½Óµ½ (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
LISTENER µÄ STATUS
------------------------
±ðÃû LISTENER
°æ±¾ TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Æô¶¯ÈÕÆÚ 13-7Ô -2008 12:03:56
Õý³£ÔËÐÐʱ¼ä 0 Ìì 0 Сʱ 0 ·Ö 1 Ãë
¸ú×Ù¼¶±ð off
°²È«ÐÔ ON: Local OS Authentication
SNMP OFF
¼àÌý³ÌÐò²ÎÊýÎļþ E:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
¼àÌý³ÌÐòÈÕÖ¾Îļþ E:\oracle\product\10.2.0\db_1\network\log\listener.log
¼àÌý¶Ëµã¸ÅÒª...
(DESCRIPTION=(ADDRESS=(P
Ïà¹ØÎĵµ£º
Êý¾Ý¿âÖо³£ÓÃ0,1 À´±êʶij×ֶΣ¬×÷Ϊ¿ª·¢ÈËÔ±¿ÉÄÜÖªµÀËüµÄÒâÒ壬µ«ÎÒÃÇÈÃËüÏÔʾÔÚGridÁбíÉϱØÐëÏÔʾËüµÄʵ¼Êº¬Ò壬һ°ãÎÒÃÇ¿ÉÒÔÔÚ´úÂëÖжÁÊý¾ÝԴʱ¿ÉÒÔ×÷´¦Àí£¬Í¬Ê±ORACLEÖÐÓÃdecodeÒ²ÊDz»´í·½·¨¡£
decode(Ìõ¼þ,Öµ1,·ÒëÖµ1,Öµ2,·ÒëÖµ2,...Öµn,·ÒëÖµn,ȱʡֵ)
¸Ãº¯ÊýµÄº¬ÒåÈçÏ£º
......
1.µ±ÄãÃÍÈ»¼äÍü¼Çͨ¹ýʲôÊÓͼ¿ÉÒԲ鿴procedureÄÚÈÝʱ£¬ÒþÔ¼¼ÇµÃËùÐèµÄÊÓͼ°üº¬“SOUR”×ֶΣ¬´Ëʱ²éѯdict/dictionaryÊÓͼÊÇ×îºÃµÄÑ¡Ôñ
sys@ora10g> col COMMENTS for a78
sys@ora10g>select * from dict where TABLE_NAME like '%SOUR%';
TABLE_NAME   ......
SQL> show user
USER is "SYS"
SQL> create user t1 identified by t1;
create user t1 identified by t1
*
ERROR at line 1:
ORA-01920: user name 'T1' conflicts with another user or role name
SQL> drop user t1 cascade;
User dropped.
SQL> create user t1 identified by t1;
Us ......
½ñÌì¿´µ½Ò»Æª¹ØÓÚORCLEµÄÂß¼±¸·Ý£¬Àä¡¢Èȱ¸·ÝµÄÌû×Ó½²µÄͦºÃµÄ£¬²»¹ýÕâƪÎÄÕÂÊÇÒÔORACLE 7ΪÀý×Ó£¬ËäÈ»ÏÖÔÚÒѾÓкܺúÜÇ¿´óµÄRMAN£¬µ«»¹ÊǾõµÃÓбØҪת¹ýÀ´£¬²»ÄÜϲÐÂÑá¾ÉÂï¡£
==================================================================================
OracleÊý¾Ý¿âµÄ±¸·ÝÓë»Ö¸´
---- µ±ÎÒÃÇ ......
ÏÈÀ´¼òµ¥µÄ˵һÏÂORACLEµÄ±¸·Ý·½Ê½£¬Ïêϸ¹¦ÄÜ¿ÉÒÔËÑË÷һϡ£
Ò»ÖÖÊÇÂß¼±¸·Ý£¬¼´ËùνµÄµ¼³ö(Export)ºÍµ¼Èë(Import)ÃüÁÕâÖÖ·½Ê½µÄÓŵãÊÇ£¬Äܹ»¶ÔÊý¾Ý¿âÖеÄÿ¸ö¶ÔÏó½øÐб¸·Ý£¬²¢ÇÒʵÏÖ²»Í¬Æ½Ì¨ÏµÄÊý¾ÝǨÒÆ£¬µ«±¸·ÝµÄʱºòÊý¾Ý¿â²»ÄÜÊǹرյģ¬´ÓCMDÃüÁî½ ......