Skip to Main Content

Application Development Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Issue adding navigation Link into portal navigation

Kingsley RajamaniFeb 20 2018 — edited Feb 21 2018

We just migrated WCP from 11.1.1.7.0 to 11.1.1.9.0. After migration, I am not able add a link with relative URL. Please see the image. Any thoughts?

pastedImage_0.png

Comments

Christian.Shay -Oracle
Answer

Hi Scott,

We don't support that syntax yet, but in the meantime you can do the following to connect proxy users:

  • To connect to Oracle Database from a .SQL or .PL/SQL file, press F1 to open Command Palette and select Oracle:Connect from the dropdown
  • To connect from Oracle Database Explorer, click the plus sign button
  • A connection dialog will open. In the Connection Type dropdown, select ODP.NET Connect String
  • In the Connection String field, enter a string with this format if providing the hostname, port and service name explicitly: User Id=myuser;Data Source=dbhostname:1521/DBSERVICENAME;Proxy User Id=myproxyuser;Proxy Password=myproxypass;
  • If using a TNS Alias, enter a connect string with this format: User Id=myuser;Data Source=mytnsalias;Proxy User Id=myproxyuser;Proxy Password=myproxypass;
  • Provide a connection name to be used to reference this connection in Database Explorer and elsewhere
  • Click the Create Connection button

For more tips, see the quickstart:

https://www.oracle.com/database/technologies/appdev/dotnet/odtvscodequickstart.html

Marked as Answer by Scott · Oct 6 2019
Scott

Perfect - that worked like a charm!

- Scott -

Hi Scott,
In our newest 19.3.3 release we made it a lot easier to connect using a proxy user. Please try it out and let me know any feedback about the release!
(In any connection dialog, check the Show more options checkbox and provide the proxy username and password)

User_6BTKC

Hello,
Am I being dense with the new dialog
In the examples here
alter user hr grant connect through scott;
connect scott[hr]/tiger
in the new dialog should I be entering scott in user name and scott[hr] in the proxy user name?

User_6BTKC

Ignore me all i was being dense. The proper syntax in the new dialog is
EX alter user hr grant connect through scott;
It is to place the target user HR in user name, and scott and scott's password in the new proxy user fields.

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 21 2018
Added on Feb 20 2018
7 comments
185 views