SEO

Hello !!

I've just installed Oracle 8.1.7 on W2k Pro
I've created 2 database Base1 & Base2
And I need to access to them using SQLPlus

But I keep having the following error code ORA 12541: TNS : No Listener

I dont understand .. the TNSListener service is running
It's configuration file "tnslistener.ora" is well formated
"tnsname.ora" is also well formated

Anyone has an idea ?

Thanks !

"Malderez Cédric" <cedric.malderez@answork.com> wrote in message
news:3f5df937$0$13301$626a54ce@news.free.fr...
> Hello !!
>
> I've just installed Oracle 8.1.7 on W2k Pro
> I've created 2 database Base1 & Base2
> And I need to access to them using SQLPlus
>
> But I keep having the following error code ORA 12541: TNS : No Listener
>
> I dont understand .. the TNSListener service is running
> It's configuration file "tnslistener.ora" is well formated
> "tnsname.ora" is also well formated
>
> Anyone has an idea ?
>
> Thanks !
>
>

The correct configuration file for TNSlistener is *listener.ora*, not
tnslistener.ora


--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

The only way to verify that your listener is running is to issue the
'lsnrctl status' command. I've noticed on Windows that there is a
problem where the service starts, yet the Oracle software is not
running, on occasion. So verify that the listener is in fact running.
Also verify that the listener is running on the port you are trying to
contact.

HTH,
Brian

"Malderez Cédric" wrote:
>
> Hello !!
>
> I've just installed Oracle 8.1.7 on W2k Pro
> I've created 2 database Base1 & Base2
> And I need to access to them using SQLPlus
>
> But I keep having the following error code ORA 12541: TNS : No Listener
>
> I dont understand .. the TNSListener service is running
> It's configuration file "tnslistener.ora" is well formated
> "tnsname.ora" is also well formated
>
> Anyone has an idea ?
>
> Thanks !

--
================================================== =================

Brian Peasland
dba@remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"

Are you doing tests while logged onto the server?

Are you doing tests while logged onto another machine/client-pc and does it
have the correct tnsnames.ora file?

Can you ping (using TCP/IP ping command) the server from the client-pc?

Can you tnsping the databases ? Of course, sqlplus is the real/ultimate test
if you have complete connectivity, but it could be useful info if you have
good test with tnsping and not good tests with sqlplus.

Do you have any other *.ora files in the directory where you store the
tnsnames.ora (other than listener.ora on the server)? Or, do you have any
*.ora files anywhere else on the client-pc or server?

Are you mistakenly pointing to another location for tnsnames.ora other than
the default? Do you have any TNS_ADMIN entries in the registry? Do you have
any environment variable named TNS_ADMIN? Is your tnsnames.ora stored in the
default location (ORACLE_HOME\network\admin)?

Include the listener.ora and tnsnames.ora files (and other *.ora files) in
your reply if possible. If the tnsnames.ora is large, then maybe just
cut/paste the databases you are having problems with.

-
"Malderez Cédric" <cedric.malderez@answork.com> wrote in message
news:3f5df937$0$13301$626a54ce@news.free.fr...
> Hello !!
>
> I've just installed Oracle 8.1.7 on W2k Pro
> I've created 2 database Base1 & Base2
> And I need to access to them using SQLPlus
>
> But I keep having the following error code ORA 12541: TNS : No Listener
>
> I dont understand .. the TNSListener service is running
> It's configuration file "tnslistener.ora" is well formated
> "tnsname.ora" is also well formated
>
> Anyone has an idea ?
>
> Thanks !
>
>

> The correct configuration file for TNSlistener is *listener.ora*, not
> tnslistener.ora

You're right ... that was just a mistake

> The only way to verify that your listener is running is to issue the
> 'lsnrctl status' command. I've noticed on Windows that there is a
> problem where the service starts, yet the Oracle software is not
> running, on occasion. So verify that the listener is in fact running.
> Also verify that the listener is running on the port you are trying to
> contact.

