dbafusion

While running "./jstatd -J-Djava.security.policy=jstatd.all.policy &" command , below error is getting encountered Error :- Could not create remote object access denied (java.util.PropertyPermission java.rmi.server.ignoreSubClasses write) java.security.AccessControlException: access denied (java.util.PropertyPermission java.rmi.server.ignoreSubClasses write) at java.security.AccessControlContext.checkPermission(AccessControlContext.java:264) at java.security.AccessController.checkPermission(AccessController.java:427) at java.lang.SecurityManager.checkPermission(SecurityManager.java:536) at java.lang.System.setProperty(System.java:699) at sun.tools.jstatd.Jstatd.main(Jstatd.java:122) Cause :- The "access denied" error is expected, because "jstatd" requires a security policy file specified with the "java.security.policy" system property, if there is no security manager running on the machine. Solution :- 1) cd $ORACLE_HOME/jdk

There was some performance issue in Development server due to thousands of unused/junk BPEL processes deployed within the container , but I couldn’t able to delete all at once as there was no option and if deleting one by one could take many hours to perform this , then I found a solution over the net which changes little code of some JSPs of the product ( Although not change in the product code not supported by Oracle). Here is the process to do the same which saved huge amount of hours and work :- Note :- Replace all "*" with "<" and "#" with ">" 1) Take a backup of the files; bulkUpdateProcess.jsp and doBulkUpdateProcess.jsp. The path is :- $ORACLE_HOME/j2ee/oc4j_soa/applications/orabpel/console 2) Add the below code in the the file bulkUpdateProcess.jsp. (Add the code after the label: *label for="processStateOff"# *%= I18nUtil.getString("off", locale)%# */label#) Code to be added :- ---- *p# *

ORABPEL-05002 Message handle error. An exception occurred while attempting to process the message "com.collaxa.cube.engine.dispatch.message.instance.CallbackDeliveryMessage"; the exception is: JTA transaction is not present or the transaction is not in active state. The current JTA transaction is not present or it is not in active state when processing activity or instance "26090849-BpInv2-BpSeq0.3-3". The reason is The execution of this instance "26090849-BpInv2-BpSeq0.3-3" for process "Test" is supposed to be in a jta transaction, but the transaction is not present or in active state, please turn on the application server transaction debug logs to get more information.. Please consult your administrator regarding this error. Symptoms :- The error is occurring intermittently in BPEL logs for test domain in the format above. Cause:- It’s a generic error but in our case it is request time out which is due to inappropriate value of “tran

Error :- JDBC Connection; nested exception is java.sql.SQLException: Connection Cache with this Cache Name is Disabled Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connection Cache with this Cache Name is Disabled Caused by: java.sql.SQLException: Connection Cache with this Cache Name is Disabled at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:240) at oracle.jdbc.pool.OracleImplicitConnectionCache.getConnection(OracleImplicitConnectionCache.java:310) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:286) at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:179) at oracle.jdbc.pool.OracleDataSource.get

An error occurred while making the JMX RMI connection and it should have only one AS-control running in Application server 10.1.3.4. Resolution Steps :- 1) Go to $OH/j2ee/test_oc4j/config path ( In each OC4J) 2) Update the new password for "oc4jadmin" in system-jazn-data.xml file with "!newpasword". "!" is used for encrytption. 3) Go to $OH/j2ee/home/persistence/ascontrol/ascontrol/securestore directory. 4) Delete the contents of the "securestore" directory . 5) Restart the application server or oc4j container.

It is a two step process as far as my documentation goes given below :- (i) STEP1 :- a) Remove the agent from the old OMS otherwise the same agent will not be able to point to the new OMS as it is registered in the old OMS with below tasks :- a.1)From OMS, drop all the Targets on the host to be removed, except the Host and Agent.All targets except the Host and Agent should now be gone from the OMS. a.2) Confirm the targets (except Host and Agent) are removed successfully and completely from the OMS: Click on "Setup" in upper right. Click on the "EM 10g Grid Control Management System" tab You will see this information on the page: --> Management Services and Repository --> Overview page --> General section --> Deleted Targets: < click on the digit listed here > a.3) Click on "Deleted Targets" (Note this only appears once a delete is attempted.) a.4) Confirm that the "Time Delete Completed" column is filled in;

