Wednesday, 14 January 2015

System message in SLD

http://<hostname>:<port>/sld . Goto to administration, in that you get System message option.

Thursday, 1 January 2015

BO \BI 4.0 Introduction

BO BI4.0
BO 5.X BO 6.X  XIR1
XI R2
XI R3(XI3.0,XI3.1)
SAP BO BI4.0 ---latest
Integration with sharepoint,Tivoli etc
TOOLS categories as
Administrator
Business user
Data manager
Designer
CMS(Central management server)
CMC :central mgmt console

Administration
Central configuration manager
Life cycle manager
Central management console (Servers info available)
Repository diagnostic tool
Import wizard
Report conversion tool
Publishing wizard
Performance manager





Unix commands Session -3 (find Command usages)

#man find
# find <path> <search Criteria> <action>

Examples of find command--

find
It will display the pathnames of all files in the current
directory and all subdirectories .
find.
find -print
find. -print

the below command will search abc file in the entire systemm
find /-name abc

Search in Current directory
find . -name abc.txt

to search a type as f , directory d

find . -type f -name abc.txt

find xyz files under abc directory
find/home/abc -name xyz.txt

find all .txt files in Directories abc
find /home/abc -name '*.txt'

find files using Name and ignoring Case
find /home/abc -iname abc.txt

find directories abc
find/ -type d -name abc

find files Based on their Permissions(permission 777)
find .-type f -perm 0777 -print

find files without permissions
find. -type f ! -perm 0777 -print

find SGID files with permission 755
find/ -perm 2755

find all SGID set files
find /-perm /g+s

find stick bit files with permission 755
find/ -perm 1755

Owner Group Others
7       7    7

r=4 w=2 x=1

ls -ltrh

find . -perm/o=t
owner only can delete this file no one can delete

find all SSUID set files
find . -perm/u=s

Find all executable files
find/ -perm /a=x

find all read only file
find /-perm /u=r

find file with permission 777 and change the permission to 755
find / -type -f -perm 0777 -exec chmod 755 {}\;
find / -type-f -perm 0777 -print0 | xargs -0 chmod 755

find and remove single file
find / -type -f -name "abc.txt" -exec rm-f {}\;
find /-type -f -name "abc.txt" -print0 |xargs -0 rm-f


find directories with 777 pemission and change permission 755
find /-type -d -perm 0777 -exec chmod 755 {}\;
find/ -type -d -perm 0777 -print0 |xargs -0 chmd 755

find all empty files and remove
find /-type f -empty -exec rm-f {}\;

find all hidden files
find /-type -f -name ".*"

find all thee files that were modified 10 days back
find / -mtime 10

find all the files that were accessed 10 days back
find /-atime 10

find all the files which are modified more than 10 days back
and less than 20 days
find / -mtime+10 -mtime -20

find all the files modified in last minute
find / -mmin 1

find all the files changed in last 1 minute
find / -type -f -cmin 1

find . -mmin 1
find .-mmin +1 -mmin -3

find a files based on user group
find / -user root -name abc.txt

find all the files of a user
find / -user root

find a file based on group
find / -group developer -name xyz.txt

find all the files of a group
find /-group developer

find a 10MB file
find /-size 10M

find . -size +1M -size -3M
find . -name '*.log'

restricting find with search capability
find / -maxdepth 3 -name "*log"

find all files that dont match a file name pattern
find. -type f -not -name "*.html"

redirecting errors to /dev/null
find -name "*.txt" 2>>/dev/null

finding EARTH text in all the text files
find . -name "*." -exec grep -i "EARTH"{}\;

finding EARTH text in all the text files efficiently
find . -name "*.txt" -exec grep-i "EARTH"{} \+


Clean out temporary files
find .\(-name a.out -o -name'*.o' -o -name 'core' \)exec rm {} \;

List zero length files
find . -empty -exec ls {} \;

find files which are more than 1 GB and nt accessed for the past
10 months

find / -size +1G -mtime +300

finding file dwnloaded today but misplaced
find ~ -type f -mtime 0 -iname '*.mp3'

identify files without a user or group
find / -nouser -o- nogroup


Setting up a Trusted RFC

Steps to Setup Trusted RFC Communication
On your source system say <SID> IN1 you want to setup a trusted RFC connection towards the destination system AP1
Result:
When you configure the RFC  when you logged onto IN1  and your user has enough authorization in AP1, you can use the RFC connection to logon  to AP1 without having to reenter username and password.

