Enabling and Disabling FND Debug from Backend

Basically Two reasons why we need to enable/disable FND debug from backend.

1.When trying to enable “FND: Debug Log Enabled”, in the below window, it might gray out and may not allow you to change it.

2. Sometimes it happens when you see something like “FND Debug Enabled, this might reduce the performance” on the Login Screen, that time it becomes difficult to disable it from front end, as you may not be able to navigate or open the profile option form.

——————————-  Come'on Lets play now  ——————————–

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

To Enable FND DEBUG

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

SQL> SELECT PROFILE_OPTION_ID,PROFILE_OPTION_NAME FROM FND_PROFILE_OPTIONS_VL

WHERE START_DATE_ACTIVE <= SYSDATE

and NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE

and ( SITE_ENABLED_FLAG = 'Y' or APP_ENABLED_FLAG = 'Y'

or RESP_ENABLED_FLAG = 'Y' or USER_ENABLED_FLAG = 'Y'

or SERVER_ENABLED_FLAG = 'Y' or SERVERRESP_ENABLED_FLAG = 'Y'

 or ORG_ENABLED_FLAG = 'Y')

and ( UPPER(USER_PROFILE_OPTION_NAME) LIKE '%FND%DEBUG%'

and (USER_PROFILE_OPTION_NAME LIKE '%f%' or

USER_PROFILE_OPTION_NAME LIKE '%F%'))

order by user_profile_option_name;

PROFILE_OPTION_ID PROFILE_OPTION_NAME
—————– ———————————–
4176         AFLOG_ENABLED

3098       AFLOG_FILENAME
3099       AFLOG_LEVEL
8470       AFLOG_BUFFER_MODE
3100       AFLOG_MODULE
8468 DEBUG RULE THRESHOLD

6 rows selected.

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

Note Down this Profile_option_id for “AFLOG_ENABLED”

Now Execute another sql which will let you know the Value of that PROFILE_OPTION

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

SQL> 

col profile_option_value for A20;

col profile_option_id for 999999999;

select PROFILE_OPTION_ID, PROFILE_OPTION_VALUE from FND_PROFILE_OPTION_VALUES

where profile_option_id in ('4176','3098','3099');

SQL>

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

Now Update the Status as follows:

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

SQL> update FND_PROFILE_OPTION_VALUESset PROFILE_OPTION_VALUE = 'Y' where PROFILE_OPTION_VALUE = 'N'and PROFILE_OPTION_ID = 4176;

SQL> Commit;

Commit complete.

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

** To disable it, just set it to NO again  **

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

SELECT PROFILE_OPTION_ID,PROFILE_OPTION_NAME FROM FND_PROFILE_OPTIONS_VL
WHERE START_DATE_ACTIVE <= SYSDATE
and NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE
and ( SITE_ENABLED_FLAG = 'Y' or APP_ENABLED_FLAG = 'Y'
or RESP_ENABLED_FLAG = 'Y' or USER_ENABLED_FLAG = 'Y'
or SERVER_ENABLED_FLAG = 'Y' or SERVERRESP_ENABLED_FLAG = 'Y'
or ORG_ENABLED_FLAG = 'Y')
and ( UPPER(USER_PROFILE_OPTION_NAME) LIKE '%FND%DEBUG%'
and (USER_PROFILE_OPTION_NAME LIKE '%f%' or USER_PROFILE_OPTION_NAME LIKE '%F%'))
order by user_profile_option_name

 PROFILE_OPTION_ID    PROFILE_OPTION_NAME
—————–    ——————-
4176       AFLOG_ENABLED3098       AFLOG_FILENAME3099       AFLOG_LEVEL8479       AFLOG_BUFFER_MODE3100       AFLOG_MODULE8465       DEBUG RULE THRESHOLD

select PROFILE_OPTION_ID, PROFILE_OPTION_VALUE from FND_PROFILE_OPTION_VALUES
where profile_option_id in ('4176','3098','3099');

PROFILE_OPTION_ID PROFILE_OP
—————– ———-
3099       1
4176       Y
3098       NULL

SQL> update FND_PROFILE_OPTION_VALUESset PROFILE_OPTION_VALUE = 'N'where PROFILE_OPTION_VALUE = 'Y'and PROFILE_OPTION_ID = 4176;  => AFLOG_ENABLED will show ‘N’ now

I Hope this will definitely help you !!!

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

-v3nom

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

VI editor Tips and Tricks

