Monday, June 13, 2011

Activate and Configure SAP ITS Webgui on SAP ECC 6.0

Since SAP ECC 5.0 and ECC 6.0, SAP has integrates its SAP Internet Transaction Server (ITS) on its server. You don’t need to install separate ITS server. You just need to activate and configure it. Follow this procedure:

1. Check if you have activated and your webgui is working for not.
First you have to know your http server port.
Call transaction SMICM
Click on services.

Check HTTP service, port number and host name.

Open internet explorer and call SAP Web GUI.
http://:8000/sap/bc/gui/sap/its/webgui/

Come across error message means its not yet configured.

2. Check if not acivated then need to activate:
With transaction SICF and locate the services by path

/sap/public/bc/its/mimes
/sap/bc/gui/sap/its/webgui
/sap/public/bc/ur

3. With Transaction SE80 locate from the menu, Utilities –> Settings–>Internet Transaction Server (Tab)–>Publish (Tab) and set “On Selected Site” = INTERAL.
This restricts the publication in the next step to the integrated (internal) ITS.

4. In SE80 only, Locate the Internet Services: SYSTEM and WEBGUI.
Publish these services with the Context Menu -> Publish -> Complete Service

5. Open internet explorer http://:8000/sap/bc/gui/sap/its/webgui/
Please enter username and password.
This will start SAP GUI for HTML.
SAPGUI get opened.

Effects on System Administration
You can administer SAP Integrated ITS using the following SAP Transactions:
1. RZ10 – definition of parameters
2. SICF – configuration of the ITS service
3. ST11 – traces
4. SITSPMON – status of integrated ITS

My integrated ITS doesn't work. What should I do?
See note 698329 in order to find out what is wrong with your integrated ITS. If you get memory errors when you start an ITS application, see also SAP note 742048
for more information.

How to prefill fields and skip first screen with webgui?
Often it is desired to prefill fields of a screen and skip this screen by triggering an okcode. The SAP kernel provides a special okcode functionality which can be used with webgui and SAP GUI. You have to create a okcode with the following syntax:
*FIELD_1=VALUE_1;FIELD_2=VALUE_2.......FIELD_N=VALUE_N;DYNP_OKCODE=OKCODE
If you i.e. use this with the ABAP editor SE38 and enter
*se38 RS38M-PROGRAMM=rsparam;DYNP_OKCODE=SHOP
in the transaction code field of webgui or SAP GUI, the ABAP editor will be started with directly showing the ABAP code of RSPARAM. You can also make use of this in the URL with the well known ~transaction parameter.
For ITS 6.20 standalone with i.e. R/3 Enterprise 4.7 the URL would be
http://ITS_HOST:ITS_PORT/scripts/wgate/webgui/!?~transaction=*se38 RS38M-PROGRAMM=rsparam;DYNP_OKCODE=SHOP
If you use SAP Netweaver 2004 or higher with integrated ITS the URL would be
http://WAS_HOST:WAS_PORT/sap/bc/gui/sap/its/webgui?~transaction=*se38 RS38M-PROGRAMM=rsparam;DYNP_OKCODE=SHOP
After authenticating the user, the SAP system will automatically process the transaction and skip the first screen.
Parameter ~okcode is obsolete for skipping screens
Many of you may know, that the parameter ~okcode provides a similar functionality with ITS 6.20. However it is not recommended anymore to use it for skipping screens. One reason is, that the solution discussed above provides much more performance because it avoids superfluous roundtrips between the SAP kernel an ITS 6.20. The other is that with SAP Netweaver 2004 and above the ~okcode syntax no longer works in any case. Therefore just forget screen skipping with ~okcode and make use of the method described above.
How to terminate a user session with integrated ITS when the transaction ends?
This tutorial describes how to delete the user session with the parameter ~singletransaction when the transaction started with ~transaction ends.

When calling a transaction with ITS 6.20 using the parameter ~transaction, ITS takes care to delete the session when the transaction ends. With SAP Netweaver and integrated ITS this don't work because session handling is not longer done by ITS but by the SAP kernel itself. When a transaction ends the system shows the transaction selection screen with the "Start Easy Access Menu" button.

