*) Paste what ever copied:- p
2) GUN ZIP the file:-
-----------------------------
gzip file_name
Note:- While trying to download gunzip file from server to local machine it should be done in binary mode. Then it can exact using the wipzip software in WINDOWS Operating System.
After gzip, if we want to unzip the file then use the following.
gunzip file_name
2.1) To unzip or gunzip the file :-
---------------------------------------------
gunzip file_name
Example:-
gunzip XYZ_1.0_5.tar.gz
2.2) To untar the file:-
------------------------------
tar -xvf file_name
Example:-
tar -xvf XYZ_1.0_5.tar
3) To run the strings for the spawand program:-
-------------------------------------------------------------
strings -a (shell_script_file_name) > (logfile.log)
Example:-
strings -a GLPURGE > /home/partners-home/hex/preddy/phani1.log
3.1) Basic grep command:-
-----------------------------------
Example:-
grep 'DROP index' adwork001.log > /home/partners-home/xyz/preddy/dropindex.txt
Note:- grep command is just like the search for some specfic word in your windows file.
In Windows Operating System, we use the (CTRL+F) and then we give the word we want to search. Similarly, grep is used for UNIX or LINUX Operating system. In the above Example, I am searching for the 'DROP index' Word in adwork001.log file. And I want all the finding of this search stored in some file. So, I have given the path and file name where it should save.
4) Specfic to some project:-
-------------------------------------
To check the number lst files:-
-----------------------------------------
Example:-
ls -altr *.lst | wc -l
Note:- If some folder have some specfic extension files, then we can count the number of that specfic extension files then we can use the above command. In the above example, I am searching for the 'lst' extension files count.
To check the number of sql files with hit files :-
------------------------------------------------------------
grep '\.sql' *.lst | wc -l
Note:- Say, we have some .sql files names in all the lst files in some folder. Then we can use the grep command to count the sql file names.
To check the number of files with hits in the lst file:-
------------------------------------------------------------------
grep 'Number of files with hits : [1-9]' *.lst
Note:- You can also give the count of the files with the range. In the above example, I have givne the range from 1 to 9. If it find any number from this range then, it will get in the count.
To create the file of the complete module :-
--------------------------------------------------------
grep '\.sql' *.lst > lst_sql_'module_name'.txt
Example:-
grep '\.sql' *.lst > lst_sql_gl.txt
Note:- The above example to do the search and to the search results in some given file name.
5) To find the file in the current folder and subfolder:-
---------------------------------------------------------------------
find . -name ‘file_name*.sql’ -print
Example:-
find -i . -name 'poXWFUNT*.sql' -print
Note:- POXWFUNT.sql is the file name which I want to search. 'i' in the above command indicates that, search should not be based on case sensitive.
6) To grep the file for a specific word:-
-------------------------------------------------
grep -i 'WORD' FILE_NAME > log_file_name
Example:-
grep -i 'ALTER table' adwork001.log > altertable.txt
7) To Know the PORT number of Env file:-
-----------------------------------------------------
setenv | grep PORT
Note:- Run the above command after login to Instance. And you have would have the read privileges for the file. This is mostly useful for people, who are working in the Oracle Application.
7.1) For specfic session we can change the variable value:-
-------------------------------------------------------------------------
setenv variable_name variable_value
Example :- The following was the current value.
INSTANCE_ENVID=XYZ12
(Used the following command to check the value (setenv | grep OBT)).
setenv OBTADMIN_ENVID OBT_12
The above command has changed the value of the variable.
---------------------------------------------------------------------
OBTADMIN_ENVID=OBT_12
Note:- If you exit from the session and then variable value will be revert back.
8) To know the path of the log and out files of the application:-
------------------------------------------------------------------------------
>>cd $APPLCSF
There you will have the log and out folders.
You can also try the following command to know the value of the APPLCSF variable.
env | grep log
9) Turn-on the application server:-
----------------------------------------------
./oraWebAndForms.sh start Instance name
Example:-
./oraWebAndForms.sh start XYZ12
Note:-
------
1) XYZ12 is the Instane name.
2) After turnning the Database and concurrent manager up. still the application front end will not open. The you need to run the above script from the applmgr user
To login to different user:-
------------------------------
sudo su - applmgr
Note:- applmgr is the superuser name. This username can depends on the DBA, what they have given at your Instance.
9.1) If you are getting 500 Internal error message after bounce back then try this:-
-----------------------------------------------------------------------------------------------------
Try to restart your application and restart your manage and see if it resolve the issue.
For the 12 Release, the above solution may not work. After you cleared _pages in R12, you'll need to recompile because the default mode is 'justrun' instead of 'recompile' as was in 11i.
I did the following while applmgr in my Instance XYZ12 env and the login now works:
1. cd $FND_TOP/patch/115/bin
2. ./ojspCompile.pl --compile --flush -p 2
(You can check if you are able to open the application or not). If you are still facing the issue then try rebounce the application and see if it resolve the issue).
3. /home/applmgr/oraWebAndForms.sh bounce xyz12
(./oraWebAndForms.sh bounce zyx12)
Note:-
------
You need to run the above script in the applmgr user
sudo su - applmgr
10) To start or stop the Internal concurrent manager:-
---------------------------------------------------------------------
cd $ADMIN_SCRIPTS_HOME/
./adcmctl.sh start apps/apps
./adcmctl.sh stop apps/apps
Note:- This need to be run from applmgr user
-----
sudo su - applmgr
11) To stop the database or start the database:-
------------------------------------------------------------
cd $ORACLE_HOME/appsutil/scripts/xyz12_server/
Note:- The above path is specfic to my server Instance.
To stop the database:- adstopdb.sql*
To start the database:- adstrtdb.sql*
Note:- This need to be run from Oracle user.
------
sudo su - oracle
12) Converting all the tabs to space in the file:-
-----------------------------------------------------------
By setting the following options in your ~/.vimrc file,
when you use tabs, spaces are actually entered into the file,
although it "feels" like there are tabs because backspaces work as they would with tabs.
You'll never have to worry about differing tabstop standards again.
Try it out, I promise you’ll be completely sold!
set softtabstop=4
set expandtab
set shiftwidth=4
Note also that if you want to convert a file with tabs to all spaces, set the above options and then use:
:retab!
13) To know the Operating system on server (unix):-
------------------------------------------------------------------
>uname
Example:-
-----------
2007.08.06-3:18:03 preddy@oscar[6]/home/partners-home/xyz/phani/xyz_23Jul/abc/la/utils > uname
HP-UX
14) To know the Operating system on server from database:-
--------------------------------------------------------------------------
begin
dbms_output.put_line('Port String: '||dbms_utility.port_string);
end;
15) Admin utility to compile all the invalid objects:-
-----------------------------------------------------------------
i) This utility is available for the applmgr user. Use the following command to login with applmgr user.
>>sudo su - applmgr
ii) Choose the Instance and then use the following command to run the adadmin utility.
>>adadmin
{ Note:- It will ask for the $APPL_TOP path. If the default path is not the correct one then provide the correct path.
It will ask for the Log file name. (Default name will be (adadmin.log)).
It will ask if you can be notified by email if a failure occurs. (Default will be set for NO).
It will ask for the Batchsize (Default is 1000).
It will ask for the correct database name.
It will ask to enter the password for your 'SYSTEM' ORACLE schema.("manager" will be the password).
(manager password will be the one you enter manually. Rest of things you take the default values.)
It will ask to enter the ORACLE password of Application Object Library (default will be [APPS]).
}
iii) To will give the menu with different options.
----------------------------------------------------
We will choose the "Compile/Reload Applications Database Entities menu" option. It will be 3 option normally.
iv) To will again give the other set of menu optins.
-----------------------------------------------
We will choose "Compile APPS schema" option to compile all the Invalid objects in APPS schema.
(Note:- You can also use $ORACLE_HOME/rdbms/admin/utlrp.sql (which will compile all invalid objects thru SVRMGRL.)).
17) To know apps password:-
--------------------------------------
cd $ORACLE_HOME/reports60/server
more CGIcmd.dat
You will find userid=APPS/apps_pass@Instance_name
Note:- If you have the FTP access for server files. Then we can know the Apps password.
18) QUOTA:-
---------------------
Say employees are allocated a certain amount of disk space on the file system for their personal files, say 1000Mb. If you go over your quota, you are given some 'n' days to remove excess files.
To check your current quota and how much of it you have used. For that,you can use the following command.
> quota -v
19)
DF:-
------------
To find out how much space is left on the fileserver, use the following command.
> df .
20)
DU:-
-------------
The du command outputs the number of kilobytes used by each subdirectory. Useful if you have gone over quota and you want to find out which directory has the most files. From your home-directory, use the following command.
> du -s *
The -s flag will display only a summary (total size) and the * means all files and directories.
21)
GZIP:-
---------------
This reduces the size of a file, thus freeing valuable disk space. This compresses the file. it similar to the Winzip in the Windows Operating system.
Example:-
> ls -l phani.txt
note the size of the file using ls -l , then to compress phani.txt, use the following command.
> gzip phani.txt
This will compress the file and place it in a file called phani.txt.gz
To see the change in size, use ls -l again.
To expand the file, use the gunzip command.
> gunzip phani.txt.gz
This is similar to the Unzip the file in your Windows Operating system.
22) ZCAT:-
----------------
zcat will read gzipped files without needing to uncompress them first.
> zcat phani.txt.gz
If the text scrolls too fast for you, pipe the output though less .
> zcat phani.txt.gz | less
23) FILE:-
File classifies the named files according to the type of data they contain, for example ascii (text), pictures, compressed data, etc.. To report on all files in your home directory, use the following command.
> file *
24)
DIFF:-
----------------
This command compares the contents of two files and displays the differences. Say you have a file called file1 and you edit some part of it and save it as file2. To see the differences use the following command.
> diff file1 file2
25)
ECHO:-
------------------
echo $variable_value
The value of the environment variable can get from the echo command.
Example:-
echo $APPL_TOP
In the above command we get the APPL_TOP variable value set in the environment file. APPL_TOP is the environment variable in the environment file.
25) REPLACE Character in File:-
------------------
Say, we want to replace the ~ or single Quote with Enter or some other symbol.
Example:- sed -i 's/~/\n/g' OUT_*.TXT 2>/dev/null
In this command, "~" would be replaced with enter ("/n")
Example:- sed -i 's/'\''/\n/g' edidata.* 2>/dev/null
In this command, \'' Note: for single quote " ' " , we have to include the wild string too.
26) General Commands:-
------------------------------
Command | Meaning |
ls | list files and directories |
ls -a | list all files and directories |
mkdir | make a directory |
cd directory | change to named directory |
cd | change to home-directory |
cd ~ | change to home-directory |
cd .. | change to parent directory |
pwd | display the path of the current directory |
cp file1 file2 | copy file1 and call it file2 |
mv file1 file2 | move or rename file1 to file2 |
rm file | remove a file |
rmdir directory | remove a directory |
cat file | display a file |
less file | display a file a page at a time |
head file | display the first few lines of a file |
tail file | display the last few lines of a file |
grep 'keyword' file | search a file for keywords |
wc file | count number of lines/words/characters in file |
command > file | redirect standard output to a file |
command >> file | append standard output to a file |
command < file | redirect standard input from a file |
command1 | command2 | pipe the output of command1 to the input of command2 |
cat file1 file2 > file0 | concatenate file1 and file2 to file0 |
sort | sort data |
who | list users currently logged in |
* | match any number of characters |
? | match one character |
man command | read the online manual page for a command |
whatis command | brief description of a command |
apropos keyword | match commands with keyword in their man pages |
ls -lag | list access rights for all files |
chmod [options] file | change access rights for named file |
command & | run command in background |
^C | kill the job running in the foreground |
^Z | suspend the job running in the foreground |
bg | background the suspended job |
jobs | list current jobs |
fg %1 | foreground job number 1 |
kill %1 | kill job number 1 |
ps | list current processes |
kill 26152 | kill process number 26152 |
26 comments:
Excellent ....I like to add one point .When you are giving details about any functional thing .Please write about the basic functionalitu .As technical users do not know the financial terms and their significance .
Sure dude.
Its very helpful for the beginners .
Good Dude
I am glad to see your comment.
Regards,
Phani
Hi Friends,
You can use the following command to search for given word in any file in the given path.
grep -ilr "Your_word_for Search" Path >>log_file.csv
Example:-
-------
grep -ilr "OE_LINE_ADJ" /cdv501/pvcs_staging/ >>adjutillist.csv
Thanks for sharing the valuable informaion.
Phonegap Training in chennai | Phonegap Training chennai | Phonegap course in chennai | Phonegap course chennai
The information you have given here is truly helpful to me. CCNA- It’s a certification program based on routing & switching for starting level network engineers that helps improve your investment in knowledge of networking & increase the value of employer’s network,
Regards,
ccna course in Chennai|ccna training in Chennai
Your design of the blog is really eye-catching. More over the content is also very productive. Information you have provided is really very beneficial.
UNIX Training in noida
Such a great articles in my carrier, It's wonderful commands like easiest understand words of knowledge in information's.
Oracle Training in Chennai
Delhi Education Institute,Deiedu
online mba in India,
mba course in India
correspondence mba in india
distance mba in india
Mba in fast track
Distance education in india
Engineering courses in india
Engineering degree in india
Best safari in kenya
Best tour companies in kenya
Best safari in kenya
Best tour companies in kenya
kenya safari masai mara
Kenya Safari Holidays Packages
Kenya Safari Tour Packages
Best safari in kenya
Best tour companies in kenya
vermeer
Nice Blog, Thanks for Sharing this blog
Unix Institute in Gurgaon
Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site.
Best IOT Training Institute In Noida ,
INDustrial Training in Noida ,
paid internship training in Noida ,
Best Software Testing Training institute in Noida,
iOS Training institute in Noida
,
iPhone apps Training institute in Noida,
Android Training Institute In Noida,
Dot Net Training Institute in Noida ,
SAP FICO Training Institute in Noida ,
blue prism training in noida,
SAP MM Training Institute in Noida ,
Automation Anywhere Training Institute In Noida ,
Kafka Training Institute in Noida
Jenkins training institute in Noida
Devops training institute in Noida
OWASP training institute in Noida
JULIA training institute in Noida
HASKELL training institute in Noida,
Artificial Intelligence Training institutes in Noida ,
best php training institute in noida ,
mvc training institute in noida ,
angularjs training institute in noida ,
Flipkart promo codes
Flipkart deals & coupons
flipkart coupon code
flipkart coupons offer promo code
Amazon promo code
amazon offers
amazon offers and deals
amazon coupon code
amazon deal of the day
cleartrip promo codes
cleartrip coupon code
cleartrip offers and deals
cleartrip deals
MMT promo Codes
MMT coupon codes
Makemytrip promo codes
makemytrip offers
makemytrip deals & offers
healthkart coupon code
healthkart promo codes
healthkart deals and offers
healthkart discount offers
Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site
samsung Galaxy Note 9 smartphone
Honor 8X smartphone
Huawei Mate 20 X smartphone
.OnePlus C type Earphones
Apple iPhone XR specification
Xiaomi Mi 8 Youth Edition smartphone
samsung Galaxy Note 9 Price
Honor 8X Price
Huawei Mate 20 X Price
.OnePlus C type Price
Apple iPhone XR Price
Xiaomi Mi 8 Youth Editions Price
samsung Galaxy Note 9 Specification
Honor 8X Specification
Huawei Mate 20 X Specification
.OnePlus C type Specification
Apple iPhone XR Specification
Xiaomi Mi 8 Youth Editions Specification
samsung Galaxy Note 9 Feature
Honor 8X Feature
Huawei Mate 20 X Feature
.OnePlus C type Feature
Apple iPhone XR Feature
Xiaomi Mi 8 Youth Editions Feature
Hi,
I found the article plainly considerable and the information published by you might benefit innumerable learners. Continue sharing this beneficial guidance and keep sharing.
Thanks!
Best Oracle Training Institute
Best Oracle Training Institute
Wonderful Article on Oracle Stuff and really amazing stuff..
SAP Training in Chennai
Java Training in Chennai
QTP Training in Chennai
Hardware and Networking Training in Chennai
SAP ABAP Training in Chennai
SAP FICO Training in Chennai
SAP SD Training in Chennai
SAP MM Training in Chennai
SAP PP Training in Chennai
AWS Training in Chennai
Amazing Stuff with lots of Informations..
SAP Training in Chennai
Java Training in Chennai
Software Testing Training in Chennai
Hardware and Networking Training in Chennai
Informatica Training in Chennai
CCNA Training in Chennai
Oracle Training in Chennai
Cloud Computing Training in Chennai
Azure Training in Chennai
AWS Training in Chennai
Excellent
SAP Training in Chennai
Java Training in Chennai
Selenium Training in Chennai
QTP Training in Chennai
Hardware and Networking Training in Chennai
CCNA Training in Chennai
MCITP Training in Chennai
Oracle Training in Chennai
PHP Training in Chennai
AWS Training in Chennai
Very Informative blog thank you for sharing. Keep sharing.
Best software training institute in Chennai. Make your career development the best by learning software courses.
cloud computing training institute in chennai
devops training in chennai
rpa training in chennai
Your new valuable key points imply much a person like me and
extremely more to my office workers. With thanks; from every one of
us.
dot net training in chennai
core java training in chennai
manual testing training in Chennai
Thanks for this innovative blog. Keep posting the updates.
Oracle Training in Chennai
Post a Comment