oracle×Ö·û¼¯ÐÞ¸ÄÎÊÌâ
1£ºÖØÐÂÔÚdbcaÖд´½¨Êý¾Ý¿â²¢Ñ¡ÔñÕýÈ·µÄ×Ö·û¼¯
2£º
²éѯµ±Ç°×Ö·û¼¯£º
select userenv('language') from dual;
select * from V$NLS_PARAMETERS;
ÔÚWindowsÏÂsqlplusÍêÈ«Õý³££¬¿ÉÊǵ½LinuxÏ£¬sqlplusÖÐÎÄÏÔʾ¾Í³öÎÊÌâÁË£¬×ÜÊÇÏÔʾ“??”£¬Õâ¸öÎÊÌâÓÖÔõô½â¾öÄØ£¿
¾¹ýÔÚÍøÂçÉϲé×ÊÁÏ£¬ÒÔ¼°³¢ÊÔ£¬µÃµ½µÄ½â·¨ÈçÏ£º
ÆäʵºÜ¼òµ¥ÎÒÃÇÖ»ÒªÉèÖÃÍ˳ösqlplus,ÉèÖÃÏàÓ¦µÄ»·¾³±äÁ¿NLS_LANG
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
ΪÁËÏ´β»±ØÖØÐÂÉèÖã¬ÎÒÃÇ¿ÉÒÔ½«Æä·ÅÔÚ/home/oracle/.bash_profile»ò/etc/profileÖС£ÖØнøÈësqlplus,µ«ÊÇ·¢ÏÖÔÀ´ÔÚsqlplusÖвåÈëµÄÊý¾ÝÖÐÎÄ»¹ÊÇÏÔʾ"??",²»¹ýÄãÖØвåÈëÒ»Ìõ¿´¿´£¬ÊDz»ÊÇ¿ÉÒÔÕý³£ÏÔʾÖÐÎÄÁË¡£
windows sqlplus¿Í»§¶ËÁ¬½ÓlinuxÏÂOracleÐÞ¸ÄΪ
export NLS_LANG="AMERICAN_AMERICA.UTF8"
3£º
ÐÞ¸Ä×Ö·û¼¯WE8ISO8859³ÉZHS16GBK¾¹ý
[oracle@testdb2 ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚÈý 5ÔÂ 20 08:56:15 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218968 bytes
Variable Size 79693416 bytes
Database Buffers 197132288 bytes
Redo Buffers 7168000 bytes
Database mounted.
SQL> alter database noarchivelog;
Database altered.
SQL> ALTER SESSION SET SQL_TRACE=TRUE;
Session altered.
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
System altered.
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
System altered.
SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
System altered.
SQL> ALTER DATABASE OPEN;
Database altered.
SQL> ALTER DATA
Ïà¹ØÎĵµ£º
¸ú×ÅÕ⼸ÌìOracle OpenWorld´ó»áµÄ¾ÙÐУ¬Oracle11gµÄÐÂÌØÕ÷Ô½À´Ô½¶àµÄ±»Õ¹ÏÖ³öÀ´¡£
¡¡¡¡ÒÔÇ°£¬ÎÒÔø¾Òý¼û¹ýOracle11g½«¿ÉÄÜÔÚ10Ô·ݵÄÕâ¸ö´ó»áÉÏÍƳö£¬µ±³õÖÁÓÚAlpha°æµÄÐÅÏ¢ÒѾ¿ÉÒÔ¼ûµ½£¬ÏÖʱ³öÏÖµÄÒѾÊÇBeta°æ£¬ÀëOracle11gµÄÕýʽ°æÒѾ²»Ô¶¡£
¡¡¡¡Laurent Schneider ÔÚËûµÄBlogÖÐ̸µ½£¬¶ÔÓÚOracle11gµÄÃû×Ö»¹ ......
¶þÁãÁã¾ÅÄêʮԶþÊ®ÈÕ£¬´ò´ÓÈýÄêÇ°ÍƳöOracle¼Ó½ô¼Æ»®ÒÔÀ´£¬¼×¹ÇÎĹ«Ë¾ÒѾÔö¼ÓÁËÆß,000¶à¼ÒÖÎÀíÈí¼þÖÐÐÍÆóÒµ¿Í»§£¬µ±Ç°ÖÐÐÍÆóÒµ¿Í»§×ÜÁ¿ÒѾ³¬¹ý25,000¼Ò¡£
͸¹ýÍƳöÂíÏòÖÐÐÍÆóÒµ¿Í»§µÄOracle¼Ó¿ì¼Æ»®Ð¹¦ÄÜ£¬°üÀ¨ÐÂʽ¼Ó¿ì¼Æ»®½â¾ö·½°¸¡¢OracleÆóÒµ¼ÓËÙÆ÷¡¢²ÆÎñÑ¡¼þºÍµ÷¶È²½ÖèµÈ£¬¼×¹ÇÎÄÔÚ²»Í£¶ÒÏÖ˳Àû¡£
ÃæÁÙÖÐÐÍ ......
1.¶à°æ±¾£º¶ÁÒ»Ö²éѯ ·Ç×èÈû²éѯ
Oracle ²ÉÓÃÁËÒ»ÖÖ
¶à°æ±¾¡¢¶ÁÒ»Ö£¨read-consistent£©µÄ²¢·¢Ä£ÐÍ¡£ÔÙ´Î˵Ã÷£¬ÎÒÃǽ«ÔÚµÚ7 Õ¸üÏêϸµØ½éÉÜÓйصļ¼Êõ¡£
²»¹ý£¬ÊµÖÊÉϽ²£¬Oracle ÀûÓÃÕâÖÖ»úÖÆÌṩÁËÒÔÏÂÌØÐÔ£º
¶ÁÒ»Ö²éѯ£º¶ÔÓÚÒ»¸öʱ¼äµã£¨point in time£©£¬²éѯ»á²úÉúÒ»ÖµĽá¹û¡£
·Ç×èÈû²éѯ£º²éѯ²»» ......
ɾ³ýAIXϵÄORACLE
===========================================================
×÷Õß: wmlm(http://wmlm.itpub.net)
·¢±íÓÚ:2008.12.02 18:17
·ÖÀà: oracle
³ö´¦£ºhttp://wmlm.itpub.net/post/12871/474762
---------------------------------------------------------------
rm -Rf /etc/oratab
rm -Rf /et ......