Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, mangesh.

Asked: March 08, 2018 - 5:58 am UTC

Last updated: March 21, 2018 - 11:18 am UTC

Version: 12.1

Viewed 1000+ times

You Asked

Hi,

I am working on 12cR1 version installed on my windows 8.1 laptop. Trying to learn EBR and so want to create additional services so that I can connect to two different editions if required. Using below command, but getting error.

>srvctl add service -db CDB -service pdb1_ed1 -edition
edition_1 -pdb pdb1
PRCD-1027 : Failed to retrieve database CDB
PRCR-1070 : Failed to check if resource ora.cdb.db is registered
CRS-0184 : Cannot communicate with the CRS daemon.

Referring to article: http://www.oracle.com/technetwork/articles/database/multitenant-part1-pdbs-2193987.html, section Adding Services in PDBs.

CDB and pdb1 both exist. Any help?

Thanks,
Mangesh



and Connor said...

Without the grid infrastructure, you need to use services *within* the database.

Check out DBMS_SERVICE for that.

SQL> exec dbms_service.create_service('NEW_SERVICE','NEW_SERVICE');

PL/SQL procedure successfully completed.

SQL> exec dbms_service.start_service('NEW_SERVICE');

PL/SQL procedure successfully completed.

SQL> exec dbms_service.stop_service('NEW_SERVICE');

PL/SQL procedure successfully completed.

SQL> exec dbms_service.delete_service('NEW_SERVICE');

PL/SQL procedure successfully completed.


https://docs.oracle.com/en/database/oracle/oracle-database/18/arpls/DBMS_SERVICE.html

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

mangesh, March 08, 2018 - 8:24 am UTC

thanks, it worked.


srvctl add service on standalone

Failed to retrieve database CDB, March 20, 2018 - 11:35 pm UTC

Hello,
I am too working on 12cR1 version installed in Windows 2012 server and I have the same error. I installed 12c and created one database and the Listener and service database in Windows is created but when I try to use the srvctl command for see the status for example, I received error below. Need I to do something to use these commands?

PRCD-1027 : Failed to retrieve database sigatest
PRCR-1070 : Failed to check if resource ora.cdb.db is registered
CRS-0184 : Cannot communicate with the CRS daemon.
Connor McDonald
March 21, 2018 - 11:18 am UTC

See my answer - check out DBMS_SERVICE

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database