SQL*Net - RAC - ORA-12514

From: Ethan Post <post.ethan_at_gmail.com>
Date: Tue, 24 Aug 2010 20:47:44 -0500
Message-ID: <AANLkTinjZaFGRMckM+uPt+e92N8E33hgbp6zEb8cvn7q_at_mail.gmail.com>

Good golly this should not be that hard.

I have two 2 node rac databases, RAC1 and PROD.

RAC1 works fine, created at install.

I create PROD manually. I can start and stop the database with srvctl fine, tns entries for RAC1 match PROD. When I check services for listener I see a service for PROD. Everything is the same so far.

So perhaps I need to create a service "srvctl add service -d PROD -s PROD -r PROD1" OK, tried that, no dice, should service name include domain in order to match tns?

Anyway, one I am posting because this has always been too complex, Oracle you need to make this easier.

Two, can someone point me to a decent doc/page which I can use to try to debug the actual issue. Unfortunately error "ORA-12514" is just way too common and my searches have not turned up what I am looking for.

One more buggy looking thing I did, I actually have database instances "PROD and PROD2" and my service is going to also be PROD. Hope that doesn't mess anything up but I converted the DB into ASM from a stand alone database and didn't have time to figure out how to change the name to PROD1.

Received on Tue Aug 24 2010 - 20:47:44 CDT

Original text of this message