Skip to Main Content
Forums

SQL Developer

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Does SQL Developer has login.sql script where I can put all the env SQLs?

Yury VelikanovApr 11 2012 — edited May 31 2012
Hello community,

Please help me out with a simple question.
Each time I start SQL Developer (3.1) and connect to a database I need to run:
alter session set nls_date_format='YYYY.MM.DD HH24:MI:SS';
to set data fields format to reflect hours, minutes and seconds.

Can I automate it? I use login.sql in SQL Plus tro setup environment including data formant .
How to do it in SQL Dev?

Thank you in advance,
Yury

Comments

Hariseshu-Oracle

Thank you for the article. I have a problem and need your help.

  1. I have set-up integrated oim-oam-omss topology successfully on Oracle Linux Server 6.5.
  2. Used Oracle Identity & Access Management 11g R2 PS3 (11.1.2.3).

Problem:

From within the Enterprise Manager console, when I try accessing "Administration" menu of "ohs1" server instance I get the following exception.


Failed to invoke operation load on MBean oracle.as.management.mbeans.register:type=component,name=ohs1,instance=ohs1,Location=AdminServer

Parsing error while loading MBeans.


I have tried all I could like,

  • ./opmnctl unregisterinstance
  • ./opmnctl redeploy
  • ./opmnctl registerinstance
  • ./opmnctl updatecomponentregistration
  • upgradenonj2eeapp.sh

but getting the same exception. I have re-installed the whole set-up but no use.

Can you please help. Thank you so much.

Hari

Ricardo Gutierrez-Oracle

Thank you for the article. I have a problem and need your help.

  1. I have set-up integrated oim-oam-omss topology successfully on Oracle Linux Server 6.5.
  2. Used Oracle Identity & Access Management 11g R2 PS3 (11.1.2.3).

Problem:

From within the Enterprise Manager console, when I try accessing "Administration" menu of "ohs1" server instance I get the following exception.


Failed to invoke operation load on MBean oracle.as.management.mbeans.register:type=component,name=ohs1,instance=ohs1,Location=AdminServer

Parsing error while loading MBeans.


I have tried all I could like,

  • ./opmnctl unregisterinstance
  • ./opmnctl redeploy
  • ./opmnctl registerinstance
  • ./opmnctl updatecomponentregistration
  • upgradenonj2eeapp.sh

but getting the same exception. I have re-installed the whole set-up but no use.

Can you please help. Thank you so much.

Hari

Hi Hari,

This seems to be an issue with the OHS configuration, try the following procedure:

  1. Create a new OHS instance, e.g.:
    /home/oracle/oim-oam-omss/config/instances/ohs1/bin/opmnctl createcomponent -componentType OHS -componentName ohs2
  2. Start the new instance
    /home/oracle/oim-oam-omss/config/instances/ohs1/bin/opmnctl startproc ias-component=ohs2
  3. Access the EM console and check if you can access the "Administration" menu for ohs2, if so then stop the new instance
    /home/oracle/oim-oam-omss/config/instances/ohs1/bin/opmnctl stopproc ias-component=ohs2
  4. Edit httpd.conf for ohs1 (make a backup first) and make sure this file is not missing any directive by comparing with httpd.conf for ohs2
    E.g. the following line could be missing:
    <IfModule mpm_worker_module>
    ...
    LoadModule cgid_module "${ORACLE_HOME}/ohs/modules/mod_cgid.so"
    </IfModule>
  5. After updating httpd.conf, proceed to re-start ohs1
    /home/oracle/oim-oam-omss/config/instances/ohs1/bin/opmnctl stopproc ias-component=ohs1
    /home/oracle/oim-oam-omss/config/instances/ohs1/bin/opmnctl startproc ias-component=ohs1
  6. Check now if you can access the "Administration" menu for ohs1, if so then proceed to delete the ohs2 instance
    /home/oracle/oim-oam-omss/config/instances/ohs1/bin/opmnctl deletecomponent -componentName ohs2

Regards,

Ricardo

Acerak

Thank you for the article.  I tried using the oracle fusion middleware guide, but it was less than helpful.  After many fits/starts, I stumbled across this document.  Was very helpful.

Hariseshu-Oracle

Hi Hari,

This seems to be an issue with the OHS configuration, try the following procedure:

  1. Create a new OHS instance, e.g.:
    /home/oracle/oim-oam-omss/config/instances/ohs1/bin/opmnctl createcomponent -componentType OHS -componentName ohs2
  2. Start the new instance
    /home/oracle/oim-oam-omss/config/instances/ohs1/bin/opmnctl startproc ias-component=ohs2
  3. Access the EM console and check if you can access the "Administration" menu for ohs2, if so then stop the new instance
    /home/oracle/oim-oam-omss/config/instances/ohs1/bin/opmnctl stopproc ias-component=ohs2
  4. Edit httpd.conf for ohs1 (make a backup first) and make sure this file is not missing any directive by comparing with httpd.conf for ohs2
    E.g. the following line could be missing:
    <IfModule mpm_worker_module>
    ...
    LoadModule cgid_module "${ORACLE_HOME}/ohs/modules/mod_cgid.so"
    </IfModule>
  5. After updating httpd.conf, proceed to re-start ohs1
    /home/oracle/oim-oam-omss/config/instances/ohs1/bin/opmnctl stopproc ias-component=ohs1
    /home/oracle/oim-oam-omss/config/instances/ohs1/bin/opmnctl startproc ias-component=ohs1
  6. Check now if you can access the "Administration" menu for ohs1, if so then proceed to delete the ohs2 instance
    /home/oracle/oim-oam-omss/config/instances/ohs1/bin/opmnctl deletecomponent -componentName ohs2

Regards,

Ricardo

Thank you Ricardo. Thank you so much for the response.

Premita Tajane

Thank you so much .Your article is just perfect to understand LCM for PS3

Hi.  I am interested in getting information regarding how OIM integrates with Robotic Process Automation (RPA), if it does at all, and what is that integration if it does?  Is there anything that is part of the OIM featureset that would make it a good companion for RPA?  Thanks.

Hi.  I am interested in getting information regarding how OIM integrates with Robotic Process Automation (RPA), if it does at all, and what is that integration if it does?  Is there anything that is part of the OIM featureset that would make it a good companion for RPA?  Thanks.

Hi there,

I'm not aware of RPA available for the IdM suite, perhaps a quick trip to the documentation could provide you with the info you are looking for.

user9196620

I think only Oracle would call something with 100+ manual steps automation.  Have you guys considered creating a docker or repo to deploy your suite?  The complicated part is configuring MDC and getting all of that to work together.  Being able to deploy and entire cluster in < 10 minutes would be really nice using openstack.  I imagine most companies big enough to buy OAM Suite will not just be installing on a single node but it is not trivial to do all of that work.

1 person found this helpful
Philipp Grigoryev

Found out that cleanup doesn't remove DB schemas and fails at preconfigure stage, even though I ran clean- and restore-

sgs123

Quite interesting and helpful. I am attempting something similar but with Only OIM-SOA, so let's see how it goes.

SrivalliMN-Oracle

Hi, Thank you for the article. Installed the IDM 11.1.2.3, Any idea how to configure the OAM so that oamconsole can be accessed by administration port after enabling DWAP. 

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

Post Details

Locked on Jun 28 2012
Added on Apr 11 2012
#sql-developer, #sqldeveloper
3 comments
7,356 views