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 for each?
The same goes for port too.. I thought that all three on the same port would
be OK?
Cheers
Mark
-----Original Message-----
Mercadante, Thomas F
Sent: 16 January 2004 13:30
To: Multiple recipients of list ORACLE-L
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, 2004 6:14 AM
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 system running Oracle 8.0.5 (don't ask!).
They keep getting an "12154 - Could not resolve service name" error.. The
TNSNAMES.ORA file looks OK, and I feel there is something iffy about their
listener set up. Here's there set-up:
TNSNAMES.ORA:
extproc_connection_data =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = LIVE))
(CONNECT_DATA = (SID = extproc))
)
LIVE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521))
(CONNECT_DATA = (SID = LIVE))
)
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521))
(CONNECT_DATA = (SID = TEST))
)
ARCHIVE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521))
(CONNECT_DATA = (SID = ARCHIVE))
)
LISTENER>ORA:
LISTENER =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= FROUDE))
(ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
(ADDRESS= (PROTOCOL= TCP)(Host= l1000)(Port= 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME= l1000.)
(ORACLE_HOME= /usr/oracle/product/8.0.5)
(SID_NAME = LIVE)
)
(SID_DESC =
(GLOBAL_DBNAME= l1000.)
(ORACLE_HOME= /usr/oracle/product/8.0.5)
(SID_NAME = TEST)
)
(SID_DESC =
(GLOBAL_DBNAME= l1000.)
(ORACLE_HOME= /usr/oracle/product/8.0.5)
(SID_NAME = ARCHIVE)
)
(SID_DESC =
(SID_NAME = extproc)
(ORACLE_HOME = /usr/oracle/product/8.0.5)
(PROGRAM = extproc)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
When he tries to connect "user/[EMAIL PROTECTED]" the connection fails - and the
same for TEST and ARCHIVE. The thing that sticks out to me is the
GLOBAL_DBNAME parameter being set to "l1000" for every instance - do you
think this could be causing the problem?
Is there anything else that catches your eye?
Cheers!
Mark
===================================================
Mark Leith | T: +44 (0)1905 330 281
Sales & Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd | E: [EMAIL PROTECTED]
===================================================
http://www.cool-tools.co.uk
Maximising throughput & performance
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mark Leith
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.net
--
Author: Mercadante, Thomas F
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).
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mark Leith
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).
