Re: How can I see my new database from other machines?

Mr. Jeremy Bettis wrote:
>
> I just created a new database with SID=OTTR. I can connect to it using
> the connect string 2:OTTR
>
> In tnsnames.ora I have an entry
> ottr.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = whittle)
> (Port = 1521)
> )
> (ADDRESS =
> (COMMUNITY = tcp.world)
> (PROTOCOL = TCP)
> (Host = whittle)
> (Port = 1526)
> )
> )
> (CONNECT_DATA = (SID = OTTR)
> )
> )
> But when I connect to the name ottr I get:
> ORA-12505: TNS:listener could not resolve SID given in connect descriptor

Entries in tnsnames.ora are for outbound connections. You also need an entry in your listener.ora to accept this inbound connection.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.