I have set up a cloud database, the database is activated. I have reset the published sftp user which was sent by mail and a new user in APEX interface is created, the groups are attached.
Now for cloud new connection in SQL Developer
-> Username = my new created user
-> URL= https://database-trialabsw.db.us1.oraclecloudapps.com/apex/
-> SFTP-Username = provided by mail, password changed in Identity console
-> SFTP-Hostname = sftp.us1.cloud.oracle.com
When I want to connect, i am prompted with username set above, but if I enter the password which is set, a popup with this error message will be shown: Unexpected token NUMERIC_VALUE encountered
I have create user as document in "Data Movement...." and i have seen the blog from Kris, but same error. Can you help me?
Here is the error log from SQL Developer:
Unexpected token NUMERIC_VALUE encountered at oracle.dbtools.raptor.cloud.auth.basic.BasicAuthenticationHandler.readProperty(BasicAuthenticationHandler.java:221)
Edited by: user626582 on Oct 18, 2012 2:19 AM
What version of SQL Developer are you using? I believe the minimum rev is 3.2.10. I got a similar error with an earlier version of SQL Developer. Please let us know if this addresses the issue, and thanks.
- Rick Greenwald
Yes, that version will not work with the Database Cloud. You need to get the latest version here - http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index-098778.html.
- Rick Greenwald
I download the latest version, but when I try to make the connection I always get an "Invalid resource owner credentials". I have given the user admin, user and develop role and can login with the user via the web interface.
Is this path correct? https://database-trialabxn.db.us1.oraclecloudapps.com/apex/
Is there anything else from a security setup I need to do?