ITPUB论坛－专业的IT技术社区

标题: ORA-12560: TNS:協定介面程式錯誤 [打印本页]

作者: samuel_t 时间: 2004-1-7 08:51
标题: ORA-12560: TNS:協定介面程式錯誤
我用sqlplus怎麼也連不上我本地的數據庫,
錯誤號如題,trace file里的內容如下,用sqlplus可以連到其他遠程數據庫,tnsping也可以ping到本地數據庫,各位老大給看看,先謝了!
nsinherit: doing connect handshake...
nlpcaini: No process parameters set
nsinherit: inheriting the connection...
nsopen: opening transport...
sntpinherit: Attempting to make pipe \\.\PIPE\ORANTP5C8.648
sntpinherit: Listening on pipe \\.\PIPE\ORANTP5C8.648
sntpinherit: Successfully established pipe 196 to parent
nsopen: transport is open
nsnainit: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd
nsopen: global context check-in (to slot 0) complete
nscon: doing connect handshake...
nscon: got NSPTCN packet
nscon: discarding connect data (94 bytes)
nsinherit: connection inherited
nsinherit: connected
nsglldprm: Resolved "CONNECT_TIMEOUT_LISTENER" to: 10
nsglldprm: Resolved "STARTUP_WAIT_TIME_LISTENER" to: 0
nttbnd2addr: port resolved to 1521
nttbnd2addr: looking up IP addr for host: n-zb15
nttcnp: Validnode Table IN use; err 0x0
nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcnp: getting sockname
nsopen: transport is open
nsopen: global context check-in (to slot 1) complete
nsgllsn: completing partial addr: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=n-zb15)(PORT=1521)))
nsgllsn: Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=n-zb15.galaxy.company)(PORT=1521)))
nsopen: opening transport...
nsopen: transport is open
nsopen: global context check-in (to slot 2) complete
nscon: sending NSPTAC packet
nscon: sending 320 bytes connect data
nsdo: 320 bytes to NS buffer
nscon: doing connect handshake...
nscon: nsctxinf[0]=0xd, [1]=0xc
nsconbrok: asking transport to enable NTOBROKEN
nsnainconn: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xc
nsopen: opening transport...
nttcnp: Validnode Table IN use; err 0x0
nttcnp: getting sockname
nttcnr: waiting to accept a connection.
nttcnr: getting sockname
nttvlser: valid node check on incoming node 10.154.20.165
nttvlser: Accepted Entry: 10.154.20.165
nttcon: set TCP_NODELAY on 388
nsopen: transport is open
nsnainit: inf->nsinfflg[0]: 0xd inf->nsinfflg[1]: 0xd
nsopen: global context check-in (to slot 3) complete
nsanswer: deferring connect attempt; at stage 5
nscon: doing connect handshake...
nscon: got NSPTCN packet
nsevdansw: exit
nscon: sending NSPTAC packet
nscon: sending 379 bytes connect data
nsdo: 379 bytes to NS buffer
nscon: doing connect handshake...
nscon: nsctxinf[0]=0xd, [1]=0xc
nsconbrok: asking transport to enable NTOBROKEN
nsdo: 455 bytes to NS buffer
nstimarmed: no timer allocated
nsclose: closing transport
nsclose: global context check-out (from slot 3) complete
tnslsnr: connect string inst->lcxd[0]: (ADDRESS=(PROTOCOL=tcp)(HOST=n-zb15.galaxy.company)(PORT=1521))
nncpmlf_make_local_addrfile: construction of local names file failed
nncpmsf_make_sys_addrfile: system names file is d:\oracle\ora81\network\admin\tnsnames.ora

作者: husthxd 时间: 2004-1-7 10:33
如何连接的?
直接c:>sqlplus system/manager
可以吗?

作者: samuel_t 时间: 2004-1-7 12:26
就是用這種方法連接的
錯誤如前
我重裝了還是這樣,會不會是我的网絡協議出錯?可我用的是tcp啊
幫我啊!!!

作者: husthxd 时间: 2004-1-7 12:52
是不是装了多个数据库?
你的ORACLE_SID设置好没有?
确认你的oracle服务起来没有?

作者: samuel_t 时间: 2004-1-7 13:38
一個數據庫,不知你說的是哪個ORACLE_SID,我用的是WIN2000+ORACLE817,INIT.ORA,TNSNAME.ORA,LISTENER.ORA中的設置都沒有問題的,可就是不行,我重裝了,謝謝你了,husthxd

作者: husthxd 时间: 2004-1-7 14:20
一个数据库的话,oracle服务起来就没有问题了

btw:good luck!

欢迎光临 ITPUB论坛－专业的IT技术社区 (http://www.itpub.net/)