Here are the steps
1.enter t-code SM59 on IN1  define an R3 type RFC connection (Connection type 3) towards AP1
2.Maintain technical settings  details in tab
Like
Load balancing  should be No
Maintain target host and system number
3.Next go to the Logon and Security Tab
Enter details like
Trusted system no
Enter client and uid and password
4.Go to the MDMP and Unicode tab
Enter details like
Choose right option in MDMP  & Unicode
Normally MDMP is inactive  and Unicode is yes
5.SAVE RFC connection is created.
Now testing RFC as its working properly or not
1.       Go to Utilities àConnection Test , Authorization test,Unicode test

Now the R3 RFC connection is made , we can continue next step , go to t-code SMT1
 And click on create
1.fill the previously created RFC name
2.Click Yes
3.Now click on maintain destination button
This will take you back into SM59  destination <RFC connection name we have created>
Change the trusted system option to yes in the logon and security  tab
Yes
Remove the user from the logon and select “Current user”

Save the RFC Connection

Unix - Session 2

#ls
#ls -l | more
long format
#ls -lt | more
latest is top
#ls -lta | more
dot files will be shown along with hidden files
#ls -lt xilink
xilink is a directory name

d stands directory

#pwd
#cd ..
#cd
it goes to home directory

cd ~/directryname
echo $cwd

mkdir krishna
emacs welcome.txt

more welcome.txt
ls -lt
chmod 700 welcome.txt  rwx by  me
chmod 600  welcome.txt  rw
chmod 644 welcome.txt


mkdir test
ls -l
rmdir test
rm welcome.txt
ls -lt



cp welcome.txt krishna_welcome.txt

#hostname
#uname -n
#uname -a
#clear
#who
#whoami
#ls -lA
#ls -A
list Almost all
#ls -a list all
#ls -A -l

spacebar or f
one page forward
b
one page backward
[Enter]or j
one line forward
[Enter] or k
one line backward
/foo
serarches forward for expression foo
#less mynewtestfile.txt
#tail -f loop.out
ctrl+c get out of it
tar -cvf myarchive.tar*

tar -xvf myarchive.tar
gzip myarchive.tar
ls -la
gunzip my
bzip2 my
bunzip2 myarhive.tar.bz2


tar czvf myarchive.tar.gz*
ls
ls -la
tar cjvf myarhcive.tar.bz2*

ls
zip myzip mydir mydir1 testfile


head hostname.txt
scp -P 1209 hostname.txt krishna.edu:-/me5013

wget krihna.com.files\krishna.123.pdf

#ls
#grep 'theme' index.php
#grep 'theme' themes/*
#cd themes/
#grep -r 'theme' themes/*
grep -r 'username' .

dot means current directory
grep -rl 'username'
grep -v 'theme' readme.txt
grep 'theme' readme.txt
grep -n 'theme' readme.txt
grep -i 'this' readme.txt
grep -r 'search string'
grep -rn 'search string'

:wq<Enter>   to exit
hit the escape key go to command mode from insert mode


find commands in unix
find  where  {permission,type,name,time ...} wat -to -do

search files last 10 days
find  .-size 0  +10  -exec ls -l {} \;>./checkold.txt
cat checkold.txt


grep "literal_string" filename
case senstitive search
grep -i "literal_string" filename
grep "this" abc.*
grep "line.*empty" abc.*
 Sol :abc.txt :line.absoluteempty
exact word search
grep -iw "is" demo_file
Display N lines after match
grep-A <N> "string" FILENAME
grep -A 3 -i "example" demo_txt
Display N lines  before match
grep -B <N> "string"  FILENAME
grep -B 2 "single word" demo_test
Display N Lines around match
grep -C <N> "string" FILENAME
grep -C 2 "Exmaple" demo_txt
Recursively searching
grep -r  "krishna"*
Invert searching
grep -v "go" demo_txt
Counting the no.of matches
grep- c "pattern" filename
grep -r "main" * | wc -l
invert does not have this word main
grep -rv "main" * |wc -l
grep -o -b "pattern" file
o-match only the string
b -show position
show line number while displaying the output
grep -n "go" demo_txt
cat fruits |less
q to exit
cat filename | pg or cat filename | more

cat filename | grep <search string>
cat filename | grep -i a
sort fruits
cat fruits  |grep -v  a | sort -r




Unix commands -1

Unix commands

