{"id":101,"date":"2020-11-28T14:40:11","date_gmt":"2020-11-28T14:40:11","guid":{"rendered":"http:\/\/blog.tutschonwieder.net\/?p=101"},"modified":"2020-11-28T14:40:32","modified_gmt":"2020-11-28T14:40:32","slug":"pump-your-database-in-the-cloud","status":"publish","type":"post","link":"https:\/\/blog.tutschonwieder.net\/index.php\/2020\/11\/28\/pump-your-database-in-the-cloud\/","title":{"rendered":"Pump your database to the Cloud"},"content":{"rendered":"\n

Oracle Always Free ATP cloud is a nice alternative to a self-hosted XE environment.<\/p>\n\n\n\n

But how can I get my data inside the ATP database?<\/p>\n\n\n\n

DataPump can help with this task.<\/p>\n\n\n\n

In the first step, you have to create a Object Storage Bucket where can store your DataPump-Dumpfile. To create a new Bucket, simply click on the Quick Action “Store Data” on your Cloud dashboard or select “Object Storage” from the menu:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

On the next page, you’ll get an overview of your storage buckets. Here you can create your new bucket via the button “Create Bucket”. Give this bucket a descriptive name and simply leave the defaults as they are. Then hit “Create Bucket”:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

After you select the bucket, you get an overview of the bucket details and also the contained files, which are – of course – none at the moment:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The next step us uploading your Datapump Dumpfile – just press the Upload-button, select the file and wait until the upload is finished.<\/p>\n\n\n\n

The next step is to create a “Pre-Authentication Request”, which is a URL containing the access token to the dumpfile, so you don’t have to care about authentication.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Upon creation of the PAR, you’ll be presented the unique link – copy it, it can only be shown once.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

The next step is to prepare your local environment for the execution of the dpimp tool, which is shown on a Linux system here.<\/p>\n\n\n\n

Set the environment variable TNS_ADMIN<\/code> to point to the directory where you unzipped your ATP Credential-Wallet:<\/p>\n\n\n\n

export TNS_ADMIN=\/path\/to\/your_unzipped_wallet<\/code><\/p>\n\n\n\n

The next step is to actually run the dpimp on your local machine – to do so, please replace the string “<<INSTANCE_NAME>><\/code>” and the string “<<PRE-AUTHENTICATED_REQUEST_URL>><\/code>” with the PAR-Url from two steps above. If prompted, enter your admin<\/code> password for your ATP instance.<\/p>\n\n\n\n

impdp admin@<<INSTANCE_NAME>>_high directory=data_pump_dir credential=def_cred_name dumpfile=<<PRE-AUTHENTICATED_REQUEST_URL>> parallel=8 transform=segment_attributes:n exclude=cluster,db_link,user,tablespace_quota,default_role<\/code><\/p>\n\n\n\n

Although the PAR-URLs are unique and quite safe, it’s a good idea to drop the Pre-Authenticated after the import is done.<\/p>\n\n\n\n

More detailed instructions to use DataPump in the cloud and an approach without the use of Pre-Authenticated Request-URLs can be found on fuzziebrain’s blog<\/a> and on Dimitri’s blog<\/a>.<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle Always Free ATP cloud is a nice alternative to a self-hosted XE environment. But how can I get my data inside the ATP database? DataPump can help with this task. In the first step, you have to create a Object Storage Bucket where can store your DataPump-Dumpfile. To create a new Bucket, simply click […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[2,18],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.tutschonwieder.net\/index.php\/wp-json\/wp\/v2\/posts\/101"}],"collection":[{"href":"https:\/\/blog.tutschonwieder.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.tutschonwieder.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.tutschonwieder.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.tutschonwieder.net\/index.php\/wp-json\/wp\/v2\/comments?post=101"}],"version-history":[{"count":6,"href":"https:\/\/blog.tutschonwieder.net\/index.php\/wp-json\/wp\/v2\/posts\/101\/revisions"}],"predecessor-version":[{"id":113,"href":"https:\/\/blog.tutschonwieder.net\/index.php\/wp-json\/wp\/v2\/posts\/101\/revisions\/113"}],"wp:attachment":[{"href":"https:\/\/blog.tutschonwieder.net\/index.php\/wp-json\/wp\/v2\/media?parent=101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.tutschonwieder.net\/index.php\/wp-json\/wp\/v2\/categories?post=101"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.tutschonwieder.net\/index.php\/wp-json\/wp\/v2\/tags?post=101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}