ORA-28547 error with OCILogon

From: milkyway <d0mufasa_at_hotmail.com>
Date: 26 Aug 2005 16:07:10 -0700
Message-ID: <1125097630.318450.142980@f14g2000cwb.googlegroups.com>

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_DATA =
(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)

Received on Fri Aug 26 2005 - 18:07:10 CDT