Oracle 12c agent won't start due to large amount of databases on the server

Oracle 12c agent won't start due to large amount of databases on the server

cd /ora01/oracle/product/agent12c/agent_inst/sysman/config

Change Xmx1024M    to Xmx2024M

< agentJavaDefines=-Xmx1024M -XX:MaxPermSize=96M
---
> agentJavaDefines=-Xmx2024M -XX:MaxPermSize=96M

Useful command to Check performance on linux server

network
   netstat -ptc

IO
  iostat

 ps commands in order to check for performance probelms:

1) Displaying top CPU_consuming processes:

 # ps aux|head -1; ps aux|sort -rn -k2|head -10
2) Displaying top 10 memory-consuming processes:

# ps aux|head -1; ps aux|sort -rn -k3|head
3) Displaying process in order of being penalized:

# ps -eakl|head -1; ps -eakl|sort -rn +5
4) Displaying process in order of priority:

# ps -eakl|sort -n +6|head
5) Displaying process in order of nice value

# ps -eakl|sort -n +7
6) Displaying the process in order of time

# ps vx|head -1;ps vx|grep -v PID|sort -rn +3|head -10
7) Displaying the process in order of real memory use

# ps vx|head -1; ps vx|grep -v PID|sort -rn +6|head -10
8) Displaying the process in order of I/O

# ps vx|head -1; ps vx|grep -v PID|sort -rn +4|head -10
9) Displaying WLM classes

# ps -a -o pid, user, class, pcpu, pmem, args
10) Determining process ID of wait processes:

# ps vg|head -1; ps vg|grep -w wait
11) Wait process bound to CPU

 # ps -mo THREAD -p
12) CPU usage with priority levels

 # topas -P


# for x in `seq 1 1 10`; do ps -eo state,pid,cmd | grep "^D"; echo "----"; sleep 5; done

# ps auxww --sort=lstart | sort -r -k3,4 | head -20

# ps aux --sort -pcpu

# ps -ef --sort=start_time|head -20

# watch -n 1 "(ps aux | awk '\$8 ~ /D/  { print \$0 }')"

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

Linux "tr" Command Examples

Translate upper case to lower
tr A-Z a-z < inputfile > outputfile
cat inputfile|tr A-Z a-z

Translate braces into parenthesis
tr '{}' '()' < inputfile > outputfile

Translate white-space to tabs
 echo "This is for testing" | tr [:space:] '\t'

Squeeze repetition of characters using -s
echo "This   is   for testing" | tr [:space:] '\t'

We can use -s option to squeeze the repetition of characters.
echo "This   is   for testing" | tr -s [:space:] '\t'

convert multiple continuous spaces with a single space
echo "This  is  for testing" | tr -s [:space:] ' '

Delete specified characters using -d option
echo "the geek stuff" | tr -d 't'

To remove all the digits from the string, use
echo "my username is 432234" | tr -d [:digit:]

Complement the sets using -c option
echo "my username is 432234" | tr -cd [:digit:]

Remove all non-printable character from a file
tr -cd [:print:] < file.txt

Join all the lines in a file into a single line
 tr -s '\n' ' ' < file.txt

How to Start/Stop CRS

As root - set enviornment ( . oraenv and at prompt enter grid and press enter)
# cd /ora01/grid/11.2.0.4/grid/bin
# . ./oraenv
Type in grid

To stop Grid
# crsctl stop crs (will do one node at a time)
# ./crs_stop -all   (this will shutdown grid on both nodes, use only if directed by DBA)

To start grid
# ./crsctl start crs

To disable grid autostart
# crsctl disable crs  # to disable

To enable grid autostart(whenever we need to enable and start, the sequence is first enable then start)
# crsctl enable crs   # to enable

To check the grid status
# crsctl config crs

###FOR STANDALONE ORACLE SERVERS###

crsctl disable has
crsctl config has
crsctl enable has
crs_stat -t -v

to stop
crsctl stop has -f

to start
crsctl start has