In a portal environment this is often not desired. SAP therefore enhanced the kernel to provide a similar functionality as with ITS 6.20. To activate this functionality you have to set the parameter ~singletransaction=1 in the ICF service. This parameter tells ITS to ask the SAP kernel to logoff a user session at the end of transaction. SAP note 959417 describes the kernel and support package requirements. For those who do not currently have access to the SAP service marketplace:

SAP Netweaver 2004, aka 640:
Kernelpatch: 136
ABAP Support-Package: SAPKB64018
SAP Netweaver 2004s, aka 700:
Kernelpatch: 66
ABAP Support-Package: SAPKB70009

The parameter has the limitation that it doesn't work if the transaction is terminated with LEAVE TO TRANSACTION. You should therefore not use this parameter with the standard webgui service but create an own z-service in SICF with ~transaction set to the tcode you want to provide your users.

How to customize the login screen?

Many customers would like to customize the ITS login page, so that it fits to their corporate standards. If you search information about how to customize the login page either in ITS 6.20 or with SAP Netweaver 2004/2004s/2007 with integrated ITS read this tutorial.

ITS 6.20 standalone
If you want to customize ITS system templates (and login page is one of these), ITS provides an easy way to do this. The system folder below SAP/ITS/6.20//templates contains two folders dm and pm. dm stands for development mode, pm for production mode. By default ITS stores the system templates in the dm folder. If you want to customize one of the ITS system templates just copy it to the pm folder. There you can modify it as you like. When ITS looks for a system template, it will at first look in pm. If it finds the template there it will use it. Otherwise it will look in dm. To modify the login page just copy the login.html from dm to pm and change it according to your requirement. From now on ITS will use this template for login. If you want to use a service specific login page create a template with the name login.html and store it beside your other service templates. When a user wants to login to this service, ITS will use this template for the login screen. For ITSmobile ITS 6.20 of patchlevel 27 or higher contains a special login page for ITSmobile which fits to the small display of mobile devices. The name is of the template is loginmobile.html. If you want to modify the mobile login page proceed as described above and copy loginmobile.html to pm or to your service directory.

SAP Netweaver
With SAP Netweaver 2004 ITS is part of the SAP kernel. The login page is therefore no longer a functionality of ITS but of the Web Application Server (WAS). By default ITS Services uses the standard system login pages that WAS provides. You can customize in transaction SICF what login procedure should be used and which fields should be available on system login page. This can be done global or per service. The documentation on the SAP help portal contains information how this can be done. It is even possible to create an own login page by inheriting an own login class from CL_ICF_SYSTEM_LOGIN. You can find detailed information about how to do this on the SAP help portal System Logon. For mobile devices Netweaver provides the CL_MOBILE_SYSTEM_LOGIN class.

SAP STANDARD JOB CHECK AND SCHEDULE for SAP ECC / R3 Server

Refer SAP Note 16083 - Standard jobs, reorganization jobs

Job

Job Info

In my system

As per SAP Note

SAP_REORG_JOBS

Deletes old background jobs

Present and scheduled at 04:15:00

Need to schedule daily with Variant yes

SAP_REORG_SPOOL

Deletes old spool data

Present and scheduled at 03:30:00

Need to schedule daily with Variant yes

SAP_REORG_BATCHINPUT

Deletes old batch input sessions

Present and scheduled at 04:15:00

Need to schedule daily with Variant yes

SAP_REORG_ABAPDUMPS

Deletes old ABAP short dumps

Present and scheduled at 03:00:00

Need to schedule daily with Variant yes

SAP_REORG_JOBSTATISTIC

Deletes old data from the job runtime statistics

Not present and not scheduled

Need to schedule monthly with Variant yes

SAP_COLLECTOR_FOR_JOBSTATISTIC

Generates runtime statistics for background jobs

Not present and not scheduled

Need to schedule daily

SAP_COLLECTOR_FOR_PERFMONITOR

Collects data for the performance monitor

Present and scheduled

Need to schedule hourly