Actually the service is running
The "lsnrctl status" command line provides the following dump (sorry it's in
french ):
For each database (BASE1 & BASE2) I have two service manager

>D:\oracle\ora81\bin>lsnrctl status
>LSNRCTL for 32-bit Windows: Version 8.1.7.0.0 - Production on 10-SEP-2003
08:46:27
>(c) Copyright 1998 Oracle Corporation. All rights reserved.
>Connexion Ó (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0) ))STATUT du
LISTENER
>------------------------
>Alias LISTENER
>Version TNSLSNR for 32-bit Windows: Version 8.1.7.0.0 -
Production
>Date de départ 09-SEP-2003 17:01:06
>Durée d'activité 0 jours 15 heures 45 min. 21 sec
>Niveau de trace off
>Sécurité OFF
>SNMP OFF
>Fichier de paramètres du listener
D:\oracle\ora81\network\admin\listener.ora
>Fichier journal listener
D:\oracle\ora81\network\log\listener.log
>Récapitulatif services...
> BASE1 \ 1 gestionnaires de services
> BASE1 \ 2 gestionnaires de services
> PLSExtProc \ 1 gestionnaires de services
> BASE2 \ 1 gestionnaires de services
> BASE \ 2 gestionnaires de services
>La commande a réussi

> Are you doing tests while logged onto the server?
>
Yes, I'm using a local domain account with administrator rights

> Are you doing tests while logged onto another machine/client-pc and does
it
> have the correct tnsnames.ora file?
>
I've tried running the client on an other computer. Using the DBAStudio,
I've added BASE1 in the Database list.
I've never touch the tnsnames.ora file directly

> Can you ping (using TCP/IP ping command) the server from the client-pc?
>
Yes, the network is working well

> Can you tnsping the databases ? Of course, sqlplus is the real/ultimate
test
> if you have complete connectivity, but it could be useful info if you have
> good test with tnsping and not good tests with sqlplus.
>
I've tried the following command line "tnsping BASE1". It seems to be
working
Here is the dump:
> D:\oracle\ora81\bin>tnsping TSEDF
> TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on
10-SEP-2003 09:01:33
> (c) Copyright 1997 Oracle Corporation. All rights reserved.
> Attempting to contact
(ADDRESS=(PROTOCOL=TCP)(HOST=172.31.0.17)(PORT=152 1))
> OK (30 msec)

> Do you have any other *.ora files in the directory where you store the
> tnsnames.ora (other than listener.ora on the server)? Or, do you have any
> *.ora files anywhere else on the client-pc or server?
In the D:\oracle\ora81\network\admin I have the following files:
- listener.ora
- snmp_ro.ora
- snmp_rw.ora
- sqlnet.ora
- tnsnames.ora

> Are you mistakenly pointing to another location for tnsnames.ora other
than
> the default? Do you have any TNS_ADMIN entries in the registry? Do you
have
> any environment variable named TNS_ADMIN? Is your tnsnames.ora stored in
the
> default location (ORACLE_HOME\network\admin)?
>
I don't have any TNS_ADMIN env set
When I'v used DBAStudio in order to add a new database in the list, the
ORACLE_HOME\network\admin\tnsnames.ora was modified

> Include the listener.ora and tnsnames.ora files (and other *.ora files) in
> your reply if possible. If the tnsnames.ora is large, then maybe just
> cut/paste the databases you are having problems with.
>
Here is the listener.ora file
# LISTENER.ORA Network Configuration File:
D:\oracle\ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 2481))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = BASE1)
(ORACLE_HOME = D:\oracle\ora81)
(SID_NAME = BASE1)
)
(SID_DESC =
(GLOBAL_DBNAME = BASE2)
(ORACLE_HOME = D:\oracle\ora81)
(SID_NAME = BASE2)
)
)

And here is the tnsnames.ora file:
# TNSNAMES.ORA Network Configuration File:
D:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

BASE2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = BASE2)
(SERVER = DEDICATED)
)
)

BASE1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = BASE1)
(SERVER = DEDICATED)
)
)

