NaturalOracle DataGaurd tutorial Series Coming Soon!! Natural
For Any queries, please mail us at support@funoracleapps.com

Self Service Form

1 comment
If we want to launch the form directly without login to front end then we can use the selfservice form link.

If the form is in servlet mode :
Servlet mode:- http://<server name>:<port>/forms/frmservlet

If the form is in socket mode :
Socket mode:- http://<server name>:<port>/OA_HTML/frmservlet

1 comment :

Post a Comment

Query for Checking the Object Accessed by a particular SID

No comments
If we want to check the objects that a particular session id(SID) is accessing in oracle we can use the below SQL.

SELECT a.object,
       a.owner,
       a.type,
       a.sid,
       s.username,
       s.osuser,
       s.program
FROM   v$access a,
       v$session s
WHERE  a.sid   = s.sid
AND    a.sid = &sid_to_check
ORDER BY a.object

No comments :

Post a Comment

Upgrading the Java Plugin in Oracle Apps R12

2 comments
Upgrading the Java Plugin in Oracle Apps R12

Steps to be followed:
 
1.Login to the Middle Tier(Web Node)
2.Set Application Environment
3.Shutdown Services on Web node
4.Go to the Jinitiator folder in Common Top
cd $COMMON_TOP/webapps/oacore/util/jinitiator
5.Copy the new version of Java Plugin to jintiator location
cp j2se16033.exe  .
6. Run the txkSetPlugin.sh Script on Web Node(If multi node then run on all webnodes)  $FND_TOP/bin/txkSetPlugin.sh  16033
7.Start services on web node

2 comments :

Post a Comment

Some Useful Unix Commands

No comments
1.Deleting files older than N number of days ? 
find . -name '*.trc' -mtime +[N in days]  -exec rm {} \;  
Command will delete files older then N days in that directory

2.Copying file keeping timestamp preserve
cp -ip file.txt file_txt_bkp

3.Listing files modified in last N days
find . -mtime -<ndays> -exec ls -lt {} \;

4.Sorting files based on Size of file ?
ls -l | sort -nrk 5  | more
du -sm *|sort -nr|head -10


5.Finding CPU & Memory detail 

->cat /proc/cpuinfo  (CPU)
->cat /proc/meminfo (Memory)
->topas


6.Finding if any service is listening on particular port or not ?
netstat -an | grep {port no} 

7.Finding Process ID (PID) associated with any port ?
lsof | grep {port no.} 
lsof should be installed and in path.Many times it will be installed eith root user.Make sure you have that permission.

9.Finding a pattern in some file in a directory ?
grep pattern  file_name  ( find pattern in particular file )
grep -i pattern  file_name (find pattern ignoring the case)

10.Create symbolic link to a file ?
ln -s  pointing_to_original_file  symbolic_link_name

example
 ln -s /home/text.txt test.txt

11.History of command executed in the unix box
fc -l
fc -e - ls ( Would execute the last ls command.) 

History command will also do the same
history

12. Compressing a bigfile
zip -r new.zip new
or
compress file_name

13.Creating a tar file
tar -cvwf file.tar myfile.txt

14.Extracting the files from a tar file
tar -xvwf myfile.tar(System would unarchive (untar) the myfile.tar file into the current directory.)

tar -xvwzf myfile.tar.gz(System would unarchive (untar) the myfile.tar.gz file in the current directory.)

14.Extracting a gz file?
Use guzip command as follows:
gunzip file.gz
OR
gzip -d file.gz

15.Extract a tar.gz or .tgz file?
Files with extension tar.gz or .tgz are tar files compressed with gzip. On Unix system extract them with following command:
gunzip < file.tar.gz | tar xvf -
gunzip < file.tgz | tar xvf -

If you have GNU tar (Linux system) you can use the z option directly:
tar xvzf file.tar.gz
tar xvzf file.tgz

 
16.Using mailx command
echo "This is going to be body of the mail" |mailx -s "Subject:Testing" "false@gmail.com"


17.Checking the file system free and used space
df -gt 

No comments :

Post a Comment

The persistent store "_WLS_AdminServer" could not be deployed: weblogic.store.PersistentStoreException

No comments
<Error> <Store> <BEA-280061><The persistent store "_WLS_AdminServer" could not be deployed: weblogic.store.PersistentStoreException:
 [Store:280105]The persistent file store "_WLS_AdminServer" cannot open file _WLS_ADMINSERVER000000.DAT.



If there is above issue while starting the weblogic server then the *.lok files and *.DAT files should be cleared.

Solution:
The files has to be cleared from $DOMIAN_HOME/servers/(server_name)
find . -name '*.DAT' -print -exec rm {} \;
find . -name '*.lok' -print -exec rm {} \;


For Example

For Admin server


$DOMAIN_HOME/servers/<server name>/tmp/Adminserver.lok
$DOMAIN_HOME/servers/<server name>/data/ldap/ldapfiles/Embedded.lok
$DOMAIN_HOME/servers/<server name>/data/store/default/_WLS_ADMINSERVER000000.DAT
$DOMAIN_HOME/servers/<server name>/data/store/diagnostics/WLS_DIAGNOSTICS000000.DAT

For Managed servers

$DOMAIN_HOME/servers/<server name>/tmp/<servername>.lok
$DOMAIN_HOME/servers/<server name>/data/ldap/ldapfiles/Embedded.lok
$DOMAIN_HOME/servers/<server name>/data/ldap/store/default/_WLS_<servername>000000.DAT
$DOMAIN_HOME/servers/<server name>/data/ldap/store/diagnostics/WLS_DIAGNOSTICS000000.DAT




No comments :

Post a Comment

Chekcing Fragmentation in Table for Oracle DB

1 comment
The below mentioned script can be used to check the table Fragmentation

Column owner   Format A6
Column table_name Format A25
Column "Fragmented-Actual"    Format A15
Column "Fragmented Size"   Format A17
Column "Actual Data Size"   Format A17

SELECT 

owner,table_name,
round((blocks*8),2)||' kb' "Fragmented Size",
round((num_rows*avg_row_len/1024),2)||' kb' "Actual Data Size",
(round((blocks*8),2) - round((num_rows*avg_row_len/1024),2) )||' kb' "Fragmented-Actual"
FROM dba_tables
WHERE table_name = '&table_name' ;

1 comment :

Post a Comment

Checking RUP Patchset Level in Oracle Apps

No comments
Below script can be used to Find the RUP Patchset level in Oracle Apps

SELECT
    bug_number,
    decode(bug_number,
    '4334965', '11i.ATG_PF.H RUP3',
    '4676589', '11i.ATG_PF.H.RUP4',
    '5473858', '11i.ATG_PF.H.RUP5',
    '5903765', '11i.ATG_PF.H.RUP6',
    '6241631','11i.ATG_PF.H.RUP7') RUP_Patch_Description
    FROM ad_bugs
    WHERE
    bug_number in ( '4334965','4676589','5473858','5903765','6241631') ;

No comments :

Post a Comment