tag:blogger.com,1999:blog-21122514.post347507858315389254..comments2024-03-23T11:05:13.046+01:00Comments on Dimitri Gielis Blog (Oracle Application Express - APEX): Free Oracle Cloud: 10. Running SQLcl and Datapump from the Compute Instance (VM) to ATPDimitri Gielishttp://www.blogger.com/profile/16295721159626839167noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-21122514.post-54611243942629165052021-02-15T12:53:23.601+01:002021-02-15T12:53:23.601+01:00A couple of points really:
Yes I can create a bac...A couple of points really:<br /><br />Yes I can create a backup file, but I don't seem to be able to use it. If I change the bucket specification to /files/ name for my bucket from /backup/ it seesm to work.<br /><br />I also had some issues around bad dump file spec, so I would include the version = parameter in the import and export commands.<br /><br />PaulPaul Hhttps://www.blogger.com/profile/09227367347227823449noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-82802825715750879952021-01-21T14:23:14.043+01:002021-01-21T14:23:14.043+01:00Hi Dimitri. Great blog post. I have everything wor...Hi Dimitri. Great blog post. I have everything working up until the IMPDP command When I run it I get the following error:<br /><br /><br />impdp admin/"mypassword"@dev01_high \ <br /> directory=data_pump_dir \ <br /> credential=DEF_CRED_NAME \<br /> dumpfile= https://objectstorage.changeme.oraclecloud.com/n/changme/b/backups/o/dev01/2021/01/2021-01-21-04-06/export%u.dmp \<br /> remap_schema=mdsouzaa:mdsouzab \<br /> parallel=1 \<br /> partition_options=merge \<br /> transform=segment_attributes:n \<br /> transform=dwcs_cvt_iots:y transform=constraint_use_default_index:y<br /><br /><br />Import: Release 19.0.0.0.0 - Production on Thu Jan 21 13:11:36 2021<br />Version 19.9.0.0.0<br /><br />Copyright (c) 1982, 2020, Oracle and/or its affiliates. All rights reserved.<br />Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production<br />ORA-39001: invalid argument value<br />ORA-39000: bad dump file specification<br />ORA-31640: unable to open dump file "/u03/dbfs/B683.../data/dpdump/expdat.dmp" for read<br />ORA-27037: unable to obtain file status<br />Linux-x86_64 Error: 2: No such file or directory<br />Additional information: 7<br /><br /><br /><br /><br />This kind of makes sense since my file is named "export01.dmp". I've tried explicitly listing the file as "export01.dmp" but still get the same error. Seems that it's looking for "expdat.dmp" Any ideas on how to resolve?<br /><br />Martin D'Souzahttps://www.blogger.com/profile/06992954599899886499noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-50540111558865094212020-09-30T11:04:47.212+02:002020-09-30T11:04:47.212+02:00Hi Dimitri. Awesome set of Posts.
Im running into...Hi Dimitri. Awesome set of Posts.<br /><br />Im running into an issue when I try and do an expdp.. Ive downloaded the same version of client as you.. Im getting the error below.<br /><br />[root@instance-20200304-1234 Downloads]# expdp admin@db202003031036_high schemas=vrs dumpfile=export%u.dmp<br /><br />Export: Release 18.0.0.0.0 - Production on Mon Sep 21 06:44:18 2020<br />Version 18.5.0.0.0<br /><br />Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved.<br />Password:<br /><br />Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production<br /><br />UDE-31626: operation generated ORACLE error 31626<br />ORA-31626: job does not exist<br />ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79<br />ORA-06512: at "SYS.DBMS_DATAPUMP", line 4749<br />ORA-04063: package body "SYS.KUPU$UTILITIES" has errors<br />ORA-06508: PL/SQL: could not find program unit being called: "SYS.KUPU$UTILITIES"<br />ORA-06512: at "SYS.DBMS_DATAPUMP", line 4453<br />ORA-06512: at "SYS.DBMS_DATAPUMP", line 6127<br />ORA-06512: at line 1<br /><br />This tells me something hasn't been setup or configured correctly on the ATP instance to do an export. Iv asked the question on the cloud forum, but not got any answers. Do you have any ideas? <br /><br />Many Thanks<br />RichardRichardLhttps://www.blogger.com/profile/09306966522237305577noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-89642454114197514522020-02-12T17:47:55.633+01:002020-02-12T17:47:55.633+01:00Dimitri,
I am trying to apply your sql connection...Dimitri,<br /><br />I am trying to apply your sql connection steps to a an exadata express database from a free VM<br />Thus installing the basic and tool package (18.3) on the free VM<br />installing sqlcl (19.4)<br />ln -s /opt/sqlcl/bin/sql /usr/lib/oracle/18.3/client64/bin/sql<br />unzip my credentails within /usr/lib/oracle/18.3/client64/lib/network/admin<br />change the content of sqlnet.ora in<br />WALLET_LOCATION = (SOURCE = (METHOD = file)<br /> (METHOD_DATA = (DIRECTORY="/usr/lib/oracle/18.3/client64/lib/network/admin")))<br />SSL_SERVER_DN_MATCH=yes<br /><br />Adding the env settings to .bash_profile of the opc user<br />reconnect as opc<br />and then on the command line:<br />plato@dbaccess (the named entry within the unzipped tnsnames.ora)<br /><br />result in<br /><br />Password? (**********?) *****<br /> USER = plato<br /> URL = jdbc:oracle:thin:@(description= (address=(protocol=tcps)(port=1522)(host=<>)) (connect_data=(service_name=<>)) (security=(ssl_server_cert_dn="CN=<>,O=Oracle Corporation,L=Redwood Shores,ST=California,C=US")) )<br /> Error Message = IO Error: IO Error General SSLEngine problem, Authentication lapse 0 ms.<br />Username? (RETRYING) ('plato/*********@dbaccess'?)<br /><br />!!For obvious reasons I have scrambled the host name and service name!!<br /><br />Any ideas?<br /><br />Frank Brinkhttps://www.blogger.com/profile/17589977584796010412noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-43191108167598692162019-11-14T07:16:53.532+01:002019-11-14T07:16:53.532+01:00Hello!
Excellent post as usual. Thank you for your...Hello!<br />Excellent post as usual. Thank you for your efforts!<br /><br />After trial period code for loading from DATA_PUMP_DIR to backup raises the following error:<br /><br />Error report -<br />ORA-20000: Unable to access directory object - ORA-01857: not a valid time zone - DATA_PUMP_DIR<br />ORA-06512: in "C##CLOUD$SERVICE.DBMS_CLOUD", line 598<br />ORA-06512: in "C##CLOUD$SERVICE.DBMS_CLOUD", line 1718<br />ORA-06512: in line 2<br />ORA-06512: in line 2<br />20000. 00000 - "%s"<br />*Cause: The stored procedure 'raise_application_error'<br /> was called which causes this error to be generated.<br />*Action: Correct the problem as described in the error message or contact<br /> the application administrator or DBA for more information.<br /><br />Any ideas?<br /><br />Thank you!<br />Nik SaridakisΝικόλαος Σαριδάκηςhttps://www.blogger.com/profile/18321601637618271079noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-84656322259572803722019-10-30T13:47:06.703+01:002019-10-30T13:47:06.703+01:00Hi Dimitri!
Very usefull guide! I'm not famil...Hi Dimitri!<br /><br />Very usefull guide! I'm not familiar with Linux and by the way learn it. All goes well (download to bucket, upload) until I reconnect to VM. Now I can't use CLI:<br /><br />[root@my-server opc]# /root/bin/oci --help<br />Traceback (most recent call last):<br /> File "/root/bin/oci", line 5, in <br /> from oci_cli.cli import cli<br /> File "/root/lib/oracle-cli/lib/python2.7/site-packages/oci_cli/__init__.py", line 10, in <br /> from oci import fips<br /> File "/root/lib/oracle-cli/lib/python2.7/site-packages/oci/__init__.py", line 4, in <br /> from . import announcements_service, audit, autoscaling, budget, container_engine, core, database, dns, dts, email, events, file_storage, functions, healthchecks, identity, key_management, limits, load_balancer, monitoring, object_storage, oce, oda, ons, resource_manager, resource_search, streaming, waas, work_requests<br /> File "/root/lib/oracle-cli/lib/python2.7/site-packages/oci/announcements_service/__init__.py", line 7, in <br /> from .announcement_client import AnnouncementClient<br /> File "/root/lib/oracle-cli/lib/python2.7/site-packages/oci/announcements_service/announcement_client.py", line 6, in <br /> from oci._vendor import requests # noqa: F401<br /> File "/root/lib/oracle-cli/lib/python2.7/site-packages/oci/_vendor/__init__.py", line 4, in <br /> from . import chardet # noqa: F401<br /> File "/root/lib/oracle-cli/lib/python2.7/site-packages/oci/_vendor/chardet/__init__.py", line 24, in <br /> from .universaldetector import UniversalDetector<br /> File "/root/lib/oracle-cli/lib/python2.7/site-packages/oci/_vendor/chardet/universaldetector.py", line 17, in <br /> import logging<br /> File "/opt/rh/python27/root/usr/lib64/python2.7/logging/__init__.py", line 26,in <br /> import sys, os, time, cStringIO, traceback, warnings, weakref, collections<br /> File "/opt/rh/python27/root/usr/lib64/python2.7/weakref.py", line 14, in <br /> from _weakref import (<br />ImportError: cannot import name _remove_dead_weakref<br /><br />Could you help me?<br /><br />Greetengs from Poland!<br />AndrzejAndrzejnoreply@blogger.comtag:blogger.com,1999:blog-21122514.post-11943871308515986552019-10-19T04:52:16.505+02:002019-10-19T04:52:16.505+02:00Awesome stuff! Much better than the original docum...Awesome stuff! Much better than the original documentation!<br /><br /><br />OmarOmar Shubeilathttps://www.blogger.com/profile/17303298495066457041noreply@blogger.comtag:blogger.com,1999:blog-21122514.post-36599162375882929542019-10-01T23:14:33.659+02:002019-10-01T23:14:33.659+02:00Great guide, well written.
One question,for sqlplu...Great guide, well written.<br />One question,for sqlplus or impdp; do we need the wallet file or is there a simpler way with a direct connection string?Sokoshttps://www.blogger.com/profile/02924045385567511422noreply@blogger.com