Database Administration (MOSC)

MOSC Banner

sqlldr Error with IP Address

edited Jun 8, 2020 1:12PM in Database Administration (MOSC) 6 commentsAnswered ✓

Hello Team,

I have a migration tool which uses sqlldr utility to load data from one oracle database (11g)  to another oracle database (12c).

The tool construct the script with the following parameters

IP:PORT:SID

USERNAME

PASSWORD

DIRECTORY

The migration tool uses the parameters above to construct the script below to migrate the data

sqlldr userid=USERNAME/psswd@xx.xx.xx.xx:1522:SID control=RSA_ALL_IND_COLUMNS_control_file_v2.ctl log=RSA_ALL_IND_COLUMNS_V2_log direct=TRUE

However, the process fails with the below error.

SQL*Loader: Release 11.2.0.2.0 - Production on Mon Jun 8 12:41:19 2020

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center