We are trying the trail version of the Oracle Database Cloud Service and having problems during deployment through SQLDeveloper and data export from the cloud.
With SQLDeveloper we have a working cloud connection. We created a cart from an existing application and uploaded the deployment. No errors!
The deployment has the status 'APPROVED' but is not processing in the database. The file uploaded to the FTP server (I can see it using a FTP client).
There is also a problem exporting the data from the cloud database by the Oracle cloud service website.
The site says that the data is exported, but on the FTP site no file is created.
Looks like the FTP locations of the Database cloud does not correspond to the locations that belong to the FTP users.
Now I can't deploy anymore because a deployment connection is refused: SQLDeveloper cloud connection works fine, but when I want to deploy the cart I get the message: Invalid SFTP Parameters, Unable to connect to sftp server with provided details.
I changed the password of both SFTP users, hoped I made a mistake. I can connect to the SFTP site by WinSCP, but connections through SQLDeveloper (deploy cart) are refused.
You wrote that I should be using service instance SFTP and not Identity Domain SFTP.
I have 2 trailxxx sftp users, but both only have the 'Identity domain SFTP user' role. I can't add/see the service instance SFTP role you described.
I hope you can help me with that one also?
Data export is working now. I didn't change anything, but thanks for that. I see updated info in cloud service status history also. It changed from 0% to 100%.
Depoy is working now. The settings for SFTP connection (host and port) where wrong. Also a reset of the password of the SFTP user was necessary. It worked before so I though this couldn't be the problem.