Scott,
Where on the client machine is the tnsnames.ora file? Probably is in
the $ORACLE_HOME\NETWORK\ADMIN directory or maybe a network drive. Your
home is probably c:\ora817 or maybe If you only changed the tnsnames.ora
on the server side (i.e. prod), you will also need to update the
tnanames.ora file on the client.
Good luck. (I'm sure you'll get it)
Stephen
>>> [EMAIL PROTECTED] 10/04/02 03:33PM >>>
Hello all,
DB=8.1.7.4.0
DB Server OS=HPUX 11i
Client: Windows NT 4.0
I have 3 Oracle instances that were installed on one machine "prod".
They
are FPRD, FTRN and FTST. I moved FTST to a different machine "dev". I
changed the tnsnames.ora files on the clients and the servers, and I
changed the listener.ora on the servers.
Now I cannot connect to the FTST instance on the "dev" machine from the
clients. The TNS_ADMIN env variable is not set either. I tried to set
it
on one of the clients and it broke all of the other instances. When I
do a
TNSPING from the clients, it still shows that the client is trying to
connect to the "prod" machine even though the tnsnames.ora file on the
client is pointing to "dev". I don't know where the client is getting
that
the FTST database is still located on "prod". I checked the sqlnet.ora
file on the clients and servers and they all have
"names.directory_path=(TNSNAMES)"
The twist to all of this is that if I try to connect using sqlplus from
"prod" to "dev" and vice versa, I can connect all day long with no
problems
at all. So that leads me to believe the issue lies on the Client
side.
Example:
C:\ tnsping ftst.harper.cc.il.us
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=prod)(PORT=1521))
and it should read:
C:\ tnsping ftst.harper.cc.il.us
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=dev)(PORT=1521))
Because the tnsnames.ora file reads:
FTST.HARPER.CC.IL.US =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dev)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ftst)
)
)
Please help a newbie!!!
Thanks so much in advance!
******************************************
Scott Stefick
UNIX Systems Administrator
Oracle Certified Professional DBA
Wm. Rainey Harper College
847.925.6130
******************************************
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Stefick
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Andert
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
