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Êý¾Ý¿âµÄ¼àÌý·þÎñʱ·¢ÏÖÎÞ·¨Æô¶¯¡£¸ø³öµÄ´íÎóÌáʾÊÇ˵£¬Õâ¸ö·þÎñÆô¶¯ÁËÓÖÍ£Ö¹ÁË£¬²»ÖªµÀÊÇΪʲô¡£ÒòΪÔÚѧУµÄʱºòÓÃÊÇûÓÐÎÊÌâµÄ¡£ÎÒÏëÓ¦¸ÃÊÇÒòΪipµÄÊÇÎÊÌâ¡£ÔÚÍøÉϲéÁËһϣºÄãÊÇ·ñÐÞ¸ÄÄãµÄ»úÆ÷Ãû»òIPµØÖ·£¬Èç¹ûÓÐÐ޸쬰ÑORACLE\ora81\network\admin\listener.oraÎļþÖеÄhostÐÞ¸ÄΪлúÆ÷à ......
Select to_char(sysdate,'ss') from dual;--È¡µ±Ç°Ê±¼äÃ벿·Ö
Select to_char(sysdate,'mi') from dual;--È¡µ±Ç°Ê±¼ä·ÖÖÓ²¿·Ö
Select to_char(sysdate,'HH24') from dual;--È¡µ±Ç°Ê±¼äÃëСʱ²¿·Ö
Select to_char(sysdate,'DD') from dual;--È¡µ±Ç°Ê±¼äÈÕÆÚ²¿·Ö
Select to_char(sysdate,'MM') from dual;--È¡µ±Ç°Ê±¼ ......
ÈçºÎ¼ÓËÙOracle´óÅúÁ¿Êý¾Ý´¦Àí
Ò»¡¢ Ìá¸ßDML²Ù×÷µÄ°ì·¨£º
¼òµ¥ËµÀ´£º
£±¡¢ÔÝÍ£Ë÷Òý£¬¸üкó»Ö¸´.±ÜÃâÔÚ¸üеĹý³ÌÖÐÉæ¼°µ½Ë÷ÒýµÄÖØ½¨.
£²¡¢ÅúÁ¿¸üУ¬Ã¿¸üÐÂһЩ¼Ç¼ºó¼°Ê±½øÐÐÌá½»¶¯×÷.±ÜÃâ´óÁ¿Õ¼Óûعö¶ÎºÍ»òÁÙʱ±í¿Õ¼ä.
£³¡¢´´½¨Ò»ÁÙʱµÄ´óµÄ±í¿Õ¼äÓà ......
ÏîÄ¿¾ÀíÈÃ×öÀúÊ·Êý¾Ý±¸·Ý£¬Éæ¼°µ½ÈçºÎ½«ÒµÎñ±íÖеļǼµ¼³öµ½ÀúÊ·±íÖУ¬×Ô¼º×ʼÏëÄѵÀÊǸú×Ô¶¯¶ÔÕ˺Í×Ô¶¯ÉÏ´«³ÌÐòÒ»Ñùд¸ö³ÌÐòÈ»ºó½«³ÌÐò·ÅÔÚϵͳµÄÈÎÎñ¼Æ»®ÀﶨʱÔËÐУ¿»¹ÊÇÎÊÎÊÏîÄ¿¾Àí°É£¬ÎÊÏîÄ¿¾Àí£¬Äǵ¼³ö¼Ç¼Ôõô×ö¡£ÏîÄ¿¾Àí˵£¬Êý¾Ý¿âÀïÓ¦¸ÃÓÐÕâ¸ö¹¦Äܰɡ£»ÐÈ»´óÎò£¬ÒþÔ¼¼ÇµÃÖ ......
ÔÚÒ»±íorginfoÉϽ¨Á¢´¥·¢Æ÷£¬ÆäÖаüÀ¨ÒÔ϶¯×÷£º
Ôöɾ¸Ä´Ë±íµÄ¼Ç¼ʱ£¬ÐèÒª²éѯ´Ë±í£¬ÉõÖÁ¸Äд´Ë±íµÄÆäËû¼Ç¼¡£±¨¸æ“ora-04091:±íÒѾ±»Ð޸쬶ÔÓÚ´¥·¢Æ÷/º¯Êý²»¿É¼û”¡£
Cause: A trigger (or a user defined PL/SQL function that is referenced in this statement) attempted to look at (or modify) a tab ......