ST03 or ST03N does not display data

Posted by Faisal Thursday, November 18, 2010 11:08 AM 0 comments
Labels: , , , , ,

In transaction ST03 or ST03N, the system does not recalculate or display any weekly workload data.


Cause:This problem occurs as of February 22, 2010 (22.02.2010).

Particularly for the weekly workload data, the entries in the key field SRTFD in the table MONI are created so that the last four digits are reserved for the consecutive week number, starting with December 24, 1990 (24.12.1990).

correction: Implement SAP note:1443908

Understanding or Administration CRON JOB

Posted by Faisal 10:59 AM 0 comments
Labels: , , , , , , ,

Crontab – Quick Reference

Setting up cron jobs in Unix and Solaris

cron is a unix, solaris utility that allows tasks to be automatically run in the background at regular intervals by the cron daemon. These tasks are often termed as cron jobs in unix , solaris. Crontab (CRON TABle) is a file which contains the schedule of cron entries to be run and at specified times.


Crontab Commands
export EDITOR=vi ;to specify a editor to open crontab file.
crontab -e Edit your crontab file, or create one if it doesn’t already exist.
crontab -l Display your crontab file.
crontab -r Remove your crontab file.
crontab -v Display the last time you edited your crontab file. (This option is only available on a few systems.)

Crontab syntax :

A crontab file has five fields for specifying day , date and time followed by the command to be run at that interval.

*     *     *   *    *        command to be executed
-     -     -   -    -
|     |     |   |    |
|     |     |   |    +----- day of week (0 - 6) (Sunday=0)
|     |     |   +------- month (1 - 12)
|     |     +--------- day of        month (1 - 31)
|     +----------- hour (0 - 23)
+------------- min (0 - 59)

* in the value field above means all legal values as in braces for that column.
The value column can have a * or a list of elements separated by commas. An element is either a number in the ranges shown above or two numbers in the range separated by a hyphen (meaning an inclusive range).

Important linux directories configuration files and block devices

Posted by taqitaha Monday, April 19, 2010 3:28 PM 1 comments
Labels: , , , , ,

Before we move on to learning commands used in Linux. Let us walk through the important Linux Directories, Configuration files and block devices in Linux.
It is important that we understand the file system in linux and also have a basic knowledge about where the programs reside in the machine, where to look for what and how to make it easy for ourselves when working on a Linux machine.


