ITPub博客

更改Global_name, domain_name, db_name 的方法refs:http://space.itpub.net/10248702/viewspace-6156101在数据库创建的时候，global_name由db_domain,db_name组成。2当数据库创建完后，对global_name的更改只能通过Alter database rename statement或update global_name set global_name语句来做。且这个结果不会反映回到参数文件中，是保存在数据字典中的。3当数据库创建完后，对参数文件中db_main的修改不会影响数据库的Global_name.[@more@]

V$SQL 中PARSING_USER_ID,PARSING_SCHEMA_ID,PARSING_SCHEMA_NAME这三个字段之间的关系：假如当前用户是HLDBA默认情况下，当前SCHEMA_ID与USER_ID相同，SCHEMA_NAME就是当前用户名(HLDBA)。但是当执行如下语句后，SCHEMA_ID 和SCHEMA_NAME就会发生改变alter session set current_schema="SALESMGMT" ;之后，USER_ID=(HLDBA USERID) , SCHEMA_ID,SCHEMA_NAME 皆属于SALESMGMT用户对应的ID和名字。[@more@]

refs:http://www.linuxidc.com/Linux/2011-04/34164.htm 经实验证实，确实如此，比较吃惊。test platform: windows 7 64bit with oracle 11.2.0.l 64bit.[@more@]

refs:http://os.51cto.com/art/200706/49072.htmhttp://ruyu319.bokee.com/6826116.htmlcommand summary:/kernel/drvgrep "vmxnet" /kernel/drv/*modinfo |grep vmxnetmodload vmxnet # load driver kernel.devfsadm -i vmxnet # Createdevice mappingifconfig vmxnet plumb /unplumb#if you remove the old net Adapter and install a new net Adapter,# then do following:#mv /etc/hostname.ipbr0 /etc/hostname.elxl0 rebootifconfig -a # check the new adapter status.[@more@]

http://blogold.chinaunix.net/u/12270/showart_63598.html[@more@]

summary:CDE:clicking on the Exit button on the CDE Front Panel to get back to the login window select Command Line Login from the Options drop-down list of the login window log in as root at the shell prompt type in kdmconfig and make your desired changes back at the shell prompt, type in init 6 to reboot your system refs:http://solaris-x86.org/documents/tutorials/cde.mhtmlhttp://www.linuxquestions.org/questions/solaris-opensolaris-20/changing-refresh-rate-and-screen-resolution-under-solaris-10-

# banner "ORACLE SUN"####### ###### # ##### # ####### ##### # # # ## # # # # # # # # # # # # # ## ## # # # # # # # # # # # # # ## # ###### # # # # ##### ##### # # # # ## # # # ####### # # # # # # # # ## # # # # # # # # # # # # # #

－－ 以下是个很简单的INSERT 触发更新远程表，其实经过测试，UPDATE,DELETE都是可以支持DBLINK远程更新的。create or replace trigger TRG_t1_bef_ins before insert on t1 for each rowdeclare -- local variables herebegin insert into HLDBA.t1@apptest ( id , name ) values( :NEW.ID , :NEW.NAME ) ;end TRG_t1_bef_ins;[@more@]

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

使用SKIP_CORRUPT_BLOCKS或Event 10231来提取数据http://blog.chinaunix.net/u/12960/showart_229495.html[@more@]

2008 中国首届Oracle数据库精英工程师评选电子试题 和答案http://www.database8.com/ORA_oracle_thread-5802-2-1.htmlhttp://zhulch.itpub.net/post/17395/470005[@more@]