Many times , some websites/applications/web services doesnt run on some particular version of Internet Explores and the reason being the compatibility of the application/code with the IE version so we can test our application URL by running on IE tester. IETester, using this utility you can run multiple instances of Internet Explorer and view how the Services are rendered in each, To download this utility :- http://www.my-debugbar.com/ietester/install-ietester-v0.4.2.exe

1) Copy the below .depot files in /var/tmp cd /var/tmp termcap-1.3.1-ia64-11.31.depot gettext-0.17-ia64-11.31.depot 2) Swinstall –s /var/tmp/termcap-1.3.1-ia64-11.31.depot Swinstall –s /var/tmp/gettext-0.17-ia64-11.31.depot 3) type bash at prompt.

Below is the error reported in BPEL opmn logs :- ############ <2010-02-07 10:50:59,852> <:logerror>Error while invoking bean "cube engine": Cannot update lob column.The process domain was unable to update the lob column "3" in the datastore. The exception reported is: ORA-22990: LOB locators cannot span transactions Please check that the machine hosting the datasource is physically connected to the network. Otherwise, check that the datasource connection parameters (user/password) is currently valid. sql statement: BEGIN INSERT INTO cube_scope( cikey, domain_ref, scope_bin ) VALUES ( ?, ?, '0' ) RETURNING scope_bin INTO ?; END; ORABPEL-04040 Cannot update lob column. The process domain was unable to update the lob column "3" in the datastore. The exception reported is: ORA-22990: LOB locators cannot span transactions Please check that the machine hosting the datasource is physically connected to the network. Oth

Issue :- Mod_oc4j not able to connect to OC4J . Below error in apache logs(error logs) ######### Sun Feb 7 10:55:58 2010] [error] [client 100.1.2.101] [ecid: 1265525758:172.1.2.3:18412:0:1429,0] File does not exist: / $OH/Apache/Apache/htdocs/error/HTTP_BAD_GATEWAY.html.var [Sun Feb 7 10:56:00 2010] [warn] [client 100.1.2.101] oc4j_socket_recvfull timed out [Sun Feb 7 10:56:00 2010] [error] [client 100.1.2.101] [ecid: 1265525456:172.1.2.3:25882:0:294,0] mod_oc4j: request to OC 4J ab.testworld.com :12543 failed: recv failed (errno=4) [Sun Feb 7 10:56:00 2010] [warn] [client 100.1.2.102] oc4j_socket_recvfull timed out [Sun Feb 7 10:56:00 2010] [error] [client 100.1.2.102] [ecid: 1265525458:172.1.2.3:15032:0:1931,0] mod_oc4j: request to O C4J ab.testworld.com:12506 failed: Connect failed ######### Solution in metalink :- Troubleshooting MOD_OC4J_0080 MOD_OC4J_0058 MOD_OC4J_0035 MOD_OC4J_0121 MOD_OC4J_0013 Errors In the HTTP Server error_log file

Whenever we were restarting the OC4J Container , we observed that some of the applications automatically gets undeployed and are not visible in enterprise manager console.We found below errors in the container logs which are due to the wrong entries in server.xml and default-website.xml file Then we deleted those physical appliation folders from the $OH/j2ee/testoc4j/applications and restarted the container and then deployed the J2EE applications again. It worked even after the restart. Issue :- opmn referreing to wrong entries in server.x ml and default-website.xml file. Solution :- Delete application folders from $OH/j2ee/testoc4j/applications and redeployed the applications. ############# 09/06/21 17:27:13 [SEVERE]: Error instantiating application at file $OH/j2ee/testoc4j/applications/test.ear: Unable to get A pplicationConfig for test1 : Error creating deployment directory: IO Error: error in opening zip file 09/06/21 17:27:13 [SEVERE]: Error instantiating appl