$HOME/.bash_profile - bash system wide and per user init files
$HOME/.bashrc - bash system wide and per user init files
/ - The root of the filesystem, all other files and directories use this as a starting point.
/bin/ - Binaries Directory--contains common executables for system operation, and cannot contain subdirectories in order to comply with HFS conventions. This is a STANDARD directory.
/boot/ - Directory containing pertinent boot information and executables, such as the kernel, and initrd, grub.conf. Must be within 1024 cylinders from the start of the physical disk.
/dev/ - Devices Directory. This is a STANDARD Directory.
/dev/fd0 - Block device that refers to the first floppy drive.
/dev/lp0 - Block device that refers to the first parallel port (ie LPT1 in DOS/Windows).
/etc/ - Configuration Files Directory. This is a STANDARD Directory.
/etc/auto.master - auto mount master file.
/etc/bash.bashrc - Shell variables. Executes right after /etc/profile and /etc/profile.local on login. Executes upon opening every new shell./etc/bash.bashrc contains: - $PS1 - User command prompt - ALIAS - Aliases - Link to /etc/bash.bashrc.local NOTE: Any changes should NOT be done in this file, but rather in the /etc/bash.bashrc.local file.
/etc/bash.bashrc.local - Overrides /etc/bash.bashrc Changes should ONLY be made in THIS file instead of in the /etc/bash.bashrc file.
/etc/bashrc - bash system wide and per user init files.
/etc/cron.* - There are 4 directories that automatically execute all scripts within the directory at intervals of hour, day, week or month
/etc/default - Default for certain commands.
/etc/exports - NFS server export list.
/etc/fstab - List of block devices and their associated mount points and mount options.
/etc/ftpusers - User names excluded from the default operational mode of the ftp server. Ie. If all users are denied then these are all of the users who are allowed, and if all users are allowed then these are those who are disallowed.
/etc/group - Group listing, passwords, and member lists.
/etc/host.allow - TCP wrapper host control files, allows these systems to connect.
/etc/host.conf - host name information look up order
/etc/host.deny - TCP wrapper host control file denies listed systems from connecting.
/etc/HOSTNAME - Full hostname including domain
/etc/hosts - A list of all known host names and IP addresses
/etc/hosts.equiv - Host list of computers that are trusted to use rsh (remote shell).
/etc/hosts.lpd - Host list of computers that are trusted to send lpr commands to this system.
/etc/httpd/conf/ - Directory for Apache Web Server configuration
/etc/init.d/ - Directory containing runlevel scripts for system startup
/etc/inittab - Control file that determines how the system boots
/etc/inittab - Control file that determines how the system boots.
/etc/lilo.conf - LInux Loader configuration that specifies boot options, kernels, and other boot parameters. NOTE: Lilo must be re-run after changes are made to lilo.conf
/etc/lpd.conf - Line Printer Daemon configuration file
/etc/lpd.perms - Line Printer Daemon permissions configuration file
/etc/motd - Message of the Day broadcast to all users on login
/etc/networks - File that contains network ranges and their associated names
/etc/nsswitch.conf - Configuration file that defines the order in which lookup of hostnames/dns names occurs
/etc/passwd - File that has information that defines user accounts on the server, their shell, UID, default group, home directory, and either a hash for their password or a marker indicating that it is in the shadow password file.
/etc/printcap.local - Printer database, changes should be made here as /etc/printcap is regenerated each time the daemon loads. This file is not used nor referenced with a CUPS solution.
/etc/profile - Sets up shell variables that are global for everyone. Loaded right after login. Executes once only at login.
/etc/profile.local - Changes to your global variables should be made here.
/etc/protocols - This file contains protocol IDs and their names. Useful for determining network traffic problems.
/etc/rc.d/init.d/lpd - [option] should be replaced with start - Starts the print daemon, status - Displays the status of the print daemon, stop - Stops the print daemon
/etc/rc.d/rc.inet1 - IP address, Network mask, Default gateway are in these files. May edit manually to modify network parameters.
/etc/rc.d/rc.local - Bash script that is executed at the end of login process - like autoexec.bat in DOS
/etc/resolv.conf - Defines IP addresses of DNS servers
/etc/rpc - RPC service name to their program numbers mapping.
/etc/services - TCP/IP services and ports mapping.
/etc/shadow - Read-only to Root access processes, used to avoid theft of user passwords.
/etc/shells - The /etc/shells file serves as the list of valid shells that may be loaded.
/etc/skel/ - Template folder that contains files - for new users.
/etc/smb.conf - Configuration for the SAMBA server to allow file and print sharing with Windows clients
/etc/sysconfig/ - A directory containing system configuration files.
/etc/sysconfig/network - The networking configuration file, specifies network interfaces, IP addresses, and other protocols.
/etc/X11/XF86Config - Configuration file for XFree86's X Server
/home/ - The mountpoint or directory where user's personal data is stored. This is an OPTIONAL directory.
/lib/ - Library Files Directory. This is a STANDARD Directory.
/mnt/ - Mount Point Directory. This is a STANDARD Directory.
/opt/ - Optional Directory. This is a STANDARD Directory.
/proc/ - Kernel Process Information Directory. This is an OPTIONAL Directory.
/proc/interrupts - Contains which interrupts are in use and which are available.
/proc/ioports - Contains which I/O addresses are in use and which are available.
/proc/pci - Lists which PCI devices are already installed and their I/O addresses and interrupts.
/root/ - Root User's Home Directory. This is an OPTIONAL Directory.
/sbin/ - System Binaries Directory. This is a STANDARD Directory.
/srv/ - This directory is used for services' runtimes and working files. This is an OPTIONAL Directory.
/tmp/ - Temporary Director. This is a STANDARD Directory.
/usr/ - This directory is used as a system resource. Many times, libraries, applications, and source code are installed in this folder. Kernel compiling usually takes place in the /usr/src/linux/ subdirectory. This is a STANDARD directory.
/var/ - Logfiles are generally stored in the /var directory or log subdirectory. Variable data from applications and some binaries are installed here. This is a STANDARD directory.
~/.Xdefaults - Defines some parameters for X-Windows (~ refers to user's Home Directory)
~/.xinitrc - Defines windows manager loaded by X-Windows (~ refers to user's Home Directory) X Window Keystrokes : - ctrl+alt+backspace - Stop X server (some systems use ctrl+alt+esc) - ctrl+alt+F1 - Switch to text mode console 1, ctrl+alt+F7 - Switch back to graphic mode

To Change Oracle database archive log mode

Posted by Faisal 8:14 AM 0 comments
Labels: , , , , , ,

To Change Oracle database archive log mode

To check archive log mode of Oracle Database trigger the following command
in SQL Prompt.

SQL> select log_mode from v$database;

1) Turn Archive Log Mode ON:

Login to Database host
SQL> sqlplus "/as sysdba"
SQL> shutdown immediate
SQL> startup mount
SQL> alter database archivelog;
SQL> alter database open;

2) Turning OFF Archive Log Mode:

