一、Linux expdp备份脚本1.备份至挂载磁盘123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778#!/bin/sh#expdp_data.shs...
一、故障描述一台服务器在cmd命令本地登录数据库提示帐号密码不对: ORA-01017: invalid username/password; logon denied
二、检查sqlnet.ora及数据库参数
检查 %ORACLE_HOME%\network\admin\sqlnet.ora文件，已经开启操作系统认证
remote_login_passwordfile值为EXC...
Oracle批量建表空间数据文件脚本
一、单机批量创建数据文件1234567891011121314151617181920212223242526272829303132333435363738#!/bin/bashdatetime=$(date +%Y-%m-%d_%H%M)export ORACLE_SID=aidbexport ORACLE_HOME=/u01/app/oracl...
批量修改文件名，批量修改名称，批量修改文件名前缀
12345678910111213141516171819202122232425262728(1) Linux批量改文件名:for txt in *.txt; do mv "$txt" "new_${dir%*/}";donefor txt in `ls Full-*`;...
授权只读访问某个用户下的数据
一、创建角色1create role select_all_qxphis_table;
二、将qxphis用户的表授权给角色12345678910111213141516171819202122232425declare cursor c_tabname is select table_name from dba_tables where owner...
https://www.truenas.com/docs/scale/scaletutorials/shares/smb/https://www.truenas.com/docs/scale/scaletutorials/shares/addingnfsshares/
一、创建用户和组
Credentials—Local Groups—Add
二、添加物理磁盘(esxi)...
查询Oracle等待事件
一、查看当前某个SQL_ID会话情况123456789101112131415set linesize 500set pagesize 500col sid format 9999col spid for a5col serial# format 999999col event format a23col p123 format a15col wait_time...
Oracle查询会话，Oracle批量杀会话，Oracle根据SQL_ID杀会话，Oracle根据SQL_ID杀会话杀进程，按SQL_ID批量杀会话
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646...
调整Linux系统 /home分区和swap分区大小
一、备份数据1234567891011121314151617181920212223# ll /home/admin/总用量 0drwxr-xr-x. 2 admin admin 6 4月 1 14:30 公共drwxr-xr-x. 2 admin admin 6 4月 1 14:30 模板drwxr-xr-x. ...
