Please somebody can assist me how could I connect the new cloud connection
I have used the port 22 and SFTP user and host are all ok .. but the error which comes up when i try to connect is
"Peer not authenticated"
What version of Oracle SQL Developer are you using when attempting to create a Cloud Connection? While I could reproduce the "Peer not authenticated" error using version 3.2.10.09.53, I've no issues creating a connection using version 3.2.20.09.87, which is the latest release available for download from OTN, here: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html. If you're running an earlier version, then I would recommend downloading the latest and retry the steps.
What platform are you running SQL Developer on? I'm not aware of any platform-specific issues with Cloud connections, but I can follow up with the SQL Dev team to investigate further if necessary. Could you please verify that you've followed the necessary steps for creating such a connections, as outlined in the associated White Paper, here: www.oracle.com/technetwork/database/database-cloud/public/data-movement-wp-1844121.pdf?
I want to confirm that the user id asked in the popup for the new cloud connection , needs to be made in the Application Express in the online database service or is it User Id of the administrator?
I am running on windows platform..
Edited by: 998633 on Apr 8, 2013 11:34 AM
Edited by: 998633 on Apr 8, 2013 11:35 AM
I have followed all the steps written in the white paper , even I have created a new user using the Oracle Application Express and used the credentials but still it is of no good . I am getting the same error of 'Peer Not Authenticated' .Please help with this issue
Thanks for the updates. You've mentioned you're on Windows - is it 32-bit or 64-bit?
+> I want to confirm that the user id asked in the popup for the new cloud connection , needs to be made in the Application Express in the online database service or is it User Id of the administrator?+
As mentioned in the white paper:
"In order to perform these steps, the data load process uses two different users – one user defined for the Secure FTP (SFTP) site, and another defined to load the data in the Database Cloud Service. You can use any user who is a Service Administrator or Database Developer to load data into your Database Cloud Service. The SFTP user for your Database Cloud Service is identified in the My Services portal1 for the Database Cloud Service in the section label Service SFTP Details."
So the user login credentials you enter in the popup for the new Cloud connection should be "any user who is a Service Administrator or Database Developer". In the 'Welcome to Oracle Cloud' email that you received upon trial registration, the user defined under the 'Identity Domain Account Details' is your default Service Administrator. However, you can of course create additional Service Administrator users or indeed Database Developer users via the Identity Console. Log in to MyServices Administration URL (you'll find the URL in the 'Welcome to Oracle Cloud' email that you received upon trial registration), then select your database service, and click on the Identity Console button on the Services page. This will launch the IDM console, where you can manager the users and roles for your database service. To add a new Database Developer user, for example, you can do the following in Identity Console:
1) Click 'Manage Users' link from the left hand side bar
2) Click Search. You should then see a list of the existing users for your service. Among those users, you'll see your SFTP user. Ensure that you have reset the password for your SFTP user, as per the documentation.
3) Click Create, and enter the credentials for a new user
4) Upon successful creation of your new user, click 'Manager Roles' link from the left hand side bar
5) Click Search. You should then see a list of available roles for your service.
6) Select 'database Database Developer' from the list of available roles, and then click Assign.
7) In the Grant Role popup dialog, and click Search.
8) From the list of available users, select the new user you created in step 3 above. You'll now have a new Database Developer, whose credentials can be used in the creation of a Cloud Connection in SQL Developer.
Now in SQL Developer, ensure that your new Cloud Connection uses the following settings: Database Username: <enter name of user created in step 3 above OR enter your Service Administrator name> Database URL: <copy the "Service Home" URL from your 'Welcome to Oracle Cloud' email, and paste it here> e.g. https://database-trial_name.oraclecloudapps.com/apex/ SFTP Username: <enter name of your SFTP user, which you'll find on the Overview page in MyServices> ** you should have already reset the password for this user via Identity Console SFTP Hostname: <enter the SFTP host name, which you'll find on the Overview page in MyServices> SFTP Port: 22
When you attempt to connect to that new Cloud Connection, enter the username/password combo for the user you defined in 'Database Username' of the connection properties. My tests are on Windows 32-bit, and I've experienced no issues connecting using either my Service Administrator or Database Developer login credentials. So I'd be interested to find out whether you're running on 64-bit, which could potentially explain why you're seeing different results. Apologies if the above is overkill, but I figured it was worthwhile outlining the information for other interested parties viewing this thread too.
I am using Windows 7 - 64-bit platform .
I have even tried SFTP host along with the user to check that if the issue lies in the SFTP credentials , but thecredentials runs without any problem. Tried in WinSCP software.
I have followed the steps you have specified in the pretty detailed last post. But same is the issue *'Peer not Authenticated'*
I have tried the administrator credentials as well as tried with the new user created through Identity Console , but error comes is the same .
What JDK version are you using?
'Peer not Authenticated' indicates a failure in the SSL layer. SQL Developer requires an updated JDK 6 to correctly handle the Oracle root certificate. In general, it is recommended that customers upgrade to the latest JDK 6 if they are using the Cloud features of SQL Developer. So if you aren't running with an updated JDK 6, could you please upgrade and retry your Cloud connection and let me know how you get on.