ORA-16032 Can not Start Instance via srvctl but via sqlplus is fine
(Doc ID 1062071.1)
Last updated on SEPTEMBER 16, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.1 [Release 10.1 to 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Using 11.2. Grid Infrastructure, the database instances cannot be started via 'srvctl', but can be started via 'sqlplus'. The same spfile "+DATA/<DB_NAME>/spfile<DB_NAME>.ora" is used for both srvctl and sqlplus:
[oracle@node1] /opt/oracle/admin/+ASM $ srvctl start database -d <DB_NAME>
PRCR-1079 : Failed to start resource ora.<DB_NAME>.db
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
ORA-16032: parameter %s destination string cannot be translated
CRS-2674: Start of 'ora.<DB_NAME>.db' on 'node1' failed
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
PRCR-1079 : Failed to start resource ora.<DB_NAME>.db
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
ORA-16032: parameter %s destination string cannot be translated
CRS-2674: Start of 'ora.<DB_NAME>.db' on 'node1' failed
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
The associated oraagent_oracle.log (located in GRID_home/log/nodename/agent/crsd/oraagent_oracle/) shows similar messages:
2010-02-09 07:08:22.587: [ AGFW][1169193280] ora.<DB_NAME>.db 1 1 state changed from: OFFLINE to: STARTING
2010-02-09 07:08:22.587: [ AGFW][1148213568] Executing command: start for resource: ora.<DB_NAME>.db 1 1
2010-02-09 07:08:37.488: [ AGFW][1148213568] sending status msg [ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
] for start for resource: ora.<DB_NAME>.db 1 1
2010-02-09 07:08:37.571: [ora.<DB_NAME>.db][1148213568] [start] Exception type=2 string=ORA-16032: parameter %s destination string cannot be translated
2010-02-09 07:08:37.571: [ AGFW][1148213568] sending status msg [ORA-16032: parameter %s destination string cannot be translated
] for start for resource: ora.<DB_NAME>.db 1 1
2010-02-09 07:08:37.571: [ora.<DB_NAME>.db][1148213568] [start] clsn_agent::start }
2010-02-09 07:08:37.571: [ AGFW][1148213568] Command: start for resource: ora.<DB_NAME>.db 1 1 completed with status: FAIL
2010-02-09 07:08:22.587: [ AGFW][1148213568] Executing command: start for resource: ora.<DB_NAME>.db 1 1
2010-02-09 07:08:37.488: [ AGFW][1148213568] sending status msg [ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
] for start for resource: ora.<DB_NAME>.db 1 1
2010-02-09 07:08:37.571: [ora.<DB_NAME>.db][1148213568] [start] Exception type=2 string=ORA-16032: parameter %s destination string cannot be translated
2010-02-09 07:08:37.571: [ AGFW][1148213568] sending status msg [ORA-16032: parameter %s destination string cannot be translated
] for start for resource: ora.<DB_NAME>.db 1 1
2010-02-09 07:08:37.571: [ora.<DB_NAME>.db][1148213568] [start] clsn_agent::start }
2010-02-09 07:08:37.571: [ AGFW][1148213568] Command: start for resource: ora.<DB_NAME>.db 1 1 completed with status: FAIL
Changes
New installation
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |