| select count(*) error [message #67214] |
Wed, 11 February 2004 21:34 |
julio
Messages: 4
Registered: October 2002
|
Junior Member |
|
|
Hi, Sorry this is not the right forum.
I have this simple view in demo db (scott)
CREATE VIEW PRUEBA ( ENAME, SAL ) AS
(select ename, sal from emp
union all select job,sum(sal)
from emp group by job )
It works fine, but if I try this:
Select count(*) from prueba;
I get a TNS-12560 error and get disconnected from Oracle.
It started when we migrated from 8.1.5.0.0 to 8.1.7.4.1
This is the sqlnet.log
-------------------------------------------
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=C:ORA8ibinSQLPLUSW.EXE)(HOST=XXXX)(USER=xxxx))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production
Time: 12-FEB-2004 07:44:23
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS:error del adaptador de protocolo
ns secondary err code: 0
nt main err code: 530
TNS-00530: Error del adaptador de protocolo
nt secondary err code: 126
nt OS err code: 0
---------------------------------------------
It happens in all the views made in this way in our db.
Thanks
Julio
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
