摘要：
数据库环境物理备库：主库 SHDB备库 BJDB1、查看当前主备库角色、状态信息主库(SHDB)10:48:37 SYS@ SHDB>col name for a1010:54:03 SYS@ SHDB>col database_role for a2010:54:03 SYS@ SHDB>col protection_mode for a2010:54:04 SYS@ SHDB>col switchover_status for a2010:54:04 SYS@ SHDB>select name,protection_mode,database_role,swi 阅读全文
摘要：
--有一个执行1000次的循环脚本，因为编辑错误导致无休止(1000次)的执行rhels5532-> ./loadbalance.sh devdb 1000ERROR:ORA-28009: connection as SYS should be as SYSDBA or SYSOPERERROR:ORA-28009: connection as SYS should be as SYSDBA or SYSOPER--查找此进程[root@rhels5532 ~]# ps aux | grep load | grep -v greporacle 31854 0.0 0.0 4732 ... 阅读全文