Re: MTS not workin ??

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 21 Aug 2003 06:13:52 +1000
Message-ID: <3f43d6d4$0$4190$afc38c87@news.optusnet.com.au>

Comments embedded.

"Ibrahim DOGAN" <ibrahim.dogan_at_lowes.com> wrote in message news:33634314.0308200654.1ff2efe0_at_posting.google.com...
>

So we now know (finally!) you have 8i on AIX.

> LISTENER
> ========
>
> irm2:/home/oracle/network/admin-> lsnrctl services
>
> LSNRCTL for IBM/AIX RISC System/6000:
> Version 8.1.7.0.0 - Production on 20-AUG-2003 10:45:33
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=irm2)(PORT=1521))
> Services Summary...
> PRACTICE has 1 service handler(s)
> DEDICATED SERVER established:1 refused:0
> LOCAL SERVER
> The command completed successfully

I think that somewhere along the line, you've got service names mixed up. Your listener is aware of a service called 'practice'. But your tnsnames has an alias for 'practice.lowes.com', although it then goes on to ask for a connection to just 'practice'.

What's the value for your service_names parameter?

And if that's not set explicitly, what's the value for db_name and db_domain?

You might like also to post the contents of the sqlnet.ora that is sitting on the server.

Regards
HJR Received on Wed Aug 20 2003 - 15:13:52 CDT