ITPub博客

 inux下使用rlwrap开源工具，可以在oracle sqlplus下具有linux下命令行功能。比如上下翻命令，等等。一、安装[root@cms2 ~]#unzip rlwrap-0.28.zip[root@cms2 ~]# cd rlwrap-0.28[root@cms2 rlwrap-0.28]...

--前期测试挂的disk /dev/sdb1一直mount不成功，也检查了/etc/fstab基本是正确--经查询,可以在操作系统启动时查看系统日志，一分析是文件系统搞清了，正确是ext2而非ext3[root@rhel5 oracle]# more /var/log/messag...

---启动oracle sqlplus报错bash-3.2$ sqlplussqlplus: error while loading shared libraries: /oracle/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1: cannot restore segment prot after reloc: Perm...

http://linux.chinaunix.net/techdoc/install/2008/06/29/1013918.shtml 处理： mount -o remount,rw /dev/sda1 / vi /etc/fstab

username:company username,my name +. + xingpassword:the same as bofore but the first zimu uppered

http://www.askmaclean.com/archives/howto-change-11gr2-asm-disk-path.html

[root@rhel5 ~]# touch /nbfile[root@rhel5 ~]# ls -l /nbfile -rw-r--r-- 1 root root 0 Jun  5 02:57 /nbfile--chattr命令简介[root@rhel5 ~]# chattr --helpUsage: chattr [-RV] [-+=AacDdijsSu] [-v versio...

---root家目录[root@rhel5 ~]# pwd/root----查看所有文件[root@rhel5 ~]# ls -latotal 128drwxr-x---  2 root root  4096 Jun  4 04:08 .drwxr-xr-x 28 root root  4096 Jun  5 02:24 .....

http://t.askmaclean.com/thread-1249-1-2.html

telnet的改法之一：编辑/etc/servicestelnet xxx/tcptelnet xxx/udpxxx为你想改成的端口号telnet的改法之二：telnet一般都是通过inetd守护进程来调用的，可以修改/etc/inetd.conf(有的发布版可能...

2013-6-3星期一入职新公司yunheenmo.新的起点，走向专业！

2013－5－30星期四于shanghai hongguan离职

---会话1SQL> show userUSER is "TBL_BCK"--会话1执行plsql代码SQL> declare  2  v_out pls_integer;  3  begin  4  for i in 1..1000 loop  5  select count(a) into v_...

--创建表并构建唯一索引SQL> create table t_unique(a int); Table created SQL> create unique index idx_t_unique on t_unique(a); Index created SQL> insert into t_unique values(1);&nbsp...

---建立create or replace procedure proc_exception_initasmy_test_exception exception;--pragma为编译器指令 exception_init有2个参数，各为异常名称和oracle错误号码,即把oracle错误号码和异常名称联系起来--这...

SQL> select to_date(to_char(sysdate,'yyyy-mm')||'_'||level,'yyyy-mm-dd') as everyday from dual connect by  level<=to_char(last_day(sysdate),'dd') order by 1; EVERYDAY-----------2013-05-01201...

http://www.itpub.net/thread-1281365-1-1.html

SQL> show userUser is "SYS" SQL> set transaction read only; Transaction set SQL> insert into t_table values(3); 1 row inserted SQL> commit; Commit complete---sys用户 set...

http://www.ibm.com/developerworks/cn/aix/library/au-wasonlinux/index.html

http://www.ibm.com/developerworks/cn/education/aix/au-enterprisewebsvr/index.html