升级数据字典，解决ORA-01092:ORACLEinstanceterminated.Disconn
在oracle 实例关闭的情况下，Oracle 软件从10.2.0.1 升级到 10.2.0.5 之后，存在的数据库也要升级。 此时启动实例会报错 ORA-01092: ORACLE instance terminated. Disconnection forced SQL alter database open; ERROR at line 1: ORA-01092: ORACLE instan
在oracle 实例关闭的情况下，Oracle 软件从10.2.0.1 升级到 10.2.0.5 之后，存在的数据库也要升级。
此时启动实例会报错 ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> alter database open;
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
第一步，通过startup upgrade启动实例
SQL> startup upgrade;
ORACLE instance started.
Total System Global Area 322961408 bytes
Fixed Size 2095992 bytes
Variable Size 100664456 bytes
Database Buffers 213909504 bytes
Redo Buffers 6291456 bytes
Database mounted.
Database opened.
第二步，升级数据字典和实例等。
SQL>@ORACLE_HOME\rdbms\admin\catupgrd.sql
整个过程需要15分钟至30分钟左右
升级完毕显示如下：
Oracle Database 10.2 Upgrade Status Utility 09-11-2014 21:48:21
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.5.0 00:15:41
JServer JAVA Virtual Machine VALID 10.2.0.5.0 00:06:46
Oracle XDK VALID 10.2.0.5.0 00:00:51
Oracle Database Java Packages VALID 10.2.0.5.0 00:00:45
Oracle Text VALID 10.2.0.5.0 00:01:07
Oracle XML Database VALID 10.2.0.5.0 00:03:26
Oracle Workspace Manager VALID 10.2.0.5.0 00:01:21
Oracle Data Mining VALID 10.2.0.5.0 00:00:39
OLAP Analytic Workspace VALID 10.2.0.5.0 00:00:48
OLAP Catalog VALID 10.2.0.5.0 00:02:01
Oracle OLAP API VALID 10.2.0.5.0 00:02:01
Oracle interMedia VALID 10.2.0.5.0 00:06:35
Spatial VALID 10.2.0.5.0 00:04:50
Oracle Expression Filter VALID 10.2.0.5.0 00:00:30
Oracle Enterprise Manager VALID 10.2.0.5.0 00:02:59
Oracle Rule Manager VALID 10.2.0.5.0 00:00:18
Total Upgrade Time: 00:53:47
DOC>#######################################################################
DOC>#######################################################################
DOC>
DOC> The above PL/SQL lists the SERVER components in the upgraded
DOC> database, along with their current version and status.
DOC>
DOC> Please review the status and version columns and look for
DOC> any errors in the spool log file. If there are errors in the spool
DOC> file, or any components are not VALID or not the current version,
DOC> consult the Oracle Database Upgrade Guide for troubleshooting
DOC> recommendations.
DOC>
DOC> Next shutdown immediate, restart for normal operation, and then
DOC> run utlrp.sql to recompile any invalid application objects.
DOC>
DOC>#######################################################################
DOC>#######################################################################
DOC>#
第三步，shutdown 实例。Startup实例
第四步，再次编译无效的应用对象
SQL> @?/rdbms/admin/utlrp.sql
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN 2014-09-11 21:52:02
DOC> The following PL/SQL block invokes UTL_RECOMP to recompile invalid
DOC> objects in the database. Recompilation time is proportional to the
DOC> number of invalid objects in the database, so this command may take
DOC> a long time to execute on a database with a large number of invalid
DOC> objects.
DOC>
DOC> Use the following queries to track recompilation progress:
DOC>
DOC> 1. Query returning the number of invalid objects remaining. This
DOC> number should decrease with time.
DOC> SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
DOC>
DOC> 2. Query returning the number of objects compiled so far. This number
DOC> should increase with time.
DOC> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC> This script automatically chooses serial or parallel recompilation
DOC> based on the number of CPUs available (parameter cpu_count) multiplied
DOC> by the number of threads per CPU (parameter parallel_threads_per_cpu).
DOC> On RAC, this number is added across all RAC nodes.
DOC>
DOC> UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel
DOC> recompilation. Jobs are created without instance affinity so that they
DOC> can migrate across RAC nodes. Use the following queries to verify
DOC> whether UTL_RECOMP jobs are being created and run correctly:
DOC>
DOC> 1. Query showing jobs created by UTL_RECOMP
DOC> SELECT job_name FROM dba_scheduler_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC> 2. Query showing UTL_RECOMP jobs that are running
DOC> SELECT job_name FROM dba_scheduler_running_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END 2014-09-11 21:53:40
DOC> The following query reports the number of objects that have compiled
DOC> with errors (objects that compile with errors have status set to 3 in
DOC> obj$). If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#
OBJECTS WITH ERRORS
-------------------
0
DOC> The following query reports the number of errors caught during
DOC> recompilation. If this number is non-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to misconfiguration or resource constraints that must be
DOC> fixed before objects can compile successfully.
DOC>#
ERRORS DURING RECOMPILATION
---------------------------
0
SQL>
热AI工具
Undresser.AI Undress
人工智能驱动的应用程序，用于创建逼真的裸体照片
AI Clothes Remover
用于从照片中去除衣服的在线人工智能工具。
Undress AI Tool
免费脱衣服图片
Clothoff.io
AI脱衣机
AI Hentai Generator
免费生成ai无尽的。
热门文章
热工具
记事本++7.3.1
好用且免费的代码编辑器
SublimeText3汉化版
中文版，非常好用
禅工作室 13.0.1
功能强大的PHP集成开发环境
Dreamweaver CS6
视觉化网页开发工具
SublimeText3 Mac版
神级代码编辑软件(SublimeText3)
热门话题
oracle如何查表空间大小
Apr 11, 2025 pm 08:15 PM
要查询 Oracle 表空间大小，请遵循以下步骤：确定表空间名称，方法是运行查询：SELECT tablespace_name FROM dba_tablespaces;查询表空间大小，方法是运行查询：SELECT sum(bytes) AS total_size, sum(bytes_free) AS available_space, sum(bytes) - sum(bytes_free) AS used_space FROM dba_data_files WHERE tablespace_
oracle数据库如何导入
Apr 11, 2025 pm 08:06 PM
数据导入方法：1. 使用 SQLLoader 实用程序：准备数据文件、创建控制文件、运行 SQLLoader；2. 使用 IMP/EXP 工具：导出数据、导入数据。提示：1. 大数据集推荐 SQL*Loader；2. 目标表应存在，列定义匹配；3. 导入后需验证数据完整性。
oracle如何增加表字段
Apr 11, 2025 pm 07:30 PM
使用 ALTER TABLE 语句，具体语法如下：ALTER TABLE table_name ADD column_name data_type [constraint-clause]。其中：table_name 为表名，column_name 为字段名，data_type 为数据类型，constraint-clause 为可选的约束。示例：ALTER TABLE employees ADD email VARCHAR2(100) 为 employees 表添加 email 字段。
如何在oracle中创建表
Apr 11, 2025 pm 08:00 PM
创建 Oracle 表涉及以下步骤：使用 CREATE TABLE 语法指定表名、列名、数据类型、约束和默认值。表名应简洁、描述性，且不超过 30 个字符。列名应描述性，数据类型指定列中存储的数据类型。NOT NULL 约束确保列中不允许使用空值，DEFAULT 子句可指定列的默认值。PRIMARY KEY 约束标识表的唯一记录。FOREIGN KEY 约束指定表中的列引用另一个表中的主键。请参见示例表 students 的创建，其中包含主键、唯一约束和默认值。
oracle中乱码怎么解决
Apr 11, 2025 pm 10:09 PM
Oracle 乱码问题可以通过以下步骤解决：检查数据库字符集以确保与数据相匹配。设置客户端字符集以与数据库相匹配。转换数据或修改列字符集以匹配数据库字符集。使用 Unicode 字符集，并避免多字节字符集。检查数据库和客户端的语言设置是否正确。
oracle如何去重查询
Apr 11, 2025 pm 07:33 PM
Oracle 提供多种去重查询方法：DISTINCT 关键字返回每列的唯一值。GROUP BY 子句对结果分组并返回每个分组的非重复值。UNIQUE 关键字用于创建仅包含唯一行的索引，查询该索引将自动去重。ROW_NUMBER() 函数分配唯一数字并过滤出仅包含第 1 行的结果。MIN() 或 MAX() 函数可返回数字列的非重复值。INTERSECT 运算符返回两个结果集的公共值（无重复项）。
Oracle安装失败如何卸载
Apr 11, 2025 pm 08:24 PM
Oracle 安装失败的卸载方法：关闭 Oracle 服务，删除 Oracle 程序文件和注册表项，卸载 Oracle 环境变量，重新启动计算机。若卸载失败，可使用 Oracle 通用卸载工具手动卸载。
oracle打不开怎么办
Apr 11, 2025 pm 10:06 PM
Oracle 打不开的解决办法包括：1. 启动数据库服务；2. 启动监听器；3. 检查端口冲突；4. 正确设置环境变量；5. 确保防火墙或防病毒软件未阻止连接；6. 检查服务器是否已关闭；7. 使用 RMAN 恢复损坏的文件；8. 检查 TNS 服务名称是否正确；9. 检查网络连接；10. 重新安装 Oracle 软件。
