My Oracle Support Banner

DBCA Fails with ORA-00119 ORA-00132 During RAC Database Creation (Doc ID 1496178.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
GNS (Grid Naming Service) is being used in this cluster environment.

Symptoms

Following successful 11.2.0.3 Grid Infrastructure (making use of the GNS feature) and RDBMS installations, Real Application Clusters (RAC) database creation using the Database Configuration Assistant (DBCA) fails with error messages "ORA-00119" and "ORA-00132"


1.  The resulting DBCA log file ($ORACLE_BASE\cfgtoollogs\dbcatrace.log) indicates the following:

[Thread-121] [ 2012-09-06 15:57:46.596 IST ] [BasicStep.handleNonIgnorableError:431]  ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name 'mycluster-scan.mycluster.mydomain.com:1521'
:msg

 

2.  nslookup of the SCAN name is failing as follows:

C:\Users\administrator>nslookup mycluster-scan.mycluster.mydomain.com
Server:  domain.mydomain.com
Address:  20.20.0.1

*** domain.mydomain.com can't find mycluster-scan.mycluster.mydomain.com: Non-existent domain

 

3.  The Cluster Verification Utility (CLUVFY) is indicating some errors related to the GNS sub domain:

C:\app\11.2.0\grid\BIN>cluvfy stage -post crsinst -n node1,node2

...

Verification of SCAN VIP and Listener setup passed

Checking GNS integrity...
The GNS subdomain name "mycluster.mydomain.com" is a valid domain name
Checking if the GNS VIP belongs to same subnet as the public network...
Public network subnets "20.20.0.0" match with the GNS VIP "20.20.0.0"
GNS VIP "mycluster-gns.mydomain.com" resolves to a valid IP address

WARNING:

PRVF-5217 : An error occurred while trying to look up IP address for "node2-vip.mycluster.mydomain.com"

WARNING:

PRVF-5217 : An error occurred while trying to look up IP address for "node2.mycluster.mydomain.com"

WARNING:

PRVF-5217 : An error occurred while trying to look up IP address for "node1.mycluster.mydomain.com"

WARNING:

PRVF-5217 : An error occurred while trying to look up IP address for "node1-vip.mycluster.mydomain.com"

GNS resource configuration check passed

GNS VIP resource configuration check passed.

GNS integrity check passed

 

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
Cause
Solution

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