ORA-12514 - Please help me

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

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

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@orcl

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

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

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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: