Step to configure Oracle Database server with Apache tom 1) Copy Oracle Jar file ojdbc14.jar (or) ojdbc6.jar till the lib directory to tomcat server 2) Modify the parameters in the…
Read MoreStep to configure MYSQL with apache tomcat: 1) Copy mysql connection jar file to catalina_home lib directory 2) Configure that database parameter in server.xml file, resource name resource type, java…
Read MoreSetting JAVA_HOME path 1.Open the .bash_profile using vi editor for the root user 2.Add the following environment variable in the file. The following is the code snippet of .bash_profile. The…
Read MoreThis blog describes the sample request for creating Change Order in Oracle Cloud for the existing Purchase Order. This Change Order is to add project details in PO line and…
Read MoreData Source:- A data source is an object which is used to establish connection between data source contains info about the database like Hostname of the database server, port number,…
Read Morelogin to the console Go to Environment Click on Datasources Go to monitoring Then we will see active connections current count and active connections high count.
Read MoreFew servers are currently unreachable at the time of post-migration cell recycle. At this time the server state is running but the server health state is Not reachable. At this…
Read More1.When we have done any changes in SetDomainEnv.sh 2. We have to restart the servers to reflect the changes. 3. Some times after the restart of the servers the servers…
Read MoreThe below query extracts the list of employee users along with their user status and employee status SELECT pu.username USER_NAME ,papf.person_number EMPLOYEE_NUMBER ,ppn.first_name EMPLOYEE_FIRST_NAME ,ppn.last_name EMPLOYEE_LAST_NAME ,DECODE(SUSPENDED,'Y', 'Inactive User','N', 'Active…
Read MoreThe below query extracts the list of data accesses given for any user in Oracle Cloud Application ————————————————–***************——————————————– SELECT gl.name "Security Context Value", pr.role_name"Job Role Name", pu.username "User Name", role.ACTIVE_FLAG…
Read More