当前位置：首页 > news >正文

oracle-blob导出，在ob导入失败

news 来源：原创 2025/6/28 2:58:41

导出：

[oracle@lncs dmp]$ /home/oracle/sqluldr2 gistar/res#pwd@192.168.205.58:1521/lndb query="select * from an_odn_picture where length(PIC_CONTENT)<=25000" file=an_odn_picture.csv Charset=utf8 text=CSV
0 rows exported at 2025-03-31 14:41:35, size 0 MB.
121633 rows exported at 2025-03-31 14:47:17, size 2158 MB.
output file an_odn_picture.csv closed at 121633 rows, size 2158 MB.
[oracle@lncs dmp]$ du -sh an_odn_picture.csv
2.2G an_odn_picture.csv
[oracle@lncs dmp]$ /home/oracle/sqluldr2 gistar/res#pwd@192.168.205.58:1521/lndb query="select * from an_odn_picture where length(PIC_CONTENT)>25000" file=an_odn_picture1.csv Charset=utf8 text=CSV
0 rows exported at 2025-03-31 14:47:45, size 0 MB.
ORA-24345: A Truncation or null fetch error occurred
[oracle@lncs dmp]$ /home/oracle/sqluldr2 gistar/res#pwd@192.168.205.58:1521/lndb query="select * from an_odn_picture where length(PIC_CONTENT)>25000 and length(PIC_CONTENT)<=30000" file=an_odn_picture1.csv Charset=utf8 text=CSV
0 rows exported at 2025-03-31 14:48:10, size 0 MB.
^CORA-01013: user requested cancel of current operation
[oracle@lncs dmp]$ /home/oracle/sqluldr2 gistar/res#pwd@192.168.205.58:1521/lndb query="select * from an_odn_picture where length(PIC_CONTENT)>25000 and length(PIC_CONTENT)<=30000" file=an_odn_picture1.csv Charset=utf8 text=CSV head=no
0 rows exported at 2025-03-31 14:49:31, size 0 MB.
45402 rows exported at 2025-03-31 14:50:06, size 1188 MB.
output file an_odn_picture1.csv closed at 45402 rows, size 1188 MB.
[oracle@lncs dmp]$ /home/oracle/sqluldr2 gistar/res#pwd@192.168.205.58:1521/lndb query="select * from an_odn_picture where length(PIC_CONTENT)>30000" file=an_odn_picture2.csv Charset=utf8 text=CSV head=no
0 rows exported at 2025-03-31 14:52:30, size 0 MB.
ORA-24345: A Truncation or null fetch error occurred
[oracle@lncs dmp]$ /home/oracle/sqluldr2 gistar/res#pwd@192.168.205.58:1521/lndb query="select * from an_odn_picture where length(PIC_CONTENT)>30000 and length(PIC_CONTENT)<=35000" file=an_odn_picture2.csv Charset=utf8 text=CSV head=no
0 rows exported at 2025-03-31 14:53:02, size 0 MB.
ORA-24345: A Truncation or null fetch error occurred
[oracle@lncs dmp]$ sqlplus gistar/res#pwd

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 31 14:53:12 2025

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select count(*) from an_odn_picture where length(PIC_CONTENT)>30000 and length(PIC_CONTENT)<=35000;

COUNT(*)
----------
21231

SQL> select count(*) from an_odn_picture where length(PIC_CONTENT)>30000 and length(PIC_CONTENT)<=32000';
ERROR:
ORA-01756: quoted string not properly terminated

SQL> select count(*) from an_odn_picture where length(PIC_CONTENT)>30000 and length(PIC_CONTENT)<=32000;

COUNT(*)
----------
11554

SQL> select count(*) from an_odn_picture where length(PIC_CONTENT)>30000;

COUNT(*)
----------
29076

SQL> select count(*) from an_odn_picture where length(PIC_CONTENT)>30000 and length(PIC_CONTENT)<=31000;

COUNT(*)
----------
6333

SQL> select count(*) from an_odn_picture where length(PIC_CONTENT)>30000 and length(PIC_CONTENT)<=33000;

COUNT(*)
----------
15618

SQL> select count(*) from an_odn_picture where length(PIC_CONTENT)>30000 and length(PIC_CONTENT)<=34000;

COUNT(*)
----------
18836

SQL> select count(*) from an_odn_picture where length(PIC_CONTENT)>30000 and length(PIC_CONTENT)<=36000;

COUNT(*)
----------
23062

SQL> select count(*) from an_odn_picture where length(PIC_CONTENT)>30000 and length(PIC_CONTENT)<=37000;

COUNT(*)
----------
24402

SQL> select count(*) from an_odn_picture where length(PIC_CONTENT)>30000 and length(PIC_CONTENT)<=38000;

COUNT(*)
----------
25355

SQL> select count(*) from an_odn_picture where length(PIC_CONTENT)>30000 and length(PIC_CONTENT)<=39000;

COUNT(*)
----------
25988

SQL> select count(*) from an_odn_picture where length(PIC_CONTENT)>30000 and length(PIC_CONTENT)<=40000;

COUNT(*)
----------
26510

SQL> select count(*) from an_odn_picture where length(PIC_CONTENT)>30000 and length(PIC_CONTENT)<=45000;

