部分 VI. Oracle
上一页		下一页

部分 VI. Oracle

63. Oracle 12c 安装可

63.1. Server 安装

63.2. Desktop 安装

63.3. Oracle Net Services Configuration

63.3.1. Listener configuration
63.3.2. Local Net Service Name configuration

63.4. Oracle 12c Client for Windows 10

63.5. 卸载 Oracle

63.6. Linux 安装 sqlplus

64. Privilege

64.1. Account

64.1.1. show user
64.1.2. DEFAULT_TABLESPACE
64.1.3. unlock/lock

64.2. User

64.2.1. Create user
64.2.2. Drop user
64.2.3. Alter user
64.2.4. 修改密码
64.2.5. Reset Password 忘记密码重置密码

64.3. grant

64.3.1. 列出权限
64.3.2. 查看用户权限
64.3.3. 吊销权限
64.3.4. System Privileges 系统权限
64.3.5. Object Privileges 对象权限

64.4. Opening the Encrypted Wallet

65. 数据库管理

65.1. lsnrctl

65.2. listener.ora

65.3. TNS 配置

65.3.1. HOST
65.3.2. SID

65.4. parameter

65.4.1. db
65.4.2. instance_name
65.4.3. service_name
65.4.4. global_name
65.4.5. db_name
65.4.6. db_domain
65.4.7. sga
65.4.8. size
65.4.9. spfile
65.4.10. cache
65.4.11. Character Set

65.11. 视图、存储过程、函数

65.12. 查看存储过程源代码

65.13. 日期时间格式

65.13.1. Date
65.13.2. 修改系统日期格式
65.13.3. TIMESTAMP
65.13.4.

65.14. 切换字符集

65.14.1. 切换到 GBK
65.14.2. 切到 UTF-8
65.14.3. 切到 AL32UTF8
65.14.4. 切换过程实例

65.15. Oracle 表空间

65.15.1. 查询空闲表空间
65.15.2. 创建表空间
65.15.3. 更改表空间属性
65.15.4. 删除表空间

66. Oracle Gui

66.1. Create instance

66.2. Oracle Net Configuration Assistant

66.3. Oracle Enterprise Manager

66.3.1. EM Configuration issue. /opt/oracle/product/11.2.0/dbhome_1/orcl.example.com_orcl not found.

66.4. Other GUI - phpOraAdmin

67. CLI

67.1. SQL*Plus

67.1.1. conn
67.1.2. startup/shutdown
67.1.3. $ORACLE_HOME/sqlplus/admin/glogin.sql
67.1.4. @运行SQL
67.1.5. 链接数据库

67.2. exp/imp

67.2.1. exp
67.2.2. imp

67.3. expdp/impdp

67.3.1. expdp
67.3.2. impdp
67.3.3. 数据泵演示
67.3.4. 查看dmp文件的表空间

67.4. RMAN

67.4.1. 数据库模式
67.4.2. 完全备份
67.4.3. 增量备份
67.4.4. 恢复数据库
67.4.5. 是用tar打包rman文件
67.4.6. 打包 rman 备份文件

68. DDL

68.1. 字段类型

68.1.1. Date
68.1.2. TIMESTAMP

68.2. 索引

68.3. 表

68.3.1.
68.3.2. 约束检查

68.4. SEQUENCE 序列

68.4.1.

69. 程序包

69.1. 执行包中的过程

70. 数据库链接

71. Oracle 监控

71.1. Oracle日志的路径

71.2. SQL 日志监控

71.2.1. 查询性能分析
71.2.2. IO性能分析

71.3. session

71.4. SQL Monitoring Report

72. Installing Oracle Database

72.1. Installing Oracle Database 10g Release 2 on Linux x86

72.2. 11gR2

72.3. Installing Oracle Client 11g

72.4. Silence Install - Database

72.4.1. Response File
72.4.2. OS 配置脚本
72.4.3. 运行 runInstaller

72.5. Silence Install - Client

72.6. oracle 817 script

72.7. Script for automatic startup on boot

72.8. Run level shell script to start Oracle 10g services on RedHat Enterprise Linux (RHAS 4)

73. FAQ

73.1. Reset root password 重置MySQL root密码

73.1.1. MySQL 5.7.x
73.1.2. MySQL 8.0

73.2. 查看错误代码

73.2.1. ERROR 1153 (08S01) at line 3168: Got a packet bigger than 'max_allowed_packet' bytes
73.2.2. ERROR 1129 (00000): Host 'XXXXXX' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

73.3. 临时表是否需要建索引

73.4. [Warning] Changed limits: max_open_files: 5000 (requested 20480)

73.5. Table 'performance_schema.session_variables' doesn't exist

73.6. SQL Error (1038): Out of sort memory, consider increasing server sort buffer size

73.7. this is incompatible with sql_mode=only_full_group_by

73.8. ERROR 1071 (42000) at line 25: Specified key was too long; max key length is 767 bytes

73.9. ERROR 1086 (HY000): File '/var/lib/mysql-files/order.txt' already exists

73.10. ERROR 1114 (HY000): The table 'your_table' is full

73.11. Error Code: 1146. Table 'test.CACHE_UPDATE' doesn't exist

73.12. Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.

73.13. ERROR 1273 (HY000) at line 3364: Unknown collation: 'utf8mb4_0900_ai_ci'

73.14. ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

73.15. ERROR 1364: 1364: Field 'id' doesn't have a default value

73.16. Error Code: 1292. Incorrect datetime value: '0000-00-00 00:00:00' for column 'create_time' at row 95692

73.17. ERROR 1415: Not allowed to return a result set from a trigger

73.18. ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function

73.19. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

73.20. ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

73.21. ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.

73.22. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

73.23. ERROR 2013 (HY000): Lost connection to MySQL server during query

73.24. 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

73.25. ERROR 3024 (HY000): Query execution was interrupted, maximum statement execution time exceeded

73.26. Error Code: 3780. Referencing column 'id' and referenced column 'id' in foreign key constraint 'FKfeti3hcwwku7l7xqru4emwkc6' are incompatible.

73.27. 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

73.28. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed

73.29. mysqldump: Couldn't execute 'SELECT COLUMN_NAME,

73.30. this is incompatible with sql_mode=only_full_group_by

73.31. mysqldump: [Warning] Using a password on the command line interface can be insecure.

73.32. mysql: [Warning] Using a password on the command line interface can be insecure.

73.33. 时间自动被加一秒

上一页		下一页
第 62 章 FAQ	起始页	第 63 章 Oracle 12c 安装可