####################################
# Date..........: Tue Sep 09 15:14:29 CEST 2003
####################################

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = BASE2)
(PRESENTATION = http://admin)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

Thanks for your help

I am in a hurry right now, but I seem to recall the SERVER=DEDICATED might
be a problem.

Edit and remove that line from the tnsnames.ora and try again.

--
"Malderez Cédric" <cedric.malderez@answork.com> wrote in message
news:3f5ed59a$0$13273$626a54ce@news.free.fr...
> > Are you doing tests while logged onto the server?
> >
> Yes, I'm using a local domain account with administrator rights
>
> > Are you doing tests while logged onto another machine/client-pc and does
> it
> > have the correct tnsnames.ora file?
> >
> I've tried running the client on an other computer. Using the DBAStudio,
> I've added BASE1 in the Database list.
> I've never touch the tnsnames.ora file directly
>
> > Can you ping (using TCP/IP ping command) the server from the client-pc?
> >
> Yes, the network is working well
>
> > Can you tnsping the databases ? Of course, sqlplus is the real/ultimate
> test
> > if you have complete connectivity, but it could be useful info if you
have
> > good test with tnsping and not good tests with sqlplus.
> >
> I've tried the following command line "tnsping BASE1". It seems to be
> working
> Here is the dump:
> > D:\oracle\ora81\bin>tnsping TSEDF
> > TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on
> 10-SEP-2003 09:01:33
> > (c) Copyright 1997 Oracle Corporation. All rights reserved.
> > Attempting to contact
> (ADDRESS=(PROTOCOL=TCP)(HOST=172.31.0.17)(PORT=152 1))
> > OK (30 msec)
>
> > Do you have any other *.ora files in the directory where you store the
> > tnsnames.ora (other than listener.ora on the server)? Or, do you have
any
> > *.ora files anywhere else on the client-pc or server?
> In the D:\oracle\ora81\network\admin I have the following files:
> - listener.ora
> - snmp_ro.ora
> - snmp_rw.ora
> - sqlnet.ora
> - tnsnames.ora
>
> > Are you mistakenly pointing to another location for tnsnames.ora other
> than
> > the default? Do you have any TNS_ADMIN entries in the registry? Do you
> have
> > any environment variable named TNS_ADMIN? Is your tnsnames.ora stored in
> the
> > default location (ORACLE_HOME\network\admin)?
> >
> I don't have any TNS_ADMIN env set
> When I'v used DBAStudio in order to add a new database in the list, the
> ORACLE_HOME\network\admin\tnsnames.ora was modified
>
> > Include the listener.ora and tnsnames.ora files (and other *.ora files)
in
> > your reply if possible. If the tnsnames.ora is large, then maybe just
> > cut/paste the databases you are having problems with.
> >
> Here is the listener.ora file
> # LISTENER.ORA Network Configuration File:
> D:\oracle\ora81\network\admin\listener.ora
> # Generated by Oracle configuration tools.
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
> )
> )
> (DESCRIPTION =
> (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
> )
> (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 2481))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = D:\oracle\ora81)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = BASE1)
> (ORACLE_HOME = D:\oracle\ora81)
> (SID_NAME = BASE1)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = BASE2)
> (ORACLE_HOME = D:\oracle\ora81)
> (SID_NAME = BASE2)
> )
> )
>
> And here is the tnsnames.ora file:
> # TNSNAMES.ORA Network Configuration File:
> D:\oracle\ora81\network\admin\tnsnames.ora
> # Generated by Oracle configuration tools.
>
> BASE2 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = BASE2)
> (SERVER = DEDICATED)
> )
> )
>
> BASE1 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = BASE1)
> (SERVER = DEDICATED)
> )
> )
>
> ####################################
> # Date..........: Tue Sep 09 15:14:29 CEST 2003
> ####################################
>
> INST1_HTTP =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = SHARED)
> (SERVICE_NAME = BASE2)
> (PRESENTATION = http://admin)
> )
> )
>
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> Thanks for your help
>
>

