Re: create database instance?

From: <cary_at_nams.net>
Date: Fri, 12 Mar 1999 15:19:16 GMT
Message-ID: <7cbb97$efg$1@nnrp1.dejanews.com>

Does tnsping use the SID info at all? It is my understanding that tnsping takes the SID alias, resolves it using the TNSNAMES.ORA file, obtains the connect info (apart from SID?), and simply hits the port to verify that the listener is listening. Perhaps the error indicates a disparity between the value of SID in the TNSNAMES.ORA file and the value of SID_NAME in the LISTENER.ORA file? I'm not certain about this; it's just a guess.

Cary

In article <7caril$rmo$1_at_tempo.univ-lyon1.fr>, slaforet_at_ifhamy.insa-lyon.fr (Sebastien LAFORET) wrote:
> hello.
> i use oracle v7.2, and tryed to create a database
>
> i made a file initABC.ora, put the good database name and parameters,
> then used the "instance manager" to create an instance.
>
> the instance has been created, it seems to be started.
>
> i created a sqlnet alias for the database..
>
> and... impossible to connect (error 12505... could not resolve SID given in
> connect descriptor)
>
> but tnsping works fine whith this alias..
>
> if somebody could explain me, i'd be glad to kiss his(her) feet ;-)
>
> --
> sebastien Laforet
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Mar 12 1999 - 09:19:16 CST