ORA-12514 - Please help me
- From: jaysingh1@xxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 24 Aug 2004 16:46:49 -0400
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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