COUNT(*)
----------
27878

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@lncs dmp]$ /home/oracle/sqluldr2 gistar/res#pwd@192.168.205.58:1521/lndb query="select * from an_odn_picture where length(PIC_CONTENT)>30000 and length(PIC_CONTENT)<=32000" file=an_odn_picture2.csv Charset=utf8 text=CSV head=no
0 rows exported at 2025-03-31 14:55:59, size 0 MB.
11554 rows exported at 2025-03-31 14:57:26, size 342 MB.
output file an_odn_picture2.csv closed at 11554 rows, size 342 MB.
[oracle@lncs dmp]$ /home/oracle/sqluldr2 gistar/res#pwd@192.168.205.58:1521/lndb query="select * from an_odn_picture where length(PIC_CONTENT)>32000 and length(PIC_CONTENT)<=35000" file=an_odn_picture2.csv Charset=utf8 text=CSV head=no
^C 0 rows exported at 2025-03-31 14:59:18, size 0 MB.
^[[A^CORA-01013: user requested cancel of current operation
[oracle@lncs dmp]$ /home/oracle/sqluldr2 gistar/res#pwd@192.168.205.58:1521/lndb query="select * from an_odn_picture where length(PIC_CONTENT)>32000 and length(PIC_CONTENT)<=35000" file=an_odn_picture3.csv Charset=utf8 text=CSV head=no
0 rows exported at 2025-03-31 14:59:29, size 0 MB.
ORA-24345: A Truncation or null fetch error occurred
[oracle@lncs dmp]$ /home/oracle/sqluldr2 gistar/res#pwd@192.168.205.58:1521/lndb query="select * from an_odn_picture where length(PIC_CONTENT)>32000 and length(PIC_CONTENT)<=34000" file=an_odn_picture3.csv Charset=utf8 text=CSV head=no
0 rows exported at 2025-03-31 14:59:41, size 0 MB.
ORA-24345: A Truncation or null fetch error occurred
[oracle@lncs dmp]$ /home/oracle/sqluldr2 gistar/res#pwd@192.168.205.58:1521/lndb query="select * from an_odn_picture where length(PIC_CONTENT)>32000 and length(PIC_CONTENT)<=33000" file=an_odn_picture3.csv Charset=utf8 text=CSV head=no
0 rows exported at 2025-03-31 14:59:50, size 0 MB.
ORA-24345: A Truncation or null fetch error occurred
[oracle@lncs dmp]$ ls -lt
total 3571388
-rw-r--r-- 1 oracle oinstall 0 Mar 31 14:59 an_odn_picture3.csv
-rw-r--r-- 1 oracle oinstall 0 Mar 31 14:59 an_odn_picture2.csv
-rw-r--r-- 1 oracle oinstall 1245954866 Mar 31 14:50 an_odn_picture1.csv
-rw-r--r-- 1 oracle oinstall 2262497611 Mar 31 14:47 an_odn_picture.csv
-rw-r--r-- 1 oracle oinstall 148633380 Mar 21 14:15 dict_premises_network.dmp
[oracle@lncs dmp]$ /home/oracle/sqluldr2 gistar/res#pwd@192.168.205.58:1521/lndb query="select * from an_odn_picture where length(PIC_CONTENT)>32000 and length(PIC_CONTENT)<=33000" file=an_odn_picture3.csv Charset=utf8 text=CSV head=no buffer=65535000
0 rows exported at 2025-03-31 15:00:45, size 0 MB.
ORA-24345: A Truncation or null fetch error occurred
[oracle@lncs dmp]$ /home/oracle/sqluldr2 gistar/res#pwd@192.168.205.58:1521/lndb query="select * from an_odn_picture where length(PIC_CONTENT)>32000 and length(PIC_CONTENT)<=32500" file=an_odn_picture3.csv Charset=utf8 text=CSV head=no
0 rows exported at 2025-03-31 15:01:01, size 0 MB.
2105 rows exported at 2025-03-31 15:01:22, size 65 MB.
output file an_odn_picture3.csv closed at 2105 rows, size 65 MB.
[oracle@lncs dmp]$ /home/oracle/sqluldr2 gistar/res#pwd@192.168.205.58:1521/lndb query="select * from an_odn_picture where length(PIC_CONTENT)>32500 and length(PIC_CONTENT)<=33000" file=an_odn_picture3.csv Charset=utf8 text=CSV head=no
0 rows exported at 2025-03-31 15:01:37, size 0 MB.
ORA-24345: A Truncation or null fetch error occurred
[oracle@lncs dmp]$ ll
total 3571388
-rw-r--r-- 1 oracle oinstall 1245954866 Mar 31 14:50 an_odn_picture1.csv
-rw-r--r-- 1 oracle oinstall 0 Mar 31 14:59 an_odn_picture2.csv
-rw-r--r-- 1 oracle oinstall 0 Mar 31 15:01 an_odn_picture3.csv
-rw-r--r-- 1 oracle oinstall 2262497611 Mar 31 14:47 an_odn_picture.csv
-rw-r--r-- 1 oracle oinstall 148633380 Mar 21 14:15 dict_premises_network.dmp
[oracle@lncs dmp]$ scp an_odn_picture.csv admin@192.168.207.143:/db/ob/admin/
admin@192.168.207.143's password:
an_odn_picture.csv 100% 2158MB 6.6MB/s 05:27
[oracle@lncs dmp]$

ob目标blob字段表失败的导入：

[admin@lnpg ~]$ obloader -h 127.0.0.1 -P 2881 -u ugistar -p res#pwd --sys-user 'root@sys' --sys-password=linux123 -t lnzyob -D gistar --csv --all -f an_odn_picture.csv --table test00
2025-03-31 15:22:00 [INFO] Parsed args:
[--csv] true
[--file-path] an_odn_picture.csv
[--host] 127.0.0.1
[--port] 2881
[--user] ugistar
[--tenant] lnzyob
[--password] ******
[--database] gistar
[--sys-user] root@sys
[--sys-password] ******
[--all] true
[--table] [test00]

2025-03-31 15:22:00 [WARN] The Java version (1.8.0_221) you are currently using is not recommended. Recommended range: [1.8.0_300, 9.0.0)
2025-03-31 15:22:00 [ERROR] Load failed! Error: One table can only correspond to one data file
2025-03-31 15:22:00 [ERROR] System exit 1
[admin@lnpg ~]$ obloader -h 127.0.0.1 -P 2881 -u gistar -p res#pwd --sys-user 'root@sys' --sys-password=linux123 -t lnzyob -D gistar --csv --all -f an_odn_picture.csv --table test00
2025-03-31 15:22:24 [INFO] Parsed args:
[--csv] true
[--file-path] an_odn_picture.csv
[--host] 127.0.0.1
[--port] 2881
[--user] gistar
[--tenant] lnzyob
[--password] ******
[--database] gistar
[--sys-user] root@sys
[--sys-password] ******
[--all] true
[--table] [test00]

2025-03-31 15:22:24 [WARN] The Java version (1.8.0_221) you are currently using is not recommended. Recommended range: [1.8.0_300, 9.0.0)
2025-03-31 15:22:25 [ERROR] Load failed! Error: One table can only correspond to one data file
2025-03-31 15:22:25 [ERROR] System exit 1
[admin@lnpg ~]$ pwd
/db/ob/admin
[admin@lnpg ~]$ obloader -h 127.0.0.1 -P 2881 -u gistar -p res#pwd --sys-user 'root@sys' --sys-password=linux123 -t lnzyob -D gistar --csv --all -f /db/ob/admin/an_odn_picture.csv --table test00
2025-03-31 15:22:42 [INFO] Parsed args:
[--csv] true
[--file-path] /db/ob/admin/an_odn_picture.csv
[--host] 127.0.0.1
[--port] 2881
[--user] gistar
[--tenant] lnzyob
[--password] ******
[--database] gistar
[--sys-user] root@sys
[--sys-password] ******
[--all] true
[--table] [test00]

2025-03-31 15:22:42 [WARN] The Java version (1.8.0_221) you are currently using is not recommended. Recommended range: [1.8.0_300, 9.0.0)
2025-03-31 15:22:43 [ERROR] Load failed! Error: One table can only correspond to one data file
2025-03-31 15:22:43 [ERROR] System exit 1
[admin@lnpg ~]$ obloader -h 127.0.0.1 -P 2881 -u gistar -p res#pwd --sys-user 'root@sys' --sys-password=linux123 -t lnzyob -D gistar --csv -f /db/ob/admin/an_odn_picture.csv --table test00
2025-03-31 15:22:56 [INFO] Parsed args:
[--csv] true
[--file-path] /db/ob/admin/an_odn_picture.csv
[--host] 127.0.0.1
[--port] 2881
[--user] gistar
[--tenant] lnzyob
[--password] ******
[--database] gistar
[--sys-user] root@sys
[--sys-password] ******
[--table] [test00]

2025-03-31 15:22:56 [WARN] The Java version (1.8.0_221) you are currently using is not recommended. Recommended range: [1.8.0_300, 9.0.0)
2025-03-31 15:22:56 [INFO] Log files will be written to /db/ob/admin/logs
2025-03-31 15:22:56 [INFO] Trying to establish JDBC connection to `gistar@lnzyob`...
2025-03-31 15:22:57 [INFO] Sys-tenant credential is required (add `--no-sys` if you don't have one). Now trying to establish JDBC connection to `root@sys@sys`...
2025-03-31 15:22:57 [INFO] Server Mode: OBORACLE-3.2.4.1
2025-03-31 15:22:57 [ERROR] create connection SQLException, url: jdbc:oceanbase://127.0.0.1:2881/oceanbase?characterEncoding=utf8&socketTimeout=1800000&connectTimeout=1800000&zeroDateTimeBehavior=convertToNull&useServerPrepStmts=true&noDatetimeStringSync=true&useCompression=true&log=false&allowMultiQueries=true&useLocalSessionState=true&cachePrepStmts=true&useSqlStringCache=true&extendOracleResultSetClass=true&// keyStore=&// keyStorePassword=, errorCode 1045, state 42000 java.sql.SQLSyntaxErrorException: Could not connect to 127.0.0.1:2881 : (conn=3221747088) Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES)
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:110) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:235) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1729) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.util.Utils.retrieveProxy(Utils.java:1436) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.OceanBaseConnection.newConnection(OceanBaseConnection.java:397) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.Driver.connect(Driver.java:93) ~[oceanbase-client-2.4.11.jar:?]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1682) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1803) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2928) ~[druid-1.2.22.jar:?]
Caused by: java.sql.SQLSyntaxErrorException: (conn=3221747088) Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES)
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:110) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:230) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:807) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:602) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1724) ~[oceanbase-client-2.4.11.jar:?]
... 6 more

2025-03-31 15:22:57 [ERROR] create connection SQLException, url: jdbc:oceanbase://127.0.0.1:2881/oceanbase?characterEncoding=utf8&socketTimeout=1800000&connectTimeout=1800000&zeroDateTimeBehavior=convertToNull&useServerPrepStmts=true&noDatetimeStringSync=true&useCompression=true&log=false&allowMultiQueries=true&useLocalSessionState=true&cachePrepStmts=true&useSqlStringCache=true&extendOracleResultSetClass=true&// keyStore=&// keyStorePassword=, errorCode 1045, state 42000 java.sql.SQLSyntaxErrorException: Could not connect to 127.0.0.1:2881 : (conn=3221747089) Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES)
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:110) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:235) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1729) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.util.Utils.retrieveProxy(Utils.java:1436) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.OceanBaseConnection.newConnection(OceanBaseConnection.java:397) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.Driver.connect(Driver.java:93) ~[oceanbase-client-2.4.11.jar:?]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1682) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1803) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2928) ~[druid-1.2.22.jar:?]
Caused by: java.sql.SQLSyntaxErrorException: (conn=3221747089) Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES)
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:110) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:230) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:807) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:602) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1724) ~[oceanbase-client-2.4.11.jar:?]
... 6 more

2025-03-31 15:22:57 [INFO] Querying table column metadata, this might take a while...
2025-03-31 15:22:57 [WARN] Table: "TEST00" doesn't exist, skip it
2025-03-31 15:22:57 [WARN] No table to proceed for schema: "GISTAR"
2025-03-31 15:22:57 [ERROR] Load failed! Error: The base tables (non temporary) are not found in the schema: GISTAR. Please check the --table option!
2025-03-31 15:22:57 [ERROR] System exit 1
[admin@lnpg ~]$ obloader -h 127.0.0.1 -P 2881 -u gistar -p res#pwd --sys-user 'root@sys' --sys-password=linux123 -t lnzyob -D gistar --csv -f /db/ob/admin/an_odn_picture.csv --table test00^C
[admin@lnpg ~]$ obclient -h192.168.207.143 -P2881 -ugistar@lnzyob -pres#pwd -A
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221747128
Server version: OceanBase 3.2.4.1 (r101000052023010822-346aa35c32e99d1b82d713f75f0072c45bdf7aab) (Built Jan 8 2023 22:52:43)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient [GISTAR]> create table test00 as select * from an_odn_picture where 1<>1;
Query OK, 0 rows affected (0.219 sec)

