Middleware
Celebrate 25 years of Java !!!!
Category: Middleware Author: Andre Luiz Dutra Ontalba (Board Member) Date: 3 years ago Comments: 0
Celebrate the Java 25th Anniversary – Free training and get Java Certified for $25
Trust everything is going well.
 
Celebrate 25 years of Java, starting from Feb 25th, you can get FREE access to the latest Java training and earn the most current Java Developer certification – Oracle Certified Professional: Java SE 11 Developer for $25.
 
Activate your free Java 25th anniversary learning subscription now and purchase your exam through the subscription until April 25, 2021.
 
Start your journey and earn a limited edition badge here, click here.

 

 

LuxOUG

Adding OCI target manually using SSH Private Key in Enterprise Manager Cloud Control 13c
Category: Middleware Author: César Carvalho Date: 3 years ago Comments: 1

Adding OCI target manually using SSH Private Key in Enterprise Manager Cloud Control 13c

Guys, today’s tip is about how to add an OCI target manually in Enterprise Manager Cloud Control 13c using private key ssh.
This week I was implementing Enterprise Manager Cloud Control 13c using machines on Oracle Cloud Infrastructure (OCI), as access to Oracle 11g bank server was done only using a private key, I needed to add this server to be monitored on Cloud Control 13c using ssh private key, I researched a lot and broke my head to add an OCI host, so I decided to post to help other people, below are the steps:
Manually adding the Oracle database server to be monitored in Enterprise Manager Cloud Control 13c.
 
Guys today’s tip is about how to add an OCI target manually in Enterprise Manager Cloud Control 13c using private key ssh.
This week I was implementing Enterprise Manager Cloud Control 13c using machines on Oracle Cloud Infrastructure (OCI), as access to Oracle 11g bank server was done only using private key, I had the need to add this server to be monitored on Cloud Control 13c using ssh private key, I researched a lot and broke my head to add an OCI host, so I decided to post to help other people, below are the steps:
Manually adding the Oracle database server to be monitored in Enterprise Manager Cloud Control 13c
Adding the Oracle 11g Linux platform host
Create the directory in oracle home with oracle user to install the Agent on the server that we will monitor Oracle database 11g.
mkdir -p /u02/app/oracle/product/11.2.0/agentem13c
 
Add the base agent directory to deploy to Enterprise Manager Cloud Control 13c
Discovering the private key to be added from the default user opc in the OCI to add in Enterprise Manager Cloud Control 13c.
cat /home/opc/.ssh/id_rsa
Just copy all the text with the private key.
Fill in the UserName field with the opc user and paste the private key in the SSH Private Key field, then change the run privilege field to sudo and run as for the oracle user.
Okay, just go ok and follow the next steps that the deployment to the target with Oracle database 11g will finish and be successfully added to the Enterprise Manager Cloud Control 13c.

 

 

César Carvalho – DBA
Contact: https://twitter.com/Cesar_DBA
https://sgbdbrasil.wordpress.com/

ERROR CODE: 17002
Category: Middleware Author: Cassio Mariani Date: 4 years ago Comments: 0
Internal Exception: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
 
TIPS: Change Database Hostname After OAM security store configured

 

Change Database Hostname After OAM security stored configured
Issue:
 
Database Hostname need to be changed after OAM security store is configured.
 
Info: Data source is: opss-DBDS

[EL Severe]: 2017-03-14 20:39:37.575--ServerSession(1547285287)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection




Error Code: 17002




JAN 07, 2020 8:39:37 PM oracle.security.jps.internal.common.config.AbstractSecurityStore getSecurityStoreVersion

WARNING: Unable to get the Version from Store returning the default. Reason: java.net.ConnectException: Connection refused.




[EL Severe]: 2020-01-20 20:39:37.978--ServerSession(1619843188)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection




Error Code: 17002

JAN 07, 2020 8:39:37 PM oracle.security.jps.internal.credstore.ldap.LdapCredentialStore init

WARNING: Could not create credential store instance. Reason oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-00027: There was an internal error: java.net.ConnectException: Connection refused

JPS-01055: Could not create credential store instance. Reason oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-00027: There was an internal error: java.net.ConnectException: Connection refused

Error: Diagnostics data was not saved to the credential store.

Error: Validate operation has failed.

Need to do the security configuration first!


Changes:

 

Login to Weblogic console and modify below connection pools

 

Navigate to “Services > Datasources > oamDS > Connection Pool” and modify connection details

 

Navigate to “Services > Datasources > opss-DBDS > Connection Pool” and modify connection details.

 

If weblogic console is not accessible then modify two files “oam-db-jdbc.xml and opss-jdbc.xml” under /user_projects/domains/base_domain/config/jdbc.

 

Login to server and navigate to below location.
/user_projects/domains/base_domain/config/fmwconfig/

 

Modify jps-config-jse.xml, jps-config-migration.xml and jps-config.xml  file
Modify “jdbc.url” property and update with new hostname.

 

Restart Admin server and managed server.

 

Repeat step 2 in all your cluster nodes.
 
Expected Error if  jps-config-jse.xml, jps-config-migration.xml and jps-config.xml  files not modified.
 
CHEERS !

 

Cassio Mariani
 

Disclaimer: “The postings on this site are my own and don’t necessarily represent may actual employer positions, strategies or opinions. The information here was edited  to be useful for general purpose, specific data and identifications was removed to allow reach generic audience and to be useful.”


MDS-00054: Undeploying SOA Composite when Soa-Infra is Down
Category: Middleware Author: Cassio Mariani Date: 5 years ago Comments: 0

MDS-00054: Undeploying SOA Composite when Soa-Infra is Down

 
 
Goal
 
Undeploying SOA Composite while soa-infra is down. 

 

Mainly this task is required when starting soa server, soa-infra application wont come up due to corrupt composite which stops the soa-infra to be in active state.  The solution also applies in the case where the server itself is failing to come up / stay up due to a bad deployment.

 

Fix

 

Check the soa logs and determine which composite is causing the problem and then follow the below process to Undeploy SOA composite by editing deployed-composites.xml

 

1. Download and copy the ShareSoaInfraPartition.ear file to $MIDDLEWARE_HOME/oracle_common/common/bin

 

2. cd to $MIDDLEWARE_HOME/oracle_common/common/bin and run wlst.sh

3.

connect()

provide username, password and server URL

4. run the below command to deploy ShareSoaInfraPartition.ear

deploy(‘ShareSoaInfraPartition’,’ShareSoaInfraPartition.ear’,upload=’true’)

5. Now run the below command by changing the “toLocation” (‘/fmw12c/fmw12213/middleware’ is some location path on SOA machine)

exportMetadata(application=’ShareSoaInfraPartition’,server=’AdminServer’,toLocation=’/fmw12c/fmw12213/middleware’,docs=’/deployed-composites/deployed-composites.xml’)

6. A deployed-composites folder will be created at “toLocation” path with deployed-composites.xml in it

7. Delete the composite which is causing the problem and save the file

For example i am MediatorTest composite like below

<composite-series name=”default/MediatorTest” default=”default/MediatorTest!1.0″>
<composite-revision dn=”default/MediatorTest!1.0″ state=”on” mode=”active” location=”dc/soa_58b98be8-9ec8-41af-bb83-590f6004d1aa”>
<composite dn=”default/MediatorTest!1.0*soa_58b98be8-9ec8-41af-bb83-590f6004d1aa” deployedTime=”2019-03-17T09:01:54.750+05:30″/>

8. Now run the below command by changing the “fromLocation” (this should be the same location as previous)

importMetadata(application=’ShareSoaInfraPartition’,server=’AdminServer’,fromLocation=’/fmw12c/fmw12213/middleware’,docs=’/deployed-composites/deployed-composites.xml’)

9. Now bounce your server and the composite will not be deployed by SOA when it comes up and hence that should bring your soa-infra up.

 

Download ShareSoaInfraPartition from here: (Need an Oracle valid Account) – Click Here
 
All the best,
Cassio Mariani

 

 

INCREASING THE PERFORMANCE OF EM CONSOLE IN ORACLE SOA SUITE 12C
Category: Middleware Author: Cassio Mariani Date: 5 years ago Comments: 0

INCREASING THE PERFORMANCE OF EM CONSOLE IN ORACLE
SOA SUITE 12C

EM console is very slow when accessing to view the composite/component details or the instance details.
We can try to improve the performance by little by following the below steps.
 
  1. Login to the Oracle SOA Suite 12c EM Console
  2. Right Click on SOA-INFRA and go to SOA Administration->Common properties
  3. Set the Data Display Options as shown below.
 
Select the option “Disable fetching of instance and fault count metrics. Each metric can still be  retrieved on demand”.

 

Set the Duration Details to 1 hour (based on your requirement) as shown below.

 

 

This will enable to fetch the instance and fault count metrics based on the demand also the default search criteria will display the last one hour data, this will improve the performance of the em console.
Enable fmwctl discovery cache:
Logging into Enterprise Manager Fusion Middleware Control 12c (fmwctl) takes a long time.  Sometimes as long as 45-60 seconds.  This is often viewed as slow response time, performance or hanging issues, fmwctl discovery is always performed as part of login.  
 
For installations with thousands of targets, fmwctl discovery may take 45-60 seconds. This delay is expected because EM discovery mbeans need to be invoked for every target.
Solution is to cache the discovery results in the servlet context and use it for subsequent logins. This discovery result will be shared by all the fmwctl users. This will still require the entire discovery to be done at least once.
 
Follow the metalink note 1423893.1 to enable the discovery caching.
 
If the caching is enabled, fmwctl will use the cached discovery results and login to the em console will be fast.The default setting is “not use the cached results”. 

 

All the best,
Cassio Mariani
 
 

LUXOUG – LUXEMBOURG ORACLE USERS GROUP
© 2024 LUXOUG – LUXEMBOURG ORACLE USERS GROUP