摘要：
SQL> shut immediateORA-24324: service handle not initializedORA-24323: value not allowedORA-27140: attach to post/wait facility failedORA-27300: OS sy 阅读全文
摘要：
[grid@db2 db2]$ adrci ADRCI: Release 12.2.0.1.0 - Production on Mon Feb 25 15:51:14 2019 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All r 阅读全文
摘要：
1.查看所有用户：select * from dba_users;select * from all_users;select * from user_users; 2.查看用户或角色系统权限(直接赋值给用户或角色的系统权限)：select * from dba_sys_privs;select * 阅读全文
摘要：
备库 Thu Feb 14 09:00:32 2019Errors in file /u01/app/oracle/diag/rdbms/trstdb/trstdb/trace/trstdb_ora_90063.trc (incident=880729):ORA-00600: internal er 阅读全文
摘要：
节点1： Wed Feb 13 16:08:06 2019Errors in file /u01/app/oracle/diag/rdbms/testdb/testdb1/trace/testdb1_dia0_9267.trc (incident=1248083):ORA-32701: Possib 阅读全文
摘要：
目标端创建 SELECT * FROM DBA_DB_LINKS Create public database link DW_TO_AC connect to chg identified by 123456 using '(DESCRIPTION= (ADDRESS_LIST=(ADDRESS 阅读全文
摘要：
ri Dec 21 22:00:00 2018Setting Resource Manager plan SCHEDULER[0x32DD]:DEFAULT_MAINTENANCE_PLAN via scheduler windowSetting Resource Manager plan DEFA 阅读全文
摘要：
格式：alter system|session set events ‘[eventnumber|immediate] trace name eventname [forever] [, level levelnumber] : „„.’ 通过“:”符号，可以连续设置多个事件，也可以通过连续使用al 阅读全文
摘要：
--节点1报错 Sun Dec 09 08:29:57 2018Control file backup creation failed: failure to open backup target file /u01/app/oracle/product/11.2.0/db_1/dbs/snapcf 阅读全文
摘要：
有时候，SQL语句中包含了 & 符号，&是数据库中存储的值，而非要求我们输入某个值， 如果你在 SQLPLUS中运行该SQL， 可以用 set define off 命令 忽略 & 举个例子： SQL> select 'hello &word' from dual;Enter value for w 阅读全文