Re: Connection errors (ORA-12504) from .NET application

From: ajmastrean <ajmastrean_at_gmail.com>
Date: 14 Dec 2006 03:51:05 -0800
Message-ID: <1166097065.310435.177940@j72g2000cwa.googlegroups.com>

> The OP is using the XE client, not necessarily the server.
This is true. The server is Oracle 9i.

> Can you connect to the database using sqlplus?
I can connect with sqlplus and another tool, sql developer. The database is on an highly available system.

> Can you provide some real values for [dbname], [serverpath].
Potentially, inquiring with legal and senior personnel...

> ... can you run "lsnrctl status" on the server and post the
> output. [dbname] etc should match values in the listner configuration
I only have cursory knowledge of the system setup, but the server is showing an alias name of the database I am trying to connect to. Is this normal? or does this indicate some oddball addressing scheme? (here's wishing I could use names/addresses, although I ensured that anywhere I put something like [dbname], it was equal to any other occurence of the name).

LSNRCTL STATUS on [servername]
* * *
C:\>lsnrctl status [servername].[serveraddress]

                            *note, I guess I called these
                              2 fields [serverpath] earlier*

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 14-DEC-2006 06:11
:04

Connecting to
(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP) (HOST=[serveripaddress])(PORT=1521)))
STATUS of the LISTENER

Alias                     [dbname]
Version                   TNSLSNR for HPUX: Version 9.2.0.6.0 -
Production
Start Date                02-MAR-2006 13:13:34
Uptime                    248 days 13 hr. 13 min. 56 sec
Trace Level               off
Security                  OFF
SNMP                      OFF

Listener Parameter File
/opt/oracle/product/9.2.0/network/admin/listener.ora Listener Log File
/opt/oracle/product/9.2.0/network/log/[dbname].log Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=[servername])(PORT=1521))) Services Summary...
Service "[dbname].[dbaddress]" has 1 instance(s).   Instance "[dbname]", status READY, has 1 handler(s) for this service...
Service "[some other db].[its address]" has 1 instance(s).   Instance "[dbname]", 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...
The command completed successfully
* * *

LSNRCTL STATUS on [dbname]
* * *
C:\>lsnrctl status [dbname].[dbaddress]

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 14-DEC-2006 06:11
:16

Connecting to
(DESCRIPTION=(SOURCE_ROUTE=OFF)(ADDRESS=(PROTOCOL=TCP)(HOST=[servername].[serveraddress])(PORT=1521))(CONNECT_DATA=(SID=[dbname])(SRVR=DEDICATED))) STATUS of the LISTENER

Alias                     [dbname]
Version                   TNSLSNR for HPUX: Version 9.2.0.6.0 -
Production
Start Date                02-MAR-2006 13:13:34
Uptime                    248 days 13 hr. 13 min. 56 sec
Trace Level               off
Security                  OFF
SNMP                      OFF