<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[qq_20481521的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/qq_20481521</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; qq_20481521]]></copyright><item><title><![CDATA[oracle 归档日志误删除、手动删除导致数据库启动失败！]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/139654184</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/139654184</guid><author>qq_20481521</author><pubDate>Thu, 13 Jun 2024 15:26:45 +0800</pubDate><description><![CDATA[原文参考：https://blog.youkuaiyun.com/qq_28917403/article/details/81358811。]]></description><category></category></item><item><title><![CDATA[ora-12518：tns listener could not hand off client connection 问题处理]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/136337512</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/136337512</guid><author>qq_20481521</author><pubDate>Wed, 28 Feb 2024 11:15:41 +0800</pubDate><description><![CDATA[参考文章：
https://blog.youkuaiyun.com/study_gis/article/details/79103951
https://blog.youkuaiyun.com/qq_38161040/article/details/118798430
ora-12518：tns listener could not hand off client connection：tns侦听器无法切换客户端连接
原因：
访问量大，数据库无法分发连接数
初级解决方法：
1.利用管理员身份登录数据库，
如无法登录，ora-000]]></description><category></category></item><item><title><![CDATA[安卓模拟器开启ssh服务并登陆]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/127215864</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/127215864</guid><author>qq_20481521</author><pubDate>Sat, 08 Oct 2022 21:07:13 +0800</pubDate><description><![CDATA[利用termux开启安卓模拟器ssh服务]]></description><category></category></item><item><title><![CDATA[oracle_解决windows下oracle11g监听日志过大问题]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/125163129</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/125163129</guid><author>qq_20481521</author><pubDate>Tue, 07 Jun 2022 13:05:27 +0800</pubDate><description><![CDATA[监听日志过大]]></description><category></category></item><item><title><![CDATA[oracle——create、insert语句备份数据]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/125162861</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/125162861</guid><author>qq_20481521</author><pubDate>Tue, 07 Jun 2022 12:34:52 +0800</pubDate><description><![CDATA[表备份]]></description><category></category></item><item><title><![CDATA[揭开正则表达式的神秘面纱]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/123627312</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/123627312</guid><author>qq_20481521</author><pubDate>Mon, 21 Mar 2022 10:50:27 +0800</pubDate><description><![CDATA[请添加图片描述

]]></description><category></category></item><item><title><![CDATA[oracle表空间——查询、扩展、修改]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/122740634</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/122740634</guid><author>qq_20481521</author><pubDate>Sat, 29 Jan 2022 11:03:07 +0800</pubDate><description><![CDATA[--检查表空间情况
select a.tablespace_name,a.bytes/1024/1024 "sum MB",
(a.bytes-b.bytes)/1024/1024 "used MB",b.bytes/1024/1024 "free MB",
round (((a.bytes-b.bytes)/a.bytes)*100,2) "used%" from
(select tablespace_name,sum(bytes) bytes from dba_data_files group by t]]></description><category></category></item><item><title><![CDATA[oracle、分区表_test]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/122740379</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/122740379</guid><author>qq_20481521</author><pubDate>Sat, 29 Jan 2022 10:51:35 +0800</pubDate><description><![CDATA[原文：https://www.cnblogs.com/advocate/archive/2010/09/03/1816628.html
--1.system 用户
--创建表空间
create tablespace part_list 
datafile 'D:\app\Administrator\oradata\test\part_list.ora'
size 10M 
autoextend on next 10M 
maxsize unlimited;

--创建用户并指定表空间
create user]]></description><category></category></item><item><title><![CDATA[Oracle SQL语句优化]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/121577465</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/121577465</guid><author>qq_20481521</author><pubDate>Sat, 27 Nov 2021 16:47:31 +0800</pubDate><description><![CDATA[1.避免使用“*”替代所有列(列过多情况)
select * from test

select tid,tname from test

2.使用truncate 代替 delete 删除表全部数据
turncate talbe table_name [drop | reuse storage]
table_name:表名
drop storage 默认收回被删除的表空间
reuse storage 保留被删除的表空间，以供新数据使用

3.确保数据完整性的情况下多用commit提交语句

4.减少对表的]]></description><category></category></item><item><title><![CDATA[win7_netsh_firewall]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/120764032</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/120764032</guid><author>qq_20481521</author><pubDate>Thu, 14 Oct 2021 15:16:23 +0800</pubDate><description><![CDATA[win7
开启防火墙：net start MpsSvr

（一）
需要额外的：ipmontr.dll
阻止端口：
出站规则设置：
netsh advfirewall firewall add rule name="hold8880" protocol=TCP dir=out localport=8880 action=block

入站规则设置：
netsh advfirewall firewall add rule name="hold8880" protocol=TCP dir=in localport]]></description><category></category></item><item><title><![CDATA[PC安卓模拟器之vdi虚拟硬盘内容抢救]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/120696263</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/120696263</guid><author>qq_20481521</author><pubDate>Mon, 11 Oct 2021 09:45:45 +0800</pubDate><description><![CDATA[问题描述：
更改模拟器WiFi网络为静态地址后界面卡死、黑屏，重启后鼠标点击失灵，WiFi后台循环尝试连接，模拟器网络异常报错！

尝试解决方法：
1.模拟器自带修复方法，重置PC网络-----false

2.模拟器界面点击、模拟器自带工具点击试图唤醒程序-----false

3.程序升级、降级-----false

4.保留旧程序，重新安装程序并替换主程序文件-----false

5.（首选）7z.exe压缩程序-----true or false
两个虚拟硬盘文件、第一个可以打开，第二个提示不支持]]></description><category></category></item><item><title><![CDATA[win7命令行设置IP地址]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/120366608</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/120366608</guid><author>qq_20481521</author><pubDate>Sat, 18 Sep 2021 14:47:35 +0800</pubDate><description><![CDATA[开始--cmd

设置ipv4地址值:(dhcp)
--"无线网络连接" 替换为 需要设置 网络客户端名称

netsh interface ip set address "无线网络连接" dhcp

设置ipv4地址值:(static)
--static 后面依次为 IP地址、子网掩码、默认网关

netsh interface ip set address "无线网络连接" static 192.198.0.2 255.255.255.0 192.198.0.1



netsh ?

用法: nets]]></description><category></category></item><item><title><![CDATA[plsql之procedures、job的简单应用]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/120345142</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/120345142</guid><author>qq_20481521</author><pubDate>Fri, 17 Sep 2021 11:39:53 +0800</pubDate><description><![CDATA[procedures
代码：

create or replace procedure UP_EMPLOYEES as

begin

(相关sql语句)
update UP_EMPLOYEES
set xm='zhangsan'
where xh='1' 

commit;
end UP_EMPLOYEES;


job
相关
what：UP_EMPLOYEES; --定时任务的过程 
interval：trunc(sysdate,'hh')+1/(24) --执行时间每小时执行


...]]></description><category></category></item><item><title><![CDATA[sqlplus之spool导出查询数据]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/120343965</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/120343965</guid><author>qq_20481521</author><pubDate>Fri, 17 Sep 2021 10:55:51 +0800</pubDate><description><![CDATA[导出数据格式*.txt/*.csv/*.xls

脚本：
set echo off --回显
set colsep , --数据分隔符
set trimout on --去除标准输出结尾空格
set trimspool on --去除spool输出结尾空格
set linesize 1000 --控制每行字符的个数
set pagesize 0 --每页显示的行数 0不限制
set heading off --控制列明显示
set termout off --脚本执行命令生成输出显示
set feedbac]]></description><category></category></item><item><title><![CDATA[mysql-库和表的管理]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/115352634</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/115352634</guid><author>qq_20481521</author><pubDate>Wed, 31 Mar 2021 15:57:08 +0800</pubDate><description><![CDATA[库和表的管理-婷姐#DDL 数据库定义语言 database definition language库和表的管理#一、库的管理#1、库的创建#2、库的修改#3、库的删除#二、表的管理#1.表的创建 ★#2.表的修改#3.表的删除#4.表的复制案例讲解：
#DDL 数据库定义语言 database definition language

库和表的管理
创建： create、修改： alter、删除： drop
一、库的管理
创建、修改、删除
二、表的管理
创建、修改、删除

#一、库的管理
#1、库的创建
]]></description><category></category></item><item><title><![CDATA[mysql基础查询概念]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/115352557</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/115352557</guid><author>qq_20481521</author><pubDate>Wed, 31 Mar 2021 15:54:42 +0800</pubDate><description><![CDATA[MySQL文档资料-婷姐一、MySQL数据库的相关概念1.数据库的好处2.数据库的常见概念 ※3.数据库存储数据的特点4.常见数据库管理系统二、MySQL介绍1.背景2.MySQL优点3.MySQL安装4.MySQL服务停止与启动5.MySQL登录与退出三、数据库基本语言：一、DDL（data definition language）数据库定义语言1.库的管理（创建、修改、删除）1.创建数据库2.修改数据库3.删除库2.表的管理（创建、修改、删除）1.创建表*2.修改表3.删除表4.复制表（表结构、表数据）]]></description><category></category></item><item><title><![CDATA[win/linux（黑窗口常见命令对比使用）]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/103079001</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/103079001</guid><author>qq_20481521</author><pubDate>Wed, 31 Mar 2021 15:47:38 +0800</pubDate><description><![CDATA[win
关机重启命令：shutdown
查看网络地址信息：ipconfig
检查网络通断：ping
目录切换：cd
目录查看：dir
显示当前目录：看前缀即可
创建空文件夹：md
创建空目录：mkdir
查看txt件内容：直接输入文件名.txt/创建txt文件 cd.&gt;1.txt
复制文件：cp
移动文件：move
删除文件：del
搜索文件：for /r  用法：find /r 目录名 %...]]></description><category></category></item><item><title><![CDATA[光猫、光纤收发器、路由器、交换机]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/103138093</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/103138093</guid><author>qq_20481521</author><pubDate>Wed, 31 Mar 2021 15:31:34 +0800</pubDate><description><![CDATA[光猫：将光以太信号转换成其他协议信号的收发设备，也称为单端口光端机，作为本地网的中继传输设备，用于基站的光线终端传输及以租用线路（个人）“modem”、“光modem”、“光猫”、“光调制解调器”。
光线收发器：将短距离的双绞线电信号和长距离的光信号进行互换的以太网传输媒体转换单元，“光电转换器”用于以太网无法覆盖，必须使用光纤来延长传输距离的实际网络环境中。

...]]></description><category></category></item><item><title><![CDATA[子网掩码的计算方法（subnet mask）]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/103141355</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/103141355</guid><author>qq_20481521</author><pubDate>Wed, 31 Mar 2021 15:28:45 +0800</pubDate><description><![CDATA[！子网掩码划分
1.什么是网络号？
网络号一般为每一段IP地址的第一组，通常用于表示某一段IP池
F：192.168.1.0/24 表示192.168.1.0-192.168.1.255/255.255.255.0
2.什么是广播号？
广播号是每一段IP地址的最后一组，通常用于网络中的广播
F：192.168.1.0/24 其中最后一组192.168.1.255 就是该段IP的广播号
3.什么是子...]]></description><category></category></item><item><title><![CDATA[快乐的Linux]]></title><link>https://blog.youkuaiyun.com/qq_20481521/article/details/115349210</link><guid>https://blog.youkuaiyun.com/qq_20481521/article/details/115349210</guid><author>qq_20481521</author><pubDate>Wed, 31 Mar 2021 14:52:39 +0800</pubDate><description><![CDATA[快乐的Linux一、什么是shell二、探究操作系统三、操作文件和目录四、什么是命令五、重定向六、从shell眼中看世界七、键盘高级操作八、权限九、进程十、shell环境十一、vi简介十二、自定制 **shell** 提示符十三、软件包管理十四、存储媒介十五、网络系统十六、查找文件十八、正则表达式（略）十九、文本处理（略）二十、格式化输出二十一、打印（CUPS）二十二、编译程序二十三、编写第一个 **Shell** 脚本二十四、启动一个项目二十五、自顶向下设计二十六、流程控制：**if** 分支结构二十七、]]></description><category></category></item></channel></rss>