Service Name Configuration

Please Help!

I am trying to configure a service name in order to install OEM on Windows NT.
I keep getting the same error message:
ORA-12541: TNS: no listener. Test did not succeed.

I am 100% positive that:
1. I use right hostname.
2. I use right Service name.
3. All of my services are started.
4. To make sure my listener is up, I use LSNRCTL STATUS.

I don't know what to do? Any advise?

Make sure you don't have several tnsnames.ora, file if you do make sure they all have the entry for the instance you want to connect to.

Whitch client appicacions you used?
Are you used domain name for oracle services?

In your client system where is the tnsname.ora file
ie. $ORACLE_HOME/network/admin/tnsname.ora.
if yes,
try to put the tnsname.ora file at $ORACLE_HOME/network/
and try to connect.

Good Luck

Quote:

---

Originally posted by Chandra
In your client system where is the tnsname.ora file
ie. $ORACLE_HOME/network/admin/tnsname.ora.
if yes,
try to put the tnsname.ora file at $ORACLE_HOME/network/
and try to connect.

Good Luck

---

You would never want to do this. The oracle tnanames name call would always look at $ORACLE_HOME/network/admin only.

The problem in this case would mostly lie in the tnsname.ora file configuration and not in its location. Do a search on the tnsnames.ora file and then make sure that all have the same entries that you would want.

Sam

for an issue like configuration os tnsnames.ora do not change the destination of tnsnames.ora file.
Make sure all the entries in listener and tnsnames are in synch.
make sure listener is up and running.
still problems then restart listener...look for the handles created. if your instance name is not found in handlers list there is some thing with wrong with you listener file.
Then look for the entries and also the log file for the listener.
isolate problem step by step like that ..

also read this tip I collected:

If you are having trouble with your database connection, you may
need to examine which tnsnames file you are using. If you have
many tnsnames files on your machine, you may not be reading the
one you think you are. You can have a local version and a system
version. When a client connection is requested, the service name
or parameter is first searched in the local version of this
configuration file. If the service is not found in the local version
it is searched in the system version. The system version is located
in the "ORACLE_HOME\NET80\ADMIN" directory for Oracle 8.0 software.
The system version is located in the "ORACLE_HOME\NETWORK\ADMIN"
directory for Oracle 8i software.

A local version can exist in the current working directory where
the application is running. For example, if, on Windows NT you
start SQL*Plus in "ORACLE_HOME\BIN", then Net8 looks for a local
TNSNAMES.ORA in "ORANT\BIN" before looking for the system version.
As a consequence you could have multiple local files in various
directories. It is recommended that only one TNSNAMES.ORA file
exist and that it be located in the default "ORACLE_HOME\NET80\ADMIN"
directory. On UNIX platforms, setting the environment variable
$TNS_ADMIN= will direct Net8 to look for the
file in that location. On Windows NT, the TNS_ADMIN in located
in the registry. You might find it helpful to have only one set of
configuration files in a single directory. Then set the TNS_ADMIN
environment variable to point to that one directory.

When I type in:

"1.Confirm DNS is working

c:> nslookup host_name

c:> nslookup ip_address"

I get the same error messages:

Can't find server name for address XXXXXXX
No response from server
Server: unknown

It looks to me that something is not configured right on my PC - way before listener.

Do you think you can help me?

OlgaK.

try to ping from any another PC to you PC and, if you have any fileserver, try to connect to it. may be this is technical network problem.

more serious problems:
are you have firewalls between you PS and oracle servers and all needed ports open.
and many other net problems.