| Having a problem with tcpip connection [message #566193] |
Tue, 11 September 2012 13:21  |
dmarcus48
Messages: 44
Registered: May 2008
Location: Central NJ
|
Member |
|
|
The server has two oracle homes on it a 10.2.0.3 and a 11.2.0.1. I'm using the listener on the 11g side and the database is 10.2.0.3, I'm using port 1528 just so we can differentiate between old and new dbs. I've done the same thing on other servers and never had a problem until now.
I can connect to the database if I set the oracle_sid, no problem. But when I try to use the connect string (i.e. sqlplus scott/tiger@test), the connection just hangs for as long as I can wait until I do a control-c.
I've tried deleting and recreating the listener several times without any change using the network configuration assistant. I can do a tnsping with no problem, comes right back.
when I look in the listener.log I see this kind of entry:
11-SEP-2012 14:12:07 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=imcsa_oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186646784)) * status * 0
Tue Sep 11 14:12:26 2012
11-SEP-2012 14:12:21 * (CONNECT_DATA=(SERVICE_NAME=ORCQA04)(CID=(PROGRAM=d:\oracle\product\11.2.0\dbhome_1\bin\sqlplus.exe)(HOST=IMCNWORCQA21)(USER=imcsa_or acle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=40.151.4.122)(PORT=2638)) * establish * ORCQA04 * 0
The only thing I don't understand from the output is the port number, it says port=2638, I don't know where that came from.
Any idea?
TIA
Dave
|
|
|
|
|
|
|
|
|
|
| Re: Having a problem with tcpip connection [message #566211 is a reply to message #566198] |
Tue, 11 September 2012 17:37  |
dmarcus48
Messages: 44
Registered: May 2008
Location: Central NJ
|
Member |
|
|
First of all I want to thank the people who've replied to this post. I needed to walk away from this for a little while. I CAN do a ping of the server from home (logged into work), I CAN do a tnsping from my pc, if I try to connect to the database from my pc, I see an entry in the logfile of the listener, this tells me that the connection is getting to the server but not to the database. I've corrected all the full names, short names, that didn't do anything. I tried "sqlplus system@orcqa04" from home and I got this message on the listener.log, Tue Sep 11 18:31:15 2012
11-SEP-2012 18:31:10 * (CONNECT_DATA=(SERVICE_NAME=orcqa04)(CID=(PROGRAM=c:\oracle\product\11.2.0\client_1\bin\sqlplus.exe)(HOST=4606LT)(USER=xxxxxx))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.4.200.22)(PORT=49886)) * establish * orcqa04 * 0 I xx'd out my name, but 4606LT is my laptop's name.
I still don't know what it is but maybe this helps?
|
|
|
|
|
|
| Re: Having a problem with tcpip connection [message #566213 is a reply to message #566212] |
Tue, 11 September 2012 17:54 |
dmarcus48
Messages: 44
Registered: May 2008
Location: Central NJ
|
Member |
|
|
Well this happens even if I'm trying to connect on the server. So that's a connection that isn't going through the firewall, isn't it? This server was set up with the same image as other servers that do not have this issue.
In this case, the listener is an 11g listener and the database is 10g. I have other servers set up like this and there's no problem. In fact during the day I tried to create a 10g listener and got the same issue. In the 10g home, I have an ifile in the tnsnames.ora pointing back to the 11g home.
|
|
|
|
|
|
|
|
|
|
| Re: Having a problem with tcpip connection [message #566219 is a reply to message #566216] |
Tue, 11 September 2012 18:09 |
dmarcus48
Messages: 44
Registered: May 2008
Location: Central NJ
|
Member |
|
|
Here you go:
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:\Documents and Settings\davidmarcus>set oracle_sid=orcqa04
C:\Documents and Settings\davidmarcus>sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 11 19:09:02 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
SQL>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Having a problem with tcpip connection [message #566229 is a reply to message #566228] |
Tue, 11 September 2012 19:06 |
dmarcus48
Messages: 44
Registered: May 2008
Location: Central NJ
|
Member |
|
|
Found this trace file, does it mean anything to anyone?
Dump file d:\oracle\diag\rdbms\orcqa04\orcqa04\udump\orcqa04_ora_3444.trc
Tue Sep 11 19:58:02 2012
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows NT Version V5.2 Service Pack 2
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:3227M/4095M, Ph+PgF:6310M/8021M, VA:662M/2047M
Instance name: orcqa04
Redo thread mounted by this instance: 1
Oracle process number: 16
Windows thread id: 3444, image: ORACLE.EXE (SHAD)
opiino: Attach failed! error=-1 ifvp=00000000
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
