ITPub博客

EXP-00106 导出数据提示查询发现此用户存在 dblink但是dblink无法查询由于此dblink不使用直接drop,重新导入此时可以导入了。

之前ctl文件定义点击(此处)折叠或打开LOAD DATACHARACTERSET ZHS16GBKINFILE 'wxls.csv'APPENDINTO TABLE temp_import20171201FIELDS TERMINATED BY ","TRAILING NULLCOLS(TEL,...

powershell 替换hosts文件

当我们进行手动resize的时候报如下错误点击(此处)折叠或打开SQL> alter database tempfile '/u01/app/oracle/oradata/orcl/temp01.dbf' resize 16G;alter database tempfile '/u01/app/oracle/oradata/orcl/temp01.dbf' resize 16G*ERROR at line ...

1.建议vim版本在7.3以上(py3env) [root@mysqltest-213-2 pytonstudy]# vim --versionVIM - Vi IMproved 7.4 (2013 Aug 10, compiled Dec 21 2016 17:10:41)Included patches: 1-207, 209-629Modified by Compiled by 下载https://github.com/VundleVim/Vundle.vim...

dataguard 由于主库参数未配置归档删除策略导致库归档丢失今天巡检库时候发现备库未启动，监控agent也被人关闭了，手动启动按照日志惯例打开备库(read_only)，但是在open的过程中显示以下错误Standby crash recovery failed to bring standby database to a consistentpoint because needed redo hasn't arrived yet....

mysql无备份恢复

一.安装undrop-for-innodb工具[root@mysqltest-213-2 tools]# unzip undrop-for-innodb-master.zip安装依赖包yum -y install gcc flex bisoncd undrop-for-innodb-mastermake[root@mysqltest-213-2 undrop-for-innodb-master]# makecc -D_FILE_OFFSET_BITS=64 -Wall -g -O3 -pipe  -I./include -c stream_...

plsql登录出现TNS-12541lsnrctl status一直无反映检查监听日志发现如下 TNS-12531: TNS:cannot allocate memory02-NOV-2017 14:16:46 * 12531TNS-12531: TNS:cannot allocate memory02-NOV-2017 14:16:46 * 12531TNS-12531: TNS:cannot&nb...

今天遇见客户报故障，数据库无法open,启动数据库的时候报一下错误，可以open但是过不了多久直接abortErrors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_mmon_3708.trc  (incident=54164):ORA-00600: internal error code, arguments: [4194], [55], [12], [], [], [], [], []ORA-00600: intern...

1.修改数据库服务端认证级别，修改文件oracle用户下cd $ORACLE_HOME/network/admin/sqlnet.ora添加以下内容SQLNET.ALLOWED_LOGON_VERSION=8注意rac集群环境下要修改的oracle用户下sqlnet.ora而非grid用户下2.修改用户名密码如果pdb需要切换到pdb下在服务器端操作cd cd $ORACLE_HOME/network/admin/[oracle@rac2 ...

今天打开一个win库的时候alert出现 ksuapc : ORA-1033 foreground process starts before PMON 主要 是因为数据库在打开中已经有应用连接上了User processes may get ORA-1033 errors when an application is connecting to an instance which is just coming ...

迁移前字符集查看sqlplus "/ as sysdba" select userenv('language') from dual;1.select tablespace_name from dba_segments where owner=upper('tnticket2017') group by tablespace_name;查询结果就是原表空间2.查询数据量select sum(bytes/1024/1024/1024) "sum(MB)" from dba_segments where owner=upper...

2017/09/23 21:37:23 CLSRSC-400: A system reboot is required to continue installing.Applies to:Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterLinux x86-64DescriptionExecution of root.sh while installing Grid Infrastructure on RedHat Linux or Oracle Linux with...

今天收到用户反馈前端页面打开很慢。数据库服务器负载也告警了。登录服务器查询Mysql占用CPU过高，很直接打开show full process 跟慢查询发现很多以下sql都是在10S以上# User@Host: gyw[gwy] @  [x.x.x.x]  Id: 19513# Query_time: 11.326904  Lock_time: 0.000327 Rows_sent: 69  Rows_examined: 1...

以下操作需要数据库服务器上操作，如果需要远程操作请参阅1.源库创建directory目录sqlplus / as sysdbacreate directory dumpdir as '/u01/dumpdir'; ---/u01/dumpdir为系统已经创建好的目录2.源库相关数据查询查询源库的表空间select tablespace_name from dba_segments where owner='TEST' group by tablespace_na...

检查alert 日志发现以下错误Sat Aug 05 20:41:16 2017Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\tndb\tndb\trace\tndb_ora_4776.trc:ORA-01187: 鐢变簬楠岃瘉娴嬭瘯澶辫触鑰屾棤娉曚粠鏂囦欢  璇诲彇ORA-01110: 鏁版嵁鏂囦欢 201: 'D:\APP\ADMINISTRATOR\ORADATA\TNDB\TEMP01.DBF'Sat Aug 05 20:41:17 2017...

方法1 sql 脚本打开Miscrosoft sql server manager studio-新建查询备份数据库backup database ebiz_hrh to disk=N'd:\msbackup\ebiz_hrh.bak';d:\msbackup\为备份文件路径ebiz_hrh.bak 为备份文件名称查看数据库名及相关信息RESTORE headeronly  FROM DISK = N'd:\msbackup\ebiz_hrh.bak'; NULL NULL...

1.执行alter database qysdb2014 set multi_user;显示已有连接连接在数据库上2.select s.spid  from sys.sysprocessselect * from master.sys.sysprocesses s where s.dbid in (select dbid from master.sys.sysdatabases mwhere m.name='qysdb2014')这里name就是你要切换的数据库名称3.kill 以上查询出来的spid4...

vnc安装1.安装桌面yum -y groupinstall "X Window System"yum -y groupinstall "Desktop"2.安装 vncyum -y install tigervnc-server.x86_643.配置vncserver[root@ORADB01-160-2 bin]# cat /etc/sysconfig/vncservers# The VNCSERVERS variable is a list of display:user pairs....