![]() ![]() ![]() All goes well (download to bucket, upload) until I reconnect to VM. Very usefull guide! I'm not familiar with Linux and by the way learn it. You can download the software for the different operating systems, but as our VM is running Oracle Linux we can install it with just a few commands:įirst, update yum so it's smarter where to find Oracle software: In order to connect to an Oracle database from a machine, we will use the Oracle Instant Client software. It also makes it easier to follow as we only have to focus on how to install the Oracle Tools on Linux. Especially when we want to automate something, it's easier to do this from another machine in the cloud. In the previous post, we installed the command line tools of the Oracle Cloud on our own machine, but for the Oracle Tools, I prefer to install them on our Compute Instance in the Cloud. In this post, we will install and use SQLcl and Datapump from the Compute Instance (VM) connecting to our Oracle Database in the Autonomous Transaction Processing (ATP) Cloud.Īlthough I use most of the time SQL Developer to connect to the database, I find it important to be able to use command-line tools too, as this is what you can automate and it's really fast. ![]() O/S-Error: (OS 1326) Logon failure: unknown user name or bad password.This post is part of a series of blog posts on the Best and Cheapest Oracle APEX hosting: Free Oracle Cloud. ORA-31640: unable to open dump file "\\Yeti\Temp\johnsdata\DATAMART131.DP_DMP" for read With the Partitioning, OLAP and Data Mining options Impdp system/mypassword DIRECTORY=DATA_PUMP_DIR DUMPFILE=YETI:DATAMART131.DP_DMPĬonnected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Produc The command line and ensuing errors are below: The following steps have been taken:ġ) Established a DIRECTORY object DATA_PUMP_DIR and verified that it worksĢ) Used "Map Network Drive" to create a connection to the shared file folder on the Linux Server and verified that I could see the files from Windowsģ) Established a DIRECTORY object YETI for the mapped network driveĤ) To test that the dumpfile itself was readable, copied one to the Windows Server and was able to use impdp against it.ĥ) Had the Windows Network Admin give all privileges to everyone on the Linux shared file folder We are attempting to use impdp from a Windows 2003 Server with Oracle release 10.2.0.3 installed. Our customer has delivered Data Pump dumpfiles to a Linux Server where Oracle is not installed. 1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.9K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |