Getting Acquainted With Oracle Fusion:

Getting Acquainted With Oracle Fusion:

Oracle Fusion is a Suite of Products being provided as a END-END  solution by Oracle.

Below are the Productions within the FUSION suite one should be familiar with,to call oneself a MASTER of Oracle Fusion

■Application Server
 ■Business Intelligence
 ■Business Process Management
 ■Grid Infrastructure
 ■Collaboration Suite
 ■Data Integration

■Developer Tools
 ■Enterprise 2.0 and Portals
 ■Enterprise Content Management
 ■Event-Driven Architecture
 ■Identity Management
 ■Middleware for Fast-Growing Companies

MDS Import/Export/Delete using wlst.

MDS Import/Export/Delete:

IMPORT METADATA TO MDS :

STEP 1:

SOURCE LOCATION :

 [fmwadmin@abcapp018 XYZApplicationObjectLibrary]$ pwd

/u01/Oracle/mds/apps/XYZMetaData/XYZComponents/XYZApplicationObjectLibrary

[fmwadmin@abcapp018 XYZApplicationObjectLibrary]$ ls

deploySOA.xml

·         The above “deploySOA.xml” file has to be uploaded to mds.

·         So I have created the hierarchy as I want it to be .

·         In My case it is “apps/XYZMetaData/XYZComponents/XYZApplicationObjectLibrary” under the source “/u01/Oracle/mds”

·         Make sure you give all permission to the above hierarchy folders under the source “/u01/Oracle/mds”

STESTE

STEP 2:

[fmwadmin@abcapp018 bin]$ pwd

/u01/Oracle/Middleware/wlserver_10.3/server/bin

[fmwadmin@abcapp018 bin]$ . ./setWLSEnv.sh

STEP 3:

/u01/Oracle/Middleware/oracle_common/common/bin

[fmwadmin@abcapp018 bin]$ ./wlst.sh

STEP 4:

