I don't think you need to create more than one database to do what you
require, one database can contain many schema's (in Oracle a user and schema
are synonomous)
Sybrand Bakker wrote in message
<930761649.28154.0.pluto.d4ee154e_at_news.demon.nl>...
>Hi Julian,
>The error message you are getting is the result of an incorrect
listener.ora
>on the server.
>Net Easy Config should generate sqlnet.ora, tnsnames.ora and listener.ora.
>All files are necessary on the server (%ORACLE_HOME%\net8\admin), the first
>two on every client, in the same directory.
>Please be aware you don't have one file with multiple databases in Oracle.
>Each database conists of several files and is being managed by an instance,
>a set of processes. It will be impossible to create MANY databases on a
>single server, especially if that's NT. Two databases on a server with 256
>Mb RAM is possible, wouldn't advise to create more.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
>
>
>
>
>Julian Cowking <jcowking_at_hrmsoftware.com> wrote in message
>news:7ldb19$rev$1_at_starburst.uk.insnet.net...
>> Hi there,
>>
>> This URGENT since I have just got my hands on a copy of Oracle 8.0.5.0.0
>> (for NT) and need to persuade my manager that we should buy it.
>>
>> Now, although i have loads of experience with SQL Server my Oracle
>knowledge
>> is sparse to say the least.
>> I want to be able to create many databases on my Oracle Server to hold my
>> differing releases of products.
>> So, I followed the manual's instructions on how to create a new database
>and
>> everything worked fine. So, I have a database with SID XXXX now (with NT
>> services aswell and catalog.sql and catproc.sql ran successfully)
>>
>> Next step is to connect to it (using Net8 Easy Config).
>> However I get the error message 12505 ORA-12505 TNS:Listener could not
>> resolve SID given in connect descriptor.
>>
>> What am I doing wrong? How do I connect to the non-default database?
>>
>> Also, when I have all these databases setup I will need to connect to a
>> specified database using ADO and a datasource. How does the datasource
>> distinguish between databases (i only get a server name input to fill in
>> when constructing the DSN)
>>
>> Thanks for your help - i need it!
>>
>>
>> Julian
>>
>>
>>
>>
>
>
Received on Sat Jul 03 1999 - 08:26:41 CDT
