Skip to Main Content

DevOps, CI/CD and Automation

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!

extension.xml and catching compile event in sql developer

955166Aug 10 2012 — edited Aug 11 2012
Hi,

recently I've been trying to make a few plug-in/extensions for sql developer. One allows you to search through entire schema to find and procedures or functions that utilize any given procedure or function, this one works fine. The second one and the one that is giving me trouble is an extension that allows you to see if any items (procedures, functions,...) are broken, the goal with this one is for it to do this task automatically when a procedure or function is compiled to show if the compilation of the function or procedure broke anything else. I have this one working as a button in the toolbar and choice in the main menu, but I can not for the life of me figure out how to hook it on to a compile or run event. Please help!!!!

here is my extension file so far:



<extension id="brokenSearch" version="1.0" esdk-version="1.0" rsbundle-class="infinTech.brokensearch.Res"
xmlns="http://jcp.org/jsr/198/extension-manifest">
<name>Broken Search</name>
<dependencies>
<import>oracle.jdeveloper.db.connection</import>
<import>oracle.ide</import>
</dependencies>
<trigger-hooks xmlns="http://xmlns.oracle.com/ide/extension">
<!-- TODO Declare triggering functionality provided by extension: infinTech.schemasearch -->
<triggers>

</triggers>
</trigger-hooks>
<hooks>
<!-- TODO Declare functionality provided by the yourcompany.showmepassword extension. -->
<jdeveloper-hook xmlns="http://xmlns.oracle.com/jdeveloper/1013/extension">
<actions>
<action id="infinTech.brokenitems.BrokenItems">
<properties>
<property name="Name">Broken Items</property>
<property name="SmallIcon">${OracleIcons.PLACEHOLDER}</property>
<property name="LongDescription">Broken Items</property>
</properties>
<controller-class>infinTech.brokensearch.ShowMeDatabasePasswordController</controller-class>
<command-class>infinTech.brokensearch.ShowMeDatabasePasswordCommand</command-class>
</action>
</actions>

<context-menu-listeners>
<site idref="navigator">
<listener-class>infinTech.brokensearch.MenuContextMenuListener</listener-class>
</site>
<site idref="editor">
<listener-class>infinTech.brokensearch.MenuContextMenuListener</listener-class>
</site>
<site idref="explorer">
<listener-class>infinTech.brokensearch.MenuContextMenuListener</listener-class>
</site>
</context-menu-listeners>

</jdeveloper-hook>

<!-- Hook into menus and toolbars -->
<menu-hook>
<menus>
<!--
Add the action in its own separator group at the top of the File
menu.
-->
<menubar id="javax.ide.view.MAIN_WINDOW_MENUBAR_ID">
<menu id="javax.ide.VIEW_MENU_ID">
<section id="schema.search"
before="javax.ide.NEW_SECTION_ID">
<item action-ref="infinTech.brokenitems.BrokenItems"/>
</section>
</menu>
</menubar>

</menus>

<toolbars>
<toolbar id="javax.ide.view.MAIN_WINDOW_TOOLBAR_ID">
<section id="SCHEMA_SEARCH_SEACTION" weight="2.0">

<item action-ref="infinTech.brokenitems.BrokenItems"/>
</section>
</toolbar>
</toolbars>
</menu-hook>


<feature-hook>
<description>Simple utility that finds any/all broken items.</description>
</feature-hook>
</hooks>
</extension>

Comments

rober584812

Hello SmithJohn45.
Try the next commands:

systemctl start oracle-xe-21c
systemctl enable oracle-xe-21c

After running the commands, reboot and test the connection to SQLPLUS.
Regards.

SmithJohn45

thanks @rober584812 but it is already mentioned in guide and off course i executed those commands to start database audomatically.
image.png

rober584812
Answer
Marked as Answer by SmithJohn45 · Oct 1 2021
SmithJohn45

thanks again, will check it and give you feedback

SmithJohn45

@rober584812 here is my feedback...
this helped me and now I can connect to my PDB.
thanks very much for help :)

SmithJohn45

hi rober584812
it was connected to my PDB but when I restart my CentOS 7 VM now it is not connecting to XEPDB1
i issued 2 ' Alter Pluggable Database ' commands ( as below ) but still failed to connect using sys/ora1234@xepdb1
in my .bash_profile i added following environment variables which can only enable me to run sqlplus, also i have to issue command manually as below to connect to XE (CDB) but this also not allowed me to connect to PDB.
. oraenv
alter commands as per oracle documents:

alter PLUGGABLE DATABASE ALL OPEN;
alter PLUGGABLE DATABASE ALL SAVE STATE;

environment variables:
export ORACLE_BASE=/opt/oracle/
export LD_LIBRARY_PATH=$ORACLE_BASE/product/21c/dbhomeXE/lib
export ORACLE_HOME=$ORACLE_BASE/product/21c/dbhomeXE
export PATH=$ORACLE_BASE/product/21c/dbhomeXE/bin:$PATH
export PATH=/usr/bin:$PATH
export ORACLE_SID=XE
this is same problem i am facing in 18c XE. please help to connect and start Apex 21 + ORDS 21 installation and development.
regards
Is it necessary to issue , oraenv command ? what about if i add it in .bash_profile but will this accept XE as parameter in that file?

rober584812

Hello SmithJohn45 , check if the listener is running.

cd <oracle_home>/bin
lsnrctl status

After, if the listener status is OK, try the following command:
system/password@localhost.localdomain:1521/XEPDB1
The order . oraenv is necessary.
Regards.

SmithJohn45

yeah, i can connnect using ezconnect syntax. but as mentioned earlier, i am confused as i want to install Apex & ORDS, how I can configure to use it both " . oraenv " and ezconnect syntax without every time manually interact when logout and login, machine restart etc. and same for production environment?
regards

rober584812

Hello @smithjohn45 , the important thing is that the listener is working, if the listener is in the OK state, you will be able to access the Oracle XE instance without problems; Regarding the installation of APEX with ORDS, using "oraenv" will be required during the installation process, you can configure ORDS in autorun or standalone mode.
Regards.

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

Post Details

Locked on Sep 8 2012
Added on Aug 10 2012
1 comment
201 views