XP系统连公司的服务器上的oracle没问题的,可是连自己的服务器上的oracle遇到问题
oracle安装在linux系统上,在linux上用sqlplus可以正常访问数据库
在服务器上
tnsping orclTNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 01-1ÔÂ -2010 00:35:50Copyright (c) 1997, 2005, Oracle. All rights reserved.Used parameter files:
/u01/app/oracle/product/10.2.0/db/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.17)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (0 msec)
服务器上的tnsnames.orapis_test =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)@localhost admin]$ lsnrctl serviceLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 01-1ÔÂ -2010 00:33:34Copyright (c) 1991, 2005, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:3 refused:0 state:ready
LOCAL SERVER
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: localhost.localdomain, pid: 4550>
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=43910))
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:3 refused:0 state:ready
LOCAL SERVER
The command completed successfully在XP上的tnsnames.orapis_test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.17)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)不知道是什么地方配错了,请高手指点啊~~
oracle安装在linux系统上,在linux上用sqlplus可以正常访问数据库
在服务器上
tnsping orclTNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 01-1ÔÂ -2010 00:35:50Copyright (c) 1997, 2005, Oracle. All rights reserved.Used parameter files:
/u01/app/oracle/product/10.2.0/db/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.17)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (0 msec)
服务器上的tnsnames.orapis_test =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)@localhost admin]$ lsnrctl serviceLSNRCTL for Linux: Version 10.2.0.1.0 - Production on 01-1ÔÂ -2010 00:33:34Copyright (c) 1991, 2005, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:3 refused:0 state:ready
LOCAL SERVER
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: localhost.localdomain, pid: 4550>
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=43910))
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:3 refused:0 state:ready
LOCAL SERVER
The command completed successfully在XP上的tnsnames.orapis_test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.17)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)不知道是什么地方配错了,请高手指点啊~~
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.17)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
) pis_test =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
) 两个配置一样的,改个试试
C:/>SET ORACLE_SID=ORCL
或者
C:/>SET ORACLE_SID=RO
看你用哪个了