ghanrahan
asked on
Oracle - TNS:could not resolve service name
Hi - I'm running Oracle 9i on Win 2003 Server. The database I am trying to connect to is on this computer. I am unable to connect. I keep getting tns could not resolve service name. I can't see anything wrong with my tnsentry or my sqlnet.ora file. Any help that can be provided would be much appreciated. Thanks (I am trying to connect to username/password@geotech.
THanks in advance.
Here is my tns entry:
GEOTECH =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = home-s6ec3n0cp6)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = geotech.world)
)
)
Here is a copy of my sqlnet.ora file -
# SQLNET.ORA Network Configuration File: c:\oracle\ora92\network\ad
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERV
names.directory_path = (TNSNAMES)
TRACE_LEVEL_CLIENT = OFF
names.default_domain = world
name.default_zone = world
THanks in advance.
Here is my tns entry:
GEOTECH =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = home-s6ec3n0cp6)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = geotech.world)
)
)
Here is a copy of my sqlnet.ora file -
# SQLNET.ORA Network Configuration File: c:\oracle\ora92\network\ad
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERV
names.directory_path = (TNSNAMES)
TRACE_LEVEL_CLIENT = OFF
names.default_domain = world
name.default_zone = world
Just try as follows. Remove the service name if database resides on the same mechine.
username/password
C:\> sqlplusw scott/tiger
or
C:\> sqlplusw sys/change_on_install as sysdba
username/password
C:\> sqlplusw scott/tiger
or
C:\> sqlplusw sys/change_on_install as sysdba
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
check if the Listener is running.
C:>lsnrctl status
To start the listener:
c:>lsnrctl start
C:>lsnrctl status
To start the listener:
c:>lsnrctl start
ASKER
Hi - Thanks for the responses ... unfortunately, I'm having an OS system problem right now so am unable to try them. For some reason, I'm only able to boot my 2003 Server in safe mode. As soon as I am able to resolve that I will attempt the suggestions. Thanks for your input and patience.
have a look int he tnsnames.ora file or use the java config app... ensure the tns name you are using exists and is spelled correctly in the tnsnames.ora and in your app code that connects the db
ASKER
Hi, sorry for the long delay getting back to this. I had a couple of other issues to deal with.
Ravindran ... you are correct. I don't know how I overlooked that. I changed my tnsnames.ora file and added the .world to the end and it worked fine. Please let me know if you don't get your points. I marked your response as the accepted answer so that should award the points to you. Thanks very much for the assistance, and I aplogize for not getting back to you sooner. Thanks
Ravindran ... you are correct. I don't know how I overlooked that. I changed my tnsnames.ora file and added the .world to the end and it worked fine. Please let me know if you don't get your points. I marked your response as the accepted answer so that should award the points to you. Thanks very much for the assistance, and I aplogize for not getting back to you sooner. Thanks
1) tnsping geotech
2) username/password@geotech