Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> listener errors
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: checkedReceived on Sat Jan 13 2001 - 23:37:32 CST