Forgot, also the sqlnet.ora might have a default domain and this would cause
problems the way you have the tnsnames.ora coded.

At least temporarily rename the sqlnet.ora file to something else and try
again.

--
"Burt Peltier" <burttemp1ReMoVeThIs@bellsouth.net> wrote in message
news:6RC7b.7129$D82.3564@bignews6.bellsouth.net...
> I am in a hurry right now, but I seem to recall the SERVER=DEDICATED might
> be a problem.
>
> Edit and remove that line from the tnsnames.ora and try again.
>
> --
> "Malderez Cédric" <cedric.malderez@answork.com> wrote in message
> news:3f5ed59a$0$13273$626a54ce@news.free.fr...
> > > Are you doing tests while logged onto the server?
> > >
> > Yes, I'm using a local domain account with administrator rights
> >
> > > Are you doing tests while logged onto another machine/client-pc and
does
> > it
> > > have the correct tnsnames.ora file?
> > >
> > I've tried running the client on an other computer. Using the DBAStudio,
> > I've added BASE1 in the Database list.
> > I've never touch the tnsnames.ora file directly
> >
> > > Can you ping (using TCP/IP ping command) the server from the
client-pc?
> > >
> > Yes, the network is working well
> >
> > > Can you tnsping the databases ? Of course, sqlplus is the
real/ultimate
> > test
> > > if you have complete connectivity, but it could be useful info if you
> have
> > > good test with tnsping and not good tests with sqlplus.
> > >
> > I've tried the following command line "tnsping BASE1". It seems to be
> > working
> > Here is the dump:
> > > D:\oracle\ora81\bin>tnsping TSEDF
> > > TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on
> > 10-SEP-2003 09:01:33
> > > (c) Copyright 1997 Oracle Corporation. All rights reserved.
> > > Attempting to contact
> > (ADDRESS=(PROTOCOL=TCP)(HOST=172.31.0.17)(PORT=152 1))
> > > OK (30 msec)
> >
> > > Do you have any other *.ora files in the directory where you store the
> > > tnsnames.ora (other than listener.ora on the server)? Or, do you have
> any
> > > *.ora files anywhere else on the client-pc or server?
> > In the D:\oracle\ora81\network\admin I have the following files:
> > - listener.ora
> > - snmp_ro.ora
> > - snmp_rw.ora
> > - sqlnet.ora
> > - tnsnames.ora
> >
> > > Are you mistakenly pointing to another location for tnsnames.ora other
> > than
> > > the default? Do you have any TNS_ADMIN entries in the registry? Do you
> > have
> > > any environment variable named TNS_ADMIN? Is your tnsnames.ora stored
in
> > the
> > > default location (ORACLE_HOME\network\admin)?
> > >
> > I don't have any TNS_ADMIN env set
> > When I'v used DBAStudio in order to add a new database in the list, the
> > ORACLE_HOME\network\admin\tnsnames.ora was modified
> >
> > > Include the listener.ora and tnsnames.ora files (and other *.ora
files)
> in
> > > your reply if possible. If the tnsnames.ora is large, then maybe just
> > > cut/paste the databases you are having problems with.
> > >
> > Here is the listener.ora file
> > # LISTENER.ORA Network Configuration File:
> > D:\oracle\ora81\network\admin\listener.ora
> > # Generated by Oracle configuration tools.
> >
> > LISTENER =
> > (DESCRIPTION_LIST =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> > )
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
> > )
> > )
> > (DESCRIPTION =
> > (PROTOCOL_STACK =
> > (PRESENTATION = GIOP)
> > (SESSION = RAW)
> > )
> > (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 2481))
> > )
> > )
> >
> > SID_LIST_LISTENER =
> > (SID_LIST =
> > (SID_DESC =
> > (SID_NAME = PLSExtProc)
> > (ORACLE_HOME = D:\oracle\ora81)
> > (PROGRAM = extproc)
> > )
> > (SID_DESC =
> > (GLOBAL_DBNAME = BASE1)
> > (ORACLE_HOME = D:\oracle\ora81)
> > (SID_NAME = BASE1)
> > )
> > (SID_DESC =
> > (GLOBAL_DBNAME = BASE2)
> > (ORACLE_HOME = D:\oracle\ora81)
> > (SID_NAME = BASE2)
> > )
> > )
> >
> > And here is the tnsnames.ora file:
> > # TNSNAMES.ORA Network Configuration File:
> > D:\oracle\ora81\network\admin\tnsnames.ora
> > # Generated by Oracle configuration tools.
> >
> > BASE2 =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SID = BASE2)
> > (SERVER = DEDICATED)
> > )
> > )
> >
> > BASE1 =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SID = BASE1)
> > (SERVER = DEDICATED)
> > )
> > )
> >
> > ####################################
> > # Date..........: Tue Sep 09 15:14:29 CEST 2003
> > ####################################
> >
> > INST1_HTTP =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SERVER = SHARED)
> > (SERVICE_NAME = BASE2)
> > (PRESENTATION = http://admin)
> > )
> > )
> >
> > EXTPROC_CONNECTION_DATA =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> > )
> > (CONNECT_DATA =
> > (SID = PLSExtProc)
> > (PRESENTATION = RO)
> > )
> > )
> >
> > Thanks for your help
> >
> >
>
>

