<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[weixin_47299913的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/weixin_47299913</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; weixin_47299913]]></copyright><item><title><![CDATA[MySQL重启报错配置文件my.cnf is ignored]]></title><link>https://blog.youkuaiyun.com/weixin_47299913/article/details/146234279</link><guid>https://blog.youkuaiyun.com/weixin_47299913/article/details/146234279</guid><author>weixin_47299913</author><pubDate>Thu, 13 Mar 2025 16:14:50 +0800</pubDate><description><![CDATA[my.cnf设置为用户可读写，其他用户不可写.权限777，任何一个用户都可以改。可以看到mysql停止不了。，存在很大的安全隐患.MySQL关闭成功.]]></description><category></category></item><item><title><![CDATA[Mysql 日志爆满，删除日志文件]]></title><link>https://blog.youkuaiyun.com/weixin_47299913/article/details/146233921</link><guid>https://blog.youkuaiyun.com/weixin_47299913/article/details/146233921</guid><author>weixin_47299913</author><pubDate>Thu, 13 Mar 2025 16:10:02 +0800</pubDate><description><![CDATA[删除日志文件的命令：purge binary logs to ‘mysql-bin.000005’;当前正在使用的日志文件是mysql-bin.000005，那么删除日志文件的时候应该排除掉该文件。第一步：登陆进入mysql，并使用 show binary logs;第二步：查看正在使用的日志文件：show master status;删除除mysql-bin.000005以外的日志文件。删除后就能释放大部分空间。]]></description><category></category></item><item><title><![CDATA[Oracle修改数据文件路径]]></title><link>https://blog.youkuaiyun.com/weixin_47299913/article/details/146229987</link><guid>https://blog.youkuaiyun.com/weixin_47299913/article/details/146229987</guid><author>weixin_47299913</author><pubDate>Thu, 13 Mar 2025 14:24:27 +0800</pubDate><description><![CDATA[对每一个要移动的文件重复执行上面的alter database rename file ... to ...4. 移动文件到新的位置(比如新的位置为/home/data )5. 以mount模式启动数据库。再次查看文件位置，发现已经更该。2. 查看数据文件位置。]]></description><category></category></item><item><title><![CDATA[ORACLE监听报TNS-12555 、TNS-12560、TNS-00525]]></title><link>https://blog.youkuaiyun.com/weixin_47299913/article/details/146229901</link><guid>https://blog.youkuaiyun.com/weixin_47299913/article/details/146229901</guid><author>weixin_47299913</author><pubDate>Thu, 13 Mar 2025 14:21:42 +0800</pubDate><description><![CDATA[3、检查oracle安装目录所属组，发现是oracle:dba, id oracle 显示oracle ..oinstall ..dba ，检查history,发现有人调整了属主。原文链接：https://blog.youkuaiyun.com/weixin_42344665/article/details/137347301。4、修改安装目录属主以及/var/tmp/.oracle属主，属主为root:root==>被人为修改了。1、检查ORACLE所在目录权限以及listener权限，权限无误；]]></description><category></category></item><item><title><![CDATA[Oracle监听程序卡死]]></title><link>https://blog.youkuaiyun.com/weixin_47299913/article/details/146229846</link><guid>https://blog.youkuaiyun.com/weixin_47299913/article/details/146229846</guid><author>weixin_47299913</author><pubDate>Thu, 13 Mar 2025 14:18:49 +0800</pubDate><description><![CDATA[检查、home\oracle\diag\tnslsnr\OEE-PC\listener\trace下listener.log文件，删除该文件,重启监听即可。若该文件过大为4G，]]></description><category></category></item><item><title><![CDATA[Oracle 11表空间扩容]]></title><link>https://blog.youkuaiyun.com/weixin_47299913/article/details/146229615</link><guid>https://blog.youkuaiyun.com/weixin_47299913/article/details/146229615</guid><author>weixin_47299913</author><pubDate>Thu, 13 Mar 2025 14:14:06 +0800</pubDate><description><![CDATA[Oracle 11表空间扩容]]></description><category></category></item><item><title><![CDATA[oracle数据库清理跟踪文件trc和trm]]></title><link>https://blog.youkuaiyun.com/weixin_47299913/article/details/141641526</link><guid>https://blog.youkuaiyun.com/weixin_47299913/article/details/141641526</guid><author>weixin_47299913</author><pubDate>Wed, 28 Aug 2024 15:24:34 +0800</pubDate><description><![CDATA[oracle数据库清理跟踪文件trc和trm]]></description><category></category></item><item><title><![CDATA[oracle-system表空间已满，解决方法]]></title><link>https://blog.youkuaiyun.com/weixin_47299913/article/details/129710892</link><guid>https://blog.youkuaiyun.com/weixin_47299913/article/details/129710892</guid><author>weixin_47299913</author><pubDate>Wed, 22 Mar 2023 15:42:05 +0800</pubDate><description><![CDATA[oracle数据库表空间占满，本人服务器oracle数据库使用的是大数据模式。因此采取清理审计表，关闭审计功能实现清理]]></description><category></category></item></channel></rss>