请教错误ORA-12162: TNS:service name is incorrectly specified

change_horn

>; lsnrctl start

LSNRCTL for Solaris: Version 9.2.0.5.0 - Production on 05-MAR-2005 14:47:05

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Starting /opt/oracle/OraHome1/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 9.2.0.5.0 - Production
System parameter file is /opt/oracle/OraHome1/network/admin/listener.ora
Log messages written to /opt/oracle/OraHome1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db1.ca.alcatel.com)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 9.2.0.5.0 - Production
Start Date                05-MAR-2005 14:47:05
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /opt/oracle/OraHome1/network/admin/listener.ora
Listener Log File         /opt/oracle/OraHome1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db1.ca.alcatel.com)(PORT=1521)))
The listener supports no services
The command completed successfully
>; dbstart

SQL*Plus: Release 9.2.0.5.0 - Production on Sat Mar 5 14:47:20 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL>; ERROR:
ORA-12162: TNS:service name is incorrectly specified


SQL>; ORA-12162: TNS:service name is incorrectly specified
SQL>;
Database "" warm started.

SQL*Plus: Release 9.2.0.5.0 - Production on Sat Mar 5 14:47:20 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL>; Connected to an idle instance.
SQL>; ORACLE instance started.

Total System Global Area  135353900 bytes
Fixed Size                   456236 bytes
Variable Size             109051904 bytes
Database Buffers           25165824 bytes
Redo Buffers                 679936 bytes
Database mounted.
Database opened.
SQL>; Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production

Database "OMP5950" warm started.
>; pwd
/opt/oracle/OraHome1/network/admin

cole

ORA-12162: TNS:net service name is incorrectly specified
Cause: The connect descriptor corresponding to the net service name in TNSNAMES.ORA or in the directory server (Oracle Internet Directory) is incorrectly specified.
Action: If using local naming make sure there are no syntax errors in the corresponding connect descriptor in the TNSNAMES.ORA file. If using directory naming check the information provided through the administration used for directory naming


我的配置
ORACLEDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = win2000)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oracledb.abc.com)
    )
  )
其中ORACLEDB为实例名