1) Global Replacement Commant in vi :- 1,$s/xyz/abc/g 2) For alligning of the content in vi :- set noai nosm (no auto intended and no show match) 3) Shutdown from remote command prompt :- shutdown -t 00 (Windows) 4) To see blocked session in windows :- qwinsta \Server:100.1.2.100 (windows) 5) how to extract cpio file :- cpio -icdmv #greater than symbol # # file_name # 6) To find which PID using port :- lsof -i TCP:portno or lsof -i tcp | grep #portnumber# 7) To find IP address of server :- netstat -in 8) To Find files "generated/modified" today and remove them from unix :- ls -ltr | awk '{print $7 " " $9}' | grep -w `date "+%d` | awk '{print $2}' | xargs rm 9) To find the files containing a specific string :- Find . –type f –print | xargs grep “vinay” 10) To get ram/os details on HP :- /usr/contrib/bin/machinfo 11) To get disk details on HP :- ioscan -fnkC disk 12) To find a file larger then the 10GB :- find /u01/sof

When an error occurs in the translation or runtime execution of a JSP page, the container would return the exception, message and a stack trace to the client. However, the exception is not displayed in the page by default in OC4j. This can be a little annoying for development machines. There are several ways to change this behavior. The easiest way is to set the development flag at the container level. This can be done by updating the element of the global-web-application.xml file. Here is an example: --orion-web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://xmlns.oracle.com/oracleas/schema/orion-web-10_0.xsd" jsp-cache-directory="./persistence" servlet-webdir="/servlet" development="true" jsp-timeout="0" jsp-cache-tlds="standard" schema-major-version="10" schema-minor-version="0"

These are the general interview questions which i framed in 5 minutes can be really helpful for the guys having intermediate experience as a DBA/Administrator in IT Field . Here we go :- 1. What are the common prerequisites of installing 10g Re2 database on HP-UX11.23 or any other OS? 2. What do mean by oraInventory and oratab? Their significance? 3. How can you copy a file recursively on UNIX prompt? How to see directory structure in HP-UX? 4. What is the purpose of netstat, touch, finger, whoami, man commands? 5. What are the severity levels of an SR? 6. What do you mean by hard close and soft close of an SR? 7. What do you mean by SR Profile? 8. What is the purpose of RDA? 9. What do you mean by software configuration manager and its purpose? 10. How can you escalate an SR to Oracle Management? Or raising a severity level? 11. What is the standard path or the naming convention used to install database softwa

1) Go to $ORACLE_HOME/owsm/bin 2) Open below file and edit below parameters same as below :- bash-3.2$ vi manageUserGroups.properties user_id=admin user_name=admin user user_password=oracle user_email=admin@admin.com group_id=su1-grp group_desc=super user group 3) Delete mapping between admin user and su1-grp with below command :- bash-3.2$ sh wsmadmin.sh manageUserGroups deleteUserGroup Buildfile: /u01/app/OAS/10.1.3.1/SOAD1/owsm/bin/../scripts/manageusergroups.xml set-classpath-oracle: [echo] Setting Oracle Classpath manage-del-user-group: [java] SUCCESS : Mapping between user "admin" and Group "su1-grp" successfully deleted from database. BUILD SUCCESSFUL Total time: 1 second 4) Now with the same file , delete user with below command :- bash-3.2$ sh wsmadmin.sh manageUserGroups deleteUser uildfile: /u01/app/OAS/10.1.3.1/SOAD1/owsm/bin/../scripts/manageusergroups.xml set-classpath-oracle:

Below error reported in opmn BPEL logs :- 10/02/01 02:30:19 org.springframework.dao.DeadlockLoserDataAccessException: CallableStatementCallback; SQL []; Transaction (Process ID 125) was deadlocked on lock communication buffer resources with a nother process and has been chosen as the deadlock victim. Rerun the transaction.; nested exception is java.sql.SQLException: Transaction (Process ID 125) was deadlocked on lock communication buffer r esources with another process and has been chosen as the deadlock victim. Rerun the transaction. 10/02/01 02:30:19 Caused by: java.sql.SQLException: Transaction (Process ID 125) was deadlocked on lock communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction . 1) This error comes whenever there is a deadlock occurred in the database which stops releasing the process resulting into the halt of OC4J 2) Find the deadlock process 3) Kill the deadlock process by Sql > A

