Connect
to Oracle Application Thru’ Internet Explorer as SYSADMIN Login for System
Administrator Responsibility.
Ø Checking
of Administer Concurrent Manager (where Actual = Target should be same).
Ø Checking
of View All Concurrent Requests (to see Report Server is connected)
Run Active Roles or Active Responsibilities
to check reports are working properly.
Ø Navigation Path: Switch
Responsibility to India Local Inventory -> Click Launch Interface Manager
-> Sembiam -> Check for Status Active on Cost Manager and Move
Transaction.
Connect
to TOAD (PROD, MIPLPROD, PREPROD, MIPLPRE)
Run the scripts for the respective instances from the Local
Machine path.
Checks Pending Transactions, Deadlocks, Tablespaces ->
Datafiles, Invalid Objects
Checking
status of processes,
Applpe21@iplapps: > cd $COMMON_TOP/admin/sc*/*
Applpe21@iplapps: > adcmctl.sh status apps/apps_PASSD
Applpe21@iplapps: > adapcctl.sh status
Applpe21@iplapps: > adrepctl.sh status
Applpe21@iplapps: > adfrmctl.sh status
Applpe21@iplapps: > lsnrctl status APPS_PROD
Applpe21@iplapps: > ps -ef|grep FNDLIBR|grep applpe21
Applpe21@iplapps: > ps -ef|grep f60webmx|grep applpe21
Applpe21@iplapps: > ps -ef|grep rwmts60|grep applpe21
Applpe21@iplapps: > ps -ef|grep FNDSM|grep applpe21
Applpe21@iplapps: > ps -ef|grep FNDCRM
Applpe21@iplapps: > ps -ef|grep ARLIBR
Applpe21@iplapps: > ps -ef|grep INVLIBR
Applpe21@iplapps: > ps -ef|grep PMON
To
clear Deadlocks in Dbase Server
Sqlplus ‘/as sysdba’
PROD> Alter
system kill session ‘SID, SERIAL #’;
Invalid
Objects
Connect to Dbase Server
Cd $ORACLE_HOME/rdbms/admin
Sqlplus ‘/as sysdba’
PROD>
@utlrp.sql
To
increase the Perfstat table space (Performance Tuning),
Connect to Dbase Server
Sqlplus perfstat/perfstat
PROD> @?/rdbms/admin/sptrunc.sql
To RESIZE
data file(Performance Tuning)
Connect to Dbase Server
Sqlplus ‘/as sysdba’
Alter database datafile ‘Physical Path of file’ resize XXXXM;
To ADD
tablespace
Alter tablespace <tablespace name> add datafile
‘Physical Path of file’ size XXXXM;
Request
for Misc. Transaction Menu
Go to PROD instance,
Navigator -> Security -> Responsibility -> Define
Search for Responsibility name as “India Local Inventory”
In Menu Exclusions -> delete Misc. Transaction
After confirmation Include the Misc. Transaction in the menu
Exclusions (Type as Function)
When
problem occurred on CONCURRENT MANAGER
> cd $COMMON_TOP/admin/scripts/ PROD_applpe21
./adcmctl.sh apps/APPSPWD
stop
./adcmctl.sh apps/APPSPWD
start
Removing
Log Files (Performance Tuning)
Weekly
based activities,
Ø cd
$COMMON_TOP/admin/log/PROD_applpe21 or $APPLCSF/$APPLLOG
ls –l *.log | more
find . -name
"*.log" -mtime +30 -exec rm {} \;
ls –l *.mgr | more
find . -name
"*.mgr" -mtime +30 -exec rm {} \;
ls –l *.req | more
find . -name
"*.req" -mtime +30 -exec rm {} \;
ls –l f60webmx* | more
find . -name “f60webmx*”
-mtime +30 -exec rm {} \;
ls –l *.rti | more
find . -name “*.rti” -mtime +30
-exec rm {} \;
Ø cd
$COMMON_TOP/admin/out/PROD_applpe21
or $APPLCSF/$APPLOUT
ls –l *.out | more
find . -name
"*.out" -mtime +30 -exec rm {} \;
CRONTAB
For job scheduling that are executed automatically by cron.
Login: orape21
Pwd : xxxxxx
> /etc
crontab
–e Edit your crontab file
crontab
–l Display your crontab file.
crontab
–r Remove your crontab file.
crontab
–v Display the last time you edited
your crontab file. (This option is only available on a few
systems.)
Backup
Procedure
Daily,
Archive Logs (or REDO Logs)
Loading Tape into the DATA LOADER,
Ø Switch
ON the Tape Drive, wait until display “DRIVE EMPTY” -> Cancel(Button)
->COMMAND(Display) -> Enter(Button) -> Import Slot 1(Display) -> Enter(Button) -> Import Slot
2(Display) -> Cancel(Button) -> Next(Button) -> Next(Button) -> Load Catridge(Display) ->
Enter(Button) -> Load Catridge Slot 1(Display) -> Enter(Button).
Connect to
128.212.3.101 as ROOT
Ø ioscan
–fnC tape (Checking Tape Drive connected to Database Server as
‘CLAIMED’)
Ø bdf
(Checking of File System for percentage on /oraprod)
Ø cd
oraprod/prodarch (PROD)
Ø ls –l
|more
Ø sh
filrm.sh (to remove archive log files) -> Month -> Date
Ø sh
filrm.dat
Ø tar cvf /dev/rmt/0mn . (Copy
Command)
Ø cd
oraprod/miplprodarch (MIPLPROD)
Ø ls –l
|more
Ø sh
filrm.sh (to remove archive log files) -> Month -> Date
Ø sh
filrm.dat
Ø tar cvf /dev/rmt/0mn . (Copy
Command)
Ø Cancel(Button)
->COMMAND(Display) -> Enter(Button) -> Next(Button) -> Next(Button)
-> Next(Button) -> Unload
Cartridge Slot 1(Display) -> Enter(Button) -> Drive Empty (Display) ->
Cancel(Button) -> Next(Button) -> Export
Slot 1(Display) -> Enter(Button) -> Cartridge comes OUT -> Remove
Cartridge -> Enter(Button) -> Previous (Button) -> Import Slot 1(Display) ->
Enter(Button) -> Import Slot 2(Display) -> Cancel(Button) ->
Next(Button) -> Next(Button) -> Load
Catridge(Display) -> Enter(Button) -> Load Catridge Slot 1(Display) ->
Enter(Button).
Ø Cancel(Button)
->COMMAND(Display) -> Enter(Button) -> Next(Button) -> Next(Button)
-> Next(Button) -> Unload Cartridge Slot 1(Display) -> Enter(Button)
-> Drive Empty (Display) -> Cancel(Button) -> Next(Button) ->
Export Slot 1(Display) -> Enter(Button) -> Cartridge comes OUT ->
Remove Cartridge -> Enter(Button) -> Cancel(Button) -> Cancel(Button).
Wait until
display “DRIVE EMPTY”, Switch OFF the Tape Drive
Weekly,
Full Backup (PROD, PREPROD, MIPLPROD, MIPLPRE)
Connect to 128.212.3.101(Dbase)
as ROOT
Ø ioscan
–fnC tape (Checking Tape Drive connected to Database Server as
‘CLAIMED’)
Ø bdf
(Checking of File System for percentage on /orape21
& /oramipl)
Ø fbackup
–f /dev/rmt/0mn –i /orape21 (Prod Dbase)
Ø fbackup
–f /dev/rmt/0mn –i /oramipl (Miplprod Dbase)
Connect to 128.212.3.111(Application)
as ROOT
Ø ioscan
–fnC tape (Checking Tape Drive connected to Database Server as
‘CLAIMED’)
Ø bdf
(Checking of File System for percentage on /applpe21
& /applmipl)
Ø fbackup
–f /dev/rmt/1mn –i /applpe21 (Prod Apps)
Ø fbackup
–f /dev/rmt/1mn –i /applmipl (Miplprod Apps)
Connect to 128.212.3.255(Dbase
& Application) as ROOT
Ø ioscan
–fnC tape (Checking Tape Drive connected to Database Server as
‘CLAIMED’)
Ø bdf
(Checking of File System for percentage on /orapre
& /applpre & /orampre
& /applmpre)
Ø fbackup
–f /dev/rmt/0mn –i /orapre (Preprod Dbase)
Ø fbackup
–f /dev/rmt/0mn –i /applpre (Preprod Apps)
Ø fbackup
–f /dev/rmt/0mn –i /orampre (Miplpre Dbase)
Ø fbackup
–f /dev/rmt/0mn –i /applmpre (Miplpre Apps)
No Hangup while copying during Cloning
The script is located on the
root login for 128.212.3.101 & 128.212.3.111
root> cd /etc
IPL
#nohup /etc/dbasecopy_IPL.sh & (Copy
Dbase file from PROD to PREPROD)
#nohup /etc/appscopy_IPL.sh & (Copy
Apps file from PROD to PREPROD)
MIPL
#nohup /etc/dbasecopy_MIPL.sh & (Copy
Dbase file from MIPLPROD to
MIPLPRE)
#nohup /etc/appscopy_MIPL.sh & (Copy
Apps file from MIPLPROD to
MIPLPRE)
nohup
stands for nohangup and '&' for running the script in the background. If
you use 'nohup' is session will not hang, you come back to the root prompt.
Then
check whether your script is running or not with. 'ps -ef |grep dbasecopy_IPL' command.
Then
type du –k (it is used to check the
copy duration of Time)
Registering RDF file to Application Instance
a) Connect to backend
through telnet as
Login: xxxxx
Pwd: xxxxx
>cd $ONT_TOP/reports/US
>pwd (present working
directory)
>ls –lt XXOM0000.* (Check
the respective report is available in the apps server), if it is not available
then transfer through ftp to the respective path.
Connect ftp for apps server
(as e.g. 128.212.3.255)
Login: xxxx
Pwd: xxxx
Ftp>mput XXOM000.rdf (Now
rdf file is transferred to the server).
b) Connect to frontend
through IE as sysadmin/pwd
System Administrator
navigator >select Concurrent>Program>Executable
From here, query for the
short name as XXOM0000 (eg. F11 / XXOM0000 / CTL+F11).If not, press F4, from
here type the details and SAVE
System Administrator
navigator >select Concurrent>Program>Define
Display Concurrent program screen in this
screen type program name, short name, application name, executable name,
method, format =RDF, style=landscape > SAVE
Grant SELECT permission
Ø Grant
select on <table_name> to < user_name>
Ø Eg : grant select on apps.ap_bank_account_uses_all to IPLIMPEXP