pl/sql developer使用技巧
1.自动替换 例如输入s,按下空格,自动替换成SELECT tools-->preferences --> editor -->autoreplace 选择目录 short.txt内容s=selectf=from sf=select * from
SP2-0618: Cannot find the Session Identifier
oracle 11gscott@ORCL>set autot traceSP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabledSP2-0611: Error enabling STATISTICS reportsys@ORCL>grant PLUSTRACE to scott;grant PLUSTRACE to scott *ERROR at line 1:ORA-01919: role 'PLUSTRACE' does ...
pl/sql developer中文显示乱码
pl/sql查询数据时出现乱码解决方法 环境变量 nls_lang SIMPLIFIED CHINESE_CHINA.ZHS16GBK
pl/sql developer 显示Window List窗口
默认情况下Window List窗口是不显示的,这十分不方便(一)在菜单项的Tools下的Preference选项中的User Interface中选择Option,在右边对于的Autosave desktop中把前面的复选框勾选上。(二)在菜单项的Tools下的Window list选项勾上。通过上面两步设置,关闭后下次打开Window List窗口将保持显示...
11
11
文本文件用sqlldr工具导入到oracel数据库中
1
python安装
1.下载 https://www.python.org/downloads/ 下载2.7.11的版本python-2.7.11.msi2.环境变量配置 path=d:\python273.下载python for eclipse插件 org.python.pydev.feature-1.6.3.2010100513.zip解压后,会发现有features、plugins两个文件夹,然后把features文件夹下的文件移到D:\eclipse\features目录下,把p...
MySQL安装
1.查看mysql包是否安装[root@localhost ~]# rpm -qa | grep mysql2、添加mysql组和用户[root@localhost ~]# groupadd mysql[root@localhost ~]# useradd -r -g mysql -s /bin/false mysql3、解压到/usr/local目录下[root@localhost home]# tar -zxvf mysql-5.7.12-linux-glibc2.5-x86_64.tar.gz -C /usr/local/4...
应用
https://192.168.0.55:446/
openfiler安装
afa
linux jdk rpm包安装
1.安装[root@OCM u01]# rpm -ivh jdk-7u79-linux-i586.rpm Preparing... ########################################### [100%] 1:jdk ###############################...
linux格式化
mkfs [ -V ] [ -t fstype ] [ fs-options ] filesys [ blocks ][root@localhost ~]# mkfs -t ext3 /dev/sdb1mke2fs 1.39 (29-May-2006)Filesystem label=OS type: LinuxBlock size=4096 (log=2)Fragment size=4096 (log=2)368000 inodes, 734965 blocks36748 blocks (5.00%) reserved for the super userFirs...
linux分区(1)
最多只能分四个主分区,如果要建多于四个的分区,就要拿出一个主分区做为扩展分区使用fdisk进行分区[root@localhost ~]# fdisk /dev/sdbDevice contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabelBuilding a new DOS disklabel. Changes will remain in memory only,until you dec...
rhel6.4本地配置yum
1.挂载[root@localhost cdrom]# mount -o loop /u01/Red\ Hat\ Enterprise\ 6.5\ x86_64.iso /mnt/cdrom2.vi rhel-source.repo[root@localhost yum.repos.d]# cat rhel-source.repo[rhel-source]name=Red Hat Enterprise Linux $releasever - $basearch - Sourcebaseurl=file:///mnt/cdromenabled=1gpgcheck=...
CentOS 7 修改主机名
hostnamectl set-hostname dbcat /etc/hostnamehostname文件将自动更新vi /etc/hosts192.168.1.56 db
oracle 11g 监听文件
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.56)(PORT = 1...
rhel 5.5UDEV绑定asm磁盘
1.添加一个20g硬盘,然后分区2.在redhatlinux5_64.vmx中添加disk.EnableUUID= "TRUE"3.获取id [root@oracle11g ~]# scsi_id -g -u -s /block/sdb36000c29d132ecb3f52081ab0f445b4934.配置udev配置文件cd /etc/udev/rules.dvi 99-oracle-asmdisk.rulesKERNEL=="sdb1",BUS=="scsi", PROGRAM=="/sbin/scsi_i...
ora-09925
root根目录变成read-only,无法写文件系统,Oracle因为无法写audit文件也无法正常登陆 。通过dmesg发现EXT3 文件系统存在问题。可以通过使用fsck命令修复文件系统,命令也执行不了(fsck可能会导致数据块损坏,最好是不做fsck,重启一下服务器)。Linux系统出问题...
jvisualvm监控tomcat
启动jvisualvm工具 出现jvisualvm图形界面 但是没有看到本地tomcat,因为tomcat还没有开启jmx功能,在java options中增加如下设置-Dcom.sun.management.jmxremote.port=8999-Dcom.sun.management.jmxremote.ssl=false -Dcom.sun.management.jmxremote.authenticate=false 然后重新启动tomcat...
CentOS 7下安装Oracle 11g
1.配置本地yum源[root@localhost yum.repos.d]# mount /dev/cdrom /mnt编辑/etc/yum.repos.d/CentOS-Debuginfo.repo[base-debuginfo]name=CentOS-7 - Debuginfobaseurl=file:///mntgpgcheck=0gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-Debug-7enabled=1禁用CentOS-Base.repo2.安装包 使用yum安...