Skip to Main Content
Forums

ORDS, SODA & JSON in the Database

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!

Delete or Modify Resource Template + Handler with code

John HowardAug 8 2022

Hello ORDS gurus,
I have a requirement to automate, as much as possible, the deployment of my ORDS config across a number of environments. To that end I would like to be able to modify or delete a template+handler pair with code rather than interactively with SQL Developer. I am using DEFINE_TEMPLATE and DEFINE_HANDLER to create. I am using ORDS 21.4.
Looking at the definition of the ORDS package I can't see any obvious way of doing this. There are no procedures for DELETE_HANDLER or DELETE_TEMPLATE. It is clearly possible to do this as you can do it with SQL Developer.
Is there any secret way or can it only be done by clicking through the gui?
Thanks,
John
This post has been answered by thatJeffSmith-Oracle on Aug 8 2022
Jump to Answer

Comments

sb92075

How do I ask a question on the forums?

https://forums.oracle.com/message/9362002#9362002

unknown-7404 
Installation is successful, but https://localhost:5500/em/ doesn't work. What is wrong?

Use google and search for "oracle 12c doesn't work" and see if you get any relevant hits.

If none of the search results seems relevant you might want to use a better term than "doesn't work"; there is NO such Oracle exception.

Installations also create an install log that you can review for issues/problems that occured during the install.

Zoltan Kecskemethy

I suggest to issue

emctl status dbconsole

in a terminal/command prompt to get your EM url.

  1. emctl status dbconsole 

emctl status dbconsole

in a terminal/command prompt to get your EM url.

Have you tried that with EM Express 12c?

C:\Oracle\product\12.1.0\dbhome_1>dir /s /b emctl*

File Not Found

The following might be better:

How can I find the port on which EM Express is configured?

Regards,

Mark

1 person found this helpful

sqlplus sys as sysdba

SQL> select dbms_xdb_config.gethttpsport() from dual;

Should return something like:

DBMS_XDB_CONFIG.GETHTTPSPORT()

------------------------------

                          5500

1 - 5

Post Details

Added on Aug 8 2022
2 comments
727 views