Re: Trouble connecting to Linux Oracle from Windows

dbuckingham wrote:

> Have set up 8.1.7 on redhat and I am trying to connect to the database
> from a windows machine, but so far i am unable to.
>
> Parameter file for windows and linux is as follows:
>
> bane =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY=TCP.WORLD)
> (PROTOCOL = TCP)
> (HOST = 10.0.0.30)
> (PORT = 1521)
> )
> (ADDRESS =
> (COMMUNITY=TCP.WORLD)
> (PROTOCOL = TCP)
> (HOST = 10.0.0.30)
> (PORT = 1526)
> )
> )
>
> (CONNECT_DATA = (SERVICE_NAME = bane.world)
> )
> )
>
> Have tried using SID instead of SERVICE_NAME and also substituting the
> IP address with the actual Server Name.
>
> The Listener is setup on the Linux machine as follows:
>
> # Name of listener and addresses to listen on
> LISTENER =
> ( ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL=tcp)
> (HOST=Redhat)
> (PORT=1521)
>
> )
> (ADDRESS =
> (PROTOCOL=ipc)
> (KEY=EXTPROC)
>
> )
> )
>
> # List of services served by this listener
> SID_LIST_LISTENER=
> (SID_LIST=
> (SID_DESC=
> (SID_NAME=bane)
> (ORACLE_HOME=/sdb3/app/product/8.1.7)
> )
> )
>
> # Start of configuration parameters.
> TRACE_LEVEL_LISTENER=OFF
> TRACE_FILE_LISTENER = "listener"
> LOG_FILE_LISTENER = "listener"
> CONNECT_TIMEOUT_LISTENER = 10
> STOP_LISTENER = YES
> DBA_GROUP = dba
>
> When I try connecting from SQL Plus from windows I get the following
> error at the moment:
>
> ORA - 03113: end of file on communication channel.
>
> How ever i am able to do a TNSPING bane and it pins ok without an issue.
>
> Anyone got any ideas as to why this is happening?
>
> Regards
>
> Dan.
>
> --
> Posted via http://dbforums.com

This is way too easy. ORA-03113 on a UNIX machine means you didn't read the installation documents before putting the CD in the machine and running the installation program.

Go back and read the installation instructions, pay special attention to semaphores and shared memory. If after installing correctly you still are having problems let us know.

Daniel Morgan Received on Mon Aug 26 2002 - 11:07:08 CDT