Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 10g after the failure to start the upgrade (Oracle instance terminated. Disconnection forced)     - linux system optimization and security configuration (Linux)

- 10046 trace only open for a particular SQL statement (Database)

- Oracle Database High-Risk Vulnerability Warning (Database)

- C ++ Const breaking rules (Programming)

- Linux / Centos anti CC attack script (Linux)

- UNIX and class UNIX system security check notes (Linux)

- Alien Magic: RPM and DEB Mutual Convert (Linux)

- Debian GNU / Linux service list acquisition, shutting down services or run (Linux)

- Linux maximum number of threads and limit the number of queries the current thread (Linux)

- SQL in the specific internal Oracle process (Database)

- Linux md5sum verify file integrity (Linux)

- OGG-01496 OGG-01031 Error Resolution (Database)

- Hanoi problem Java Solution (Programming)

- CentOS6 installed Tomcat (Server)

- C language files update in real time (Programming)

- How to install the Linux text editor Atom 0.124.0 (Linux)

- OpenStack image production in the CentOS 6.2 (Linux)

- Linux Log Clear (Linux)

- How to build Memcached Docker container (Server)

- Linux install Eclipse for C / C ++ Development (Linux)

 
         
  Oracle 10g after the failure to start the upgrade (Oracle instance terminated. Disconnection forced)
     
  Add Date : 2018-11-21      
         
         
         
  SQL> startup
Oracle instance started.
Total System Global Area 285212672 bytes
Fixed Size 1267044 bytes
Variable Size 130026140 bytes
Database Buffers 146800640 bytes
Redo Buffers 7118848 bytes
Database mounted.
ORA-01092: ORACLEinstance terminated. Disconnection forced

View the alert_rhip.log file (/opt/oracle/admin/rhip/bdump/alert_rhip.log)

Errors in file /opt/oracle/admin/rhip/udump/rhip_ora_17875.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened withUPGRADE option
Tue May 19 17:35:50 CST 2015
Error 704 occurred during db open, shuttingdown database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 17875
ORA-1092 signalled during: ALTER DATABASEOPEN ...
 
View the rhip_ora_17875.trc file
/opt/oracle/admin/rhip/udump/rhip_ora_17875.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /opt/oracle/product/10.2.0/db_1
System name: Linux
Node name: test
Release: 2.6.18-164.el5
Version: # 1 SMP Tue Aug 18 15:51:48 EDT 2009
Machine: x86_64
Instance name: rhip
Redo thread mounted by this instance: 1
Oracle process number: 15
Unix process pid: 17875, image: oracle @ test (TNS V1 - V3)
 
*** ACTION NAME :() 2015-05-19 17: 35: 50.802
*** MODULE NAME: (sqlplus @ test (TNS V1-V3)) 2015-05-19 17: 35: 50.802
*** SERVICE NAME: (SYS $ USERS) 2015-05-1917: 35: 50.802
*** SESSION ID: (159.3) 2015-05-1917: 35: 50.802
ORA-00704: bootstrap process failure
ORA-39700: database must be opened withUPGRADE option
Reason: Because of today's database upgrade, the data dictionary of some of the contents of the base table has been modified.
 
Workaround: Start the database in upgrade mode and upgrade the data dictionary
SQL> startup upgrade
  
SQL> select status from v $ instance;
  
STATUS
------------------------
OPEN MIGRATE

Make sure that the state of the instance is OPEN MIGRATE ()

When upgrading large databases or large patches, it is always necessary to upgrade the existing database data dictionary. The reason for upgrading the data fields is that as the Oracle version is upgraded, the properties of some objects need to be changed to ensure that the system's data Dictionaries for completeness and validity These changes are in the upgrade script $ ORACLE_HOME / rdbms / admin / catupgrd.sql.
1, to upgrade mode to start the database, began to upgrade the data dictionary
1 SQL> @ / opt / product / 10.2.0 / db_1 / rdbms / catupgrd.sql

