Re: Newbie - easy question but URGENT!

Hi Julian,
Ensure that a service called 'TNSLISTENER80' is started when NT starts up.You can check this in the Control Panel-->Services Menu.

Also Check $ORACLE_HOME/Net80/admin/listener.ora and tnsnames.ora files for Listener, Connect String,Port, Hostnames etc and make sure that the Listener is listening to the Database XXXX on port like 1521 or 1526

Then from Prompt
>lsnrctl start

should start the Listener and will show the Database name as it's services.. Do a > lsnrctl status
anytime to find out the status of the default Listener 'listener'

-Thiru

Julian Cowking wrote:

> 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 Wed Jun 30 1999 - 12:43:08 CDT