LoveUnix » ORACLE等数据库 » ORA-12538: TNS:no such protocol adapter问题
2007-5-10 10:37
有有
ORA-12538: TNS:no such protocol adapter问题
$ tnsping jforum
TNS Ping Utility for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Production on 10-MAY-2007 09:47:09
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=IBM140)(PORT=1521))
OK (30 msec)
$ sqlplus [email=system/manager@jforum]system/manager@jforum[/email]
SQL*Plus: Release 8.1.7.0.0 - Production on Thu May 10 09:47:31 2007
(c) Copyright 2000 Oracle Corporation. All rights reserved.
ERROR:
ORA-12538: TNS:no such protocol adapter
$ cat listener.ora
# LISTENER.ORA Network Configuration File: /oracle/app/oracle/product/8.1.7/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBM140)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/app/oracle/product/8.1.7)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = jforum)
(SID_NAME = jforum)
(ORACLE_HOME = /oracle/app/oracle/product/8.1.7)
)
)
$ cat tnsnames.ora
# TNSNAMES.ORA Network Configuration File: /oracle/app/oracle/product/8.1.7/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
JFORUM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBM140)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jforum)
)
)
好像啥都正常
可就是不能连接。。。。。
$ tnsping jforum
TNS Ping Utility for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Production on 10-MAY-2007 09:47:09
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=IBM140)(PORT=1521))
OK (30 msec)
$ sqlplus [email=system/manager@jforum]system/manager@jforum[/email]
SQL*Plus: Release 8.1.7.0.0 - Production on Thu May 10 09:47:31 2007
(c) Copyright 2000 Oracle Corporation. All rights reserved.
ERROR:
ORA-12538: TNS:no such protocol adapter
$ cat listener.ora
# LISTENER.ORA Network Configuration File: /oracle/app/oracle/product/8.1.7/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBM140)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/app/oracle/product/8.1.7)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = jforum)
(SID_NAME = jforum)
(ORACLE_HOME = /oracle/app/oracle/product/8.1.7)
)
)
$ cat tnsnames.ora
# TNSNAMES.ORA Network Configuration File: /oracle/app/oracle/product/8.1.7/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
JFORUM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IBM140)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jforum)
)
)
好像啥都正常
可就是不能连接。。。。。
2007-5-10 13:53
Gavin_ygf
回复 #1 有有 的帖子
sqlnet.ora 文件的内容哪？
sqlnet.ora 文件的内容哪？
2007-5-10 13:55
Gavin_ygf
oracle的网络配置一般设计到三个文件
listener.ora 服务器端的 做监听用
tnsnames.ora 服务名
sqlnet.ora 采用的服务方式
listener.ora 服务器端的 做监听用
tnsnames.ora 服务名
sqlnet.ora 采用的服务方式
2007-5-10 14:09
有有
$ cat sqlnet.ora
# SQLNET.ORA Network Configuration File: /oracle/app/oracle/product/8.1.7/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
AUTOMATIC_IPC = OFF
# SQLNET.ORA Network Configuration File: /oracle/app/oracle/product/8.1.7/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
AUTOMATIC_IPC = OFF
2007-5-10 21:14
Gavin_ygf
回复 #4 有有 的帖子
你可以编辑一下你系统的hosts表
里面添加
IP IBM140
之后你再试试sqlplus 的连接
你可以编辑一下你系统的hosts表
里面添加
IP IBM140
之后你再试试sqlplus 的连接
2007-5-11 01:29
oraix
环境变量都设置好了么？
2007-5-14 23:40
有有
hosts设置好了，但不行；环境变量是指什么环境变量？
$ env
_=/usr/bin/env
TMPDIR=/oracle/tmp
LANG=en_US
LOGIN=oracle
PATH=/oracle/app/oracle/product/8.1.7/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/oracle/bin:/usr/bin/X11:/sbin:.
NLS_LANG=American_America.ZHS16GBK
LC__FASTMSG=true
CATALINA_HOME=/bbs/tomcat
CGI_DIRECTORY=/var/docsearch/cgi-bin
LOGNAME=oracle
JAVA2D_USEAWTFONTS=0
MAIL=/usr/spool/mail/oracle
ORACLE_SID=jforum
LOCPATH=/usr/lib/nls/loc
ORACLE_OWNER=oracle
DOCUMENT_SERVER_MACHINE_NAME=localhost
USER=oracle
AUTHSTATE=files
ORACLE_DOC=/oracle/app/oracle/product/8.1.7/doc
DEFAULT_BROWSER=netscape
DISPLAY=172.16.10.133:0.0
SHELL=/usr/bin/ksh
ORACLE_TERM=vt100
ODMDIR=/etc/objrepos
JAVA_HOME=/usr/java14
DOCUMENT_SERVER_PORT=49213
HOME=/oracle
TERM=vt100
MAILMSG=[YOU HAVE NEW MAIL]
ORACLE_HOME=/oracle/app/oracle/product/8.1.7
ITECONFIGSRV=/etc/IMNSearch
PWD=/oracle
DOCUMENT_DIRECTORY=/usr/docsearch/html
TZ=BEIST-8
ITECONFIGCL=/etc/IMNSearch/clients
ITE_DOC_SEARCH_INSTANCE=search
A__z=! LOGNAME
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
$ env
_=/usr/bin/env
TMPDIR=/oracle/tmp
LANG=en_US
LOGIN=oracle
PATH=/oracle/app/oracle/product/8.1.7/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/oracle/bin:/usr/bin/X11:/sbin:.
NLS_LANG=American_America.ZHS16GBK
LC__FASTMSG=true
CATALINA_HOME=/bbs/tomcat
CGI_DIRECTORY=/var/docsearch/cgi-bin
LOGNAME=oracle
JAVA2D_USEAWTFONTS=0
MAIL=/usr/spool/mail/oracle
ORACLE_SID=jforum
LOCPATH=/usr/lib/nls/loc
ORACLE_OWNER=oracle
DOCUMENT_SERVER_MACHINE_NAME=localhost
USER=oracle
AUTHSTATE=files
ORACLE_DOC=/oracle/app/oracle/product/8.1.7/doc
DEFAULT_BROWSER=netscape
DISPLAY=172.16.10.133:0.0
SHELL=/usr/bin/ksh
ORACLE_TERM=vt100
ODMDIR=/etc/objrepos
JAVA_HOME=/usr/java14
DOCUMENT_SERVER_PORT=49213
HOME=/oracle
TERM=vt100
MAILMSG=[YOU HAVE NEW MAIL]
ORACLE_HOME=/oracle/app/oracle/product/8.1.7
ITECONFIGSRV=/etc/IMNSearch
PWD=/oracle
DOCUMENT_DIRECTORY=/usr/docsearch/html
TZ=BEIST-8
ITECONFIGCL=/etc/IMNSearch/clients
ITE_DOC_SEARCH_INSTANCE=search
A__z=! LOGNAME
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
2007-5-15 02:09
oraix
在windows里面用sqlplus连接一下，如果能连接上，应该是服务器上某个参数的问题
看看sqlnet.log里面怎么说的？
看看sqlnet.log里面怎么说的？
2007-5-15 02:17
oraix
试试：
1.
export TNS_ADMIN=/oracle/app/oracle/product/8.1.7/network/admin
或者
2.
AUTOMATIC_IPC = ON
这个问题在windows下比较常见，不知道aix的原因，最好能查下日志sqlnet.log
1.
export TNS_ADMIN=/oracle/app/oracle/product/8.1.7/network/admin
或者
2.
AUTOMATIC_IPC = ON
这个问题在windows下比较常见，不知道aix的原因，最好能查下日志sqlnet.log
2007-5-15 08:48
有有
$ more sqlnet.log
***********************************************************************
Fatal NI connect error 12538, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IBM140)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=jforum)(CID=(PROGRAM=
)(HOST=IBM140)(USER=oracle))))
VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Development
Time: 15-MAY-2007 01:20:31
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12538
TNS-12538: TNS:no such protocol adapter
ns secondary err code: 12560
nt main err code: 508
TNS-00508: No such protocol adapter
nt secondary err code: 0
nt OS err code: 0
***********************************************************************
Fatal NI connect error 12538, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IBM140)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=jforum)(CID=(PROGRAM=
)(HOST=IBM140)(USER=oracle))))
VERSION INFORMATION:
TNS for IBM/AIX RISC System/6000: Version 8.1.7.0.0 - Development
Time: 15-MAY-2007 01:20:31
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12538
TNS-12538: TNS:no such protocol adapter
ns secondary err code: 12560
nt main err code: 508
TNS-00508: No such protocol adapter
nt secondary err code: 0
nt OS err code: 0
2007-5-15 08:50
有有
$ netstat -an|grep tcp
tcp4 0 0 *.13 *.* LISTEN
tcp 0 0 *.21 *.* LISTEN
tcp 0 0 *.23 *.* LISTEN
tcp4 0 0 *.25 *.* LISTEN
tcp4 0 0 *.37 *.* LISTEN
tcp4 0 0 *.111 *.* LISTEN
tcp4 0 0 *.199 *.* LISTEN
tcp 0 0 *.512 *.* LISTEN
tcp 0 0 *.513 *.* LISTEN
tcp 0 0 *.514 *.* LISTEN
tcp4 0 0 *.523 *.* LISTEN
tcp4 0 0 *.543 *.* LISTEN
tcp4 0 0 *.544 *.* LISTEN
tcp4 0 0 172.16.10.140.199 172.16.10.140.42158 FIN_WAIT_2
tcp4 0 0 172.16.10.140.42158 172.16.10.140.199 CLOSE_WAIT
tcp4 0 0 *.50000 *.* LISTEN
tcp4 0 0 *.1334 *.* LISTEN
tcp4 0 0 *.1521 *.* LISTEN
tcp4 0 0 127.0.0.1.50000 127.0.0.1.42154 ESTABLISHED
tcp 0 0 127.0.0.1.42154 127.0.0.1.50000 ESTABLISHED
tcp4 0 0 127.0.0.1.49213 *.* LISTEN
tcp4 0 0 *.6000 *.* LISTEN
tcp4 0 0 *.6112 *.* LISTEN
tcp4 0 0 *.13 *.* LISTEN
tcp 0 0 *.21 *.* LISTEN
tcp 0 0 *.23 *.* LISTEN
tcp4 0 0 *.25 *.* LISTEN
tcp4 0 0 *.37 *.* LISTEN
tcp4 0 0 *.111 *.* LISTEN
tcp4 0 0 *.199 *.* LISTEN
tcp 0 0 *.512 *.* LISTEN
tcp 0 0 *.513 *.* LISTEN
tcp 0 0 *.514 *.* LISTEN
tcp4 0 0 *.523 *.* LISTEN
tcp4 0 0 *.543 *.* LISTEN
tcp4 0 0 *.544 *.* LISTEN
tcp4 0 0 172.16.10.140.199 172.16.10.140.42158 FIN_WAIT_2
tcp4 0 0 172.16.10.140.42158 172.16.10.140.199 CLOSE_WAIT
tcp4 0 0 *.50000 *.* LISTEN
tcp4 0 0 *.1334 *.* LISTEN
tcp4 0 0 *.1521 *.* LISTEN
tcp4 0 0 127.0.0.1.50000 127.0.0.1.42154 ESTABLISHED
tcp 0 0 127.0.0.1.42154 127.0.0.1.50000 ESTABLISHED
tcp4 0 0 127.0.0.1.49213 *.* LISTEN
tcp4 0 0 *.6000 *.* LISTEN
tcp4 0 0 *.6112 *.* LISTEN
2007-5-15 08:52
有有
1521端口都已经是起来的了，是不是这个版本的bug呢，我重装还是一样，不过由于我安装的方法都是一样的缘故
2007-5-15 08:57
有有
$ adapters
Installed Net8 Tranport Protocols are:
IPC
TCP/IP
BEQueath
SSL
RAW
Installed Net8 Naming Adapters are:
TNSnames.ora
OracleNames
LDAP
Hostname
Installed Oracle Advanced Security products are:
RC4 40-bit encryption algorithm
RC4 56-bit encryption algorithm
RC4 128-bit encryption algorithm
RC4 256-bit encryption algorithm
DES40 40-bit encryption algorithm
DES 56-bit encryption algorithm
3DES 112-bit encryption algorithm
3DES 168-bit encryption algorithm
MD5 crypto-checksumming algorithm
SHA-1 crypto-checksumming algorithm
$ adapters `which`
usage: adapters <executable>
$ adapters `which linstener`
usage: adapters <executable>
$ adapters `which lsnrctl`
Net Protocol Adapters linked with /oracle/app/oracle/product/8.1.7/bin/lsnrctl are:
BEQ
IPC
TCP/IP
RAW
SSL
Net Naming Adapters linked with /oracle/app/oracle/product/8.1.7/bin/lsnrctl are:
Oracle TNS Names (tnsnames.ora)
Oracle Names
LDAP
Oracle Advanced Security products linked with /oracle/app/oracle/product/8.1.7/bin/lsnrctl are:
RC4 40-bit encryption algorithm
RC4 56-bit encryption algorithm
RC4 128-bit encryption algorithm
RC4 256-bit encryption algorithm
DES40 40-bit encryption algorithm
DES 56-bit encryption algorithm
3DES 112-bit encryption algorithm
3DES 168-bit encryption algorithm
MD5 crypto-checksumming algorithm
SHA crypto-checksumming algorithm (for FIPS)
SHA-1 crypto-checksumming algorithm
$
Installed Net8 Tranport Protocols are:
IPC
TCP/IP
BEQueath
SSL
RAW
Installed Net8 Naming Adapters are:
TNSnames.ora
OracleNames
LDAP
Hostname
Installed Oracle Advanced Security products are:
RC4 40-bit encryption algorithm
RC4 56-bit encryption algorithm
RC4 128-bit encryption algorithm
RC4 256-bit encryption algorithm
DES40 40-bit encryption algorithm
DES 56-bit encryption algorithm
3DES 112-bit encryption algorithm
3DES 168-bit encryption algorithm
MD5 crypto-checksumming algorithm
SHA-1 crypto-checksumming algorithm
$ adapters `which`
usage: adapters <executable>
$ adapters `which linstener`
usage: adapters <executable>
$ adapters `which lsnrctl`
Net Protocol Adapters linked with /oracle/app/oracle/product/8.1.7/bin/lsnrctl are:
BEQ
IPC
TCP/IP
RAW
SSL
Net Naming Adapters linked with /oracle/app/oracle/product/8.1.7/bin/lsnrctl are:
Oracle TNS Names (tnsnames.ora)
Oracle Names
LDAP
Oracle Advanced Security products linked with /oracle/app/oracle/product/8.1.7/bin/lsnrctl are:
RC4 40-bit encryption algorithm
RC4 56-bit encryption algorithm
RC4 128-bit encryption algorithm
RC4 256-bit encryption algorithm
DES40 40-bit encryption algorithm
DES 56-bit encryption algorithm
3DES 112-bit encryption algorithm
3DES 168-bit encryption algorithm
MD5 crypto-checksumming algorithm
SHA crypto-checksumming algorithm (for FIPS)
SHA-1 crypto-checksumming algorithm
$
2007-5-15 09:00
有有
有点奇怪，我用一行命令方式登录就不行，再次输入用户名和密码就可以。。
$ sqlplus system@jforum
SQL*Plus: Release 8.1.7.0.0 - Production on Tue May 15 09:10:16 2007
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Enter password:
ERROR:
ORA-12538: TNS:no such protocol adapter
Enter user-name: system
Enter password:
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL>
$ sqlplus system@jforum
SQL*Plus: Release 8.1.7.0.0 - Production on Tue May 15 09:10:16 2007
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Enter password:
ERROR:
ORA-12538: TNS:no such protocol adapter
Enter user-name: system
Enter password:
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL>
2007-5-15 09:04
有有
但是net8的图形配置总是测试通不过，sqlplus直接连接也不行
2007-5-17 12:03
有有
解决了，是这个oracle版本的bug，换一个817的版本就OK了
2007-5-17 20:10
老农
KAO，有有还在玩古董:L
2007-5-18 00:32
有有
我要有570就不玩古董了:lol
页: [1]
Powered by Discuz! Archiver 5.5.0 © 2001-2006 Comsenz Inc.