When you upgrade the data dictionary, you can see the corresponding action

PL / SQL procedure successfully completed.
  
Type created.
  
Grant succeeded.
  
Package created.
  
No errors.
  
Table created.
  
PL / SQL procedure successfully completed.
  
View created.
  
Synonym created.
  
And further verify the role of catupgrd.sql, after upgrading the data dictionary, sqlplus will appear under the following information
  
TIMESTAMP
-------------------------------------------------- ------------------------------
COMP_TIMESTAMP RUL 2012-01-23 06:56:47
DBUA_TIMESTAMP RUL VALID 2012-11-23 06:56:47
COMP_TIMESTAMP UPGRD_END 2012-11-2306: 58: 01
.
Oracle Database 10.2 Upgrade StatusUtility 11-23-2012 06:58:01
.
Component Status Version HH: MM: SS
Oracle Database Server VALID 10.2.0.5.0 00:07:52
JServer JAVA Virtual Machine VALID 10.2.0.5.0 00:00:56
Oracle XDK VALID 10.2.0.5.0 00:00:23
Oracle Database Java Packages VALID 10.2.0.5.0 00:00:12
Oracle Text VALID 10.2.0.5.0 00:00:18
Oracle XML Database VALID 10.2.0.5.0 00:02:02
Oracle Workspace Manager VALID 10.2.0.5.0 00:00:36
Oracle Data Mining VALID 10.2.0.5.0 00:00:15
OLAP Analytic Workspace VALID 10.2.0.5.0 00:00:16
OLAP Catalog VALID 10.2.0.5.0 00:00:42
Oracle OLAP API VALID 10.2.0.5.0 00:00:31
Oracle interMedia VALID 10.2.0.5.0 00:02:21
Spatial VALID 10.2.0.5.0 00:01:32
Oracle Expression Filter VALID 10.2.0.5.0 00:00:06
Oracle Enterprise Manager VALID 10.2.0.5.0 00:00:30
Oracle Rule Manager VALID 10.2.0.5.0 00:00:06
.
Total Upgrade Time: 00:20:01
DOC> ######################################################## #######################
DOC> ######################################################## ######################
DOC>
DOC> The above PL / SQL lists theSERVER components in the upgraded
DOC> database, along with their current version and status.
DOC>
DOC> Please review the statusand version columns and look for
DOC> any errors in the spool logfile. If there are errors in the spool
DOC> file, or any components arenot VALID or not the current version,
DOC> consult the Oracle DatabaseUpgrade Guide for troubleshooting
DOC> recommendations.
DOC>
DOC> Next shutdown immediate, restart for normal operation, and then
DOC> run utlrp.sql to recompileany invalid application objects.
DOC>
DOC> ################################################# #######################
DOC> ################################################# #######################

2, restart the database again

SQL> shutdown immediate
SQL> startup
ORACLE instance started.

3, compile invalid object script utlrp.sql

Utlrp.sql script can be run in the database to execute the state to compile, the database of invalid objects, Oracle recommends the database migration, upgrades, downgrade run utlrp.sql to compile again after the invalid object.
Log in as sysdba to execute the script
[Oracle @ Oel_10 ~] $ sqlplus / as sysdba
SQL> @ / opt / product / 10.2.0 / db_1 / rdbms / admin / utlrp.sql
Note: To write the full script path
TIMESTAMP
-------------------------------------------------- ------------------------------
COMP_TIMESTAMP UTLRP_BGN 2012-11-2307: 04: 44
  
