ORA-12514 - Please help me

From: <jaysingh1_at_optonline.net>
Date: Tue, 24 Aug 2004 16:46:49 -0400
Message-id: <c61033c66566.c66566c61033@optonline.net>

Hi All,

Could someone help me out here to fix this issue? I restarted the listener but no luck.

C:\>sqlplus /nolog

SQL*Plus: Release 10.1.0.2.0 - Production on Tue Aug 24 15:50:51 2004

SQL> connect / as sysdba
Connected.
SQL> show parameter service_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- --------------------------
service_names                        string      orcl

SQL> tnsnames.ora

# tnsnames.ora Network Configuration File: C:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tamizh)(PORT = 1521)) (CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)

)
)

C:\>sqlplus system/welcome_at_orcl

SQL*Plus: Release 10.1.0.2.0 - Production on Tue Aug 24 15:49:32 2004

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Aug 24 2004 - 15:42:35 CDT