ITPub博客

1. Oracle软件安装, 运行./runInstaller 报错Checking monitor: must be configured to display at least 256 colors   >>> Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set.    Failed

1. [oracle@11GR2-test ~]$ export DISPLAY=192.168.181.128:1在虚拟机中安装ORACLE, 设置完DISPLAY变量后,运行xhost +命令无法找到,明显为xhost相对应的rpm包未安装.用yum命令加参数whatprovides 加xhost查到相对应的包为xorg-x11-server-utils-7.7-14.el6.x86_64,如下图.2. [root@11GR2-test ~]# yum whatprovides *...

Patch 27282436Combo OJVM PSU 11.2.0.4.180116 and GI PSU 11.2.0.4.180116 Patch 27107360 ?GI PSU? ? ?Oracle Grid Infrastructure Patch Set Update 11.2.0.4.180116 (Includes Database PSU 11.2.0.4.180116)1. RAC生产库打补丁前,请做好DB RMAN全库备份.2. oracle与grid家目录备份,...

DG搭建   1.DG之RMAN Duplicate方式环境：                    IP              DB_NAME    DB_UNIQUE_NAME     ORACLE_SID    DB PORT主库：192.168.1.69     hsi...

#oracle_home备份 $ echo $ORACLE_HOME/u01/app/oracle/product/11.2.0/db_1$pwd/u01/app/backup$$nohup tar -cvf db_1.tar /u01/app/oracle/product/11.2.0/db_1 &1 OPatch Utility      You must use the OPatch utility version 11.2.0.3.6 or later to apply this patch.   ...

打补丁前,查看DB实例状态[oracle@beihangedw05 ~]$ srvctl status database -d oddInstance odd1 is running on node beihangedw05Instance odd2 is running on node beihangedw06Instance odd3 is running on node beihangedw07Instance odd4 is running on node beihangedw08odd为4个节点的RAC1.对ODD集群各节...

1.DB源库oracle_home备份1.1. 创建backup与patch目录.[oracle@ecdb ~]$ cd /u01/app/[oracle@ecdb app]$ [oracle@ecdb app]$ mkdir backup[oracle@ecdb app]$ mkdir patch[oracle@ecdb app]$ pwd/u01/app[oracle@ecdb app]$ ll -athrtotal 28Kdrwxrwxr-x. 4 oracle oinstall 4.0K Jan 17 17:12 ..drwxrwx...

JIEYU119> SELECT owner,constraint_name,constraint_type,table_name,status 2 FROM user_constraints 3 WHERE table_name LIKE 'ORIG%';OWNER CONSTRAINT_NAME C TABLE_NAME STATUS--------------- ------------------------------ - ------------------------------ --------JIEYU119 PK_ORIGTABLE_ID P ORIG_TABLE_TEMP ENABLED

测试库今天巡检DB alert日志发现如下报错,Non critical error ORA-00001 caught while writing to trace file“xxx”, 详细查询如下红色标识原因为, DB空间不足。查询ORA-00001报错如下, 介绍ORA-00001能触发的原因, 并非为空间不足问题引起的, 而此处DB因空间问题引发ORA-00001异常,应该为DB(11.2.0.1.0)一个BUG.[o...

Linux下查看cpu,内存,硬盘大小及型号信息dmidecode -q  |grep Product    ---Linux下查服务器型号cat /proc/cpuinfo | grep 'model name' |uniq  查CPU大小及型号.cat /proc/meminfo | grep MemTotal 或 free -m     --Linux下物理内存大小dmidecode |grep -A16 "Memory Device$...

操作环境:1. OS : CentOS release 6.5 (Final)    DB: 11g(11.2.0.1.0) 2. 异常现象: 对Oracle 数据库3个用户(test1,test2,test3), 做expdp导出,sql如下.      2.1  expdp system/systemtest directory=dump_dir schemas=test1,test2,test3  dumpfile=expdp_test...

1.安装jdk.    我下载的jdk包为jdk-8u25[root@pretest packages]# ll jdk-8u25-linux-x64.rpm -rw-r--r-- 1 root root 142191827 Dec  9 17:37 jdk-8u25-linux-x64.rpm安装jdk包后, /etc/profile 编译java环境变量.export JAVA_HOME=/usr/java/jdk1.8.0_25export CLASSPATH=.:$JAVA_HOME/jr...

Linux SVN安装1.查询subversion包在Server上安装没有.[root@pretest ~]# rpm -qa |grep subversionsubversion-1.6.11-10.el6_5.x86_64如上所述,此处Server已经安装.如果没有安装,需要进行安装此包.2.创建svn目录.[root@pretest ~]# [root@pretest ~]# mkdir -p /data/svn/svnrepos[root@pretest ~]# ll /...

centos openfire rpm包安装.1. linux jdk rpm包安装.[root@mail packages]# rpm -ivh jdk-8u25-linux-x64.rpm Preparing...                ########################################### [100%]   1:jdk1.8.0_25            ...

1. 环境 OS: Centos 6.6(bit).           mysql源码:mysql-5.7.4-m142. mysql 安装完成后,因为mysql root用户密码为空,正常第一次mysql不加密码,可以直接登录. 此处mysql安装完,mysql不能直接登录,报异常root@pretest packages]# mysqlERROR 1045 (28000): Access denied for user 'roo...

1.查看vsftp包是否安装.    如下本机已经安装过.如果vsftpd包未安装,可以用yum install vsftpd进行安装.[root@extw2 ~]rpm -qa |grep ftpvsftpd-2.2.2-12.el6_5.1.x86_64   2.启动vsftpd服务[root@extw2 ~]# service vsftpd startStarting vsftpd for vsftpd: [  OK  ]3.配置vsftp...

1. 检查snmp相关rpm包是否在linux主机上存在.   1.1 可以用rpm -qa |grep snmp查看, 如果snmp相关rpm包不存,一种方法,可以去光盘包中找到相关包去rpm -ivh xxx去安装,另一种方法是配置yum网络源,此处我配置的是163的网络yum源,进行yum install安装,可以把rpm相关的依赖包,交给yum去解决.   1.2 如...

1.  Oracle 11gR2 Oracle安装时,需要pdksh包.进行rpm安装.[root@jietextdb  packets]# rpm -ivh pdksh-5.2.14-*warning: pdksh-5.2.14-37.el5.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 1d1e034b: NOKEYerror: Failed dependencies:        pdksh conflicts with ksh-20120801-...

CentOS 6.5(64bit)安装Oracle 11gR2, 修改完CentOS内核参数配置文件/etc/sysctl.conf,  进行sysctl -p编译时,报如下错误(如下红色文字).[root@jietextdb ~]# sysctl -pnet.ipv4.ip_forward = 0net.ipv4.conf.default.rp_filter = 1net.ipv4.conf.default.accept_source_route = 0kernel.sysrq = 0kernel.co...

ORA-00838: Specified value of MEMORY_TARGET is too small