DOC> The following PL / SQL blockinvokes UTL_RECOMP to recompile invalid
DOC> objects in the database.Recompilation time is proportional to the
DOC> number of invalid objectsin the database, so this command may take
DOC> a long time to execute on adatabase with a large number of invalid
DOC> objects.
DOC>
DOC> Use the following queriesto track recompilation progress:
DOC>
DOC> 1. Query returning thenumber of invalid objects remaining. This
DOC> number shoulddecrease with time.
DOC> SELECTCOUNT (*) FROM obj $ WHERE status IN (4, 5, 6);
DOC>
DOC> 2. Query returning thenumber of objects compiled so far. This number
DOC> shouldincrease with time.
DOC> SELECTCOUNT (*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC> This script automaticallychooses serial or parallel recompilation
DOC> based on the number of CPUs available (parameter cpu_count) multiplied
DOC> by the number of threadsper CPU (parameter parallel_threads_per_cpu).
DOC> On RAC, this number isadded across all RAC nodes.
DOC>
DOC> UTL_RECOMP usesDBMS_SCHEDULER to create jobs for parallel
DOC> recompilation. Jobs arecreated without instance affinity so that they
DOC> can migrate across RACnodes. Use the following queries to verify
DOC> whether UTL_RECOMP jobs arebeing created and run correctly:
DOC>
DOC> 1. Query showing jobscreated by UTL_RECOMP
DOC> SELECTjob_name FROM dba_scheduler_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>
DOC> 2. Query showing UTL_RECOMPjobs that are running
DOC> SELECTjob_name FROM dba_scheduler_running_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC> #
  
PL / SQL procedure successfully completed.
  
  
TIMESTAMP
-------------------------------------------------- ------------------------------
COMP_TIMESTAMP UTLRP_END 2012-11-2307: 05: 46
  
  
PL / SQL procedure successfully completed.
  
DOC> The following query reports thenumber 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 higherthan expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfigurationor resource constraints that must be
DOC> fixed before attempting torecompile these objects.
DOC> #
  
OBJECTS WITH ERRORS
-------------------
                Lt; / RTI & gt;
  
DOC> The following query reports thenumber of errors caught during
DOC> recompilation. If this number isnon-zero, please query the error
DOC> messages in the table UTL_RECOMP_ERRORSto see if any of these errors
DOC> are due to misconfiguration orresource constraints that must be
DOC> fixed before objects can compilesuccessfully.
DOC> #
  
ERRORS DURING RECOMPILATION
---------------------------
                        Lt; / RTI & gt;
  
PL / SQL procedure successfully completed
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
  
Total System Global Area 7516192768 bytes
Fixed Size 2107936 bytes
Variable Size 1258292704 bytes
Database Buffers 6241124352 bytes
Redo Buffers 14667776 bytes
Database mounted.
Database opened.

 

SQL> select * from v $ version; / / View the database version
BANNER
-------------------------------------------------- ------------------------------
Oracle Database 10g Enterprise EditionRelease 10.2.0.5.0 - 64bi
PL / SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 -Production
NLSRTL Version 10.2.0.5.0 - Production

Up to now, the upgrade work initially completed
     
         
         
         
  More:      
 
- Ubuntu Server 14.04 installation Web server (Linux + Apache + MySQL + PHP) (Server)
- C ++ Supplements --new delete overload (Programming)
- Some of the bibliographic management tools to good use on linux (Linux)
- Parts of the partition is not recognized after Debian mount mobile hard disk (Linux)
- Android WebView use layman (Programming)
- Oracle 11g users to create, authorize and import dmp file (Database)
- Use PuTTY to access the virtual machine Linux under Windows xp (Programming)
- Ubuntu users to install voice switch instructs the applet (Linux)
- How Vim playing a mature IDE (Linux)
- Storm how to assign tasks and load balancing (Programming)
- Oracle 11g new features and associated SQL TUNING (Database)
- How to Install SeaMonkey 2.25 for Ubuntu (Linux)
- Performance issues under CentOS 6.5 VLAN devices (Linux)
- Node.js installed on Ubuntu Upstream version (Linux)
- MySQL 5.7 can not log in problem (Database)
- File encryption and decryption of Linux security mechanisms (Linux)
- Linux beginners to develop the seven habits (Linux)
- Vim useful plugin: EasyGrep (Linux)
- Java in the final qualifier (Programming)
- Various sorting algorithms implemented in Python (Programming)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.