dbafusion

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