Re: create database instance?

From: Uwe Schneider <pi_at_nospam.richard-schneider.de>
Date: Fri, 12 Mar 1999 22:46:36 +0100
Message-ID: <36E98B3C.F95276DB@nospam.richard-schneider.de>

Hi,

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..
>

I had the same phenomenon with Ora 8.05 on Linux. The problem was resolved by writing the Oracle-SID in the SID_NAME= clause of listener.ora EXACTLY the same way as the running Oracle instance expected it. Case seems to me an issue when connecting to Oracle via Shm.

Uwe

--

Uwe Schneider       | Telefon +49 7251 / 82587
Karlsdorfer Str. 31 | Mail    pi_at_richard-schneider.de
76646 Bruchsal      | 

Linux - OS al dente! Received on Fri Mar 12 1999 - 15:46:36 CST