MADHU ORACLE APPS & RAC DBA: Daily Needs for a DBA(Activities)

Daily Needs for a DBA:
================

to fetch the apps pwd from 11.5.10.2
============================

grep -i pass $IAS_CONFIG_HOME/A*/modplsql/cfg/*.app

To kill the hung concurrent requests
==========================

update fnd_concurrent_requests set status_code='X' , phase_code='C' where request_id='150120296';

To fetch the code from backend
===========================

set pagesize 0
set linesize 200
Set head off
Spool GEWE_IR_SR_APPROVE_PKG.24Jun12.sql
select text from dba_source where NAME like 'GEWE_IR_SR_APPROVE_PKG%'
and type like '%PACKAGE%';
spool off

To generate the RSA and DSA public keys
=============================
inputs will be NONE ..all ENTER

ssh-keygen -t rsa --to generate RSA public key
/usr/bin/ssh-keygen -t dsa --to generate DSA public key

Purge the log files
===============
find . -name "*.req" -mtime +15 -exec rm {} \; --to purge 15 days old

Cluster command to check the current clusters from root in solaris
===============================================
/opt/VRTS/bin/hares -state |grep instance name |grep `hostname`|egrep -v 'mount|public|dg|share|nfs|mnt'

/opt/VRTSvcs/bin/hagrp -display instance name| grep -i frozen --to chk the database cluster status

/opt/VRTSvcs/bin/hagrp -freeze erpshst1 -sys `uname -n` --to keep in freeze mode

/opt/VRTS/bin/hares -offline orpogpp1_app_X -sys `hostname` --to bring down
/opt/VRTS/bin/hares -clear orpogpp1_app_X -sys `hostname` --to clear if its failed
/opt/VRTS/bin/hares -online orpogpp1_app_X -sys `hostname` --to bring up

To check the printer from backend
==========================
lpstat -a DSALBCGEIDTAG1

set bachspace to remove in solaris
===============================
stty erase ^h

Compiling forms,libraries,reports in Oracle Apps
=====================================

You all are may be well aware that we use f60gen for compiling forms and libraries in Oracle Applications Version 11i,But this is deprecated in R12 and we need to use frmcmp(Form Compiler) To compile forms,menus,PL/SQL libraries.

Compiling library files

11.5.9 and 11.5.10

$ f60gen module=/test/applmgr/11510/au/11.5.0/resource/OEXOELIN.pll userid=apps/passwd
output_file=/test/applmgr/11510/au/11.5.0/resource/OEXOELIN.plx module_type=library
batch=no compile_all=special

R12

$ frmcmp_batch module=/test/applmgr/11510/au/11.5.0/resource/OEXOELIN.pll userid=apps/passwd
output_file=/test/applmgr/11510/au/11.5.0/resource/OEXOELIN.plx module_type=library
batch=no compile_all=special

Compiling forms

11.5.9 and 11.5.10

[applmgr@oracle vis11appl]$export FORMS60_PATH=$FORMS60_PATH:$AU_TOP/fomrs/US
[applmgr@oracle vis11appl]$ echo $FORMS60_PATH
/apps/appl/vis11appl/au/11.5.0/resource:/apps/appl/vis11appl/au/11.5.0/resource/stub:
/apps/appl/vis11appl/au/11.5.0/forms/US
[applmgr@oracle vis11appl]$

f60gen module=$AU_TOP/forms/US/APXSUMBA.fmb userid=apps/appspasswd
output_file=$PROD_TOP/forms/US/APXSUMBA.fmx module_type=form
batch=no compile_all=special

R12

$ frmcmp_batch module=<path to the fmb file> userid=apps/<apps pwd>
output_file=<path to the fmx file> compile_all=special batch=yes

Compiling reports

Syntax

adrepgen userid=APPS/APPS
source=/<full path of schema top>/reports/<report name>.rdf
dest=/<full path of schema top>/reports/<report name>.rdf stype=rdffile
dtype=rdffile logfile=<report name>.log overwrite=yes batch=yes dunit=character

Example

adrepgen userid=apps/appspasswd source=/test/applmgr/11510/ap/11.5.0/reports/US/APXPBBLD.rdf dest=/test/applmgr/11510/admin/TEST/out/tmp001.rdf stype=rdffile dtype=rdffile logfile=/test/applmgr/11510/admin/TEST/out/adrep001.txt overwrite=yes batch=yes compile_all=yes

****what is the diff between batch=yes and no *******

If batch=yes -> it won't display the output,If batch=no -> it will display output

To Enable trace using running sql sessions
==============================

connect / as sysdba
oradebug setospid 84
oradebug unlimit
oradebug event 10046 trace name context forever,level 12
<wait for some considerable time>
oradebug event 10046 trace name context off

To Check the version of the files
=======================

strings -a ./hxc/11.5.0/patch/115/sql/hxcafnawf.pkb |grep '$Header'
adident Header ./hxc/11.5.0/patch/115/sql/hxcafnawf.pkb

Killing All processes at once:
===============================
Yesterday we come across a situation where we have to kill all look-a-like processes at once, this is what we followed to get rid of it.
kill -9 `ps -ef | grep -i applmgr | grep -i 889 | grep -v grep | awk '{print $2}'`
ps -efw | grep -i applmgr | grep | grep -v grep | awk '{print "kill -9 "$2}'

To avoid the relink set the below memory parameter
=====================================

Relink Issue:

$LDR_CNTRL="MAXDATA=0x40000000"
$export LDR_CNTRL

Move files for 30 days old
=====================
mv `find . -mtime +30` /opt/oracle/apps/common/OICP/inbound/XXATFAQS/processed/archive/ --move files older then 30 days

To verify the Stats
==============

set serveroutput on

exec fnd_stats.verify_stats('APPLSYS','FND_CONCURRENT_REQUESTS');--stats verification

SQL> exec dbms_stats.gather_table_stats ( -
ownname => 'INV', -
tabname => 'MTL_TRANSACTION_ACCOUNTS' -
)> > >
/

R12 Compile JSP:
==================

$FND_TOP/patch/115/bin

ojspCompile.pl

ojspCompile.pl --compile --fast --quiet

and clear persistence for login issues

Clear directory under persistence from below directory and restart all three OC4J
rm -rf $ORA_CONFIG_HOME/10.1.3/j2ee/oacore/persistence/*
rm -rf $ORA_CONFIG_HOME/10.1.3/j2ee/oafm/persistence/*
rm -rf $ORA_CONFIG_HOME/10.1.3/j2ee/forms/persistence/*

SQL Profile from backend
=====================
Create task ..it needs sql id and Name of task
=================================

DECLARE
my_task_name VARCHAR2 (30);
BEGIN
my_task_name := dbms_sqltune.create_tuning_task (
sql_id => '7asddw0r2wykx'
,plan_hash_value => NULL
,SCOPE => 'COMPREHENSIVE'
,time_limit => 3000
,task_name => 'C2CTST_Issue2'
,description => NULL);
END;
/
Execute task
==========
exec dbms_sqltune.execute_tuning_task (task_name => 'C2CTST_Issue2');

View the report and analyze
====================
set long 100000
set longchunksize 10000
set linesize 10000
set pages 10000
SELECT dbms_sqltune.report_tuning_task ('C2CTST_Issue1') FROM DUAL;

Output is not feasible then drop using below
================================
exec dbms_sqltune.drop_tuning_task(task_name => 'OPRD_CMchange');

Query to check latest roll ups
===============================

select bug_number Bug, decode(bug_number,3262159, 'Patch 11i.FND.H',
3262919, 'Patch 11i.FWK.H',3126422, '11.5.9 CU1',
3171663, '11.5.9 CU2',
3140000, '11.5.10 Maintenance Pack',
3240000, '11.5.10 Consolidated Update 1 (CU1)',
3640000, '11.5.10.1 Maintenance Pack',
4017300, '11.5.10 Consolidated Update 1 (CU1) for ATG Product Family',
3460000, '11.5.10 Consolidated Update 2 (CU2)',
3480000, '11.5.10.2 Maintenance Pack',
4125550, '11.5.10 Consolidated Update (CU2) for ATG Product Family',
3438354, 'Patch 11i.ATG_PF.H',
4334965, '11i.ATG_PF.H Rollup 3',
4676589, '11i.ATG_PF.H.RUP4',
5473858, '11i.ATG_PF.H.RUP5',
5903765, '11i.ATG_PF.H.RUP6',
6241631, '11i.ATG_PF.H.RUP7') Patch,
b.LAST_UPDATE_DATE Last_update
from AD_BUGS b
where b.BUG_NUMBER in ('3262919','3262159','3126422','3171633','3140000','3240000','3640000','4017300','3460000','3480000','4125550','3438354','4334965','4676589','5473858','5903765','6241631')
order by patch;

User's Responsibilities:
============================

SELECT frt.RESPONSIBILITY_NAME, furg.end_date
FROM
fnd_user_resp_groups furg,
FND_RESPONSIBILITY fr,
fnd_responsibility_tl frt,
fnd_user fu
WHERE fu.user_name = 'ORAKOUSHIKA'
AND fu.user_id = furg.user_id
AND furg.responsibility_id = fr.RESPONSIBILITY_ID
AND frt.responsibility_id = fr.RESPONSIBILITY_ID
ORDER BY 1;

FIND REDO LOGS INFO:
===================

select a.group#, a.bytes/(1024*1024) mb, a.members, b.member
from v$log a, v$logfile b
where a.group#=b.group#
order by a.group#;

Monitoring Cursors:
===================

select sum(a.value) total_cur, avg(a.value) avg_cur, max(a.value) max_cur,
s.username, s.machine
from v$sesstat a, v$statname b, v$session s
where a.statistic# = b.statistic# and s.sid=a.sid
and b.name = 'opened cursors current'
group by s.username, s.machine
order by 1 desc;

select a.value, s.username, s.sid, s.serial#
from v$sesstat a, v$statname b, v$session s
where a.statistic# = b.statistic# and s.sid=a.sid
and b.name = 'opened cursors current';

Querry to check Table-Defragmentation:

=====================================

select owner,table_name,round((blocks*8),2)/(1024) "TABLE SIZE",round((num_rows*avg_row_len/1024),2)/(1024) "ACTUAL DATA" ,

( round((blocks*8),2) - round((num_rows*avg_row_len/1024),2) )/(1024) "Wasted Space in Table"

from dba_tables

WHERE owner not in ( 'SYS' , 'SYSTEM' ) and ( round((blocks*8),2) - round((num_rows*avg_row_len/1024),2) )/(1024) is not null

order by 5 desc

DROP Issue

==============

SQL> DROP TABLE GEPSMFG.GEPS_LOB_TEMP CASCADE CONSTRAINTS;

SP2-0544: Command "drop" disabled in Product User Profile

SQL> select char_value from product_user_profile where ATTRIBUTE='DROP' and PRODUCT='SQL*Plus';

CHAR_VALUE

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

DISABLED

SQL> update product_user_profile set char_value='ENABLED' where ATTRIBUTE='DROP' and PRODUCT='SQL*Plus';

1 row updated.

SQL> commit;

Commit complete.

SQL>

DB Keep Pool

=============

set pages 999

set lines 92

spool keep_syn.lst

drop table t1;

create table t1 as

select

o.owner owner,

o.object_name object_name,

o.subobject_name subobject_name,

o.object_type object_type,

count(distinct file# || block#) num_blocks

from

dba_objects o,

v$bh bh

where

o.data_object_id = bh.objd

and

o.owner not in ('SYS','SYSTEM')

and

bh.status != 'free'

group by

o.owner,

o.object_name,

o.subobject_name,

o.object_type

order by

count(distinct file# || block#) desc

;

select

'alter '||s.segment_type||' '||t1.owner||'.'||s.segment_name||' storage (buffer_pool keep);'

from

t1,

dba_segments s

where

s.segment_name = t1.object_name

and

s.owner = t1.owner

and

s.segment_type = t1.object_type

and

nvl(s.partition_name,'-') = nvl(t1.subobject_name,'-')

and

buffer_pool <> 'KEEP'

and

object_type in ('TABLE','INDEX')

group by

s.segment_type,

t1.owner,

s.segment_name

having

(sum(num_blocks)/greatest(sum(blocks), .001))*100 > 80

;

Stored Outlines:

================

http://www.oracle-base.com/articles/misc/Outlines.php

SELECT SQL_ID,HASH_VALUE FROM V$SQL WHERE SQL_ID='bknbsrc9yaxfq';

SELECT SQL_TEXT FROM V$SQL WHERE HASH_VALUE='333805014';

ALTER SYSTEM SET OPTIMIZER_FEATURES_ENABLE ='9.2.0';

BEGIN

DBMS_OUTLN.create_outline(

hash_value => 333805014,

child_number => 0,

category => 'C2C2_OUTLINES2');

END;

SQL> SELECT name, category, sql_text FROM user_outlines WHERE category = 'C2C2_OUTLINES2';

NAME CATEGORY SQL_TEXT

------------------------------ ------------------------------ --------------------------------------------------------------------------------

SYS_OUTLINE_11071507080129703 C2C2_OUTLINES2 SELECT v.company_code, v.site_code, v.receiving_number, v.package_number, v.purc

COLUMN hint FORMAT A50

SELECT node, stage, join_pos, hint FROM user_outline_hints WHERE name = 'SYS_OUTLINE_11071507080129703';

SELECT name, category, used FROM user_outlines where category like '%C2C2%';

ALTER SYSTEM SET OPTIMIZER_FEATURES_ENABLE ='11.1.0.7';

ALTER system SET query_rewrite_enabled=TRUE;

ALTER system SET use_stored_outlines=C2C2_OUTLINES2;

run the query now

then explain plan for query

then check the outline status

SELECT name, category, used FROM user_outlines where category like '%C2C2%';

Shrink datafile:

================

column cmd format a75 word_wrapped

select 'alter database datafile '||file_name||' resize '||ceil( (nvl(hwm,1)*&&blksize)/1024/1024 )||'m;' cmd

from dba_data_files a, ( select file_id, max(block_id+blocks-1) hwm from dba_extents group by file_id ) b

where a.file_id = b.file_id(+) and ceil( blocks*&&blksize/1024/1024) -ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) > 0

***************ROLES*************

SET TERMOUT OFF

SET NEWPAGE 0

SET SPACE 0

SET LINESIZE 999

SET PAGESIZE 0

SET ECHO OFF

SET FEEDBACK OFF

SET HEADING OFF

spool roles_grant.sql

select 'grant ' ||GRANTED_ROLE || ' to ' ||GRANTEE|| ' with ADMIN OPTION ;'

from dba_role_privs where ADMIN_OPTION='YES'

UNION

select 'grant ' ||GRANTED_ROLE || ' to ' ||GRANTEE|| ';'

from dba_role_privs where ADMIN_OPTION='NO' ;

SELECT 'EXIT;' FROM DUAL;

SPOOL OFF

SET TERMOUT ON

EXIT;

***************object & sys privs***********

SET TERMOUT OFF

SET NEWPAGE 0

SET SPACE 0

SET LINESIZE 80

SET PAGESIZE 0

SET ECHO OFF

set feedback off

set heading off

spool sys_obj_privs_grant.sql

select 'grant ' || PRIVILEGE || ' to ' || GRANTEE|| ';'from dba_sys_privs

UNION

select 'grant ' ||PRIVILEGE|| ' on ' ||owner || '.'||TABLE_NAME|| ' to ' ||GRANTEE|| ' with grant OPTION ;'

from dba_tab_privs where GRANTABLE='YES' and owner not in (select username from dba_users where username like '%SYS%')

UNION

select 'grant ' ||PRIVILEGE|| ' on ' ||owner || '.'||TABLE_NAME|| ' to ' ||GRANTEE|| ';'

from dba_tab_privs where GRANTABLE='NO' and owner not in (select username from dba_users where username like '%SYS%');

SELECT 'EXIT;' FROM DUAL;

SPOOL OFF

SET TERMOUT ON

EXIT;

WF Sync from backend

=======================

begin apps.wf_local_synch.BULKSYNCHRONIZATION(P_ORIG_SYSTEM=>'ALL',

P_PARALLEL_PROCESSES=>2,

P_LOGGING=>'LOGGING', P_RAISEERRORS=>TRUE,

P_TEMPTABLESPACE=>'APPS_TS_TX_DATA'); END;

Resize datafiles

=================

set verify off

column file_name format a50 word_wrapped

column smallest format 999,990 heading "Smallest|Size|Poss."

column currsize format 999,990 heading "Current|Size"

column savings format 999,990 heading "Poss.|Savings"

break on report

compute sum of savings on report

column value new_val blksize

select value from v$parameter where name = 'db_block_size'

select file_name,

ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) smallest,

ceil( blocks*&&blksize/1024/1024) currsize,

ceil( blocks*&&blksize/1024/1024) -

ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) savings

from dba_data_files a,

( select file_id, max(block_id+blocks-1) hwm

from dba_extents

group by file_id ) b

where a.file_id = b.file_id(+)

column cmd format a75 word_wrapped

select 'alter database datafile '''||file_name||''' resize ' ||

ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) || 'm;' cmd

from dba_data_files a,

( select file_id, max(block_id+blocks-1) hwm

from dba_extents

group by file_id ) b

where a.file_id = b.file_id(+)

and ceil( blocks*&&blksize/1024/1024) -

ceil( (nvl(hwm,1)*&&blksize)/1024/1024 ) > 0 and a.tablespace_name='APPS_TS_TX_DATA'

Query to find object growth

==========================

SQL> col object_name for a35

SQL> set pages 0

SQL> set linesize 200

SQL> select * from (select c.TABLESPACE_NAME,c.segment_name "Object Name",b.object_type,

2 sum(space_used_delta)/1024/1024 "Growth (MB)"

3 from dba_hist_snapshot sn,

4 dba_hist_seg_stat a,

5 dba_objects b,

6 dba_segments c

7 where begin_interval_time > trunc(sysdate) - &days_back

8 and sn.snap_id = a.snap_id

9 and b.object_id = a.obj#

10 and b.owner = c.owner

11 and b.object_name = c.segment_name

12 and b.object_name = c.segment_name

13 group by c.TABLESPACE_NAME,c.segment_name,b.object_type)

14 order by 3 asc;

Enter value for days_back: 30

old 7: where begin_interval_time > trunc(sysdate) - &days_back

new 7: where begin_interval_time > trunc(sysdate) - 30

OPP

====

UPDATE fnd_cp_services

SET developer_parameters =

'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx1024m'

WHERE service_id = (SELECT manager_type

FROM fnd_concurrent_queues

WHERE concurrent_queue_name = 'FNDCPOPP');

SSO Issue

===========

select fpot.user_profile_option_name, fpov.profile_option_value,fpov.last_update_date,fu.user_name

from apps.fnd_profile_options fpo, apps.fnd_profile_options_tl fpot, apps.fnd_profile_option_values fpov, apps.fnd_user fu

where fpo.profile_option_id = fpov.profile_option_id

and fpov.level_id=10001

and fpov.last_updated_by=fu.user_id

and fpo.profile_option_name in ('APPS_FRAMEWORK_AGENT','APPS_SSO','APPS_SSO_LDAP_SYNC','APPS_SSO_LOCAL_LOGIN','APPS_SSO_ALLOW_MULTIPLE_ACCOUNTS','APPS_SSO_USER_CREATE_UPDATE','APPS_SSO_LINK_TRUTH_SRC','APPS_SSO_AUTO_LINK_USER','FND_OVERRIDE_SSO_LANG')

and fpo.profile_option_name=fpot.profile_option_name

and fpot.language='US'

order by 1;

select fpot.user_profile_option_name, fpov.profile_option_value,fpov.last_update_date,fu1.user_name

from apps.fnd_profile_options fpo, apps.fnd_profile_options_tl fpot, apps.fnd_profile_option_values fpov, apps.fnd_user fu,apps.fnd_user fu1

where fpo.profile_option_id = fpov.profile_option_id

and fpov.level_id=10004

and fpov.level_value=fu.user_id

and fpov.last_updated_by=fu1.user_id

and fpo.profile_option_name=fpot.profile_option_name

and fpot.language='US'

and fu.user_name='502064474'

order by 1;

select user_name,end_date,user_guid from apps.fnd_user where user_name='502078503';

Out of Memory

==============

SQL> !prtconf | grep Mem

Memory size: 131072 Megabytes

id -p --need to run in oracle user to find the projid

orapgre2@tsgsd5904 $ id -p

uid=502064261(orapgre2) gid=502064270(dbapgre2) projid=1001(user.orapgre2)

==============

Please managed user's shared memory appropriately. You will have to remove any shared memory in use in order to restart the database, user can manage.

tsgsd3900 > ipcs -m | grep oraogpx2

m 1912602658 0xbe82356d --rw-rw---- oraogpx2 dbaogpx2

m 587202582 0xbe82356c --rw-rw---- oraogpx2 dbaogpx2

use ipcrm command to remove memory in use to restart.

prctl -n project.max-shm-memory -i project 3 --to check the correct allocated memory

project: 1001: user.orapgre2

NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT

project.max-shm-memory

privileged 5.00GB - deny -

system 16.0EB max deny -

prctl -n project.max-shm-memory -r -v 37G -i project 3 --increased to 7G from 5G (pls verify before execute )

add responsibility using sqlplus

================================

BEGIN

fnd_user_pkg.addresp ('DBAREAD','SYSADMIN','SYSTEM_ADMINISTRATOR','STANDARD','System Administrator Responsibility',SYSDATE,SYSDATE + 2);

COMMIT;

END;

Pinning objects

===========

select 'execute dbms_shared_pool.keep('''||owner||'.'||name||''','''||decode(type,'PACKAGE BODY','P','PACKAGE','P','FUNCTION','P','PROCEDURE','P','TRIGGER','R','TYPE','T','SEQUENCE','Q')||''');' FROM v$db_object_cache

WHERE type NOT IN ('NOT LOADED','NON-EXISTENT','VIEW','TABLE','SEQUENCE','INVALID TYPE','CURSOR')AND loads>1 AND executions>loads AND executions>100 AND kept='NO'ORDER BY owner,namespace,type,executions desc;

RAC cluster commands

==================

ora.GPSPGJP1.lsnr

gpspgjp1_X

gpspgjp1_conc_mgr

gpspgjp1_dollaru

gpspgjp1_ebs_app_apppgjp101

gpspgjp1_ebs_app_apppgjp102

gpspgjp1_ebs_app_apppgjp1x01

gpspgjp1_ebs_app_apppgjp1x02

ora.gpspgjp1.db

tsgsp5010#

Status Services :

============================

crsctl status resource gpspgjp1_ebs_app_apppgjp1x01

crsctl status resource gpspgjp1_ebs_app_apppgjp1x02

crsctl status resource gpspgjp1_ebs_app_apppgjp101

crsctl status resource gpspgjp1_ebs_app_apppgjp102

crsctl status resource gpspgjp1_dollaru

crsctl status resource gpspgjp1_conc_mgr

crsctl status resource gpspgjp1_X

Stop Application Services

==========================

crsctl stop resource gpspgjp1_ebs_app_apppgjp1x01

crsctl stop resource gpspgjp1_ebs_app_apppgjp1x02

crsctl stop resource gpspgjp1_ebs_app_apppgjp101

crsctl stop resource gpspgjp1_ebs_app_apppgjp102

crsctl stop resource gpspgjp1_dollaru

crsctl stop resource gpspgjp1_conc_mgr

crsctl stop resource gpspgjp1_X

check for any third party Application like Aventx

=================================================== 8:14 AM

i. login to admin node as application user (apppgjp1)

ii. fcmgr -admin -c stop ( to stop the Aventx unix services)

cd $FCHOME/bin

fcmgr -admin

>lc ( to check the status of Aventx unix services)

>stop ( to stop the Aventx unix services if running)

>e (exit from the prompt)

iii. $FCHOME/cfg/scripts/srvctl stop ( to stop fcsrv services)

iv. sh $CATALINA_HOME/bin/shutdown.sh ( to stop tomcat web manager services)

v. sh /gpspgjp1/erpapp/appl/tools/AventX/oa/extproc/AventXDaemon/stop.sh

==================================================

Database and Listener

crsctl stop resource ora.GPSPGJP1.lsnr

crsctl stop resource ora.gpspgjp1.db

Status Services :

============================

crsctl status resource gpspgjp1_ebs_app_apppgjp1x01

crsctl status resource gpspgjp1_ebs_app_apppgjp1x02

crsctl status resource gpspgjp1_ebs_app_apppgjp101

crsctl status resource gpspgjp1_ebs_app_apppgjp102

crsctl status resource gpspgjp1_dollaru

crsctl status resource gpspgjp1_conc_mgr

crsctl status resource gpspgjp1_X 8:14 AM

Database and Listener

=====================================

crsctl start resource ora.gpspgjp1.db

crsctl start resource ora.GPSPGJP1.lsnr

Start Application Services

==========================

crsctl start resource gpspgjp1_conc_mgr

crsctl start resource gpspgjp1_X

crsctl start resource gpspgjp1_dollaru

crsctl start resource gpspgjp1_ebs_app_apppgjp1x01

crsctl start resource gpspgjp1_ebs_app_apppgjp1x02

crsctl start resource gpspgjp1_ebs_app_apppgjp101

crsctl start resource gpspgjp1_ebs_app_apppgjp102

check for any third party Application like Aventx

===================================================

i. login to admin node as application user (apppgjp1)

ii. fcmgr -admin -c start ( to start the Aventx unix services)

cd $FCHOME/bin

fcmgr -admin

>lc ( to check the status of Aventx unix services)

>stop ( to stop the Aventx unix services if running)

>e (exit from the prompt)

iii. $FCHOME/cfg/scripts/srvctl start ( to stop fcsrv services)

iv. sh $CATALINA_HOME/bin/startup.sh ( to stop tomcat web manager services)

v. sh /gpspgjp1/erpapp/appl/tools/AventX/oa/extproc/AventXDaemon/start.sh

IMAP

==========

-bash-3.2$ telnet gpsgnep1.tsg.ge.com 143

Trying 3.21.56.208...

Connected to gpsgnep1.tsg.ge.com (3.21.56.208).

Escape character is '^]'.

* OK Dovecot ready.

* login mailgnep xyz00abc

* OK Logged in.

* list * "*"

* LIST (\NoInferiors \UnMarked) "/" "DISCARD"

* LIST (\NoInferiors \UnMarked) "/" "PROCESSED"

* LIST (\NoInferiors \UnMarked) "/" "Trash"

* LIST (\NoInferiors \UnMarked) "/" "INBOX"

* OK List completed.

* logout

* BYE Logging out

* OK Logout completed.

Connection closed by foreign host.

Cluster name modify

====================

crsctl relocate resource appafmx102.appvip -n tsgxd2101 -f

To Fetch Version of Package from backend

===========================================

SELECT name ||' '|| text

FROM dba_source

WHERE line = 2

AND type LIKE 'PACKAGE BODY'

AND owner = 'APPS'

AND name = 'CSI_PROCESS_TXN_GRP'

ORDER BY name, type;

Daily Needs for a DBA(Activities)

No comments: