- 博客(24)
- 资源 (3)
- 收藏
- 关注
原创 awk替换文本字符串
awk ‘{ gsub(/dayhour_behavior_time./,""); print $0 }’ awk.txt
2021-05-29 17:43:50 8850
原创 ORA-12170
Navicat -> 主机 -> 数据库tnscat tnsname.oratnsping bpxlsnrctl statusnetstat -na 1521
2021-05-29 16:53:11 4644
原创 ORA-27102: out of memory
修改操作系统参数shmallcat /etc/sysctl.conf |grep shmallsed -i 's/kernel.shmall = 2097152/kernel.shmall = 107374/g' /etc/sysctl.confsysctl -pcat /etc/sysctl.conf |grep shmall
2021-05-29 11:28:56 2852
原创 ORA-01078: failure in processing system parameters
SQL> startupORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora'[oracle@udbs01 ~]$ cd $ORACLE_HOME/dbs[oracle@udbs01 ~]$ ls没有这个文件哈。。。[oracle@udbs01
2021-05-29 11:25:01 3041
原创 ADG搭建
搭建过程SQL> select force_logging from v$database;SQL> alter database force logging;SQL> select group#, bytes/1024/1024 from v$log;SQL> show parameter db_create_file_destSQL> alter database add standby logfile '+DATA' size 50M;SQL> se
2021-05-28 00:47:10 10
原创 ORA-10456 & ORA-01219
问题SQL> select * from bpx;select * from bpx *ERROR at line 1:ORA-01219: database not open: queries allowed on fixed tables/views onlySQL> alter database open;alter database open*ERROR at line 1:ORA-10456: cannot open standby da
2021-05-28 00:31:36 3078
原创 TNS-12543: TNS:destination host unreachable
问题描述[oracle@udbs01 ~]$ tnsping u01sby1TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 27-MAY-2021 23:31:06Copyright (c) 1997, 2011, Oracle. All rights reserved.Used parameter files:Used TNSNAMES adapter to resolve the aliasAttemp
2021-05-27 23:41:17 6694 1
原创 SQL*Loader
1 概述用于将来自外部文件的数据加载到 Oracle DB 中;它是可用于将数据加载到数据库表中的多个 Oracle 实用程序之一。2使用2.1 编写sqlldr控制文件cat > bpx.ctlload datainfile '/home/oracle/bpx.csv'badfile '/home/oracle/bpx.bad'truncateinto table bpxfields terminated by ','
2021-05-22 16:02:23 3994
原创 Oracle导入csv文件
sqldevelopercd $ORACLE_HOME/sqldeveloper./sqldeveloper.sh可能数据量太大了。。。。SQLLDR欧耶!
2021-05-22 15:41:34 4380
原创 将lab.ipynb转化为lab.md格式
!jupyter nbconvert --to markdown lab.ipynb !cp lab.md /home/shiyanlou/Code/
2021-05-22 00:36:00 3288
原创 HBase
架构HBase 架构:只有一个 Master 节点,称 HMaster,还有多台 RegionServer 成为 HRegionServer,每个 RegionServer 包含多个 Region。Master:集群的管理服务器,为 RegionServer 分配 Region,负责 RegionServer 的负载均衡,处理 schema 更新请求.RegionServer:管理 HBase 的数据存储,维护 Region,处理 IO 请求。Zookeeper:保证集群的高可用性、存储 Regi
2021-05-19 21:54:42 104
原创 RMAN备份
通道 ORA_DISK_1: 启动全部数据文件备份集RMAN 查看备份、通道和并行度配置、RMAN中的交叉校验crosscheckRMAN实战 RMAN备份数据库、控制文件、参数文件、FRA、归档日志
2021-05-19 16:20:39 3323
原创 RMAN-06908: WARNING: operation will not run in parallel on the allocated channels
RMAN-06908: WARNING: operation will not run in parallel on the allocated channelsRMAN-06909: WARNING: parallelism require Enterprise Edition原因:oracle标准版不能开并行
2021-05-19 16:15:40 3835
原创 RMAN-06149: cannot BACKUP DATABASE in NOARCHIVELOG mode
数据库open状态下,非归档模式不能做备份!开启归档!!!
2021-05-19 16:10:57 3987
原创 OGG测试
源端./ggsci: error while loading shared libraries: libnnz11.so: cannot open shared object file: No such file or directory目标端
2021-05-16 18:41:27 2
原创 Hadoop平台相关组件
目录HDFSYARNZookeeperHBaseHiveHDFSNameNodeSecondaryNameNodeDataNode [all]WRANYARNResourceManagerNodeManager [all]ZookeeperQuorumPeerMainensembleQuorumPeerMainHBaseHMasterHRegionHiveRunJar
2021-05-03 23:24:29 187
StudentManagerSSM.rar
2020-08-06
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人