Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracleÊý¾Ý¿âʱ³£ÓõIJÙ×÷ÃüÁîÕûÀí

µÇ¼oracleÊý¾Ý¿âʱ³£ÓõIJÙ×÷ÃüÁîÕûÀí
1¡¢su – oracle ²»ÊDZØÐ裬ÊʺÏÓÚûÓÐDBAÃÜÂëʱʹÓ㬿ÉÒÔ²»ÓÃÃÜÂëÀ´½øÈësqlplus½çÃæ¡£
2¡¢sqlplus /nolog »òsqlplus system/manager »ò./sqlplus system/manager@ora9i
;
3¡¢SQL>connect / as sysdba ;£¨as sysoper£©»ò
connect internal/oracle AS SYSDBA ;(scott/tiger)
conn sys/change_on_install as sysdba;
4¡¢SQL>startup; Æô¶¯Êý¾Ý¿âʵÀý
5¡¢ ²é¿´µ±Ç°µÄËùÓÐÊý¾Ý¿â: select * from v$database;
select name from v$database;
desc v$databases; ²é¿´Êý¾Ý¿â½á¹¹×Ö¶Î
7¡¢ÔõÑù²é¿´ÄÄЩÓû§ÓµÓÐSYSDBA¡¢SYSOPERȨÏÞ:
SQL>select * from V_$PWFILE_USERS;
Show user;²é¿´µ±Ç°Êý¾Ý¿âÁ¬½ÓÓû§
8¡¢½øÈëtestÊý¾Ý¿â£ºdatabase test;
9¡¢²é¿´ËùÓеÄÊý¾Ý¿âʵÀý£ºselect * from v$instance£»
È磺ora9i
10¡¢²é¿´µ±Ç°¿âµÄËùÓÐÊý¾Ý±í£º
SQL> select TABLE_NAME from all_tables;
select * from all_tables;
SQL> select table_name from all_tables where table_name like '%u%';
TABLE_NAME
------------------------------
_default_auditing_options_
11¡¢²é¿´±í½á¹¹£ºdesc all_tables;
12¡¢ÏÔʾCQI.T_BBS_XUSERµÄËùÓÐ×ֶνṹ£º
desc CQI.T_BBS_XUSER;
13¡¢»ñµÃCQI.T_BBS_XUSER±íÖеļǼ£º
select * from CQI.T_BBS_XUSER;
14¡¢Ôö¼ÓÊý¾Ý¿âÓû§£º(test11/test)
create user test11 identified by test default tablespace users Temporary TABLESPACE Temp;
15¡¢Óû§ÊÚȨ:
grant connect,resource,dba to test11;
grant sysdba to test11;
commit;
16¡¢¸ü¸ÄÊý¾Ý¿âÓû§µÄÃÜÂ룺(½«sysÓësystemµÄÃÜÂë¸ÄΪtest.)
alter user sys indentified by test;
alter user system indentified by test;
oracle
¹ÜÀí¿ØÖÆÌ¨ÎÞ·¨µÇ¼µÄ½â¾ö°ì·¨



½â¾ö²½Ö裺
oracle
10gÖØ½¨em db control
Oracle
10GÖØ½¨EM DB Control.
1.drop configuration files and repository run :
emca -deconfig dbcontrol db -repos drop
oracle
10gÖØ½¨em db control
Oracle
10GÖØ½¨EM DB Control.
1.drop configuration files and repository run :
emca -deconfig dbcontrol db -repos drop
2. Logon SQLPLUS as user SYS or SYSTEM, and drop the sysman account and mangement objects:
a. drop user sysman cascade;
b. d


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

OracleÊý¾Ý¿âËÀËø´¦Àí

--µ±ÇëÇóÖ´Ðкó²»ÄÜ"²é¿´Êä³ö"µÄʱºò±íʾÓнø³ÌËÀËøÁË
--²éÕÒËÀËøµÄ½ø³Ì
select t2.username,t2.sid,t2.serial#,t2.logon_time
from v$locked_object t1,v$session t2
where t1.session_id=t2.sid order by t2.logon_time
--ɾ³ýËÀËøµÄ½ø³Ì£¬É¾³ýµ±ÌìǰµÄ£¬²»ÄÜɾ³ýµ±ÌìµÄ£¬
--alter system kill session 't2.sid,t ......

Oracle ¿ç¿â ²éѯ ¸´ÖƱíÊý¾Ý

Ô­ÎĵØÖ·£ºhttp://www.cnblogs.com/chinhr/archive/2009/04/22/1440914.html
·½·¨Ò»£º
ÔÚĿǰ¾ø´ó²¿·ÖÊý¾Ý¿âÓзֲ¼Ê½²éѯµÄÐèÒª¡£ÏÂÃæ¼òµ¥µÄ½éÉÜÈçºÎÔÚoracleÖÐÅäÖÃʵÏÖ¿ç¿â·ÃÎÊ¡£
±ÈÈçÏÖÔÚÓÐ2¸öÊý¾Ý¿â·þÎñÆ÷£¬°²×°ÁË2¸öÊý¾Ý¿â¡£Êý¾Ý¿âserver AºÍB¡£ÏÖÔÚÀ´ÊµÏÖÔÚA¿âÖзÃÎÊBµÄÊý¾Ý¿â¡£
µÚÒ»²½¡¢ÅäÖÃA·þÎñÆ÷¶ËµÄtnsnam ......

ÈçºÎÔÚoracleÖе¼ÈëdmpÊý¾Ý¿âÎļþ


OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£
ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
¡¡¡¡Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS(ÃüÁîÐÐ)ÖÐÖ´ÐУ¬DOSÖ ......

oracleµÄ»ù±¾ÖªÊ¶

Oracle
    SqlServer2000 2005
 MySql      
 DB2
 ORACLE   sun  SUN
 
 Êý¾Ý¿â  DataBase  db
    ´æ´¢Êý¾Ý
 Êý¾Ý Data
        Êý×Ö   ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