Oracle Technologies Blog

By ASKM

imp information

Posted by Srikrishna Murthy Annam on September 30, 2009

Q) What is  napply option with opatch ?
ANS :Installs n number of patches at a time to several oracle homes.
The command to apply the following patches at a time is …
8447875  8534394  8537027

-bash-3.00$ pwd
/test/disco/product/disco_1012/PATCHES/8537032
-bash-3.00$ ls
8447875  8534394  8537027  README.html  README.txt  remove_demo.sh
-bash-3.00$ $ORACLE_HOME/OPatch/opatch napply -invPtrLoc $ORACLE_HOME/oraInst.loc
..
..
..

-bash-3.00$ $ORACLE_HOME/OPatch/opatch lsinventory -invPtrLoc $ORACLE_HOME/oraInst.loc | grep 8447875
3) Patch  8447875 applied on Wed Sep 09 19:38:39 CDT 2009
[ Bug fixes: 6490362 8447875 8351021  ]

-bash-3.00$ $ORACLE_HOME/OPatch/opatch lsinventory -invPtrLoc $ORACLE_HOME/oraInst.loc | grep 8534394

2) Patch  8534394 applied on Wed Sep 09 19:46:26 CDT 2009
[ Bug fixes: 6350565 6079585 4175906 5901912 6864078 4486132 5896963 6647005 5095815 4519477 5347751 4691191 4754900 5861360 8290534 5382595 5071931 5458543 6607951 5179574 4329444 5029950 5464895 5029952 5029954 5738539 5648727 4402808 5631915 4871035 5091108 5114396 6455161 5584790 4605877 4751932 5751672 5490845 6753516 8534394 3345756 5933477 7592360 5094098 5015557 4679094 5154689 5675556 5222931 5910829 5227879 4152843 4661844 6079603 5637094 7044603 4905112 6016022 8290629 4166537 7120513 5276400 7154097 7154098 5408664 6395024 4146291 6397568 5901877 4768040 5049074 7022400 5960451 5490935 5049077 4593539 4680009 4542188 4555795 5406923 4359124 5258410 5689908 4969005 3962946 3743912 5648102 5057964 5014128 4873311 4439469 4331689 6705965 4597251 4903532 6055387 7576788 5650178 5225797 4047969 4554284 5376215 4874628 5401921 5151518 4458415 4900129 5226235 7375686 5095648 4561867 5239126 4712638 4925103 5354517 4745776 4939157 5998987 6404864 7300525 5501362 4587572 4969029 6270140 5055442 7334756 6639839 4492467 5222032 5151675 5242647 6999528 7137797 6864202 6737308 4587431 5605370 6647068 4335559 6826532 5417371 4671216 5065930 4575854 5355257 6130365 5243019 7173149 4966417 6639553 5884075 4899479 4610820 3837600 5092688 4528572 4449900 4601861 6009358 4226736 6404447 4348230 5233111 5644862 4197970  ]
-bash-3.00$ $ORACLE_HOME/OPatch/opatch lsinventory -invPtrLoc $ORACLE_HOME/oraInst.loc | grep 8537027

1) Patch  8537027 applied on Wed Sep 09 19:47:15 CDT 2009
[ Bug fixes: 7379127 7608327 7156655 7156648 8265594 7135493 8537027 7135488 8298232 7379122  ]
-bash-3.00$

Check the link : http://download.oracle.com/docs/cd/B28359_01/em.111/b31207/oui7_opatch.htm#CHDCIGJC

Q) How to check whether  the application MTs are with shared tech stack or not ?
ANS : Following commands should result in the same value

grep s_iASconfig_home $CONTEXT_FILE
grep s_weboh_oh $CONTEXT_FILE

Q)How to install enterprise manager dbconsole in a DHCP enabled system?
Ans : If you want to install an em dbconsole in a local machine which is DHCP inabled , it will fail in pre-requesites check with loopback adapter error. The solution is to install a loopback adaptor before starting em dbconsole installation.

On Linux :
Edit file /etc/hosts and place
127.0.0.1 localhost.localdomain localhost

On Windows XP
=============
Navigation
Control panel -> add hardware -> select “Yes, I have already connected the hardware” -> select “Add a new hardware device” ->
select “Install the hardware that I manually select from a list”  -> select “Network adapters” -> select “Manufacturer: Select Microsoft” and “Network Adapter: Select Microsoft Loopback Adapter” -> Click on Finish

Go to Desktop and click on “My Network Places”
Choose properties -> select the newly created network connection -> Choose “Properties” -> Use the following IP address ->
IP address= 192.168.x.x (x is any value between 0 and 255)
Subnet mask=Enter 255.255.255.0
Click OK

Add a line to the SYSTEM_DRIVE:\WINDOWS\system32\drivers\etc\hosts
<IP address u assigned above>  mycomputer.mydomain.com   mycomputer

Confirmation:
============
Ping <ip address>
Ping <mycomputer>

Q) Solution for “ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes” ?

Sometimes you may get the ORA-20000 error while executing the script with pl/sql code.  Pls set the folloing sqlplus setting to avoid the error …..

SQL> set serveroutput on size 200000
SQL> <Execute the script >

Q) Following error in alert log file ?

ORA-00312: online log 2 thread 1: ‘/u01/app/oracle/oradata/askm/redo02.log’
Wed Sep 30 05:04:49 2009
Errors in file /u01/app/oracle/diag/rdbms/askm/askm/trace/askm_ora_2291.trc:
ORA-16038: log 1 sequence# 91 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: ‘/u01/app/oracle/oradata/askm/redo01.log’
USER (ospid: 2291): terminating the instance due to error 16038
Instance terminated by USER, pid = 2291

Solution :

To verify this run the following query. It will show the size of the recovery area and how full it is:

SQL> startup mount
ORACLE instance started.

Total System Global Area  849530880 bytes
Fixed Size                  1339824 bytes
Variable Size             536874576 bytes
Database Buffers          306184192 bytes
Redo Buffers                5132288 bytes
Database mounted.
SQL> set lines 100
col name format a60
select  name
,       floor(space_limit / 1024 / 1024) “Size MB”
,       ceil(space_used  / 1024 / 1024) “Used MB”
from    v$recovery_file_dest
order by nameSQL> SQL>   2    3    4    5  ;

NAME                                                            Size MB    Used MB
———————————————————— ———- ———-
/u01/app/oracle/flash_recovery_area                                3852       3826

SQL> alter system set db_recovery_file_dest_size=6g scope=both;

System altered.

SQL> alter database open;

Database altered.

SQL>

Advertisements

One Response to “imp information”

  1. JimmyBean said

    I don’t know If I said it already but …Hey good stuff…keep up the good work! 🙂 I read a lot of blogs on a daily basis and for the most part, people lack substance but, I just wanted to make a quick comment to say I’m glad I found your blog. Thanks,)

    A definite great read..Jim Bean

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: