郁闷的TNS-12560
今天碰到一件比较蹊跷郁闷的事情，操作系统装好，数据库装好，并升级至10.2.0.4。主机版本为
[29-11月-2010 15:48:39:392] nam_gbp: Parameter not found
[29-11月-2010 15:48:39:392] nau_gparams: Using default value "FALSE"
[29-11月-2010 15:48:39:392] nau_gslf: entry
[29-11月-2010 15:48:39:392] nam_gic: entry
[29-11月-2010 15:48:39:392] nam_gic: Counting # of items in "sqlnet.authentication_services" parameter
[29-11月-2010 15:48:39:392] nam_gic: Found 1 items
[29-11月-2010 15:48:39:392] nam_gic: exit
[29-11月-2010 15:48:39:392] nam_gnsp: Reading parameter "sqlnet.authentication_services" from parameter file
[29-11月-2010 15:48:39:392] nam_gnsp: Found value "NTS"
[29-11月-2010 15:48:39:392] nauss_set_state: entry
[29-11月-2010 15:48:39:392] nauss_set_state: exit
[29-11月-2010 15:48:39:392] nau_gslf: exit
[29-11月-2010 15:48:39:392] nau_gparams: exit
[29-11月-2010 15:48:39:392] nau_gin: exit
[29-11月-2010 15:48:39:392] nagblini: exit
[29-11月-2010 15:48:39:392] na_saveprot: entry
[29-11月-2010 15:48:39:392] na_saveprot: exit
[29-11月-2010 15:48:39:392] nacomin: entry
[29-11月-2010 15:48:39:392] nas_init: entry
[29-11月-2010 15:48:39:392] nas_init: exit
[29-11月-2010 15:48:39:392] nau_ini: entry
[29-11月-2010 15:48:39:392] naugcp_get_connect_parameters: entry
[29-11月-2010 15:48:39:392] nauss_set_state: entry
[29-11月-2010 15:48:39:392] nauss_set_state: exit
[29-11月-2010 15:48:39:392] naugcp_get_connect_parameters: exit
[29-11月-2010 15:48:39:392] nau_gettab: entry
[29-11月-2010 15:48:39:392] nau_gettab: using authentication adapter table "nautab"
[29-11月-2010 15:48:39:392] nau_gettab: nautab contains the following services:
[29-11月-2010 15:48:39:392] nau_gettab: KERBEROS5
[29-11月-2010 15:48:39:393] nau_gettab: NTS
[29-11月-2010 15:48:39:393] nau_gettab: RADIUS
[29-11月-2010 15:48:39:393] nau_gettab: exit
[29-11月-2010 15:48:39:393] nau_sini: entry
[29-11月-2010 15:48:39:393] nau_sini: exit
[29-11月-2010 15:48:39:393] nau_ini: connection type: "standard"
[29-11月-2010 15:48:39:393] nau_ini: exit
[29-11月-2010 15:48:39:393] naeeinit: entry
[29-11月-2010 15:48:39:393] nam_gbp: Reading parameter "SQLNET.FIPS_140" from parameter file
[29-11月-2010 15:48:39:393] nam_gbp: Parameter not found
[29-11月-2010 15:48:39:393] nam_gnsp: Reading parameter "SQLNET.ENCRYPTION_CLIENT" from parameter file
[29-11月-2010 15:48:39:393] nam_gnsp: Parameter not found
[29-11月-2010 15:48:39:393] naequad: Using default value "ACCEPTED"
[29-11月-2010 15:48:39:393] nam_gic: entry
[29-11月-2010 15:48:39:393] nam_gic: Counting # of items in "SQLNET.ENCRYPTION_TYPES_CLIENT" parameter
[29-11月-2010 15:48:39:393] nam_gic: Parameter not found
[29-11月-2010 15:48:39:393] nam_gic: exit
[29-11月-2010 15:48:39:393] naesno: Using default value "all available algorithms"
[29-11月-2010 15:48:39:393] naeshow: entry
[29-11月-2010 15:48:39:393] naeshow: These are the encryption algorithms that the client will accept:
[29-11月-2010 15:48:39:393] naeshow: Choice 0: no algorithm; encryption inactive
[29-11月-2010 15:48:39:393] naeshow: Choice 1: 'AES256' (ID 17)
[29-11月-2010 15:48:39:393] naeshow: Choice 2: 'RC4_256' (ID 6)
[29-11月-2010 15:48:39:393] naeshow: Choice 3: 'AES192' (ID 16)
[29-11月-2010 15:48:39:393] naeshow: Choice 4: '3DES168' (ID 12)
[29-11月-2010 15:48:39:393] naeshow: Choice 5: 'AES128' (ID 15)
[29-11月-2010 15:48:39:393] naeshow: Choice 6: 'RC4_128' (ID 10)
[29-11月-2010 15:48:39:393] naeshow: Choice 7: '3DES112' (ID 11)
[29-11月-2010 15:48:39:393] naeshow: Choice 8: 'RC4_56' (ID
[29-11月-2010 15:48:39:393] naeshow: Choice 9: 'DES' (ID 2)
[29-11月-2010 15:48:39:393] naeshow: Choice 10: 'RC4_40' (ID 1)
[29-11月-2010 15:48:39:393] naeshow: Choice 11: 'DES40' (ID 3)
[29-11月-2010 15:48:39:393] naeshow: exit
[29-11月-2010 15:48:39:394] naeeinit: exit
[29-11月-2010 15:48:39:394] naecinit: entry
[29-11月-2010 15:48:39:394] nam_gnsp: Reading parameter "SQLNET.CRYPTO_CHECKSUM_CLIENT" from parameter file
[29-11月-2010 15:48:39:394] nam_gnsp: Parameter not found
[29-11月-2010 15:48:39:394] naequad: Using default value "ACCEPTED"
[29-11月-2010 15:48:39:394] nam_gic: entry
[29-11月-2010 15:48:39:394] nam_gic: Counting # of items in "SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT" parameter
[29-11月-2010 15:48:39:394] nam_gic: Parameter not found
[29-11月-2010 15:48:39:394] nam_gic: exit
[29-11月-2010 15:48:39:394] naesno: Using default value "all available algorithms"
[29-11月-2010 15:48:39:394] naeshow: entry
[29-11月-2010 15:48:39:394] naeshow: These are the checksumming algorithms that the client will accept:
[29-11月-2010 15:48:39:394] naeshow: Choice 0: no algorithm; checksumming inactive
[29-11月-2010 15:48:39:394] naeshow: Choice 1: 'SHA1' (ID 3)
[29-11月-2010 15:48:39:394] naeshow: Choice 2: 'MD5' (ID 1)
[29-11月-2010 15:48:39:394] naeshow: exit
[29-11月-2010 15:48:39:394] naecinit: exit
[29-11月-2010 15:48:39:394] nainit: exit
[29-11月-2010 15:48:39:394] nagetctxinfo: entry
[29-11月-2010 15:48:39:394] nagetctxinfo: exit
[29-11月-2010 15:48:39:394] nsnainit: NS Connection version: 313
[29-11月-2010 15:48:39:394] nsnainit: inf->nsinfflg[0]: 0x61 inf->nsinfflg[1]: 0x61
[29-11月-2010 15:48:39:394] nsnainit: "or" info flags: 0x61Translations follow:
native service(s) is (are) wanted

[29-11月-2010 15:48:39:394] nsnainit: "or" info flags: 0x61Translations follow:
native service(s) is (are) wanted
"and" info flags: 0x61Translations follow:
native service(s) is (are) wanted

[29-11月-2010 15:48:39:394] nsnainit: normal exit
[29-11月-2010 15:48:39:394] nsopen: global context check-in (to slot 0) complete
[29-11月-2010 15:48:39:394] nsopen: lcl[0]=0xf4ffefff, lcl[1]=0x102000, gbl[0]=0xfabf, gbl[1]=0x0, tdu=32767, sdu=2048
[29-11月-2010 15:48:39:394] nsdo: entry
[29-11月-2010 15:48:39:395] nsdo: cid=0, opcode=65, *bl=0, *what=0, uflgs=0x0, cflgs=0x2
[29-11月-2010 15:48:39:395] nsdo: rank=64, nsctxrnk=0
[29-11月-2010 15:48:39:395] nsdo: nsctx: state=7, flg=0x4001, mvd=0
[29-11月-2010 15:48:39:395] nsbal: entry
[29-11月-2010 15:48:39:395] nsbgetfl: entry
[29-11月-2010 15:48:39:395] nsbgetfl: normal exit
[29-11月-2010 15:48:39:395] nsmal: entry
[29-11月-2010 15:48:39:395] nsmal: 84 bytes at 0x767e40
[29-11月-2010 15:48:39:395] nsmal: normal exit
[29-11月-2010 15:48:39:395] nsbal: normal exit
[29-11月-2010 15:48:39:395] nsbal: entry
[29-11月-2010 15:48:39:395] nsbgetfl: entry
[29-11月-2010 15:48:39:395] nsbgetfl: normal exit
[29-11月-2010 15:48:39:395] nsmal: entry
[29-11月-2010 15:48:39:395] nsmal: 84 bytes at 0x7686c0
[29-11月-2010 15:48:39:395] nsmal: normal exit
[29-11月-2010 15:48:39:395] nsbal: normal exit
[29-11月-2010 15:48:39:395] nsdo: nsctxrnk=0
[29-11月-2010 15:48:39:395] nsdo: normal exit
[29-11月-2010 15:48:39:395] nsopen: normal exit
[29-11月-2010 15:48:39:395] nsdo: entry
[29-11月-2010 15:48:39:395] nsdo: cid=0, opcode=67, *bl=210, *what=8, uflgs=0x0, cflgs=0x3
[29-11月-2010 15:48:39:395] nsdo: rank=64, nsctxrnk=0
[29-11月-2010 15:48:39:395] nsdo: nsctx: state=14, flg=0x4005, mvd=0
[29-11月-2010 15:48:39:395] nsdo: gtn=10, gtc=10, ptn=10, ptc=2011
[29-11月-2010 15:48:39:395] nscon: entry
[29-11月-2010 15:48:39:395] nscon: doing connect handshake...
[29-11月-2010 15:48:39:396] nscon: sending NSPTCN packet
[29-11月-2010 15:48:39:396] nspsend: entry
[29-11月-2010 15:48:39:396] nspsend: plen=268, type=1
[29-11月-2010 15:48:39:396] nttwr: entry
[29-11月-2010 15:48:39:396] nttwr: socket 300 had bytes written=268
[29-11月-2010 15:48:39:396] nttwr: exit
[29-11月-2010 15:48:39:396] nspsend: packet dump
[29-11月-2010 15:48:39:396] nspsend: 01 0C 00 00 01 00 00 00 |........|
[29-11月-2010 15:48:39:396] nspsend: 01 39 01 2C 00 00 08 00 |.9.,....|
[29-11月-2010 15:48:39:396] nspsend: 7F FF C6 0E 00 00 01 00 |........|
[29-11月-2010 15:48:39:396] nspsend: 00 D2 00 3A 00 00 02 00 |...:....|
[29-11月-2010 15:48:39:396] nspsend: 61 61 00 00 00 00 00 00 |aa......|
[29-11月-2010 15:48:39:396] nspsend: 00 00 00 00 00 00 00 00 |........|
[29-11月-2010 15:48:39:396] nspsend: 00 00 00 00 00 00 00 00 |........|
[29-11月-2010 15:48:39:396] nspsend: 00 00 28 44 45 53 43 52 |..(DESCR|
[29-11月-2010 15:48:39:396] nspsend: 49 50 54 49 4F 4E 3D 28 |IPTION=(|
[29-11月-2010 15:48:39:396] nspsend: 41 44 44 52 45 53 53 3D |ADDRESS=|
[29-11月-2010 15:48:39:396] nspsend: 28 50 52 4F 54 4F 43 4F |(PROTOCO|
[29-11月-2010 15:48:39:396] nspsend: 4C 3D 54 43 50 29 28 48 |L=TCP)(H|
[29-11月-2010 15:48:39:396] nspsend: 6F 73 74 3D 31 37 32 2E |ost=172.|
[29-11月-2010 15:48:39:396] nspsend: 31 36 2E 34 2E 31 37 33 |16.4.173|
[29-11月-2010 15:48:39:396] nspsend: 29 28 50 6F 72 74 3D 31 |)(Port=1|
[29-11月-2010 15:48:39:396] nspsend: 35 32 31 29 29 28 43 4F |521))(CO|
[29-11月-2010 15:48:39:396] nspsend: 4E 4E 45 43 54 5F 44 41 |NNECT_DA|
[29-11月-2010 15:48:39:396] nspsend: 54 41 3D 28 53 45 52 56 |TA=(SERV|
[29-11月-2010 15:48:39:396] nspsend: 45 52 3D 44 45 44 49 43 |ER=DEDIC|
[29-11月-2010 15:48:39:396] nspsend: 41 54 45 44 29 28 53 49 |ATED)(SI|
[29-11月-2010 15:48:39:396] nspsend: 44 3D 6F 72 63 6C 29 28 |D=orcl)(|
[29-11月-2010 15:48:39:396] nspsend: 43 49 44 3D 28 50 52 4F |CID=(PRO|
[29-11月-2010 15:48:39:396] nspsend: 47 52 41 4D 3D 44 3A 5C |GRAM=D:\|
[29-11月-2010 15:48:39:396] nspsend: 6F 72 61 63 6C 65 5C 70 |oracle\p|
[29-11月-2010 15:48:39:396] nspsend: 72 6F 64 75 63 74 5C 31 |roduct\1|
[29-11月-2010 15:48:39:396] nspsend: 30 2E 32 2E 30 5C 64 62 |0.2.0\db|
[29-11月-2010 15:48:39:397] nspsend: 5F 31 5C 62 69 6E 5C 73 |_1\bin\s|
[29-11月-2010 15:48:39:397] nspsend: 71 6C 70 6C 75 73 2E 65 |qlplus.e|
[29-11月-2010 15:48:39:397] nspsend: 78 65 29 28 48 4F 53 54 |xe)(HOST|
[29-11月-2010 15:48:39:397] nspsend: 3D 44 42 43 4F 4F 4B 45 |=DBCOOKE|
[29-11月-2010 15:48:39:397] nspsend: 52 2D 50 43 29 28 55 53 |R-PC)(US|
[29-11月-2010 15:48:39:397] nspsend: 45 52 3D 41 64 6D 69 6E |ER=Admin|
[29-11月-2010 15:48:39:397] nspsend: 69 73 74 72 61 74 6F 72 |istrator|
[29-11月-2010 15:48:39:397] nspsend: 29 29 29 29 |)))) |
[29-11月-2010 15:48:39:397] nspsend: 268 bytes to transport
[29-11月-2010 15:48:39:397] nspsend: normal exit
[29-11月-2010 15:48:39:397] nscon: exit (0)
[29-11月-2010 15:48:39:397] nsdo: nsctxrnk=0
[29-11月-2010 15:48:39:397] nsdo: normal exit
[29-11月-2010 15:48:39:397] nsdo: entry
[29-11月-2010 15:48:39:397] nsdo: cid=0, opcode=68, *bl=512, *what=9, uflgs=0x0, cflgs=0x3
[29-11月-2010 15:48:39:397] nsdo: rank=64, nsctxrnk=0
[29-11月-2010 15:48:39:397] nsdo: nsctx: state=2, flg=0x4005, mvd=0
[29-11月-2010 15:48:39:397] nsdo: gtn=10, gtc=10, ptn=10, ptc=2011
[29-11月-2010 15:48:39:397] nscon: entry
[29-11月-2010 15:48:39:397] nscon: recving a packet
[29-11月-2010 15:48:39:397] nsprecv: entry
[29-11月-2010 15:48:39:397] nsprecv: reading from transport...
[29-11月-2010 15:48:39:397] nttrd: entry
最后没办法，重装Oracle软件，之后竟然神奇的好了。。。。只有一个解释，之前装数据库的同事RP太差，呵呵