SAP_CCMS_MONI_BATCH_DP

Dispatches monitoring architecture methods

Present and scheduled

Need to schedule hourly

Below are recommended as per sap note and http://help.sap.com/saphelp_nw70/helpdata/en/24/b884388b81ea55e10000009b38f842/frameset.htm but not scheduled by me.

SAP_REORG_UPDATERECORDS

Deletes old update requests

SAP_SPOOL_CONSISTENCY_CHECK

Not present and not scheduled

Need to schedule daily with Variant yes

SAP_REORG_PRIPARAMS

Need to schedule monthly

SAP_REORG_ORPHANED_JOBLOGS

Not present and not scheduled

Need to schedule weekly with Variant yes

SAP_CHECK_ACTIVE_JOBS

Not present and not scheduled

Need to schedule hourly with Variant yes

SAP_DELETE_ORPHANED_IVARIS

Not present and not scheduled

Need to schedule weekly with Variant ja

SAP_REORG_ORPHANED_TEMSE_FILES

Not present and not scheduled

Need to schedule weekly with Variant ja

SAP_CCMS_MONI_BATCH_DP is not a reorganization job but is needed to start tools / methods in the system monitoring area in the background -> transaction RZ20/RZ21.

Function fopen() failed for '/oracle/PIP/sapbackup/befyqyra.tib' at location main-9

Come across below error message during executing of br commands.

BR0252E Function fopen() failed for '/oracle/PRD/sapbackup/befyqyra.tib' at location main-9


Post patch update permission are not correcting set of BRTools files.

SERVER:oraprd 6> ls -la /sapmnt/PRD/exe/br*
-rwxrwxr-x 1 oraprd dba 15409552 Jan 29 21:14 /sapmnt/PRD/exe/brarchive
-rwxrwxr-x 1 oraprd dba 15916368 Jan 29 21:18 /sapmnt/PRD/exe/brbackup
-rwxrwxr-x 1 oraprd dba 20199200 Jan 29 21:36 /sapmnt/PRD/exe/brconnect
-rwxrwxr-x 1 oraprd dba 16622720 Jan 29 21:39 /sapmnt/PRD/exe/brrecover
-rwxrwxr-x 1 oraprd dba 6909792 Jan 29 21:41 /sapmnt/PRD/exe/brrestore
-rwxrwxr-x 1 oraprd dba 22033288 Jan 29 21:57 /sapmnt/PRD/exe/brspace
-rwxrwxr-x 1 oraprd dba 9044344 Jan 29 22:01 /sapmnt/PRD/exe/brtools


As Per
Note 113747 - Permissions for DBA tools BR*Tools and SAPDBA
brarchive, brbackup, and brconnect have permission 4775:
-rwsrwxr-x ora sapsys ...
These can be started by the ora or the adm OS user.

brrestore, brrecover, brspace, brtools, and sapdba have permission 755:
-rwxr-xr-x adm sapsys ...
These should only be started by the ora OS user.

SERVER:oraprd 7> cd /sapmnt/PRD/exe/
SERVER:oraprd 8> chmod 4775 /sapmnt/PRD/exe/brarchive
SERVER:oraprd 10> chmod 4775 /sapmnt/PRD/exe/brbackup
SERVER:oraprd 11> chmod 4775 /sapmnt/PRD/exe/brconnect
SERVER:oraprd 13> chmod 755 /sapmnt/PRD/exe/brrecover
SERVER:oraprd 15> chmod 755 /sapmnt/PRD/exe/brrestore
SERVER:oraprd 16> chmod 755 /sapmnt/PRD/exe/brspace
SERVER:oraprd 17> chmod 755 /sapmnt/PRD/exe/brtools
SERVER:oraprd 18> ls -la /sapmnt/PRD/exe/br*
-rwsrwxr-x 1 oraprd dba 15409552 Jan 29 21:14 /sapmnt/PRD/exe/brarchive
-rwsrwxr-x 1 oraprd dba 15916368 Jan 29 21:18 /sapmnt/PRD/exe/brbackup
-rwsrwxr-x 1 oraprd dba 20199200 Jan 29 21:36 /sapmnt/PRD/exe/brconnect
-rwxr-xr-x 1 oraprd dba 16622720 Jan 29 21:39 /sapmnt/PRD/exe/brrecover
-rwxr-xr-x 1 oraprd dba 6909792 Jan 29 21:41 /sapmnt/PRD/exe/brrestore
-rwxr-xr-x 1 oraprd dba 22033288 Jan 29 21:57 /sapmnt/PRD/exe/brspace
-rwxr-xr-x 1 oraprd dba 9044344 Jan 29 22:01 /sapmnt/PRD/exe/brtools
SERVER:oraprd 19>

