Home  >  Oracle Database Administration (DBA)  >  Maintenance  >  ORA-12514 after service creation with Entreprise Manager 11.2

ORA-12514 after service creation with Entreprise Manager 11.2

oracle@linux1rac:/oracle/grid/11.2/bin>tnsping serviciu_creat_cata1

TNS Ping Utility for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production on 14-AUG-2010 18:44:36

Copyright (c) 1997, 2009, Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = scan.mfol.ist.ro)(PORT = 1521)) (LOAD_BALANCE = YES) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = serviciu_creat_cata1) (FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5))))
OK (0 msec)
oracle@linux1rac:/oracle/grid/11.2/bin>sqlplus scott/s     (here another service is used)

SQL*Plus: Release 11.2.0.1.0 Production on Sat Aug 14 18:45:08 2010

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters and Real Application Testing options

SQL> conn scott/s@serviciu_creat_cata1
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor


Warning: You are no longer connected to ORACLE.

more $ORACLE_HOME/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /oracle/db/11.2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = scan.mfol.ist.ro)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST.mfol.ist.ro)
)
)

serviciu_creat_cata1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = scan.mfol.ist.ro)(PORT = 1521))
(LOAD_BALANCE = YES)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = serviciu_creat_cata1)
(FAILOVER_MODE =
(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5)
)
)
)
 

COMMENT: serviciu_creat_cata1 tnsnames.ora entry was created by the EM automatically.

Now, edit the tnsnames.ora on each node and add the domain to the SERVICE_NAME to have:

(SERVICE_NAME = serviciu_creat_cata1.mfol.ist.ro)

More information about  this subject ( ORA-12514 after service creation with Entreprise Manager 11.2 ) you can get from  www.in-oracle.com