#pwd
#ls
#ls -l
#ls -a
#man ls
#man pwd
#cd /boot/grub

pwd /boot/grub
ls
#clear
cd ..

it takes one step back
 linunx cd  ..
cd ~/
it will take to Home directory
vi Newfile
i
press i
press esc after insert then it will comes in command mode
:wq
save and quit
cat newfile
mv <SRC> <DEST>
rm newfile
ls
rm newfile -i
rm newfile -v

rmdir newfolder -v
------
#cp src dest
cp bands /home/krishna/copied.txt
#clear
vi new\ file
creates new file
cat new\ file
rm new \file
cat textfie
grep this textfile
grep this textfile --count
grep this textfile -- invert-match
clear
grep this textfile -B1 -A1

cat num
sort num -n
sort bands
sort bands -o sortedbands
#passwd
password change
#pidof sap
#kill
----
#su
super user
#root
------
exit

ps
#ps -e
#ps -a
#ps -u sap
#uname
#uname -a
#uname -s
#uname -m

#clear
#who
#whoami
#gzip
#gzip textfile
#ls
#gzip -l textfile.gz
#gzip -d textfile.gz
back to normal file

#tar-xvzf name.tar
#tar -xvzf


#ping <ipaddress>
ctrl+c
#ping -c4 <ipaddress>
4 times it will ping
#clear
#ping -c4 <ip address> -q

#ifconfig


Saturday, 27 December 2014

Network Troubleshooting

Network Troubleshooting windows env

open command prompt

#ipconfig

The ipconfig command displays all current TCP/IP network configuration values

It gives you basic information to get your IP address,your routers IP address,
DNS Server IP Address,DHCP Server IP address etc..

Default gateway is router

cls --to clear screen'

#ipconfig/all

#Ping

Allows you to send a signal to another device on the network to see if it is active

Uses the ICMP (Internet Control Message Protocol) to send out an echo request
to the destination device,and gets back an echo response , if the device you are
trying reach of in fact Active.


#ping <routeripaddress> <DNSIPaddress> <www.siteaddress.com>

#Tracert

tracert gives the step-by-step route a packet takes to the destination
you speicfy

So if you send a packet to google.com , before the packet
actually reaches google.com servers,it will go through many diffrent
routers before it finally reaches google.com

You can also use the term HOPS instead of routers.So,if it takes 10
routers to get to google.com, you can instead say: "it took 10 hops
"

#tracert <webaddress.com>

#NSLOOKUP
This command will fetch the DNS records for a given domain name or
IP Address.Remeber , the IP Addresses and domain names are
stored in DNS servers,so the NSLOOKUP command lets you query the DNS Records to gather information

#nslookup <webaddress.com>

---------------------------------
cmd prmpt basic commands
c:\>dir
c:\>cd users
c:\users>cd krishna
c:\users\krishna>dir
c:\users\krishna\pics>dir
c:\users\krishna\pics>pic.jpg
c:\users\krishna\pics>cd..
c:\users\krishna>cd\
c:\>cls
c:\>cd program files
c:\program files>dir
c:\program files>cd internet explorer
c:\programfiles\Internet Explorer>dir
c:\programfiles\internet explorer>iexplore.exe
c:\programfiles\internet explorer>cd\
c:\>color y
c:\>color 1e
c:\>color 0f
c:\>systeminfo
---------------------------------------------------
c:\>whomami
c:\>systeminfo
os name , os version,install date,system boot time
c:\>ipconfig\flushdns
to flush dns
c:\>ping krishna.com -n 10
pings 10 times
c:\>tasklist
c:\Users\krishna\Desktop>mkdir example
c:\users\krishna\Desktop\example>cd ..
c:\users\krishna\desktop>copy text.txt c:\users\krishna\desktop\example
 c:\users\krishna\Desktop\example>del test.txt
c:\users\krishna\Desktop\example>dir
c:\users\krishna\Desktop\example>rename test.txt test1.txt
c:\users\krishna\Desktop\example>notepad test.txt
c:\users\krishna\Desktop\example>tasklist
c:\users\krishna\Desktop\example>taskkill /im notepad.exe

Thursday, 11 December 2014

netstat and nslookup

To check which port is free and which is occupied  :Netstat -a  is the command
Have ip address how to know the server name :nslookup is the command

SAPSPRINT Service for windows environment in SAP

SAPSPRINT Service needs to be installed on printer server on port 515 or 516

Ports in SAP

