Skip to content

Database Relocation Error

case: trying to relocate database and it gives error.

solution: try to stop and start database few times until it works out using srvclt or sqlplus

example: 

-bash-4.2$ srvctl relocate database -d tempc -n node1.com -w 1

PRCD-1161 : Online relocation failed for RAC One Node database tempc
PRCR-1037 : Failed to update cardinality of the resource ora.tempc.db to 1
PRCR-1071 : Failed to register or update resource ora.tempc.db
CRS-2736: The operation requires stopping resource ‘ora.tempc.db’ on server ‘node2’
CRS-2744: Unable to modify resource ‘ora.tempc.db’ as this will affect running resources, but the force option was not specified
-bash-4.2$
-bash-4.2$
-bash-4.2$ srvctl status database -d tempc
Instance tempc_1 is running on node node2
Instance tempc_1 is running on node node1
Online relocation: FAILED
Source instance: tempc_1 on node1
Destination instance: tempc_1 on node2
-bash-4.2$
-bash-4.2$ db | grep cert
oracle 9961580 1 0 09:46:31 – 0:00 ora_pmon_tempc_1
-bash-4.2$
-bash-4.2$
-bash-4.2$ sqlplus sys@tempc

SQL*Plus: Release 12.2.0.1.0 Production on Fri Apr 5 10:04:03 2019

Copyright (c) 1982, 2017, Oracle. All rights reserved.

Enter password:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
-bash-4.2$ sqlplus sys/dbadm1n@tempc as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Apr 5 10:04:30 2019

Copyright (c) 1982, 2017, Oracle. All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Enter user-name:
-bash-4.2$
-bash-4.2$ srvctl stop database -d tempc -o immediate;
-bash-4.2$
-bash-4.2$ srvctl start database -d tempc
PRCR-1079 : Failed to start resource ora.tempc.db
CRS-5017: The resource action “ora.tempc.db start” encountered the following error:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 2410
Additional information: -1042435125
Process ID: 0
Session ID: 0 Serial number: 0

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: