Other Oracle database topics - ORA-28547 error with OCILogon

Author

ORA-28547 error with OCILogon

milkyway

2005-08-26, 8:23 pm

Hello out there,

I am using Oracle 10.0 OCI calling interface. When running the example
of the bulk loading, I come across an Oracle error
ORA-28547.

I have incorporated the sqlnet.ora, tnsnames.ora and listener.ora
below.

What am I doing wrong? Or is this a new bug?

Kindest Regards.

====================
====================
==================
SQLNET.ORA
====================
====================
==================

# sqlnet.ora Network Configuration File:
/large_work/opt_oracle/opt/oracle/product/10.0.1/db_1/network/admin/sqlnet.ora

# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

====================
====================
==================
LISTENER.ORA
====================
====================
==================
# listener.ora Network Configuration File:
/large_work/opt_oracle/opt/oracle/product/10.0.1/db_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = DEV)
(SID_NAME = DEV)
(ORACLE_HOME = /large_work/opt_oracle/opt/oracle/product/10.0.1/db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
)

====================
====================
====================
=
TNSNAMES.ORA
====================
====================
====================
=
# tnsnames.ora Network Configuration File:
/large_work/opt_oracle/opt/oracle/product/10.0.1/db_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

DEV =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DEV)
)
)

EXTPROC_CONNECTION_D
ATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = DEV)
(SERVICE_NAME = DEV)
(PRESENTATION = RO)
)
)

====================
====================
==================
BULK INSERT
====================
====================
==================
-----------------------------------------------------------

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <oci.h>

void checkerr(OCIError *errp, sword status);

int main()
{

(previous snipped)

/* logon */

********* THE LINE THAT FAILS ********************
*********
checkerr(errp, OCILogon(envp, errp, &svcp, "SCOTT", 5, "TIGER", 5,
"DEV", 3));
********************
********************
********************

(rest snipped)

Rene Nyffenegger

2005-08-26, 8:23 pm

> Hello out there,
>
> I am using Oracle 10.0 OCI calling interface. When running the example
> of the bulk loading, I come across an Oracle error
> ORA-28547.

You cannot expect anyone to know what errer text is hidden behind
ORA-28547. You should, imho, post the entire error message
if you want some help.

Rene

--
Rene Nyffenegger
http://www.adp-gmbh.ch/

HansF

2005-08-27, 3:23 am

First thing I'd check is 'can you get there from here'? Can you (tnsping
dev) and (sqlplus scott/tiger@dev) from the same machine?

Note that the problem starts at the client side, and therefore has little
or nothing to do with the Listener on the server, at least initially.

Oracle has a real handy little document, called the "Oracle® Database Net
Services Administrator's Guide", part III of which goes into a lot of
detail in troubleshooting. Check it out at docs.oracle.com (and
specifically the list of books for 10g Release 1 is at
http://otn.oracle.com/pls/db10g/por...ted=3#index-NET)

The BIG question - how did these files get created? I'd encourage you to
fire up Oracle's Network Manager to check the syntax of the TNSNAMES.ora
(netmgr)

For reference ... the error message (as provided in the docco) is

ORA-28547: connection to server failed, probable Net8 admin error

Cause: A failure occurred during initialization of a network
connection from a client process to the Oracle server: The connection
was completed but a disconnect occurred while trying to perform
protocol-specific initialization, usually due to use of different
network protocols by opposite sides of the connection. This usually is
caused by incorrect Net8 administrative setup for database links or
external procedure calls. The most frequent specific causes are: --
The connection uses a connect string which refers to a Heterogeneous
Services agent instead of an Oracle server. -- The connection uses a
connect string which includes an (HS=) specification.

Action: Check Net8 administration in the following ways: -- When
using TNSNAMES.ORA or an Oracle Names server, make sure that the
client connection to the ORACLE server uses the correct service name
or SID. -- Check LISTENER.ORA on the connection end point's host
machine to assure that this service name or SID refers to the correct
server. -- Confirm in TNSNAMES.ORA or the equivalent service
definition that the connect string does NOT contain (HS=).

--
Hans Forbrich
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries ***

Dave

2005-08-30, 7:23 am

milkyway wrote:
> Hello out there,
>
> I am using Oracle 10.0 OCI calling interface. When running the example
> of the bulk loading, I come across an Oracle error
> ORA-28547.
>

First thing to check is the configuration - in the same shell, from the
same place, run sqlplus scott/tiger@dev. Don't telnet to the server and
run sqlplus locally - that's not the same thing.

If your config is duff then sqlplus should fail in the same way.

If it doesn't, then it's either a bug or a programming error. Post a
*minimal* reproduceable test program, that shows the problem in the
*least possible* amount of code (should be possible in less than 10
lines of code, seeing as the failure is on OCILogon) for further
investigation.

Dave.

Sponsored Links