wls:/offline>connect(‘weblogic’,’password’,’t3://hostname:adminport’)

STEP 5:

wls:/XYZ_domain/serverConfig> importMetadata(application='soa-infra',server='XYZ_soa_server1',fromLocation='/u01/Oracle/mds',docs='/apps/XYZMetaData/XYZComponents/XYZApplicationObjectLibrary/**')

Command:

wls:/XYZ_domain/serverConfig> importMetadata(application='soa-infra',server='XYZ_soa_server1',fromLocation='/u01/Oracle/mds',docs='/apps/XYZMetaData/XYZComponents/XYZApplicationObjectLibrary/**')

Executing operation: importMetadata.

Operation "importMetadata" completed. Summary of "importMetadata" operation is:

List of documents successfully transferred:

/apps/XYZMetaData/XYZComponents/XYZApplicationObjectLibrary/deploySOA.xml

1 documents successfully transferred.

wls:/XYZ_domain/serverConfig>

Verification: Check the same from Jdeveloper

______________________________________________________________________________________

EXPORT METADATA FROM MDS:

STEP 1:Target location below. Make sure it is having enof space and permissions.

[fmwadmin@abcapp018 XYZApplicationObjectLibrary]$ pwd

/u01/Oracle/mds/

REPEAT STEP 2,3,4 of “IMPORT METADATA TO MDS SECTION”:

STEP 5:

exportMetadata(application='soa-infra', server='XYZ_soa_server1',toLocation='/u01/Oracle/mds', docs='/apps/XYZMetaData/XYZComponents/XYZApplicationObjectLibrary/deploySOA.xml')

________________________________________________________________________________________

DELETE METADATA FROM MDS:

REPEAT STEP 2 to STEP 4 in the IMPORT SECTION ABOVE:

Then execute below command.

wls:/XYZ_domain/serverConfig> deleteMetadata(application='soa-infra',server='XYZ_soa_server1',docs='/apps/XYZMetaData/XYZComponents/XYZApplicationObjectLibrary/deploySOA.xml')

Executing operation: deleteMetadata.

Operation "deleteMetadata" completed. Summary of "deleteMetadata" operation is:

List of documents successfully deleted:

/apps/XYZMetaData/XYZComponents/XYZApplicationObjectLibrary/deploySOA.xml

1 documents successfully deleted.

wls:/XYZ_domain/serverConfig>

JDBC DATASOURCE ISSUES:

 Many times we may encounter Datasource overlosd issues.
At those times you may track below kind of errors in logs.

<BEA-001129> <Received exception while creating connection for pool "ARS213NotificDBConn": Cannot open database "ARS271TEST" requested by the login. The login failed. ClientConnectionId:5c6a702b-00ad-4d38-b031-2645f4a89563.>
<Mar 5, 2013 5:32:34 AM GMT> <Error> <JDBC> <BEA-001112> <Test "SELECT 1" set up for pool "SFA316NytificDBConn" failed with exception: "com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset".>
<Mar 5, 2013 5:32:35 AM GMT> <Error> <JDBC> <BEA-001112> <Test "SELECT 1" set up for pool "SFA271ARDBConn" failed with exception: "com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset".>
<Mar 5, 2013 5:32:45 AM GMT> <Error> <JDBC> <BEA-001112> <Test "SELECT 1" set up for pool "SFA315HeldDBConn" failed with exception: "com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset".>
<Mar 5, 2013 5:32:52 AM GMT> <Error> <JDBC> <BEA-001112> <Test "SELECT 1" set up for pool "SFA316ARDBConn" failed with exception: "com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset".>
<Mar 5, 2013 5:33:07 AM GMT> <Error> <JDBC> <BEA-001112> <Test "SELECT 1" set up for pool "SFA319ARDBConn" failed with exception: "com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset".>


ERROR:

weblogic.common.resourcepool.ResourceDisabledException: Pool SFA213HeldDBConn is Suspended, cannot allocate resources to applications. 

Immediate Resolution:

login to your weblogic console:

left pane click on services->datasources->click on the datasource->control tab

Clear the statement cache / shutdown & start the datasource:

After the immdiate action lets now look at how we can avoid this reoccurance :

JDBC TIPS AND KNOWLEDGE:

 Tuning JDBC Connection Pool Initial Capacity

The InitialCapacity attribute of the JDBCConnectionPool element enables you to set the number of physical database connections to create when configuring the pool. If the server cannot create this number of connections, the creation of this connection pool will fail.
During development, it may be convenient to set the value of the InitialCapacity attribute to a low number to help the server start up faster. In production systems, consider setting the InitialCapacity value equal to the MaxCapacity attribute's default production mode setting of 25. This way, all database connections are acquired during server start-up. And if you need to tune the MaxCapacity value, make sure to set the InitialCapacity so that it equals the MaxCapacity value.
If InitialCapacity is less than MaxCapacity, the server needs to create additional database connections when its load is increased. When the server is under load, all resources should be working to complete requests as fast as possible, rather than creating new database connections.

Tuning JDBC Connection Pool Maximum Capacity

The MaxCapacity attribute of the JDBCConnectionPool element allows you to set the maximum number of physical database connections that a connection pool can contain. Different JDBC drivers and database servers might limit the number of possible physical connections.
The default settings for development and production mode are equal to the default number of execute threads: 15 for development mode; 25 for production mode. However, in production, it is advisable that the number of connections in the pool equal the number of concurrent client sessions that require JDBC connections. The pool capacity is independent of the number of execute threads in the server. There may be many more ongoing user sessions than there are execute threads.

  However in WEblogic 8:

It was adviced to Set the Maximum Capacity of the connection pool at least equal to the Execute Thread Count.

From WLS 9.0 series onwards,server has a single thread pool for requests from all applications. Similarly, all pending work is enqueued in a common priority-based queue. The thread count is automatically tuned to achieve maximum overall throughput. One of the major differences between execute queues and the new thread scheduling model is that the thread count does not need to be set. In earlier releases, customers defined new thread pools and configured their size to avoid deadlocks and provide differentiated service. It is quite difficult to determine the exact number of threads needed in production to achieve optimal throughput and avoid deadlocks. WebLogic Server 9.0 is self-tuned, dynamically adjusting the number of threads to avoid deadlocks and achieve optimal throughput subject to concurrency constraints. The maximum threads constraint can be used to limit the maximum number of concurrent threads given to all WorkManagers that share the constraint.This constraint should be used in very special cases and should not be confused with the thread count parameter in execute queues. The minimum threads constraint takes an integer value that specifies the number of threads that should be assigned to this constraint to prevent server-to-server deadlocks.

There is no Execute Queue concept from Weblogic server 9 version onwards.They have intoduced WORK MANAGERS instead of that.Now WebLogic Server uses a single thread pool, in which all types of work are executed. WebLogic Server prioritizes work based on rules you define, and run-time metrics, including the actual time it takes to execute a request and the rate at which requests are entering and leaving the pool.

Test Connections On Reserve(do not check)
Enables WebLogic Server to test a connection before giving it to a client. (Requires that you specify a Test Table Name.)
The test adds a small delay in serving the client's request for a connection from the pool, but ensures that the client receives a viable connection.
MBean Attribute (Does not apply to application modules) :
JDBCConnectionPoolParamsBean.TestConnectionsOnReserve



Statement Cache Size(SET to 10)
The number of prepared and callable statements stored in the cache. (This may increase server performance.)
WebLogic Server can reuse statements in the cache without reloading the statements, which can increase server performance. Each connection in the connection pool has its own cache of statements.
Setting the size of the statement cache to 0 turns off statement caching.
MBean Attribute (Does not apply to application modules) :
JDBCConnectionPoolParamsBean.StatementCacheSize
Minimum value: 0
Maximum value: 1024


When using DataSource objects for a connection pool, use the Honors Global Transaction option to create a TxDataSource.

 The only time you should use a non-Tx Data Source is when you want to do some work on the database that you do not want to include in the current transaction.



When configuring a connection pool to use with WebLogic JMS JDBC Store, use non-XA database drivers.

 

How to import the certificates:WEBLOGIC

How to import the certificates:

STEP 1 :

cd to middleware home jdk location:
ex:C:\Oracle\Middleware\jdk160_21\bin\keytool

STEP 2:

execute the below command to import the certificates:

C:\Oracle\Middleware\jdk160_21\bin\keytool -import -trustcacerts -alias tso -keystore DemoTrust.jks -storepass DemoTrustKeyStorePassPhrase
 -storetype jks -file C:\Users\xyz364\Documents\ASHLEE\CERT_FOLDER_BS)\Pannmina_cert\devCert.crt


