请教ORA-12154: TNS:could not resolve the connect identifier specified

liujsh

环境redhat 5.0 安装了oracle 10g，安装完成后，sqlplus /nolog ,出现sql 〉，用conn sys/sys@orc
1 as sysdba ,则会出现ORA-12154: TNS:could not resolve the connect identifier specified，请问是什么原因，应该如何解决，急！希望大家帮帮忙！

hb_li_520

原帖由 liujsh 于 2007-8-3 16:42 发表
环境redhat 5.0 安装了oracle 10g，安装完成后，sqlplus /nolog ,出现sql 〉，用conn sys/sys@orc
1 as sysdba ,则会出现ORA-12154: TNS:could not resolve the connect identifier specified，请问是什么原因 ...

看你的listener是否有起?

1. 
   
2. lsnrctl stat
   
3. tnsping orcl
   

复制代码

还有请贴出
listener.ora内容
tnsnames.ora文件内容

liujsh

# listener.ora Network Configuration File: /opt/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
  )

# tnsnames.ora Network Configuration File: /opt/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

RCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PLSExtProc)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = orac1)
      (PRESENTATION = RO)
    )
  )

license 起来了

hb_li_520

原帖由 liujsh 于 2007-8-3 16:42 发表
环境redhat 5.0 安装了oracle 10g，安装完成后，sqlplus /nolog ,出现sql 〉，用conn sys/sys@orc
1 as sysdba ,则会出现ORA-12154: TNS:could not resolve the connect identifier specified，请问是什么原因 ...

1. conn sys/sys@orc1 as sysdba

复制代码

tnsnames.ora出错:

1. 
   
2. RCL =
   
3.   (DESCRIPTION =
   
4.     (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
   
5.     (CONNECT_DATA =
   
6.       (SERVER = DEDICATED)
   
7.       (SERVICE_NAME = PLSExtProc)
   
8.     )
   
9.   )
   
10. 
    
11. EXTPROC_CONNECTION_DATA =
    
12.   (DESCRIPTION =
    
13.     (ADDRESS_LIST =
    
14.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    
15.     )
    
16.     (CONNECT_DATA =
    
17.       (SID = orac1)
    
18.       (PRESENTATION = RO)
    
19.     )
    
20.   )
    

复制代码

请仔细去看一下tnsnames.ora的配置~~~~~~
tnsping orcl可以通时就以了!

conn sys/sys@EXTPROC_CONNECTION_DATA as sysdba
应该是这样的.