Home | 简体中文 | 繁体中文 | 杂文 | 知乎专栏 | 51CTO学院 | CSDN程序员研修院 | Github | OSChina 博客 | 腾讯云社区 | 阿里云栖社区 | Facebook | Linkedin | Youtube | 打赏(Donations) | About
知乎专栏多维度架构

部分 VII. Oracle

目录

72. Oracle 12c 安装可
72.1. Server 安装
72.2. Desktop 安装
72.3. Oracle Net Services Configuration
72.3.1. Listener configuration
72.3.2. Local Net Service Name configuration
72.4. Oracle 12c Client for Windows 10
72.5. 卸载 Oracle
72.6. Linux 安装 sqlplus
73. Privilege
73.1. Account
73.1.1. show user
73.1.2. DEFAULT_TABLESPACE
73.1.3. unlock/lock
73.2. User
73.2.1. Create user
73.2.2. Drop user
73.2.3. Alter user
73.2.4. 修改密码
73.2.5. Reset Password 忘记密码重置密码
73.3. grant
73.3.1. 列出权限
73.3.2. 查看用户权限
73.3.3. 吊销权限
73.3.4. System Privileges 系统权限
73.3.4.1. EM 权限
73.3.4.2. Granting and Revoking SYSDBA and SYSOPER Privileges
73.3.5. Object Privileges 对象权限
73.4. Opening the Encrypted Wallet
74. 数据库管理
74.1. lsnrctl
74.2. listener.ora
74.3. TNS 配置
74.3.1. HOST
74.3.2. SID
74.4. parameter
74.4.1. db
74.4.2. instance_name
74.4.3. service_name
74.4.4. global_name
74.4.5. db_name
74.4.6. db_domain
74.4.7. sga
74.4.8. size
74.4.9. spfile
74.4.10. cache
74.4.11. Character Set
74.5. 进程
74.6. 查看用户
74.7. 显示表
74.8. 显示试图
74.9. PROCEDURE
74.10. FUNCTION
74.11. 视图、存储过程、函数
74.12. 查看存储过程源代码
74.13. 日期时间格式
74.13.1. Date
74.13.2. 修改系统日期格式
74.13.3. TIMESTAMP
74.13.4.
74.14. 切换字符集
74.14.1. 切换到 GBK
74.14.2. 切到 UTF-8
74.14.3. 切到 AL32UTF8
74.14.4. 切换过程实例
74.15. Oracle 表空间
74.15.1. 查询空闲表空间
74.15.2. 创建表空间
74.15.2.1. 临时表空间
74.15.3. 更改表空间属性
74.15.3.1. 修改表空间大小
74.15.4. 删除表空间
75. Oracle Gui
75.1. Create instance
75.2. Oracle Net Configuration Assistant
75.3. Oracle Enterprise Manager
75.3.1. EM Configuration issue. /opt/oracle/product/11.2.0/dbhome_1/orcl.example.com_orcl not found.
75.4. Other GUI - phpOraAdmin
76. CLI
76.1. SQL*Plus
76.1.1. conn
76.1.2. startup/shutdown
76.1.2.1. startup
76.1.2.2. shutdown
76.1.3. $ORACLE_HOME/sqlplus/admin/glogin.sql
76.1.4. @运行SQL
76.1.5. 链接数据库
76.2. exp/imp
76.2.1. exp
76.2.2. imp
76.2.2.1. A用户导出B用户导入
76.3. expdp/impdp
76.3.1. expdp
76.3.2. impdp
76.3.3. 数据泵演示
76.3.4. 查看dmp文件的表空间
76.4. RMAN
76.4.1. 数据库模式
76.4.2. 完全备份
76.4.3. 增量备份
76.4.4. 恢复数据库
76.4.5. 是用tar打包rman文件
76.4.6. 打包 rman 备份文件
77. DDL
77.1. 字段类型
77.1.1. Date
77.1.2. TIMESTAMP
77.2. 索引
77.3. 表
77.3.1.
77.3.2. 约束检查
77.4. SEQUENCE 序列
77.4.1.
78. 程序包
78.1. 执行包中的过程
79. 数据库链接
80. Oracle 监控
80.1. Oracle日志的路径
80.2. SQL 日志监控
80.2.1. 查询性能分析
80.2.2. IO性能分析
80.3. session
80.4. SQL Monitoring Report
81. Installing Oracle Database
81.1. Installing Oracle Database 10g Release 2 on Linux x86
81.2. 11gR2
81.3. Installing Oracle Client 11g
81.4. Silence Install - Database
81.4.1. Response File
81.4.2. OS 配置脚本
81.4.3. 运行 runInstaller
81.5. Silence Install - Client
81.6. oracle 817 script
81.7. Script for automatic startup on boot
81.8. Run level shell script to start Oracle 10g services on RedHat Enterprise Linux (RHAS 4)
82. FAQ
82.1. Reset root password 重置MySQL root密码
82.1.1. MySQL 5.7.x
82.1.2. MySQL 8.0
82.2. 查看错误代码
82.2.1. ERROR 1153 (08S01) at line 3168: Got a packet bigger than 'max_allowed_packet' bytes
82.2.2. ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
82.3. 临时表是否需要建索引
82.4. [Warning] Changed limits: max_open_files: 5000 (requested 20480)
82.5. SQL Error (1038): Out of sort memory, consider increasing server sort buffer size
82.6. this is incompatible with sql_mode=only_full_group_by
82.7. ERROR 1071 (42000) at line 25: Specified key was too long; max key length is 767 bytes
82.8. ERROR 1086 (HY000): File '/var/lib/mysql-files/order.txt' already exists
82.9. Error Code: 1146. Table 'test.CACHE_UPDATE' doesn't exist
82.10. Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.
82.11. ERROR 1273 (HY000) at line 3364: Unknown collation: 'utf8mb4_0900_ai_ci'
82.12. ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
82.13. ERROR 1364: 1364: Field 'id' doesn't have a default value
82.14. ERROR 1415: Not allowed to return a result set from a trigger
82.15. ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function
82.16. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
82.17. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
82.18. ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.
82.19. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
82.20. ERROR 2013 (HY000): Lost connection to MySQL server during query
82.21. ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
82.22. ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded
82.23. 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
82.24. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
82.25. mysqldump: Couldn't execute 'SELECT COLUMN_NAME,
82.26. this is incompatible with sql_mode=only_full_group_by
82.27. mysqldump: [Warning] Using a password on the command line interface can be insecure.
82.28. mysql: [Warning] Using a password on the command line interface can be insecure.