@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

Reset the Admin Server password

Reset the Admin Server password

How do I reset the Admin Server's Administrator password?

To successfully change the Administrator password, perform the following steps.

 Note: Please refer to Doc ID 1350814.1

IF YOU KNOW CURRENT PASSWORD

1. Start the Admin Server and log-into console.

2. Go to page: Home > Summary of Security Realms > myrealm > Users and Groups > weblogic. and click on tab Passwords.

3. Enter the new Password.

4. Restart the server.

If you get a weblogic.security.SecurityInitializationException error, perform this additional step on every Managed Server (or eventually the Admin Server, too):

5. Go to folder DOMAIN_HOME/servers/AdminServer/security

6. Edit the boot.properties file and change the password to the value already entered on the Admin Console. Do this for all the servers in the domain.

7. Started the Admin Server (Weblogic Server will encrypt the password for you).

Optionally, you can force a Managed Server to connect to the embedded LDAP server on the Administration Server, instead of connecting to the local replicated LDAP server. Follow these steps:

8. Go to page: Domain > Security > Embedded LDAP page on the Admin Console

9. Enable MasterFirst.

10. Restart the server.

IF YOU DON'T KNOW CURRENT PASSWORD

1.- Take the back of the LDAP folder of the admin server as well as managed server (you may rename those folders) and then delete the actual LDAP folder (found at servers\<MyServer>\data\ldap).

2. Make sure WebLogic instance is down.

3. Set your environment variables using setDomainEnv.sh.

4. cd to security directory in your instance.
(eg: $WL_HOME/user_projects/domains/base_domain/security)

5. Run:
java weblogic.security.utils.AdminAccount admin_user admin_pass .Remember to change “admin_user” and “admin_pass” to your need.

Also, don’t forget the period “.” at the end of the above command, it is required.

6. After running the command, the file “DefaultAuthenticatorInit.ldift” will get updated.

7. Delete the following file from “ldap” folder:

cd WL_HOME/user_projects/domains/base_domain/servers/AdminServer/data/ldap
rm DefaultAuthenticatormyrealmInit.initialized

8. Go to folder DOMAIN_HOME/servers/AdminServer/security

9. Edit the boot.properties file and change the password to the value already used on step 5. Do this for all the servers in the domain.

10. Start Weblogic Server (Weblogic Server will encrypt the password for you).


IMPORTANT

Keep in mind that we are NOT just changing the password for the Admin Console, but we are rather changing it for the Admin User (which may connect in many different ways to Admin Server).

Remember to use the new password (once successfully changed), when we try to connect to WLST or start the managed servers or even using weblogic.Admin utility.