脚踏实地、勇往直前!
全部博文(1005)
发布时间:2013-12-27 15:13:20
今天启动mysql报错误,查看/var/lib/mysql/mydb.err有如下的信息131227 14:24:01 mysqld_safe mysqld from pid file /var/lib/mysql/richinfo-dev2.pid ended131227 14:24:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql131227 14:24:51 [Warning] Changed limits: max_open_files: 1024&.........【阅读全文】
发布时间:2013-12-26 13:55:16
1.关闭数据库SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.2.将当前目录的数据文件迁移到指定目录mv tps_hxl02.dbf ../oraclbak mv tps_hxl03.dbf ../oraclbak3.启动数据库到mount状态SQL> connect / as sysdbaConnected to an idle instance.SQL> s.........【阅读全文】
发布时间:2013-12-18 16:08:10
为了保持主备库的在线日志文件组保持一致,在主库添加后需要在备库也相应的添加,步骤如下:1.退出日志应用模式SQL> alter database add logfile group 8 ('/u01/app/oracle/oradata/oracl/redo04.log') SIZE 512m;alter database add logfile group 8 ('/u01/app/oracle/oradata/oracl/redo04.log') SIZE 512m*.........【阅读全文】
发布时间:2013-12-05 15:56:05
今天在安装oracle 11GR2的时候,有两项package检查没有通过,提示缺少如下两个包:elfutils-libelf-devel-0.125-3.el5.i386.rpmelfutils-libelf-devel-static-0.125-3.el5.i386.rpm于是逐一安装[root@host1 Server]# rpm -ivh elfutils-libelf-devel-0.125-3.el5.i386.rpmwarning: elfutils-libelf-devel-0..........【阅读全文】
发布时间:2013-12-04 17:09:24
环境:OS:Linux As 5DB:11GR2在linux下安装11GR2的时候,步骤1需要填写email地址,安装提示输入email地址后,提示如下错误:Unexpected error occurred while validating inputs at state 'getOCMDetails'. 该错误是因为没有安装pdksh的原因,将该包安装好后,问题解决.1.下载pdksh2.安装pdksh[root@host1 soft]# rpm -.........【阅读全文】