1).Note:443699.1 How to check if certain Oracle Applications product/module is implemented?
2).Note:228779.1 How to Merge Patches Using admrgpch
3).Note: 343987.1 How to uninstall backout an Oracle Applications 11i Patch
4).Note:181665.1 Release 11i Adpatch Basics
5).Note:415129.1 How to change IP Address for server with Oracle Applications; Is it supported to use DNS address resolution instead of IP
6).Note:337762.1 How to Remove an Oracle Applications 11i node.
7).Note:400920.1 What Affect Will IP Address Change Have On Oracle Applications?
8).Note:375130.1 How to apply patch without enabling Maintenance Mode
9).Note:Oracle Applications Patching FAQ
Monday, July 16, 2007
Friday, July 13, 2007
How to Configure 32/64 Bit Kernel for Solaris OS
The below link helps you to convert 32 bit OS to 64 Bit and Vise Versa.
http://developers.sun.com/solaris/articles/64_bit_booting.html#Q6
http://developers.sun.com/solaris/articles/64_bit_booting.html#Q6
Monday, July 9, 2007
How to Check the installed Oracle Software is 32/64 bit ?
You can check the Oracle Bit by 2 methods
Method 1:
Go to ORACLE_HOME/bin
$ file oracle
oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped
Method 2:-
Login to sqlplus,
use the following query,
SQL> select metadata from sys.kopm$ ;
-----------------------
METADATA
-----------------------
0000006001240F050B0C030C0C0504050D06090708050F0505050F05050505050A050505050504050607080823472323081123081141B0230083001F07D01300000000000000000000000000000000000000000000000000000000000000000000000000
If the output has 'B023' string then the database is 32 bit else if it is B047 then it is 64 bit
Method 1:
Go to ORACLE_HOME/bin
$ file oracle
oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped
Method 2:-
Login to sqlplus,
use the following query,
SQL> select metadata from sys.kopm$ ;
-----------------------
METADATA
-----------------------
0000006001240F050B0C030C0C0504050D06090708050F0505050F05050505050A050505050504050607080823472323081123081141B0230083001F07D01300000000000000000000000000000000000000000000000000000000000000000000000000
If the output has 'B023' string then the database is 32 bit else if it is B047 then it is 64 bit
Thursday, June 14, 2007
R12 New Features.........
1).Jinitiator is removed.Instead native Java Plugin is used
2).Jserv is replaced by OC4J Container
3).10g Forms and reports are in place
4).Base release of Oracle AS is now 10g
5).XML Publiser is given more importance over Oracle Reports
6).R12 Comes with 10g Database
7).Change in the UI(swan Interface). Looks cool.
2).Jserv is replaced by OC4J Container
3).10g Forms and reports are in place
4).Base release of Oracle AS is now 10g
5).XML Publiser is given more importance over Oracle Reports
6).R12 Comes with 10g Database
7).Change in the UI(swan Interface). Looks cool.
Tuesday, June 12, 2007
Oracle DBA Tool Bar for IE and Firefox
Oracle has come up with toolbar for DBA to search easily from Oracle Websites
Below is the link for to download,
http://www.oracle.com/technology/toolbar/install/index.html?msgid=5191908
It is available for both IE and FireFox.
Donno how useful it is .Will wait and see.
Below is the link for to download,
http://www.oracle.com/technology/toolbar/install/index.html?msgid=5191908
It is available for both IE and FireFox.
Donno how useful it is .Will wait and see.
Wednesday, May 9, 2007
Trace Analyzer : The Good Tool for Performance Monitoring
Just Came across one Good Performance Analysis Tool from Oracle.Itz Trace Analyzer.
Trace Analyzer is an Improved version of Oracle TKPROF.With Proper Layout and Format.
Trace Analyzer Utility download details are given in Metalink Note:224270.1
Download from the link and follow the steps given in the instruction.txt of the trca.zip file
Steps to Trace the Concurrent Request.
1).Enable the trace for the Concurrent Program using the following Navigation
Concurrent->Program->Define->'Program Name'
And check out the Enable Trace option
this will create the *trc file in udump directory
2)Once the Concurrent Request is completed look for the trace file with the name of request id
$ ls *requestid*
3).Login to sqlplus
SQL> conn apps/
SQL>set serverout on
SQL>exec trca$i.trace_analyzer('vis_ora_14328_SYSADMIN.trc');
Once the above procedure is completed it will create the html file the local Directory.
This file can be used for analysis of Performance.
Trace Analyzer is an Improved version of Oracle TKPROF.With Proper Layout and Format.
Trace Analyzer Utility download details are given in Metalink Note:224270.1
Download from the link and follow the steps given in the instruction.txt of the trca.zip file
Steps to Trace the Concurrent Request.
1).Enable the trace for the Concurrent Program using the following Navigation
Concurrent->Program->Define->'Program Name'
And check out the Enable Trace option
this will create the *trc file in udump directory
2)Once the Concurrent Request is completed look for the trace file with the name of request id
$ ls *requestid*
3).Login to sqlplus
SQL> conn apps/
SQL>set serverout on
SQL>exec trca$i.trace_analyzer('vis_ora_14328_SYSADMIN.trc');
Once the above procedure is completed it will create the html file the local Directory.
This file can be used for analysis of Performance.
Tuesday, May 8, 2007
Bullet Points:- Oracle Applications DBA
1). Environment Variable APPLFENV gives the environment variables file(*env file) which is sourced in the node
2).To find the Character Set of the Database
Use,
SQL>select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET'
3)To find the free disk space in ASM
Use,
SQL.select sum(free_mb) from v$asm_disk;
4).To skip the particular job when running a patch/maintenance pack
use the hidden option '8' in 'adctrl' to skip and start the job.
5)To check whether the Applications running on RAC
SQL>select is_rac_db from fnd_databases;Output would be either Y/N
6)To check the location of Voting Disk
Use ,
$crsctl query css votedisk
O/P would be somewhat like,
0 0 /dev/votediskLocated 1 Vote disk
2).To find the Character Set of the Database
Use,
SQL>select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET'
3)To find the free disk space in ASM
Use,
SQL.select sum(free_mb) from v$asm_disk;
4).To skip the particular job when running a patch/maintenance pack
use the hidden option '8' in 'adctrl' to skip and start the job.
5)To check whether the Applications running on RAC
SQL>select is_rac_db from fnd_databases;Output would be either Y/N
6)To check the location of Voting Disk
Use ,
$crsctl query css votedisk
O/P would be somewhat like,
0 0 /dev/votediskLocated 1 Vote disk
Handy UNIX Commands for Oracle Professionals
Like to share some good and handy UNIX commands which would be really helpful support professionals
1).To find the top 10 larger files in the Directory,
$ls -lrt | awk '{print $5,$9}' | sort -nr head | xargs ls -lrt
2) To find the access and Modification details of a file
$istat
*This command is available for AIX only
3).To remove file which are older then say 7 days
$find . -mtime +7 -exec rm {} \;
1).To find the top 10 larger files in the Directory,
$ls -lrt | awk '{print $5,$9}' | sort -nr head | xargs ls -lrt
2) To find the access and Modification details of a file
$istat
*This command is available for AIX only
3).To remove file which are older then say 7 days
$find . -mtime +7 -exec rm {} \;
4).Locate Files That Contain Certain Strings
$ find . -printxargs grep -i v\$dba_objects
5)To Delete top 10 files in directory which has huge size
use,
$du -sk sort -nr head awk '{print $2}' xargs rm -r
Tuesday, April 10, 2007
STORAGE:What is SAN and NAS ?
Overview of NAS and SAN
NAS(Network attached storage) :
As the data storage across the LAN grew exponentialy,the concept of File Sharing Server came into existence .This is usually a desktop with Network Operating System(NOS) installed with set of hard drives which can beaccessed by the client through LAN.Example of NOS can be Windows,UNIX,MacOS. With the Traditional File Server,When the server goes down the Storage device attached to that also be impactedand may result in corruption ,also overhead of complete operating system and other accessories are inevitable. NAS has desiged in order to overcome these drawbacks by segregating the server from the storage and only the essential part of the OS for File Sharing is used.
NAS Box has set of RAID arrays which is controlled by a devicecalled the storage is controlled by the embedded OS .NAS doesn't require any monitor,keyboard,mouse as Traditionalfile server.
On the Network,NAS will be assigned a IP address through which Clients access to data from the storage.NAS access the data by taking file name as the reference
NAS(Network attached storage) :
As the data storage across the LAN grew exponentialy,the concept of File Sharing Server came into existence .This is usually a desktop with Network Operating System(NOS) installed with set of hard drives which can beaccessed by the client through LAN.Example of NOS can be Windows,UNIX,MacOS. With the Traditional File Server,When the server goes down the Storage device attached to that also be impactedand may result in corruption ,also overhead of complete operating system and other accessories are inevitable. NAS has desiged in order to overcome these drawbacks by segregating the server from the storage and only the essential part of the OS for File Sharing is used.
NAS Box has set of RAID arrays which is controlled by a devicecalled the storage is controlled by the embedded OS .NAS doesn't require any monitor,keyboard,mouse as Traditionalfile server.
On the Network,NAS will be assigned a IP address through which Clients access to data from the storage.NAS access the data by taking file name as the reference
NAS typically uses Ethernet as its network protocol for clients to access the storage.It also supports NFS,CIFS(COMMON INTERNET FILE SYSTEM),HTTP,TCP/IP protocols
SAN(Storage Area Network):
SAN is high speed special purpose network that interconnects various kinds of data storage devices associated withthe data servers.A SAN consists of a communication infrastructure, which provides physical connections and amanagement layer, which organizes the connections, storage elements, and computer systems so that data transfer is secure and robust.
SAN are generally used in large scale enterprises Unlike NAS, SAN uses the block level transfer of data between theservers storage.This gives very high I/O rate which quite critical in mission critical applications.
SAN introduces the flexibility of networking to enable one or more heterogeneous servers to share a commonstorage utility, which may comprise many storage devices, including disk, tape, and optical storage. The storage utilitycan be extended even for 10 KM.
SAN(Storage Area Network):
SAN is high speed special purpose network that interconnects various kinds of data storage devices associated withthe data servers.A SAN consists of a communication infrastructure, which provides physical connections and amanagement layer, which organizes the connections, storage elements, and computer systems so that data transfer is secure and robust.
SAN are generally used in large scale enterprises Unlike NAS, SAN uses the block level transfer of data between theservers storage.This gives very high I/O rate which quite critical in mission critical applications.
SAN introduces the flexibility of networking to enable one or more heterogeneous servers to share a commonstorage utility, which may comprise many storage devices, including disk, tape, and optical storage. The storage utilitycan be extended even for 10 KM.
SAN uses ethernet,Fibre Channel,SCSI as the physical data link between the server and the storage.Fibre Channelprotocol is the architecture on which SAN is built.
Subscribe to:
Posts (Atom)