Re: listener errors

Please post your listener.ora and tnsnames.ora (or e-mail them privately) right now it looks like the Oracle home irectory is incorrectly missing from listener.ora, but there may be other problems. The error message is saying your listener.ora doesn't match your tnsnames.ora.
As there are working samples in %ORACLE_HOME%\net80\admin\sample, I'm not sure why your problem still persists.

Regards,

Sybrand Bakker, Oracle DBA

"Joe Stanton" <joe_at_bravenewsoftware.com> wrote in message news:wWa86.45455$y9.8876650_at_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 Sun Jan 14 2001 - 01:28:55 CST