Discussions
Categories
- 384.5K All Categories
- 2.5K Data
- 555 Big Data Appliance
- 1.9K Data Science
- 451.4K Databases
- 222.1K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 561 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 561 SQLcl
- 4K SQL Developer Data Modeler
- 187.5K SQL & PL/SQL
- 21.4K SQL Developer
- 296.9K Development
- 1 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 293.6K Development Tools
- 112 DevOps
- 3.1K QA/Testing
- 646.2K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 193 Java Community Process
- 106 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 166 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 533 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 178 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 236 Portuguese
database is open but can't sqlplus into it
I have upgrade db from 12 to 19c. All successful and when I applied April 2022 patch, OJVM was fine but DB patch successful for 158 minutes. The problem is db open but can't sqlplus into it. it's idle instance. I checked the status, crsctl stat res -t and target of ora.ons OFFLINE OFFLINE and ora.dbname.db ONLINE INTERMEDIATE.
I tried to force to shutdown and restart the database via srvctl command. After db start, I checked the status and it hung for quite long... after that, the sqlplus is still idle instance. According to the alert that after the DATABASE OPEN, something goes wrong with ORA-00445: background process "W004" and "CL00" did not start after 120 second. After that Unable to obtain current patch information due to error: 20001, ORA-20001: Latest xml inventory is not loaded into table: ORA-06512 at "SYS.DBMS_QOPATCH", line 2327, line 854, 937, 932. ORA-06510: PL/SQL: unhandled user-defined exception. ORA-29913: error in executing ODCIEXTTABLEFETCH callout. ORA-29400: data cartridge error. KUP-04095: preprocessor command $ORACLE_HOME/QOPatch/qopiprep.cat encountered error "pipe read timeout". ORA-06512: at "SYS.DBMS_QOPATCH", line 919, 2286, 817, 2309. It tries delete the shared memory segments from previous instance incarnation before starting the instance. and still error ORA-00445: background process "CL00" did not start after 120 second.
ASMB has not responded for 193 seconds
NOTE: ASMB umbilicus running slower than expected. heavy swapping observed on system in last 5 mins.
I tried to run dispatch and still didn't help. Would like to roll back the patchset. When I run roothas.sh -unlock it took 15 minutes to unlock. After rollback all OJVM and RU patchset, I reboot the server and nothing is come back up. Unable to connect to Cluster Synchronization Service, "has" daemon is up but could not contact Oracle High Availability Service.
What do I need to do to resolve this problem to start asm and db?
this is not RAC node but single instance running on diskgroup.
Answers
-
You ae using srvctl to startup the database? Is that what you've been doing before on 12c before the upgrade?