Sql Loader Direct NFS Warning Messages While Loading Data With CHARACTERSET "JA16SJIS" (Doc ID 2110581.1)

Last updated on MARCH 21, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Getting Sql Loader Direct NFS warning messages while loading data with CHARACTERSET "JA16SJIS" and the Data Source file location is on NFS.

The used Sql Loader Control file is like:

::Control file ::
LOAD DATA CHARACTERSET "JA16SJIS"
APPEND
INTO TABLE FCYT_SYUKUJITU_M
REENABLE
FIELDS TERMINATED BY "|"
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
KYUJITU_YMD "RTRIM(:KYUJITU_YMD)",
KYUJITU_NAME "RTRIM(:KYUJITU_NAME)"
)


Next Direct NFS warning messages are raised when using CHARACTERSET "JA16SJIS":

SQL*Loader: Release 12.1.0.2.0 - Production on Wed Feb 24 14:14:38 2016

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

::Warning message CHARACTERSET "JA16SJIS"::

Path used: Conventional
Direct NFS: channel id [0] path [tkgisnap061-v101.nomura.com] to filer [tkgisnap061-v101.nomura.com] via local [] is UP
Direct NFS: attempting to mount /vol/vol101/nap061gis_userhome1/srenair on filer tkgisnap061-v101.nomura.com defined in mtab
Direct NFS: channel config is:
channel id [0] local [] path [tkgisnap061-v101.nomura.com]
[1456294479455655] kgnfs_exec_remote_mount:2430: warn could not spawn oradism
Direct NFS: please check that oradism is setuid
Commit point reached - logical record count 1

Table T:
1 Row successfully loaded.

 

NOTE:
If CHARACTERSET is "UTF8" in the sqlldr controlfile, there is no warning message.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms