CM logfiles location information and Srvctl sample commands

Find Concurrent manager logs on Oracle Apps

Concurrent Mangers log files are located in the $APPLCSF/$APPLLOG location.
cd $APPLCSF/$APPLLOG
For ICM Log                                       –> ls -lrt *$TWO_TASK*
For Standard manager Log                  –> ls -lrt w*.mgr
For Conflict Resolution manager Log –> ls -lrt c*.mgr



sample Srvctl commands :

srvctl remove database -d db_name [-f]

srvctl remove database -d prod

srvctl start database -d db_name [-o start_options] [-c connect_str|-q]
srvctl start database -d db_name [-o open]
srvctl start database -d db_name -o nomount
srvctl start database -d db_name -o mount

srvctl start db -d prod
srvctl start database -d apps -o open

srvctl stop database -d db_name [-o stop_options] [-c connect_str|-q]

srvctl stop database -d db_name [-o normal]

srvctl stop database -d db_name -o transactional

srvctl stop database -d db_name -o immediate

srvctl stop database -d db_name -o abort

srvctl stop db -d crm -o immediate

srvctl status database -d db_name [-f] [-v] [-S level]

srvctl status database -d db_name -v service_name

srvctl status database -d hrms

srvctl enable database -d db_name
srvctl enable database -d vis

srvctl disable database -d db_name

srvctl disable db -d vis

srvctl config database

srvctl config database -d db_name [-a] [-t]

srvctl config database
srvctl config database -d HYD -a

 

 

 

Nodeapps:

---

#srvctl add nodeapps -n node_name -o ORACLE_HOME -A name|ip/netmask[/if1[|if2|...]]

#srvctl add nodeapps -n lnx02 -o $ORACLE_HOME -A 192.168.0.151/255.255.0.0/eth0

#srvctl remove nodeapps -n node_names [-f]

#srvctl start nodeapps -n node_name     -- Starts GSD, VIP, listener & ONS

#srvctl stop nodeapps -n node_name [-r] -- Stops GSD, VIP, listener & ONS

#srvctl status nodeapps -n node_name

#srvctl config nodeapps -n node_name [-a] [-g] [-o] [-s] [-l]

-a Display VIP configuration
-g Display GSD configuration
-s Display ONS daemon configuration
-l Display listener configuration

#srvctl modify nodeapps -n node_name [-A new_vip_address]

#srvctl modify nodeapps -n lnx06 -A 10.50.99.43/255.255.252.0/eth0

#srvctl getenv nodeapps -n node_name [-t name_list]

#srvctl setenv nodeapps -n node_name {-t "name=val[,name=val,...]"|-T "name=val"}
#srvctl setenv nodeapps –n adcracdbq3 –t “TNS_ADMIN=/u01/app/oracle/product/11.1/asm/network/admin”

#srvctl unsetenv nodeapps -n node_name [-t name_list]

In 11g Release 2, some command's syntax has been changed:
srvctl add nodeapps -n node_name -A {name|ip}/netmask[/if1[|if2|...]] [-m multicast_ip_address] [-p multicast_port_number] [-l ons_local_port] [-r ons_remote-port] [-t host[:port][,host[:port],...]] [-v]
srvctl add nodeapps -S subnet/netmask[/if1[|if2|...]] [-d dhcp_server_type] [-m multicast_ip_address] [-p multicast_port_number] [-l ons_local_port] [-r ons_remote-port] [-t host[:port][,host[:port],...]] [-v]
#srvctl add nodeapps -n devnode1 -A 1.2.3.4/255.255.255.0

srvctl remove nodeapps [-f] [-y] [-v]
srvctl remove nodeapps

srvctl start nodeapps [-n node_name] [-v]
srvctl start nodeapps

srvctl stop nodeapps [-n node_name] [-r] [-v]
srvctl stop nodeapps

srvctl status nodeapps

srvctl enable nodeapps [-g] [-v]
srvctl enable nodeapps -g -v

srvctl disable nodeapps [-g] [-v]
srvctl disable nodeapps -g -v

srvctl config nodeapps [-a] [-g] [-s] [-e]
srvctl config nodeapps -a -g -s -e

srvctl modify nodeapps [-n node_name -A new_vip_address] [-S subnet/netmask[/if1[|if2|...]] [-m multicast_ip_address] [-p multicast_port_number] [-e eons_listen_port] [-l ons_local_port] [-r ons_remote_port] [-t host[:port][,host:port,...]] [-v]
srvctl modify nodeapps -n mynode1 -A 100.200.300.40/255.255.255.0/eth0

srvctl getenv nodeapps [-a] [-g] [-s] [-e] [-t "name_list"] [-v]
srvctl getenv nodeapps -a

srvctl setenv nodeapps {-t "name=val[,name=val][...]" | -T "name=val"} [-v]
srvctl setenv nodeapps -T "CLASSPATH=/usr/local/jdk/jre/rt.jar" -v

srvctl unsetenv nodeapps -t "name_list" [-v]
srvctl unsetenv nodeapps -t "test_var1,test_var2"

ASM:

---

srvctl add asm -n node_name -i asminstance -o ORACLE_HOME [-p spfile]

srvctl remove asm -n node_name [-i asminstance] [-f]

srvctl remove asm -n db6

srvctl start asm -n node_name [-i asminstance] [-o start_options] [-c connect_str|-q]

srvctl start asm -n node_name [-i asminstance] [-o open]

srvctl start asm -n node_name [-i asminstance] -o nomount

srvctl start asm -n node_name [-i asminstance] -o mount

srvctl start asm -n linux01

srvctl stop asm -n node_name [-i asminstance] [-o stop_options] [-c connect_str|-q]

srvctl stop asm -n node_name [-i asminstance] [-o normal]

srvctl stop asm -n node_name [-i asminstance] -o transactional

srvctl stop asm -n node_name [-i asminstance] -o immediate

srvctl stop asm -n node_name [-i asminstance]-o abort

srvctl stop asm -n racnode1
srvctl stop asm -n devnode1 -i +asm1

srvctl status asm -n node_name

srvctl status asm -n racnode1

srvctl enable asm -n node_name [-i asminstance]
srvctl enable asm -n lnx03 -i +asm3

srvctl disable asm -n node_name [-i asminstance]

srvctl disable asm -n lnx02 -i +asm2

srvctl config asm -n node_name
srvctl config asm -n lnx08

srvctl modify asm -n node_name -i asminstance [-o ORACLE_HOME] [-p spfile]
srvctl modify asm –n rac6 -i +asm6 –o /u01/app/oracle/product/11.1/asm

In 11g Release 2, some command's syntax has been changed:
srvctl add asm [-l lsnr_name] [-p spfile] [-d asm_diskstring]
srvctl add asm
srvctl add asm -l LISTENERASM -p +dg_data/spfile.ora

srvctl remove asm [-f]
srvctl remove asm -f

srvctl start asm [-n node_name] [-o start_options]
srvctl start asm -n devnode1

srvctl stop asm [-n node_name] [-o stop_options] [-f]
srvctl stop asm -n devnode1 -f

srvctl status asm [-n node_name] [-a]
srvctl status asm -n devnode1 -a

srvctl enable asm [-n node_name]
srvctl enable asm -n devnode1

srvctl disable asm [-n node_name]
srvctl disable asm -n devnode1

srvctl config asm [-a]
srvctl config asm -a

srvctl modify asm [-l lsnr_name] [-p spfile] [-d asm_diskstring]
srvctl modify asm [-n node_name] [-l listener_name] [-d asm_diskstring] [-p spfile_path_name]
srvctl modify asm -l lsnr1

srvctl getenv asm [-t name[, ...]]
srvctl getenv asm

srvctl setenv asm {-t "name=val [,...]" | -T "name=value"}
srvctl setenv asm -t LANG=en

srvctl unsetenv asm -t "name[, ...]"
srvctl unsetenv asm -t CLASSPATH

Listener:

---

srvctl add listener -n node_name -o ORACLE_HOME [-l listener_name]  -- 11g R1 command

srvctl remove listener -n node_name [-l listener_name] -- 11g R1 command

srvctl start listener -n node_name [-l listener_names]
srvctl start listener -n node1

srvctl stop listener -n node_name [-l listener_names]

srvctl stop listener -n node1

srvctl status listener [-n node_name] [-l listener_names] -- 11g R1 command
srvctl status listener -n node2

srvctl config listener -n node_name

srvctl modify listener -n node_name [-l listener_names] -o ORACLE_HOME               -- 11g R1 command
srvctl modify listener -n racdb4 -o /u01/app/oracle/product/11.1/asm -l "LISTENER_RACDB4"

In 11g Release 2, some command's syntax has been changed:
srvctl add listener [-l lsnr_name] [-s] [-p "[TCP:]port[, ...][/IPC:key][/NMP:pipe_name][/TCPS:s_port] [/SDP:port]"] [-k network_number] [-o ORACLE_HOME]
srvctl add listener -l LISTENERASM -p "TCP:1522" -o $ORACLE_HOME
srvctl add listener -l listener112 -p 1341 -o /ora/ora112

srvctl remove listener [-l lsnr_name|-a] [-f]
srvctl remove listener -l lsnr01

srvctl stop listener [-n node_name] [-l lsnr_name] [-f]

srvctl enable listener [-l lsnr_name] [-n node_name]
srvctl enable listener -l listener_dev -n node5

srvctl disable listener [-l lsnr_name] [-n node_name]
srvctl disable listener -l listener_dev -n node5

srvctl config listener [-l lsnr_name] [-a]
srvctl config listener

srvctl modify listener [-l listener_name] [-o oracle_home] [-u user_name] [-p "[TCP:]port_list[/IPC:key][/NMP:pipe_name][/TCPS:s_port][/SDP:port]"] [-k network_number]
srvctl modify listener -n node1 -p "TCP:1521,1522"

srvctl getenv listener [-l lsnr_name] [-t name[, ...]]
srvctl getenv listener

srvctl setenv listener [-l lsnr_name] {-t "name=val [,...]" | -T "name=value"}
srvctl setenv listener -t LANG=en

srvctl unsetenv listener [-l lsnr_name] -t "name[, ...]"
srvctl unsetenv listener -t "TNS_ADMIN"

New srvctl commands in 11g Release 2

Diskgroup:

---

srvctl remove diskgroup -g diskgroup_name [-n node_list] [-f]

srvctl remove diskgroup -g DG1 -f

srvctl start diskgroup -g diskgroup_name [-n node_list]

srvctl start diskgroup -g diskgroup1 -n node1,node2

srvctl stop diskgroup -g diskgroup_name [-n node_list] [-f]

srvctl stop diskgroup -g ASM_FRA_DG

srvctl stop diskgroup -g dg1 -n node1,node2 -f

srvctl status diskgroup -g diskgroup_name [-n node_list] [-a]

srvctl status diskgroup -g dg_data -n node1,node2 -a

srvctl enable diskgroup -g diskgroup_name [-n node_list]

srvctl enable diskgroup -g diskgroup1 -n node1,node2

srvctl disable diskgroup -g diskgroup_name [-n node_list]

srvctl disable diskgroup -g dg_fra -n node1, node2

Home:

---

srvctl start home -o ORACLE_HOME -s state_file [-n node_name]

srvctl start home -o /u01/app/oracle/product/11.2.0/db_1 -s ~/state.txt

srvctl stop home -o ORACLE_HOME -s state_file [-t stop_options] [-n node_name] [-f]

srvctl stop home -o /u01/app/oracle/product/11.2.0/db_1 -s ~/state.txt

srvctl status home -o ORACLE_HOME -s state_file [-n node_name]

srvctl status home -o /u01/app/oracle/product/11.2.0/db_1 -s ~/state.txt

Thanks 

Srini

 

 

Oracle Application Language installation

1. Check if there is enough disk space on the  system Extra disk space is required for each additional  languages.

4   GB of disk space is require in $APPL_TOP for  each additional language 10 GB of disk space is required in oradata for each additional language 

2. Active the new Language(s) using Oracle  Applications Manager

Login to http://$mt_hostname.$domainname:$port_prefix15 as sysadmin 

Select Site Map -> System Configuration: Licence  Manager -> Languages

Select all the Languages that are in list

Select Next -> Submit

3. Maintain Multilingual Tables and  compile objects

Login to MT host 

Run adadmin

Select 4. Maintain Applications Database Entities

Select 3. Maintain Multi-Lingual Tables

Once this has completed use adadmin to  Maintain Snapshot information:- 

Select 7. Return  to Main Menu

Select 2. Maintain Applicatiosn Files Menu

Select 5. Maintain snapshot information

Select 2. Update current view snapshot (Note: This step can take a while - approximately 2 hours on a  test system)

Select 7. Return to Main Applications Files Menu

Select 7. Return to Main Menu

Select 3. Compile Reload Applications  Database Entities menu

Select 3. Compile flexfields

4. Manifest file for NLS

1 Generate the Manifest File

 Pre-req patch : 5635729 (for latest adgennls.pl file)

Login to $mt_hostname as ap$cust_id

perl $AD_TOP/bin/adgennls.pl

This generates a manifest file in the $APPL_TOP/admin/$TWO_TASK directory

This file contains all the active lanaguages.

2 Upload the Manifest

Copy this manifest file to your PC.

Login to https://updates.oracle.com/TransSync with you Metalink username and password.

Use the Request a New Patch button to upload the correct file and press Submit.

Note: Also choose 'Get Latest Translations'

You should  receive an email to your oracle email account once the NLS patch is available - it usually takes 7 - 8 hours.

Note: If you do not receive an email with the confirmation for a completed patch you may want to check https://updates.oracle.com/TransSync periodically - once the patch is available it should be listed on this page. The requested patch can be listed as 'In Progress',  'Merged Translation' or 'Full Translation' so please verify this before downloading it to the customer mid tier. Some patches can take up to 2 days for creation.

3 Download NLS Patch and apply.

Once the patch is available go back to https://updates.oracle.com/TransSync and you will see your patch.

If you can access updates.oracle.com directly from the server you can ftp the patch directly to the server (use your Metalink username and password).

If you cannot access updates.oracle.com  - click on the patch to download it to your PC then upload it to the server and apply.

 

Thanks

Srinivas

R12.2 interview Q&A

1. What is Jinitiator in Oracle Apps?

2. Where is Jinitiator being used in Oracle Apps ?

3. Why OC4J replaced with WebLogic server 11g?

4. Why we are still using Oracle Apps server 10g R3(10.1.2.3) for Forms & Reports

5. Why we used Dual File system in R12.2 ?

Application Tier File System has changed in 12.2 to Dual File System to support ………. (answer this in comment) ?  Register here for Oracle Apps DBA 12.2 Training to learn more on Dual File System or Online Patching (ADOP).

6. How do we know Apps tier is using FS1 or FS2 (where FS1 and FS2 are two file system from Apps Dual File System in 12.2)?

7. FS1 or FS2 (dual file system) is independent to each other – TRUE / FALSE ?

8. What is role of Concurrent Manager ?

9. Why do Concurrent Manager Fail (some of the scenarios in which manager could fail) ?

10. What is Database Version that comes with EBS and Can we use any database version with EBS or are there any restrictions ?

11. What is the purpose of patching in Oracle Apps (E-Business Suite) and is it Compulsory to Patch (More Question on Patching on Day3 of Apps DBA Training) ?

Well these are just handful of hundreds of questions we answer either in online class or in support ticket (all our trainings comes with 1 Year support for any queries) or in our

To ask questions like these or learn more about Oracle Apps DBA in 30 Days, register for our Oracle Apps DBA (R12.2) Training

 

 

Thanks 

Srini

Oracle EBS 12.2.4 application tier autoconfig fails after database upgrade from 11.2.0.3 to 11.2.0.4

Problem

Oracle EBS 12,2,4 application tier autoconfig fails with following error.

WARNING: [AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution.  Errors are grouped by directory and phase.
The report format is:
      <filename>  <phase>  <return code where appropriate>

  [PROFILE PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /u01/CRP/fs1/inst/apps/CRP_oracle/admin/install
      jtfictx.sh              INSTE8_PRF         1

AutoConfig is exiting with status 1

Cause

DECLARE
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drixmd.GetIndexRec
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 948
ORA-06512: at "CTXSYS.AD_CTX_DDL", line 336
ORA-06512: at line 96



Solution
connect /as sysdba

ALTER SESSION SET CURRENT_SCHEMA=SYS;
grant select on SYS.DBA_PROCEDURES to ctxsys;

ALTER SESSION SET CURRENT_SCHEMA=CTXSYS;
SET PAGESIZE 0
SELECT 'Calling ctx/admin/driacc.plb on ' || SYSTIMESTAMP FROM dual;
SET PAGESIZE 10

@@?/ctx/admin/driacc.plb;

@$ORACLE_HOME/rdbms/admin/utlrp.sql

set serveroutput on
execute sys.validate_context;

select comp_name, status, substr(version,1,10) as version from dba_registry where comp_id = 'CONTEXT';

Reference
 Can Not Validate CTXSYS.DRIACC Package (Doc ID 1906873.1)

Thanks
Srini