Tag Archives: oracle19c

[Solved] ORA-04063: package body “SYS.DBMS_DATAPUMP“ has errors

Due to the manual modification of the default parameter value of cluster_ok in start_job of sys.DBMS_DATAPUMP, 1 is 0, which leads to export error after successful compilation.
ORA-04063: package body “SYS.DBMS_DATAPUMP” has errors
SQL> CREATE TABLE “test”
2  (       ”   ” VARCHAR2(255), “YPID” VARCHAR2(255));
Table created.
SQL> insert into “test”  values(‘aa’,’bb’);
1 row created.
SQL> commit;
Commit complete.
SQL> select * from test;

——————————————————————————–
YPID
——————————————————————————–
aa
bb

SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0

[oracle@oem ~]$ expdp jyc/jyc@jyc dumpfile=t.dmp logfile=t.log directory=dmp tables=jyc.test
Export: Release 19.0.0.0.0 – Production on Tue Jun 29 16:54:57 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
UDE-04063: operation generated ORACLE error 4063
ORA-04063: package body “SYS.DBMS_DATAPUMP” has errors
ORA-06508: PL/SQL: could not find program unit being called: “SYS.DBMS_DATAPUMP”
ORA-06512: at line 1
[oracle@oem ~]$ sqlplus jyc/jyc@jyc
SQL*Plus: Release 19.0.0.0.0 – Production on Tue Jun 29 16:57:00 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Last Successful login time: Tue Jun 29 2021 16:54:57 +08:00
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0
SQL> select * from dba_errors where OWNER=’SYS’ and NAME=’DBMS_DATAPUMP’;
OWNER
——————————————————————————–
NAME
——————————————————————————–
TYPE                                     SEQUENCE       LINE   POSITION
————————————– ———- ———- ———-
TEXT
——————————————————————————–
ATTRIBUTE          MESSAGE_NUMBER
—————— ————–
SYS
DBMS_DATAPUMP
PACKAGE BODY                                    1       7294         17
OWNER
——————————————————————————–
NAME
——————————————————————————–
TYPE                                     SEQUENCE       LINE   POSITION
————————————– ———- ———- ———-
TEXT
——————————————————————————–
ATTRIBUTE          MESSAGE_NUMBER
—————— ————–
PLS-00593: default value of parameter “CLUSTER_OK” in body must match that of sp
ec
ERROR                         593
OWNER
——————————————————————————–
NAME
——————————————————————————–
TYPE                                     SEQUENCE       LINE   POSITION
————————————– ———- ———- ———-
TEXT
——————————————————————————–
ATTRIBUTE          MESSAGE_NUMBER
—————— ————–

SQL>
select * from dba_objects where status = ‘INVALID’
select owner, name, text, message_number from all_errors where owner=’SYS’;

Solution:
Execute rebuild dbms_datapump under cdb
cd $ORACLE_HOME/rdbms/admin
sqlplus/as sysdba
@dbmsdp.sql;
@utlrp.sql;
exit
Redirection is normal.
[oracle@oem admin]$ expdp jyc/jyc@jyc dumpfile=t.dmp logfile=t.log directory=dmp tables=jyc.test
Export: Release 19.0.0.0.0 – Production on Thu Jul 1 10:29:24 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
FLASHBACK automatically enabled to preserve database integrity.
Starting “JYC”.”SYS_EXPORT_TABLE_01″:  jyc/********@jyc dumpfile=t.dmp logfile=t.log directory=dmp tables=jyc.test
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
Processing object type TABLE_EXPORT/TABLE/PROCACT_INSTANCE
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported “JYC”.”TEST”                                    0 KB       0 rows
Master table “JYC”.”SYS_EXPORT_TABLE_01″ successfully loaded/unloaded
******************************************************************************
Dump file set for JYC.SYS_EXPORT_TABLE_01 is:
/home/oracle/dmp/t.dmp
Job “JYC”.”SYS_EXPORT_TABLE_01″ successfully completed at Thu Jul 1 10:29:32 2021 elapsed 0 00:00:08

[Solved] IO Error: The Network Adapter could not establish the connection

IO Error: The Network Adapter could not establish the connection
The Network Adapter could not establish the connection
The Network Adapter could not establish the connection
Connection timed out: connect, socket connect lapse 21004 ms. /10.10.10.3 1521 0 1 true
Connection timed out: connect, socket connect lapse 21004 ms. /10.10.10.3 1521 0 1 true
Connection timed out: connect
Connection timed out: connect

the database is 19C   rac   PDB environment, the current test even one of the VIP address, through the VPN, sqlplus and PL/SQL tools can connect to the database, but with Oracle   sql   The developer tool reported an error. Later, it tried dbeaver and dbvisualizer. It’s strange.

When using the dbeaver tool, we find that the connection is jdbc:oracle :thin

Think of these tools to go is it, so query

By searching jdbc:oracle : the network adapter could not establish the connection

Find the configuration file below:

Add this   Addvmoption – DJava. Net. Preferipv4stack = true restart the client tool and connect again successfully.

relevant:
Dbeaver is modified as follows: dbeaver.ini

add to

-Djava.net.preferIPv4Stack=true

invalid connection string format, a valid format is host:ip:port

After Oracle 11.2.0.4 database is upgraded to 19C, the original interface program reports an error: invalid connection string format, a valid format is host:ip :port

The reason is: Java variables refer to classes12. Jar and Ojdbc14. Jar, which leads to conflicts

Solution: after removing classes12. Jar, it will be normal.

In addition, the program should use JDK1.8 and ojdbc8.jar or above synchronously, which is a big change.

Relevant information:

The driver package classes12.jar is used for JDK 1.2 and JDK 1.3, while ojdbc14.jar is used for JDK 1.4

https://sqlora.blog.csdn.net/article/details/112985085