上一页 1 ··· 3 4 5 6 7 8 下一页
摘要: NBU(NetBackup) 7.0之後的版本官方文檔鏈接地址: https://www.veritas.com/support/en_US/article.DOC5332 阅读全文
posted @ 2016-05-23 13:41 guilingyang 阅读(375) 评论(0) 推荐(0) 编辑
摘要: 1.使用srvctl工具檢查RAC當前配置和狀態 $ srvctl config database -h Displays the configuration for the database. Usage: srvctl config database [-d <db_unique_name> [ 阅读全文
posted @ 2016-05-11 14:25 guilingyang 阅读(344) 评论(0) 推荐(0) 编辑
摘要: Doc ID 2082662.1 1.錯誤碼 Installation Of Oracle Client 12.1.0.2.0 (32-bit) Fails With An Error Message "[INS-20802] Oracle Net Configuration Assistant f 阅读全文
posted @ 2016-04-21 19:27 guilingyang 阅读(4657) 评论(0) 推荐(0) 编辑
摘要: 1.直接使用shell當編輯器 [root@phburdb1 mail]# mail -s "Hello World" juncai.chen@innolux.comHello juncaiCc: You have new mail in /var/spool/mail/root第一行是输入的命令, 阅读全文
posted @ 2016-04-21 16:53 guilingyang 阅读(198) 评论(0) 推荐(0) 编辑
摘要: 1. 進入Data Domain管理界面后,在Administration >Settings界面。點擊More mail Server >Set Mail Server >輸入Mail Server的地址 2. 如果上面的Mail Server設置正確的話。就可以去命令行界面測試 sysadmin 阅读全文
posted @ 2016-04-21 16:10 guilingyang 阅读(410) 评论(0) 推荐(0) 编辑
摘要: 測試表emp RANK SQL> select EMPNO,DEPTNO,SAL, 2 rank()over(partition by DEPTNO order by SAL) "rank" 3 from emp; EMPNO DEPTNO SAL rank 7934 10 1300 1 7782 阅读全文
posted @ 2016-04-13 10:15 guilingyang 阅读(191) 评论(0) 推荐(0) 编辑
摘要: oracle merge 語法: 用途: Use the MERGE statement to select rows from one or more sources for update orinsertion into a table or view. You can specify cond 阅读全文
posted @ 2016-04-11 19:33 guilingyang 阅读(194) 评论(0) 推荐(0) 编辑
摘要: Doc ID 461911.1 Patch 6602742 Applies to: Oracle Database - Enterprise Edition - Version 10.2.0.3 and later Information in this document applies to an 阅读全文
posted @ 2016-04-08 15:56 guilingyang 阅读(662) 评论(0) 推荐(0) 编辑
摘要: 1 COALESCE 語法:COALESCE(expr1, expr2, ..., exprn) n>=2 作用:COALESCE returns the first non-null expr in the expression list. You must specify at leasttwo 阅读全文
posted @ 2016-04-08 15:35 guilingyang 阅读(212) 评论(0) 推荐(0) 编辑
摘要: 我這oracle版本為11.2.0.4,裝的GRID,所以在grid用戶下編輯sqlnet.ora 1.cd /grid/product/11.2.0/network/admin 2.編輯sqlnet.ora #开启ip限制功能tcp.validnode_checking=yes#允许访问数据库的I 阅读全文
posted @ 2016-04-08 14:38 guilingyang 阅读(211) 评论(0) 推荐(0) 编辑
上一页 1 ··· 3 4 5 6 7 8 下一页