My Oracle Support Banner

11.2 Oracle Restart cannot manage 10.x or 11.1 single instances (Doc ID 954552.1)

Last updated on FEBRUARY 18, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


Does 'oracle restart' (new 11.2 ASM feature) support database instances?   

NOTE:  The feature also applies to 10.2.x and 11.1.x  resources.

### 1. Add database to Oracle Restart configuration:
oracle@node1:~/ [+ASM] srvctl add database -d test -o
<Database Oracle Home> -m -p
<Database Oracle Home>/dbs/spfiletest.ora -s open -t immediate -n

oracle@node1:~/ [+ASM] srvctl config database -d test
Database unique name: test
Database name: test
Oracle home: <Database Oracle Home>
Oracle user: oracle
Spfile: <Database Oracle Home>/dbs/spfiletest.ora
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups:
oracle@node1:~/ [+ASM]

### 2. Database start (please have a look at the alert and agent log files.
The database has been started successfully, but afterwards during resource
check killed by the agent):
oracle@node1:~/ [+ASM] srvctl start database -d test
PRCR-1079 : Failed to start resource ora.test.db
CRS-5011: Check of resource "test" failed: details at "(:CLSN00007:)" in
CRS-2674: Start of 'ora.test.db' on 'node1' failed
oracle@node1:~/ [+ASM]




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.