Wednesday, August 08, 2007

ORA-12560: TNS:protocol adapter error

I am receiving below error message when i try to connect to ORACLE through sqlplus.

sqlplus "/nolog"

connect sys as sysdba

ERROR:
ORA-12560: TNS:protocol adapter error


to resolved this i set ORACLE_SID parameter
set ORACLE_SID=EP6

sqlplus "/nolog"
connect sys as sysdba

this time i succeed with login.

Wednesday, June 13, 2007

Datafile usage in tablespace

select substr(a.file_name,1,30),
substr(a.tablespace_name,1,20),
a.bytes allocated,
nvl(b.free,0) free,
a.bytes-nvl(b.free,0) used,
(nvl((a.bytes-nvl(b.free,0)),0)*100)/a.bytes usage_perc
from dba_data_files a,
( select file_id, sum(bytes) free
from dba_free_space
group by file_id ) b
where a.file_id = b.file_id (+)
AND a.tablespace_name='&tablespace'
/

Saturday, February 24, 2007

Mount USB Pen Drive in to Linux.

Before plug in USB pen see /var/log/messages kernel through which you get device name and path. Here I get sdc as device name (or sda0, sda1 like that.).

Now mount it.

Mount for FAT file system
mount –t vfat /dev/sdc /mnt/mounttemp/

Mount for NTFS file system
mount –t ntfs /dev/sdc /mnt/mounttemp/

access your device




Thursday, July 06, 2006

Configuration for allow public user to use service on server i.e. port 25, 110.

I have Red Hat Linux 9.0 on which I have 2 NIC.

NIC 1 is used for internal network connection.
NIC 2 is used for Broad band internet connection which has static IP.

Now in this server my sendmail on 25 , POP3 on 110, HTTPD on 90 Is running now I want to allow user to access this services from outside my network or on internet.

In this box I have my firewall and for that I have to reconfigure and opened port 25, 110, 90 so outside user can access it.

After opening port and checking my settings I am only able to access POP3 service.

Why ?

Because my sendmail & HTTPD is configure on my local/internal IP.

So which ever request comes inside for port 25 and port 90 I need to forward to my local/internal ip port 25 and 90.

So need to add below in my rc.local file for route the request.

Iptables –t nat –A PREROUTING –i eth1 –p tcp – -dport 25 –j DNAT - -to :25
Iptables –t nat –A PREROUTING –i eth1 –p tcp – -dport 90 –j DNAT - -to :90

After doing routing I am able to access.

Friday, March 17, 2006

DETECTING MIGRATION AND CHAINING ROWS

1. ANALYZE TABLE OWNER.TABLE_NAME COMPUTE STATISTICS;
2. SELECT NUM_ROWS,CHAIN_CNT FROM DBA_TABLES WHERE TABLE_NAME=’TABLE_NAME’;

CHAIN_CNT= MIGRATED + CHAINED ROWS.

FOR LIST OF ROWS.

1. ANALYZE TABLE OWNER.TABLE_NAME LIST CHAINED ROWS;
2. SELECT OWNER_NAME,TABLE_NAME,HEAD_ROWID FROM CHAINED_ROWS WHERE TABLE_NAME=’TABLE_NAME’;
TO CREATE CHAINED_ROWS TABLE RUN UTLCHAIN.SQL

