| connection failure TNS-12203 [message #66776] |
Thu, 09 January 2003 11:27  |
Calvertk
Messages: 2
Registered: January 2003
|
Junior Member |
|
|
I can not connect to database, while other users can from different locations. I can Ping and TNSPing but I keep getting the same error. I have also tried Port 1521 with the same results. The local Network guys say things are fine on thier end. I looked through the trace file and a socket error is mentioned. Any Ideas?
nricall: Got routable address information.
nricall: Making call with following address information: (DESCRIPTION=(CONNECT_DATA=(SID=ipmsprod)(CID=(PROGRAM=C:IPMSv3BinWSSetup.exe)(HOST=WS-CAOC-IPMS)(USER=richmon.schumann)))(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=204.222.212.151)(Port=1601))).
nricdt: entry
nricdt: Calling with outgoing connect data: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=204.222.212.151)(Port=1601))(ADDRESS=(COMMUNITY=tcp.world)(PROTOCOL=TCP)(Host=204.222.212.151)(Port=1601)))(CONNECT_DATA=(SID=ipmsprod)(CID=(PROGRAM=C:IPMSv3BinWSSetup.exe)(HOST=WS-CAOC-IPMS)(USER=richmon.schumann)))).
nscall: entry
nscall: connecting...
nsc2addr: entry
nttbnd2addr: entry
nttbnd2addr: port resolved to 1601
nttbnd2addr: using host IP address: 204.222.212.151
nttbnd2addr: exit
nsc2addr: normal exit
nsopen: entry
nsmal: entry
nsmal: 400 bytes at 0x4841988
nsmal: normal exit
nsnainconn: entry
nsmal: entry
nsmal: 1664 bytes at 0x48349c8
nsmal: normal exit
snsbitini_ts: entry
snsbitini_ts: normal exit
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsnainconn: normal exit
nsopen: opening transport...
nttcon: entry
nttcon: toc = 1
nttcnp: entry
ntvlin: entry
ntvlin: exit
nttcnp: Validnode Table IN use; err 0x0
nttcnp: creating a socket.
nttcnp: exit
nttcni: entry
nttcni: trying to connect to socket 276.
ntt2err: entry
ntt2err: soc 276 error - operation=1, ntresnt[[0]]=511, ntresnt[[1]]=61, ntresnt[[2]]=0
ntt2err: exit
nttcni: exit
nttcon: exit
nserror: entry
nserror: nsres: id=0, op=65, ns=12541, ns2=12560; nt[[0]]=511, nt[[1]]=61, nt[[2]]=0
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsopen: unable to open transport
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
snsbittrm_ts: entry
snsbittrm_ts: normal exit
snsbitts_ts: entry
snsbitts_ts: acquired the bit
snsbitts_ts: normal exit
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsbfr: entry
nsbfr: normal exit
nsmfr: entry
nsmfr: 1664 bytes at 0x48349c8
nsmfr: normal exit
snsbitcl_ts: entry
snsbitcl_ts: normal exit
nsmfr: entry
nsmfr: 400 bytes at 0x4841988
nsmfr: normal exit
nsopen: error exit
nscall: error exit
nricdt: Call failed.
nricfg: entry
nricfg: exit
nricdt: Call made to destination.
nricdt: Processing address list so continuing.
nricdt: exit
nric2a: entry
nric2a: Getting local community information
nriglp: entry
nriglp: Looking for local addresses setup by nrigla
nriglp: No addresses in the preferred address list
nriglp: exit
nric2a: TNSNAV.ORA is not present. No local communities entry.
nrigla: entry
nrigla: Getting local address information
nrigla: Address list being processed.
nrigla: Processed all addresses in address list. Failed to make contact.
nrigla: exit
nric2a: exit
nricie: entry
nricie: Result descriptor: 12203,12541,511,61.
nricie: Result descriptor: 12224,12541,511,61 from Interchange:
nricie: Result descriptor: 12224,12541,511,61 from Interchange:
nricie: exit
nricall: Failed to copy originating community name value binding.
nricall: Exiting NRICALL with following termination result: -1.
nricall: exit
nioqper: error from nricall
nioqper: nr err code: 12203
nioqper: ns main err code: 12541
nioqper: ns (2) err code: 12560
nioqper: nt main err code: 511
nioqper: nt (2) err code: 61
nioqper: nt OS err code: 0
niqme: entry
niqme: reporting nr (1) error: (12203) as rdbms err (12203)
niqme: exit
niotns: Couldn't connect, returning 12203
snsbittrm_ts: entry
snsbittrm_ts: normal exit
snsbittrm_ts: entry
snsbittrm_ts: normal exit
nsbfrfl: entry
nsbfrfl: normal exit
nigtrm: Count in the NI global area is now 1
nigtrm: Count in the NL global area is now 1
|
|
|
|
|
|
|
|
|
|
| Re: connection failure TNS-12203 [message #67185 is a reply to message #66783] |
Wed, 21 January 2004 22:22  |
MAD
Messages: 2
Registered: April 2002
|
Junior Member |
|
|
ME TO HAVING THE SAME PROBLEM, THERE ARE MANY WAYS TO HANDEL IT LISTED BELOW
1:-FIRST REPLACE UR DATABASE WITH SOME OTHER DATABASE
2:-U BETTER NOT TO INDULGE UR SELF IN THIS DATABSE
3:-THIS POURLY MANAGED DATABASE IS JUST A TENSION
4:-MOVE TO PAPAER SYSTEM
TAKE CARE
|
|
|
|
| Re: connection failure TNS-12203 [message #67502 is a reply to message #66778] |
Tue, 31 August 2004 23:48 |
Ronju
Messages: 1
Registered: August 2004
|
Junior Member |
|
|
i am facing the same problem and here is my tnsname.ora file...................
IORA.HEAVEN =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 192.168.10.134)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVICE_NAME = iora.heaven)
)
)
help me please.............
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