Dispatcher Port : 3200 to 3299
Message server Port: 3600 to 3699
Gateway Port :3300 to 3399
Secured Dispatcher Port: 4700 to 4799
Secured Gateway: 4800 to 4899

LAN Check by ping in SAP

LAN Check by Ping is used to ping to all the systems in the Network/Landscape .If a user complaints that he could not connect to the server(ping to the desktop).

ST06 is the t-code

Saturday, 6 December 2014

ST22 ABAP Dumps

When ever a SAP Program(ABAP) Program could not be executed due to an error it will be thrown out from the GUI- Screen and dump is recorded in ST22.

ST22 Recovers the following
1.Divide Error I/O
2.Update(Lags in memory)
3.Infinite Loops

1.Time_OUT error :The program require more time than the time defined in rdisp/max_wprun_time
2.Memory related issues with error message PXA,SWAP,PAGE,OUT OF MEMORY. This error requires memory corrections to the parameters.
3.Program Corrections:The problem is with SAP standard program for which SAP provides
a correction through notes(The correction can be applied through SNOTE)
4.Customer defined program :(Y,Z)consumes more memory,endless loops,improper select statements etc.The program needed and to be corrected by developer.
5. En queue Table overflow:SM12
6.Update deactivation
7.Database issues like table space overflow,max-extents reached, archive stuck.
8.Illegal time(Day light Savings) - During day light savings the system date and time has to be changed.Stop the AS and change the date if not,the above errors occurs.

Note:
TSTC:Holds the transaction and program name
TSTCT:Holds the description/text of  a t-code.

SMLG in SAP

Logon Load Balancing SMLG
It is used to route requests to the least loaded instance of that group.

1.Buffers are optimally utilized
2.Load balancing is avoid long queues.
3.Fail over

Mechanism
1.User used SAP GUI -groups option to login
2.Saplogon.ini is used to display the available entries
3.User select the group and click on logon.
4.When the user select the group.It look for sapmsg.ini to identify the message server and etc/services for message server port.saproute.ini,saprfc.ini,sapdoccd.ini(For library),saplogon.ini
5.Message server communicates will all the dispatchers and identifies the least loaded server and mark it as a favorite server in SMLG. The request is routed to the favorite server.
6.The dispatcher process the requests normally.

Profiles in SAP

Startup Profile

Startup profile consists of startup parameters like

Starting Database
Starting Message server
Dispatcher+work
Do not modify these parameters under any circumstances on OS level.

Default Profile

It is used to provide global parameters for all instances, buffer parameters , security parameters(password,user restriction),Message server host,en queue host.

Instance Profile

This is specific to instance configuration such as work process , timeout parameters etc..


Starting Sequence
1. Start up profile is read by the system to start the engine by starting database,message server and dispatcher in central instance.
2. Start up profile is ready by the system to start the engine by starting(Disp+Work) on dialogue instance.
3.There will be only one default profile in the entire system which provides global values.
4.Instance specific profile -This is used to set the instance specific parameters.

Ex:How many profiles available on a system with 10 Dialogue instances

Total =11 (Including Central Instance)
             11X2 per instance (Start+instance)
             22
             22+1 (Default Instance)=23

Profile Types in SAP

1.Default
2.Startup
3.Instance Profile

Friday, 5 December 2014

Default job scheduling

go to sm36
click on "Standard Background Job"
Define Background Job
Click on Default Scheduling

And schedule the BTC Jobs with Default time

1.RSBTCDEL:Used to delete the background jobs ,Reporting structure 'BTC' 'DEL'
2.RSSNAPDEL:Delete the old ABAP Dumps
3.RSPO1041:Delete the old spool logs and files
4.RSMO13002:Delete the old Update requests/logs
5.RSCOLL00:Collects performance info in t-code ST03
6.RSPO1043:Spool reorganization

ORA Errors

Table space Overflow :ORA-1653; ORA-1654
Table space max extent reached :ORA-1631;ORA-1632
Archive Stuck:ORA-225;ORA-272

Setting up Text

Execute -SE61
Document class:General Text
From Document Tab Name:ZLOGIN_SCREEN_INFO create
Type the text -Welcome
Save

T-code to maintain Table Entries

SM30 is the t-code to maintain table entries.

No Restrictions needs to be selected

Client Open and client close

Client Open:
Select the option :Automatic recording f changes
Select :customizing to objects and repository are allowed

Client close
Select:No changes allowed
select:No Customizing to objects and repository are allowed