The maximum heap size controls how much memory the JVM can use. If your BPEL instance runs on a dedicated machine, set this as high as the maximum addressable memory space of your Operating System. Determine the maximum heap by running Java from the command line and specifying the maximum heap. For example, java -mx3000m -version In this case, decrease the maximum heap value until you do not get the error message . You can start by setting the maximum heap to a value satisfying your free RAM bash-3.2$ java -mx3500m -version java version "1.4.2.10" Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2.10-060112-14:28) Java HotSpot(TM) Server VM (build 1.4.2 1.4.2.10-060112-19:42-IA64N IA64, mixed mode) bash-3.2$ java -mx3600m -version Error occurred during initialization of VM java.lang.OutOfMemoryError: unable to create new native thread

In xyz server , i saw opmn.log has below entries i.e. cluster handshake, but after that it got resolved automatically as no error got produced, 8042 is the remote ONS port of other server in cluster. 10/02/02 14:10:39 [ons-secure] Connection 172.200.100.100,8042 SSL handshake failed 10/02/02 14:11:25 [ons-connect] Passive connection 172.200.100.100,8042 missing connect Thre reason could be peak load or network disconnectivity. Remoteport, the port that ONS binds to on all interfaces for talking to other ONS daemons.

Below errors are reported in the Oracle Application Server logs :- 2010-02-02 08:17:29,832> <::> Io exception: The Network Adapter could not establish the connection java.sql.SQLException: Io exception: The Network Adapter could not establish the connection at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:287 10/02/02 08:17:29 ERROR: exception symbol "09732" not found in resource file. <2010-02-02 08:17:29,831> <::> Io exception: The Network Adapter could not establish the connection java.sql.SQLException: Io exception: The Network Adapter could not establish the connection at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175) at oracle.jdbc.driver.DatabaseError.thr

1) In httpd.conf , there is a module called "mod_status" which should be present status_module libexec/mod_status.so 2) Extended Status should be ON to see full status. # ExtendedStatus controls whether Apache will generate "full" status # information (ExtendedStatus On) or just basic information (ExtendedStatus # Off) when the "server-status" handler is called. The default is Off. # ExtendedStatus On 3) To add server version etc. in status , add below line Optionally add a line containing the server version and virtual host # name to server-generated pages (error documents, FTP directory listings, # mod_status and mod_info output etc., but not CGI generated documents). # Set to "EMail" to also include a mailto: link to the ServerAdmin. # Set to one of: On | Off | EMail # ServerSignature On 4) Add the server hostname and the workstation IP in "Allow From" tab on which you want to veiw the report. # # All

1)       There is no need of shutting down the Application Server, We can take tar backup online and it is consistent as well , only while restoring we might have have to change the status We are taking the backup of all the Oracle Homes using the “Tar” Command. Ex: tar –cvf  portalorahome_20070508.tar  $ORACLE_HOME_PATH

1) Edit /etc/hosts file and map --LBR Hostname-- to --LBR IP-- on each node 2) Set enableCluster to true and assign a name to the clusterName property in ORACLE_HOME/bpel/system/config/collaxa-config.xml on each node 3) Set mcast-addr and mcast-port in ORACLE_HOME/bpel/system/config/jgroups-protocol.xml on each node 4) Set the soapServerURL to the same value as the load balancer internal URL and the soapCallbackUrl to the same value of the load balancer external URL, using the BPELADMIN console on each node 5) Configure these properties on all the nodes in the cluster: 6) In the ORACLE_HOME/bpel/utilities/ant-orabpel.properties file, set cluster to true. 7) Set oc4jinstancename to SOA_GROUP (the name of the OC4J group that has the Oracle BPEL Process Manager deployed to it). 8) Restart the OC4J_SOA instances on all nodes.

a) Use Discovery Server method for OPMN Cluster b) Designate --node1-- as the discovery server and apply the below configuration c) Edit opmn.xml file and the below config --notification-server-- --topology-- --discover list="--node1:--ONS_Port--"/-- --/topology-- ... --/notification-server-- d) Run the command ./opmnctl reload Apply the step a to d on all the nodes. e) After doing on all nodes , execute :- ./opmnctl startall and thus opmn gets clustered

Suddenly a requirement came to me that whether the IP address is published over the net or outside network or not. Then for a quick solution , instead of going into the server apache configuration files , i found that there are many sites available over the internet which can provide IP to HOST or HOST to IP resolution so if it will resolve to my IP then it is published over the net.So this cheeky solution worked.

1) Installing OHS on Red Hat Linux 4.0 on virtual VMWare , faced a problem that http server not gettng started and threw below error. 10/01/28 11:15:14 Start process -------- /data1/oracle/app10gR3/ohs/ohs/bin/apachectl startssl: execing httpd /data1/oracle/app10gR3/ohs/ohs/bin/httpd: error while loading shared libraries: libdb-3.3.so: cannot open shared object file: No such file or directory. 2) Found that on blogs that libdb-3.3.so is an OS (RED HAT) library file which is missing. 3) Found on the google the link . i.e. ftp://mahe.inrialpes.fr/linux/freshrpms/redhat/7.0/updates/i386/db3-3.3.11-6.i386.rpm Now the link will not work so replace ftp with http , and download it. 4) Executed RPM 5) Retry the installation & http server will start successfully

Some Important Java Terms you can come across while working & monitoring SOA Suite :- BPEL Versioning :- Oracle BPEL Control is also useful for deciding when a process is ready for production mode. For example, assume that you compiled and deployed version 1.0 of your BPEL process and subsequently a newer version, version 2.0. After testing and verification of your BPEL process, you can use Oracle BPEL Control to mark one of the versions as the default. Then new instances are started using this definition. The Java Database Connectivity (JDBC) :- The Java Database Connectivity (JDBC) API is the industry standard for database-independent connectivity between the Java programming language and a wide range of databases – SQL databases and other tabular data sources, such as spreadsheets or flat files. The JDBC API provides a call-level API for SQL-based database access. JDBC technology allows you to use the Java programming language to exploit "Write Once, Run Anywhe

Usually platform id is picked up from the file : $ORACLE_HOME/inventory/ContentsXML/oraclehomeproperties.xml To override the value :- Set :- OPATCH_PLATFORM_ID export OPATCH_PLATFORM_ID=0 set OPATCH_PLATFORM_ID=0

This problem comes when we try to access any OC4J instances other than HOME, the Application Server will deny the access and gives following error on the screen: Unable to make a connection to OC4J instance instance_name on Application Server application_server_name. A common cause for this failure is an authentication error. The administrator password for each OC4J instance in the Cluster must be the same as the administrator password for the OC4J instance on which Application Server Control is running. This means that all the OC4J instances in the application server should have same oc4jadmin password. Perform below steps to debug the above error :- Before changing the oc4jadmin password for HOME instance, change the oc4jadmin password for all other instances using the following steps: 1. Click on OC4J instance 2. Click on Administration tab 3. Edit sub-task Security Providers under Security task 4. Edit any application name under Application Level Security 5.

Overview of applying Oracle Application Server 10g R3 patchset 4 (10.1.3.4) on existing 10g R3 (10.1.3) Key Points for 10.1.3.4 Upgrade 1. Patch Number for OAS 10g R3 patchset 4 (10.1.3.4) is 7272722 2. 10g R3 patchset 4 (10.1.3.4.0 - 7272722) is cumulative and includes all fixes from 10.1.3.0, 10.1.3.1, 10.1.3.2 and 10.1.3.3 3. 10g R3 patchset 4 (10.1.3.4.0) is NOT complete software, you need to install in on top of one of existing software i.e. 10.1.3.n (10.1.3.0, 10.1.3.1, 10.1.3.2 or 10.1.3.3) 4)10g Rel 3 patchset 1 (10.1.3.1.0) is starting point for Oracle SOA Suite (BPEL, ESB…) and 10g Rel 3 patchset 2 (10.1.3.2.0) is starting point for WebCenter Suite (ContentDB, WebCenter Services). If you are using Oracle SOA Suite or Oracle Web Center then you need to do additonal steps before upgrade like – upgrade_10131_10134_oracle.sql (10.1.3.1) or – upgrade_10133_10134_oracle.sql (10.1.3.3) (For BPEL from ORABPEL schema) – upgrade_10133_10134_oracle.sql (For ESB from O

1) Set ORACLE_HOME,OPATCH/bin under PATH. 2) Shut down the application server by $opmnctl shutdown command 3) Extract the MLR6 on the server & move inside the directory. 4) Execute below command :- bash-3.2$ ./opatch apply /u01/data/8279781/ Oracle Interim Patch Installer version 1.0.0.0.58 Copyright (c) 2007 Oracle Corporation. All Rights Reserved.. We recommend you refer to the OPatch documentation under OPatch/docs for usage reference. We also recommend using the latest OPatch version. For the latest OPatch version and other support related issues, please refer to document 293369.1 which is viewable from metalink.oracle.com Oracle Home : /u01/app/OAS/10.1.3.1/OH Oracle Home Inventory : /u01/app/OAS/10.1.3.1/OH/inventory Central Inventory : /home/appsoad/oraInventory from : /var/opt/oracle/oraInst.loc OUI location : /u01/app/OAS/10.1.3.1/OH/oui OUI shared library : /u01/app/OAS/10.1.3.1/OH/oui/lib/hpunix/liboraInstaller.so Java locatio

I have collected below brief information about some of the performance metrices used in OC4J monitoring in SOA Suite . This is a brief idea. Have a look :- CPU (%) Description: The percentage of the CPU currently being used by the OC4J instance, or--on the JVM Metrics page--the selected Java Virtual Machine (JVM). User Action: Use this metric to determine how much of the CPU is in use by the OC4J instance or JVM. If you encounter consistent high readings for this metric, try to isolate the problem by monitoring individual applications and services that are running on the OC4J instance. If no problems are found, consider obtaining additional hardware resources or load balancing solutions. Memory (MB) Description: Indicates how much of your total physical memory is in use by the current OC4J instance, or--on the JVM Metrics page--by the selected Java Virtual Machine (JVM). User Action: Use this metric to monitor memory use by the OC4J instance or JVM. Compare this with h

You may get an out of memory exception if the Oracle WSM is configured so that its runtime memory requirements exceed the JVM default configuration. One known situation where this can occur is if you patch Oracle WSM 10.1.3 to 10.1.3.1. To avoid this error, you need to increase the size of the Java heap. To change the values of the Java heap 1. Log in to Oracle Enterprise Manager 10g Application Server Control. 2. In the Cluster Topology page, locate the Members section, and click home. 3. Click Administration. 4. Find Server Properties in the Task Name list, and click the Go to Task icon. 5. Edit the values for Maximum heap size (1024 Mb) and Initial heap size (512 Mb). 6. Add a row for the -XX:MaxPermSize (256 Mb) and -XX:PermSize (128 Mb) parameters and provide a value. 7. Click Apply. 8. Restart the server. Note: The values in parentheses are provided as an example only. These values were derived assuming that all components in the Oracle Application Server

It is important to ensure that only authorized consumers can call the web services that are exposed. The below solution applies only to security internal web services. All the internal web services will be secured using OWSM Server Agents. This document consists of steps to be taken on order to deploy server agents. To configure a server agent component in Oracle Web Services Manager Point your browser to the Web Services Manager Control Console and log in using your user name and password. The Web Services Manager Control Console is accessed with a URL of the form: http:// :port_number/ccore For example: httphttp://dceapocxxxx:8888/ccore/index.jsp 2. Click Add New Component. 3. On the Add New Component page, define: ■Component name ■Component type ■Container type Click Register. Define Policy Set for Server Agent To define the policy set for the server agent: 1. At the Web Services Manager Control Console, click Policy Management, then click Mana