SQL> shutdown immediate
SQL> startup mount;
SQL> alter database noarchivelog;
SQL> alter database open;

History of Linux

Posted by taqitaha Sunday, April 18, 2010 3:51 PM 0 comments
Labels: , , , ,

It all began in 1991 when a Finnish student, Linus Torvalds started working on a personal project and required posix standard definition which led to the creation of a new operating system kernal. Since then the Linux Kernal has been constantly updated and improved to meet the never ending requirements of the world. Since the initial release of its source code in 1991, it has grown from a small number of C files under a license prohibiting commercial distribution to its state in 2009 of over 370 megabytes of source under the GNU General Public License.


The Unix operating system was implemented in the 1960s and first released in 1970. Its availability and portability caused it to be widely adopted, copied and modified by academic institutions and businesses. Its design became influential to authors of other systems.

The GNU project was started in 1983 by Richard Stallman with the goal of creating a free UNIX-like operating system. He wrote the GNU General Public License (GPL) as part of his work. There was almost enough available software by the early 1990s to create a full operating system but since the GNU kernel, called Hurd, failed to attract enough attention from developers, GNU was left incomplete.

Another free operating system project in the 1980s was the Berkeley Software Distribution (BSD). This was developed by UC Berkeley from the 6th edition of Unix from AT&T. Since BSD contained Unix code that AT&T owned, AT&T filed a lawsuit in the early 1990s against the University of California. This strongly limited the development and adoption of BSD.

MINIX, a Unix-like system intended for academic use, was released by Andrew S. Tanenbaum in 1987. While source code for the system was available, modification and redistribution were restricted. In addition, MINIX's 16-bit design was not well adapted to the 32-bit features of the increasingly cheap and popular Intel 386 architecture for personal computers.

These factors and the lack of a widely-adopted, free kernel provided the impetus for Torvalds's starting his project. He has stated that if either the GNU or 386BSD kernels were available at the time, he likely would not have written his own.


Error duing JAVA Import in Dual Stack SAP System Copy

Posted by Faisal Friday, April 16, 2010 7:55 AM 2 comments
Labels: , , , , ,

While doing ABAP + JAVA System Copy Following Error occurred:
FJS-00003 TypeError: sourceProps.get ("src.ci.host") has no properties

Solution:
Copy the SOURCE.PROPERTIES from the Central Instance export
to the Java export DVD or add the property src.id.host to the
SOURCE.PROPERTIES file using the value created by the Central
Instance export.

Here I went to the location of JAVA Dump and opened SOURCE.PROPERTIES file
Added src.ci.host=

SAP Note 1238351 explains this issue in more detail.

ORA-12560: TNS:protocol adapter error

Posted by Faisal Wednesday, April 14, 2010 9:23 AM 0 comments
Labels: , , , , ,

ORA-12560: TNS:protocol adapter error while connecting to Oracle Database through SQL Prompt

Possible reasons why you are facing the error:

1) Oracle Service has not yet started
Check:

Start Run --> Services.msc --> search for oracleservice --> Right click and start if it is stopped

2) Check if ORACLE_SID environmental variable is set and value has correct Database SID.

Right click on My computer --> Properties --> Advanced --> Environmental Variables --> Search for ORACLE_SID in User Variables for current user

3) Check parameter SQLNET.AUTHENTICATION_SERVICES value is set to NTS in sqlnet.ora

4) Check if TNS_ADMIN environmental variable is set on Database host and pointing to right directory. This should be pointing to drive:\ORACLE_HOME\network\admin

5) Check if listener is up and running. This is again in windows services or you can type the following command in command prompt for status

lsnrctl status

If you find listener is not running then type the following command

lsnrctl start

Subscribe to: Posts (Atom)