Home | 简体中文 | 繁体中文 | 杂文 | 打赏(Donations) | 云栖社区 | OSChina 博客 | Facebook | Linkedin | 知乎专栏 | Github | Search | About

部分 VII. Oracle

目录

74. Oracle 12c 安装可
74.1. Server 安装
74.2. Desktop 安装
74.3. Oracle Net Services Configuration
74.3.1. Listener configuration
74.3.2. Local Net Service Name configuration
74.4. Oracle 12c Client for Windows 10
74.5. 卸载 Oracle
74.6. Linux 安装 sqlplus
75. Privilege
75.1. Account
75.1.1. show user
75.1.2. DEFAULT_TABLESPACE
75.1.3. unlock/lock
75.2. User
75.2.1. Create user
75.2.2. Drop user
75.2.3. Alter user
75.2.4. 修改密码
75.2.5. Reset Password 忘记密码重置密码
75.3. grant
75.3.1. 列出权限
75.3.2. 查看用户权限
75.3.3. 吊销权限
75.3.4. System Privileges 系统权限
75.3.4.1. EM 权限
75.3.4.2. Granting and Revoking SYSDBA and SYSOPER Privileges
75.3.5. Object Privileges 对象权限
75.4. Opening the Encrypted Wallet
76. 数据库管理
76.1. lsnrctl
76.2. listener.ora
76.3. TNS 配置
76.3.1. HOST
76.3.2. SID
76.4. parameter
76.4.1. db
76.4.2. instance_name
76.4.3. service_name
76.4.4. global_name
76.4.5. db_name
76.4.6. db_domain
76.4.7. sga
76.4.8. size
76.4.9. spfile
76.4.10. cache
76.4.11. Character Set
76.5. 进程
76.6. 查看用户
76.7. 显示表
76.8. 显示试图
76.9. PROCEDURE
76.10. FUNCTION
76.11. 视图、存储过程、函数
76.12. 查看存储过程源代码
76.13. 日期时间格式
76.13.1. Date
76.13.2. 修改系统日期格式
76.13.3. TIMESTAMP
76.13.4.
76.14. 切换字符集
76.14.1. 切换到 GBK
76.14.2. 切到 UTF-8
76.14.3. 切到 AL32UTF8
76.14.4. 切换过程实例
76.15. Oracle 表空间
76.15.1. 查询空闲表空间
76.15.2. 创建表空间
76.15.2.1. 临时表空间
76.15.3. 更改表空间属性
76.15.3.1. 修改表空间大小
76.15.4. 删除表空间
77. Oracle Gui
77.1. Create instance
77.2. Oracle Net Configuration Assistant
77.3. Oracle Enterprise Manager
77.3.1. EM Configuration issue. /opt/oracle/product/11.2.0/dbhome_1/orcl.example.com_orcl not found.
77.4. Other GUI - phpOraAdmin
78. CLI
78.1. SQL*Plus
78.1.1. conn
78.1.2. startup/shutdown
78.1.2.1. startup
78.1.2.2. shutdown
78.1.3. $ORACLE_HOME/sqlplus/admin/glogin.sql
78.1.4. @运行SQL
78.1.5. 链接数据库
78.2. exp/imp
78.2.1. exp
78.2.2. imp
78.2.2.1. A用户导出B用户导入
78.3. expdp/impdp
78.3.1. expdp
78.3.2. impdp
78.3.3. 数据泵演示
78.3.4. 查看dmp文件的表空间
78.4. RMAN
78.4.1. 数据库模式
78.4.2. 完全备份
78.4.3. 增量备份
78.4.4. 恢复数据库
78.4.5. 是用tar打包rman文件
78.4.6. 打包 rman 备份文件
79. DDL
79.1. 字段类型
79.1.1. Date
79.1.2. TIMESTAMP
79.2. 索引
79.3. 表
79.3.1.
79.3.2. 约束检查
79.4. SEQUENCE 序列
79.4.1.
80. 程序包
80.1. 执行包中的过程
81. 数据库链接
82. Oracle 监控
82.1. Oracle日志的路径
82.2. SQL 日志监控
82.2.1. 查询性能分析
82.2.2. IO性能分析
82.3. session
82.4. SQL Monitoring Report
83. Installing Oracle Database
83.1. Installing Oracle Database 10g Release 2 on Linux x86
83.2. 11gR2
83.3. Installing Oracle Client 11g
83.4. Silence Install - Database
83.4.1. Response File
83.4.2. OS 配置脚本
83.4.3. 运行 runInstaller
83.5. Silence Install - Client
83.6. oracle 817 script
83.7. Script for automatic startup on boot
83.8. Run level shell script to start Oracle 10g services on RedHat Enterprise Linux (RHAS 4)
84. FAQ
84.1. Reset root password 重置MySQL root密码
84.1.1. MySQL 5.7.x
84.1.2. MySQL 8.0
84.2. 数据库内容替换
84.3. 查看错误代码
84.3.1. ERROR 1153 (08S01) at line 3168: Got a packet bigger than 'max_allowed_packet' bytes
84.3.2. ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
84.4. 临时表是否需要建索引
84.5. Kill 脚本
84.6. ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function
84.7. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
84.8. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
84.9. 重新整理AUTO_INCREMENT字段
84.10. 转换 latin1 到 UTF-8
84.11. this is incompatible with sql_mode=only_full_group_by
84.12. [Warning] Changed limits: max_open_files: 5000 (requested 20480)
84.13. ERROR 1364: 1364: Field 'id' doesn't have a default value
84.14. ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
84.15. ERROR 1086 (HY000): File '/var/lib/mysql-files/order.txt' already exists
84.16. ERROR 1415: Not allowed to return a result set from a trigger
84.17. Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such fileor directory
84.18. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed