ITPub博客

SALES_DED_PRE= (DESCRIPTION= (LOAD_BALANCE=OFF) (FAILOVER=ON) (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.74)(PORT=1524)) (ADDRESS=(PROTOCOL=TCP)(HOST=144.25.28.75)(PORT=1524))) (CONNECT_DATA= (SERVICE_NAME=SALES.ORACLE.COM) (SERVER=DEDICATED) (INSTANCE_ROLE=PRIMARY) (FAILOVER_MODE= (BACKUP=SALES_DED_PRE_SECONDARY) (TYPE=SELECT) (METHOD=PRECONNECT) (RETRI

1， SERVER端安装，系统安装光盘上有。使用GNOME-SESSION：--change in server :vncpasswd , set the user password.-- close firewall ,$home_dir/.vnc/xstartup :uncomment following: unset SESSION_MANAGER exec /etc/X11/xinit/xinitrccomment : #twm &add this line: gnome-session &2，客户端VNCVIEWER版本号须与SERVER端一致，否则会报“the connection closed unexpectedly”错误。[@more@]

IMP-00032: SQL statement exceeded buffer lengthIMP-00008: unrecognized statement in the export file: 'This table defines the category names available for a metric class.'IMP-00032: SQL statement exceeded buffer lengthIMP-00008: unrecognized statement in the export file: 'This table provides information about what category is applicable for a given metric/policy guid and metric class. The same table is used to define mappings for both metrics and policies.'....resolve: add parameter buff

以下内容可以适用于所有CMD窗口显示文字的程序，包括SQLPLUS ， TYPE FILE_NAME 等。--中文代码页 936UTF8 65001CHCP 936 # 使用简体中文编码CHCP 65001 #使用UTF8编码如何在DOS窗口中显示UTF-8字符 作者：终南 <li.zhongnan@hotmail.com> 在中文Windows系统中，如果一个文本文件是UTF-8编码的，那么在CMD.exe命令行窗口（所谓的DOS窗口）中不能正确显示文件中的内容。在默认情况下，命令行窗口中使用的代码页是中文或者美国的，即编码是中文字符集或者西文字符集。 如果想正确显示UTF-8字符，可以按照以下步骤操作： 1、打开C

-- 错误代码举例:(from alert_DBSID.log)Tue Mar 15 18:35:21 2011+188791 Thread 1 advanced to log sequence 783 (LGWR switch)+188792 Current log# 3 seq# 783 mem# 0: /opt/app/oracle/oradata/Homelink/redo03.log+188793 Thread 1 cannot allocate new log, sequence 784+188794 Checkpoint not complete+188795 Current log# 3 seq# 783 mem# 0: /opt/app/oracle/oradata/Homelink/redo03.log+188796 Thread 1 advanced to log sequence 784 (LGWR switch)+188797 Current log# 1 seq# 784 mem# 0: /opt/app/oracle/oradata

--错误代码举例: (from alert_DBSID.log)Tue Mar 22 17:20:29 2011+210778 Process startup failed, error stack:+210779 Errors in file /opt/app/oracle/diag/rdbms/homelink/Homelink/trace/Homelink_psp0_3080224.trc:+210780 ORA-27300: OS system dependent operation:fork failed with status: 12+210781 ORA-27301: OS failure message: Not enough space+210782 ORA-27302: failure occurred at: skgpspawn3-- 解决: 增加虚拟内存.减少SGA,PGA[@more@]

Link:http://sadhus.blog.sohu.com/91144960.htmlsummary:这是和网络连接相关的一个错误,Metalink上给出了如下的解决方案:1.set INBOUND_CONNECT_TIMEOUT_listener_name =0 in listener.ora2. set SQLNET.INBOUND_CONNECT_TIMEOUT = 0 in sqlnet.ora of server.3. stop and start both listener and database.4. Now try to connect to DB and observe the behaviour[@more@]

http://space.itpub.net/9399028/viewspace-682318-- SUMMARY：应用分割，数据分割。总结：分而治之。[@more@]

Link: http://fanqiang.chinaunix.net/a1/b7/20010606/220800418.html-- 开机脚本:在 /etc/inittab 文件中加入类似以下代码.--rc.local 是用户定义的,内空可根据需要自由编写.rc.local:2:wait:/etc/rc.local > /dev/console 2>&1 -- 关机脚本:/etc/rc.shutdown[@more@]

by default , find command use 512 byte as one size unit, and file size will round up to times of 512 bytes. See below and think .If you encounter trouble at default size unit, please use suffix "c" or "k" for exactly file size match.[oracle@tomy_4 test]$ find ./ -size 13c -ls133975 0 lrwxrwxrwx 1 oracle oinstall 13 Sep 5 2009 ./me3 -> /boot/message[oracle@tomy_4 test]$ find ./ -size 6c -ls133963 4 -rw-rw-rw- 1 oracle oinstall 6 Sep 5 2009