123456789101112131415
create or replace trigger logon_ip_controlAFTER logon on databasedeclare ip STRING(30); prod_owner STRING(30);BEGIN SELECT SYS_CONTEXT('USERENV','SESSION_USER') into prod_owner from dual; SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') into ip from dual; if prod_owner='PROD_C' or prod_owner='PROD_S' ...
1234567891011121314151617181920212223242526272829303132
drop trigger BLOCK_TOOLS_LOGON; CREATE OR REPLACE TRIGGER BLOCK_TOOLS_LOGON AFTER LOGON ON DATABASEDECLARE my_forced_exception EXCEPTION; PRAGMA EXCEPTION_INIT(MY_FORCED_EXCEPTION, -20101);BEGIN IF (sys_context('USERENV', 'SESSION_USER') IN ('TRY_LOGON_BY_TOOLS')) -- add your username here THEN &n...
123456789101112131415161718192021222324252627282930313233343536373839404142
set verify offcol value format a20column file_name format a50 word_wrappedcolumn smallest format 999,990 heading "Smallest|Size|Poss."column currsize format 999,990 heading "Current|Size"column savings format 999,990 heading "Poss.|Savings"break on reportcompute sum of savings on report column value new_val blksizeselect value from v$parameter where name ...
@echo off
reg add HKLM\SOFTWARE\Policies\Google\Chrome\ /v RendererCodeIntegrityEnabled /t REG_DWORD /d 0
Recovery Writer (RVWR) is stuck until more space
is available in the recovery area.
Unable to write Flashback database log data because the
recovery area is full, presence of a guaranteed
restore point and no reusable flashback logs.
1. 查看闪回日志目录
1
show parameter recover
2. 查看闪回目录的使用状态
1
select * from v$flash_recovery_area_usage;
...
racle 出现未释放锁 查询出 sid 与 serial 杀死进程事务 1185
123
SELECT T2.USERNAME,T2.SID,T2.SERIAL#,T2.LOGON_TIMEFROM V$LOCKED_OBJECT T1,V$SESSION T2WHERE T1.SESSION_ID=T2.SID ORDER BY T2.LOGON_TIME
根据 sid 查询出sql sql 不重要 这步可跳过
123
SELECT SQL_TEXT FROM V$SESSION A,V$SQLTEXT_WITH_NEWLINES BWHERE DECODE(A.SQL_HASH_VALUE, 0, PREV_HASH_VALUE, SQ...
nmcli con add type vlan con-name vlan12 ifname vlan12 dev eth1 ipv4.addresses 192.168.1.2/24 ipv4.gateway 192.168.1.254
1. 问题描述
Oracle DataGuard日志传输失败,日志信息如下所示,
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
FAL[client, ARC2]: Error ...
挂载共享文件夹 centos7 挂载命令 :
mount -t cifs -o username=*****,password=******* vers=1.0 //192.168.1.1/share /mnt/share
其中:
username,password是 windows 登录用户名,密码
//192.168.1.1/share 就是windows要的共享文件夹,ip可以在window 运行 cmd ,ipconfig 查看本地局域网适配器 IPV4地址.
/mnt/share 是希望Centos7将共享文件夹要挂载到的地方,可任意定位置
vers=1.0 必须要写上。否则报错误:cifs vfs ioctl error in smb2_get_dfs_refer rc=-5
挂载成功后,可以在window将需要共享的文件复制到share,然后在linu...
DG 环境重启过程
DataGuard环境的重启原则是:先关主库再关备库,先开备库再开主库
1、关闭DG
1> 关闭主库
SQL>shutdown immediate
$ lsnrctl start
2> 关闭备库
SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL>SHUTDOWN IMMEDIATE;
$lsnrctl stop
2、启动DG
1>启动备库
SQL>STARTUP MOUNT/OPEN;
SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM
SESSION;
$ lsnrctl start
2>启动主库
SQL> STARTUP;
SQL> exit
$ lsnrctl start
(2)启动DataGuard后的检查...