Re: How can I create instances ?

From: cpbbb <cpbrady_at_frontiernet.net>
Date: 20 May 1998 23:59:10 GMT
Message-ID: <6jvqoe$r0q$1@node17.cwnet.frontiernet.net>

You need to configure the TNSNAMES.ORA file, on both the server and the client, to recognize the new SID.
If you're running Win95 clients you'll find the file in:

    For SQL*Net 2.x ---- c:\ORAWIN95\network\admin     For NET8 ---- c:\ORAWIN95\NET80\admin If you still need 16 bit ODBC or apps they are in:

                                        c:\orawin\network\admin.

There should be a \sample subdirectory as well so you can use it as a template.

Good luck!

Craig Brady
Talisman Technologies Inc
Specializing in Oracle Data Warehousing/VLDB's

<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>

Geir Rastad wrote in message <3562D3C3.134C60F2_at_provida.no>...
>I've used the Instance Manager, added a proper instance, loaded it with
>data.
>
>When I use isql on the server (with bequeth protocol) I'm able to access
>all instances, but
>over TCP/IP I get: TNS Listener could not find SID XXX.
>
>What have I done wrong ?
>
>TIA
>
> - Geir Rastad
>
Received on Wed May 20 1998 - 18:59:10 CDT