Re: Cannot access a new SID on a Workgroup-Server

You also have to update the LISTENER.ORA file to "listen" for connection requests to the new database. There should be a section of the listener file which list the SID's, add the new one here.

    (SID_LIST=

        (SID_DESC=
            (SID_NAME=SID1)
        )
    (SID_DESC=
            (SID_NAME=SID2)
        )

Dave

Pablo Picasso wrote:

> Hi,
>
> we have a Oracle 7.3.3 Workgroup Server running under NT 3.51.
> There are 3 Instances on the Server.
>
> Now, i added a new Instance to the Server by using the Instance
> Manager. After this i did the needed changes in the tnsnames.ora file.
>
> But when i give the connection string and try to connect i get the
> error
> 12505 cannot resolve SID given in the connect_Data string. But
> i did set the correct SID in this string.
>
> If i try to start the intelligent agent to use the enterprise manager
> i get the error 0020 device not found . (hope i translated it correct,
> because we use german version).
>
> Does anyone have any suggestion ??
>
> Thanks in Advance
>
> Oliver
>
> Email: oengst_at_cybernet-ag.net
Received on Thu Sep 17 1998 - 13:40:45 CDT