vi editor in Linux is the best tool to create / edit a file. It has got more functions then any other Linux Editor (if you don't have access to GUI).

I am trying to keep this post as simple as I can. If you have any doubt or queries please ask.

In this post we will cover some exciting tricks and methods which I bet will be quite effective. 

I have categorized them in the following topics.

• changing text
• copying and pasting
• deleting
• external commands
• inserting
• miscellaneous
• moving
• options
• search and replace

Now lets check them one by one.

---------------------------------------------------------------------------------------------------------------------
changing text

cc	change a line
C	change from current cursor position to the end-of-line
cw	change from current cursor position to the end of the word
J	joins the next line to the current line (inserts a space between the two)
gJ	joins the next line to the current line (without a space)
:12,24j	join lines 12 thru 24, leaving a space between each line.
~	switch lower and upper cases
r	replace the current character with the next character typed
4rx	replace next four characters with "x"
R	overwrite until <esc>
s	substitute the current character and go into insert mode. Same as "rxi <ESC>"
S	substitute the current line, erase it, and go into insert mode, starting at the indentation of the line. Same as "cc"
>>	shift current line forward
3>>	shift three lines forward
>%	shift all lines until a matching brace or parenthesis
>}	shift to the end of the paragraph
>'m	shift to the marked line
<<	shift current line backward
vEU	change from here to end of word to uppercase
vEu	change from here to end of word to lowercase

--------------------------------------------------------------------------------------------------------------------
copying and pasting (We call yanking for Copying anything in Linux)

yl	yank (copy) current character
yn	yank n characters
yw	yank the current word
yy	yank the current line
Y	yank a line, same as "yy"
nyy	yank n lines of text
y$	yank to end of line
y)	yank to the end of the sentence
y'x	yank from current line to the mark x (use mx to mark as x)
y/word	yank from current position to "word"
"ay'm	yank from here to the mark. Place this into the named buffer "a". This will also allow one to switch files using the ":e fn" or ":n fn" command and then place the buffer back.
"ayy	yank current line into buffer a.
"a3Y	yank three lines, place into buffer "a"
"A3Y	append 3 lines, place into "a". This allows one to build up a buffer.
"ap	paste the contents of "a" back, below current line.
"zyy @z	"zyy places the highlighted text into buffer z; @z will run the contents of buffer z. This allows a search pattern to be written in the document and then reused.
p	paste to the right of the cursor
P	paste to the left of the cursor

---------------------------------------------------------------------------------------------------------------------
deleting

x	delete the character under the cursor
dd	delete the current line
d^	delete from current cursor position to the beginning of the line
d$	delete from current cursor position to the end of the line
dw	delete from current cursor position to the end of the word
d3w	delete three words
3dd	delete three lines
d/word	delete until you find word
dfx	delete from here until the character "x"
D	delete everything to the end of the current line (same as d$)
3dd	delete everything to the end of the current line and the following 2 lines
u	undo deletion
U	undo the line you just changed

---------------------------------------------------------------------------------------------------------------------
inserting

i	insert at the current character
I	insert at the beginning of the current line
20i- <ESC>	insert 20 dashes (-)
a	append to the right of the current character
A	append at the end of the current line
o	insert a new line immediately following the current line
O	insert a new line immediately before the current line

---------------------------------------------------------------------------------------------------------------------
moving