ELIMINATION MIGRATED ROWS.

  1. EXPORT / IMPORT
    1. EXPORT THE TABLE
    2. DROP OR TRUNCATE THE TABLE
    3. IMPORT THE TABLE
  2. MOVE TABLE COMMAND
    1. ALTER TABLE TABLE_NAME MOVE;
  3. COPY MIGRATED ROWS
    1. FIND MIGRATED ROWS USING ANALYZE

ANALYZE TALBE TABLE_NAME LIST CHAINED ROWS;

    1. COPY MIGRATED ROWS TO NEW TABLE

CREATE TABLE MIGRATED_ROWS AS
SELECT ORIG.*
FROM TABLE_NAME ORIG,CHAINED_ROWS CR
WHERE ORIG.ROWID=CR.ROWID
AND CR.TABLE_NAME=TABLE_NAME;

    1. delete migrated rows from original table

delete from table_name
where rowid in
(select head_rowid from chained_rows);

    1. copy rows from new table to original table
insert into table_name select * from migrated_rows;

Monday, February 20, 2006

Export – Import Taking long time.

We have Sales Order Processing System at HO & works

We are taking orders at HO and Billing and dispatch and etc. happening at works.

We have some tables which we need to import at HO base on dispatch and billing done at works.

But my import takes to much time to import those tables. I had try with different exp/imp parameters but can’t get success.

Then i get realized I have trigger on tables which are firing after insert on the tables which I am importing and that triggers are creating issue for me.

So I had disabled that trigger and import.

Now which import taking 30/45 min its now completing within 5 min.

Friday, February 03, 2006

Automatic Archiving Does Not Restart if Disk Space is Full

Compliments of Jeff Hunter, ideveleopment.info
Overview
Consider an Oracle database running in archive log mode with automatic archiving turned on. When the archive log destination disk space becomes full, the automatic archiving will stop. As per Oracle's documentation, this is the expected behaviour. At this point, a message should appear:
ORA-00257: archiver error. Connect internal only, until freed.
When all of the online redo logs are filled up, the database will be in a hung state.
If you attempt to manually archive the files, you may receive the following errors:
SVRMGR> archive log next
ORA-16014: log 1 sequence# 199 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/u03/app/oradata/DBADB/redo_g01a.log'

SVRMGR> archive log all
ORA-16020: less destinations available than specified
by LOG_ARCHIVE_MIN_SUCCEED_DEST
Solution
The following is a list of the possible ways to fix this problem:
1. Use the command:
alter system archive log all to '/u07/app/oradata/DBADB/archive';
NOTE: You MUST specify a location ref - ora-16014
2. Shutdown and restart the database. It may be necessary to do a Shutdown abort.

3. Use the REOPEN attribute of the LOG_ARCHIVE_DEST_n init.ora parameter:
LOG_ARCHIVE_DEST_n=' REOPEN=30'
Or run the following comand:
alter system set LOG_ARCHIVE_DEST_n = 'reopen'
4. Use the commands:
5. alter system archive log stop;

alter system archive log start;

Explanation
The error ORA-16014 is the real clue for this problem. Once the archive destination becomes full, the location also becomes invalid. Normally Oracle does not do a recheck to see if space has been made available.
Using the command
alter system archive log all to '/u07/app/oradata/DBADB/archive';
gives Oracle a valid location for the archive logs. Even after using this the archive log destination parameter is still invalid and automatic achive does not work. This solution is best for systems that do not archive regularly but cannot be shutdown. You can also use this to allow you to do a Shutdown immediate instead of Shutdown abort.

Shutdown and restart of the database resets the archive log destinstation parameter to be valid. Do not forget to make disk space available before starting the database.

Use the REOPEN attribute of the LOG_ARCHIVE_DEST_n parameter to determine whether and when ARCn attempts to re-archive to a failed destination following an error. REOPEN applies to all errors, not just OPEN errors. REOPEN=n sets the minimum number of seconds before ARCn should try to reopen a failed destination. The default value for n is 300 seconds. A value of 0 is the same as turning off the REOPEN option, in other words, ARCn will not attempt to archive after a failure. If you do not specify the REOPEN keyword, ARCn will never reopen a destination following an error.