- 论坛徽章:
- 0
|
原帖由 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,请问是什么原因 ... - conn sys/sys@orc1 as sysdba
复制代码
tnsnames.ora出错:
- 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)
- )
- )
复制代码
请仔细去看一下tnsnames.ora的配置~~~~~~
tnsping orcl可以通时就以了!
conn sys/sys@EXTPROC_CONNECTION_DATA as sysdba
应该是这样的. |
|