Oracle Apps DBA

Oracle Bit version: From Linux/Unix prompt: $file `which oracle` /oracle/app/oracle/product/10.2.0/db_1/bin/oracle: setuid setgid ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.2.5, dynamically linked (uses shared libs), not stripped From here you can find, oracle BIT version. From sql prompt: select distinct address from v$sql where rownum<2; ADDRESS ----------- 0000000386D3E060 If the address is 16 characters long, it is 64 bit. If it is 32 bit you will get an 8 character address. SQL> select distinct address from v$sql where rownum<2; ADDRESS ----------- 826A774C

Here I use: Primary database name: primary Standby database name: standby Requirements: 1. Primary database should be in archive log mode: ----------------------------------------------------------------------------------------------- 2 Priamry database should be in force logging. ----------------------------------------------------------------------------------------------- 3. Create Password file for primary database. orapwd file=/u01/app/oracle/product/10.2.0/db_1/dbs/orapw$ORACLE_SID.ora password=oracle entries=5 ----------------------------------------------------------------------------------------------- 4. Ensure that the MAXLOGFILES value for the primary database is one more than twice the actual number of redo log groups in the primary database. To check this run this sql query on primary database. select records_used "Current Groups",records_total "Max Groups", decode(sign(records_total-(records_used*2+1)),-1,LPAD('YES',21),LPAD('NO',21))

Get all installed products in E-Business Suite: set linesize 130 col application_name format a50 col meaning format a15 select b.application_name, c.meaning From applsys.FND_PRODUCT_INSTALLATIONS a, applsys.fnd_application_tl b,APPLSYS.fnd_lookup_values c where a.application_id = b.application_id and a.status = c.lookup_code and c.lookup_Type = 'FND_PRODUCT_STATUS';

Change IP address after Installing R12 in linux: Change the IP address In Host entry vi /etc/hosts Start the database Listener sh addlnctl.sh start $ORACLE_SID(This scripts UNDER $ADMIN_SCRIPTS_HOME folder) Start the database sh addbctl.sh start run autocofig in database tier sh adautocfg.sh enter apps password: run autocofig in apps tier sh adautocfg.sh enter apps password: start the apps sh adstrtal.sh

ORA-44410: XE edition single instance violation error Solution: With Oracle XE, you can run only one instance. If you want to clone the database on the XE instance you have to install the software and then you can clone your database. For example if you want to clone 10g database, install 10g database software only.