oracleÈçºÎ½«Êý¾Ýµ¼Èëµ½ÁíÒ»¸ö±í¿Õ¼ä
oracleÈçºÎ½«Êý¾Ýµ¼Èëµ½ÁíÒ»¸ö±í¿Õ¼ä
ij¸öÓû§µÄÊý¾ÝÔÚUSER±í¿Õ¼äÀÈç¹û¶à¸öÓû§µÄÊý¾Ý¶¼ÔÚUSERS±í¿Õ¼äÄÚ£¬½«ÑÏÖØÓ°ÏìϵͳÐÔÄÜ£¬Ò»°ãÔÚϵͳǨÒƵÄʱºò£¬ÔÚеÄϵͳÀïÏ£Íûµ¼ÈëÒ»¸ö¶ÀÁ¢µÄÓû§±í¿Õ¼ä£¬µ«ÊǾ³£ÎÞ·¨µ¼ÈëÓû§Ö¸¶¨µÄȱʡ±í¿Õ¼ä£¬Õâ¸öÎÊÌâ²úÉúµÄÔÒòÊÇÈç¹ûÒ»¸öÓû§ÓÐDBAµÄȨÏÞ£¬µ¼ÈëÊý¾ÝµÄʱºò£¬¾Í»áд»ØÔ±í¿Õ¼äusers
½â¾öÎÊÌâµÄ·½·¨ ,´´½¨Óû§µÄʱºò²»Òª¸³ÓèDBAµÄȨÏÞ
CREATE USER "GX" PROFILE "DEFAULT"
IDENTIFIED BY "gx" DEFAULT TABLESPACE "GX"
TEMPORARY TABLESPACE "TEMP"
ACCOUNT UNLOCK;
×¢ÒâÖ»ÒªÓÐconnect imp_full_database,resoure¾ÍÄܵ¼ÈëÓû§µÄÊý¾Ý£¬²»Òª¸³ÓèDBAȨÏÞ
GRANT "CONNECT" TO "GX";
GRANT "IMP_FULL_DATABASE" TO "GX";
GRANT "RESOURCE" TO "GX";
»ØÊÕÓû§ÎÞÏÞÖƵÄȨÏÞ£»
revoke unlimited tablespace from gx;
ÔÚUSERS±í¿Õ¼äµÄÅä¶îΪ0
alter user gx quota 0 on USERS;
ÔÚÓû§×Ô¼ºµÄȱʡ±í¿Õ¼äÄÚÅä¶îΪÎÞÏÞµÄ
alter user gx quota unlimited on GX;
ʹÓÃÓû§µ¼Èë
imp gx/gx file=gx.dmp fromuser=gx touser=gx
¿ÉÒÔ²éѯһÏÂÓû§µÄ±íÔÚÄǸö±í¿Õ¼ä
select table_name,tablespace_name from user_tables;
Èç¹û¸ö±ð±íȱʡ±í¿Õ¼äÓдí¿ÉÒÔʹÓÃÏÂÃæµÄÃüÁîÀ´Ð޸ıíËùÔڵıí¿Õ¼ä
ÏȲéѯһÏÂÓм¸¸öÕâÑùµÄ±í
select table_name,tablespace_name from user_tables where tablespace_name='USERS';
Ð޸ıíËùÔڵıí¿Õ¼ä
alter table test tablespace newtab;
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
²»ÊÇORACLEµÄÎÊÌâ
2009-12-30 15:00
  ......
ÎÒµÄORACLE RAC INSTALL for LINUX 10.2Ñо¿
ÎÒµÄORACLE RAC INSTALL for LINUX 10.2Ñо¿
1¡¢´´½¨ÐéÄâ»ú
DB1ÐéÄâ»úÎļþĿ¼ g:\vmtest1 Îļþ´óС8G ÄÚ´æ944M£¨ÔÁÂÎÒÖ»ÓÐ2GRAM)
DB2ÐéÄâ»úÎļþĿ¼ E:\vmtest2 Îļþ´óС8G ÄÚ´æ944M
ÔÚDB1ÉÏ´´½¨¹²Ïí´ÅÅÌ£¬
E:\SHARE Îļþ´óС8G
DB2Ò²´´½¨´ÅÅÌ£¬ ......
°²×°ºÃÁËÖ®ºó¿ÉÒÔͨ¹ýÕâ¸ö·¾¶ÕÒµ½Ò»¸öÎı¾Îļþ£º
oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora »¹Ò»¸öÔÚͬ·¾¶ÏµÄtnsnames.oraÎļþ£¬ÕâÁ½¸öÎı¾ÖеÄһЩÐÅÏ¢ÒªÒ»ÑùµÄ¡£
Äã¿´¿´ÎÒµÄÕâÁ½¸öÎı¾ÎļþµÄÐÅÏ¢£º
listener.ora
# listener.ora Network Configuration File:& ......
·¢ÏÖ´íÎó£ºÊý¾Ý¿âδ´ò¿ª: ½öÔÊÐíÔڹ̶¨±í/ÊÓͼÖвéѯ
½â¾ö·½°¸£º
1. ÔÚÔËÐÐ-->ÃüÁîÀïÊäÈësqlplus /nologÈ»ºó»Ø³µ£¬
2. ÒÔsysdbaµÄ½ÇÉ«µÇ¼£ºconnect sys/¿ÚÁî as sysdba
3. ÏÈÖ´ÐДalter database open”£¬»á³öÏÖÈçϵĴíÎó
µÚ 1 ÐгöÏÖ´íÎó:
ORA-01157: ÎÞ·¨±êʶ/Ëø¶¨Êý¾ÝÎļþ 6 - Çë² ......