obclient [GISTAR]> select count(*) from test00;
+----------+
| COUNT(*) |
+----------+
| 0 |
+----------+
1 row in set (0.015 sec)

obclient [GISTAR]> exit
Bye
[admin@lnpg ~]$ obloader -h 127.0.0.1 -P 2881 -u gistar -p res#pwd --sys-user 'root@sys' --sys-password=linux123 -t lnzyob -D gistar --csv -f /db/ob/admin/an_odn_picture.csv --table test00
2025-03-31 15:24:19 [INFO] Parsed args:
[--csv] true
[--file-path] /db/ob/admin/an_odn_picture.csv
[--host] 127.0.0.1
[--port] 2881
[--user] gistar
[--tenant] lnzyob
[--password] ******
[--database] gistar
[--sys-user] root@sys
[--sys-password] ******
[--table] [test00]

2025-03-31 15:24:19 [WARN] The Java version (1.8.0_221) you are currently using is not recommended. Recommended range: [1.8.0_300, 9.0.0)
2025-03-31 15:24:19 [INFO] Log files will be written to /db/ob/admin/logs
2025-03-31 15:24:19 [INFO] Trying to establish JDBC connection to `gistar@lnzyob`...
2025-03-31 15:24:19 [INFO] Sys-tenant credential is required (add `--no-sys` if you don't have one). Now trying to establish JDBC connection to `root@sys@sys`...
2025-03-31 15:24:19 [INFO] Server Mode: OBORACLE-3.2.4.1
2025-03-31 15:24:19 [ERROR] create connection SQLException, url: jdbc:oceanbase://127.0.0.1:2881/oceanbase?characterEncoding=utf8&socketTimeout=1800000&connectTimeout=1800000&zeroDateTimeBehavior=convertToNull&useServerPrepStmts=true&noDatetimeStringSync=true&useCompression=true&log=false&allowMultiQueries=true&useLocalSessionState=true&cachePrepStmts=true&useSqlStringCache=true&extendOracleResultSetClass=true&// keyStore=&// keyStorePassword=, errorCode 1045, state 42000 java.sql.SQLSyntaxErrorException: Could not connect to 127.0.0.1:2881 : (conn=3221747182) Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES)
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:110) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:235) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1729) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.util.Utils.retrieveProxy(Utils.java:1436) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.OceanBaseConnection.newConnection(OceanBaseConnection.java:397) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.Driver.connect(Driver.java:93) ~[oceanbase-client-2.4.11.jar:?]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1682) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1803) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2928) ~[druid-1.2.22.jar:?]
Caused by: java.sql.SQLSyntaxErrorException: (conn=3221747182) Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES)
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:110) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:230) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:807) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:602) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1724) ~[oceanbase-client-2.4.11.jar:?]
... 6 more

2025-03-31 15:24:19 [ERROR] create connection SQLException, url: jdbc:oceanbase://127.0.0.1:2881/oceanbase?characterEncoding=utf8&socketTimeout=1800000&connectTimeout=1800000&zeroDateTimeBehavior=convertToNull&useServerPrepStmts=true&noDatetimeStringSync=true&useCompression=true&log=false&allowMultiQueries=true&useLocalSessionState=true&cachePrepStmts=true&useSqlStringCache=true&extendOracleResultSetClass=true&// keyStore=&// keyStorePassword=, errorCode 1045, state 42000 java.sql.SQLSyntaxErrorException: Could not connect to 127.0.0.1:2881 : (conn=3221747183) Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES)
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:110) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:235) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1729) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.util.Utils.retrieveProxy(Utils.java:1436) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.OceanBaseConnection.newConnection(OceanBaseConnection.java:397) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.Driver.connect(Driver.java:93) ~[oceanbase-client-2.4.11.jar:?]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1682) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1803) ~[druid-1.2.22.jar:?]
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2928) ~[druid-1.2.22.jar:?]
Caused by: java.sql.SQLSyntaxErrorException: (conn=3221747183) Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES)
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:110) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:230) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:807) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:602) ~[oceanbase-client-2.4.11.jar:?]
at com.oceanbase.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1724) ~[oceanbase-client-2.4.11.jar:?]
... 6 more

2025-03-31 15:24:20 [INFO] Querying table column metadata, this might take a while...
2025-03-31 15:24:20 [INFO] Splitting data files into 64 MB logical chunks...
2025-03-31 15:24:20 [WARN] File /db/ob/admin/an_odn_picture.csv splitting error, remaining 653 bytes are skipped, please check the file content and settings. If it is a csv file, please check whether the --column-delimiter setting matches the file content
2025-03-31 15:24:20 [INFO] File: "/db/ob/admin/an_odn_picture.csv" has been split into 34 chunks. Elapsed: 717.8 ms
2025-03-31 15:24:20 [INFO] Split 1 data files to 34 logical chunks success. Elapsed: 725.5 ms
2025-03-31 15:24:20 [INFO] Bootstrap with Max Heap: 3 GB, Safe Heap: 3.09 GB
2025-03-31 15:24:20 [INFO] Querying primary/unique constraints metadata for data replacing...
2025-03-31 15:24:20 [ERROR] Load failed! Error: (conn=3221747183) Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES)
2025-03-31 15:24:20 [ERROR] System exit 1
[admin@lnpg ~]$ obloader -h 127.0.0.1 -P 2881 -u gistar -p res#pwd --sys-user 'root' --sys-password=linux123 -t lnzyob -D gistar --csv -f /db/ob/admin/an_odn_picture.csv --table test00
2025-03-31 15:25:39 [INFO] Parsed args:
[--csv] true
[--file-path] /db/ob/admin/an_odn_picture.csv
[--host] 127.0.0.1
[--port] 2881
[--user] gistar
[--tenant] lnzyob
[--password] ******
[--database] gistar
[--sys-user] root
[--sys-password] ******
[--table] [test00]

