- 博客(158)
- 收藏
- 关注
原创 Oracle datafile在linux文件系统上的头大小
Oracle在linux文件系统上,用一个表空间block size大小字节的空间,作为OS文件的头。验证如下:07:01:27 SYS@ora11g> create tablespace test datafile '/u01/app/oracle/oradata/ora11g/test.dbf' size 10m blocksize 32k;create tablespace...
2020-03-03 20:11:46 318
原创 code 6101 和 code 6111的解决办法
<<<< code 6101 和 code 6111的解决办法<<<<<<<< kdbchk: row locked by non-existent transaction<<<< table=0 slot=0<<<< lockid=2...
2020-03-02 09:26:15 2711
原创 consistency value in tail 不一致的恢复
用BBED修复tailchk错误导致的坏块:<<<检查alert日志,发现96033损坏SYS@ora11g> select * from songyb;select * from songyb*ERROR at line 1:ORA-01578: ORACLE data block corrupted (file # 1, block # 96033)...
2020-02-26 21:07:02 275
原创 OBJD MISMATCH diskobj错误修复
在做恢复测试,几次都遇到了ORA-08103: object no longer exists错误,后来索性将其解决了,解决过程记录一下:primary:/home/oracle/tools$sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 28 22:57:38 2019Copyright ...
2020-02-26 20:46:16 589
原创 MD5 For Windows
certutil -hashfile filename MD5 certutil -hashfile p29832062_122010_MSWIN-x86-64.zip SHA1 certutil -hashfile filename SHA256 Oracle Database 12.2.0.1.0 for Linux x86-64 V8399...
2019-09-12 20:51:29 385
原创 12c datapatch Could not open logfile
Connecting to database...OKBootstrapping registry and package to current versions...doneDetermining current state...doneCurrent state of SQL patches:Bundle series PSU: ID 190416 in the binary ...
2019-09-12 20:44:52 557
原创 关于监听密码的设置问题
pre-10gR1=======有两种办法设置密码,分为明文和暗文:1.Clear text Password(i)Add PASSWORDS_ entry to your existing listener.ora file.e.g.PASSWORDS_listener1 = (p1,p2)(ii)Stop your listener, and restart it.Now p
2017-08-29 21:44:00 1667
原创 MySQL关闭密码强度验证
关于密码强度验证:[root@mysql mysql]# mysql -uroot -p123456mysql: [Warning] Using a password on the command line interface can be insecure.Welcome to the MySQL monitor. Commands end with ; or \g.Your
2017-06-21 23:49:40 5137
原创 Done with "file /usr/share/mysql/czech/errmsg.sys from install of mysql-community-common-5.7.9-1.el6
安装时报如下错误:[root@mysql tmp]# rpm -ivh mysql-community-server-5.7.9-1.el6.x86_64.rpm warning: mysql-community-server-5.7.9-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYerror:
2017-06-21 23:29:48 3366 1
原创 MySQL学习笔记2-System administration(set password)II
发现在5.7.18版本中,不能按照前面说的修改密码,可以按照下面的操作修改:在第一个窗口执行:[root@mysql mysql]# service mysqld stopStopping mysqld: [ OK ][root@mysql mysql]# /usr/bin/mysqld
2017-06-21 23:24:16 407
原创 两招让你知道数据库消耗IO的进程是谁?
两招让你知道数据库消耗IO的进程是谁?在某客户现场保障,客户反映说“服务开通系统”IO占用率100%...
2017-03-06 10:26:59 2287
转载 ogg简单维护命令--转jelephant
1.查看进程状态GGSCI (PONY) 2> info all2.查看进程详细状态,有助于排错GGSCI (PONY) 2> view report +进程名称3.查看告警日志信息GGSCI (PONY) 2> view ggsevt4. 查看延时,以及文件抽取应用情况GGSCI> lag 可以查看详细的延时信息。例如:GGSCI (db4) 1
2016-03-30 10:49:23 727
原创 Unable to install ORACHK utility on AIX platform --Oracle Tools
Hi All, We are facing below issue while installing ORACHK utility on AIX platform. With our analysis, we got to know that orachk needs bash shell to run, which is currently not enabled in our
2016-01-26 11:44:36 1145
转载 oratop - Utility for Near Real-time Monitoring of Databases, RAC and Single Instance (Doc ID 1500864
In this Document Purpose Requirements Configuring Instructions Quick Start Guide Script
2016-01-24 20:51:30 2065
转载 Main Note - Oracle GoldenGate - Supplemental Logging
The query below will tell you if Supplemental Logging is turned on at the database level:select SUPPLEMENTAL_LOG_DATA_MIN, SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI, FORCE_LOGGING
2016-01-20 23:33:49 799
原创 Certification, Software Downloads, and Support Coverage
很多人都在问GoldenGate 10.x.x.x是否可用于Oracle 9i and so on,通过MOS的certification可以找到答案,关键部分摘录如下,供参考Certification, Software Downloads, and Support CoverageCertificationOracle GoldenGate certification infor
2016-01-20 21:03:46 509
原创 How to Set Up Replication--MySQL Concept
Thissection describes how to set up complete replication of a MySQL server. Thereare a number of different methods for setting up replication, and the exact methodto use depends on how you are setting
2016-01-14 18:47:57 720
转载 Auto-tuning: Shutting Down Background Process GTX (Doc ID 1481153.1)
In this Document Symptoms Changes Cause SolutionAPPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2
2016-01-14 11:25:34 3397
原创 Using Option Files --MySQL Concept
Using Option FilesMostMySQL programs can read startup options from option files (also sometimescalled configuration files). Option files provide a convenient way to specifycommonly used options so t
2016-01-11 18:29:49 495
转载 ORA-03137: TTC Protocol Internal Error : [12333] Using JDBC Driver (文档 ID 752297.1)
In this Document Symptoms Cause Solution ReferencesAPPLIES TO:JDBC - Version 11.1.0.6 and laterInformation in this documen
2016-01-07 14:18:27 1237
转载 Troubleshooting ORA-3137 [12333] Errors Encountered When Using Oracle JDBC Driver (文档 ID 1361107.1)
In this Document Purpose Troubleshooting Steps Known Database Issues Unpublished Bug 8625762 - ORA-3137 [12333] due to bind data not read fr
2016-01-07 14:17:12 4791
转载 Understanding and Diagnosing ORA-00600 [12333] / ORA-3137 [12333] Errors (文档 ID 389713.1)
In this Document Purpose Troubleshooting Steps ReferencesAPPLIES TO:Oracle Database - Enterprise Edition - Version 8.1.7.4 and laterInform
2016-01-07 14:15:13 1101
原创 BATCHSQL--GoldenGate Parameter
BATCHSQLValid for ReplicatUsethe BATCHSQL parameter to increase theperformance of Replicat. BATCHSQL causesReplicatto organize similar SQL statements into arrays and apply them at an accelerat
2016-01-06 22:14:11 942
原创 INSERTDELETES&NOINSERTDELETES--GoldenGate Parameter
INSERTDELETES | NOINSERTDELETESValid for ReplicatUse the INSERTDELETES and NOINSERTDELETES parameters to control whether or not OracleGoldenGate converts source delete operations to insert opera
2016-01-06 20:07:28 826
原创 linux下删除大量小文件方法汇总
除了链接http://www.jb51.net/article/46496.htm中提到的下列六种方法外,再补充一种方法,并附加测试过程:for i in $(seq 1 500000)for> dofor> echo test >>$i.txtfor> donetest time rm -f *zsh: sure you want to delete all the files
2015-12-30 19:12:11 2630
原创 MySQL学习笔记-04_Server_Config(mysqld --verbose --help)
[root@songyb usr]# mysqld --verbose --help2015-11-11 17:32:14 0 [Note] mysqld (mysqld 5.6.27) starting as process 4699 ...2015-11-11 17:32:14 4699 [Note] Plugin 'FEDERATED' is disabled.mysqld V
2015-11-19 20:52:19 2193
原创 MySQL学习笔记-04_Server_Config
Server ConfigurationMySQL Configuration OptionsYou can specify startup options on the command line when you invoke the server (or client), or in an option file. MySQL client programs look for op
2015-11-19 20:50:56 551
原创 MySQL学习笔记2-System administration(set password)
安装完毕后,第一次登录mysql,修改密码[root@localhost bin]# service mysql startStarting MySQL.. SUCCESS! [root@localhost bin]# cat /root/.mysql_secret# The random password set for the root user at Tue Nov 17
2015-11-17 15:51:32 627
原创 MySQL学习笔记2-System administration(STOP or START MySQL)
START MYSQL[root@localhost bin]# service mysql startStarting MySQL.. SUCCESS! [root@localhost bin]# ps -ef | grep mysqlroot 5548 1 0 22:00 pts/2 00:00:00 /bin/sh /usr/bin/mysqld_s
2015-11-17 15:49:31 396
原创 MySQL学习笔记2-System administration(uninstall mysql)
1、查找以前是否装有mysql命令:rpm -qa|grep -i mysql可以看到mysql的两个包:[root@localhost init.d]# rpm -qa | grep -i mysqlMySQL-server-5.6.27-1.el6.i686MySQL-client-5.6.27-1.el6.i6862、删除mysql删除命令:rpm -e
2015-11-17 14:28:27 370
原创 MySQL学习笔记2-System administration(Installing MySQL-5.6.27)
[root@songyb mysql56]# tar -xvf MySQL-5.6.27-1.rhel5.i386.rpm-bundle.tar MySQL-shared-compat-5.6.27-1.rhel5.i386.rpmMySQL-devel-5.6.27-1.rhel5.i386.rpmMySQL-shared-5.6.27-1.rhel5.i386.rpmMySQL
2015-11-13 15:33:09 482
转载 常见分区加载方法
常见分区加载方法:mount挂载iso文件:#mkdir /mnt/iso1#mount –o loop linuxsetup.iso /mnt/iso1在linux 不需要虚拟光驱,就可以直接读取iso文件了。看到你VMWARE上右下角的那个小光驱后编辑它,选中你的ISO后:[root@songyb dev]# mount /dev/cdrom
2015-11-13 14:10:34 569
转载 Linux(RHEL)5.4/5.5/5.8/6.0/6.3 ISO镜像文件-下载地址
版本有RedHat Enterprise Linux(RHEL)5.4/5.5/5.8/6.0/6.3 ISO镜像文件下载地址:RHEL 5.4 ISO下载http://rhel.ieesee.net/uingei/rhel-server-5.4-i386-dvd.isohttp://rhel.ieesee.net/uingei/rhel-server-5.4-x86_64-dvd
2015-11-13 11:57:36 7886
原创 MySQL学习笔记2-System administration(Installing MySQL on Linux Using RPM Packages)
2.5.5 Installing MySQL on Linux Using RPM PackagesNoteTo install or upgrade to MySQL 5.7.2 or later, be sure to read the special instructions at the end of this section.The rec
2015-11-11 19:55:59 637
原创 MySQL学习笔记2-System administration
System administration=======================MySQL Server DistributionsMySQL is available for several operating systems, including Linux, Windows, Mac OS X, and Oracle SolarisMySQL is a
2015-11-11 16:20:55 543
原创 MySQL学习笔记1-MySQL Architecture
ArchitectureNote the difference between a server and a host:o Server: A software program (mysqld) with a version number and a list of featureso Host: The physical machine on which the server progr
2015-11-10 20:23:54 559
原创 ORA-00845: MEMORY_TARGET not supported on this system
[main] [ 2015-07-07 17:08:25.109 EDT ] [UsmcaLogger.logException:164] SEVERE:method oracle.sysman.assistants.usmca.backend.USMInstance:configureLocalASM[main] [ 2015-07-07 17:08:25.109 EDT ] [UsmcaLog
2015-07-07 23:41:16 1645
原创 inventory.xml中的Oracle_home已存在
重新安装RAC数据库时报下列错误:Remote 'AttachHome' failed on nodes: 'prod02'. Refer to '/u01/app/oraInventory/logs/installActions2015-07-06_10-45-26PM.log' for details.It is recommended that the following comman
2015-07-06 23:38:38 4120
原创 11gR203 add node for RAC
RAC添加节点要点、步骤和遇到的问题:要点:1、不需要停其他节点,可以说不影响正在运行的节点。2、不需要下载安装介质。步骤:--delete清理失败的节点:1. Reconfigure the RDBMS Services in the cluster to take into account node 2 is gone. 1.1 Reconfigure th
2015-07-06 21:05:52 1327
原创 11gR203 inventory 被误删后的恢复
在添加节点时,错误的删除了存活节点的inventory目录,解决办法如下:su - gridcd /u01/11.2.0/grid/oui/bin./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES={prod02}" CRS=TRUE ORACLE_HOME
2015-07-06 20:44:51 626
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人