Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> listener errors

listener errors

From: Joe Stanton <joe_at_bravenewsoftware.com>
Date: Sun, 14 Jan 2001 05:37:32 GMT
Message-ID: <wWa86.45455$y9.8876650@typhoon.we.rr.com>

ORA-12505: TNS:listener could not resolve SID given in connector descriptor

I am a newbie to Oracle installation and setup (been using Oracle for some time in the role of VB programmer connecting via ODBC).

Recently I installed Oracle 8.0.4 (patched to 8.0.4.4 - and yes, I know it is desupported, but that is what my clients use) to one of my faster NT Workstations - and have had nothing but trouble/failure getting a remote computer to connect to it.

As a control I have setup a BEQ service on the server - which works fine - so I know that my database and user/permissions are setup correctly.

The service I want to connect with is a TCP one with all parameters as close to the BEQ one as possible. The listener apparently has settings that should match up (I presume the port numbers should be identical between the listener and the service).

I have spent a lot of time searching with AlataVista and Google for help, reading the provided documentation, and I have realized that the best place to get assistance is right here.

Some basic understanding of the process may be my whole issue. Does the server need to have a TCP service that the remote computers access or does the remote computer setup a service through which it access the server? Or both?

If there is good sample somewhere online please point me at it so I waste nobody's time. If not, I appreciate your time in responding.

TIA
Joe

Here are the settings from the listener on the server:

    Listener nane: LISTENER

        General Parameters, General tab:
            Startup wait time: 0
            Connect timeout: 10
            Options:
                Save configuration on shutdown: clear
                Register services with Oracle names: clear
                SNMP contact information: greyed out and blank
    General Parameters, Logging and tracing:
        Logging enabled
        Tracing disabled
    General Parameters, Authentication:
        Do not require a password for listener operations

    Listening locations, address tabs 1,2,3:
        IPC - I have no idea what these do it was there already
    Listening locations, address tab 4:
        Protocol: TCP
        Host: MYSERVER
        Port: 1521

    Database services, Database 1 tab:
        Global database name: TEST
        Oracle home directory: {blank}
        SID: ORC1
        Use pre-spawned dedicated servers.  Configured:
            TCPIP: 1,0        (number, timeout)
            SPX: 0,0
            Named pipes: 0,0
            IPC: 0,0
            Maximum prespawned servers: 2

    Other services, Service 1:
        I am not sure if this matters, most is blank and it was defaulted

    Also I am not using Oracle Names Servers

Here are the settings from the service on the remote computer:

    Service name: CONNECTVIATCP.WORLD

        Protocol: TCP/IP
        Host name: MYSERVER
        Port number: 1521
        SID name: ORC1
    Advanced:
        Global database name: TEST
        Data unit: {default}
        Source route: clear
        Dedicated server: checked
Received on Sat Jan 13 2001 - 23:37:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US