2025-03-31 15:25:39 [WARN] The Java version (1.8.0_221) you are currently using is not recommended. Recommended range: [1.8.0_300, 9.0.0)
2025-03-31 15:25:40 [INFO] Log files will be written to /db/ob/admin/logs
2025-03-31 15:25:40 [INFO] Trying to establish JDBC connection to `gistar@lnzyob`...
2025-03-31 15:25:40 [INFO] Sys-tenant credential is required (add `--no-sys` if you don't have one). Now trying to establish JDBC connection to `root@sys`...
2025-03-31 15:25:40 [INFO] Server Mode: OBORACLE-3.2.4.1
2025-03-31 15:25:40 [INFO] Querying table column metadata, this might take a while...
2025-03-31 15:25:40 [INFO] Splitting data files into 64 MB logical chunks...
2025-03-31 15:25:41 [WARN] File /db/ob/admin/an_odn_picture.csv splitting error, remaining 653 bytes are skipped, please check the file content and settings. If it is a csv file, please check whether the --column-delimiter setting matches the file content
2025-03-31 15:25:41 [INFO] File: "/db/ob/admin/an_odn_picture.csv" has been split into 34 chunks. Elapsed: 822.7 ms
2025-03-31 15:25:41 [INFO] Split 1 data files to 34 logical chunks success. Elapsed: 830.5 ms
2025-03-31 15:25:41 [INFO] Bootstrap with Max Heap: 3 GB, Safe Heap: 3.09 GB
2025-03-31 15:25:41 [INFO] Querying primary/unique constraints metadata for data replacing...
2025-03-31 15:25:41 [INFO] Query table entry for table: "TEST00" finished. Remain: 0
2025-03-31 15:25:41 [INFO] Query leader location of table: "TEST00" finished. Remain: 0
2025-03-31 15:25:41 [INFO] Waiting to calculate leader for 34 subfiles....
2025-03-31 15:25:44 [WARN] Ignore parse first record. File: "/db/ob/admin/an_odn_picture-25.csv". Error: Invalid char between encapsulated token and delimiter. Token Content：N�ˎ[�8
�vj(�Zr��x)6�}O�e�yo�<��4R��:)�/V�S�Dɚ�ĪG$A� ��u�_/��6v؛8n��.
��J��r��xo�h��::��D�-��GM�(
_��Ġ)�Д��+�� 3��-LG Li+e: [5,344]
2025-03-31 15:25:44 [WARN] Ig+-_e +he fi__+ ++++ _ec-_d. Fi+e: /db/-b/ad+i+/a+_-d+_-ic++_e-25.c_+
2025-03-31 15:25:44 [INFO] Wai+i+g +- _ef_e_h -b_e_+e_ +-ad _+a++_....
2025-03-31 15:25:44 [INFO] C_ea+e 1024 _+-+_ f-_ _i+g b+ffe_ fi+i_hed. [192.168.207.143:2881]
2025-03-31 15:25:44 [INFO] S+a_+ 32 da+aba_e +_i+e_ +h_ead_ fi+i_hed. [192.168.207.143:2881]
2025-03-31 15:25:44 [INFO] S+a_+ 32 _ec-_d fi+e _eade_ +h_ead_ _+cce__
2025-03-31 15:25:46 [ERROR] L-ad da+a fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-14.c_+" fai+ed. Rea_-+: I++a+id cha_ be++ee+ e+ca-_++a+ed +-+e+ a+d de+i+i+e_. T-+e+ C-++e++：��z#~�+�XO��Ҵ� Line: [427,54912].
2025-03-31 15:25:46 [ERROR] Fatal error occurred while loading data from "/db/ob/admin/an_odn_picture.csv" into table "GISTAR"."TEST00". Reason: Invalid char between encapsulated token and delimiter. Token Content：��z#~�v�XO��Ҵ� Line: [427,54912]
2025-03-31 15:25:47 [ERROR] Load data file: "/db/ob/admin/an_odn_picture-12.csv" failed. Reason: Invalid char between encapsulated token and delimiter. Token Content： Line: [411,50980].
2025-03-31 15:25:47 [ERROR] Fatal error occurred while loading data from "/db/ob/admin/an_odn_picture.csv" into table "GISTAR"."TEST00". Reason: Invalid char between encapsulated token and delimiter. Token Content： Line: [411,50980]
��E��3-31 15:25:47 [ERROR] Load data file: "/db/ob/admin/an_odn_picture-1.csv" failed. Reason: Invalid char between encapsulated token and delimiter. Token Content：��;ŀ�q��\�N��@�bK=�W�ېU�"�
ǃ��ҵ�-2`�A�Q�#␺\28�$�]J��Pc�� -:��g]|[�04�.>J8��3U��-6��k�x��)
s�Z2?�c��A�u ��n YWh�gUq��Z��
ot�2�>�ny8y��&X�Oa�&�M�F�E
�&��;p�نG�i+n.
q�G�W�7��7
s��4t Line: [601,75642].
2025-03-31 15:25:47 [ERROR] Fatal error occurred while loading data from "/db/ob/admin/an_odn_picture.csv" into table "GISTAR"."TEST00". Reason: Invalid char between encapsulated token and delimiter. Token��E��nt：��;ŀ�q��\�N��@�bK=�W�ېU�"�
ǃ��ҵ�-2`�A�Q�#␺\28�$�]J��Pc�� -:��g]|[�04�.>J8��3U��-6��k�x��)
s�Z2?�c��A�u ��n YWh�gUq��Z��
ot�2�>�ny8y��&X�Oa�&�M�F�E
�&��;p�نG�i+n.
q�G�W�7��7
s��4t Line: [601,75642]
2025-03-31 15:25:47 [ERROR] Load data file: "/db/ob/admin/an_odn_picture-31.csv" failed. Reason: Invalid char between encapsulated token and delimiter. Token Content：�e�� cl��+��
C��z�Yx�4�m$�� uɳ��|� Li+e: [216,23796].
2025-03-31 15:25:47 [ERROR] Fa+a+ e__-_ -cc+__ed +hi+e +-adi+g da+a f_-+ "/db/-b/ad+i+/a+_-d+_-ic++_e.c_+" i++- +ab+e "GISTAR"."TEST00". Rea_-+: I++a+id cha_ be++ee+ e+ca-_++a+ed +-+e+ a+d de+i+i+e_. T-+e+ C-++e++：�e�� c+��+��
C��z�Yx�4�m$�� uɳ��|� Li+e: [216,23796]
2025-03-31 15:25:47 [ERROR] L-ad da+a fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-3.c_+" fai+ed. Rea_-+: I++a+id cha_ be++ee+ e+ca-_++a+ed +-+e+ a+d de+i+i+e_. T-+e+ C-++e++：4,Θ �+�A$�
h$QA+��++�EH Li+e: [224,26892].
2025-03-31 15:25:47 [ERROR] Fa+a+ e__-_ -cc+__ed +hi+e +-adi+g da+a f_-+ "/db/-b/ad+i+/a+_-d+_-ic++_e.c_+" i++- +ab+e "GISTAR"."TEST00". Rea_-+: I++a+id cha_ be++ee+ e+ca-_++a+ed +-+e+ a+d de+i+i+e_. T-+e+ C-++e++：4,Θ �+�A$�
h$QA+��++�EH Li+e: [224,26892]
2025-03-%+L%��:�IX��!%��)�`�4�\��Xm|�4�4 ��=��j�OK�-��ɿ��J��^��J�;8��oɷ]k(��c{�Έ♍vV�_ZFt#�of��y�m��{/cha_ be�.��d~�rj�h4`�� ;�y��֏7#՟�h��E+i+i+e_. T-+e+ C-++e++：�d+Ռf?�U}F#1"��߭&��
9k��<&��hQod6��M"�Ԧ�d�g?��d�yу/��1��(�U}%�c]��W+2��44�{C�9G2TME��>��j�a�-F:��vu��û�gMɹR��T;��J��wC�J�]�97z�Dg!Mb7 (H�$�Y��5�I?yOZ?�x��mT%2f��J�I%�~b��Q�=�7H��f\&5�1�f�+�o�Zu�"��. i��
@�U�}�U�<s;4d6f��S��X�-�WǮ¥��y�X�_1��I��E^Ɇ��%�Ы�-�3�>>{��!��Ϩ[��d�Hm+-�u��$P��4�b,�E�bI�2ӄ��-�$�`��$�I�s��\�RP�sê� 2SFH�ه86|H�o(��ka��>L�m��&f;>�{L�؍��[.vP3�1��ʄa��o7� l0��II��.�\��7��:��]�
f?X�s��r��@�1<J�� Line: [266,35781].
2025-03-31 15:25:47 [ERROR] Fatal error occurred while loading data from "/db/ob/admin/an_odn_picture.csv" into table "GISTAR"."TEST00". Reason: Invalid char between encapsulated token and delimiter. Token Content%lL%��:�IX��!%��)�`�4�\��Xm|�4�4 ��=��j�OK�-��ɿ��J��^��J�;8��oɷ]k(��c{�Έ♍vV�_ZFt#�of��y�m��{/ �.��d~�rj�h4`�� ;�y��֏7#՟�h��E
9k��<&��hQod6��M"�Ԧ�d�g?��d�yу/��1��(�U}%�c]��W+2��44�{C�9G2TME��>��j�a�-F:��vu��û�gMɹR��T;��J��wC�J�]�97z�Dg!Mb7 (H�$�Y��5�I?yOZ?�x��mT%2f��J�I%�~b��Q�=�7H��f\&5�1�f�+�o�Zu�"��. i��
@�U�}�U�<s;4d6f��S��X�-�WǮ¥��y�X�_1��I��E^Ɇ��%�Ы�-�3�>>{��!��Ϩ[��d�Hm+-�u��$P��4�b,�E�bI�2ӄ��-�$�`��$�I�s��\�RP�sê� 2SFH�ه86|H�o(��ka��>L�m��&f;>�{L�؍��[.vP3�1��ʄa��o7� l0��II��.�\��7��:��]�
f?X�s��r��@�1<J�� Line: [266,35781]
2025-03-31 15:25:47 [INFO] File: "/db/ob/admin/an_odn_picture-21.csv" has been parsed finished
2025-03-31 15:25:47 [ERROR] Fatal error occurred while loading data from "/db/ob/admin/an_odn_picture.csv" into table "GISTAR"."TEST00". Reason: Too many bad records were found in file: /db/ob/admin/an_odn_picture.csv. See the bad record in "ob-loader-dumper.bad"
2025-03-31 15:25:47 [INFO] File: "/db/ob/admin/an_odn_picture-27.csv" has been parsed finished
2025-03-31 15:25:47 [INFO] File: "/db/ob/admin/an_odn_picture-7.csv" has been parsed finished
2025-03-31 15:25:47 [INFO] File: "/db/ob/admin/an_odn_picture-18.csv" has been parsed finished
2025-03-31 15:25:47 [INFO] File: "/db/ob/admin/an_odn_picture-11.csv" has been parsed finished
2025-03-31 15:25:47 [INFO] File: "/db/ob/admin/an_odn_picture-10.csv" has been parsed finished
2025-03-31 15:25:47 [INFO] File: "/db/ob/admin/an_odn_picture-13.csv" has been parsed finished
2025-03-31 15:25:47 [ERROR] Load data file: "/db/ob/admin/an_odn_picture-25.csv" failed. Reason: Invalid char between encapsulated token and delimiter. Token Content：N�ˎ[�8
�vj(�Zr��x)6�}O�e�yo�<��4R��:)�/V�S�Dɚ�ĪG$A� ��u�_/��6v؛8n��.
��J��r��xo�h��::��D�-��GM�(
_��Ġ)�Д��+�� 3��-LG Li+e: [5,344].
2025-03-31 15:25:47 [ERROR] Fa+a+ e__-_ -cc+__ed +hi+e +-adi+g da+a f_-+ "/db/-b/ad+i+/a+_-d+_-ic++_e.c_+" i++- +ab+e "GISTAR"."TEST00". Rea_-+: I++a+id cha_ be++ee+ e+ca-_++a+ed +-+e+ a+d de+i+i+e_. T-+e+ C-++e++：N�ˎ[�8
�++(�Z_��|)6�}O�e�y-�<��4R��:)�/V�S�Dɚ�ĪG$A� ��+�_/��6+؛8+��.
��J��_��|-�h��::��D�-��GM�(
_��Ġ)�Д��+�� 3��-LG Li+e: [5,344]
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-33.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-5.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-19.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-30.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-8.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-23.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-32.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-28.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-17.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-15.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-2.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-6.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-4.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-16.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-29.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-24.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-9.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-20.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-34.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [INFO] Fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-26.c_+" ha_ bee+ -a__ed fi+i_hed
2025-03-31 15:25:47 [ERROR] E__-_: I++a+id cha_ be++ee+ e+ca-_++a+ed +-+e+ a+d de+i+i+e_. T-+e+ C-++e++：N�ˎ[�8
�++(�Z_��|)6�}O�e�y-�<��4R��:)�/V�S�Dɚ�ĪG$A� ��+�_/��6+؛8+��.
��J��_��|-�h��::��D�-��GM�(
_��Ġ)�Д��+�� 3��-LG Li+e: [5,344]
2025-03-31 15:25:47 [ERROR] E__-_: I++a+id cha_ be++ee+ e+ca-_++a+ed +-+e+ a+d de+i+i+e_. T-+e+ C-++e++：4,Θ �+�A$�
h$QA+��++�EH Li+e: [224,26892]
2025-03-%+L%��:�IX��!%��)�`�4�\��Xm|�4�4 ��=��j�OK�-��ɿ��J��^��J�;8��oɷ]k(��c{�Έ♍vV�_ZFt#�of��y�m��{/�d+Ռf?��.��d~�rj�h4`�� ;�y��֏7#՟�h��E
9k��<&��hQod6��M"�Ԧ�d�g?��d�yу/��1��(�U}%�c]��W+2��44�{C�9G2TME��>��j�a�-F:��vu��û�gMɹR��T;��J��wC�J�]�97z�Dg!Mb7 (H�$�Y��5�I?yOZ?�x��mT%2f��J�I%�~b��Q�=�7H��f\&5�1�f�+�o�Zu�"��. i��
@�U�}�U�<s;4d6f��S��X�-�WǮ¥��y�X�_1��I��E^Ɇ��%�Ы�-�3�>>{��!��Ϩ[��d�Hm+-�u��$P��4�b,�E�bI�2ӄ��-�$�`��$�I�s��\�RP�sê� 2SFH�ه86|H�o(��ka��>L�m��&f;>�{L�؍��[.vP3�1��ʄa��o7� l0��II��.�\��7��:��]�
f?X�s��r��@�1<J�� Line: [266,35781]
2025-03-31 15:25:47 [ERROR] Error: Invalid char between encapsulated token and delimiter. Token Content：��z#~�v�XO��Ҵ� Line: [427,54912]
2025-03-31 15:25:47 [ERROR] Error: Invalid char between encapsulated token and delimiter. Token Content：�e�� cl��+��
C��z�Yx�4�m$�� uɳ��|� Li+e: [216,23796]
2025-03-31 15:25:47 [ERROR] E__-_: T-- +a+y bad _ec-_d_ +e_e f-++d i+ fi+e: /db/-b/ad+i+/a+_-d+_-ic++_e.c_+. See +he bad _ec-_d i+ "-b-+-ade_-d++-e_.bad"
2025-03-31 15:25:47 [ERROR] E__-_: I++a+id cha_ be++ee+ e+ca-_++a+ed +-+e+ a+d de+i+i+e_. T-+e+ C-++e++： Li+e: [411,50980]
��E��3-31 15:25:47 [ERROR] E__-_: I++a+id cha_ be++ee+ e+ca-_++a+ed +-+e+ a+d de+i+i+e_. T-+e+ C-++e++：��;ŀ�-��\�N��@�bK=�W�ېU�"�
ǃ��ҵ�-2`�A�Q�#␺\28�$�]J��Pc�� -:��g]|[�04�.>J8��3U��-6��k�x��)
s�Z2?�c��A�u ��n YWh�gUq��Z��
ot�2�>�ny8y��&X�Oa�&�M�F�E
�&��;p�نG�i+n.
q�G�W�7��7
s��4t Line: [601,75642]
2025-03-31 15:25:47 [INFO] ---------- Finished Tasks: 34 Running Tasks: 0 Progress: 100.00% ----------
2025-03-31 15:25:47 [INFO]

All Load Tasks Finished:

----------------------------------------------------------------------------------------------------------------------------
No.# | Type | Name | Count | Status
----------------------------------------------------------------------------------------------------------------------------
1 | TABLE | TEST00 | 1003 -> 0 | FAILURE
----------------------------------------------------------------------------------------------------------------------------

Total Count: 0 End Time: 2025-03-31 15:25:47

2025-03-31 15:25:47 [INFO] Load record finished. Total Elapsed: 7.678 s
2025-03-31 15:25:47 [ERROR] System exit 1
[admin@lnpg ~]$ obclient -h192.168.207.143 -P2881 -ugistar@lnzyob -pres#pwd -A
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221747380
Server version: OceanBase 3.2.4.1 (r101000052023010822-346aa35c32e99d1b82d713f75f0072c45bdf7aab) (Built Jan 8 2023 22:52:43)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient [GISTAR]> select count(*) from test00;
+----------+
| COUNT(*) |
+----------+
| 0 |
+----------+
1 row in set (0.000 sec)

obclient [GISTAR]> exit
Bye
[admin@lnpg ~]$ ls -lt
total 2245472
drwxrwxr-x 2 admin admin 142 Mar 31 15:25 logs
-rw-r--r-- 1 admin admin 2262497611 Mar 31 15:06 an_odn_picture.csv
-rw-r--r-- 1 root root 36831183 Mar 25 17:15 ora2ob-1.0.jar
-rw-rw-r-- 1 admin admin 58 Mar 20 09:59 3.sql
-rw-rw-r-- 1 admin admin 58 Mar 20 09:59 1.sql
-rw-rw-r-- 1 admin admin 55 Mar 20 09:48 2.sql
-rw-rw-r-- 1 admin admin 389 Mar 19 14:42 obloader_config.json
-rw-rw-r-- 1 admin admin 48 Mar 19 14:35 dict_sap.csv
-rwxrwxr-x 1 admin admin 224 Mar 19 14:19 getcsv.sh
-rw-rw-r-- 1 admin admin 3714 Mar 19 14:00 getddl.sql
-rwxrwxr-x 1 admin admin 275 Mar 19 11:35 tran.sh
drwxrwxr-x 3 admin admin 18 Mar 12 10:31 oradiag_admin
drwxrwxr-x 6 admin admin 231 Mar 10 16:08 log
drwxrwxr-x 2 admin admin 6 Mar 10 16:05 run
drwxrwxr-x 2 admin admin 178 Mar 10 16:05 audit
drwxrwxr-x 2 admin admin 6 Mar 10 15:53 etc
drwxrwxr-x 3 admin admin 28 Sep 26 2024 log1
drwxrwxr-x 3 admin admin 20 Sep 26 2024 1
[admin@lnpg ~]$ cd logs
[admin@lnpg logs]$ ll
total 1196
-rw-rw-r-- 1 admin admin 1187828 Mar 31 15:25 ob-loader-dumper.bad
-rw-rw-r-- 1 admin admin 11903 Mar 31 15:25 ob-loader-dumper.error
-rw-rw-r-- 1 admin admin 19277 Mar 31 15:25 ob-loader-dumper.info
-rw-rw-r-- 1 admin admin 1250 Mar 31 15:25 ob-loader-dumper.warn
[admin@lnpg logs]$ ls -lt
total 1196
-rw-rw-r-- 1 admin admin 11903 Mar 31 15:25 ob-loader-dumper.error
-rw-rw-r-- 1 admin admin 19277 Mar 31 15:25 ob-loader-dumper.info
-rw-rw-r-- 1 admin admin 1250 Mar 31 15:25 ob-loader-dumper.warn
-rw-rw-r-- 1 admin admin 1187828 Mar 31 15:25 ob-loader-dumper.bad
[admin@lnpg logs]$ more ob-loader-dumper.error
2025-03-31 15:22:57 [ERROR] Load failed! Error: The base tables (non temporary) are not found in the schema: GISTAR. Please check the --table option!
2025-03-31 15:22:57 [ERROR] System exit 1
2025-03-31 15:24:20 [ERROR] Load failed! Error: (conn=3221747183) Access denied for user 'root'@'xxx.xxx.xxx.xxx' (using password: YES)
2025-03-31 15:24:20 [ERROR] System exit 1
2025-03-31 15:25:46 [ERROR] Load data file: "/db/ob/admin/an_odn_picture-14.csv" failed. Reason: Invalid char between encapsulated token and delimiter. Token Content：��z#~�v�XO��Ҵ� Line: [427,54912].
2025-03-31 15:25:46 [ERROR] Fatal error occurred while loading data from "/db/ob/admin/an_odn_picture.csv" into table "GISTAR"."TEST00". Reason: Invalid char between encapsulated token and delimiter. Token
Content：��z#~�v�XO��Ҵ� Line: [427,54912]
2025-03-31 15:25:47 [ERROR] Load data file: "/db/ob/admin/an_odn_picture-12.csv" failed. Reason: Invalid char between encapsulated token and delimiter. Token Content： Line: [411,50980].
2025-03-31 15:25:47 [ERROR] Fatal error occurred while loading data from "/db/ob/admin/an_odn_picture.csv" into table "GISTAR"."TEST00". Reason: Invalid char between encapsulated token and delimiter. Token
Content： Line: [411,50980]
��E��3-31 15:25:47 [ERROR] Load data file: "/db/ob/admin/an_odn_picture-1.csv" failed. Reason: Invalid char between encapsulated token and delimiter. Token Content：��;ŀ�q��\�N��@�bK=�W�ېU�"�
8+��3:��^e=��[�;�<U�-!��
2025-03-31 15:25:47 [ERROR] Fa+a+ e__-_ -cc+__ed +hi+e +-adi+g da+a f_-+ "/db/-b/ad+i+/a+_-d+_-ic++_e.c_+" i++- +ab+e "GISTAR"."TEST00". Rea_-+: I++a+id cha_ be++ee+ e+ca-_++a+ed +-+e+ a+d de+i+i+e_. T-+e+
��E��++：��;ŀ�-��\�N��@�bK=�W�ېU�"�
8+��3:��^e=��[�;�<U�-!��
2025-03-31 15:25:47 [ERROR] L-ad da+a fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-31.c_+" fai+ed. Rea_-+: I++a+id cha_ be++ee+ e+ca-_++a+ed +-+e+ a+d de+i+i+e_. T-+e+ C-++e++：�e�� c+��+��
C��z�Yx�4�m$�� uɳ��|� Li+e: [216,23796].
2025-03-31 15:25:47 [ERROR] Fa+a+ e__-_ -cc+__ed +hi+e +-adi+g da+a f_-+ "/db/-b/ad+i+/a+_-d+_-ic++_e.c_+" i++- +ab+e "GISTAR"."TEST00". Rea_-+: I++a+id cha_ be++ee+ e+ca-_++a+ed +-+e+ a+d de+i+i+e_. T-+e+
C-++e++：�e�� c+��+��
C��z�Yx�4�m$�� uɳ��|� Li+e: [216,23796]
2025-03-31 15:25:47 [ERROR] L-ad da+a fi+e: "/db/-b/ad+i+/a+_-d+_-ic++_e-3.c_+" fai+ed. Rea_-+: I++a+id cha_ be++ee+ e+ca-_++a+ed +-+e+ a+d de+i+i+e_. T-+e+ C-++e++：4,Θ �+�A$�
h$QA+��++�EH Li+e: [224,26892].
2025-03-31 15:25:47 [ERROR] Fa+a+ e__-_ -cc+__ed +hi+e +-adi+g da+a f_-+ "/db/-b/ad+i+/a+_-d+_-ic++_e.c_+" i++- +ab+e "GISTAR"."TEST00". Rea_-+: I++a+id cha_ be++ee+ e+ca-_++a+ed +-+e+ a+d de+i+i+e_. T-+e+
C-++e++：4,Θ �+�A$�
h$QA+��++�EH Li+e: [224,26892]
2025-03-%+L%��:�IX��!%��)�`�4�\��Xm|�4�4 ��=��j�OK�-��ɿ��J��^��J�;8��oɷ]k(��c{�Έ♍vV�_ZFt#�of��y�m��{/cha_ be�.��d~�rj�h4`�� ;�y��֏7#՟�h��E+i+i+e_. T-+e+ C-++e++：�d+Ռf?�U}F#1"��߭&��
a�0�Z�mT%2f��J�I%�~b��Q�=�7H�
C�J�]�97z�Dg!Mb7 (H
@�U�}�U�<s;4d6f��S��X�-�WǮ¥��y�X�_1��I��E^Ɇ��%�Ы�-�3�>>{��!��Ϩ[��d�Hm+-�u��$P��4�b,�E�bI�2ӄ��-�$�`��$�I�s��\�RP�sê� 2SFH�ه86|H�o(��ka��II��.�\��7��:��]�^Lf?X�s��r��@�1<J�� Line: [266,35781].
2025-03-31 15:25:47 [ERROR] Fatal error occurred while loading data from "/db/ob/admin/an_odn_picture.csv" into table "GISTAR"."TEST00". Reason: Invalid char between encapsulated token and delimiter. Token
Content%lL%��:�IX��!%��)�`�4�\��Xm|�4�4 ��=��j�OK�-��ɿ��J��^��J�;8��oɷ]k(��c{�Έ♍vV�_ZFt#�of��y�m��{/ �.��d~�rj�h4`�� ;�y��֏7#՟�h��E
a�0�Z�mT%2f��J�I%�~b��Q�=�7H�
@�U�}�U�<s;4d6f��S��X�-�WǮ¥��y�X�_1��I��E^Ɇ��%�Ы�-�3�>>{��!��Ϩ[��d�Hm+-�u��$P��4�b,�E�bI�2ӄ��-�$�`��$�I�s��\�RP�sê� 2SFH�ه86|H�o(��ka��II��.�\��7��:��]�^Lf?X�s��r��@�1<J�� Line: [266,35781]
2025-03-31 15:25:47 [ERROR] Fatal error occurred while loading data from "/db/ob/admin/an_odn_picture.csv" into table "GISTAR"."TEST00". Reason: Too many bad records were found in file: /db/ob/admin/an_odn
_picture.csv. See the bad record in "ob-loader-dumper.bad"
2025-03-31 15:25:47 [ERROR] Load data file: "/db/ob/admin/an_odn_picture-25.csv" failed. Reason: Invalid char between encapsulated token and delimiter. Token Content：N�ˎ[�8
�vj(�Zr��x)6�}O�e�yo�<��
��J��r��xo�h��::��D�-��GM�(
_��Ġ)�Д
2025-03-31 15:25:47 [ERROR] Fa+a+ e__-_ -cc+__ed +hi+e +-adi+g da+a f_-+ "/db/-b/ad+i+/a+_-d+_-ic++_e.c_+" i++- +ab+e "GISTAR"."TEST00". Rea_-+: I++a+id cha_ be++ee+ e+ca-_++a+ed +-+e+ a+d de+i+i+e_. T-+e+
C-++e++：N�ˎ[�8
�++(�Z_��|)6�}O�e�y-�<��
��J��_��|-�h��::��D�-��GM�(
_��Ġ)�Д
2025-03-31 15:25:47 [ERROR] E__-_: I++a+id cha_ be++ee+ e+ca-_++a+ed +-+e+ a+d de+i+i+e_. T-+e+ C-++e++：N�ˎ[�8
�++(�Z_��|)6�}O�e�y-�<��
��J��_��|-�h��::��D�-��GM�(
_��Ġ)�Д
2025-03-31 15:25:47 [ERROR] E__-_: I++a+id cha_ be++ee+ e+ca-_++a+ed +-+e+ a+d de+i+i+e_. T-+e+ C-++e++：4,Θ �+�A$�
h$QA+��++�EH Li+e: [224,26892]
2025-03-%+L%��:�IX��!%��)�`�4�\��Xm|�4�4 ��=��j�OK�-��ɿ��J��^��J�;8��oɷ]k(��c{�Έ♍vV�_ZFt#�of��y�m��{/�d+Ռf?��.��d~�rj�h4`�� ;�y��֏7#՟�h��E
a�0�Z�mT%2f��J�I%�~b��Q�=�7H�
��
@�U�}�U�<s;4d6f��S��X�-�WǮ¥��y�X�_1��I��E^Ɇ��%�Ы�-�3�>>{��!��Ϩ[��d�Hm+-�u��$P��4�b,�E�bI�2ӄ��-�$�`��$�I�s��\�RP�sê� 2SFH�ه86|H�o(��ka��II��.�\��7��:��]�^Lf?X�s��r��@�1<J�� Line: [266,35781]
2025-03-31 15:25:47 [ERROR] Error: Invalid char between encapsulated token and delimiter. Token Content：��z#~�v�XO��Ҵ� Line: [427,54912]
2025-03-31 15:25:47 [ERROR] Error: Invalid char between encapsulated token and delimiter. Token Content：�e�� cl��+��
C��z�Yx�4�m$�� uɳ��|� Li+e: [216,23796]
2025-03-31 15:25:47 [ERROR] E__-_: T-- +a+y bad _ec-_d_ +e_e f-++d i+ fi+e: /db/-b/ad+i+/a+_-d+_-ic++_e.c_+. See +he bad _ec-_d i+ "-b-+-ade_-d++-e_.bad"
2025-03-31 15:25:47 [ERROR] E__-_: I++a+id cha_ be++ee+ e+ca-_++a+ed +-+e+ a+d de+i+i+e_. T-+e+ C-++e++： Li+e: [411,50980]
��E��3-31 15:25:47 [ERROR] E__-_: I++a+id cha_ be++ee+ e+ca-_++a+ed +-+e+ a+d de+i+i+e_. T-+e+ C-++e++：��;ŀ�-��\�N��@�bK=�W�ېU�"�
8+��3:��^e=��[�;�<U�-!��
[ad+i+@++-g +-g_]$
[ad+i+@++-g +-g_]$
[ad+i+@++-g +-g_]$
[ad+i+@++-g +-g_]$

参考：sqluldr2导出的几个问题_sqluldr2导出数据-CSDN博客

导出：

[oracle@lncs dmp]$ /home/oracle/sqluldr2 gistar/res#pwd@192.168.205.58:1521/lndb query="select * from an_odn_picture where length(PIC_CONTENT)>32000 and length(PIC_CONTENT)<=32500" NULL=\\\\N lob=FILE safe=yes file=an_odn_picture4.csv Charset=utf8 text=CSV head=no
0 rows exported at 2025-03-31 15:59:01, size 0 MB.
2105 rows exported at 2025-03-31 15:59:03, size 1 MB.
output file an_odn_picture4.csv closed at 2105 rows, size 1 MB.
[oracle@lncs dmp]$ ll
total 3638548
-rw-r--r-- 1 oracle oinstall 1245954866 Mar 31 14:50 an_odn_picture1.csv
-rw-r--r-- 1 oracle oinstall 0 Mar 31 14:59 an_odn_picture2.csv
-rw-r--r-- 1 oracle oinstall 67997120 Mar 31 15:34 an_odn_picture3.csv
-rw-r--r-- 1 oracle oinstall 739104 Mar 31 15:59 an_odn_picture4.csv
-rw-r--r-- 1 oracle oinstall 2262497611 Mar 31 14:47 an_odn_picture.csv
-rw-r--r-- 1 oracle oinstall 148633380 Mar 21 14:15 dict_premises_network.dmp
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0000
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0001
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0002
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0003
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0004
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0005
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0006
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0007
[oracle@lncs dmp]$ ls -lt
total 3638548
-rw-r--r-- 1 oracle oinstall 739104 Mar 31 15:59 an_odn_picture4.csv
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0007
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0006
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0004
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0005
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0003
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0002
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0000
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0001
-rw-r--r-- 1 oracle oinstall 67997120 Mar 31 15:34 an_odn_picture3.csv
-rw-r--r-- 1 oracle oinstall 0 Mar 31 14:59 an_odn_picture2.csv
-rw-r--r-- 1 oracle oinstall 1245954866 Mar 31 14:50 an_odn_picture1.csv
-rw-r--r-- 1 oracle oinstall 2262497611 Mar 31 14:47 an_odn_picture.csv
-rw-r--r-- 1 oracle oinstall 148633380 Mar 21 14:15 dict_premises_network.dmp
[oracle@lncs dmp]$ head an_odn_picture4.csv
3828948695,"2022-06-08 09:28:53","",\\N,\\N,"2489464868","ODN-鐭冲北闀囧ぇ閲戞潙48鍙风-01",1,1,3,2,1,"0",\\N,"2111","4042878175",\\N,\\N,\\N,\\N,\\N,"bad",\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N
3837042942,"2022-06-30 12:41:37","",\\N,\\N,"3463944834","ODN-(濡堝琛楁潙)杈戒腑鑲栧闂ㄩ晣濡堝琛楁潙(2-75-07)鎵╁绠5-2J",1,1,3,2,1,"0","ln-sw-ljc","2101","3826367934","2022-12-05 21:40:33","sunp8","瀛欓箯",\\N,1,"good",\\N,\\N,\\N,\\N,\\N,\\N,"2022-08-18 13:04:03",\\N,1,"2022-12-05 21:40:33","sunp8","瀛欓箯",\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N
3834076765,"2022-06-22 09:51:12","",\\N,\\N,"2554003884","ODN-鍑ゅ煄鐭冲煄瀛熷鏉凱77-10鍙锋潌-842",1,1,3,2,1,"0",\\N,"2106","3852392814",\\N,\\N,\\N,\\N,\\N,"bad",\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N
3832253407,"2022-06-17 13:16:12","",\\N,\\N,"2473456964","ODN-褰版鍘垮眬MA5800T涓崕璺2鍙锋ゼ3鍗曞厓",1,1,3,2,1,"0",\\N,"2109","3805270785","2022-12-13 17:15:22","liqf3","鏉庡簡宄\N,0,"bad",\\N,\\N,\\N,\\N,\\N,\\N,"2022-09-22 16:46:59",\\N,0,"2022-12-13 17:15:22","liqf3","鏉庡簡宄\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N
3837082293,"2022-06-30 14:01:25","",\\N,\\N,"1736371316","ODN-鍙板畨瑗夸經闀囧崡65鍙风",1,1,3,2,1,"0","ln-wentq","2103","3927094526",\\N,\\N,\\N,\\N,\\N,"part",\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N
3830979264,"2022-06-14 10:54:07","",\\N,\\N,"2529152386","ODN-鍑ゅ煄娌欓噷瀵ㄤ寒瀛愭渤P89鍙锋潌-608",1,1,3,2,1,"0",\\N,"2106","3824213045",\\N,\\N,\\N,\\N,\\N,"bad",\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N
3825711314,"2022-05-30 09:59:23","",\\N,\\N,"1800926427","ODN-澶嶅窞婀惧眬-瑁村悲26鍙B",1,1,3,2,1,"0",\\N,"2102","3865672526",\\N,\\N,\\N,\\N,\\N,"bad",\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N
3837289364,"2022-06-30 21:56:40","",\\N,\\N,"2605660558","ODN-02浜腑鏀眬琛ュ厖104",1,1,3,2,1,"0","ln-sw-bs","2112","2567457503","2022-11-30 12:41:36","jinye3","閲戝喍",\\N,1,"part",\\N,\\N,\\N,\\N,\\N,\\N,"2022-07-11 19:48:55",\\N,1,"2022-11-30 12:41:36","jinye3","閲戝喍",\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N
3832215079,"2022-06-17 10:55:59","",\\N,\\N,"2615180521","ODN-宸翠粈缃曞崡钀ュ瓙6闃",1,1,3,2,1,"0",\\N,"2114","3891055634",\\N,\\N,\\N,\\N,\\N,"bad",\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N
3832199530,"2022-06-17 10:53:19","",\\N,\\N,"1859707073","ODN-02鑰佸煄姘存瘉宸ョ▼24",1,1,3,2,1,"0",\\N,"2112","1857872153",\\N,\\N,\\N,\\N,\\N,"part",\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N,\\N
[oracle@lncs dmp]$

[oracle@lncs dmp]$ scp an_odn_picture34.csv admin@192.168.207.143:/db/ob/admin/
admin@192.168.207.143's password:
[oracle@lncs dmp]$ scp an_odn_picture4.csv admin@192.168.207.143:/db/ob/admin/
admin@192.168.207.143's password:
an_odn_picture4.csv 100% 722KB 721.8KB/s 00:00
[oracle@lncs dmp]$ scp LOB000* admin@192.168.207.143:/db/ob/admin/
admin@192.168.207.143's password:
LOB0000: Permission denied
LOB0001: Permission denied
LOB0002: Permission denied
LOB0003: Permission denied
LOB0004: Permission denied
LOB0005: Permission denied
LOB0006: Permission denied
LOB0007: Permission denied
[oracle@lncs dmp]$ scp LOB000* admin@192.168.207.143:/db/ob/admin/
admin@192.168.207.143's password:
LOB0000: Permission denied
LOB0001: Permission denied
LOB0002: Permission denied
LOB0003: Permission denied
LOB0004: Permission denied
LOB0005: Permission denied
LOB0006: Permission denied
LOB0007: Permission denied
[oracle@lncs dmp]$ ll
total 3638548
-rw-r--r-- 1 oracle oinstall 1245954866 Mar 31 14:50 an_odn_picture1.csv
-rw-r--r-- 1 oracle oinstall 0 Mar 31 14:59 an_odn_picture2.csv
-rw-r--r-- 1 oracle oinstall 67997120 Mar 31 15:34 an_odn_picture3.csv
-rw-r--r-- 1 oracle oinstall 739104 Mar 31 15:59 an_odn_picture4.csv
-rw-r--r-- 1 oracle oinstall 2262497611 Mar 31 14:47 an_odn_picture.csv
-rw-r--r-- 1 oracle oinstall 148633380 Mar 21 14:15 dict_premises_network.dmp
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0000
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0001
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0002
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0003
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0004
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0005
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0006
d--------- 2 oracle oinstall 4096 Mar 31 15:59 LOB0007
[oracle@lncs dmp]$ ll LOB0000
ls: cannot open directory LOB0000: Permission denied
[oracle@lncs dmp]$ chown -R oracle:oinstall LOB*
chown: cannot read directory `LOB0000': Permission denied
chown: cannot read directory `LOB0001': Permission denied
chown: cannot read directory `LOB0002': Permission denied
chown: cannot read directory `LOB0003': Permission denied
chown: cannot read directory `LOB0004': Permission denied
chown: cannot read directory `LOB0005': Permission denied
chown: cannot read directory `LOB0006': Permission denied
chown: cannot read directory `LOB0007': Permission denied
[oracle@lncs dmp]$ pwd
/oracle/dmp
[oracle@lncs dmp]$ exit
logout
[root@lncs ~]# chmod -R 777 /oracle/dmp/LOB*
[root@lncs ~]# scp -rp /oracle/dmp/LOB* admin@192.168.207.143:/db/ob/admin/
admin@192.168.207.143's password:
[root@lncs ~]#

导入：

[admin@lnpg ~]$ ll
total 2246196
drwxrwxr-x 3 admin admin 20 Sep 26 2024 1
-rw-rw-r-- 1 admin admin 58 Mar 20 09:59 1.sql
-rw-rw-r-- 1 admin admin 55 Mar 20 09:48 2.sql
-rw-rw-r-- 1 admin admin 58 Mar 20 09:59 3.sql
-rw-r--r-- 1 admin admin 739104 Mar 31 15:58 an_odn_picture4.csv
-rw-r--r-- 1 admin admin 2262497611 Mar 31 15:06 an_odn_picture.csv
drwxrwxr-x 2 admin admin 178 Mar 10 16:05 audit
-rw-rw-r-- 1 admin admin 48 Mar 19 14:35 dict_sap.csv
drwxrwxr-x 2 admin admin 6 Mar 10 15:53 etc
-rwxrwxr-x 1 admin admin 224 Mar 19 14:19 getcsv.sh
-rw-rw-r-- 1 admin admin 3714 Mar 19 14:00 getddl.sql
drwxrwxrwx 2 admin admin 6 Mar 31 15:59 LOB0000
drwxrwxrwx 2 admin admin 6 Mar 31 15:59 LOB0001
drwxrwxrwx 2 admin admin 6 Mar 31 15:59 LOB0002
drwxrwxrwx 2 admin admin 6 Mar 31 15:59 LOB0003
drwxrwxrwx 2 admin admin 6 Mar 31 15:59 LOB0004
drwxrwxrwx 2 admin admin 6 Mar 31 15:59 LOB0005
drwxrwxrwx 2 admin admin 6 Mar 31 15:59 LOB0006
drwxrwxrwx 2 admin admin 6 Mar 31 15:59 LOB0007
drwxrwxr-x 6 admin admin 231 Mar 10 16:08 log
drwxrwxr-x 3 admin admin 28 Sep 26 2024 log1
drwxrwxr-x 2 admin admin 142 Mar 31 15:25 logs
-rw-rw-r-- 1 admin admin 389 Mar 19 14:42 obloader_config.json
-rw-r--r-- 1 root root 36831183 Mar 25 17:15 ora2ob-1.0.jar
drwxrwxr-x 3 admin admin 18 Mar 12 10:31 oradiag_admin
drwxrwxr-x 2 admin admin 6 Mar 10 16:05 run
-rwxrwxr-x 1 admin admin 275 Mar 19 11:35 tran.sh
[admin@lnpg ~]$ obloader -h 127.0.0.1 -P 2881 -u gistar -p res#pwd --sys-user 'root' --sys-password=linux123 -t lnzyob -D gistar --csv -f /db/ob/admin/an_odn_picture4.csv --table test00
2025-03-31 16:02:53 [INFO] Parsed args:
[--csv] true
[--file-path] /db/ob/admin/an_odn_picture4.csv
[--host] 127.0.0.1
[--port] 2881
[--user] gistar
[--tenant] lnzyob
[--password] ******
[--database] gistar
[--sys-user] root
[--sys-password] ******
[--table] [test00]

2025-03-31 16:02:53 [WARN] The Java version (1.8.0_221) you are currently using is not recommended. Recommended range: [1.8.0_300, 9.0.0)
2025-03-31 16:02:53 [INFO] Log files will be written to /db/ob/admin/logs
2025-03-31 16:02:53 [INFO] Trying to establish JDBC connection to `gistar@lnzyob`...
2025-03-31 16:02:53 [INFO] Sys-tenant credential is required (add `--no-sys` if you don't have one). Now trying to establish JDBC connection to `root@sys`...
2025-03-31 16:02:53 [INFO] Server Mode: OBORACLE-3.2.4.1
2025-03-31 16:02:54 [INFO] Querying table column metadata, this might take a while...
2025-03-31 16:02:54 [INFO] Splitting data files into 64 MB logical chunks...
2025-03-31 16:02:54 [INFO] Split 1 data files to 1 logical chunks success. Elapsed: 11.19 ms
2025-03-31 16:02:54 [INFO] Bootstrap with Max Heap: 3 GB, Safe Heap: 3.09 GB
2025-03-31 16:02:54 [INFO] Querying primary/unique constraints metadata for data replacing...
2025-03-31 16:02:54 [INFO] Query table entry for table: "TEST00" finished. Remain: 0
2025-03-31 16:02:54 [INFO] Query leader location of table: "TEST00" finished. Remain: 0
2025-03-31 16:02:54 [INFO] Waiting to calculate leader for 1 subfiles....
2025-03-31 16:02:54 [INFO] Waiting to refresh observer load status....
2025-03-31 16:02:54 [INFO] Create 1024 slots for ring buffer finished. [192.168.207.143:2881]
2025-03-31 16:02:54 [INFO] Start 32 database writer threads finished. [192.168.207.143:2881]
2025-03-31 16:02:54 [INFO] Start 32 record file reader threads success
2025-03-31 16:02:54 [INFO] File: "/db/ob/admin/an_odn_picture4.csv" has been parsed finished
2025-03-31 16:02:54 [WARN] Retry Table: "TEST00", Partition: 0. Records: 65. Error: ORA-01858: a non-numeric character was found where a numeric was expected. Retry Mode: SERIAL.
2025-03-31 16:02:54 [WARN] Retry Table: "TEST00", Partition: 0. Records: 200. Error: ORA-01858: a non-numeric character was found where a numeric was expected. Retry Mode: SERIAL.
2025-03-31 16:02:54 [WARN] Retry Table: "TEST00", Partition: 0. Records: 200. Error: ORA-01858: a non-numeric character was found where a numeric was expected. Retry Mode: SERIAL.
2025-03-31 16:02:54 [WARN] Retry Table: "TEST00", Partition: 0. Records: 200. Error: ORA-01858: a non-numeric character was found where a numeric was expected. Retry Mode: SERIAL.
2025-03-31 16:02:54 [WARN] Retry Table: "TEST00", Partition: 0. Records: 200. Error: ORA-01858: a non-numeric character was found where a numeric was expected. Retry Mode: SERIAL.
2025-03-31 16:02:54 [WARN] Retry Table: "TEST00", Partition: 0. Records: 200. Error: ORA-01858: a non-numeric character was found where a numeric was expected. Retry Mode: SERIAL.
2025-03-31 16:02:54 [WARN] Retry Table: "TEST00", Partition: 0. Records: 200. Error: ORA-01858: a non-numeric character was found where a numeric was expected. Retry Mode: SERIAL.
2025-03-31 16:02:54 [WARN] Retry Table: "TEST00", Partition: 0. Records: 200. Error: ORA-01858: a non-numeric character was found where a numeric was expected. Retry Mode: SERIAL.
2025-03-31 16:02:54 [WARN] Retry Table: "TEST00", Partition: 0. Records: 200. Error: ORA-01858: a non-numeric character was found where a numeric was expected. Retry Mode: SERIAL.
2025-03-31 16:02:54 [WARN] Retry Table: "TEST00", Partition: 0. Records: 200. Error: ORA-01858: a non-numeric character was found where a numeric was expected. Retry Mode: SERIAL.
2025-03-31 16:02:54 [ERROR] Fatal error occurred while loading data from "/db/ob/admin/an_odn_picture4.csv" into table "GISTAR"."TEST00". Reason: Load data into "GISTAR"."TEST00" failed! NonRetryableException: Too many bad records. Table: "GISTAR"."TEST00"
2025-03-31 16:02:55 [ERROR] Error: Load data into "GISTAR"."TEST00" failed! NonRetryableException: Too many bad records. Table: "GISTAR"."TEST00"
2025-03-31 16:02:55 [INFO] ---------- Finished Tasks: 1 Running Tasks: 0 Progress: 100.00% ----------
2025-03-31 16:02:55 [INFO]

All Load Tasks Finished:

----------------------------------------------------------------------------------------------------------------------------
No.# | Type | Name | Count | Status
----------------------------------------------------------------------------------------------------------------------------
1 | TABLE | TEST00 | 2105 -> 0 | FAILURE
----------------------------------------------------------------------------------------------------------------------------

Total Count: 0 End Time: 2025-03-31 16:02:55

2025-03-31 16:02:55 [INFO] Load record finished. Total Elapsed: 1.494 s
2025-03-31 16:02:55 [ERROR] System exit 1
[admin@lnpg ~]$

相关文章：