h	move the cursor one character to the left
j	move the cursor one character down
k	move the cursor one character up
l	move the cursor one character to the right
0	move cursor to the beginning of the current line
$	move cursor to the end of the current line
w	move cursor forward a word
3w	move cursor forward three words
W	move cursor forward, ignoring punctuation
b	move cursor back a word
B	move cursor back a word, ignoring punctuation
e	move cursor to the end of the word
E	move cursor to the end of the word, ignoring punctuation
G	move cursor to the last line of the file
nG	move cursor to the beginning of line n
1G	move to the first line of a file
n|	moves the cursor to the beginning of column n
f	find a character in the line, forward
fa	find the character "a" in the line, forward
2fa	find the second occurrence of "a" in the line, forward
F	find a character in the line, backward
Fz	find the character "z" in the line, backward
t	find up to a character in the line, forward
)	jump to the next sentence
}	jump to the next paragraph
]	jump to the next section
%	find matching brace or parenthesis
^b	scroll backwards one page. A count scrolls that many pages
^f	scroll forwards one page. A count scrolls that many pages
^u	scroll up half a screen
^d	scroll down half a screen
z <enter>	put current line at top of screen
z.	put current line at middle of screen
z-	put current line at bottom of screen
m	start a mark, the next character is the name, any character from a-z
ma	mark this spot with the character "a"
'a	return to the line marked "a"
`a	return to the character marked "a"
''	return to previous line (auto-mark)
``	return to previous character (auto-mark)

---------------------------------------------------------------------------------------------------------------------
search and replace

/word	search forward for word
?word	search backward for word
?word?z.	search forward for word, put line at the middle of screen
n	jump forward to next occurance of word
N	jump backward to next occurance of word
*	search forward for word under cursor (vim)
#	search backward for word under cursor (vim)
g*	search forward for word under cursor (partial match) (vim)
g#	search backward for word under cursor (partial match) (vim)
:noh	stop highlighting the word that was searched for
:s/old/new/	replaces first occurence of old with new on current line
:s/old/new/g	globally replaces old with new on current line
:%s/old/new/g	globally replaces old with new on all lines
:s/old/new/gc	confirms replacements
:%s/^V^M//g	globally remove DOS carriage returns
:%s/,/^V^M/g	globally replace commas with newlines (yes, I know this looks like it would insert DOS carriage returns, but it only inserts the newlines on Unix)
:%s/\s*$//	strip blanks from end of lines
:%s/^.\{30}//	remove the first 30 characters from each line
:%s/[ ^I]*$/!d	remove trailing whitespace (where ^I is produced by pressing the tab key)
:%s/.*/\L&/	convert the entire file to lowercase.
:s/.*/\u&/	convert the first character of line to uppercase.
:%s/\<./\u&/g	convert the first character of each word to uppercase \< matches the start of a word; . therefore matches the first character of a word; \u tells Vi(m) to uppercase the next character in the substitution string; & means substitute whatever was matched on the lhs;
:s/book{./\L&/	convert the first character after the { to lowercase.
:'x,.s/\([a-z]\)=/\1 =/	replace any lowercase character in the alphabet followed by an equal sign with the same character followed by a space and an equal sign, e.g., book= >> book =
::%s/\(That\) or \(this\)/\2 or \1/	change "that or this" to "this or that"
::%s/\(^\\foilhead{\(.*\)}\)/ %\1^M\\section{\2}/	comment out each line beginning with '\foilhead' and replace with a line beginning with '\section'; note the nested backreferences for keeping the rest of the line the same
::%s/\(.*\)/<a href="\1">\1<\/a>/	add HTML tags for references to files
:s/ \(\d\{1,2}\)\.\(\d\{1,2}\)\(.*\)/<a href="\1-\2.sh">\1.\2\3<\/a>	change a line of the form        1.1 Accessing Substring to        <a href="1-1.sh">1.1 Accessing Substrings</a>
:'x,.s:^\([^ ]\+\) \(.*\): <\1>\1 \2<\/\1><br>:	change a line of the form        KBD used for text to be typed by the user to        <KBD>KBD used for text to be typed by the user</KBD><br> Colons are used here instead of the usual slashes for separating the 'find' and 'replace' parts. The part ^\([^ ]\+\) finds all of the characters up to the first space and saves them for use in the 'replace' part as \1.
:'x,.s/^/#/	insert a pound sign (#) at the beginning of the line from the line marked with mx to the current line
:%s/word1\nword2//	remove word1 from the end of a line and word2 from the beginning of the next line; \n represents the newline between the two
:&	repeat previous substitution
:<up arrow>	recall : history
:g/string/d	deletes every line that contains string
:g/\.c/+|s/^/\.cc/	look for all ".c" commands, jump to next line, substitute the beginning of line with ".cc".
:g/^\..*/|s//\U&/	convert all characters at beginning of line that start with a "." to upper case.
:v/string/d	deletes every line that does not contain string
:g/.*/m0	This will reverse the order of the lines in the current file. m0 is the ex command to move the line to line 0.
:v/./d or :g/^$/d	Remove all blank lines.
:g/^\s*$/d	Removes all lines that only have whitespace.
:v/./.,/./-1join	Replaces multiple blank lines with just one blank line.

---------------------------------------------------------------------------------------------------------------------
options

:se ai	autoindent (unset with :se noai)
:se ff=unix	set fileformat to unix
:se ic	ignore case when searching.
:se list	display tabs and carriage returns
:se nu	display line numbers in the file. They are not actually in the file. (unset with :se nonu)
:se sm	show matching brace or parenthesis while inserting
:se smd	display the mode
:se sw=2	set shifting to 2 spaces
:se tabstop=4	set tabs to 4 spaces
^^D	turn off autoindent for current line, resume same place for the next line (up carrot and control-D)
0^D	reset the autoindent, start at the left margin

---------------------------------------------------------------------------------------------------------------------
external commands

!cmd	execute an external program
!!cmd	execute an external program, replacing the output with the results
!$	send from here to the end-of-line
!L	send from here to the last line of screen
!23G	send from here to line 23
!/word	send from here until you find "word"
!)	send from here until the next sentence
!}	send from here until the next paragraph
!!date	adds the date
!!cut -c41-	cut the first 40 characters from a file
3!!sort	send three lines to sort, and return the output
!Grev	send from here to the end of file to the "rev" command; the results will reverse the characters in each line
!}sort	sends from the current line until the first blank line to sort
:'x,.!sort	will sort from the line marked with mx to the current line
:r !ll	read the output of an "ll" command, and put it after the current line.
:'t,'b !spell	check spelling from mark t to mark b
:'t,. !awk '{print $3 " " $2 " " $1}'	reverse the order of three columns
:%! sed G	double space the entire file.
:1,5! sed G	double space the lines from 1-5
:'x,.!sed '/^$/d'	remove the blank lines from mark x to the current line

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

miscellaneous

^g	give file name, status, current line number and relative position
^l	refresh the screen (sometimes `^P' or `^R')
^v	visual mode. in Windows, Ctrl-v is mapped to paste text. Use Ctrl-q instead (vim)
.	repeat latest command
&	repeat latest `ex' substitute command, e.g. :s/wrong/good/
:ab lg longer	create an abbreviation. Whenever lg is typed, it will be replaced with longer.
vi +/string filename	start vi, jumping to the first occurrence of string
vi -r filename	recovers an open file after a crash
vi `cat somefile`	open a list of files that are in the file somefile
:r filename	insert file filename, placing its contents after current line
:1,4w filename	write lines 1 through 4 to filename
:e filename	edit filename
:f filename	change current file name to filename
:n	edit next file
:sh	call up the shell, run commands until a ^d (CONTROL-d), then return to editing
:vi	VI MODE. Used if "Q" is pressed, or called up ex, and now wish to use the visual mode
	In Insert mode, press the Ctrl-p or Ctrl-n key to complete part of a word that has been typed. This is useful for entering function names.
:<up arrow>	recall : history

----------------------------------------------------------------------------------------------------------------------
References:

1. vi Fast Reference Guide — the motherload of vi commands
2. Vim documentation: starting
3. Vi IMproved — VIM
4. Best of VIM Tips

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

Commitment towards the Life...! The Work-life balance.

Today's post is about the life a DBA and every other person must commit to.

From my past experiences I can say that, the life of a DBA can be very enjoyable one, if we follow some rules and be under our boundaries.
To be something, you have to keep hold on somethings, you have to keep somethings ON HOLD until you achieve your desired goal. You may need to work hard, or work smart to deal with your personal and professional life. One of my friend Aniket (Professional Network Engg.), his experiences and my thoughts helped me to come up with some of these points. So lets get started with these points.

These are the  Points we shall always keep in Mind while working:

1. Self Confidence

    Its the term what everyone writes in his/her resume. But the fact is only 20% people follow this rule sincerely. When it comes to compromise the work with your personal life, most people go with the flow of their personal matters. Personal matters drives you, but also they affect your professional life and your career growth.
   What I say is just not to commit anything in your personal life unless you achieve your professional goal what you desire for. And that will absolutely make you achieve your professional goal, and I bet it will make you work for your personal goal. So just SHOW confidence while you are working. Always achieve whatever comes in your way.


2. Be Ambitious

     Always try to do something more. What so ever you can do, to make it better!
Try to excel in your field. This statement is small, but when it comes to your work, you may think of lot many things and ultimately you see a bigger problem, as your field is vast.
So now what I suggest is, to start with you current task, and keep on digging it up. FULL STOP. Just keep on digging the enhancement you can make. I know it may take time, but you will get atleast an hour to think about it apart from your regular routine, and if not, just spend 10 Mins to think about it, just jot down every single possibility you can come up with.

One of the Saying, that keeps me motivated is "Try to break your own record everyday". I personally follow this.


3. Self Respect

    This term can be taken it two ways, one which will led you to right way, and another that will led to be arrogant and selfish.

I would say, that you must keep your ego aside if and only if you want to be successful. Now, lets come to the point.

Self Respect, to respect ourselves. To respect what you do, To respect what you did, and to respect what you can/will do.

Be responsible for your deeds,  Whatever decision you make, just make sure, that it will be true in all the cases. And its NOT BAD if you are proved wrong in some of them, just correct them and make changes. Don't be shy, just be confident.


4. Take Opinion

    It is always advisable to take opinion from your seniors, even if you think he is not correct. Just take opinion. Then research and act upon.
If it feels like you are asking something stupid, still ask, ASK FOR MORE. And you may get something extra out of it.
Whatever the front personal think about that topic, you will get a view. Take opinions and make your decisions wisely.


5. Believe in Yourself.

  Every human in this world, is here because he is important to play his/her role. You can be right or wrong for every individual. It always depends upon the perspective you hold. If you are low to take it, then you will lose, and if you are confident then you will achieve it.

This point is most important and dependent upon all the points stated above. While making decisions, always think in both ways, about its adverse and its positive effects.
If you master you technology, and above given points of life. You will certainly make decision which will be good for you, and for your surrounding.
And everyone looks for a better environment to work in. So why not make one. Make it yourself.



That's all for today.
The Better You, the Better will be your environment.
-V3nom

Why Shall I be a DBA???

This post is mainly for the Freshers and for the beginners in the field of Database.....

Task of DBA is equivalent to the Events in life of an individual.

For the freshers, this is my first question. Why you want to be a DBA?

Well this has been asked to me several times, from my friends and from the interviewers...

Well for me, I just wanted a job, as I was fresher in IT field. Later when I was going thought the Oracle DBA Course, I understood what RDBMS is, and what's it importance. Well simply in a sentence I will explain it. "It's the record of Data, action or reaction you give while you are on the internet."  Let's take an example:

"Beginning from the world famous site GOOGLE, whatever you browse, search, everything is recorded in the GOOGLE database."

Well if you are bored enough reading this,,,,, Lets come to the point.

Database is the record of each and every transaction, and DBA is a person who holds the key to preserve this data. This data can be important to anyone, to GOOGLE or any other client.

But, to be a DBA, you need certain things, Lets keep these points in mind:

1. Be Focused, Just concentrate on the GOAL (This is an important thing which you must concentrate throughout you life )

2. Be Responsible (Take ownership of task, take everything seiously)

3. Time  (Give time, and try to reduce the time to resolve every problem)

4. Be Truthful (Never, never, never lie in your life, as you will be caught anyhow, if anyone wants to.)

5. Don't Panic (Take everything seriously, but don't panic, Decide what you wants to do, Make an Action Plan and estimate the time and ask for 1.5 times the decided time, so that if any problem comes in between, then you must be able to resolve it anyhow  ;)   )

That's all for today. Just keep this in mind.

-Next post will be the starting of the DBA course right from the beginning... and that will be free of cost. And that will be in sequence.

All your doubts and questions will be answered timely.

Thanks Folks,

-Venom  (That's What My Screen Name is)

Something about Rapid Cloning Part 1 - Database

During the interviews this is always asked, like "Tell me how do you do the Cloning in R12?"
We all know what happens in Cloning, but now we shall also know how is it done internally.
So I thought I shall dig up some information about how oracle works, whats the idea behind.
Starting with the few basic statements that we might have heard alot. I will put them in a question/answer pattern. 
In this post I am focusing only on the Database part. 

Q: Why do we need to do cloning?

-> To test some application by patching or coding which can affect the whole application or may need downtime for the process to be carried out. So, in order to avoid the loss in business due to these mentioned factors, we need to clone the Oracle Application.

Q. What are the different cloning methods supported by Oracle?

-> There can be many cloning methods but oracle supports only 1, i.e., RAPID CLONE.
      On the basis of Config.  We can divide them as
            1. With AUTOCONFIG. (Completely replaced by Rapid Clone now.)
            2. Without AUTOCONFIG. (used before 11.5.5)

Q.  What is the need to run adpreclone?

-> This will create the staged clone directory which will be having the driver files and configuration file (XML File) of the source.

Q: How does adpreclone.pl dbTier will run

->   After runnning this, it will go in two stages
            1. dbTechStack                       2. Database

Q: Explain dbTechStack and Database in details:

-> It will create stage cloned area at $ORACLE_HOME/appsutil/clone This clone directory has got following main directories
data,jre,bin,db,html,context
This will prepare the database techstack at dbTechStack stage.

  1. Creates template files at $ORACLE_HOME/appsutil/template
  2. Creates driver files at $ORACLE_HOME/appsutil/driver/instconf.drv
  3. Converts inventory from binary to xml

Now the database stage:

      It will prepare database at the database stage. Major activities includes

  1. Create database control file script

      $ORACLE_HOME/appsutil/clone/context/data/stage/addbhomsrc.xml
      $ORACLE_HOME/appsutil/clone/context/data/stage/adcrdb.zip
       adcrdbclone.sql

  2. Generates database creation driver file
$ORACLE_HOME/appsutil/clone/context/data/driver/data.drv

  3. Copy JDBC Libraries
$ORACLE_HOME/appsutil/clone /clone/jlib/classes111.zip

________________________________________ 

NOW adcfgclone.pl dbTier (On TARGET NODE)

This will also run in two modes

     1. dbTechStack stage: 

It will make use template and driver files which were created during preclone process. And it will run the following scripts
      adchkutl.sh
      adclonectx.sh
      runInstallConfigDriver - located in $ORACLE_HOME/appsutil/driver/instconf.drv
      Relinking of ORACLE_HOME/appsutil/install/adlnkoh.sh  

     2. Now for the Database Stage

            Driver File       $ORACLE_HOME/appsutil/clone/context/data/driver/data.drv
            Create Database using adcrdb.zip file
            Autoconfig is Run
            Controlfile is created using adcrdbclone.sql

     3. Generates database creation driver file

$ORACLE_HOME/appsutil/clone/context/data/driver/data.drv

     4. Copy JDBC Libraries

$ORACLE_HOME/appsutil/clone /clone/jlib/classes111.zip

Ok, Now you can sleep and dream about the cloning.

-----------  That's it ------

Basics of VI Editor of Linux

_________________________________________________________________________________

                       Opening a file     

vi filename: Creating text

Edit modes: These keys enter editing modes and type in the text

of your document.

i     Insert before current cursor position

I     Insert at beginning of current line

a     Insert (append) after current cursor position

A     Append to end of line

r     Replace 1 character

R     Replace mode

<ESC> Terminate insertion or overwrite mode

_________________________________________________________________________________

                 Deletion of text

x        Delete single character

dd      Delete current line and put in buffer

ndd    Delete n lines (n is a number) and put them in buffer

J        Attaches the next line to the end of the current line (deletes carriage return).

u        Undo last command

_________________________________________________________________________________

                 CUT AND PASTE

yy      Yank current line into buffer

nyy    Yank n lines into buffer

p        Put the contents of the buffer after the current line

P       Put the contents of the buffer before the current line

_________________________________________________________________________________

                CURSOR POSITIONING

^d              Page down

^u              Page up

:n               Position cursor at line n

:$               Position cursor at end of file

^g               Display current line number

h,j,k,l          Left,Down,Up, and Right respectively. 

                  Your arrow keys should also work if your keyboard mappings are anywhere near same.

_________________________________________________________________________________

                STRING SUBSTITUTION

:%s#string1#string2#[g]       Substitute string2 for string1 on lines n1 to n2. If g is included (meaning global), 
                                           all instances of string1 on each line are substituted. If g is not included,only
                                           the first instance per matching line is substituted.

    

    ^ - matches start of line

    . - matches any single character

    $ - matches end of line

These and other "special characters" (like the forward slash) can be "escaped" with \

i.e to match the string "/usr/STRIM100/SOFT" say "\/usr\/STRIM100\/SOFT"

Examples:

:1,$:s/dog/cat/g                   Substitute 'cat' for 'dog', every instance

                                   for the entire file -lines 1 to $ (end of file)

:23,25:/frog/bird/                 Substitute 'bird' for 'frog' on lines

                                   23 through 25. Only the first instance

                                   on each line is substituted.

_________________________________________________________________________________

              SAVING, QUITTING and other "ex" Commands

These commands are all prefixed by pressing colon (:) and then entered in the lower left corner of the window. They are called "ex" commands because they are commands of the ex text editor - the precursor line editor to the screen editor

vi. You cannot enter an "ex" command when you are in an edit mode (typing text onto the screen)

Press <ESC> to exit from an editing mode.

:w                         Write the current file.

:w new.file             Write the file to the name 'new.file'.

:w!                        Existing.file Overwrite an existing file with the file currently being edited.

:wq                       Write the file and quit.

:q                          Quit.

:q!                         Quit with no changes.

:e filename             Open the file 'filename' for editing.

:set number            Turns on line numbering

:set nonumber        Turns off line numbering

_________________________________________________________________________________