|
118 | 118 | * http://docs.oracle.com/en/bigdata/
|
119 | 119 |
|
120 | 120 | * dbms_lob.substr[DBMS_LOB -> SUBSTR]: http://docs.oracle.com/database/122/ARPLS
|
| 121 | + |
121 | 122 | * lsnrctl的用法[Configuring the Network Environment -> lsnrctl]: http://docs.oracle.com/database/122/ADMQS
|
| 123 | +* 配置系统环境变量[Getting Started with Database Administration -> Configuring the Operating System Environment Variables]: http://docs.oracle.com/database/122/ADMQS |
| 124 | + |
122 | 125 | * "on delete cascade" 和 "on delete set null" 的差别[Common SQL DDL Clauses -> constraint -> on delete]: http://docs.oracle.com/database/122/SQLRF
|
| 126 | +* TRUNC (date)[Functions -> TRUNC (date)]: http://docs.oracle.com/database/122/SQLRF |
| 127 | +* SYS_CONTEXT[Functions -> SYS_CONTEXT]: http://docs.oracle.com/database/122/SQLRF |
| 128 | +* ALTER SEQUENCE[SQL Statements: ALTER MATERIALIZED VIEW to ALTER SYSTEM -> ALTER SEQUENCE]: http://docs.oracle.com/database/122/SQLRF |
| 129 | + |
123 | 130 | * Database Error Messages: http://docs.oracle.com/database/122/ERRMG
|
| 131 | + |
124 | 132 | * 开启和关闭数据库[Starting Up and Shutting Down]: http://docs.oracle.com/database/122/ADMIN
|
| 133 | +* ADR[Managing Diagnostic Data -> Automatic Diagnostic Repository (ADR)]: http://docs.oracle.com/database/122/ADMIN |
| 134 | +* 归档日志[Managing the Redo Log]: http://docs.oracle.com/database/122/ADMIN |
| 135 | +* 为系统用户指定密码[Creating and Configuring an Oracle Database -> Protecting Your Database: Specifying Passwords for Users SYS and SYSTEM]: http://docs.oracle.com/database/122/ADMIN |
| 136 | +* Managing Oracle Enterprise Manager Database Control: http://docs.oracle.com/database/122/ADMIN |
| 137 | + |
125 | 138 | * LOBs类型说明[Using SQL Data Types in Database Applications -> Representing Large Amounts of Data]: http://docs.oracle.com/database/122/ADFNS
|
| 139 | + |
126 | 140 | * 端口配置[Managing Oracle Database Port Numbers]: http://docs.oracle.com/database/122/LADBI
|
127 |
| -* 配置系统环境变量[Getting Started with Database Administration -> Configuring the Operating System Environment Variables]: http://docs.oracle.com/database/122/ADMQS |
| 141 | + |
128 | 142 | * 环境变量[Administering Oracle Database -> Oracle Database Environment Variables]: docs.oracle.com/database/122/UNXAR
|
129 |
| -* ADR[Managing Diagnostic Data -> Automatic Diagnostic Repository (ADR)]: http://docs.oracle.com/database/122/ADMIN |
130 |
| -* 归档日志[Managing the Redo Log]: http://docs.oracle.com/database/122/ADMIN |
| 143 | + |
131 | 144 | * 设置国际化支持环境变量[Setting Up a Globalization Support Environment]: http://docs.oracle.com/database/122/NLSPG/
|
| 145 | + |
132 | 146 | * 逻辑存储结构[Logical Storage Structures]: http://docs.oracle.com/database/122/CNCPT/
|
| 147 | + |
133 | 148 | * SQL*Loader[SQL*Loader Concepts]: http://docs.oracle.com/database/122/SUTIL
|
134 | 149 | * ADRCI: ADR Command Interpreter: http://docs.oracle.com/database/122/SUTIL
|
| 150 | +* Using LogMiner to Analyze Redo Log Files: https://docs.oracle.com/database/122/SUTIL |
| 151 | + |
135 | 152 | * 数据库网络服务全部内容: http://docs.oracle.com/database/122/NETRF
|
136 | 153 | * JDBC数据源配置[Data Sources and URLs]: http://docs.oracle.com/database/122/JJDBC
|
| 154 | + |
137 | 155 | * 预置账户[Securing the Database Installation and Configuration -> Predefined User Accounts Provided by Oracle Database]: http://docs.oracle.com/database/122/TDPSG
|
138 |
| -* 为系统用户指定密码[Creating and Configuring an Oracle Database -> Protecting Your Database: Specifying Passwords for Users SYS and SYSTEM]: http://docs.oracle.com/database/122/ADMIN |
139 |
| -* Managing Oracle Enterprise Manager Database Control: http://docs.oracle.com/database/122/ADMIN |
| 156 | + |
140 | 157 | * [Gathering Database Statistics -> Generating an AWR Report Using the Command-Line Interface]: http://docs.oracle.com/database/122/TGDBA
|
141 |
| -* TRUNC (date)[Functions -> TRUNC (date)]: http://docs.oracle.com/database/122/SQLRF |
142 |
| -* SYS_CONTEXT[Functions -> SYS_CONTEXT]: http://docs.oracle.com/database/122/SQLRF |
143 |
| -* ALTER SEQUENCE[SQL Statements: ALTER MATERIALIZED VIEW to ALTER SYSTEM -> ALTER SEQUENCE]: http://docs.oracle.com/database/122/SQLRF |
| 158 | + |
144 | 159 | * / (slash)[SQL*Plus Command Reference -> / (slash)]: http://docs.oracle.com/database/122/SQPUG
|
| 160 | + |
145 | 161 | * CRSCTL/SRVCTL: https://docs.oracle.com/database/122/CWADD
|
146 | 162 |
|
147 | 163 | * Oracle SQL Handler:http://www.heartblue.cn/
|
|
203 | 219 | * 【ASM】SYSASM 角色: https://yq.aliyun.com/articles/28404
|
204 | 220 | * rac节点无法启动ORA-29702的问题及分析: http://blog.itpub.net/23718752/viewspace-1158618
|
205 | 221 | * ORACLE RAC 的启动和关闭顺序: http://blog.itpub.net/29634949/viewspace-1269073/
|
206 |
| - |
207 |
| - |
| 222 | +* Oracle RAC中public ip, private ip, vip, scan ip的概念: 《Oracle RAC 11g实战指南》 2.2 3.1.3 3.2.4章节 |
| 223 | +* 深入了解 Oracle Flex ASM 及其优点(了解性知识):<http://www.oracle.com/technetwork/cn/articles/database/flexasm-flexcluster-benefits-odb12c-2177371-zhs.html> |
| 224 | +* oracle数据库备份删除操作:<http://www.blogjava.net/wangxinsh55/archive/2010/11/05/337300.html> |
| 225 | +* Oracle关闭和开启归档日志: <http://oma1989.iteye.com/blog/1469744> |
| 226 | +* oracle数据库自动提交事务(autocommit)为OFF,但事务自动提交了: <http://blog.sina.com.cn/s/blog_68fe7e150100z7tn.html> |
| 227 | +* statspack安装使用 和 report 分析: <http://blog.csdn.net/tianlesoftware/article/details/4682329> |
| 228 | +* 【性能调优】Oracle AWR报告指标全解析: <http://www.askmaclean.com/archives/performance-tuning-oracle-awr.html> |
| 229 | +* Oracle Trace文件生成及查看: http://blog.csdn.net/weiwenhp/article/details/6932835 |
| 230 | +* Oracle 10g Audit(审计) --- 记录登录用户在Oracle中的所有操作: <http://blog.csdn.net/ryb7899/article/details/5413720> |
208 | 231 |
|
209 | 232 | ## oracle疑难问题排查集:
|
210 | 233 |
|
@@ -586,6 +609,7 @@ Oracle提供了两种验证方式,一种是OS验证,另一种密码文件验
|
586 | 609 | * actian: http://www.actian.com/
|
587 | 610 | * Apache Derby: http://db.apache.org/derby/
|
588 | 611 | * BlinkDB: http://blinkdb.org/
|
| 612 | +* H2 Database Engine: http://www.h2database.com/html/main.html |
589 | 613 |
|
590 | 614 | # 数据模型
|
591 | 615 |
|
|
0 commit comments