Oracle Database Discussions

Hello,

As far as I can tell, my listener and network services are all working correctly. However, when I run the ‘Test Service’ test in netmgr, the tests fail. Here are the 2 tests:

1. If I select the name of my database and choose ‘Test Service’ menu command from the Command menu, then I get an error dialog box that says ‘A valid “Service Name” is required.’

One observation is that netmgr lists the name of my database as “griffmcc” while the full name is “griffmcclellan.net.” I don’t know if this may contribute to the error.

2. If I select ‘extproc_connection_data’ and choose ‘Test Service,’ then I get an error dialog box that says ‘The test did not succeed. ORA-28547 connection to server failed, probable Oracle Net admin error.’ I ran this test with a number of different login names but always got the same result.

Does anyone know how to fix these errors? I provide more specifics about my configuration below.

Thanks,
Griff


Here is the output from the lsnrctl services and status commands. They both appear to be in good shape.

$ lsnrctl services

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 24-APR-2007 13:12:14

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "CRAIGSDBXDB.net" has 1 instance(s).
Instance "CRAIGSDB", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: lin.griffmcclellan.net, pid: 4816>
(ADDRESS=(PROTOCOL=tcp)(HOST=lin.griffmcclellan.net)(PORT=41038))
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:6 refused:0
LOCAL SERVER
Service "griffmcclellan.net" has 1 instance(s).
Instance "CRAIGSDB", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:325 refused:0 state:ready
LOCAL SERVER
Service "griffmcclellan_XPT.net" has 1 instance(s).
Instance "CRAIGSDB", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:325 refused:0 state:ready
LOCAL SERVER
The command completed successfully


$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 24-APR-2007 13:09:10

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 23-APR-2007 14:14:56
Uptime 0 days 22 hr. 54 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lin.griffmcclellan.net)(PORT=1521)))
Services Summary...
Service "CRAIGSDBXDB.net" has 1 instance(s).
Instance "CRAIGSDB", status READY, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "griffmcclellan.net" has 1 instance(s).
Instance "CRAIGSDB", status READY, has 1 handler(s) for this service...
Service "griffmcclellan_XPT.net" has 1 instance(s).
Instance "CRAIGSDB", status READY, has 1 handler(s) for this service...
The command completed successfully