Hello Mark,
all 3 instances are listening on the same port.
Cheers
Barry.
-Original Message-
Mark Leith
Sent: 16 January 2004 11:14
To: Multiple recipients of list ORACLE-L
Hi All,
I'm helping out a friend of mine who's having problems with connecting from
an NT system to an HP
Mark,
The (GLOBAL_DBNAME= l1000.)
entry looks strange. Should there be a '.' in there? I've never seen this
entry in this file. What does : lsnrctl status lsnrctl services show?
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, January 16,
I've asked for the out put on a lsnrctl status already, but haven't heard
back from him as yet..
The . does look strange.. Also, what would the impact be to have the
GLOBAL_DBNAME set to the same value for all three instances? Would it not be
better to set it to the same name as the instance name
Mark,
I don't think that all three on the same port is a problem - heck - I do it
all the time. I would comment out the GLOBAL_DBNAME entry. It certainly is
not required. And output from lsnrctl would be helpful.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent:
I don't believe a 12154 error has anything to do with the listener. The
request never leaves the client. It has all to do with the fact that sqlnet
on the client can not find the service name in the tnsnames.ora. What is
names.default.domain set to in sqlnet.ora. If there is no sqlnet.ora try
Thanks folks (a useful gender-neutral word).
Suggestions received were
clean up old names files
try pinging name and ip address
use ip address in names file instead of a name
trace.
I have 4 Oracles on the machine so I renamed old names files.
I then failed to
spot on, thanks.
S.J.C. Fox
CRH
0161 601 8723
-Original Message-
Sent: 27 June 2003 19:20
To: Multiple recipients of list ORACLE-L
A name resolution problem? Symptoms for the site with problems are
consistent with not getting consistently consistent service from your name
server.
fair point about lack of info. You guessed correctly about contents of
tnsnames file. Many thanks.
S.J.C. Fox
CRH
0161 601 8723
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: 28 June 2003 00:04
To: Multiple recipients of list ORACLE-L
Try turning on SQL Net tracing to
A name resolution problem? Symptoms for the site with problems are
consistent with not getting consistently consistent service from your name
server. Look are your tnsnames.ora and see if it has the name of host
there. If so, try putting in the IP address instead.
-Original Message-
Try turning on SQL Net tracing to discover the problem. Turn on tracing on
the client PC by adding the appropriate trace parameters to the sqlnet.ora
file.
This will produce a trace file upon your next connection attempt and you
will be able to (hopefully) see what is causing the problem. It is
Thanks to all for your suggestions.
Looking at the log file gave me a clue that the wrong tnsnames.ora was
being used. It was tricky since the host that it was connecting to has
been renamed but the old name is still supported through DNS, so when I
saw that the log file had the old name, I
Just a guess, but have you checked the firewall settings?
Rusnak,
George A. To:
Rusnak, George A. wrote:
Group,
I have a development and a production system. Both are Sun/Solaris, Oracle
8.1.7.2.
I have an identical db link to a remote server on both of my servers. I can
connect to remote host using the user/password that is in the db link.
On my development
Is tnsnames.ora pointing to the same place on both servers?
-Original Message-
Sent: Friday, January 11, 2002 1:15 PM
To: Multiple recipients of list ORACLE-L
Rusnak, George A. wrote:
Group,
I have a development and a production system. Both are Sun/Solaris, Oracle
8.1.7.2.
I
:RE: Connection problem
Is tnsnames.ora pointing to the same place on both servers?
-Original Message-
Sent: Friday, January 11, 2002 1:15 PM
To: Multiple recipients of list ORACLE-L
Rusnak, George A. wrote:
Group,
I have a development and a production system. Both are Sun
15 matches
Mail list logo