查看Oracle帐号被锁的机器主机名、查看Oracle帐号被锁原因若某个用户登录数据库失败，则基表USER$的列LCOUNT加1。只要成功登录后，LCOUNT的值就会置0。另外，审计表（SYS.AUD$或DBA_AUDIT_TRAIL）也记录了登陆失败的信息，comment_text里面会记录服务器的IP地址
一、查看用户帐号被锁日期或过期时间123set linesize 200 pa...
Grafana升级、Grafana打补丁、Grafana漏洞修复
一、CVE-2025-4123漏洞简介
https://grafana.com/blog/2025/05/21/grafana-security-release-high-severity-security-fix-for-cve-2025-4123/
Today we are releasing Grafana 12....
一、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...
