Re: Trouble connecting to Linux Oracle from Windows

Some more information. I have gone into the init.ora file and increased the memory in there. When I then do a ipcs, Oracle is now taking up 50 megs of shared memory, so it appears that the increase in shared memory has worked, but not helped so far.

Below you will see an extract of the listener.log file. YOu will see that the listener is talking to the windows machine ok.

TNSLSNR for Linux: Version 8.1.7.0.0 - Production on 27-AUG-2002 14:40:19

(c) Copyright 1998 Oracle Corporation. All rights reserved.

System parameter file is
/sdb3/app/oracle/product/8.1.7/network/admin/listener.ora Log messages written to
/sdb3/app/oracle/product/8.1.7/network/log/listener.log Trace information written to
/sdb3/app/oracle/product/8.1.7/network/trace/listener.trc Trace level is currently 0

Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Redhat)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC))) TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 27-AUG-2002 14:40:19 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=Redhat)(USER=- oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135294- 976)) * status * 0
27-AUG-2002 14:40:39 * (CONNECT_DATA=(SERVICE_NAME=bane.world)(CID=(PRO- GRAM=C:\oracle\ora81\bin\SQLPLUSW.EXE)(HOST=DBUCKINGHAM)(USER=dbuckingham)))

• (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.125)(PORT=1715)) * establish
  * bane.world * 0
  27-AUG-2002 14:40:44 * (CONNECT_DATA=(SERVICE_NAME=bane.world)(CID=(PROGRAM =C:\oracle\ora81\bin\SQLPLUSW.EXE)(HOST=DBUCKINGHAM)(USER=dbuckingham)))
• (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.125)(PORT=1716)) * establish
  * bane.world * 0
  27-AUG-2002 14:43:30 * service_register * bane * 0 27-AUG-2002 14:43:55 * (CONNECT_DATA=(SERVICE_NAME=bane.world)(CID=(PROGRAM =C:\oracle\ora81\bin\SQLPLUSW.EXE)(HOST=DBUCKINGHAM)(USER=dbuckingham)))
• (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.125)(PORT=1717)) * establish
  * bane.world * 0
  27-AUG-2002 14:44:02 * (CONNECT_DATA=(SERVICE_NAME=bane.world)(CID=(PROGRAM =C:\oracle\ora81\bin\SQLPLUSW.EXE)(HOST=DBUCKINGHAM)(USER=dbuckingham)))
• (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.125)(PORT=1718)) * establish
  * bane.world * 0
  27-AUG-2002 14:44:29 * ping * 0 27-AUG-2002 14:52:31 * service_died * bane * 12537 27-AUG-2002 14:52:34 * service_register * bane * 0 27-AUG-2002 14:53:36 * ping * 0 27-AUG-2002 14:53:54 * (CONNECT_DATA=(SERVICE_NAME=bane.world)(CID=(PROGRAM =C:\oracle\ora81\bin\SQLPLUSW.EXE)(HOST=DBUCKINGHAM)(USER=dbuckingham)))
• (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.125)(PORT=1722)) * establish
  * bane.world * 0
  27-AUG-2002 14:54:01 * (CONNECT_DATA=(SERVICE_NAME=bane.world)(CID=(PROGRAM =C:\oracle\ora81\bin\SQLPLUSW.EXE)(HOST=DBUCKINGHAM)(USER=dbuckingham)))
• (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.125)(PORT=1723)) * establish
  * bane.world * 0
  27-AUG-2002 14:54:07 * ping * 0 27-AUG-2002 14:59:46 * (CONNECT_DATA=(SERVICE_NAME=bane.world)(CID=(PROGRAM =C:\oracle\ora81\bin\SQLPLUSW.EXE)(HOST=DBUCKINGHAM)(USER=dbuckingham)))
• (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.125)(PORT=1729)) * establish
  * bane.world * 0
  27-AUG-2002 14:59:54 * (CONNECT_DATA=(SERVICE_NAME=bane.world)(CID=(PROGRAM =C:\oracle\ora81\bin\SQLPLUSW.EXE)(HOST=DBUCKINGHAM)(USER=dbuckingham)))
• (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.0.125)(PORT=1730)) * establish
  * bane.world * 0
  27-AUG-2002 15:20:40 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=Redhat)(USER=- oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=135294- 976)) * status * 0

I am not sure what all of this means, but should the listener be returning errors if they are found?

Dan.

--
Posted via http://dbforums.com