Hi,
listener.ora resides on server side where the service will "listen"
tnsnames.ora resides on client side
The client/server could resides on one box.
if you would like to connect to the database server you have to use the
service_name or TNS alias or SID as defined in
$ORACLE_HOME/network/admin/tnsnames.ora
regards,
priatna.
Wilkinson, Alex wrote:
> Anyone ? Curtis ?
>
> -aW
>
> 0n Sun, Jun 10, 2007 at 04:36:29PM +0800, Wilkinson, Alex wrote:
>
> >Hi all,
> >
> >Certain behavior in NB6.0-MP4 is confusing me and I really want to know
> >conceptually if I have the following correct.
> >
> >What I thought was meant to happen:
> >
> > * Within the NB GUI I am at the point of connecting to the required
> DBs.
> > * I am to login with an account that has SYSDBA privs
> > * I am to provide a TNS alias name
> >
> > Now, my issue is with respect to the TNS alias name. I was always
> under the
> > impression that the TNS alias name is derived directly from where it is
> > defined. In my case: $ORACLE_HOME/network/admin/listener.ora
> >
> > e.g. #grep HOST $ORACLE_HOME/network/admin/listener.ora
> > (ADDRESS = (PROTOCOL = TCP)(HOST =
> myoracleclient.dsto.defence.gov.au)(PORT = 1521))
> >
> >However, if I use myoracleclient.dsto.defence.gov.au as the TNS Alias in
> the NB
> >GUI, it just plain old does not work. And I will get an error stating:
> >
> > "ERR - Unable to connect to mydb
> > Error code 12514"
> >
> >However, if I use 1 out of the 4 $ORACLE_SID names it works!
> >
> >I am starting to suspect I should be getting the TNS Alias as such:
> >
> > #grep SERVICE_NAME $ORACLE_HOME/network/admin/tnsnames.ora
> >
> > (SERVICE_NAME = db1.dsto.defence.gov.au)
> > (SERVICE_NAME = db2.dsto.defence.gov.au)
> > (SERVICE_NAME = db3.dsto.defence.gov.au)
> > (SERVICE_NAME = db4.dsto.defence.gov.au)
> >
> >So in the end I have it working, but I really want to know conceptually
> where I
> >am meant to derive the TNS Alias from ? Anyone ?
> >
> >Cheers
> >
> > -aW
>
> IMPORTANT: This email remains the property of the Australian Defence
> Organisation and is subject to the jurisdiction of section 70 of the CRIMES
> ACT 1914. If you have received this email in error, you are requested to
> contact the sender and delete the email.
>
>
> _______________________________________________
> Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
>
>
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|