You were right .. It works perfectly

Thanks again

"Burt Peltier" <burttemp1ReMoVeThIs@bellsouth.net> a écrit dans le message
de news:sUC7b.7131$D82.2353@bignews6.bellsouth.net...
> Forgot, also the sqlnet.ora might have a default domain and this would
cause
> problems the way you have the tnsnames.ora coded.
>
> At least temporarily rename the sqlnet.ora file to something else and try
> again.
>
> --
> "Burt Peltier" <burttemp1ReMoVeThIs@bellsouth.net> wrote in message
> news:6RC7b.7129$D82.3564@bignews6.bellsouth.net...
> > I am in a hurry right now, but I seem to recall the SERVER=DEDICATED
might
> > be a problem.
> >
> > Edit and remove that line from the tnsnames.ora and try again.
> >
> > --
> > "Malderez Cédric" <cedric.malderez@answork.com> wrote in message
> > news:3f5ed59a$0$13273$626a54ce@news.free.fr...
> > > > Are you doing tests while logged onto the server?
> > > >
> > > Yes, I'm using a local domain account with administrator rights
> > >
> > > > Are you doing tests while logged onto another machine/client-pc and
> does
> > > it
> > > > have the correct tnsnames.ora file?
> > > >
> > > I've tried running the client on an other computer. Using the
DBAStudio,
> > > I've added BASE1 in the Database list.
> > > I've never touch the tnsnames.ora file directly
> > >
> > > > Can you ping (using TCP/IP ping command) the server from the
> client-pc?
> > > >
> > > Yes, the network is working well
> > >
> > > > Can you tnsping the databases ? Of course, sqlplus is the
> real/ultimate
> > > test
> > > > if you have complete connectivity, but it could be useful info if
you
> > have
> > > > good test with tnsping and not good tests with sqlplus.
> > > >
> > > I've tried the following command line "tnsping BASE1". It seems to be
> > > working
> > > Here is the dump:
> > > > D:\oracle\ora81\bin>tnsping TSEDF
> > > > TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production
on
> > > 10-SEP-2003 09:01:33
> > > > (c) Copyright 1997 Oracle Corporation. All rights reserved.
> > > > Attempting to contact
> > > (ADDRESS=(PROTOCOL=TCP)(HOST=172.31.0.17)(PORT=152 1))
> > > > OK (30 msec)
> > >
> > > > Do you have any other *.ora files in the directory where you store
the
> > > > tnsnames.ora (other than listener.ora on the server)? Or, do you
have
> > any
> > > > *.ora files anywhere else on the client-pc or server?
> > > In the D:\oracle\ora81\network\admin I have the following files:
> > > - listener.ora
> > > - snmp_ro.ora
> > > - snmp_rw.ora
> > > - sqlnet.ora
> > > - tnsnames.ora
> > >
> > > > Are you mistakenly pointing to another location for tnsnames.ora
other
> > > than
> > > > the default? Do you have any TNS_ADMIN entries in the registry? Do
you
> > > have
> > > > any environment variable named TNS_ADMIN? Is your tnsnames.ora
stored
> in
> > > the
> > > > default location (ORACLE_HOME\network\admin)?
> > > >
> > > I don't have any TNS_ADMIN env set
> > > When I'v used DBAStudio in order to add a new database in the list,
the
> > > ORACLE_HOME\network\admin\tnsnames.ora was modified
> > >
> > > > Include the listener.ora and tnsnames.ora files (and other *.ora
> files)
> > in
> > > > your reply if possible. If the tnsnames.ora is large, then maybe
just
> > > > cut/paste the databases you are having problems with.
> > > >
> > > Here is the listener.ora file
> > > # LISTENER.ORA Network Configuration File:
> > > D:\oracle\ora81\network\admin\listener.ora
> > > # Generated by Oracle configuration tools.
> > >
> > > LISTENER =
> > > (DESCRIPTION_LIST =
> > > (DESCRIPTION =
> > > (ADDRESS_LIST =
> > > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> > > )
> > > (ADDRESS_LIST =
> > > (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
> > > )
> > > )
> > > (DESCRIPTION =
> > > (PROTOCOL_STACK =
> > > (PRESENTATION = GIOP)
> > > (SESSION = RAW)
> > > )
> > > (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 2481))
> > > )
> > > )
> > >
> > > SID_LIST_LISTENER =
> > > (SID_LIST =
> > > (SID_DESC =
> > > (SID_NAME = PLSExtProc)
> > > (ORACLE_HOME = D:\oracle\ora81)
> > > (PROGRAM = extproc)
> > > )
> > > (SID_DESC =
> > > (GLOBAL_DBNAME = BASE1)
> > > (ORACLE_HOME = D:\oracle\ora81)
> > > (SID_NAME = BASE1)
> > > )
> > > (SID_DESC =
> > > (GLOBAL_DBNAME = BASE2)
> > > (ORACLE_HOME = D:\oracle\ora81)
> > > (SID_NAME = BASE2)
> > > )
> > > )
> > >
> > > And here is the tnsnames.ora file:
> > > # TNSNAMES.ORA Network Configuration File:
> > > D:\oracle\ora81\network\admin\tnsnames.ora
> > > # Generated by Oracle configuration tools.
> > >
> > > BASE2 =
> > > (DESCRIPTION =
> > > (ADDRESS_LIST =
> > > (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
> > > )
> > > (CONNECT_DATA =
> > > (SID = BASE2)
> > > (SERVER = DEDICATED)
> > > )
> > > )
> > >
> > > BASE1 =
> > > (DESCRIPTION =
> > > (ADDRESS_LIST =
> > > (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
> > > )
> > > (CONNECT_DATA =
> > > (SID = BASE1)
> > > (SERVER = DEDICATED)
> > > )
> > > )
> > >
> > > ####################################
> > > # Date..........: Tue Sep 09 15:14:29 CEST 2003
> > > ####################################
> > >
> > > INST1_HTTP =
> > > (DESCRIPTION =
> > > (ADDRESS_LIST =
> > > (ADDRESS = (PROTOCOL = TCP)(HOST = dbhost)(PORT = 1521))
> > > )
> > > (CONNECT_DATA =
> > > (SERVER = SHARED)
> > > (SERVICE_NAME = BASE2)
> > > (PRESENTATION = http://admin)
> > > )
> > > )
> > >
> > > EXTPROC_CONNECTION_DATA =
> > > (DESCRIPTION =
> > > (ADDRESS_LIST =
> > > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> > > )
> > > (CONNECT_DATA =
> > > (SID = PLSExtProc)
> > > (PRESENTATION = RO)
> > > )
> > > )
> > >
> > > Thanks for your help
> > >
> > >
> >
> >
>
>